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