public static void InsertCOM(COM.Comanda cm) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["Database"])) { connection.Open(); string s = "Insert into Comenzi(IdComanda,Nume,Prenume,AdresaLivrare,NumarTelefon,Email) values (@IdComanda,@Nume,@Prenume,@AdresaLivrare,@NumarTelefon,@Email)"; using (SqlCommand cmd = new SqlCommand(s, connection)) { cmd.Parameters.Add("@IdComanda", SqlDbType.UniqueIdentifier).Value = Guid.NewGuid(); cmd.Parameters.Add("@Nume", SqlDbType.NChar).Value = cm.Nume; cmd.Parameters.Add("@Prenume", SqlDbType.NChar).Value = cm.Prenume; cmd.Parameters.Add("@AdresaLivrare", SqlDbType.NVarChar).Value = cm.AdresaLivrare; cmd.Parameters.Add("@NumarTelefon", SqlDbType.NVarChar).Value = cm.NumarTelefon; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = cm.Email; cmd.ExecuteNonQuery(); } } }
public ActionResult FinCOM(COM.Comanda c) { IO.InsertCOM(c); return(RedirectToAction("FinalizareComanda")); }