/// <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;
}
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();
}
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm6 master = (mForm6)this.Master;
master.ActiveToolbar = "Resources";
// Cost information only visible for admin
tpGeneralData.Visible = true;
if (!Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_ADMIN"]))
{
tpGeneralData.Visible = false;
tkrpbLeftMenuTools.Items[0].Items[0].Visible = false; // Personnel Agencies
}
if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_VACATIONS_HOLIDAY_FULL_EDITING"])))
{
tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; // Vacations Setup
}
// For vacation error message
EmployeeInformationPayVacationDaysInformationList employeeInformationPayVacationDaysInformationList = new EmployeeInformationPayVacationDaysInformationList();
employeeInformationPayVacationDaysInformationList.LoadByEmployeeId(Int32.Parse(hdfCurrentEmployeeId.Value));
if (employeeInformationPayVacationDaysInformationList.Table.Rows.Count < 1)
{
lblNoExistVacations.Visible = true;
}
// For job costing error message
int employeeId = Int32.Parse(hdfCurrentEmployeeId.Value);
EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(employeeInformationTDS);
decimal? bourdenFactor = employeeInformationBasicInformationGateway.GetBourdenFactor(employeeId);
decimal? usHealthBenefitFactor = employeeInformationBasicInformationGateway.GetUSHealthBenefitFactor(employeeId);
decimal? benefitFactorCad = employeeInformationBasicInformationGateway.GetBenefitFactorCad(employeeId);
decimal? benefitFactorUsd = employeeInformationBasicInformationGateway.GetBenefitFactorUsd(employeeId);
if ((!bourdenFactor.HasValue) || (!usHealthBenefitFactor.HasValue) || (!benefitFactorCad.HasValue) || (!benefitFactorUsd.HasValue))
{
lblJoxCostingFactorsError.Visible = true;
}
}
protected void grdProjectTime_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Footer Item
if (e.Row.RowType == DataControlRowType.Footer)
{
EmployeeInformationBasicInformationGateway employeeInformationBasicInformation = new EmployeeInformationBasicInformationGateway();
employeeInformationBasicInformation.LoadByEmployeeId(Int32.Parse(hdfEmployeeID.Value));
string jobClassType = employeeInformationBasicInformation.GetJobClassType(Int32.Parse(hdfEmployeeID.Value));
if (jobClassType != "")
{
try
{
((DropDownList)e.Row.FindControl("ddlJobClassTypeFooter")).SelectedValue = jobClassType;
}
catch
{
}
}
}
// Edit Item
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
int projectTimeId = Int32.Parse(((Label)e.Row.FindControl("lblProjectTimeIdEdit")).Text.Trim());
ProjectTimeTempGateway projectTimeTempGateway = new ProjectTimeTempGateway(projectTimeTDS);
// For Start Time
string startTime = ""; if (projectTimeTempGateway.GetStartTime(projectTimeId) != "") startTime = projectTimeTempGateway.GetStartTime(projectTimeId);
if (startTime != "")
{
string[] hoursMin1 = startTime.Split(':');
((DropDownList)e.Row.FindControl("ddlStartTimeHourEdit")).SelectedValue = hoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlStartTimeMinuteEdit")).SelectedValue = hoursMin1[1].Trim();
}
// For End Time
string endTime = ""; if (projectTimeTempGateway.GetEndTime(projectTimeId) != "") endTime = projectTimeTempGateway.GetEndTime(projectTimeId);
if (endTime != "")
{
string[] endHoursMin1 = endTime.Split(':');
((DropDownList)e.Row.FindControl("ddlEndTimeHourEdit")).SelectedValue = endHoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlEndTimeMinuteEdit")).SelectedValue = endHoursMin1[1].Trim();
}
// For Type of work
string workFunctionConcat = projectTimeTempGateway.GetWorkFunctionConcat(projectTimeId);
((DropDownList)e.Row.FindControl("ddlTypeOfWorkFunctionEdit")).SelectedValue = workFunctionConcat;
// For UnitId
int? unitId = null; if (projectTimeTempGateway.GetUnitId(projectTimeId).HasValue) unitId = (int)projectTimeTempGateway.GetUnitId(projectTimeId);
if (unitId.HasValue)
{
((DropDownList)e.Row.FindControl("ddlUnitEdit")).SelectedValue = ((int)unitId).ToString();
}
// For TowedId
int? towedId = null; if (projectTimeTempGateway.GetTowedUnitId(projectTimeId).HasValue) towedId = (int)projectTimeTempGateway.GetTowedUnitId(projectTimeId);
if (towedId.HasValue)
{
((DropDownList)e.Row.FindControl("ddlTowedEdit")).SelectedValue = ((int)towedId).ToString();
}
string jobClassType = projectTimeTempGateway.GetJobClassType(projectTimeId);
if (jobClassType != "")
{
try
{
((DropDownList)e.Row.FindControl("ddlJobClassTypeEdit")).SelectedValue = jobClassType;
}
catch
{
}
}
}
}
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();
}
}
}
/// <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);
}
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadByEmployeeId
/// </summary>
/// <param name="employeeId">employeeId</param>
/// <param name="companyId">companyId</param>
public void LoadByEmployeeId(int employeeId, int companyId)
{
EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(Data);
employeeInformationBasicInformationGateway.LoadByEmployeeId(employeeId);
}
// ////////////////////////////////////////////////////////////////////////
// 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"]);
}
}
}
protected void grdProjectTime_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
// For Start Time
if (!string.IsNullOrEmpty(hdfStartTime.Value))
{
string startTime = DateTime.Parse(hdfStartTime.Value).ToString("H:mm");
if (startTime != "")
{
string[] hoursMin1 = startTime.Split(':');
((DropDownList)e.Row.FindControl("ddlStartTimeHourFooter")).SelectedValue = hoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlStartTimeMinuteFooter")).SelectedValue = hoursMin1[1].Trim();
}
}
// For End Time
if (!string.IsNullOrEmpty(hdfEndTime.Value))
{
string endTime = DateTime.Parse(hdfEndTime.Value).ToString("H:mm");
if (endTime != "")
{
string[] endHoursMin1 = endTime.Split(':');
((DropDownList)e.Row.FindControl("ddlEndTimeHourFooter")).SelectedValue = endHoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlEndTimeMinuteFooter")).SelectedValue = endHoursMin1[1].Trim();
}
}
// For Lunch
string lunch = hdfOffset.Value;
if (lunch != "")
{
((DropDownList)e.Row.FindControl("ddlLunchFooter")).SelectedValue = lunch;
}
// For Type Of Work
string workFunctionConcat = hdfWorkFunctionConcat.Value;
((DropDownList)e.Row.FindControl("ddlTypeOfWorkFooter")).SelectedValue = workFunctionConcat;
// For Meals Allowance
//string isMealsAllowance = hdfIsMealsAllowance.Value;
//((CheckBox)e.Row.FindControl("ckbxMealsAllowanceFooter")).Checked = Boolean.Parse(isMealsAllowance);
// For Job Class
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(Int32.Parse(ddlProject.SelectedValue));
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
int employeeId = Int32.Parse(((DropDownList)e.Row.FindControl("ddlEmployeesFooter")).SelectedValue);
EmployeeInformationBasicInformationGateway employeeInformationBasicInformation = new EmployeeInformationBasicInformationGateway();
employeeInformationBasicInformation.LoadByEmployeeId(employeeId);
string jobClassType = employeeInformationBasicInformation.GetJobClassType(employeeId);
if (jobClassType != "")
{
((DropDownList)e.Row.FindControl("ddlJobClassTypeFooter")).SelectedValue = jobClassType;
}
}
}
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
int teamProjectTimeId = Int32.Parse(((Label)e.Row.FindControl("lblTeamProjectTimeIdEdit")).Text.Trim());
int detailId = Int32.Parse(((Label)e.Row.FindControl("lblDetailIdEdit")).Text.Trim());
TeamProjectTime2DetailGateway teamProjectTime2DetailGateway = new TeamProjectTime2DetailGateway(teamProjectTime2TDS);
// For employee
int employeeId = 0; if (teamProjectTime2DetailGateway.GetEmployeeId(teamProjectTimeId, detailId) != -1) employeeId = teamProjectTime2DetailGateway.GetEmployeeId(teamProjectTimeId, detailId);
if (employeeId != -1)
{
((DropDownList)e.Row.FindControl("ddlEmployeesEdit")).SelectedValue = employeeId.ToString();
}
// For Start Time
string startTime = ""; if (teamProjectTime2DetailGateway.GetStartTime(teamProjectTimeId, detailId) != "") startTime = DateTime.Parse(teamProjectTime2DetailGateway.GetStartTime(teamProjectTimeId, detailId)).ToString("H:mm"); ;
if (startTime != "")
{
string[] hoursMin1 = startTime.Split(':');
((DropDownList)e.Row.FindControl("ddlStartTimeHourEdit")).SelectedValue = hoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlStartTimeMinuteEdit")).SelectedValue = hoursMin1[1].Trim();
}
// For End Time
string endTime = ""; if (teamProjectTime2DetailGateway.GetEndTime(teamProjectTimeId, detailId) != "") endTime = DateTime.Parse(teamProjectTime2DetailGateway.GetEndTime(teamProjectTimeId, detailId)).ToString("H:mm");;
if (endTime != "")
{
string[] endHoursMin1 = endTime.Split(':');
((DropDownList)e.Row.FindControl("ddlEndTimeHourEdit")).SelectedValue = endHoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlEndTimeMinuteEdit")).SelectedValue = endHoursMin1[1].Trim();
}
// For Type Of Work
string work_ = teamProjectTime2DetailGateway.GetWork(teamProjectTimeId, detailId);
string function_ = teamProjectTime2DetailGateway.GetFunction(teamProjectTimeId, detailId);
((DropDownList)e.Row.FindControl("ddlTypeOfWorkFunctionEdit")).SelectedValue = work_ + " . " + function_;
string jobClass = teamProjectTime2DetailGateway.GetJobClassType(teamProjectTimeId, detailId);
((DropDownList)e.Row.FindControl("ddlJobClassTypeEdit")).SelectedValue = jobClass;
// For Unit
int? unitId = null; if (teamProjectTime2DetailGateway.GetUnitId(teamProjectTimeId, detailId).HasValue) unitId = (int)teamProjectTime2DetailGateway.GetUnitId(teamProjectTimeId, detailId);
if (unitId.HasValue)
{
((DropDownList)e.Row.FindControl("ddlUnitEdit")).SelectedValue = ((int)unitId).ToString();
}
// For Towed
int? towedId = null; if (teamProjectTime2DetailGateway.GetTowedUnitId(teamProjectTimeId, detailId).HasValue) towedId = (int)teamProjectTime2DetailGateway.GetTowedUnitId(teamProjectTimeId, detailId);
if (towedId.HasValue)
{
((DropDownList)e.Row.FindControl("ddlTowedEdit")).SelectedValue = ((int)towedId).ToString();
}
}
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate))))
{
int teamProjectTimeId = Int32.Parse(((Label)e.Row.FindControl("lblTeamProjectTimeId")).Text.Trim());
int detailId = Int32.Parse(((Label)e.Row.FindControl("lblDetailId")).Text.Trim());
TeamProjectTime2DetailGateway teamProjectTime2DetailGateway = new TeamProjectTime2DetailGateway(teamProjectTime2TDS);
// For Start Time
string startTime = "";
try
{
if (teamProjectTime2DetailGateway.GetStartTime(teamProjectTimeId, detailId) != "") startTime = DateTime.Parse(teamProjectTime2DetailGateway.GetStartTime(teamProjectTimeId, detailId)).ToString("H:mm"); ;
}
catch
{
}
if (startTime != "")
{
((TextBox)e.Row.FindControl("tbxStartTime")).Text = startTime;
}
// For End Time
string endTime = "";
try
{
if (teamProjectTime2DetailGateway.GetEndTime(teamProjectTimeId, detailId) != "") endTime = DateTime.Parse(teamProjectTime2DetailGateway.GetEndTime(teamProjectTimeId, detailId)).ToString("H:mm"); ;
}
catch
{
}
if (endTime != "")
{
((TextBox)e.Row.FindControl("tbxEndTime")).Text = endTime;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP4 - EMPLOYEES - AUXILIAR EVENTS
//
protected void ddlEmployeesFooter_SelectedIndexChanged(object sender, EventArgs e)
{
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(Int32.Parse(ddlProject.SelectedValue));
DropDownList ddlEmployee = (DropDownList)sender;
int employeeId = Int32.Parse(ddlEmployee.SelectedValue);
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
EmployeeInformationBasicInformationGateway employeeInformationBasicInformation = new EmployeeInformationBasicInformationGateway();
employeeInformationBasicInformation.LoadByEmployeeId(employeeId);
string jobClassType = employeeInformationBasicInformation.GetJobClassType(employeeId);
if (jobClassType != "")
{
((DropDownList)grdProjectTime.FooterRow.FindControl("ddlJobClassTypeFooter")).SelectedValue = jobClassType;
}
}
}
