public bool ExecuteCresteStocProcedure(ProdusDeUpdatatInStocModel PDUModel)
{
bool retVal;
try
{
using (SqlCommand SqlCommand_SC = new SqlCommand("CrestereStocProc", DataBaseConnection_SqlCOnnection))
{
SqlCommand_SC.CommandType = CommandType.StoredProcedure;
SqlCommand_SC.Parameters.AddWithValue("@inputidprodus", PDUModel.IdProdus);
SqlCommand_SC.Parameters.AddWithValue("@inputcantitate", PDUModel.Cantitate);
DataBaseConnection_SqlCOnnection.Open();
SqlCommand_SC.ExecuteNonQuery();
DataBaseConnection_SqlCOnnection.Close();
retVal = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
retVal = false;
}
return(retVal);
}
private List <ProdusDeUpdatatInStocModel> GetProduseDeUpdatatInStoc(DataTable DT)
{
List <ProdusDeUpdatatInStocModel> localProdusedeUpdatatInStoc = new List <ProdusDeUpdatatInStocModel>();
foreach (DataRow row in DT.Rows)
{
ProdusDeUpdatatInStocModel local_ProdusDeUpdatatInStoc = new ProdusDeUpdatatInStocModel(Convert.ToInt32(row["IdProdus"].ToString()), Convert.ToInt32(row["Cantitate"].ToString()));
localProdusedeUpdatatInStoc.Add(local_ProdusDeUpdatatInStoc);
}
return(localProdusedeUpdatatInStoc);
}
private void CresteCantitatiStoc(DataTable inputDT)
{
foreach (DataRow row in inputDT.Rows)
{
ProdusDeUpdatatInStocModel local_ProdusDeUpdatatInStoc = new ProdusDeUpdatatInStocModel(Convert.ToInt32(row["IdProdus"].ToString()), Convert.ToInt32(row["Cantitate"].ToString()));
ProdusedeUpdatatInStoc_List.Add(local_ProdusDeUpdatatInStoc);
}
foreach (ProdusDeUpdatatInStocModel PDU in ProdusedeUpdatatInStoc_List)
{
if (Service.ExecuteCresteStocProcedure(PDU))
{
View.CresteStocSuccessfull(PDU);
}
else
{
View.CresteStocFailed();
}
}
ProdusedeUpdatatInStoc_List.Clear();
}
