public void Add(PayslipBatchDetail entity)
{
try
{
using (var dbcntx = new HrDataContext())
{
PayslipBatchDetail payslipbatchdetail = dbcntx.PayslipBatchDetails
.Where(x => x.BatchDetailId == entity.BatchDetailId).FirstOrDefault();
if (payslipbatchdetail == null)
{
dbcntx.PayslipBatchDetails.Add(entity);
dbcntx.SaveChanges();
}
else
{
payslipbatchdetail.BatchDetailId = entity.BatchDetailId;
payslipbatchdetail.BatchHeaderId = entity.BatchHeaderId;
payslipbatchdetail.BatchNo = entity.BatchNo;
payslipbatchdetail.RegisterCode = entity.RegisterCode;
payslipbatchdetail.ContributionCode = entity.ContributionCode;
payslipbatchdetail.Amount = entity.Amount;
dbcntx.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(PayslipBatchHeader entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
PayslipBatchHeader payslipBatchHeader = dbContext.PayslipBatchHeaders
.Where(x => x.BatchHeaderId == entity.BatchHeaderId).FirstOrDefault();
if (payslipBatchHeader == null)
{
dbContext.PayslipBatchHeaders.Add(entity);
dbContext.SaveChanges();
}
else
{
payslipBatchHeader.BatchHeaderId = entity.BatchHeaderId;
payslipBatchHeader.BatchNo = entity.BatchNo;
payslipBatchHeader.Month = entity.Month;
payslipBatchHeader.Year = entity.Year;
payslipBatchHeader.TotalSalary = entity.TotalSalary;
payslipBatchHeader.ProcessDate = entity.ProcessDate;
dbContext.SaveChanges();
}
}
}
catch (Exception ex)
{
throw;
}
}
public void Add(EmpSalaryStructureHeader entity)
{
using (var dbCntx = new HrDataContext())
{
EmpSalaryStructureHeader obj = dbCntx.EmpSalaryStructureHeaders
.Where(x => x.EmployeeId == entity.EmployeeId && x.BranchId == entity.BranchId)
.FirstOrDefault();
if (obj != null)
{
dbCntx.EmpSalaryStructureHeaders.Remove(obj);
}
dbCntx.EmpSalaryStructureHeaders.Add(entity);
dbCntx.SaveChanges();
//if (obj == null)
//{
// //Update(entity);
//}
//else
//{
// obj.IsActive = entity.IsActive;
// obj.ModifiedBy = entity.ModifiedBy;
// obj.ModifiedOn = entity.ModifiedOn;
// obj.Remarks = entity.Remarks;
// obj.Salary = entity.Salary;
// obj.TotalDeductions = entity.TotalDeductions;
// obj.TotalGross = entity.TotalGross;
//}
}
}
public void Add(VariablePaymentHeader entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
VariablePaymentHeader variablepaymentheader = dbContext.VariablePaymentHeaders
.Where(x => x.HeaderID == entity.HeaderID).FirstOrDefault();
if (variablepaymentheader == null)
{
dbContext.VariablePaymentHeaders.Add(entity);
}
else
{
variablepaymentheader.TransactionNo = entity.TransactionNo;
variablepaymentheader.Month = entity.Month;
variablepaymentheader.Year = entity.Year;
variablepaymentheader.Status = entity.Status;
variablepaymentheader.ModifiedBy = entity.ModifiedBy;
variablepaymentheader.ModifiedOn = entity.ModifiedOn;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(OtherLeave entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
OtherLeave OtherLeave = dbContext.OtherLeaves
.Where(x => x.BranchId == entity.BranchId && x.LeaveId == entity.LeaveId).FirstOrDefault();
if (OtherLeave == null)
{
entity.IsActive = true;
dbContext.OtherLeaves.Add(entity);
}
else
{
OtherLeave.BranchId = entity.BranchId;
OtherLeave.CarryForward = entity.CarryForward;
OtherLeave.IsCarryForward = entity.IsCarryForward;
OtherLeave.LeavesPerMonth = entity.LeavesPerMonth;
OtherLeave.LeavesPerYear = entity.LeavesPerYear;
OtherLeave.LeaveTypeId = entity.LeaveTypeId;
// OtherLeave.
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddFromLookUp(OtherLeave entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
OtherLeave OtherLeave = dbContext.OtherLeaves
.Where(x => x.BranchId == entity.BranchId && x.LeaveTypeId == entity.LeaveTypeId).FirstOrDefault();
if (OtherLeave != null)
{
//otherLeave.IsCarryForward = entity.IsCarryForward;
// otherLeave.Description = entity.Description;
//otherLeave.BranchId = entity.BranchId;
OtherLeave.BranchId = entity.BranchId;
OtherLeave.IsCarryForward = entity.IsCarryForward;
OtherLeave.LeaveTypeId = entity.LeaveTypeId;
OtherLeave.IsActive = entity.IsActive;
// OtherLeave.
dbContext.SaveChanges();
}
else
{
Add(entity);
}
}
}
catch (Exception)
{
throw;
}
}
public void AddClaimDocuments(EmployeeDocumentDetail entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
EmployeeDocumentDetail empDetail = dbContext.EmployeeDocumentDetails
.Where(x => x.EmployeeId == entity.EmployeeId && x.DocumentType == entity.DocumentType)
.FirstOrDefault();
if (empDetail == null)
{
dbContext.EmployeeDocumentDetails.Add(entity);
}
else
{
empDetail.BranchId = entity.BranchId;
//empDetail.DocumentDetailID = entity.DocumentDetailID;
empDetail.DocumentType = entity.DocumentType;
empDetail.FileName = entity.FileName;
empDetail.EmployeeId = entity.EmployeeId;
empDetail.ModifiedBy = entity.CreatedBy;
empDetail.ModifiedOn = UTILITY.SINGAPORETIME;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(VariablePaymentDetail entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
VariablePaymentDetail variablepaymentdeatil = dbContext.VariablePaymentDetails
.Where(x => x.DetailID == entity.DetailID).FirstOrDefault();
if (variablepaymentdeatil == null)
{
dbContext.VariablePaymentDetails.Add(entity);
}
else
{
variablepaymentdeatil.EmployeeId = entity.EmployeeId;
variablepaymentdeatil.ComponentCode = entity.ComponentCode;
variablepaymentdeatil.Amount = entity.Amount;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(Company entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
Company company = dbContext.Companies
.Where(x => x.CompanyId == entity.CompanyId).FirstOrDefault();
if (company == null)
{
dbContext.Companies.Add(entity);
}
else
{
company.CompanyCode = entity.CompanyCode;
company.CompanyName = entity.CompanyName;
company.CreatedBy = entity.CreatedBy;
company.CreatedOn = entity.CreatedOn;
company.InCorporationDate = entity.InCorporationDate;
company.IsActive = true;
company.RegNo = entity.RegNo;
company.ModifiedBy = entity.ModifiedBy;
company.ModifiedOn = entity.ModifiedOn;
company.SSFNumber = entity.SSFNumber;
company.TaxIdNumber = entity.TaxIdNumber;
company.BranchCode = entity.BranchCode;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(TaxAssessmentDetail entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
TaxAssessmentDetail taxassessmentdetail = dbContext.TaxAssessmentDetails
.Where(x => x.ID == entity.ID).FirstOrDefault();
if (taxassessmentdetail == null)
{
dbContext.TaxAssessmentDetails.Add(entity);
}
else
{
taxassessmentdetail.ID = entity.ID;
taxassessmentdetail.HeaderID = entity.HeaderID;
taxassessmentdetail.SalaryFrom = entity.SalaryFrom;
taxassessmentdetail.SalaryTo = entity.SalaryTo;
taxassessmentdetail.Rate = entity.Rate;
taxassessmentdetail.Maxamount = entity.Maxamount;
taxassessmentdetail.CreatedBy = entity.CreatedBy;
taxassessmentdetail.CreatedOn = entity.CreatedOn;
taxassessmentdetail.ModifiedBy = entity.ModifiedBy;
taxassessmentdetail.ModifiedOn = entity.ModifiedOn;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(Branch entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
Branch branch = dbContext.Branches
.Where(x => x.BranchID == entity.BranchID).FirstOrDefault();
if (branch == null)
{
dbContext.Branches.Add(entity);
}
else
{
branch.BranchCode = entity.BranchCode;
branch.BranchName = entity.BranchName;
branch.RegNo = entity.RegNo;
branch.CompanyCode = entity.CompanyCode;
branch.CompanyId = entity.CompanyId;
branch.BranchTaxCode = entity.BranchTaxCode;
branch.SSFNumber = entity.SSFNumber;
branch.TaxIdNumber = entity.TaxIdNumber;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(SalaryStructureHeader entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
SalaryStructureHeader salaryStructureHeader = dbContext.SalaryStructureHeaders
.Where(x => x.StructureID == entity.StructureID).FirstOrDefault();
if (salaryStructureHeader == null)
{
dbContext.SalaryStructureHeaders.Add(entity);
}
else
{
salaryStructureHeader.Code = entity.Code;
salaryStructureHeader.Remarks = entity.Remarks;
salaryStructureHeader.EffectiveDate = entity.EffectiveDate;
salaryStructureHeader.IsActive = entity.IsActive;
salaryStructureHeader.ModifiedBy = entity.ModifiedBy;
salaryStructureHeader.ModifiedOn = entity.ModifiedOn;
salaryStructureHeader.NetAmount = entity.NetAmount;
salaryStructureHeader.TotalDeductions = entity.TotalDeductions;
salaryStructureHeader.TotalGross = entity.TotalGross;
salaryStructureHeader.Description = entity.Description;
salaryStructureHeader.EmployeeId = entity.EmployeeId;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(LookUp entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
LookUp lookUp = dbContext.LookUps
.Where(x => x.LookUpID == entity.LookUpID).FirstOrDefault();
if (lookUp == null)
{
entity.IsActive = true;
dbContext.LookUps.Add(entity);
}
else
{
lookUp.IsCarryForward = entity.IsCarryForward;
lookUp.IsWeekendPolicy = entity.IsWeekendPolicy;
lookUp.LookUpCategory = entity.LookUpCategory;
lookUp.LookUpCode = entity.LookUpCode;
lookUp.LookUpDescription = entity.LookUpDescription;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(Country entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
Country country = dbContext.Countries
.Where(x => x.CountryId == entity.CountryId).FirstOrDefault();
if (country == null)
{
dbContext.Countries.Add(entity);
}
else
{
country.CountryCode = entity.CountryCode;
country.CountryName = entity.CountryName;
country.Description = entity.Description;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(Contribution entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
Contribution contribution = dbContext.Contributions
.Where(x => x.ContributionId == entity.ContributionId).FirstOrDefault();
if (contribution == null)
{
entity.IsActive = true;
dbContext.Contributions.Add(entity);
}
else
{
contribution.Description = entity.Description;
contribution.IsActive = true;
contribution.ModifiedBy = entity.ModifiedBy;
contribution.ModifiedOn = entity.ModifiedOn;
contribution.Name = entity.Name;
contribution.RegisterCode = entity.RegisterCode;
contribution.BranchId = entity.BranchId;
contribution.SortBy = entity.SortBy;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(SalaryRuleHeader entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
SalaryRuleHeader salaryRule = dbContext.SalaryRuleHeaders
.Where(x => x.RuleId == entity.RuleId).FirstOrDefault();
if (salaryRule == null)
{
dbContext.SalaryRuleHeaders.Add(salaryRule);
}
else
{
salaryRule.RuleId = entity.RuleId;
salaryRule.Category = entity.Category;
salaryRule.Code = entity.Code;
salaryRule.IsActive = entity.IsActive;
salaryRule.IsOnPayslip = entity.IsOnPayslip;
salaryRule.Name = entity.Name;
salaryRule.SequenceNo = entity.SequenceNo;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(LeaveDetail entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
LeaveDetail leaveDetail = dbContext.LeaveDetails
.Where(x => x.LeaveDetailID == entity.LeaveDetailID).FirstOrDefault();
if (leaveDetail == null)
{
leaveDetail.CreatedBy = UTILITY.SSN_USERID;
leaveDetail.CreatedOn = UTILITY.SINGAPORETIME;
dbContext.LeaveDetails.Add(leaveDetail);
}
else
{
leaveDetail.CreatedBy = UTILITY.SSN_USERID;
leaveDetail.CreatedOn = UTILITY.SINGAPORETIME;
leaveDetail.LeaveHeaderId = entity.LeaveHeaderId;
leaveDetail.LeaveType = entity.LeaveType;
leaveDetail.ModifiedBy = UTILITY.SSN_USERID;
leaveDetail.ModifiedOn = UTILITY.SINGAPORETIME;
leaveDetail.TotalLeaves = entity.TotalLeaves;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
public void Add(TaxAssessmentHeader entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
TaxAssessmentHeader taxassessmentheader = dbContext.TaxAssessmentHeaders
.Where(x => x.HeaderID == entity.HeaderID).FirstOrDefault();
if (taxassessmentheader == null)
{
dbContext.TaxAssessmentHeaders.Add(entity);
}
else
{
taxassessmentheader.HeaderID = entity.HeaderID;
taxassessmentheader.BranchID = entity.BranchID;
taxassessmentheader.AssessmentNo = entity.AssessmentNo;
taxassessmentheader.Year = entity.Year;
taxassessmentheader.SocialContributionRate = entity.SocialContributionRate;
taxassessmentheader.MaximumAmount = entity.MaximumAmount;
taxassessmentheader.Status = entity.Status;
taxassessmentheader.CreatedBy = entity.CreatedBy;
taxassessmentheader.CreatedOn = entity.CreatedOn;
taxassessmentheader.ModifiedBy = entity.ModifiedBy;
taxassessmentheader.ModifiedOn = entity.ModifiedOn;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(LeaveTran entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
LeaveTran LeaveTransaction = dbContext.LeaveTrans
.Where(x => x.TransactionId == entity.TransactionId).FirstOrDefault();
if (LeaveTransaction == null)
{
dbContext.LeaveTrans.Add(entity);
}
else
{
LeaveTransaction.BranchId = entity.BranchId;
LeaveTransaction.CreatedBy = UTILITY.SSN_USERID;
LeaveTransaction.CreatedOn = UTILITY.SINGAPORETIME;
LeaveTransaction.CurrentLeaves = entity.CurrentLeaves;
LeaveTransaction.PreviousLeaves = entity.PreviousLeaves;
LeaveTransaction.EmployeeId = entity.EmployeeId;
LeaveTransaction.FromDt = entity.FromDt;
LeaveTransaction.LeaveType = entity.LeaveType;
LeaveTransaction.ModifiedBy = UTILITY.SSN_USERID;
LeaveTransaction.ModifiedOn = UTILITY.SINGAPORETIME;
LeaveTransaction.ToDt = entity.ToDt;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(EmployeeBankdetail entity)
{
try
{
using (var dbcntx = new HrDataContext())
{
EmployeeBankdetail employeebankdetail = dbcntx.EmployeeBankdetails.
Where(x => x.BankDetailId == entity.BankDetailId).FirstOrDefault();
if (employeebankdetail == null)
{
dbcntx.EmployeeBankdetails.Add(entity);
}
else
{
employeebankdetail.EmployeeId = entity.EmployeeId;
employeebankdetail.BranchId = entity.BranchId;
employeebankdetail.BankName = entity.BankName;
employeebankdetail.AccountNo = entity.AccountNo;
employeebankdetail.AccountType = entity.AccountType;
employeebankdetail.BankBranchCode = entity.BankBranchCode;
employeebankdetail.SwiftCode = entity.SwiftCode;
}
dbcntx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(HolidayList entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
HolidayList holidayList = dbContext.HolidayLists
.Where(x => x.HolidayId == entity.HolidayId).FirstOrDefault();
if (holidayList == null)
{
dbContext.HolidayLists.Add(entity);
}
else
{
holidayList.Date = entity.Date;
holidayList.Description = entity.Description;
holidayList.CountryId = entity.CountryId;
holidayList.ModifiedBy = entity.ModifiedBy;
holidayList.ModifiedOn = entity.ModifiedOn;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Delete(EmpSalaryStructureHeader entity)
{
using (var dbCntx = new HrDataContext())
{
var obj = GetByProperty(x => x.EmployeeId == entity.EmployeeId && x.BranchId == entity.BranchId);
obj.IsActive = false;
dbCntx.SaveChanges();
}
}
private void Update(EmpSalaryStructureHeader entity)
{
using (var dbCntx = new HrDataContext())
{
var obj = GetByProperty(x => x.EmployeeId == entity.EmployeeId && x.BranchId == entity.BranchId);
obj.ModifiedBy = entity.ModifiedBy;
obj.ModifiedOn = entity.ModifiedOn;
dbCntx.SaveChanges();
}
}
public void Delete(EmpSalaryStructureDetail entity)
{
using (var dbCntx = new HrDataContext())
{
var obj = GetByProperty(x => x.EmployeeId == entity.EmployeeId && x.BranchId == entity.BranchId && x.Code == entity.Code);
if (obj != null)
{
obj.IsActive = false;
dbCntx.SaveChanges();
}
}
}
public void Update(WeekendPolicy entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult AddRole(Role role)
{
using (HrDataContext dbContext = new HrDataContext())
{
role.ModifiedBy = "Admin";
role.ModifiedOn = DateTime.Now;
role.Createdby = "Admin";
role.CreatedOn = DateTime.Now;
role.IsActive = true;
dbContext.Roles.Add(role);
dbContext.SaveChanges();
}
return(RedirectToAction("AddRole"));
}
public void Update(EmployeeBankdetail entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Add(TravelClaimDetail entity)
{
using (HrDataContext dbContext = new HrDataContext())
{
using (DbContextTransaction transaction = dbContext.Database.BeginTransaction())
{
try
{
TravelClaimDetail travelClaimDetail = dbContext.TravelClaimDetails
.Where(x => x.TravelClaimDetailId == entity.TravelClaimDetailId).FirstOrDefault();
if (travelClaimDetail == null)
{
//travelClaimDetail.CreatedBy = entity.CreatedBy;
//travelClaimDetail.CreatedOn = entity.CreatedOn;
entity.CurrencyCode = entity.Currency;
dbContext.TravelClaimDetails.Add(entity);
}
else
{
travelClaimDetail.Amount = entity.Amount;
travelClaimDetail.Category = entity.Category;
//travelClaimDetail.CreatedBy = entity.CreatedBy;
//travelClaimDetail.CreatedOn = entity.CreatedOn;
travelClaimDetail.Currency = entity.Currency;
travelClaimDetail.Perticulars = entity.Perticulars;
travelClaimDetail.ExchangeRate = entity.ExchangeRate;
travelClaimDetail.ModifiedBy = entity.CreatedBy;
travelClaimDetail.ModifiedOn = UTILITY.SINGAPORETIME;
travelClaimDetail.Receipts = entity.Receipts;
travelClaimDetail.TotalInSGD = entity.TotalInSGD;
travelClaimDetail.TravelClaimId = entity.TravelClaimId;
travelClaimDetail.TravelDate = entity.TravelDate;
travelClaimDetail.FromDate = entity.FromDate;
travelClaimDetail.TODate = entity.TODate;
travelClaimDetail.DepartureTime = entity.DepartureTime;
travelClaimDetail.CurrencyCode = entity.Currency;
}
dbContext.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public void Add(EmployeeLeaveList entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
EmployeeLeaveList leaveList = dbContext.EmployeeLeaveLists
.Where(x => x.EmployeeLeaveID == entity.EmployeeLeaveID).FirstOrDefault();
if (leaveList == null)
{
dbContext.EmployeeLeaveLists.Add(entity);
}
else
{
leaveList.BranchId = entity.BranchId;
leaveList.FromDate = entity.FromDate;
leaveList.ToDate = entity.ToDate;
leaveList.Days = entity.Days;
leaveList.EmployeeId = entity.EmployeeId; //Convert.ToInt32(UTILITY.SSN_EMPLOYEEID);
leaveList.LeaveTypeId = entity.LeaveTypeId;
leaveList.Remarks = entity.Remarks;
leaveList.Reason = entity.Reason;
leaveList.CreatedBy = entity.CreatedBy;
leaveList.CreatedOn = UTILITY.SINGAPORETIME;
leaveList.ModifiedBy = entity.ModifiedBy;
leaveList.ModifiedOn = UTILITY.SINGAPORETIME;
leaveList.ApplyDate = UTILITY.SINGAPORETIME;
if (entity.ManagerId == 0)
{
leaveList.ManagerId = 0;
}
else
{
leaveList.ManagerId = dbContext.EmployeeHeaders
.Where(x => x.EmployeeId == leaveList.EmployeeId)
.FirstOrDefault()
.ManagerId.Value;
}
leaveList.Status = entity.Status;
}
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Delete(Address entity)
{
try
{
using (HrDataContext dbContext = new HrDataContext())
{
dbContext.Addresses.Remove(entity);
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
};
}
