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;
}
}
public void GetTraceabilityDetails(int RMRId)
{
DataSet DS = new DataSet();
btracqc = new BTraceabilityMilkQC();
DS = btracqc.GetTraceabilityQCDetailsById(RMRId);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CreamAndSkimDate"].ToString()) ? string.Empty : Convert.ToDateTime(DS.Tables[0].Rows[0]["CreamAndSkimDate"]).ToString("yyyy-MM-dd");
txtSkimDate.Text = DATE;
string DATE1 = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["PackingDate"].ToString()) ? string.Empty : Convert.ToDateTime(DS.Tables[0].Rows[0]["PackingDate"]).ToString("yyyy-MM-dd");
txtPackingDate.Text = DATE1;
txtBatchNo.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["BatchNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["BatchNo"].ToString();
dpShiftDetails.ClearSelection();
try
{
if (dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["TraceabilitMilkQCShiftId"]).ToString()) != null)
{
dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["TraceabilitMilkQCShiftId"]).ToString()).Selected = true;
}
}
catch (InvalidCastException)
{
dpShiftDetails.SelectedIndex = 0;
}
txtTankerCode.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TankerCode"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TankerCode"].ToString();
txtSMPBatchcode.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SMPBatchCode"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SMPBatchCode"].ToString();
txtPumpinghr.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TotalHours"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TotalHours"].ToString();
txtChilledMilkSiloNo.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ChilledMilkSiloNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["ChilledMilkSiloNo"].ToString();
txtProcessSiloNo.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ProcessSiloNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["ProcessSiloNo"].ToString();
txtCreamTemperature.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CreamTemperature"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CreamTemperature"].ToString();
txtSkimTemperature.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SkimTemperature"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SkimTemperature"].ToString();
txtFAT.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["FAT"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["FAT"].ToString();
txtTaste.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Taste"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Taste"].ToString();
txtSmell.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Smell"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Smell"].ToString();
txtColor.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Color"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Color"].ToString();
txtPhosphataseTest.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["PhosphatasTest"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["PhosphatasTest"].ToString();
txtPacketCode.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["PackedCode"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["PackedCode"].ToString();
txtAcidity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Acidity"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Acidity"].ToString();
txtCLR.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CLR"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CLR"].ToString();
txtSNF.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SNF"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SNF"].ToString();
txtTechnician.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Technician"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Technician"].ToString();
dpStatus.ClearSelection();
string TraceabilityStatusId = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TraceabilityStatusId"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TraceabilityStatusId"].ToString();
if (TraceabilityStatusId == "")
{
dpStatus.SelectedIndex = 2;
}
else
{
dpStatus.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["TraceabilityStatusId"]).ToString()).Selected = true;
}
}
}
public void GetTraceabilityDetails(RMRecieve R)
{
btracqc = new BTraceabilityMilkQC();
DataSet DS = new DataSet();
DS = btracqc.GetTraceabilityDetails(R);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpTraceabilityQC.DataSource = DS;
rpTraceabilityQC.DataBind();
}
else
{
rpTraceabilityQC.DataSource = DS;
rpTraceabilityQC.DataBind();
}
}
public void GetTraceabilityDetails(string dates)
{
btracqc = new BTraceabilityMilkQC();
DataSet DS = new DataSet();
DS = btracqc.GetTraceabilityDetails(dates);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
TraceabilityQC.DataSource = DS;
TraceabilityQC.DataBind();
}
else
{
DS.Clear();
TraceabilityQC.DataSource = DS;
TraceabilityQC.DataBind();
}
}
