public string CreateAddress(CreateAddressRequest request)
{
try
{
DataAccess.Core.DAEmployee service = new DataAccess.Core.DAEmployee();
DataAccess.EmployeeAddress addr = new DataAccess.EmployeeAddress();
addr.Id = Guid.NewGuid();
addr.EmployeeId = new Guid("7601C88B-D5D3-47FC-8F6A-0AA1C5DBDECF");//change this with real employeeId
addr.Address = request.address;
addr.CityMun = request.cityMun;
addr.ProvState = request.provState;
//addr.CountryCode = request.country;
addr.AddressTypeCode = "Permanent";
service.CreateAddress(addr);
FormlessPage page = new FormlessPage();
var ctrl = (Payroll.Web.Pages.Employee.Address.AddressGrid)page.LoadControl("~/Pages/Employee/Address/AddressGrid.ascx");
//HtmlForm form = new HtmlForm();
////Add user control to the form
//form.Controls.Add(ctrl);
page.Controls.Add(ctrl);
return page.RenderPage();
}
catch (Exception ex)
{
return ex.Message;
}
}
void grdEmployees_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
var item = (Guid)e.Keys["Id"];
DataAccess.Core.DAEmployee service = new DataAccess.Core.DAEmployee();
service.Delete(item);
Bind();
}
void Bind()
{
DataAccess.Core.DAEmployee empService = new DataAccess.Core.DAEmployee();
var data = empService.List();
grdEmployees.DataSource = data;
grdEmployees.DataBind();
}
void BindEmployee()
{
DataAccess.Core.DAEmployee service = new DataAccess.Core.DAEmployee();
var data = service.List().Select(x =>
new {Name = string.Format("{0}, {1}",x.LastName,x.FirstName), id = x.Id }).ToList();
ddlEmployee.DataSource = data;
ddlEmployee.DataTextField = "Name";
ddlEmployee.DataValueField = "Id";
ddlEmployee.DataBind();
}
void Bind()
{
DataAccess.Core.DAEmployee empService = new DataAccess.Core.DAEmployee();
var employee = empService.GetById(Id);
txtEmployeeNumber.Text = employee.EmployeeNumber.ToString();
txtTitle.Text = employee.Title;
txtFname.Text = employee.FirstName;
txtMname.Text = employee.MiddleName;
txtLname.Text = employee.LastName;
txtAge.Text = employee.Age.ToString();
txtBirthDate.Text = employee.Birthdate.ToShortDateString();
ddlSex.SelectedValue = employee.Sex.ToString();
ddlCivilStatus.SelectedValue = employee.CivilStatus;
txtHomePhone.Text = employee.HomePhone;
txtMobile.Text = employee.MobilePhone;
txtEmail.Text = employee.Email;
//entity.PresentHomeAddressId = employee.PresentHomeAddressId;
ddlDepartment.SelectedValue = employee.DepartmentCode;
ddlPosition.SelectedValue = employee.PositionCode;
ddlTaxStatus.SelectedValue = employee.TaxStatusCode;
txtHiredDate.Text = employee.HireDate.ToShortDateString();
ddlEmployeeType.SelectedValue = employee.EmployementTypeCode;
txtSSSNumber.Text = employee.SSSNumber.ToString();
txtTIN.Text = employee.TINNumber.ToString();
txtPagIbig.Text = employee.PagIbigNumber.ToString();
txtPhilHealth.Text = employee.PhilHealthNumber.ToString();
txtSalaryRate.Text = employee.SalaryRate;
txtCurrentSalary.Text = employee.CurrentSalary.ToString();
ddlBankName.SelectedValue = employee.BankNameCode;
txtAccountNumber.Text = employee.AccountNumber.ToString();
ddlEmpStatus.SelectedValue = employee.EmployeeStatus;
var empAddress = empService.GetEmployeeAddressList(employee.Id).FirstOrDefault();
if (empAddress != null)
{
txtAddress.Text = empAddress.Address;
TxtCityMun.Text = empAddress.CityMun;
txtProvState.Text = empAddress.ProvState;
txtZipCode.Text = empAddress.ZipCode;
ddlCountry.SelectedValue = empAddress.CountryCode;
}
}
void btnSave_Click(object sender, EventArgs e)
{
try
{
DataAccess.Core.DAEmployee empService = new DataAccess.Core.DAEmployee();
var employee = empService.GetById(Id);
employee.EmployeeNumber = txtEmployeeNumber.Text.ToInteger();
employee.Title = txtTitle.Text;
employee.FirstName = txtFname.Text;
employee.MiddleName = txtMname.Text;
employee.LastName = txtLname.Text;
employee.Age = txtAge.Text.ToInteger();
employee.Birthdate = txtBirthDate.Text.ToDate();
employee.Sex = char.Parse(ddlSex.SelectedValue);
employee.CivilStatus = ddlCivilStatus.SelectedValue;
employee.HomePhone = txtHomePhone.Text;
employee.MobilePhone = txtMobile.Text;
employee.Email = txtEmail.Text;
employee.PresentHomeAddressId = Guid.NewGuid();
employee.DepartmentCode = ddlDepartment.SelectedValue;
employee.PositionCode = ddlPosition.SelectedValue;
employee.TaxStatusCode = ddlTaxStatus.SelectedValue;
employee.HireDate = txtHiredDate.Text.ToDate();
employee.EmployementTypeCode = ddlEmployeeType.SelectedValue;
employee.SSSNumber = txtSSSNumber.Text.ToInteger();
employee.TINNumber = txtTIN.Text.ToInteger();
employee.PagIbigNumber = txtPagIbig.Text.ToNullableInteger();
employee.PhilHealthNumber = txtPhilHealth.Text.ToNullableInteger();
employee.SalaryRate = txtSalaryRate.Text;
employee.CurrentSalary = txtCurrentSalary.Text.ToDecimal();
employee.BankNameCode = ddlBankName.SelectedValue;
employee.AccountNumber = txtAccountNumber.Text.ToNullableInteger();
employee.EmployeeStatus = ddlEmpStatus.SelectedValue;
DataAccess.EmployeeAddress address = empService.GetEmployeeAddressList(employee.Id).FirstOrDefault();
if (address == null)
{
address = new DataAccess.EmployeeAddress();
address.AddressTypeCode = "Permanent";
address.EmployeeId = employee.Id;
}
address.Address = txtAddress.Text;
address.CityMun = TxtCityMun.Text;
address.ProvState = string.IsNullOrEmpty(txtProvState.Text) ? null : txtProvState.Text;
address.CountryCode = string.IsNullOrEmpty(ddlCountry.SelectedValue) ? null : ddlCountry.SelectedValue;
address.ZipCode = txtZipCode.Text;
empService.Update(employee);
if (address.Id == null || address.Id == Guid.Empty)
empService.CreateAddress(address);
else
empService.UpdateEmployeeAddress(address);
SetMessage(MessageType.Succes, "Saving successfull",true);
RedirectToReferrerUrl();
}
catch (Exception ex)
{
SetMessage(MessageType.Error, string.Format("Saving failed: {0}", ex.Message));
}
}
