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; } }