/// <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;
}
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
{
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// 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;
}
}
}
