public bool CheckIsBasic(int AllowanceId) { bool IsBasic = false; try { tblAllowanceDeduction obj = (from tbl in objData.tblAllowanceDeductions where tbl.IsDelete == false && tbl.AllowDedId == AllowanceId && tbl.IsBasic == true select tbl).FirstOrDefault(); if (obj != null) { IsBasic = true; } else { IsBasic = false; } } catch (Exception ex) { throw ex; } return(IsBasic); }
public void Save(EntityAllowanceDeduction objInfo) { try { tblAllowanceDeduction objBatch = new tblAllowanceDeduction(); objBatch.Description = objInfo.Description; objBatch.IsFlexible = objInfo.IsFlexible; objBatch.IsFixed = objInfo.IsFixed; objBatch.IsPercentage = objInfo.IsPercentage; objBatch.Amount = objInfo.Amount; objBatch.Percentage = objInfo.Percentage; objBatch.IsAllowance = objInfo.IsAllowance; objBatch.IsDeduction = objInfo.IsDeduction; objBatch.IsBasic = objInfo.IsBasic.Value; objData.tblAllowanceDeductions.InsertOnSubmit(objBatch); objData.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void Update(EntityAllowanceDeduction objT) { try { tblAllowanceDeduction obj = (from tbl in objData.tblAllowanceDeductions where tbl.AllowDedId == objT.AllowDedId && tbl.IsDelete == false select tbl).FirstOrDefault(); obj.Description = objT.Description; obj.Amount = objT.Amount; obj.Percentage = objT.Percentage; obj.IsFlexible = objT.IsFlexible; obj.IsFixed = objT.IsFixed; obj.IsPercentage = objT.IsPercentage; obj.IsAllowance = objT.IsAllowance; obj.IsDeduction = objT.IsDeduction; objData.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public EntityAllowanceDeduction ValidateByName(EntityAllowanceDeduction objInfo) { try { tblAllowanceDeduction objBatch = (from tbl in objData.tblAllowanceDeductions where tbl.Description.ToUpper().Equals(objInfo.Description) && tbl.IsDelete == false select tbl).FirstOrDefault(); if (objBatch != null) { return(objInfo); } else { return(null); } } catch (Exception ex) { throw ex; } }