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"));
}
