Merhaba,
bulduğum örneklere göre kodum biraz karışık olduğu için uygulayamadım * from şeklinde select atmak mantığı oturmadı view dan veri girerek db ye insert atarken EMail zaten varsa hata vermesini nasıl ayarlayabilirim
view ve model ı ekledim resim olarak
`
using Microsoft.AspNetCore.Mvc;
using System.Data.SqlClient;
using WebProgrammingFinal.Models;
namespace WebProgrammingFinal.Controllers
{
public class UlasimController : Controller
{
public ActionResult Gorusme()
{
return View(new Ulasim() { Name = "Ertürk", Surname = "Erdağı" });
}
[HttpPost]
public ActionResult Gorusme(Ulasim Gorusme)
{
using (SqlConnection con = new SqlConnection("Server=(localdb)\BATU;Database=DBFINAL;Trusted_Connection=True;MultipleActiveResultSets=true"))
{
string query = "INSERT INTO Ulasim(Name, Surname, EMail, PhoneNumber, Message) VALUES(@Name, @Surname, @EMail, @PhoneNumber, @Message)";
//query += " SELECT SCOPE_IDENTITY()";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
cmd.Parameters.AddWithValue("@Name", Gorusme.Name);
cmd.Parameters.AddWithValue("@Surname", Gorusme.Surname);
cmd.Parameters.AddWithValue("@EMail", Gorusme.EMail);
cmd.Parameters.AddWithValue("@PhoneNumber", Gorusme.PhoneNumber);
cmd.Parameters.AddWithValue("@Message", Gorusme.Message);
int sonuc = cmd.ExecuteNonQuery();
con.Close();
}
}
return View(Gorusme);
}
}
}
`