public void GetStandardizationProductsAddedDetails(int RMRId)
{
DataSet DS = new DataSet();
bstdpdata = new BStandardizationProductsAdded();
DS = bstdpdata.GetStandardizationProductsAddedDetailsById(RMRId);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["QualityDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["QualityDate"].ToString();
//sky
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"));
}
txtBatchNo.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["BatchNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["BatchNo"].ToString();
dpShiftDetails.ClearSelection();
string Shift = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["QualityShiftId"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["QualityShiftId"].ToString();
if (Shift == "")
{
dpShiftDetails.SelectedIndex = 0;
}
else
{
//dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["StandardizationProductsAddedShiftId"]).ToString()) != null)
dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["QualityShiftId"]).ToString()).Selected = true;
}
txtMilkType.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TypeOfMilk"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TypeOfMilk"].ToString();
txtSMPQuantity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SMPQuantity"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SMPQuantity"].ToString();
txtCreamkg.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Creamkg"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Creamkg"].ToString();
txtWaterliters.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Waterliters"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Waterliters"].ToString();
txtCondensedMilk.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CondensedMilk"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CondensedMilk"].ToString();
txtButterOil.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ButterOil"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["ButterOil"].ToString();
txtSkimmedMilk.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SkimmedMilk"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SkimmedMilk"].ToString();
txtOthers.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Others"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Others"].ToString();
dpStdAddDone.ClearSelection();
try
{
if (Convert.ToInt32(DS.Tables[0].Rows[0]["StdStatusId"]).ToString() != "")
{
dpStdAddDone.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["StdStatusId"]).ToString()).Selected = true;
}
}
catch (InvalidCastException)
{
dpStdAddDone.SelectedIndex = 2;
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
{
mstdpdata = new MStandardizationProductsAdded();
bstdpdata = new BStandardizationProductsAdded();
int Result = 0;
mstdpdata.StandardizationProductsAddedId = 0;
mstdpdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mstdpdata.StandardizationProductsAddedDate = Convert.ToDateTime(txtDate.Text.ToString());
mstdpdata.StandardizationProductsAddedShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mstdpdata.MilkType = string.IsNullOrEmpty(txtMilkType.Text) ? string.Empty : txtMilkType.Text;
mstdpdata.SMPQuantity = string.IsNullOrEmpty(txtSMPQuantity.Text) ? 0 : Convert.ToDouble(txtSMPQuantity.Text);
mstdpdata.Creamkg = string.IsNullOrEmpty(txtCreamkg.Text) ? 0 : Convert.ToDouble(txtCreamkg.Text);
mstdpdata.Waterliters = string.IsNullOrEmpty(txtWaterliters.Text) ? 0 : Convert.ToDouble(txtWaterliters.Text);
mstdpdata.CondensedMilk = string.IsNullOrEmpty(txtCondensedMilk.Text) ? 0 : Convert.ToDouble(txtCondensedMilk.Text);
mstdpdata.ButterOil = string.IsNullOrEmpty(txtButterOil.Text) ? 0 : Convert.ToDouble(txtButterOil.Text);
mstdpdata.SkimmedMilk = string.IsNullOrEmpty(txtSkimmedMilk.Text) ? 0 : Convert.ToDouble(txtSkimmedMilk.Text);
mstdpdata.Others = string.IsNullOrEmpty(txtOthers.Text) ? string.Empty : txtOthers.Text;
mstdpdata.StdStatusId = Convert.ToInt32(dpStdAddDone.SelectedItem.Value);
mstdpdata.flag = "Insert";
Result = bstdpdata.stdpdata(mstdpdata);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Standardization Products Added Data Add Successfully";
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
pnlError.Update();
//string dates;
//dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtDate.Text);
GetStandardizationProductsAddedDetails(R);
uprouteList.Update();
ClearFields();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
//return Result;
}
}
public void GetStandardizationProductsAddedDetails(string dates)
{
bstdpdata = new BStandardizationProductsAdded();
DataSet DS = new DataSet();
DS = bstdpdata.GetStandardizationProductsAddedDetails(dates);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpStandardizationProductsAdded.DataSource = DS;
rpStandardizationProductsAdded.DataBind();
}
else
{
DS.Clear();
rpStandardizationProductsAdded.DataSource = DS;
rpStandardizationProductsAdded.DataBind();
}
}
public void GetStandardizationProductsAddedDetails(RMRecieve R)
{
bstdpdata = new BStandardizationProductsAdded();
DataSet DS = new DataSet();
DS = bstdpdata.GetStandardizationProductsAddedDetails(R);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpStandardizationProductsAdded.DataSource = DS;
rpStandardizationProductsAdded.DataBind();
}
else if (DS.Tables[0].Rows.Count == 0)
{
rpStandardizationProductsAdded.DataSource = DS;
rpStandardizationProductsAdded.DataBind();
//this.BindRepeater(dt);
}
}