protected void btnAddRechilling_Click(object sender, EventArgs e)
{
RData = new MRechilling();
BData = new BRechilling();
int Result = 0;
RData.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
foreach (RepeaterItem item in rpRechillingList.Items)
{
HiddenField hdfID2 = item.FindControl("hfQualityId") as HiddenField;
if (hdfID2 != null)
{
RData.QualityId = string.IsNullOrEmpty(hdfID2.Value) ? 0 : Convert.ToInt32(hdfID2.Value);
}
}
RData.BatchNo = string.IsNullOrEmpty(txtBatchNO.Text) ? string.Empty : txtBatchNO.Text;
RData.ShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
RData.Date = Convert.ToDateTime(txtDate.Text.ToString());
RData.SiloNo = Convert.ToInt32(txtSiloNo.Text);
RData.TypeOfMilk = dpTypeOfMilk.SelectedItem.Text;
//string.IsNullOrEmpty(txtTypeOfMilk.Text) ? string.Empty : txtTypeOfMilk.Text;
RData.Quantity = Convert.ToDouble(txtQuantity.Text);
RData.IBTInTemperature = Convert.ToDouble(txtIBTInTemperature.Text);
RData.IBTOutTemperature = Convert.ToDouble(txtIBTOutTemperature.Text);
RData.MilkInTemperature = Convert.ToDouble(txtMilkInTemperature.Text);
RData.MilkOutTemperature = Convert.ToDouble(txtMilkOutTemperature.Text);
RData.RechilledBy = string.IsNullOrEmpty(txtRechilledBy.Text) ? string.Empty : txtRechilledBy.Text;
RData.RechillStatusId = Convert.ToInt32(dpRechillStatus.SelectedItem.Value);
RData.flag = "Insert";
Result = BData.RechillingData(RData);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
//string dates;
//dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetReachlingDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtDate.Text);
GetReachlingDetails(R);
uprouteList.Update();
lblSuccess.Text = "Rechilling Data Add Successfully";
pnlError.Update();
ClearTextbox();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
//return Result;
}
public DataSet GetPasteurizationDetails(RMRecieve R)
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DataAcess.DBParameter("@date", R.RMRDate));
return(_DBHelper.ExecuteDataSet("sp_Prod_GetPasteurizationQCDetails", paramCollection, CommandType.StoredProcedure));
}
public DataSet GetRechillingDetails(RMRecieve R)
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@date", R.RMRDate));
return(_DBHelper.ExecuteDataSet("[sp_Prod_RechillingViewDetails]", paramCollection, CommandType.StoredProcedure));
}
public int RMRData(RMRecieve receive)
{
int result = 0;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@id", receive.RMRId));
paramCollection.Add(new DBParameter("@RMRShiftId", receive.RMRShiftId));
paramCollection.Add(new DBParameter("@RMRDate", receive.RMRDate));
paramCollection.Add(new DBParameter("@TankMilkReciptNo", receive.TankMilkReciptNo));
paramCollection.Add(new DBParameter("@TankerNo", receive.TankerNo));
paramCollection.Add(new DBParameter("@TypeOfMilk", receive.MilkType));
paramCollection.Add(new DBParameter("@Qty", receive.Quantity));
paramCollection.Add(new DBParameter("@CreatedBy", receive.CreatedBy));
paramCollection.Add(new DBParameter("@CreatedDate", receive.CreatedDate));
paramCollection.Add(new DBParameter("@RMRQCStatus", receive.QCId));
paramCollection.Add(new DBParameter("@flag", receive.flag));
result = _DBHelper.ExecuteNonQuery("spProd_RMReceived", paramCollection, CommandType.StoredProcedure);
}
catch (Exception EX)
{
string MSG = EX.ToString();
}
return(result);
}
public DataSet dapackeddata(RMRecieve R)
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DataAcess.DBParameter("@date", R.RMRDate));
return(_DBHelper.ExecuteDataSet("sp_Prod_GetMilkPackedDetails", paramCollection, CommandType.StoredProcedure));
}
public DataSet GetQualityDetails(RMRecieve R)
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@date", R.RMRDate));
return(_DBHelper.ExecuteDataSet("sp_Prod_GetQualityInformation", paramCollection, CommandType.StoredProcedure));
}
public DataSet GetDrainedMilkQCDetails(RMRecieve R)
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@date", R.RMRDate));
return(_DBHelper.ExecuteDataSet("sp_Prod_GetReturnDrainedMilkQCDetails", paramCollection, CommandType.StoredProcedure));
}
public DataSet GetStandardizationProductsAddedDetails(RMRecieve R)
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@date", R.RMRDate));
return(_DBHelper.ExecuteDataSet("sp_Prod_GetStandardizationProductsAddedDetails", paramCollection, CommandType.StoredProcedure));
}
public DataSet GetMilkColdRoomTemperatureDetails(RMRecieve R)
{
DBParameterCollection paramcollection = new DBParameterCollection();
paramcollection.Add(new DBParameter("@date", R.RMRDate));
return(_DBHelper.ExecuteDataSet("sp_Prod_GetMilkColdRoomTemperaturDetails", paramcollection, CommandType.StoredProcedure));
}
public DataSet GetFinishedGoodReleaseDetails(RMRecieve R)
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DataAcess.DBParameter("@date", R.RMRDate));
return(_DBHelper.ExecuteDataSet("sp_Prod_GetFinishedGoodsInformation", paramCollection, CommandType.StoredProcedure));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
{
mtracqc = new MTraceabilityMilkQC();
btracqc = new BTraceabilityMilkQC();
int Result = 0;
mtracqc.TraceabilityMilkQCId = 0;
mtracqc.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mtracqc.CreamAndSkimDate = Convert.ToDateTime(txtSkimDate.Text.ToString());
mtracqc.PackingDate = Convert.ToDateTime(txtPackingDate.Text.ToString());
mtracqc.TraceabilitMilkQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mtracqc.TankerCode = string.IsNullOrEmpty(txtTankerCode.Text) ? string.Empty : txtTankerCode.Text;
mtracqc.SMPBatchCode = string.IsNullOrEmpty(txtSMPBatchcode.Text) ? string.Empty : txtSMPBatchcode.Text;
mtracqc.TankerPampingTime = string.IsNullOrEmpty(txtPumpinghr.Text) ? string.Empty : txtPumpinghr.Text;
mtracqc.ChilledMilkSiloNo = string.IsNullOrEmpty(txtChilledMilkSiloNo.Text) ? string.Empty : txtChilledMilkSiloNo.Text;
mtracqc.ProcessSiloNo = string.IsNullOrEmpty(txtProcessSiloNo.Text) ?string.Empty : txtProcessSiloNo.Text;
mtracqc.CreamTemperature = string.IsNullOrEmpty(txtCreamTemperature.Text) ? 0 : Convert.ToDouble(txtCreamTemperature.Text);
mtracqc.SkimTemperature = string.IsNullOrEmpty(txtSkimTemperature.Text) ? 0 : Convert.ToDouble(txtSkimTemperature.Text);
mtracqc.FAT = string.IsNullOrEmpty(txtFAT.Text) ? 0 : Convert.ToDouble(txtFAT.Text);
mtracqc.Taste = string.IsNullOrEmpty(txtTaste.Text) ? string.Empty : txtTaste.Text;
mtracqc.Smell = string.IsNullOrEmpty(txtSmell.Text) ? string.Empty : txtSmell.Text;
mtracqc.Color = string.IsNullOrEmpty(txtColor.Text) ? string.Empty : txtColor.Text;
mtracqc.PhosphatasTest = string.IsNullOrEmpty(txtPhosphataseTest.Text)?string.Empty :txtPhosphataseTest.Text;
mtracqc.Acidity = string.IsNullOrEmpty(txtAcidity.Text) ? 0 : Convert.ToDouble(txtAcidity.Text);
mtracqc.CLR = string.IsNullOrEmpty(txtCLR.Text) ? 0 : Convert.ToDouble(txtCLR.Text);
//mtracqc.Color = string.IsNullOrEmpty(txtColor.Text) ? 0 : Convert.ToDouble(txtColor.Text);
mtracqc.PackedCode = string.IsNullOrEmpty(txtPacketCode.Text)? string.Empty : txtPacketCode.Text;
mtracqc.SNF = string.IsNullOrEmpty(txtSNF.Text) ? 0 : Convert.ToDouble(txtSNF.Text);
mtracqc.Technician = string.IsNullOrEmpty(txtTechnician.Text) ? string.Empty : txtTechnician.Text;
mtracqc.TraceabilityStatusId = Convert.ToInt32(dpStatus.SelectedItem.Value);
mtracqc.flag = "Insert";
Result = btracqc.tracqcdata(mtracqc);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSkimDate.Text);
GetTraceabilityDetails(R);
string dates;
dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
uprouteList.Update();
lblSuccess.Text = "Traceability Data Added Successfully";
pnlError.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
//return Result;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
mqcp = new MQCAfterProcessing();
bqcp = new BQCAfterProcessing();
int Result = 0;
mqcp.APQCId = 0;
mqcp.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mqcp.BatchCode = string.IsNullOrEmpty(txtBatchCode.Text) ? string.Empty : txtBatchCode.Text;
mqcp.APQCDate = Convert.ToDateTime(txtDate.Text).ToString("dd-MM-yyyy");
mqcp.APQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mqcp.ProcessingTime = string.IsNullOrEmpty(txtProcessingTime.Text) ? string.Empty : txtProcessingTime.Text;
mqcp.SiloNo = string.IsNullOrEmpty(txtSiloNo.Text) ? 0 : Convert.ToInt32(txtSiloNo.Text);
mqcp.ProcessedQty = string.IsNullOrEmpty(txtProcessQty.Text) ? 0 : Convert.ToDouble(txtProcessQty.Text);
mqcp.ProcessTemperature = string.IsNullOrEmpty(txtTemperature.Text) ? 0 : Convert.ToDouble(txtTemperature.Text);
mqcp.OrganoSmell = string.IsNullOrEmpty(txtOrganolepticTestForSmell.Text) ? string.Empty : txtOrganolepticTestForSmell.Text;
mqcp.OrganoTaste = string.IsNullOrEmpty(txtOrganolepticTestForTaste.Text) ? string.Empty : txtOrganolepticTestForTaste.Text;
mqcp.OrganoColor = string.IsNullOrEmpty(txtOrganolepticTestForColour.Text) ? string.Empty : txtOrganolepticTestForColour.Text;
mqcp.Acidity = string.IsNullOrEmpty(txtAcidity.Text) ? 0 : Convert.ToDouble(txtAcidity.Text);
mqcp.PhosStartTime = string.IsNullOrEmpty(txtPhosphataseStartingTime.Text) ? string.Empty : txtPhosphataseStartingTime.Text;
mqcp.PhosEndTime = string.IsNullOrEmpty(txtPhosphataseEndTime.Text) ? string.Empty : txtPhosphataseEndTime.Text;
mqcp.PhosTotalHrs = string.IsNullOrEmpty(txtPhosphatasetotalhrs.Text) ? string.Empty : txtPhosphatasetotalhrs.Text;
mqcp.MBRTStartTime = string.IsNullOrEmpty(txtMBRTStartTime.Text) ? string.Empty : txtMBRTStartTime.Text;
mqcp.MBRTEndTime = string.IsNullOrEmpty(txtMBRTEndTime.Text) ? string.Empty : txtMBRTEndTime.Text;
mqcp.MBRTTotalHrs = string.IsNullOrEmpty(txtMBRTTotalHours.Text) ? string.Empty : txtMBRTTotalHours.Text;
mqcp.Fat = string.IsNullOrEmpty(txtFAT.Text) ? 0 : Convert.ToDouble(txtFAT.Text);
mqcp.SNF = string.IsNullOrEmpty(txtSNF.Text) ? 0 : Convert.ToDouble(txtSNF.Text);
mqcp.CLR = string.IsNullOrEmpty(txtCLR.Text) ? 0 : Convert.ToDouble(txtCLR.Text);
mqcp.HomEfficiency = string.IsNullOrEmpty(txtHomEfficiency.Text) ? string.Empty : txtHomEfficiency.Text;
mqcp.AfterProcessingStatusId = Convert.ToInt32(dpAfterProcessingStatus.SelectedItem.Value);
mqcp.flag = "Insert";
Result = bqcp.AfterProcessingQcData(mqcp);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
//string dates;
//dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetQCProcssingDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetQCProcssingDetails(R);
uprouteList.Update();
lblSuccess.Text = "PasteurizationProcess Data Add Successfully";
pnlError.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
RMRecieve R = new RMRecieve();
ProductionData PD = new ProductionData();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetQCProcssingDetails(R);
}
protected void btnAddProductionInfo_Click(object sender, EventArgs e)
{
rmrdata = new RMRecieve();
proddata = new ProductionData();
int Result = 0;
rmrdata.RMRId = 0;
rmrdata.RMRDate = Convert.ToDateTime(txtDate.Text.ToString());
rmrdata.RMRShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
rmrdata.BatchNo = txtBatchNo.Text;
rmrdata.TankMilkReciptNo = txtTankerReceipitNo.Text;
rmrdata.TankerNo = txtTankerNo.Text;
rmrdata.Quantity = string.IsNullOrEmpty(txtQty.Text) ? 0 : Convert.ToDouble(txtQty.Text);
rmrdata.MilkType = string.IsNullOrEmpty(txtMilkType.Text) ? string.Empty : txtMilkType.Text;
rmrdata.CreatedBy = GlobalInfo.Userid;
rmrdata.CreatedDate = Convert.ToDateTime(DateTime.Now).ToString("dd-MM-yyyy");
rmrdata.QCId = Convert.ToInt32(dpfinishQC.SelectedItem.Value);
rmrdata.MBRTStart = string.IsNullOrEmpty(txtMBRTStartTime.Text) ? string.Empty : txtMBRTStartTime.Text;
rmrdata.MBRTEnd = string.IsNullOrEmpty(txtMBRTEndTime.Text) ? string.Empty : txtMBRTEndTime.Text;
rmrdata.TotalHours = string.IsNullOrEmpty(txtTotalHours.Text) ? string.Empty : txtTotalHours.Text;
rmrdata.IsActive = true;
rmrdata.flag = "Insert";
// rmrdata.CheckBatchNo = 0;
Result = proddata.RMRData(rmrdata);
if (Result > 0)
{
//Response.Redirect(Request.RawUrl);
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtDate.Text);
GetRMRDetails(R);
uprouteList.Update();
lblSuccess.Text = "RMR Data Add Successfully";
pnlError.Update();
clearText();
}
else if (Result == 100)
{
divDanger.Visible = true;
divwarning.Visible = false;
divSusccess.Visible = false;
lblSuccess.Text = "Batch No Already Exist";
pnlError.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
//return Result;
}
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();
}
}
protected void btnUpdateCurdProcessQCdetail_Click(object sender, EventArgs e)
{
MCQCdata = new MCurdProcessingQC();
BCQCdata = new BCurdProcessingQC();
int Result = 0;
MCQCdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
MCQCdata.BatchNo = string.IsNullOrEmpty(txtBatchNo.Text) ? string.Empty : txtBatchNo.Text;
MCQCdata.CurdQCDate = Convert.ToDateTime(txtCurdQCDate.Text).ToString("dd-MM-yyyy");
MCQCdata.CurdQCShiftId = Convert.ToInt32(dpCurdQCShift.SelectedItem.Value);
MCQCdata.CurdQCProcessTime = string.IsNullOrEmpty(txtProcessingTime.Text) ? string.Empty : txtProcessingTime.Text;
MCQCdata.CurdQCSiloNo = Convert.ToInt32(txtSiloNo.Text);
MCQCdata.CurdQCProcessQty = string.IsNullOrEmpty(txtProcessQty.Text) ? 0 : Convert.ToDouble(txtProcessQty.Text);
MCQCdata.CurdQCTemp = string.IsNullOrEmpty(txtTemperature.Text) ? 0 : Convert.ToDouble(txtTemperature.Text);
MCQCdata.CurdQCFat = string.IsNullOrEmpty(txtFat.Text) ? 0 : Convert.ToDouble(txtFat.Text);
MCQCdata.CurdQCCLR = string.IsNullOrEmpty(txtCLR.Text) ? 0 : Convert.ToDouble(txtCLR.Text);
MCQCdata.CurdQCSNF = string.IsNullOrEmpty(txtSNF.Text) ? 0 : Convert.ToDouble(txtSNF.Text);
MCQCdata.CurdQCAcidity = string.IsNullOrEmpty(txtAcidity.Text) ? 0 : Convert.ToDouble(txtAcidity.Text);
MCQCdata.HomEfficiency = string.IsNullOrEmpty(txtHomEfficiency.Text) ? string.Empty : txtHomEfficiency.Text;
MCQCdata.CurdQCTaste = string.IsNullOrEmpty(txtTaste.Text) ? string.Empty : txtTaste.Text;
MCQCdata.CurdQCSmell = string.IsNullOrEmpty(txtSmell.Text) ? string.Empty : txtSmell.Text;
MCQCdata.CurdQCColor = string.IsNullOrEmpty(txtColor.Text) ? string.Empty : txtColor.Text;
MCQCdata.PhosphataseStartTime = string.IsNullOrEmpty(txtPhosphataseStartTime.Text) ? string.Empty : txtPhosphataseStartTime.Text;
MCQCdata.PhosphataseEndTime = string.IsNullOrEmpty(txtPhosphataseEndTime.Text) ? string.Empty : txtPhosphataseEndTime.Text;
MCQCdata.PhosphataseTotalHours = string.IsNullOrEmpty(txtPhosphataseTotalHours.Text) ? string.Empty : txtPhosphataseTotalHours.Text;
MCQCdata.CurdQCMBRTStartTime = string.IsNullOrEmpty(txtMBRTStartTime.Text) ? string.Empty : txtMBRTStartTime.Text;
MCQCdata.CurdQCMBRTEndTime = string.IsNullOrEmpty(txtMBRTEndTime.Text) ? string.Empty : txtMBRTEndTime.Text;
MCQCdata.CurdQCMBRTTotalHours = string.IsNullOrEmpty(txtMBRTTotalHours.Text) ? string.Empty : txtMBRTTotalHours.Text;
MCQCdata.CurdQCStatusId = Convert.ToInt32(dpQCDetails.SelectedItem.Value);
MCQCdata.flag = "Update";
Result = BCQCdata.CurdProcessQCData(MCQCdata);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
//string dates;
//dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetCurdProcessQCDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetCurdProcessQCDetails(R);
uprouteList.Update();
lblSuccess.Text = "Data Updated Successfully";
pnlError.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
qtyMdata = new MQuality();
qtyBdata = new BQuality();
//if (dpQCDetails.SelectedItem.Text == "Accepted" || dpQCDetails.SelectedItem.Text == "Rejected")
//{
int Result = 0;
qtyMdata.QualityId = 0;
qtyMdata.RMRId = string.IsNullOrEmpty(hfrid.Value) ? 0 : Convert.ToInt32(hfrid.Value);
//qtydata.QCId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
qtyMdata.RMRShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
//qtyMdata.RMRDate = DateTime.Now.ToString();
qtyMdata.QualityDate = Convert.ToDateTime(txtDate.Text.ToString());
qtyMdata.Temperature = string.IsNullOrEmpty(txtTemperature.Text) ? 0 : Convert.ToDouble(txtTemperature.Text);
qtyMdata.Alcohol = string.IsNullOrEmpty(txtAlcohol.Text) ? 0 : Convert.ToDouble(txtAlcohol.Text);
qtyMdata.Neutralizer = string.IsNullOrEmpty(txtNeutralizer.Text) ? 0 : Convert.ToDouble(txtNeutralizer.Text);
qtyMdata.Taste = string.IsNullOrEmpty(txtTaste.Text) ? string.Empty : txtTaste.Text;
qtyMdata.Smell = string.IsNullOrEmpty(txtSmell.Text) ? string.Empty : txtSmell.Text;
qtyMdata.Color = string.IsNullOrEmpty(txtColor.Text) ? string.Empty : txtColor.Text;
qtyMdata.Acidity = string.IsNullOrEmpty(txtAcidity.Text) ? 0 : Convert.ToDouble(txtAcidity.Text);
qtyMdata.HeatStability = string.IsNullOrEmpty(txtHeatStability.Text) ? 0 : Convert.ToDouble(txtHeatStability.Text);
qtyMdata.Fat = string.IsNullOrEmpty(txtFat.Text) ? 0 : Convert.ToDouble(txtFat.Text);
qtyMdata.CLR = string.IsNullOrEmpty(txtCLR.Text) ? 0 : Convert.ToDouble(txtCLR.Text);
qtyMdata.SNF = string.IsNullOrEmpty(txtSNF.Text) ? 0 : Convert.ToDouble(txtSNF.Text);
qtyMdata.TestedBy = string.IsNullOrEmpty(txtTestedBy.Text) ? string.Empty : txtTestedBy.Text;
qtyMdata.VerifiedBy = string.IsNullOrEmpty(txtVerifiedBy.Text) ? string.Empty : txtVerifiedBy.Text;
qtyMdata.Others = string.IsNullOrEmpty(txtOthers.Text) ? string.Empty : txtOthers.Text;
qtyMdata.Remarks = string.IsNullOrEmpty(txtRemarks.Text) ? string.Empty : txtRemarks.Text;
qtyMdata.QCStatus = Convert.ToInt32(dpQCDetails.SelectedItem.Value);
qtyMdata.flag = "Update";
Result = qtyBdata.QualityData(qtyMdata);
//btnRefresh_Click(sender, e);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtDate.Text);
GetQualityDetails(R);
uprouteList.Update();
lblSuccess.Text = "QualityData Data Updated Successfully";
pnlError.Update();
ClearField();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
}
protected void btnUpdateCurdProcessdetail_Click(object sender, EventArgs e)
{
MCdata = new MCurdProcessing();
BCdata = new BCurdProcessing();
int Result = 0;
MCdata.CurdId = 0;
MCdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
MCdata.CurdProcessDate = Convert.ToDateTime(txtDate.Text).ToString("dd-MM-yyyy");
MCdata.CurdProcessShiftId = Convert.ToInt32(dpCurdProcessShiftId.SelectedItem.Value);
MCdata.HeatingTemp = string.IsNullOrEmpty(txtHeatingTemperature.Text) ? 0 : Convert.ToDouble(txtHeatingTemperature.Text);
MCdata.HoldingTime = string.IsNullOrEmpty(txtHoldingTime.Text) ? string.Empty : txtHoldingTime.Text;
MCdata.InoculationMilkTemp = string.IsNullOrEmpty(txtInoculation.Text) ? 0 : Convert.ToDouble(txtInoculation.Text);
MCdata.CultureAdd = string.IsNullOrEmpty(txtCultureName.Text) ? string.Empty : txtCultureName.Text;
MCdata.CultureLotNo = string.IsNullOrEmpty(txtCulturelotNo.Text) ? string.Empty : txtCulturelotNo.Text;
MCdata.CultureExpDate = Convert.ToDateTime(txtcultureExpDate.Text).ToString("dd-MM-yyyy");
MCdata.IncubationStartTime = string.IsNullOrEmpty(txtIncubationStartTime.Text) ? string.Empty : txtIncubationStartTime.Text;
MCdata.IncubationEndTime = string.IsNullOrEmpty(txtIncubationStartTime.Text) ? string.Empty : txtIncubationStartTime.Text;
MCdata.MilkQtyforCanCurd = string.IsNullOrEmpty(txtQtyMilkforCanCurd.Text) ? 0 : Convert.ToDouble(txtQtyMilkforCanCurd.Text);
MCdata.MilkQtyforCupPouchCurd = string.IsNullOrEmpty(txtQtyMilkforCupPouchCurd.Text) ? 0 : Convert.ToDouble(txtQtyMilkforCupPouchCurd.Text);
MCdata.PackingStartTime = string.IsNullOrEmpty(txtPackingStartTime.Text) ? string.Empty : txtPackingStartTime.Text;
MCdata.PackingEndTime = string.IsNullOrEmpty(txtPackingEndTime.Text) ? string.Empty : txtPackingEndTime.Text;
MCdata.BatchCode = string.IsNullOrEmpty(txtBatchcode.Text) ? string.Empty : txtBatchcode.Text;
MCdata.ColdRoomTemp = string.IsNullOrEmpty(txtColdRoomTemp.Text) ? 0 : Convert.ToDouble(txtColdRoomTemp.Text);
MCdata.ProcessedBy = string.IsNullOrEmpty(txtProcessedby.Text) ? string.Empty : txtProcessedby.Text;
MCdata.LabTechnician = string.IsNullOrEmpty(txtLabTechnician.Text) ? string.Empty : txtLabTechnician.Text;
MCdata.VerifiedBy = string.IsNullOrEmpty(txtVerifiedBy.Text) ? string.Empty : txtVerifiedBy.Text;
MCdata.ApprovedBy = string.IsNullOrEmpty(txtApprovedBy.Text) ? string.Empty : txtApprovedBy.Text;
MCdata.CurdProcessingStatusId = Convert.ToInt32(dpCurdProcessingStatusId.SelectedItem.Value);
MCdata.flag = "Update";
Result = BCdata.CurdProcessData(MCdata);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
//string dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetCurdProcessDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetCurdProcessDetails(R);
uprouteList.Update();
lblSuccess.Text = "Curd Processing Data Updated Successfully";
pnlError.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
}
protected void btnAdd_Click1(object sender, EventArgs e)
{
{
mpacked = new MMilkPackedData();
bpacked = new BMilkPackedData();
int Result = 0;
mpacked.PackedDataId = 0;
mpacked.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mpacked.PackedDate = Convert.ToDateTime(txtDate.Text.ToString());
mpacked.ShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mpacked.PackingOperatorName = string.IsNullOrEmpty(txtPackingOperatorName.Text) ? string.Empty : txtPackingOperatorName.Text;
mpacked.ReceivedBy = string.IsNullOrEmpty(txtReceivedBy.Text) ? string.Empty : txtReceivedBy.Text;
mpacked.TypeOfMilk = string.IsNullOrEmpty(txtTypeOfMilk.Text) ? string.Empty : txtTypeOfMilk.Text;
mpacked.QuantityIn1000ML = string.IsNullOrEmpty(txtQuantityIn1000.Text) ? 0 : Convert.ToDouble(txtQuantityIn1000.Text);
mpacked.QuantityIn500ML = string.IsNullOrEmpty(txtQuantityIn500.Text) ? 0 : Convert.ToDouble(txtQuantityIn500.Text);
mpacked.QuantityIn450ML = string.IsNullOrEmpty(txtQuantityIn450.Text) ? 0 : Convert.ToDouble(txtQuantityIn450.Text);
mpacked.QuantityIn250ML = string.IsNullOrEmpty(txtQuantityIn250.Text) ? 0 : Convert.ToDouble(txtQuantityIn250.Text);
mpacked.QuantityIn200ML = string.IsNullOrEmpty(txtQuantityIn200.Text) ? 0 : Convert.ToDouble(txtQuantityIn200.Text);
mpacked.Curd500MLQty = string.IsNullOrEmpty(txtcurd500.Text) ? 0 : Convert.ToDouble(txtcurd500.Text);
mpacked.Curd450MLQty = string.IsNullOrEmpty(txtcurd450.Text) ? 0 : Convert.ToDouble(txtcurd450.Text);
mpacked.ButterMilk200ML = string.IsNullOrEmpty(txtbuttermilk200.Text) ? 0 : Convert.ToDouble(txtbuttermilk200.Text);
mpacked.TotalQtyOfMilk = string.IsNullOrEmpty(txtTotalOfMilk.Text) ? 0 : Convert.ToDouble(txtTotalOfMilk.Text);
mpacked.ColdRoomNo = string.IsNullOrEmpty(txtColdRoomNo.Text) ? string.Empty : txtColdRoomNo.Text;
mpacked.PackingDetailStatusId = Convert.ToInt32(dpPackingDetailStatus.SelectedItem.Value);
mpacked.flag = "Insert";
Result = bpacked.packeddata(mpacked);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
//string dates;
//dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetCreamDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetCreamDetails(R);
uprouteList.Update();
lblSuccess.Text = "Packed Data Add Successfully";
pnlError.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
//return Result;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
//string dates = Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetPasteurizationDetails(dates);
RMRecieve R = new RMRecieve();
ProductionData PD = new ProductionData();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetPasteurizationDetails(R);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
{
mhomo = new MHomogenizer();
bhomo = new BHomogenizer();
int Result = 0;
mhomo.HomogenizerId = 0;
mhomo.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mhomo.HomogenizerDate = Convert.ToDateTime(txtHomogenizerDate.Text.ToString());
mhomo.HomogenizerShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
//mhomo.StatusId = Convert.ToInt32(dpStatusDetails.SelectedItem.Value);
mhomo.PressureFirstStage = string.IsNullOrEmpty(txtPressureFisrtStage.Text) ? 0 : Convert.ToDouble(txtPressureFisrtStage.Text);
mhomo.PressureSecondStage = string.IsNullOrEmpty(txtPressureSecondStage.Text) ? 0 : Convert.ToDouble(txtPressureSecondStage.Text);
// mhomo.Oilleakage = string.IsNullOrEmpty(txtOilleakage.Text) ? 0 : Convert.ToDouble(txtOilleakage.Text);
mhomo.OilleakageId = Convert.ToInt32(dpOilLeakage.SelectedItem.Value);
mhomo.HomogenizedQty = string.IsNullOrEmpty(txtQtyHomogenized.Text) ? 0 : Convert.ToDouble(txtQtyHomogenized.Text);
mhomo.Technician = txtTechnician.Text;
//mhomo.Homogenized = txtHomogenized.Text;
mhomo.Remarks = txtRemarks.Text;
mhomo.MachineStartTime = txtStartingTime.Text;
mhomo.MachineEndTime = txtEndTime.Text;
mhomo.Technician = txtTechnician.Text;
mhomo.HomogenizerStatusId = Convert.ToInt32(dpStatusDetails.SelectedItem.Value);
mhomo.flag = "Update";
Result = bhomo.homodata(mhomo);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
//string dates;
//dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetHomogenizerDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetHomogenizerDetails(R);
uprouteList.Update();
lblSuccess.Text = "Homogenizer Data Update Successfully";
pnlError.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
//return Result;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
{
mpast = new MPastProcess();
bpast = new BPastProcess();
int Result = 0;
mpast.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
//mpast.pastProcessId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mpast.PastProcessDate = Convert.ToDateTime(txtDate.Text).ToString("dd-MM-yyyy");
mpast.PastShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mpast.IBTTemperature = string.IsNullOrEmpty(txtIBTTemperature.Text) ? 0 : Convert.ToDouble(txtIBTTemperature.Text);
mpast.PastStartTime = string.IsNullOrEmpty(txtPasteurizationstarttime.Text)?string.Empty : txtPasteurizationstarttime.Text;
mpast.PastTempHeat1 = string.IsNullOrEmpty(txtHeatFirst.Text) ? 0 : Convert.ToDouble(txtHeatFirst.Text);
mpast.Cool1 = string.IsNullOrEmpty(txtCool1.Text) ? 0 : Convert.ToDouble(txtCool1.Text);
mpast.PastTempHeat2 = string.IsNullOrEmpty(txtHeatSecond.Text) ? 0 : Convert.ToDouble(txtHeatSecond.Text);
mpast.Cool2 = string.IsNullOrEmpty(txtCool2.Text) ? 0 : Convert.ToDouble(txtCool2.Text);
mpast.PastTempHeat3 = string.IsNullOrEmpty(txtHeatThird.Text) ? 0 : Convert.ToDouble(txtHeatThird.Text);
mpast.Cool3 = string.IsNullOrEmpty(txtCool3.Text) ? 0 : Convert.ToDouble(txtCool3.Text);
mpast.PastTempHeat4 = string.IsNullOrEmpty(txtHeatForth.Text) ? 0 : Convert.ToDouble(txtHeatForth.Text);
mpast.Cool4 = string.IsNullOrEmpty(txtCool4.Text) ? 0 : Convert.ToDouble(txtCool4.Text);
mpast.PastTempHeat5 = string.IsNullOrEmpty(txtHeatFive.Text) ? 0 : Convert.ToDouble(txtHeatFive.Text);
mpast.Cool5 = string.IsNullOrEmpty(txtCool5.Text) ? 0 : Convert.ToDouble(txtCool5.Text);
mpast.MilkClosingTime = string.IsNullOrEmpty(txtMilkClosingTime.Text)?string.Empty:txtMilkClosingTime.Text;
mpast.DoneBy = string.IsNullOrEmpty(txtDoneBy.Text)?string.Empty:txtDoneBy.Text;
mpast.pastProcessStatusId = Convert.ToInt32(dpPastProcessDone.SelectedItem.Value);
mpast.flag = "Update";
Result = bpast.pastdata(mpast);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "PasteurizationProcess Data Update 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);
GetPastDetails(R);
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;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
//string dates = Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
GetQualityDetails(R);
}
catch (Exception) { }
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
RMRecieve R = new RMRecieve();
ProductionData PD = new ProductionData();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetCreamDetails(R);
}
catch (Exception) { }
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try {
//string dates = Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetHomogenizerDetails(dates);
RMRecieve R = new RMRecieve();
ProductionData PD = new ProductionData();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetHomogenizerDetails(R);
}
catch (Exception) { }
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
//string dates = Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetMilkColdRoomTemperatureDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
GetMilkColdRoomTemperatureDetails(R);
}
catch (Exception) { }
}
protected void btnAddFinishGoodsdetail_Click(object sender, EventArgs e)
{
try
{
finishMdata = new MFinishedGoodsRelease();
finishBdata = new BFinishedGoodsRelease();
int Result = 0;
finishMdata.FinishgoodId = 0;
finishMdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
finishMdata.FinishedGoodsBatchCode = string.IsNullOrEmpty(txtBatchCode.Text) ? string.Empty : txtBatchCode.Text;
finishMdata.FinishedGoodsDate = Convert.ToDateTime(txtDate.Text).ToString("dd-MM-yyyy");
finishMdata.FinishedGoodsShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
finishMdata.TypeofMilk = string.IsNullOrEmpty(txtMilkType.Text) ? string.Empty : txtMilkType.Text;
finishMdata.FinishedGoodsQuantity = string.IsNullOrEmpty(txtQuantity.Text) ? string.Empty : txtQuantity.Text;
finishMdata.FinishedGoodsMfgDate = Convert.ToDateTime(txtMfgDate.Text).ToString("dd-MM-yyyy");
finishMdata.FinishedGoodsStatusId = Convert.ToInt32(dpStatus.SelectedItem.Value);
finishMdata.flag = "Insert";
Result = finishBdata.FinishedGoods(finishMdata);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').addClass('collapsed-box');", true);
//string dates;
//dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetFinishedGoodReleaseDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtDate.Text);
GetFinishedGoodReleaseDetails(R);
uprouteList.Update();
lblSuccess.Text = "Finished Goods Added Successfully";
pnlError.Update();
//ClearField();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblSuccess.Text = "Something went wrong plz contact site admin";
pnlError.Update();
}
}
catch (FormatException EX)
{
string MSG = EX.ToString();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
//string dates = Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
//GetStandardizationProductsAddedDetails(dates);
RMRecieve R = new RMRecieve();
R.RMRDate = Convert.ToDateTime(txtSearchDate.Text);
//string dates = Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
GetStandardizationProductsAddedDetails(R);
}
catch (Exception) { }
}
protected void btnUpdateProductindetail_Click(object sender, EventArgs e)
{
RMRecieve RMR = new RMRecieve();
ProductionData proddata = new ProductionData();
RMR.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
RMR.RMRShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
RMR.RMRDate = Convert.ToDateTime(txtDate.Text).ToString("dd-MM-yyyy");
RMR.BatchNo = string.IsNullOrEmpty(txtBatchNo.Text) ? string.Empty : txtBatchNo.Text;
RMR.TankMilkReciptNo = string.IsNullOrEmpty(txtTankerReceipitNo.Text) ? string.Empty : txtTankerReceipitNo.Text;
RMR.TankerNo = string.IsNullOrEmpty(txtTankerNo.Text) ? string.Empty : txtTankerNo.Text;
RMR.MilkType = string.IsNullOrEmpty(txtMilkType.Text) ? string.Empty : txtMilkType.Text;
RMR.Quantity = string.IsNullOrEmpty(txtQty.Text) ? 0 : Convert.ToDouble(txtQty.Text);
RMR.MBRTStart = string.IsNullOrEmpty(txtMBRTStartTime.Text)? string.Empty : txtMBRTStartTime.Text;
RMR.MBRTEnd = string.IsNullOrEmpty(txtMBRTEndTime.Text) ? string.Empty : txtMBRTEndTime.Text;
RMR.TotalHours = string.IsNullOrEmpty(txtTotalHours.Text) ? string.Empty : txtTotalHours.Text;
RMR.CreatedBy = 0;
RMR.CreatedDate = DateTime.Now.ToString();
RMR.flag = "Update";
int Result = 0;
Result = proddata.RMRData(RMR);
if (Result > 0)
{
lblHeaderTab.Text = "Update RMR Details";
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
string dates;
dates = string.IsNullOrEmpty(txtSearchDate.Text) ? string.Empty : Convert.ToDateTime(txtSearchDate.Text).ToString("dd-MM-yyyy");
GetRMRDetails(dates);
uprouteList.Update();
lblSuccess.Text = "RMR Updated Successfully";
pnlError.Update();
btnAddProductionInfo.Visible = true;
btnUpdateProductindetail.Visible = false;
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
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;
}
}
