public bool IsRecordExists(EntityTest entDept)
{
bool flag = false;
try
{
tblTestMaster obj = (from tbl in objData.tblTestMasters
where tbl.IsDelete == false &&
tbl.TestName.ToUpper().ToString().Trim().Equals(entDept.TestName.ToUpper().ToString().Trim())
select tbl).FirstOrDefault();
if (obj != null)
{
flag = true;
}
else
{
flag = false;
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
public bool GetTestStatus(int TestID)
{
bool flag = false;
tblTestMaster tblTest = new tblTestMaster();
tblTest = (from tbl in objData.tblTestMasters
where tbl.TestId.Equals(TestID) &&
tbl.IsRadiology == true
select tbl).FirstOrDefault();
if (tblTest != null)
{
flag = true;
}
return(flag);
}
public int Update(EntityTest entDept)
{
try
{
tblTestMaster test = (from tbl in objData.tblTestMasters
where tbl.IsDelete == false &&
tbl.TestId == entDept.TestId
select tbl).FirstOrDefault();
test.TestName = entDept.TestName;
test.TestCharge = entDept.TestCharge;
test.Precautions = entDept.Precautions;
test.IsPathology = entDept.IsPathology;
test.IsRadiology = entDept.IsRadiology;
test.TestCatId = entDept.TestCatId;
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertTest(EntityTest entDept)
{
try
{
tblTestMaster obj = new tblTestMaster()
{
Precautions = entDept.Precautions,
TestName = entDept.TestName,
TestCharge = entDept.TestCharge,
IsDelete = false,
IsPathology = entDept.IsPathology,
IsRadiology = entDept.IsRadiology,
TestCatId = entDept.TestCatId
};
objData.tblTestMasters.InsertOnSubmit(obj);
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
