public bool IsRecordExist(EntityTestPara entDept)
{
bool flag = false;
try
{
tblTestPara obj = (from tbl in objData.tblTestParas
where tbl.IsDelete == false &&
tbl.TestId.Equals(entDept.TestId) &&
tbl.ParaName.ToUpper().ToString().Trim().Equals(entDept.ParaName.ToUpper().ToString().Trim())
select tbl).FirstOrDefault();
if (obj != null)
{
flag = true;
}
else
{
flag = false;
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
protected void BtnEdit_Click(object sender, EventArgs e)
{
int lintCnt = 0;
try
{
EntityTestPara entDept = new EntityTestPara();
entDept.TstParID = Convert.ToInt32(Session["T_Id"]);
entDept.TestId = ddlTestName.SelectedIndex;
entDept.ParaName = txtParaName.Text;
if (Convert.ToDecimal(txtMaxPara.Text) <= Convert.ToDecimal(txtMinPara.Text))
{
lblMsg.Text = "Maximum Parameter Value Can't Be Less Then Minimum Parameter Value";
txtMaxPara.Text = string.Empty;
txtMaxPara.Focus();
return;
}
else
{
entDept.MinPara = Convert.ToDecimal(txtMinPara.Text);
entDept.MaxPara = Convert.ToDecimal(txtMaxPara.Text);
}
if (!mobjDeptBLL.IsRecordExist(entDept))
{
lintCnt = mobjDeptBLL.UpdatePara(entDept);
if (lintCnt > 0)
{
GetTestsWithPara();
lblMessage.Text = "Record Updated Successfully";
//this.programmaticModalPopup.Hide();
}
else
{
lblMessage.Text = "Record Not Updated";
}
}
else
{
lblMessage.Text = "Record Already Exist....";
}
MultiView1.SetActiveView(View1);
}
catch (Exception ex)
{
Commons.FileLog("frmDepartmentMaster - BtnEdit_Click(object sender, EventArgs e)", ex);
}
}
public int InsertTestWithPara(EntityTestPara entDept)
{
try
{
tblTestPara obj = new tblTestPara()
{
TestId = entDept.TestId,
ParaName = entDept.ParaName,
MinPara = entDept.MinPara,
MaxPara = entDept.MaxPara
};
objData.tblTestParas.InsertOnSubmit(obj);
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public int UpdatePara(EntityTestPara entDept)
{
try
{
tblTestPara test = (from tbl in objData.tblTestParas
where tbl.IsDelete == false &&
tbl.TstParID == entDept.TstParID
select tbl).FirstOrDefault();
test.TestId = entDept.TestId;
test.ParaName = entDept.ParaName;
test.MinPara = entDept.MinPara;
test.MaxPara = entDept.MaxPara;
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
int lintcnt = 0;
EntityTestPara entDept = new EntityTestPara();
if (Session["update"].ToString() == ViewState["update"].ToString())
{
if (ddlTestName.SelectedIndex == 0)
{
lblMsg.Text = "Please Select Test Name";
ddlTestName.Focus();
return;
}
else
{
if (string.IsNullOrEmpty(txtParaName.Text.Trim()))
{
lblMsg.Text = "Please Enter The Test Parameter Name";
txtParaName.Focus();
return;
}
else
{
if (string.IsNullOrEmpty(txtMinPara.Text.Trim()))
{
lblMsg.Text = "Please Enter Minimum Parameter Value";
txtMinPara.Focus();
return;
}
else
{
if (string.IsNullOrEmpty(txtMaxPara.Text.Trim()))
{
lblMsg.Text = "Please Enter Maximum Parameter Value";
txtMaxPara.Focus();
return;
}
else
{
if (Convert.ToDecimal(txtMaxPara.Text) <= Convert.ToDecimal(txtMinPara.Text))
{
lblMsg.Text = "Maximum Parameter Value Can't Be Less Then Minimum Parameter Value";
txtMaxPara.Text = string.Empty;
txtMaxPara.Focus();
return;
}
else
{
entDept.TestId = Convert.ToInt32(ddlTestName.SelectedValue);
entDept.MinPara = Convert.ToDecimal(txtMinPara.Text);
entDept.MaxPara = Convert.ToDecimal(txtMaxPara.Text);
entDept.ParaName = txtParaName.Text;
if (!mobjDeptBLL.IsRecordExist(entDept))
{
lintcnt = mobjDeptBLL.InsertTestWithPara(entDept);
if (lintcnt > 0)
{
GetTestsWithPara();
lblMessage.Text = "Record Inserted Successfully....";
Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString());
}
else
{
lblMessage.Text = "Record Not Inserted...";
}
}
else
{
lblMessage.Text = "Record Already Exist....";
}
}
}
}
}
}
}
MultiView1.SetActiveView(View1);
}
