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