public void Delete(Guid id) { PayrollDataContext context = new PayrollDataContext(); var tax = context.TaxTables.Where(x => x.Id == id).FirstOrDefault(); tax.IsDeleted = true; context.SubmitChanges(); }
public void Update(TaxTable taxtable) { PayrollDataContext context = new PayrollDataContext(); var tax = context.TaxTables.Where(x=> x.Id == taxtable.Id).FirstOrDefault(); tax.TaxCode = taxtable.TaxCode; tax.Description = taxtable.Description; tax.Exemption = taxtable.Exemption; context.SubmitChanges(); }
public Guid Create(TaxTable taxtable) { PayrollDataContext context = new PayrollDataContext(); if (taxtable.Id == Guid.Empty) taxtable.Id = Guid.NewGuid(); context.TaxTables.InsertOnSubmit(taxtable); context.SubmitChanges(); return taxtable.Id; }
public void Update(EmployeeTimeSheet time) { PayrollDataContext context = new PayrollDataContext(); var timesheet = context.EmployeeTimeSheets.Where(x => x.Id == time.Id).FirstOrDefault(); timesheet.ReportedDate = time.ReportedDate; timesheet.DateTimeIn = time.DateTimeIn; timesheet.DateTimeOut = time.DateTimeOut; context.SubmitChanges(); }
public Guid Create(EmployeeTimeSheet time) { PayrollDataContext context = new PayrollDataContext(); if (time.Id == Guid.Empty) time.Id = Guid.NewGuid(); time.IsDeleted = false; context.EmployeeTimeSheets.InsertOnSubmit(time); context.SubmitChanges(); return time.Id; }
public void Delete(Guid id) { try { PayrollDataContext context = new PayrollDataContext(); var entity = context.Employees.Where(x => x.Id == id).FirstOrDefault(); entity.IsDeleted = true; context.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public Guid Create(Employee entity) { try { PayrollDataContext context = new PayrollDataContext(); if (entity.Id == Guid.Empty) entity.Id = Guid.NewGuid(); context.Employees.InsertOnSubmit(entity); context.SubmitChanges(); } catch(Exception ex) { throw ex; } return entity.Id; }
public List<Entity.TimeSheet> GetListByEmployee(Guid employeeId, DateTime startDate, DateTime endDate) { PayrollDataContext context = new PayrollDataContext(); return context.GetTimeSheetByEmployee(employeeId, startDate, endDate) .Select(x => new Entity.TimeSheet() { Id = x.id.HasValue ? x.id.Value : Guid.Empty, EmployeeId = x.EmployeeId.HasValue ? x.EmployeeId.Value: Guid.Empty, ReportedDate = x.ReportedDate.Value, DateTimeIn = x.DateTimeIn, DateTimeOut = x.DateTimeOut, Remarks = x.Remarks }) .ToList(); //return context.EmployeeTimeSheets.Where(x=> x.IsDeleted == false && x.EmployeeId == employeeId).ToList(); }
public void CreateAddress(EmployeeAddress address) { try { PayrollDataContext context = new PayrollDataContext(); if (address.Id == Guid.Empty) address.Id = Guid.NewGuid(); if (address.EmployeeId == Guid.Empty) throw new Exception("Cannot add address to empty employee id"); context.EmployeeAddresses.InsertOnSubmit(address); context.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void Update(Employee employee) { try { PayrollDataContext context = new PayrollDataContext(); if (employee.Id == Guid.Empty) return; var entity = context.Employees.Where(x => x.Id == employee.Id).FirstOrDefault(); entity.EmployeeNumber = employee.EmployeeNumber; entity.Title = employee.Title; entity.FirstName = employee.FirstName; entity.MiddleName = employee.MiddleName; entity.LastName = employee.LastName; entity.Age = employee.Age; entity.Birthdate = employee.Birthdate; entity.Sex = employee.Sex; entity.CivilStatus = employee.CivilStatus; entity.HomePhone = employee.HomePhone; entity.MobilePhone = employee.MobilePhone; entity.Email = employee.Email; entity.PresentHomeAddressId = employee.PresentHomeAddressId; entity.DepartmentCode = employee.DepartmentCode; entity.PositionCode = employee.PositionCode; entity.TaxStatusCode = employee.TaxStatusCode; entity.HireDate = employee.HireDate; entity.EmployementTypeCode = employee.EmployementTypeCode; entity.SSSNumber = employee.SSSNumber; entity.TINNumber = employee.TINNumber; entity.PagIbigNumber = employee.PagIbigNumber; entity.PhilHealthNumber = employee.PhilHealthNumber; entity.SalaryRate = employee.SalaryRate; entity.CurrentSalary = employee.CurrentSalary; entity.BankNameCode = employee.BankNameCode; entity.AccountNumber = employee.AccountNumber; entity.EmployeeStatus = employee.EmployeeStatus; context.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public List<Employee> List() { PayrollDataContext context = new PayrollDataContext(); return context.Employees.Where(x => x.IsDeleted == false).ToList(); }
public List<EmployeeAddress> GetEmployeeAddressList(Guid employeeId) { PayrollDataContext context = new PayrollDataContext(); return context.EmployeeAddresses.Where(x => x.EmployeeId == employeeId).ToList(); }
public Employee GetById(Guid id) { PayrollDataContext context = new PayrollDataContext(); return context.Employees.Where(x => x.Id == id).FirstOrDefault(); }
public Employee FindByEmployeeNumber(int employeeNumber) { PayrollDataContext context = new PayrollDataContext(); return context.Employees.Where(x => x.EmployeeNumber == employeeNumber).FirstOrDefault(); }
public void UpdateEmployeeAddress(EmployeeAddress address) { PayrollDataContext context = new PayrollDataContext(); var newAddress = context.EmployeeAddresses.Where(x => x.Id == address.Id).FirstOrDefault(); newAddress.Address = address.Address; newAddress.CityMun = address.CityMun; newAddress.ProvState = address.ProvState; newAddress.CountryCode = address.CountryCode; newAddress.ZipCode = address.ZipCode; context.SubmitChanges(); }
public List<TaxTable> List() { PayrollDataContext context = new PayrollDataContext(); return context.TaxTables.ToList(); }