public bool CheckRecordExists(EntityChargeCategory entDept) { bool flag1 = false; try { tblChargeCategory objCharge = (from tbl in objData.tblChargeCategories where tbl.ChargeCategoryName.ToUpper().ToString().Trim().Equals(entDept.ChargeCategoryName.ToUpper().ToString().Trim()) && tbl.ChargesId == entDept.ChargesId select tbl).FirstOrDefault(); if (objCharge != null) { flag1 = true; } else { flag1 = false; } } catch (Exception ex) { throw ex; } return(flag1); }
public int InsertChargeCategory(EntityChargeCategory entDept) { try { tblChargeCategory obj = new tblChargeCategory() { ChargeCategoryName = entDept.ChargeCategoryName, IsOperation = entDept.IsOperation, IsBed = entDept.IsBed, IsConsulting = entDept.IsConsulting, IsOther = entDept.IsOther, IsICU = entDept.IsICU }; objData.tblChargeCategories.InsertOnSubmit(obj); objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public int Update(EntityChargeCategory entDept) { try { tblChargeCategory test = (from tbl in objData.tblChargeCategories where tbl.IsDelete == false && tbl.ChargesId == entDept.ChargesId select tbl).FirstOrDefault(); test.ChargesId = entDept.ChargesId; test.ChargeCategoryName = entDept.ChargeCategoryName; test.IsOperation = entDept.IsOperation; test.IsBed = entDept.IsBed; test.IsConsulting = entDept.IsConsulting; test.IsOther = entDept.IsOther; test.IsICU = entDept.IsICU; objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }