private void LoadBasicData(int employeeId)
{
EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(employeeInformationTDS);
if (employeeInformationBasicInformationGateway.Table.Rows.Count > 0)
{
// Load employee basic data
tbxFisrtName.Text = employeeInformationBasicInformationGateway.GetFirstName(employeeId);
tbxLastName.Text = employeeInformationBasicInformationGateway.GetLastName(employeeId);
tbxeMail.Text = employeeInformationBasicInformationGateway.GeteMail(employeeId);
ckbxIsSalesman.Checked = employeeInformationBasicInformationGateway.GetIsSalesman(employeeId);
ckbxRequestTimesheet.Checked = employeeInformationBasicInformationGateway.GetRequestProjectTime(employeeId);
ckbxSalaried.Checked = employeeInformationBasicInformationGateway.GetSalaried(employeeId);
ckbxAssignableSrs.Checked = employeeInformationBasicInformationGateway.GetAssignableSRS(employeeId);
tbxJobClassType.Text = employeeInformationBasicInformationGateway.GetJobClassType(employeeId);
tbxCategory.Text = employeeInformationBasicInformationGateway.GetCategory(employeeId);
tbxPersonalAgency.Text = employeeInformationBasicInformationGateway.GetPersonalAgencyName(employeeId);
ckbxVacationsManager.Checked = employeeInformationBasicInformationGateway.GetIsVacationsManager(employeeId);
ckbxApproveTimesheets.Checked = employeeInformationBasicInformationGateway.GetApproveTimesheets(employeeId);
tbxCrew.Text = employeeInformationBasicInformationGateway.GetCrew(employeeId);
string type = employeeInformationBasicInformationGateway.GetType(employeeId);
EmployeeTypeGateway employeeTypeGateway = new EmployeeTypeGateway();
employeeTypeGateway.LoadByType(type);
tbxType.Text = employeeTypeGateway.GetDescription(type);
string state = employeeInformationBasicInformationGateway.GetState(employeeId);
EmployeeStateGateway employeeStateGateway = new EmployeeStateGateway();
employeeStateGateway.LoadByState(state);
tbxState.Text = employeeStateGateway.GetDescription(state);
// Job costing factors
decimal? bourdenFactor = employeeInformationBasicInformationGateway.GetBourdenFactor(employeeId);
if (bourdenFactor.HasValue)
{
tbxBourdenFactor.Text = decimal.Round((decimal)bourdenFactor,1).ToString();
}
decimal? usHealthBenefitFactor = employeeInformationBasicInformationGateway.GetUSHealthBenefitFactor(employeeId);
if (usHealthBenefitFactor.HasValue)
{
tbxUSHealthBenefitFactor.Text = decimal.Round((decimal)usHealthBenefitFactor, 1).ToString();
}
decimal? benefitFactorCad = employeeInformationBasicInformationGateway.GetBenefitFactorCad(employeeId);
if (benefitFactorCad.HasValue)
{
tbxBenefitFactorCad.Text = decimal.Round((decimal)benefitFactorCad, 2).ToString();
}
decimal? benefitFactorUsd = employeeInformationBasicInformationGateway.GetBenefitFactorUsd(employeeId);
if (benefitFactorUsd.HasValue)
{
tbxBenefitFactorUsd.Text = decimal.Round((decimal)benefitFactorUsd, 2).ToString();
}
}
}
private void LoadBasicData(int employeeId)
{
// Load Data
EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(employeeInformationTDS);
if (employeeInformationBasicInformationGateway.Table.Rows.Count > 0)
{
// Load employee basic data
tbxFisrtName.Text = employeeInformationBasicInformationGateway.GetFirstName(employeeId);
tbxLastName.Text = employeeInformationBasicInformationGateway.GetLastName(employeeId);
tbxeMail.Text = employeeInformationBasicInformationGateway.GeteMail(employeeId);
ckbxIsSalesman.Checked = employeeInformationBasicInformationGateway.GetIsSalesman(employeeId);
ckbxRequestTimesheet.Checked = employeeInformationBasicInformationGateway.GetRequestProjectTime(employeeId);
ckbxSalaried.Checked = employeeInformationBasicInformationGateway.GetSalaried(employeeId);
ckbxAssignableSrs.Checked = employeeInformationBasicInformationGateway.GetAssignableSRS(employeeId);
ddlType.SelectedValue = employeeInformationBasicInformationGateway.GetType(employeeId);
ddlState.SelectedValue = employeeInformationBasicInformationGateway.GetState(employeeId);
ddlCategory.SelectedValue = employeeInformationBasicInformationGateway.GetCategory(employeeId);
ddlPersonalAgency.SelectedValue = employeeInformationBasicInformationGateway.GetPersonalAgencyName(employeeId);
ckbxVacationsManager.Checked = employeeInformationBasicInformationGateway.GetIsVacationsManager(employeeId);
ckbxApproveTimesheets.Checked = employeeInformationBasicInformationGateway.GetApproveTimesheets(employeeId);
if (employeeInformationBasicInformationGateway.GetCrew(employeeId) != "")
{
ddlCrew.SelectedValue = employeeInformationBasicInformationGateway.GetCrew(employeeId);
}
else
{
ddlCrew.SelectedIndex = 0;
}
if (employeeInformationBasicInformationGateway.GetType(employeeId).Contains("CA"))
{
ProjectTimeJobClassTypeList projectTimeJobClassTypeList = new ProjectTimeJobClassTypeList();
projectTimeJobClassTypeList.LoadAndAddItem(1, 3, "");
ddlJobClassType.DataSource = projectTimeJobClassTypeList.Table;
ddlJobClassType.DataValueField = "JobClassType";
ddlJobClassType.DataTextField = "JobClassType";
ddlJobClassType.DataBind();
}
else
{
ProjectTimeJobClassTypeList projectTimeJobClassTypeList = new ProjectTimeJobClassTypeList();
projectTimeJobClassTypeList.LoadAndAddItem(2, 3, "");
ddlJobClassType.DataSource = projectTimeJobClassTypeList.Table;
ddlJobClassType.DataValueField = "JobClassType";
ddlJobClassType.DataTextField = "JobClassType";
ddlJobClassType.DataBind();
}
ddlJobClassType.SelectedValue = employeeInformationBasicInformationGateway.GetJobClassType(employeeId);
// Job costing factors
decimal? bourdenFactor = employeeInformationBasicInformationGateway.GetBourdenFactor(employeeId);
if (bourdenFactor.HasValue)
{
tbxBourdenFactor.Text = decimal.Round((decimal)bourdenFactor, 1).ToString();
}
decimal? usHealthBenefitFactor = employeeInformationBasicInformationGateway.GetUSHealthBenefitFactor(employeeId);
if (usHealthBenefitFactor.HasValue)
{
tbxUSHealthBenefitFactor.Text = decimal.Round((decimal)usHealthBenefitFactor, 1).ToString();
}
decimal? benefitFactorCad = employeeInformationBasicInformationGateway.GetBenefitFactorCad(employeeId);
if (benefitFactorCad.HasValue)
{
tbxBenefitFactorCad.Text = decimal.Round((decimal)benefitFactorCad, 2).ToString();
}
decimal? benefitFactorUsd = employeeInformationBasicInformationGateway.GetBenefitFactorUsd(employeeId);
if (benefitFactorUsd.HasValue)
{
tbxBenefitFactorUsd.Text = decimal.Round((decimal)benefitFactorUsd, 2).ToString();
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_VACATIONS_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in vacations_all.aspx");
}
// Tag page
int companyId = Int32.Parse(Session["companyID"].ToString());
hdfCompanyId.Value = companyId.ToString();
// ... For non vacation managers
EmployeeGateway employeeGatewayManager = new EmployeeGateway();
int employeeIdNow = employeeGatewayManager.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
employeeGatewayManager.LoadByEmployeeId(employeeIdNow);
if (employeeGatewayManager.GetIsVacationsManager(employeeIdNow))
{
hdfIsVacationManager.Value = "True";
}
else
{
hdfIsVacationManager.Value = "False";
}
// Initialize values
DropDownList ddlVacationsFor = (DropDownList)tkrpbLeftMenuAllVacations.FindItemByValue("nbVacationsForDDL").FindControl("ddlVacationsFor");
EmployeeList employeeList = new EmployeeList();
string employeeTypeNow = employeeGatewayManager.GetType(employeeIdNow);
if (employeeTypeNow.Contains("CA"))
{
employeeList.LoadBySalariedEmployeeTypeAndAddItem(1, "CA", -1, "(All)");
}
else
{
employeeList.LoadBySalariedEmployeeTypeAndAddItem(1, "US", -1, "(All)");
}
ddlVacationsFor.DataSource = employeeList.Table;
ddlVacationsFor.DataValueField = "EmployeeID";
ddlVacationsFor.DataTextField = "FullName";
ddlVacationsFor.DataBind();
//... date_to_show
if ((string)Request.QueryString["date_to_show"] == null)
{
ViewState["date_to_show"] = DateTime.Now.ToString();
}
else
{
ViewState["date_to_show"] = (string)Request.QueryString["date_to_show"];
}
// Load vacations
vacationsInformationTDS = new VacationsInformationTDS();
vacationsInformation = new VacationsInformationTDS.VacationsInformationDataTable();
VacationsInformationGateway vacationsInformationGateway = new VacationsInformationGateway(vacationsInformationTDS);
if (hdfIsVacationManager.Value == "False")
{
EmployeeGateway employeeGateway1 = new EmployeeGateway();
ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway();
employeeInformationBasicInformationGateway.LoadByEmployeeId(Int32.Parse(ViewState["employee_id"].ToString()));
string employeeType = employeeInformationBasicInformationGateway.GetType(Int32.Parse(ViewState["employee_id"].ToString()));
if (employeeType.Contains("CA"))
{
ddlWorkingLocation.SelectedValue = "CA";
}
else
{
ddlWorkingLocation.SelectedValue = "US";
}
vacationsInformationGateway.LoadByEmployeeIdEmployeeType(Int32.Parse(ViewState["employee_id"].ToString()), employeeType, companyId);
}
else
{
if ((string)Request.QueryString["employee_id"] == null)
{
ViewState["employee_id"] = "-1";
if (employeeTypeNow.Contains("CA"))
{
ddlWorkingLocation.SelectedValue = "CA";
}
else
{
ddlWorkingLocation.SelectedValue = "US";
}
vacationsInformationGateway.LoadByEmployeeType(employeeTypeNow, companyId);
}
else
{
ViewState["employee_id"] = (string)Request.QueryString["employee_id"];
EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway();
employeeInformationBasicInformationGateway.LoadByEmployeeId(Int32.Parse(ViewState["employee_id"].ToString()));
string employeeType = employeeInformationBasicInformationGateway.GetType(Int32.Parse(ViewState["employee_id"].ToString()));
if (employeeTypeNow.Contains("CA"))
{
ddlWorkingLocation.SelectedValue = "CA";
}
else
{
ddlWorkingLocation.SelectedValue = "US";
}
vacationsInformationGateway.LoadByEmployeeIdEmployeeType(Int32.Parse(ViewState["employee_id"].ToString()), employeeType, companyId);
ddlVacationsFor.SelectedValue = ViewState["employee_id"].ToString();
}
}
Session["vacationsInformationTDS"] = vacationsInformationTDS;
Session["vacationsInformation"] = vacationsInformationTDS.VacationsInformation;
tkrsVacations.SelectedDate = DateTime.Parse(ViewState["date_to_show"].ToString());
lblTitle.Text = "Vacations Calendar for " + tkrsVacations.SelectedDate.ToString("MMMM") + " " + tkrsVacations.SelectedDate.Year.ToString();
// Databind
Page.DataBind();
// For Open Vacation event
if ((Request.Params["__EVENTTARGET"]) == "openVacation")
{
int vacationId = Int32.Parse(Request.Params.Get("__EVENTARGUMENT").ToString()) ;
VacationsInformationDaysInformationGateway vacationsInformationDaysInformationGateway = new VacationsInformationDaysInformationGateway();
vacationsInformationDaysInformationGateway.LoadByVacationId(vacationId, companyId);
int requestId = vacationsInformationDaysInformationGateway.GetRequestID(vacationId);
Session["ddlVacationsForSelectedValue"] = ddlVacationsFor.SelectedValue;
Response.Redirect("./vacations_summary.aspx?source_page=vacations_all.aspx&vacation_id=" + vacationId.ToString() + "&request_id=" + requestId.ToString() + "&date_to_show=" + ViewState["date_to_show"]);
}
}
else
{
vacationsInformationTDS = (VacationsInformationTDS)Session["vacationsInformationTDS"];
vacationsInformation = (VacationsInformationTDS.VacationsInformationDataTable)Session["vacationsInformation"];
// For Open Vacation event
if ((Request.Params["__EVENTTARGET"]) == "openVacation")
{
int vacationId = Int32.Parse(Request.Params.Get("__EVENTARGUMENT").ToString());
VacationsInformationDaysInformationGateway vacationsInformationDaysInformationGateway = new VacationsInformationDaysInformationGateway();
vacationsInformationDaysInformationGateway.LoadByVacationId(vacationId, Int32.Parse(hdfCompanyId.Value));
int requestId = vacationsInformationDaysInformationGateway.GetRequestID(vacationId);
DropDownList ddlVacationsFor = (DropDownList)tkrpbLeftMenuAllVacations.FindItemByValue("nbVacationsForDDL").FindControl("ddlVacationsFor");
Session["ddlVacationsForSelectedValue"] = ddlVacationsFor.SelectedValue;
Response.Redirect("./vacations_summary.aspx?source_page=vacations_all.aspx&vacation_id=" + vacationId.ToString() + "&request_id=" + requestId.ToString() + "&date_to_show=" + ViewState["date_to_show"]);
}
}
}
/// <summary>
/// Save
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId)
{
EmployeeInformationTDS employeeInformationChanges = (EmployeeInformationTDS)Data.GetChanges();
if (employeeInformationChanges.BasicInformation.Rows.Count > 0)
{
EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(employeeInformationChanges);
// Update employee
foreach (EmployeeInformationTDS.BasicInformationRow basicInformationRow in (EmployeeInformationTDS.BasicInformationDataTable)employeeInformationChanges.BasicInformation)
{
// Unchanged values
int employeeId = basicInformationRow.EmployeeID;
int? loginId = null; if(!basicInformationRow.IsLoginIDNull()) loginId = basicInformationRow.LoginID;
int? contactsId = null; if (!basicInformationRow.IsContactsIDNull()) contactsId = basicInformationRow.ContactsID;
string middleInitial = ""; if (!basicInformationRow.IsMiddleInitialNull()) middleInitial = basicInformationRow.MiddleInitial;
bool deleted = basicInformationRow.Deleted;
decimal? bourdenFactor = null; if (!basicInformationRow.IsBourdenFactorNull()) bourdenFactor = (decimal)basicInformationRow.BourdenFactor;
decimal? usHealthBenefitFactor = null; if (!basicInformationRow.IsUSHealthBenefitFactorNull()) usHealthBenefitFactor = (decimal)basicInformationRow.USHealthBenefitFactor;
decimal? benefitFactorCad = null; if (!basicInformationRow.IsBenefitFactorCadNull()) benefitFactorCad = (decimal)basicInformationRow.BenefitFactorCad;
decimal? benefitFactorUsd = null; if (!basicInformationRow.IsBenefitFactorUsdNull()) benefitFactorUsd = (decimal)basicInformationRow.BenefitFactorUsd;
// Original values
string originalFirstName = employeeInformationBasicInformationGateway.GetFirstNameOriginal(employeeId);
string originalLastName = employeeInformationBasicInformationGateway.GetLastNameOriginal(employeeId);
string originalFullName = originalFirstName + ' ' + originalLastName;
string originalType = employeeInformationBasicInformationGateway.GetTypeOriginal(employeeId);
string originalState = employeeInformationBasicInformationGateway.GetStateOriginal(employeeId);
bool originalIsSalessman = employeeInformationBasicInformationGateway.GetIsSalesmanOriginal(employeeId);
bool originalRequestProjectTime = employeeInformationBasicInformationGateway.GetRequestProjectTimeOriginal(employeeId);
bool originalSalaried = employeeInformationBasicInformationGateway.GetSalariedOriginal(employeeId);
string originalEMail = employeeInformationBasicInformationGateway.GeteMailOriginal(employeeId);
bool originalAssignableSrs = employeeInformationBasicInformationGateway.GetAssignableSRSOriginal(employeeId);
string originalJobClassType = employeeInformationBasicInformationGateway.GetJobClassTypeOriginal(employeeId);
string originalCategory = employeeInformationBasicInformationGateway.GetCategoryOriginal(employeeId);
string originalPersonalAgencyName = employeeInformationBasicInformationGateway.GetPersonalAgencyNameOriginal(employeeId);
bool originalIsVacationsManager = employeeInformationBasicInformationGateway.GetIsVacationsManagerOriginal(employeeId);
bool originalApproveTimesheets = employeeInformationBasicInformationGateway.GetApproveTimesheetsOriginal(employeeId);
string originalCrew = employeeInformationBasicInformationGateway.GetCrewOriginal(employeeId);
// New variables
string newFirstName = employeeInformationBasicInformationGateway.GetFirstName(employeeId);
string newLastName = employeeInformationBasicInformationGateway.GetLastName(employeeId);
string newFullName = newFirstName + ' ' + newLastName;
string newType = employeeInformationBasicInformationGateway.GetType(employeeId);
string newState = employeeInformationBasicInformationGateway.GetState(employeeId);
bool newIsSalessman = employeeInformationBasicInformationGateway.GetIsSalesman(employeeId);
bool newRequestProjectTime = employeeInformationBasicInformationGateway.GetRequestProjectTime(employeeId);
bool newSalaried = employeeInformationBasicInformationGateway.GetSalaried(employeeId);
string newEMail = employeeInformationBasicInformationGateway.GeteMail(employeeId);
bool newAssignableSrs = employeeInformationBasicInformationGateway.GetAssignableSRS(employeeId);
string newJobClassType = employeeInformationBasicInformationGateway.GetJobClassType(employeeId);
string newCategory = employeeInformationBasicInformationGateway.GetCategory(employeeId);
string newPersonalAgencyName = employeeInformationBasicInformationGateway.GetPersonalAgencyName(employeeId);
bool newIsVacationsManager = employeeInformationBasicInformationGateway.GetIsVacationsManager(employeeId);
bool newApproveTimesheets = employeeInformationBasicInformationGateway.GetApproveTimesheets(employeeId);
string newCrew = employeeInformationBasicInformationGateway.GetCrew(employeeId);
// ... Update
Employee employee = new Employee(null);
employee.UpdateDirect(employeeId, loginId, contactsId, originalFullName, originalFirstName, middleInitial, originalLastName, originalType, originalState, originalIsSalessman, originalRequestProjectTime, deleted, originalSalaried, originalEMail, originalAssignableSrs, originalJobClassType, originalCategory, originalPersonalAgencyName, originalIsVacationsManager, originalApproveTimesheets, bourdenFactor, usHealthBenefitFactor, benefitFactorCad, benefitFactorUsd, originalCrew, newFullName, newFirstName, middleInitial, newLastName, newType, newState, newIsSalessman, newRequestProjectTime, deleted, newSalaried, newEMail, newAssignableSrs, newJobClassType, newCategory, newPersonalAgencyName, newIsVacationsManager, newApproveTimesheets, bourdenFactor, usHealthBenefitFactor, benefitFactorCad, benefitFactorUsd, newCrew);
}
}
}
/// <summary>
/// GetAllCategoryManagers
/// </summary>
/// <param name="category">category</param>
/// <param name="employeeId">employeeId</param>
/// <returns>All Category Managers</returns>
public string GetAllCategoryManagers(string category, int employeeId)
{
string allCategoryManagers = "";
EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway();
employeeInformationBasicInformationGateway.LoadByEmployeeId(employeeId);
string employeeType = "";
if (employeeInformationBasicInformationGateway.GetType(employeeId).Contains("CA"))
{
employeeType = "%CA";
}
else
{
employeeType = "%US";
}
EmployeeGateway employeeGateway = new EmployeeGateway(Data);
employeeGateway.LoadApproveManagersByCategoryType(category, employeeType);
foreach (EmployeeTDS.LFS_RESOURCES_EMPLOYEERow row in (EmployeeTDS.LFS_RESOURCES_EMPLOYEEDataTable)Table)
{
if (allCategoryManagers.Length > 0)
{
allCategoryManagers = allCategoryManagers + ", " + row.LastName + " " + row.FirstName;
}
else
{
allCategoryManagers = allCategoryManagers + row.LastName + " " + row.FirstName;
}
}
//if (allCategoryManagers[allCategoryManagers.Length-1] == ',')
//{
// allCategoryManagers = allCategoryManagers.Substring(0, allCategoryManagers.Length - 2);
//}
return allCategoryManagers;
}
