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