public int closingstockdata(MClosingStockForMilkInSiloAndAllProducts receive) { int result = 0; try { DBParameterCollection paramcollection = new DBParameterCollection(); paramcollection.Add(new DBParameter("@RMRId", receive.RMRId)); paramcollection.Add(new DBParameter("@ClosingStockForMilkInSiloAndAllProductsId", receive.ClosingStockForMilkInSiloAndAllProductsId)); paramcollection.Add(new DBParameter("@ClosingStockForMilkInSiloAndAllProductsDate", receive.ClosingStockForMilkInSiloAndAllProductsDate)); paramcollection.Add(new DBParameter("@ClosingStockForMilkInSiloAndAllProductsShiftId", receive.ClosingStockForMilkInSiloAndAllProductsShiftId)); paramcollection.Add(new DBParameter("@SiloNo", receive.SiloNo)); paramcollection.Add(new DBParameter("@MilkType", receive.MilkType)); paramcollection.Add(new DBParameter("@Quantity", receive.Quantity)); paramcollection.Add(new DBParameter("@FAT", receive.FAT)); paramcollection.Add(new DBParameter("@SNF", receive.SNF)); paramcollection.Add(new DBParameter("@CLR", receive.CLR)); paramcollection.Add(new DBParameter("@Temperature", receive.Temperature)); paramcollection.Add(new DBParameter("@Acidity", receive.Acidity)); paramcollection.Add(new DBParameter("@MBRT", receive.MBRT)); paramcollection.Add(new DBParameter("@HomoEfficiency", receive.HomoEfficiency)); paramcollection.Add(new DBParameter("@Remarks", receive.Remarks)); paramcollection.Add(new DBParameter("@ClosingStockForMilkInSiloAndAllProductsStatus", receive.ClosingStockForMilkInSiloAndAllProductsStatus)); paramcollection.Add(new DBParameter("@flag", receive.flag)); result = _DBHelper.ExecuteNonQuery("prod_spClosingStockForMilkInSiloAndAllProductsDetails ", paramcollection, CommandType.StoredProcedure); } catch (Exception EX) { String MSG = EX.ToString(); } return(result); }
public int closingstockdata(MClosingStockForMilkInSiloAndAllProducts receive) { dacsfmaap = new DAClosingStockForMilkInSiloAndAllProducts(); int Result = 0; try { Result = dacsfmaap.closingstockdata(receive); } catch (Exception) { throw; } return(Result); }
protected void btnAdd_Click(object sender, EventArgs e) { { mcsfmaap = new MClosingStockForMilkInSiloAndAllProducts(); bcsfmaap = new BClosingStockForMilkInSiloAndAllProducts(); int Result = 0; mcsfmaap.ClosingStockForMilkInSiloAndAllProductsId = 0; mcsfmaap.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value); mcsfmaap.ClosingStockForMilkInSiloAndAllProductsDate = Convert.ToDateTime(txtDate.Text.ToString()); mcsfmaap.ClosingStockForMilkInSiloAndAllProductsShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); mcsfmaap.SiloNo = string.IsNullOrEmpty(txtSiloNo.Text) ? 0 : Convert.ToInt32(txtSiloNo.Text); mcsfmaap.MilkType = txtMilkType.Text; mcsfmaap.Quantity = string.IsNullOrEmpty(txtQuantity.Text) ? 0 : Convert.ToDouble(txtQuantity.Text); mcsfmaap.FAT = string.IsNullOrEmpty(txtFAT.Text) ? 0 : Convert.ToDouble(txtFAT.Text); mcsfmaap.SNF = string.IsNullOrEmpty(txtSNF.Text) ? 0 : Convert.ToDouble(txtSNF.Text); mcsfmaap.CLR = string.IsNullOrEmpty(txtCLR.Text) ? 0 : Convert.ToDouble(txtCLR.Text); mcsfmaap.Temperature = string.IsNullOrEmpty(txtTemperature.Text) ? 0 : Convert.ToDouble(txtTemperature.Text); mcsfmaap.Acidity = string.IsNullOrEmpty(txtAcidity.Text) ? 0 : Convert.ToDouble(txtAcidity.Text); mcsfmaap.MBRT = string.IsNullOrEmpty(txtMBRT.Text) ? 0 : Convert.ToDouble(txtMBRT.Text); mcsfmaap.HomoEfficiency = string.IsNullOrEmpty(txtHomoEfficiency.Text) ? 0 : Convert.ToDouble(txtHomoEfficiency.Text); mcsfmaap.Remarks = txtRemarks.Text; mcsfmaap.ClosingStockForMilkInSiloAndAllProductsStatus = Convert.ToInt32(dpStatusDetails.SelectedItem.Value); mcsfmaap.flag = "Insert"; Result = bcsfmaap.closingstockdata(mcsfmaap); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Closing Stock For Milk In Silo And All Products Data Add Successfully"; pnlError.Update(); // GetPastDetails(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblSuccess.Text = "Something went wrong plz contact site admin"; pnlError.Update(); } //return Result; } }