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