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