protected void btnUpdateProductindetail_Click(object sender, EventArgs e)
{
stdmdata = new MStandardization();
stdbdata = new BStandardization();
int Result = 0;
stdmdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
stdmdata.StandardDate = DateTime.Now.ToString();
stdmdata.StdShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
stdmdata.SiloNo = string.IsNullOrEmpty(txtSiloNo.Text) ? string.Empty : txtSiloNo.Text;
stdmdata.RCMQuantity = string.IsNullOrEmpty(txtRCMQty.Text) ? 0 : Convert.ToDouble(txtRCMQty.Text);
stdmdata.StandardizationStartTime = txtStandardizationStartTime.Text;
stdmdata.StandardizationEndTime = txtStandardizationEndTime.Text;
stdmdata.CuttingMilkQuantity = string.IsNullOrEmpty(txtCuttingMilkQuantity.Text) ? 0 : Convert.ToDouble(txtCuttingMilkQuantity.Text);
stdmdata.CuttingMilkFAT = string.IsNullOrEmpty(txtCuttingMilkFat.Text) ? 0 : Convert.ToDouble(txtCuttingMilkFat.Text);
stdmdata.CuttingMilkSNF = string.IsNullOrEmpty(txtCuttingMilkSnf.Text) ? 0 : Convert.ToDouble(txtCuttingMilkSnf.Text);
stdmdata.Skim = string.IsNullOrEmpty(txtSkim.Text) ? 0 : Convert.ToDouble(txtSkim.Text);
stdmdata.SkimFAT = string.IsNullOrEmpty(txtSkimFat.Text) ? 0 : Convert.ToDouble(txtSkimFat.Text);
stdmdata.SkimSNF = string.IsNullOrEmpty(txtSkimSnf.Text) ? 0 : Convert.ToDouble(txtSkimSnf.Text);
stdmdata.RCM = string.IsNullOrEmpty(txtRcm.Text) ? 0 : Convert.ToDouble(txtRcm.Text);
stdmdata.SMP = string.IsNullOrEmpty(txtRcm.Text) ? 0 : Convert.ToDouble(txtRcm.Text);
stdmdata.CreamAdd = string.IsNullOrEmpty(txtCreamAdd.Text) ? 0 : Convert.ToDouble(txtCreamAdd.Text);
stdmdata.CreamProduced = string.IsNullOrEmpty(txtCreamAdd.Text) ? 0 : Convert.ToDouble(txtCreamAdd.Text);
stdmdata.Remarks = txtRemarks.Text;
stdmdata.StandardizationStatusId = Convert.ToInt32(dpStandardDone.SelectedItem.Value);
//stdmdata.Custom1 = txtCustom1.Text;
//stdmdata.Custom2 = txtCustom2.Text;
//stdmdata.Custom3 = txtCustom3.Text;
//stdmdata.Custom4 = txtCustom4.Text;
//stdmdata.Custom5 = txtCustom5.Text;
stdmdata.flag = "Update";
Result = stdbdata.StandardizationData(stdmdata);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Data Updated 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(txtSearchDate.Text);
GetStandardizationDetails(R);
uprouteList.Update();
// ClearTextbox();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
}
public int StandardizationData(MStandardization recieve)
{
dastd = new DAStandardization();
int Result = 0;
try
{
Result = dastd.StdData(recieve);
}
catch (Exception)
{
throw;
}
return(Result);
}
public int StdData(MStandardization std)
{
int result = 0;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@RMRId", std.RMRId));
paramCollection.Add(new DBParameter("@QualityId", std.QualityId));
paramCollection.Add(new DBParameter("@StdDate", std.StandardDate));
paramCollection.Add(new DBParameter("@StdShiftId", std.StdShiftId));
paramCollection.Add(new DBParameter("@SiloNo", std.SiloNo));
paramCollection.Add(new DBParameter("@RCMQuantity", std.RCMQuantity));
paramCollection.Add(new DBParameter("@StdStartTime", std.StandardizationStartTime));
paramCollection.Add(new DBParameter("@StdEndTime", std.StandardizationEndTime));
paramCollection.Add(new DBParameter("@CuttingMilkQuantity", std.CuttingMilkQuantity));
paramCollection.Add(new DBParameter("@CuttingMilkFat", std.CuttingMilkFAT));
paramCollection.Add(new DBParameter("@CuttingMilkSNF", std.CuttingMilkSNF));
paramCollection.Add(new DBParameter("@Skim", std.Skim));
//paramCollection.Add(new DBParameter("@Qty", std.Qty));
paramCollection.Add(new DBParameter("@SkimFAT", std.SkimFAT));
paramCollection.Add(new DBParameter("@SkimSNF", std.SkimSNF));
paramCollection.Add(new DBParameter("@RCM", std.RCM));
paramCollection.Add(new DBParameter("@SMP", std.SMP));
paramCollection.Add(new DBParameter("@CreamAdd", std.CreamAdd));
paramCollection.Add(new DBParameter("@CreamProduced", std.CreamProduced));
paramCollection.Add(new DBParameter("@StandardizationStatusId", std.StandardizationStatusId));
//paramCollection.Add(new DBParameter("@TotalQuantity", std.TotalQuantity));
//paramCollection.Add(new DBParameter("@TypeOfMilk", std.TypeOfMilk));
paramCollection.Add(new DBParameter("@Remarks", std.Remarks));
//paramCollection.Add(new DBParameter("@Custom1", std.Custom1));
//paramCollection.Add(new DBParameter("@Custom2", std.Custom2));
//paramCollection.Add(new DBParameter("@Custom3", std.Custom3));
//paramCollection.Add(new DBParameter("@Custom4", std.Custom4));
//paramCollection.Add(new DBParameter("@Custom5", std.Custom5));
paramCollection.Add(new DBParameter("@flag", std.flag));
result = _DBHelper.ExecuteNonQuery("sp_Prod_Standardization", paramCollection, CommandType.StoredProcedure);
}
catch (Exception EX)
{
string MSG = EX.ToString();
}
return(result);
}
protected void btnAddProductionInfo_Click(object sender, EventArgs e)
{
stdmdata = new MStandardization();
stdbdata = new BStandardization();
int Result = 0;
stdmdata.StdId = 0;
stdmdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
foreach (RepeaterItem item in rpStandardizationList.Items)
{
HiddenField hdfID = item.FindControl("hfQualityId") as HiddenField;
if (hdfID != null)
{
stdmdata.QualityId = string.IsNullOrEmpty(hdfID.Value) ? 0 : Convert.ToInt32(hdfID.Value);
}
}
stdmdata.StandardDate = DateTime.Now.ToString();
stdmdata.StdShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
stdmdata.SiloNo = string.IsNullOrEmpty(txtSiloNo.Text) ? string.Empty : txtSiloNo.Text;
stdmdata.RCMQuantity = string.IsNullOrEmpty(txtRCMQty.Text) ? 0 : Convert.ToDouble(txtRCMQty.Text);
stdmdata.StandardizationStartTime = string.IsNullOrEmpty(txtStandardizationStartTime.Text) ? string.Empty : txtStandardizationStartTime.Text;
stdmdata.StandardizationEndTime = string.IsNullOrEmpty(txtStandardizationEndTime.Text) ? string.Empty : txtStandardizationEndTime.Text;
stdmdata.CuttingMilkQuantity = string.IsNullOrEmpty(txtCuttingMilkQuantity.Text) ? 0 : Convert.ToDouble(txtCuttingMilkQuantity.Text);
stdmdata.CuttingMilkFAT = string.IsNullOrEmpty(txtCuttingMilkFat.Text) ? 0 : Convert.ToDouble(txtCuttingMilkFat.Text);
stdmdata.CuttingMilkSNF = string.IsNullOrEmpty(txtCuttingMilkSnf.Text) ? 0 : Convert.ToDouble(txtCuttingMilkSnf.Text);
stdmdata.Skim = string.IsNullOrEmpty(txtSkim.Text) ? 0 : Convert.ToDouble(txtSkim.Text);
stdmdata.SkimFAT = string.IsNullOrEmpty(txtSkimFat.Text) ? 0 : Convert.ToDouble(txtSkimFat.Text);
stdmdata.SkimSNF = string.IsNullOrEmpty(txtSkimSnf.Text) ? 0 : Convert.ToDouble(txtSkimSnf.Text);
stdmdata.RCM = string.IsNullOrEmpty(txtRcm.Text) ? 0 : Convert.ToDouble(txtRcm.Text);
stdmdata.SMP = string.IsNullOrEmpty(txtRcm.Text) ? 0 : Convert.ToDouble(txtRcm.Text);
stdmdata.CreamAdd = string.IsNullOrEmpty(txtCreamAdd.Text) ? 0 : Convert.ToDouble(txtCreamAdd.Text);
stdmdata.CreamProduced = string.IsNullOrEmpty(txtCreamAdd.Text) ? 0 : Convert.ToDouble(txtCreamAdd.Text);
//stdmdata.TotalQuantity = string.IsNullOrEmpty(txtTotalQuantity.Text) ? 0 : Convert.ToDouble(txtTotalQuantity.Text);
//stdmdata.TypeOfMilk = string.IsNullOrEmpty(txtTypeOfMilk.Text) ? string.Empty : txtTypeOfMilk.Text;
stdmdata.Remarks = string.IsNullOrEmpty(txtRemarks.Text) ? string.Empty : txtRemarks.Text;
stdmdata.StandardizationStatusId = Convert.ToInt32(dpStandardDone.SelectedItem.Value);
stdmdata.flag = "Insert";
Result = stdbdata.StandardizationData(stdmdata);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Data Added 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");
GetStandardizationDetails(dates);
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
//return Result;
}
