public void GetPasteurizationDetails(int RMRId)
{
DataSet DS = new DataSet();
BPasteurizationQC bdata = new BPasteurizationQC();
DS = bdata.GetPasteurizationDetabyId(RMRId);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["PastProcessDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["PastProcessDate"].ToString();
if (DATE == "")
{
txtDate.Text = "";
}
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();
txtTemperatureHeat.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TemperatureHeat"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TemperatureHeat"].ToString();
txtTempChill.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TempChill"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TempChill"].ToString();
txtDoneBy.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DoneBy"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DoneBy"].ToString();
txtRemarks.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Remarks"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Remarks"].ToString();
dpShiftDetails.ClearSelection();
try
{
if (dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["PastQCShiftId"]).ToString()) != null)
{
dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["PastQCShiftId"]).ToString()).Selected = true;
}
}
catch (InvalidCastException)
{
dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["PastShiftId"]).ToString()).Selected = true;
}
dpQCDetails.ClearSelection();
try
{
if (dpQCDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["QCStatus"]).ToString()) != null)
{
dpQCDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["QCStatus"]).ToString()).Selected = true;
}
}
catch (InvalidCastException)
{
dpQCDetails.SelectedIndex = 0;
}
}
}
public void GetPasteurizationDetails(string dates)
{
bdata = new BPasteurizationQC();
DataSet DS = new DataSet();
DS = bdata.GetPasteurizationDetails(dates);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpPasteurizationQCList.DataSource = DS;
rpPasteurizationQCList.DataBind();
}
else
{
DS.Clear();
rpPasteurizationQCList.DataSource = DS;
rpPasteurizationQCList.DataBind();
}
}
public void GetPasteurizationDetails(RMRecieve R)
{
bdata = new BPasteurizationQC();
DataSet DS = new DataSet();
DS = bdata.GetPasteurizationDetails(R);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpPasteurizationQCList.DataSource = DS;
rpPasteurizationQCList.DataBind();
}
else
{
// this.BindRepeater(dt);
rpPasteurizationQCList.DataSource = DS;
rpPasteurizationQCList.DataBind();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
MPasteurizationQC mdata = new MPasteurizationQC();
BPasteurizationQC bdata = new BPasteurizationQC();
int Result = 0;
mdata.PastQCId = 0;
// mdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mdata.PastQCDate = Convert.ToDateTime(txtDate.Text).ToString("dd-MM-yyyy");
mdata.PastQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mdata.TemperatureHeat = string.IsNullOrEmpty(txtTemperatureHeat.Text) ? 0 : Convert.ToDouble(txtTemperatureHeat.Text);
mdata.TempChill = string.IsNullOrEmpty(txtTempChill.Text) ? 0 : Convert.ToDouble(txtTempChill.Text);
mdata.DoneBy = txtDoneBy.Text;
mdata.Remarks = txtRemarks.Text;
mdata.QCStatus = Convert.ToInt32(dpQCDetails.SelectedItem.Value);
mdata.flag = "Update";
Result = bdata.PasteurizationData(mdata);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Pasteurization 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");
GetPasteurizationDetails(dates);
uprouteList.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_Click(object sender, EventArgs e)
{
MPasteurizationQC mdata = new MPasteurizationQC();
BPasteurizationQC bdata = new BPasteurizationQC();
int Result = 0;
mdata.PastQCId = 0;
foreach (RepeaterItem item in rpPasteurizationQCList.Items)
{
HiddenField hdfID = item.FindControl("hfPastProcessId") as HiddenField;
if (hdfID != null)
{
mdata.PastProcessId = string.IsNullOrEmpty(hdfID.Value) ? 0 : Convert.ToInt32(hdfID.Value);
}
}
foreach (RepeaterItem item in rpPasteurizationQCList.Items)
{
HiddenField hdfID1 = item.FindControl("hfStdId") as HiddenField;
if (hdfID1 != null)
{
mdata.StdId = string.IsNullOrEmpty(hdfID1.Value) ? 0 : Convert.ToInt32(hdfID1.Value);
}
}
foreach (RepeaterItem item in rpPasteurizationQCList.Items)
{
HiddenField hdfID2 = item.FindControl("hfQualityId") as HiddenField;
if (hdfID2 != null)
{
mdata.QualityId = string.IsNullOrEmpty(hdfID2.Value) ? 0 : Convert.ToInt32(hdfID2.Value);
}
}
mdata.RMRId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mdata.PastQCDate = Convert.ToDateTime(txtDate.Text).ToString("dd-MM-yyyy");
mdata.PastQCShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value);
mdata.TemperatureHeat = string.IsNullOrEmpty(txtTemperatureHeat.Text) ? 0 : Convert.ToDouble(txtTemperatureHeat.Text);
mdata.TempChill = string.IsNullOrEmpty(txtTempChill.Text) ? 0 : Convert.ToDouble(txtTempChill.Text);
mdata.DoneBy = txtDoneBy.Text;
mdata.Remarks = txtRemarks.Text;
mdata.QCStatus = Convert.ToInt32(dpQCDetails.SelectedItem.Value);
mdata.flag = "Insert";
Result = bdata.PasteurizationData(mdata);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Pasteurization 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");
GetPasteurizationDetails(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;
}