public void GetOpeningStockForMilkAndAllProductsDetails(int RMRId) { DataSet DS = new DataSet(); bosfmaap = new BOpeningStockForMilkAndAllProducts(); DS = bosfmaap.GetOpeningStockForMilkAndAllProductsDetailsById(RMRId); if (!Comman.Comman.IsDataSetEmpty(DS)) { string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["OpeningStockForMilkAndAllProductsDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["OpeningStockForMilkAndAllProductsDate"].ToString(); if (DATE == "") { txtDate.Text = Convert.ToString(DateTime.Now.ToString("yyy-MM-dd")); } else { DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat); txtDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd")); } dpShiftDetails.ClearSelection(); string Shift = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["OpeningStockForMilkAndAllProductsShiftId"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["OpeningStockForMilkAndAllProductsShiftId"].ToString(); if (Shift == "") { dpShiftDetails.SelectedIndex = 0; } else { dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["OpeningStockForMilkAndAllProductsShiftId"]).ToString()).Selected = true; } txtBatchNo.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["BatchNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["BatchNo"].ToString(); txtSiloNoForMilk.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SiloNoForMilk"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SiloNoForMilk"].ToString(); txtMilkType.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MilkType"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MilkType"].ToString(); txtQuantity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Quantity"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Quantity"].ToString(); txtFAT.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["FAT"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["FAT"].ToString(); txtSNF.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SNF"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SNF"].ToString(); txtCLR.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CLR"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CLR"].ToString(); txtTemperature.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Temperature"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Temperature"].ToString(); txtAcidity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Acidity"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Acidity"].ToString(); txtMBRT.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MBRT"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MBRT"].ToString(); txtHomoEfficiency.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["HomoEfficiency"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["HomoEfficiency"].ToString(); txtRemarks.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Remarks"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Remarks"].ToString(); dpStatusDetails.ClearSelection(); string Status = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["OpeningStockForMilkAndAllProductsStatus"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["OpeningStockForMilkAndAllProductsStatus"].ToString(); if (Status == "") { dpStatusDetails.SelectedIndex = 0; } else { dpStatusDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["OpeningStockForMilkAndAllProductsStatus"]).ToString()).Selected = true; } } }
public void GetOpeningStockForMilkAndAllProductsDetails() { bosfmaap = new BOpeningStockForMilkAndAllProducts(); DataSet DS = new DataSet(); DS = bosfmaap.GetOpeningStockForMilkAndAllProductsDetails(); if (!Comman.Comman.IsDataSetEmpty(DS)) { rpOpeningStockForMilkAndAll.DataSource = DS; rpOpeningStockForMilkAndAll.DataBind(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { { mosfmaap = new MOpeningStockForMilkAndAllProducts(); bosfmaap = new BOpeningStockForMilkAndAllProducts(); int Result = 0; mosfmaap.OpeningStockForMilkAndAllProductsId = 0; mosfmaap.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value); mosfmaap.OpeningStockForMilkAndAllProductsDate = Convert.ToDateTime(txtDate.Text.ToString()); mosfmaap.OpeningStockForMilkAndAllProductsShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); mosfmaap.SiloNoForMilk = string.IsNullOrEmpty(txtSiloNoForMilk.Text) ? 0 : Convert.ToInt32(txtSiloNoForMilk.Text); mosfmaap.MilkType = txtMilkType.Text; mosfmaap.Quantity = string.IsNullOrEmpty(txtQuantity.Text) ? 0 : Convert.ToDouble(txtQuantity.Text); mosfmaap.FAT = string.IsNullOrEmpty(txtFAT.Text) ? 0 : Convert.ToDouble(txtFAT.Text); mosfmaap.SNF = string.IsNullOrEmpty(txtSNF.Text) ? 0 : Convert.ToDouble(txtSNF.Text); mosfmaap.CLR = string.IsNullOrEmpty(txtCLR.Text) ? 0 : Convert.ToDouble(txtCLR.Text); mosfmaap.Temperature = string.IsNullOrEmpty(txtTemperature.Text) ? 0 : Convert.ToDouble(txtTemperature.Text); mosfmaap.Acidity = string.IsNullOrEmpty(txtAcidity.Text) ? 0 : Convert.ToDouble(txtAcidity.Text); mosfmaap.MBRT = string.IsNullOrEmpty(txtMBRT.Text) ? 0 : Convert.ToDouble(txtMBRT.Text); mosfmaap.HomoEfficiency = string.IsNullOrEmpty(txtHomoEfficiency.Text) ? 0 : Convert.ToDouble(txtHomoEfficiency.Text); mosfmaap.Remarks = txtRemarks.Text; mosfmaap.OpeningStockForMilkAndAllProductsStatus = Convert.ToInt32(dpStatusDetails.SelectedItem.Value); mosfmaap.flag = "Update"; Result = bosfmaap.openingstockdata(mosfmaap); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Opening Stock For Milk And All Products Data Update 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; } }