internal void AddPreparat(Preparate preparat)
{
if (String.IsNullOrEmpty(preparat.Denumire))
{
return;
}
preparateDAL.AddPreparat(preparat);
//UserList.Add(user);
}
internal void DeletePreparat(Preparate preparat)
{
using (SqlConnection connection = DALHelper.Connection)
{
SqlCommand cmd = new SqlCommand("spPreparate_Delete", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramDenumire = new SqlParameter("@Denumire", preparat.Denumire);
cmd.Parameters.Add(paramDenumire);
connection.Open();
cmd.ExecuteNonQuery();
}
}
internal void AddPreparatComandat(Comenzi comanda, Preparate preparat, int cantitate)
{
using (SqlConnection connection = DALHelper.Connection)
{
SqlCommand cmd = new SqlCommand("spPreparateComandate_Insert", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramComandaId = new SqlParameter("ComandaId", comanda.ComandaId);
SqlParameter paramPreparatId = new SqlParameter("PreparatId", preparat.Id);
SqlParameter paramCantitate = new SqlParameter("Cantitate", cantitate);
cmd.Parameters.Add(paramComandaId);
cmd.Parameters.Add(paramPreparatId);
cmd.Parameters.Add(paramCantitate);
connection.Open();
cmd.ExecuteNonQuery();
}
}
internal void AddPreparat(Preparate preparat)
{
using (SqlConnection connection = DALHelper.Connection)
{
SqlCommand cmd = new SqlCommand("spPreparate_Insert", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramDenumire = new SqlParameter("@Denumire", preparat.Denumire);
SqlParameter paramPret = new SqlParameter("@Pret", preparat.Pret);
SqlParameter paramCantitate = new SqlParameter("Cantitate", preparat.Cantitate);
SqlParameter paramCantitateTotala = new SqlParameter("CantitateTotala", preparat.CantitateTotala);
SqlParameter paramCategorieId = new SqlParameter("CategorieId", preparat.CategorieId);
cmd.Parameters.Add(paramDenumire);
cmd.Parameters.Add(paramPret);
cmd.Parameters.Add(paramCantitate);
cmd.Parameters.Add(paramCantitateTotala);
cmd.Parameters.Add(paramCategorieId);
connection.Open();
cmd.ExecuteNonQuery();
}
}
internal void DeletePreparat(Preparate preparat)
{
preparateDAL.DeletePreparat(preparat);
}
internal void AddPreparatComandate(Comenzi comanda, Preparate preparat, int cantitate)
{
preparateComandateDAL.AddPreparatComandat(comanda, preparat, cantitate);
//UserList.Add(user);
}
