public int personalhygieneqcdata(MPersonalHygieneCheckListQC receive)
{
int result = 0;
try
{
DBParameterCollection paramcollection = new DBParameterCollection();
paramcollection.Add(new DBParameter("PersonalHygieneCheckListQCId", receive.PersonalHygieneCheckListQCId));
paramcollection.Add(new DBParameter("PersonalHygieneCheckListQCDate", receive.PersonalHygieneCheckListQCDate));
paramcollection.Add(new DBParameter("EmployeeId", receive.EmployeeId));
paramcollection.Add(new DBParameter("DesignationId", receive.DesignationId));
paramcollection.Add(new DBParameter("UniformCleaning", receive.UniformCleaning));
paramcollection.Add(new DBParameter("Nail", receive.Nail));
paramcollection.Add(new DBParameter("Cap", receive.Cap));
paramcollection.Add(new DBParameter("ApronLab", receive.ApronLab));
paramcollection.Add(new DBParameter("BeardCrimp", receive.BeardCrimp));
paramcollection.Add(new DBParameter("HandGloves", receive.HandGloves));
paramcollection.Add(new DBParameter("Mask", receive.Mask));
paramcollection.Add(new DBParameter("@flag", receive.flag));
result = _DBHelper.ExecuteNonQuery("sp_Prod_PersonalHygieneCheckListQCDetails", paramcollection, CommandType.StoredProcedure);
}
catch (Exception EX)
{
string MSG = EX.ToString();
}
return(result);
}
public int personalhygieneqcdata(MPersonalHygieneCheckListQC receive)
{
daphcqc = new DAPersonalHygieneCheckListQC();
int Result = 0;
try
{
Result = daphcqc.personalhygieneqcdata(receive);
}
catch (Exception)
{
throw;
}
return(Result);
}
protected void btnAdd_Click1(object sender, EventArgs e)
{
mphcqc = new MPersonalHygieneCheckListQC();
bphcqc = new BPersonalHygieneCheckListQC();
int Result = 0;
mphcqc.PersonalHygieneCheckListQCId = 0;
mphcqc.PersonalHygieneCheckListQCDate = Convert.ToDateTime(txtDate.Text.ToString());
mphcqc.EmployeeId = Convert.ToInt32(dpEmployee.SelectedItem.Value);
mphcqc.DesignationId = Convert.ToInt32(dpDesignation.SelectedItem.Value);
if (chkUniform.Checked)
{
mphcqc.UniformCleaning = true;
}
else
{
mphcqc.UniformCleaning = false;
}
if (chkNail.Checked)
{
mphcqc.Nail = true;
}
else
{
mphcqc.Nail = false;
}
if (chkCap.Checked)
{
mphcqc.Cap = true;
}
else
{
mphcqc.Cap = false;
}
if (chkApronLab.Checked)
{
mphcqc.ApronLab = true;
}
else
{
mphcqc.ApronLab = false;
}
if (chkBeardCrimp.Checked)
{
mphcqc.BeardCrimp = true;
}
else
{
mphcqc.BeardCrimp = false;
}
if (chkHandGloves.Checked)
{
mphcqc.HandGloves = true;
}
else
{
mphcqc.HandGloves = false;
}
if (chkMask.Checked)
{
mphcqc.Mask = true;
}
else
{
mphcqc.Mask = false;
}
mphcqc.flag = "Insert";
Result = bphcqc.personalhygieneqcdata(mphcqc);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Personal Hygiene CheckListQC Data Added Successfully";
ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx2').removeClass('collapsed-box');", true);
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_Click1(object sender, EventArgs e)
{
mphcqc = new MPersonalHygieneCheckListQC();
bphcqc = new BPersonalHygieneCheckListQC();
int Result = 0;
mphcqc.PersonalHygieneCheckListQCId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value);
mphcqc.PersonalHygieneCheckListQCDate = Convert.ToDateTime(txtDate.Text.ToString());
mphcqc.EmployeeId = Convert.ToInt32(dpEmployee.SelectedItem.Value);
mphcqc.DesignationId = Convert.ToInt32(dpDesignation.SelectedItem.Value);
if (chkUniform.Checked)
{
mphcqc.UniformCleaning = true;
}
else
{
mphcqc.UniformCleaning = false;
}
if (chkNail.Checked)
{
mphcqc.Nail = true;
}
else
{
mphcqc.Nail = false;
}
if (chkCap.Checked)
{
mphcqc.Cap = true;
}
else
{
mphcqc.Cap = false;
}
if (chkApronLab.Checked)
{
mphcqc.ApronLab = true;
}
else
{
mphcqc.ApronLab = false;
}
if (chkBeardCrimp.Checked)
{
mphcqc.BeardCrimp = true;
}
else
{
mphcqc.BeardCrimp = false;
}
if (chkHandGloves.Checked)
{
mphcqc.HandGloves = true;
}
else
{
mphcqc.HandGloves = false;
}
if (chkMask.Checked)
{
mphcqc.Mask = true;
}
else
{
mphcqc.Mask = false;
}
mphcqc.flag = "Update";
Result = bphcqc.personalhygieneqcdata(mphcqc);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Personal Hygiene CheckListQC 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();
}
}