public void SendMailForCompletedToDo()
{
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "A to do list was completed.";
string body = "";
// MailtTo, nameTo
int createdBy = Int32.Parse(hdfCreatedById.Value);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(createdBy);
mailTo = employeeGateway.GetEMail(createdBy);
nameTo = employeeGateway.GetFullName(createdBy);
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following to do list was completed. \n";
body = body + "\n Subject: "+ lblTitleSubjectName.Text;
body = body + "\n Created By: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
body = body + "\n Unit / Equipment: " + tbxUnit.Text;
//Send Mail
SendMail(mailTo, subject, body);
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_VIEW"]) && Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_DELETE"])))
{
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) || ((string)Request.QueryString["employee_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in employees_delete.aspx");
}
// Tag page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentEmployeeId.Value = Request.QueryString["employee_id"];
hdfActiveTab.Value = Request.QueryString["active_tab"];
// ... for team member title
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int employeeId = Int32.Parse(hdfCurrentEmployeeId.Value);
EmployeeInformationTDS employeeInformationTDS = new EmployeeInformationTDS();
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
lblTitleTeamMember.Text = "Team Member: " + employeeGateway.GetFullName(employeeId);
// If coming from
// ... employees_navigator2.aspx
if (Request.QueryString["source_page"] == "employees_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
}
// ... employees_summary.aspx
if (Request.QueryString["source_page"] == "employees_summary.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
}
// Restore dataset
employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"];
}
else
{
// Restore dataset
employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"];
}
}
public void SendMailForNewTicket()
{
int companyId = Int32.Parse(hdfCompanyId.Value);
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "A support ticket was created.";
string body = "";
// MailtTo, nameTo
int createdBy = Int32.Parse(hdfTeamMemberId.Value);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(createdBy);
mailTo = employeeGateway.GetEMail(createdBy);
nameTo = employeeGateway.GetFullName(createdBy);
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following support ticket was created. \n";
body = body + "\n Subject: " + hdfSubject.Value;
body = body + "\n Comment: " + hdfComments.Value;
body = body + "\n Created By: " + employeeGateway.GetFullName(createdBy);
if (hdfDueDate.Value != "")
{
DateTime dueDate = DateTime.Parse(hdfDueDate.Value);
string dueDateText = dueDate.Month.ToString() + "/" + dueDate.Day.ToString() + "/" + dueDate.Year.ToString();
body = body + "\n Due Date: " + dueDateText;
}
int categoryId = Int32.Parse(hdfCategoriesSelected.Value);
SupportTicketCategoryGateway supportTicketCategoryGateway = new SupportTicketCategoryGateway();
supportTicketCategoryGateway.LoadByCategoryId(categoryId, companyId);
body = body + "\n Category: " + supportTicketCategoryGateway.GetName(categoryId);
//int assignTeamMemberId = Int32.Parse(hdfTeamMemberId.Value);
//EmployeeGateway employeeGatewayForAssignment = new EmployeeGateway();
//employeeGatewayForAssignment.LoadByEmployeeId(assignTeamMemberId);
//body = body + "\n Assigned team member: " + employeeGatewayForAssignment.GetFullName(assignTeamMemberId) + "\n";
body = body + "\n Assigned team member: Anzovino Dan \n";
//Send Mail
SendMail(mailTo, subject, body);
}
// ////////////////////////////////////////////////////////////////////////
// INITIAL EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
EmployeeGateway employeeGatewayManager = new EmployeeGateway();
int employeeIdNow = employeeGatewayManager.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
employeeGatewayManager.LoadByEmployeeId(employeeIdNow);
if (!employeeGatewayManager.GetIsVacationsManager(employeeIdNow))
{
// Security check
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_VACATIONS_REPORTS"]))
{
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_summary_report.aspx");
}
EmployeeInformationPayVacationDaysInformationList employeeInformationPayVacationDaysInformationList = new EmployeeInformationPayVacationDaysInformationList();
employeeInformationPayVacationDaysInformationList.Load();
ddlYear.DataSource = employeeInformationPayVacationDaysInformationList.Table;
ddlYear.DataValueField = "Year";
ddlYear.DataTextField = "Year";
ddlYear.DataBind();
try
{
ddlYear.SelectedValue = DateTime.Now.Year.ToString();
}
catch
{
}
// Register delegates
this.RegisterDelegates();
}
else
{
// Register delegates
this.RegisterDelegates();
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm6 master = (mForm6)this.Master;
master.ActiveToolbar = "LabourHours";
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
int employeeId = Int32.Parse(hdfCurrentEmployeeId.Value);
employeeGateway1.LoadByEmployeeId(employeeId);
if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
tkrpbLeftMenuOthersTimesheets.Visible = true;
tkrpbLeftMenuTools.Items[0].Items[0].Visible = true; // Add Team Project Time
tkrpbLeftMenuTools.Items[0].Items[2].Visible = true; // Missing Project Time
// Access control
// ... Employees
EmployeeListGateway employeeListGateway = new EmployeeListGateway(new DataSet());
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
employeeListGateway.LoadByRequestProjectTimeWithoutEmployeeId(1, employeeId);
}
else
{
employeeListGateway.LoadByRequestProjectTime(1);
}
DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor");
ddlOthersFor.DataSource = employeeListGateway.Table;
ddlOthersFor.DataValueField = "EmployeeID";
ddlOthersFor.DataTextField = "FullName";
ddlOthersFor.DataBind();
try
{
ddlOthersFor.SelectedValue = Session["ddlOthersForSelectedValue"].ToString();
}
catch
{
}
}
else
{
tkrpbLeftMenuOthersTimesheets.Visible = false;
tkrpbLeftMenuTools.Items[0].Items[0].Visible = false; // Add Team Project Time
tkrpbLeftMenuTools.Items[0].Items[2].Visible = false; // Missing Project Time
}
if (!((Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) && (employeeGateway1.GetRequestProjectTime(employeeId))))
{
tkrpbLeftMenuMyTimesheets.Visible = false;
tkrpbLeftMenuOthersTimesheets.Items[0].Text = "Timesheets";
}
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_REPORTS"]))
{
tkrpbLeftMenuReports.Visible = false;
}
}
}
protected void grdProjectTimeApprove_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Normal items
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate))))
{
Label lblJobClass = (Label)e.Row.FindControl("lblJobClass");
Label lblTypeOfWork = (Label)e.Row.FindControl("lblTypeOfWork");
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
int employeeId = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
employeeGateway1.LoadByEmployeeId(employeeId);
string employeeType = employeeGateway1.GetType(employeeId);
if (lblTypeOfWork.Text == "Mobilization" && employeeType.Contains("US"))
{
lblJobClass.Visible = false;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Validate query string
if (((string)Request.QueryString["source_page"] == null) && ((string)Request.QueryString["others"] == null) && ((string)Request.QueryString["employee_id"] == null) && ((string)Request.QueryString["period_id"] == null) && ((string)Request.QueryString["projecttime_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_summary.aspx");
}
// Security check
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (Request.QueryString["others"] == "no")
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
else
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
}
}
}
}
// Initialize viewstate's variables
ViewState["others"] = Request.QueryString["others"];
ViewState["employee_id"] = int.Parse(Request.QueryString["employee_id"]);
ViewState["period_id"] = int.Parse(Request.QueryString["period_id"]);
ViewState["projecttime_id"] = int.Parse(Request.QueryString["projecttime_id"]);
System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader();
ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString();
// Get ProjectTime record
projectTimeTDS = new ProjectTimeTDS();
ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS);
projectTimeGateway.LoadByProjectTimeId((int)ViewState["projecttime_id"]);
// Store datasets
Session["projectTimeTDS"] = projectTimeTDS;
// Databind
tbxDate.DataBind();
tbxWorkingDetails.DataBind();
tbxStartTime.DataBind();
tbxEndTime.DataBind();
tbxLunch.DataBind();
tbxComments.DataBind();
tbxState.DataBind();
// Prepare initial data for client
StoreNavigatorState();
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
employeeGateway.LoadByEmployeeId((int)ViewState["employee_id"]);
tbxEmployee.Text = employeeGateway.GetFullName((int)ViewState["employee_id"]);
int companyId = Int32.Parse(Session["companyID"].ToString());
CompaniesGateway companiesGateway = new CompaniesGateway(new DataSet());
companiesGateway.LoadAllByCompaniesId(projectTimeGateway.GetCompaniesId((int)ViewState["projecttime_id"]), companyId);
tbxClient.Text = companiesGateway.GetName(projectTimeGateway.GetCompaniesId((int)ViewState["projecttime_id"]));
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"]));
tbxProject.Text = projectGateway.GetName(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])) + "(" + projectGateway.GetProjectNumber(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])) + ")";
if (projectGateway.GetFairWageApplies(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])))
{
tbxJobClassType.Visible = true;
lblJobClassType.Visible = true;
tbxJobClassType.Text = projectTimeGateway.GetJobClassType((int)ViewState["projecttime_id"]);
}
else
{
tbxJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
if (projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]).HasValue)
{
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId((Int64)projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]));
tbxMealsCountry.Text = countryGateway.GetName((Int64)projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]));
}
//if (projectTimeGateway.GetMealsAllowance((int)ViewState["projecttime_id"]) > 0)
//{
// cbxMealsAllowance.Checked = true;
//}
//if (projectTimeGateway.GetFairWage((int)ViewState["projecttime_id"]))
//{
// cbxFairWage.Checked = true;
//}
if (projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]).HasValue)
{
UnitsGateway unitGateway = new UnitsGateway(new DataSet());
unitGateway.LoadByUnitId((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]), Convert.ToInt32(Session["companyID"]));
tbxUnit.Text = unitGateway.GetUnitCode((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]));
}
if (projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]).HasValue)
{
UnitsGateway unitGateway = new UnitsGateway(new DataSet());
unitGateway.LoadByUnitId((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]), Convert.ToInt32(Session["companyID"]));
tbxTowed.Text = unitGateway.GetUnitCode((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]));
}
tbxTypeOfWork.Text = "";
if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]) != "")
{
tbxTypeOfWork.Text = projectTimeGateway.GetWork((int)ViewState["projecttime_id"]);
}
tbxFunction.Text = "";
if (projectTimeGateway.GetFunction((int)ViewState["projecttime_id"]) != "")
{
tbxFunction.Text = projectTimeGateway.GetFunction((int)ViewState["projecttime_id"]);
}
}
else
{
// Restore datasets
projectTimeTDS = (ProjectTimeTDS)Session["projectTimeTDS"];
}
}
private void LoadData(int toDoId)
{
ToDoListInformationBasicInformationGateway toDoListInformationBasicInformationGateway = new ToDoListInformationBasicInformationGateway(toDoListInformationTDS);
if (toDoListInformationBasicInformationGateway.Table.Rows.Count > 0)
{
// Load to do Details
int companyId = Int32.Parse(hdfCompanyId.Value);
int createdById = toDoListInformationBasicInformationGateway.GetCreatedByID(toDoId);
hdfCreatedById.Value = createdById.ToString();
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(createdById);
tbxCreatedBy.Text = employeeGateway.GetFullName(createdById);
tbxCreationDate.Text = toDoListInformationBasicInformationGateway.GetCreationDate(toDoId).ToString();
tbxState.Text = toDoListInformationBasicInformationGateway.GetState(toDoId);
if (toDoListInformationBasicInformationGateway.GetDueDate(toDoId).HasValue)
{
DateTime dueDateValue = (DateTime)toDoListInformationBasicInformationGateway.GetDueDate(toDoId);
tbxDueDate.Text = dueDateValue.Month.ToString() + "/" + dueDateValue.Day.ToString() + "/" + dueDateValue.Year.ToString();
}
int? unitId = toDoListInformationBasicInformationGateway.GetUnitID(toDoId);
tbxUnit.Text = "";
if (unitId.HasValue)
{
UnitsGateway unitsGateway = new UnitsGateway();
unitsGateway.LoadByUnitId((int)unitId, companyId);
tbxUnit.Text = unitsGateway.GetUnitCode((int)unitId) + " " + unitsGateway.GetDescription((int)unitId);
}
}
}
protected void grdToDoList_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Control of footer row
if (e.Row.RowType == DataControlRowType.Footer)
{
int loginId = Convert.ToInt32(Session["loginID"]);
EmployeeGateway employeeGateway = new EmployeeGateway();
int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId);
// Select action
DropDownList actions = (DropDownList)e.Row.FindControl("ddlActionsNew");
actions.SelectedValue = hdfAction.Value;
// Only the assigned user could close the todo
if (hdfAssignedUser.Value != employeeId.ToString())
{
actions.Items.Remove("Close");
}
// Make fields visible for actions
if (hdfAction.Value == "Assign To User")
{
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = true;
((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = true;
((TextBox)e.Row.FindControl("tbxUserNew")).Visible = false;
((Label)e.Row.FindControl("lblClosed")).Visible = false;
((Label)e.Row.FindControl("lblUserNew")).Text = "Assign To";
}
if (hdfAction.Value == "Add Comment")
{
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = false;
((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = false;
((TextBox)e.Row.FindControl("tbxUserNew")).Visible = true;
EmployeeGateway employeeGatewayForUser = new EmployeeGateway();
employeeGatewayForUser.LoadByEmployeeId(employeeId);
((TextBox)e.Row.FindControl("tbxUserNew")).Text = employeeGatewayForUser.GetFullName(employeeId);
((Label)e.Row.FindControl("lblClosed")).Visible = false;
((Label)e.Row.FindControl("lblUserNew")).Text = "Comment Added By";
}
if (hdfAction.Value == "Complete")
{
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = false;
((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = false;
((TextBox)e.Row.FindControl("tbxUserNew")).Visible = true;
EmployeeGateway employeeGatewayForUser = new EmployeeGateway();
employeeGatewayForUser.LoadByEmployeeId(Int32.Parse(hdfAssignedUser.Value));
((TextBox)e.Row.FindControl("tbxUserNew")).Text = employeeGatewayForUser.GetFullName(Int32.Parse(hdfAssignedUser.Value));
((Label)e.Row.FindControl("lblClosed")).Visible = false;
((Label)e.Row.FindControl("lblUserNew")).Text = "To Do Completed By";
}
if (hdfCompleted.Value == "True")
{
((DropDownList)e.Row.FindControl("ddlActionsNew")).Visible = false;
((TextBox)e.Row.FindControl("tbxDateTimeNew")).Visible = false;
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = false;
((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = false;
((TextBox)e.Row.FindControl("tbxUserNew")).Visible = false;
((TextBox)e.Row.FindControl("tbxCommentsNew")).Visible = false;
((Label)e.Row.FindControl("lblActionNew")).Visible = false;
((Label)e.Row.FindControl("lblDateTimeNew")).Visible = false;
((Label)e.Row.FindControl("lblUserNew")).Visible = false;
((Label)e.Row.FindControl("lblCommentsNew")).Visible = false;
((ImageButton)e.Row.FindControl("ibtnAdd")).Visible = false;
((Label)e.Row.FindControl("lblClosed")).Visible = true;
}
if (hdfAction.Value == "Put On Hold")
{
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = false;
((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = false;
((TextBox)e.Row.FindControl("tbxUserNew")).Visible = true;
EmployeeGateway employeeGatewayForOnHold = new EmployeeGateway();
employeeGatewayForOnHold.LoadByEmployeeId(employeeId);
((TextBox)e.Row.FindControl("tbxUserNew")).Text = employeeGatewayForOnHold.GetFullName(employeeId);
((Label)e.Row.FindControl("lblClosed")).Visible = false;
((Label)e.Row.FindControl("lblUserNew")).Text = "On Hold By";
}
// Date and time
DateTime creationDate = DateTime.Now;
((TextBox)e.Row.FindControl("tbxDateTimeNew")).Text = creationDate.ToString();
}
// Control of edit rows
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
// Date and time
DateTime creationDate = DateTime.Now;
((TextBox)e.Row.FindControl("tbxDateTimeEdit")).Text = creationDate.ToString();
string type_ = ((Label)e.Row.FindControl("lblType")).Text;
int loginId = Convert.ToInt32(Session["loginID"]);
EmployeeGateway employeeGateway = new EmployeeGateway();
int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId);
int toDoId = Int32.Parse(((Label)e.Row.FindControl("lblToDoID")).Text);
int refId = Int32.Parse(((Label)e.Row.FindControl("lblRefID")).Text);
ToDoListInformationActivityInformationGateway toDoListInformationActivityInformationGateway = new ToDoListInformationActivityInformationGateway(toDoListInformationTDS);
// Make fields visible for actions
if (type_ == "AssignUser")
{
int employeeIdForAssign = toDoListInformationActivityInformationGateway.GetEmployeeID(toDoId, refId);
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).Visible = true;
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).SelectedValue = employeeIdForAssign.ToString();
((CustomValidator)e.Row.FindControl("cvTeamMemberEdit")).Visible = true;
((TextBox)e.Row.FindControl("tbxUserEdit")).Visible = false;
((Label)e.Row.FindControl("lblUserEdit")).Text = "Assign To";
}
if (type_ == "AddComment")
{
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).Visible = false;
((CustomValidator)e.Row.FindControl("cvTeamMemberEdit")).Visible = false;
((TextBox)e.Row.FindControl("tbxUserEdit")).Visible = true;
EmployeeGateway employeeGatewayForUser = new EmployeeGateway();
employeeGatewayForUser.LoadByEmployeeId(employeeId);
((TextBox)e.Row.FindControl("tbxUserEdit")).Text = employeeGatewayForUser.GetFullName(employeeId);
((Label)e.Row.FindControl("lblUserEdit")).Text = "Comment Added By";
}
if (type_ == "CloseToDo")
{
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).Visible = false;
((CustomValidator)e.Row.FindControl("cvTeamMemberEdit")).Visible = false;
((TextBox)e.Row.FindControl("tbxUserEdit")).Visible = true;
EmployeeGateway employeeGatewayForUser = new EmployeeGateway();
employeeGatewayForUser.LoadByEmployeeId(Int32.Parse(hdfAssignedUser.Value));
((TextBox)e.Row.FindControl("tbxUserEdit")).Text = employeeGatewayForUser.GetFullName(Int32.Parse(hdfAssignedUser.Value));
((Label)e.Row.FindControl("lblUserEdit")).Text = "To Do Completed By";
}
if (type_ == "OnHoldToDo")
{
((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).Visible = false;
((CustomValidator)e.Row.FindControl("cvTeamMemberEdit")).Visible = false;
((TextBox)e.Row.FindControl("tbxUserEdit")).Visible = true;
EmployeeGateway employeeGatewayForOnHold = new EmployeeGateway();
employeeGatewayForOnHold.LoadByEmployeeId(employeeId);
((TextBox)e.Row.FindControl("tbxUserEdit")).Text = employeeGatewayForOnHold.GetFullName(employeeId);
((Label)e.Row.FindControl("lblUserEdit")).Text = "On Hold By";
}
}
// Control normal rows
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate))))
{
// Validate admin actions
if ((Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_ADMIN"])))
{
((ImageButton)e.Row.FindControl("ibtnEdit")).Visible = true;
((ImageButton)e.Row.FindControl("ibtnDelete")).Visible = true;
}
else
{
bool inDataBase = bool.Parse(((Label)e.Row.FindControl("lblInDataBase")).Text);
if (inDataBase)
{
((ImageButton)e.Row.FindControl("ibtnEdit")).Visible = false;
((ImageButton)e.Row.FindControl("ibtnDelete")).Visible = false;
}
else
{
((ImageButton)e.Row.FindControl("ibtnEdit")).Visible = true;
((ImageButton)e.Row.FindControl("ibtnDelete")).Visible = true;
}
}
// Change label text
string type_ = ((Label)e.Row.FindControl("lblType")).Text;
if (type_ == "AssignUser")
{
((Label)e.Row.FindControl("lblUser")).Text = "Assign To";
}
if (type_ == "AddComment")
{
((Label)e.Row.FindControl("lblUser")).Text = "Comment Added By";
}
if (type_ == "CloseToDo")
{
((Label)e.Row.FindControl("lblUser")).Text = "To Do Completed By";
}
if (type_ == "OnHoldToDo")
{
((Label)e.Row.FindControl("lblUser")).Text = "On Hold By";
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string orderBy = ddlOrderBy.SelectedValue;
string whereClause = "(P.Deleted = 0) AND (P.ProjectType = 'Ballpark') AND (P.ProjectState = 'Active')";
if (ddlCountry.SelectedValue != "(All)")
{
if (whereClause.Length > 0) whereClause += " AND ";
whereClause += "(P.CountryID = " + ddlCountry.SelectedValue + ")";
}
if (ddlClient.SelectedValue != "-1")
{
if (whereClause.Length > 0) whereClause += " AND ";
whereClause += "(P.ClientID = " + ddlClient.SelectedValue + ")";
}
if (ddlSalesman.SelectedValue != "-1")
{
if (whereClause.Length > 0) whereClause += " AND ";
whereClause += "(P.SalesmanID = " + ddlSalesman.SelectedValue + ")";
}
LiquiForce.LFSLive.BL.Projects.Projects.BallparkSummaryReport ballparkSummayReport = new LiquiForce.LFSLive.BL.Projects.Projects.BallparkSummaryReport();
ballparkSummayReport.LoadWhereOrderBy(whereClause, orderBy, ddlCurrency.SelectedValue, decimal.Parse(tbxExchangeRate.Text));
// ... set properties to master page
master.Data = ballparkSummayReport.Data;
master.Table = ballparkSummayReport.TableName;
// Get report
if (ballparkSummayReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.BallparkSummaryReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.BallparkSummaryReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim()));
master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.Trim() + "):");
master.SetParameter("Currency", ddlCurrency.SelectedValue.Trim());
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("Client", "All");
}
else
{
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), companyId);
string clientName = companiesGateway.GetName(Int32.Parse(ddlClient.SelectedValue));
master.SetParameter("Client", clientName);
}
// ... ... salesman
if (ddlSalesman.SelectedValue == "-1")
{
master.SetParameter("Salesman", "All");
}
else
{
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(Int32.Parse(ddlSalesman.SelectedValue));
string salesman = employeeGateway.GetFullName(Int32.Parse(ddlSalesman.SelectedValue));
master.SetParameter("Salesman", salesman);
}
// ... ... country
if (ddlCountry.SelectedValue == "2")
{
master.SetParameter("Country", "USA");
}
else
{
if (ddlCountry.SelectedValue == "1")
{
master.SetParameter("Country", "Canada");
}
else
{
master.SetParameter("Country", "All");
}
}
// ... ... order by
if (ddlOrderBy.SelectedValue == "P.CountryID")
{
master.SetParameter("OrderBy", "Country");
}
else
{
if (ddlOrderBy.SelectedValue == "P.ProjectNumber")
{
master.SetParameter("OrderBy", "Project Number");
}
else
{
if (ddlOrderBy.SelectedValue == "P.Name")
{
master.SetParameter("OrderBy", "Project Name");
}
else
{
if (ddlOrderBy.SelectedValue == "C.Name")
{
master.SetParameter("OrderBy", "Client");
}
else
{
master.SetParameter("OrderBy", "Salesman");
}
}
}
}
}
else
{
master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim()));
master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.Trim() + "):");
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Tag page
// ... 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";
}
// Security check
if (hdfIsVacationManager.Value == "False")
{
//if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_VACATIONS_EDIT"])))
//{
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) && ((string)Request.QueryString["vacation_id"] == null) && ((string)Request.QueryString["request_id"] == null) && ((string)Request.QueryString["date_to_show"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in vacations_edit.aspx");
}
// Tag page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfVacationId.Value = (string)Request.QueryString["vacation_id"];
hdfRequestId.Value = (string)Request.QueryString["request_id"];
int requestId = Int32.Parse(hdfRequestId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
ViewState["date_to_show"] = (string)Request.QueryString["date_to_show"];
DateTime dateToShow = DateTime.Parse((string)Request.QueryString["date_to_show"]);
// 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();
ddlVacationsFor.SelectedValue = Session["ddlVacationsForSelectedValue"].ToString();
// Load Data
vacationsInformationTDS = new VacationsInformationTDS();
vacationDaysInformation = new VacationsInformationTDS.DaysInformationDataTable();
VacationsInformationDaysInformationGateway vacationsInformationDaysInformationGateway = new VacationsInformationDaysInformationGateway(vacationsInformationTDS);
vacationsInformationDaysInformationGateway.LoadByRequestId(requestId, companyId);
VacationsInformationRequestsInformationGateway vacationsInformationRequestsInformationGateway = new VacationsInformationRequestsInformationGateway(vacationsInformationTDS);
vacationsInformationRequestsInformationGateway.LoadByRequestId(requestId, companyId);
hdfEmployeeId.Value = vacationsInformationRequestsInformationGateway.GetEmployeeID(requestId).ToString();
int employeeId = Int32.Parse(hdfEmployeeId.Value);
VacationsInformationBasicInformationGateway vacationsInformationBasicInformationGateway = new VacationsInformationBasicInformationGateway(vacationsInformationTDS);
vacationsInformationBasicInformationGateway.LoadByEmployeeIdYear(employeeId, dateToShow.Year, companyId);
Session["vacationsInformationTDS"] = vacationsInformationTDS;
Session["vacationDaysInformation"] = vacationsInformationTDS.DaysInformation;
LoadData(employeeId, dateToShow.Year, requestId);
Page.DataBind();
}
else
{
vacationsInformationTDS = (VacationsInformationTDS)Session["vacationsInformationTDS"];
vacationDaysInformation = (VacationsInformationTDS.DaysInformationDataTable)Session["vacationDaysInformation"];
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue;
PrintEmployeeLocationGateway printEmployeeLocationGateway = new PrintEmployeeLocationGateway();
if (ddlEmployee.SelectedValue == "-1")
{
if (tbxLocation.Text.Trim() == "yes")
{
printEmployeeLocationGateway.LoadByStartDateEndDateProjectTimeState(DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()), DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()), projectTimeState);
}
else
{
printEmployeeLocationGateway.LoadByStartDateEndDateLocationProjectTimeState(DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()), DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()), tbxLocation.Text.Trim(), projectTimeState);
}
}
else
{
if (tbxLocation.Text.Trim() == "yes")
{
printEmployeeLocationGateway.LoadByStartDateEndDateEmployeeIdProjectTimeState(DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()), DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()), Int32.Parse(ddlEmployee.SelectedValue), projectTimeState);
}
else
{
printEmployeeLocationGateway.LoadByStartDateEndDateEmployeeIdLocationProjectTimeState(DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()), DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()), int.Parse(ddlEmployee.SelectedValue), tbxLocation.Text.Trim(), projectTimeState);
}
}
// ... set properties to master page
master.Data = printEmployeeLocationGateway.Data;
master.Table = printEmployeeLocationGateway.TableName;
// Get report
if (printEmployeeLocationGateway.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintEmployeeLocationReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintEmployeeLocationReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... project time state
if (ddlProjectTimeState.SelectedValue == "(All)")
{
master.SetParameter("projectTimeState", "All");
}
else
{
master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text);
}
// ... ... team member
if (ddlEmployee.SelectedValue == "-1")
{
master.SetParameter("teamMember", "All");
}
else
{
int teamMemberId = Int32.Parse(ddlEmployee.SelectedValue);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(teamMemberId);
string fullName = employeeGateway.GetFullName(teamMemberId);
master.SetParameter("teamMember", fullName);
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
master.SetParameter("location", tbxLocation.Text.Trim());
master.SetParameter("startTime", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("endTime", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
}
}
// ////////////////////////////////////////////////////////////////////////
// AUXILIAR EVENTS
//
protected void ddlEmployee_SelectedIndexChanged(object sender, EventArgs e)
{
ViewState["date_to_show"] = tkrsVacations.SelectedDate.ToString();
ViewState["employee_id"] = ddlEmployee.SelectedValue;
DateTime dateToShow = DateTime.Parse((string)ViewState["date_to_show"]);
int companyId = Int32.Parse(hdfCompanyId.Value);
hdfEmployeeId.Value = ddlEmployee.SelectedValue.ToString();
int employeeId = Int32.Parse(hdfEmployeeId.Value);
// Reload Data
VacationsAddBasicInformationGateway vacationsAddBasicInformationGateway = new VacationsAddBasicInformationGateway(vacationsAddTDS);
vacationsAddBasicInformationGateway.LoadByEmployeeIdYear(employeeId, dateToShow.Year, companyId);
if (vacationsAddBasicInformationGateway.Table.Rows.Count == 0)
{
Response.Redirect("./../../error_page.aspx?error=" + "The team member don't have total paid day vacations defined in the system. Contact your system administrator.");
}
else
{
LoadData(employeeId, dateToShow.Year);
// ... Load non working days
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
string employeeType = employeeGateway.GetType(employeeId);
int companyLevelId = 3; //USA
if (employeeType.Contains("CA"))
{
companyLevelId = 2;//Canada
}
VacationsAddDaysInformation vacationsAddDaysInformation = new VacationsAddDaysInformation(vacationsAddTDS);
//vacationsAddDaysInformation.LoadNonWorkingDaysByCompanyLevelId(companyLevelId, companyId);
// ... Load previews vacations
//vacationsAddDaysInformation.LoadPreviousVacations(employeeId, companyId);
vacationsAddDaysInformation.LoadDataForVacationsAdd(companyLevelId, employeeId, companyId);
}
Session["vacationsAddTDS"] = vacationsAddTDS;
Session["vacationDaysInformation"] = vacationsAddTDS.DaysInformation;
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Tag page
// ... 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";
}
// Security check
//if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_VACATIONS_ADD"])))
//{
if (hdfIsVacationManager.Value == "False")
{
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) && ((string)Request.QueryString["employee_id"] == null) && ((string)Request.QueryString["date_to_show"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in vacations_add.aspx");
}
// Tag page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfEmployeeId.Value = (string)Request.QueryString["employee_id"];
Session.Remove("vacationsAddTDS");
ViewState["date_to_show"] = (string)Request.QueryString["date_to_show"];
DateTime dateToShow = DateTime.Parse((string)Request.QueryString["date_to_show"]);
// Prepare initial data
// ... For employee list
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)");
}
DropDownList ddlVacationsFor = (DropDownList)tkrpbLeftMenuAllVacations.FindItemByValue("nbVacationsForDDL").FindControl("ddlVacationsFor");
ddlVacationsFor.DataSource = employeeList.Table;
ddlVacationsFor.DataValueField = "EmployeeID";
ddlVacationsFor.DataTextField = "FullName";
ddlVacationsFor.DataBind();
ddlVacationsFor.SelectedValue = Session["ddlVacationsForSelectedValue"].ToString();
// ... For employee ddl
ddlEmployee.DataSource = employeeList.Table;
ddlEmployee.DataValueField = "EmployeeID";
ddlEmployee.DataTextField = "FullName";
ddlEmployee.DataBind();
vacationsAddTDS = new VacationsAddTDS();
vacationDaysInformation = new VacationsAddTDS.DaysInformationDataTable();
// If there is a selected employee
if (hdfEmployeeId.Value != "-1")
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int employeeId = Int32.Parse(hdfEmployeeId.Value);
// ... Verify basic information
VacationsAddBasicInformationGateway vacationsAddBasicInformationGateway = new VacationsAddBasicInformationGateway(vacationsAddTDS);
vacationsAddBasicInformationGateway.LoadByEmployeeIdYear(employeeId, dateToShow.Year, companyId);
if (vacationsAddBasicInformationGateway.Table.Rows.Count == 0)
{
Response.Redirect("./../../error_page.aspx?error=" + "The team member don't have total paid day vacations defined in the system. Contact your system administrator.");
}
else
{
LoadData(employeeId, dateToShow.Year);
// ... Load non working days
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
string employeeType = employeeGateway.GetType(employeeId);
int companyLevelId = 3; //USA
if (employeeType.Contains("CA"))
{
companyLevelId = 2;//Canada
}
VacationsAddDaysInformation vacationsAddDaysInformation = new VacationsAddDaysInformation(vacationsAddTDS);
//vacationsAddDaysInformation.LoadNonWorkingDaysByCompanyLevelId(companyLevelId, companyId);
// ... Load previews vacations
//vacationsAddDaysInformation.LoadPreviousVacations(employeeId, companyId);
vacationsAddDaysInformation.LoadDataForVacationsAdd(companyLevelId, employeeId, companyId);
}
}
ViewState["employee_id"] = hdfEmployeeId.Value;
Session["vacationsAddTDS"] = vacationsAddTDS;
Session["vacationDaysInformation"] = vacationsAddTDS.DaysInformation;
Page.DataBind();
}
else
{
vacationsAddTDS = (VacationsAddTDS)Session["vacationsAddTDS"];
vacationDaysInformation = (VacationsAddTDS.DaysInformationDataTable)Session["vacationDaysInformation"];
hdfEmployeeId.Value = ViewState["employee_id"].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_HOLIDAY_FULL_EDITING"])))
{
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_setup.aspx");
}
// Tag page
// ... 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";
}
hdfCompanyId.Value = Session["companyID"].ToString();
hdfUpdate.Value = "no";
Session.Remove("vacationsSetup");
Session.Remove("vacationsSetupDummy");
// Prepare initial data
// ... For Grids
vacationsSetup = new VacationsSetupTDS.VacationsSetupDataTable();
// ... Store datasets
Session["vacationsSetup"] = vacationsSetup;
// StepSection1In
wizard.ActiveStepIndex = 0;
StepBeginIn();
}
else
{
// Restore datasets
vacationsSetup = (VacationsSetupTDS.VacationsSetupDataTable)Session["vacationsSetup"];
}
}
private void LoadWorkData(int workId, int assetId)
{
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(fullLengthLiningTDS);
if (fullLengthLiningWorkDetailsGateway.Table.Rows.Count > 0)
{
// For Header
tbxVideoLength.Text = fullLengthLiningWorkDetailsGateway.GetVideoLength(workId);
// Load full length lining general data
tbxGeneralClientId.Text = fullLengthLiningWorkDetailsGateway.GetClientId(workId);
ckbxGeneralIssueIdentified.Checked = fullLengthLiningWorkDetailsGateway.GetIssueIdentified(workId);
ckbxGeneralLfsIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueLFS(workId);
ckbxGeneralClientIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueClient(workId);
ckbxGeneralSalesIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueSales(workId);
ckbxGeneralIssueGivenToClient.Checked = fullLengthLiningWorkDetailsGateway.GetIssueGivenToClient(workId);
ckbxGeneralIssueResolved.Checked = fullLengthLiningWorkDetailsGateway.GetIssueResolved(workId);
ckbxGeneralIssueInvestigation.Checked = fullLengthLiningWorkDetailsGateway.GetIssueInvestigation(workId);
// ... Load Dates
if (fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workId).HasValue)
{
tkrdpGeneralProposedLiningDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workId).HasValue)
{
tkrdpGeneralDeadlineLiningDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetP1Date(workId).HasValue)
{
tkrdpPrepDataP1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetP1Date(workId);
tkrdpGeneralP1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetP1Date(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetM1Date(workId).HasValue)
{
tkrdpM1DataM1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM1Date(workId);
tkrdpGeneralM1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM1Date(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetM2Date(workId).HasValue)
{
tkrdpGeneralM2Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM2Date(workId);
tkrdpM2DataM2Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM2Date(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetInstallDate(workId).HasValue)
{
tkrdpGeneralInstallDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetInstallDate(workId);
tkrdpInstallDataInstallDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetInstallDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId).HasValue)
{
tkrdpGeneralFinalVideo.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId);
tkrdpInstallDataFinalVideoDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId);
}
// ... for RA data
if (fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId).HasValue)
{
tkrdpGeneralPreFlushDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId);
tkrdpGeneralPreFlushDateReadOnly.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId).HasValue)
{
tkrdpGeneralPreVideoDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId);
tkrdpGeneralPreVideoDateReadOnly.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId);
}
// For FullLengthLiningP1 data
tbxPrepDataCXIsRemoved.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId).HasValue) tbxPrepDataCXIsRemoved.Text = fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId).ToString();
ckbxPrepDataRoboticPrepCompleted.Checked = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompleted(workId);
if (fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workId).HasValue)
{
tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workId);
}
ckbxPrepDataP1Completed.Checked = fullLengthLiningWorkDetailsGateway.GetP1Completed(workId);
// For FullLengthLiningM1 data
// ... for material
ddlM1DataMaterial.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMaterial(workId);
// ... form m1 data
tbxM1DataMeasurementsTakenBy.Text = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenBy(workId);
ddlM1DataTrafficControl.SelectedValue = fullLengthLiningWorkDetailsGateway.GetTrafficControl(workId);
if(fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId) == "") ddlM1DataSiteDetails.SelectedIndex = 0; else ddlM1DataSiteDetails.SelectedValue = fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId);
if (fullLengthLiningWorkDetailsGateway.GetAccessType(workId) == "") ddlM1DataAccessType.SelectedIndex = 0; else ddlM1DataAccessType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetAccessType(workId);
ckbxM1DataPipeSizeChange.Checked = fullLengthLiningWorkDetailsGateway.GetPipeSizeChange(workId);
ckbxM1DataStandardBypass.Checked = fullLengthLiningWorkDetailsGateway.GetStandardBypass(workId);
tbxM1DataStandardBypassComments.Text = fullLengthLiningWorkDetailsGateway.GetStandardBypassComments(workId);
tbxM1DataTrafficControlDetails.Text = fullLengthLiningWorkDetailsGateway.GetTrafficControlDetails(workId);
ddlM1DataMeasurementType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMeasurementType(workId);
ddlM1DataMeasuredFromMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId);
tbxM1DataMeasuredFromMh.Text = ""; fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId);
ddlM1DataVideoDoneFromMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId);
tbxM1DataVideoDoneFromMh.Text = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId);
ddlM1DataVideoDoneToMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId);
tbxM1DataVideoDoneToMh.Text = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId);
// For FullLengthLiningM2 data
tbxM2DataMeasurementsTakenBy.Text = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2(workId);
ckbxM2DataDropPipe.Checked = fullLengthLiningWorkDetailsGateway.GetDropPipe(workId);
tbxM2DataDropPipeInvertdepth.Text = fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepth(workId);
tbxM2DataCappedLaterals.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId).HasValue) tbxM2DataCappedLaterals.Text = fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId).ToString();
tbxM2DataLineWidthId.Text = fullLengthLiningWorkDetailsGateway.GetLineWithId(workId);
tbxM2DataHydrantAddress.Text = fullLengthLiningWorkDetailsGateway.GetHydrantAddress(workId);
ddlM2DataHydroWireWithin10FtOfInversionMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMH(workId);
tbxM2DataDistanceToInversionMH.Text = fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMh(workId);
if (fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId) == "") ddlM2DataSurfaceGrade.SelectedIndex = 0; else ddlM2DataSurfaceGrade.SelectedValue = fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId);
cbxM2DataHydroPulley.Checked = fullLengthLiningWorkDetailsGateway.GetHydroPulley(workId);
cbxM2DataFridgeCart.Checked = fullLengthLiningWorkDetailsGateway.GetFridgeCart(workId);
cbxM2DataTwoPump.Checked = fullLengthLiningWorkDetailsGateway.GetTwoPump(workId);
cbxM2DataSixBypass.Checked = fullLengthLiningWorkDetailsGateway.GetSixBypass(workId);
cbxM2DataScaffolding.Checked = fullLengthLiningWorkDetailsGateway.GetScaffolding(workId);
cbxM2DataWinchExtension.Checked = fullLengthLiningWorkDetailsGateway.GetWinchExtension(workId);
cbxM2DataExtraGenerator.Checked = fullLengthLiningWorkDetailsGateway.GetExtraGenerator(workId);
cbxM2DataGreyCableExtension.Checked = fullLengthLiningWorkDetailsGateway.GetGreyCableExtension(workId);
cbxM2DataEasementMats.Checked = fullLengthLiningWorkDetailsGateway.GetEasementMats(workId);
cbxM2DataRampsRequired.Checked = fullLengthLiningWorkDetailsGateway.GetRampRequired(workId);
cbxM2DataCameraSkid.Checked = fullLengthLiningWorkDetailsGateway.GetCameraSkid(workId);
// For FullLengthLiningWetOut data
int companyId = Int32.Parse(hdfCompanyId.Value);
// ... ... tube size = confirmed Size
Distance confirmedSizeDistance = new Distance(tbxConfirmedSize.Text);
double confirmedSize = 0;
string[] confirmedSizeString = confirmedSizeDistance.ToStringInEng1().Split('\"');
if (!confirmedSizeDistance.ToStringInEng1().Contains("'"))
{
if (Validator.IsValidDouble(tbxConfirmedSize.Text))
{
confirmedSize = double.Parse(tbxConfirmedSize.Text);
}
else
{
confirmedSize = double.Parse(confirmedSizeString[0]);
}
}
else
{
confirmedSize = Math.Ceiling(confirmedSizeDistance.ToDoubleInEng3()*12);
tbxConfirmedSize.Text = confirmedSize.ToString();
}
// ... Verify if work has wet out information
WorkFullLengthLiningWetOutGateway workFullLengthLiningWetOutGateway = new WorkFullLengthLiningWetOutGateway();
workFullLengthLiningWetOutGateway.LoadByWorkId(workId, companyId);
if (workFullLengthLiningWetOutGateway.Table.Rows.Count > 0)
{
// ... setup data
ddlWetOutDataLinerTube.SelectedValue = fullLengthLiningWorkDetailsGateway.GetLinerTube(workId);
if (ddlWetOutDataLinerTube.SelectedValue != "(Select)")
{
ckbxWetOutDataIncludeWetOutInformation.Checked = true;
}
else
{
ckbxWetOutDataIncludeWetOutInformation.Checked = false;
}
ddlWetOutDataResins.SelectedValue = fullLengthLiningWorkDetailsGateway.GetResinId(workId).ToString();
tbxWetOutDataExcessResin.Text = fullLengthLiningWorkDetailsGateway.GetExcessResin(workId).ToString();
ddlWetOutDataPoundsDrums.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPoundsDrums(workId);
tbxWetOutDataDrumDiameter.Text = fullLengthLiningWorkDetailsGateway.GetDrumDiameter(workId).ToString();
tbxWetOutDataHoistMaximumHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistMaximumHeight(workId).ToString();
tbxWetOutDataHoistMinimumHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistMinimumHeight(workId).ToString();
tbxWetOutDataDownDropTubeLength.Text = fullLengthLiningWorkDetailsGateway.GetDownDropTubeLenght(workId).ToString();
tbxWetOutDataPumpHeightAboveGround.Text = fullLengthLiningWorkDetailsGateway.GetPumpHeightAboveGround(workId).ToString();
tbxWetOutDataTubeResinToFeltFactor.Text = fullLengthLiningWorkDetailsGateway.GetTubeResinToFeltFactor(workId).ToString();
// ... wet out sheet
DateTime wetOutDataDateOfSheet = fullLengthLiningWorkDetailsGateway.GetDateOfSheet(workId);
tbxWetOutDataDateOfSheet.Text = wetOutDataDateOfSheet.Month.ToString() + "/" + wetOutDataDateOfSheet.Day.ToString() + "/" + wetOutDataDateOfSheet.Year.ToString();
ddlWetOutDataMadeBy.SelectedValue = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId).ToString();
hdfRunDetails.Value = fullLengthLiningWorkDetailsGateway.GetRunDetails(workId);
ddlWetOutDataRunDetails2.SelectedValue = fullLengthLiningWorkDetailsGateway.GetRunDetails2(workId);
tkrdpWetOutDataWetOutDate.SelectedDate = fullLengthLiningWorkDetailsGateway.GetWetOutDate(workId);
tbxWetOutDataInstallDate.Text = "";
if (fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId).HasValue)
{
DateTime? wetOutDataInstallDate = fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId);
DateTime wetOutDataInstallDateDateTime = (DateTime)wetOutDataInstallDate;
tbxWetOutDataInstallDate.Text = wetOutDataInstallDateDateTime.Month.ToString() + "/" + wetOutDataInstallDateDateTime.Day.ToString() + "/" + wetOutDataInstallDateDateTime.Year.ToString();
}
tbxWetOutDataTubeThickness.Text = fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId);
tbxWetOutDataLengthToLine.Text = decimal.Round(decimal.Parse(fullLengthLiningWorkDetailsGateway.GetLengthToLine(workId).ToString()), 1).ToString();
tbxWetOutDataPlusExtra.Text = fullLengthLiningWorkDetailsGateway.GetPlusExtra(workId).ToString();
tbxWetOutDataForTurnOffset.Text = fullLengthLiningWorkDetailsGateway.GetForTurnOffset(workId).ToString();
tbxWetOutDataLengthtToWetOut.Text = fullLengthLiningWorkDetailsGateway.GetLengthToWetOut(workId).ToString();
tbxWetOutDataTubeMaxColdHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxColdHead(workId).ToString();
tbxWetOutDataTubeMaxColdHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxColdHeadPsi(workId).ToString();
tbxWetOutDataTubeMaxHotHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxHotHead(workId).ToString();
tbxWetOutDataTubeMaxHotHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxHotHeadPsi(workId).ToString();
tbxWetOutDataTubeIdealHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeIdealHead(workId).ToString();
tbxWetOutDataTubeIdealHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeIdealHeadPsi(workId).ToString();
tbxWetOutDataNetResinForTube.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTube(workId).ToString();
tbxWetOutDataNetResinForTubeUsgals.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeUsgals(workId).ToString();
tbxWetOutDataNetResinForTubeDrumsIns.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeDrumsIns(workId);
tbxWetOutDataNetResinForTubeLbsFt.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeLbsFt(workId).ToString();
tbxWetOutDataNetResinForTubeUsgFt.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeUsgFt(workId).ToString();
tbxWetOutDataExtraResinForMix.Text = fullLengthLiningWorkDetailsGateway.GetExtraResinForMix(workId).ToString();
tbxWetOutDataExtraLbsForMix.Text = fullLengthLiningWorkDetailsGateway.GetExtraLbsForMix(workId).ToString();
tbxWetOutDataTotalMixQuantity.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantity(workId).ToString();
tbxWetOutDataTotalMixQuantityUsgals.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantityUsgals(workId).ToString();
tbxWetOutDataTotalMixQuantityDrumsIns.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantityDrumsIns(workId);
ddlWetOutDataInversionType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetInversionType(workId);
tbxWetOutDataDepthOfInversionMH.Text = fullLengthLiningWorkDetailsGateway.GetDepthOfInversionMH(workId).ToString();
tbxWetOutDataTubeForColumn.Text = fullLengthLiningWorkDetailsGateway.GetTubeForColumn(workId).ToString();
tbxWetOutDataTubeForStartDry.Text = fullLengthLiningWorkDetailsGateway.GetTubeForStartDry(workId).ToString();
tbxWetOutDataTotalTube.Text = fullLengthLiningWorkDetailsGateway.GetTotalTube(workId).ToString();
tbxWetOutDataDropTubeConnects.Text = fullLengthLiningWorkDetailsGateway.GetDropTubeConnects(workId);
tbxWetOutDataAllowsHeadTo.Text = fullLengthLiningWorkDetailsGateway.GetAllowsHeadTo(workId).ToString();
tbxWetOutDataRollerGap.Text = fullLengthLiningWorkDetailsGateway.GetRollerGap(workId).ToString();
tbxWetOutDataHeightNeeded.Text = fullLengthLiningWorkDetailsGateway.GetHeightNeeded(workId).ToString();
tbxWetOutDataAvailable.Text = fullLengthLiningWorkDetailsGateway.GetAvailable(workId);
tbxWetOutDataHoistHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistHeight(workId);
hdfResinId.Value = fullLengthLiningWorkDetailsGateway.GetResinId(workId).ToString();
hdfMadeBy.Value = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId).ToString();
tbxWetOutDataNotes.Text = fullLengthLiningWorkDetailsGateway.GetCommentsCipp(workId);
lblWetOutDataResinGray.Text = fullLengthLiningWorkDetailsGateway.GetResinsLabel(workId);
lblWetOutDataDrumContainsGray.Text = fullLengthLiningWorkDetailsGateway.GetDrumContainsLabel(workId);
lblWetOutDataLinerTubeGray.Text = fullLengthLiningWorkDetailsGateway.GetLinerTubeLabel(workId);
lblWetOutDataLbDrumsGrey.Text = fullLengthLiningWorkDetailsGateway.GetForLbDrumsLabel(workId);
lblWetOutDataNetResinGrey.Text = fullLengthLiningWorkDetailsGateway.GetNetResinLabel(workId);
lblWetOutDataCatalystGrey.Text = fullLengthLiningWorkDetailsGateway.GetCatalystLabel(workId);
// ... ... graphic labels
lblWetOutDataDimensionLabel.Text = confirmedSize + " ins x " + ddlThickness.SelectedValue + " mm Tube";
lblWetOutDataTotalTubeLengthlabel.Text = "Total Tube Length " + tbxWetOutDataTotalTube.Text + " ft";
lblWetOutDataForColumnLabel.Text = tbxWetOutDataTubeForColumn.Text + " ft for Column";
lblWetOutDataDryFtLabel.Text = "Dry " + tbxWetOutDataTubeForStartDry.Text + " ft";
lblWetOutDataWetOutLengthlabel.Text = "Wet-Out Length " + tbxWetOutDataLengthtToWetOut.Text + " ft";
lblWetOutDataDryFtEndLabel.Text = "Dry " + tbxWetOutDataTubeForColumn.Text + " ft";
lblWetOutDataTailEndlabel.Text = "Tail End";
lblWetOutDataColumnEndlabel.Text = "Column End";
lblWetOutDataRollerGapLabel.Text = "Roller Gap " + tbxWetOutDataRollerGap.Text + " mm";
}
else
{
// Wet Out Data
// ... Show current day for new sheets
DateTime sheetDate = DateTime.Now;
tbxWetOutDataDateOfSheet.Text = sheetDate.Month.ToString() + "/" + sheetDate.Day.ToString() + "/" + sheetDate.Year.ToString();
// Set default values.
tbxWetOutDataExcessResin.Text = "0.0";
ddlWetOutDataPoundsDrums.SelectedIndex = 1;
tbxWetOutDataDrumDiameter.Text = "22.5";
tbxWetOutDataHoistMaximumHeight.Text = "24";
tbxWetOutDataHoistMinimumHeight.Text = "5";
tbxWetOutDataDownDropTubeLength.Text = "19";
tbxWetOutDataPumpHeightAboveGround.Text = "6";
tbxWetOutDataTubeResinToFeltFactor.Text = "87";
tbxWetOutDataPlusExtra.Text = "3";
tbxWetOutDataForTurnOffset.Text = "0";
tbxWetOutDataExtraResinForMix.Text = "0";
tbxWetOutDataTubeForColumn.Text = "16";
tbxWetOutDataTubeForStartDry.Text = "3";
if (ddlWetOutDataInversionType.SelectedValue == "Top")
{
Distance usmhDepthDistance = new Distance(tbxM1DataUsmhDepth.Text);
tbxWetOutDataDepthOfInversionMH.Text = decimal.Round(decimal.Parse(usmhDepthDistance.ToStringInEng3()), 1).ToString();
}
else
{
if (ddlWetOutDataInversionType.SelectedValue == "Bottom")
{
Distance dsmhDepthDistance = new Distance(tbxM1DataDsmhDepth.Text);
tbxWetOutDataDepthOfInversionMH.Text = decimal.Round(decimal.Parse(dsmhDepthDistance.ToStringInEng3()), 1).ToString();
}
else
{
tbxWetOutDataDepthOfInversionMH.Text = "0";
}
}
tbxWetOutDataRollerGap.Text = "13";
tbxWetOutDataNotes.Text = fullLengthLiningWorkDetailsGateway.GetCommentsCipp(workId);
// ...Section values
// ... ... Length To Line = Steel Tape Length, the first section to consider is the work one in Xft Yin
Distance steelTapeLength = new Distance(tbxSteelTapeLength.Text);
tbxWetOutDataLengthToLine.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()), 1).ToString();
tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()),1).ToString();
double lengthToLine = double.Parse(steelTapeLength.ToStringInEng3());
// ... Run details
if (cbxlSectionId.Items.Count > 1)
{
hdfRunDetails.Value = hdfSectionId.Value;
}
// .... Install Date
tbxWetOutDataInstallDate.Text = "";
if (tkrdpInstallDataInstallDate.SelectedDate.ToString() != "")
{
DateTime? inversionDataInstalledOn = tkrdpInstallDataInstallDate.SelectedDate;
DateTime installedOnDateTime = (DateTime)inversionDataInstalledOn;
tbxWetOutDataInstallDate.Text = installedOnDateTime.Month.ToString() + "/" + installedOnDateTime.Day.ToString() + "/" + installedOnDateTime.Year.ToString();
}
}
// ... Verify if work has inversion information
WorkFullLengthLiningInversionGateway workFullLengthLiningInversionGateway = new WorkFullLengthLiningInversionGateway();
workFullLengthLiningInversionGateway.LoadByWorkId(workId, companyId);
// ... Verify if work has inversion information
if (workFullLengthLiningInversionGateway.Table.Rows.Count > 0)
{
// ... Inversion data
lblInversionDataSubtitle.Text = fullLengthLiningWorkDetailsGateway.GetLinerTube(workId);
DateTime inversionDataDateOfSheet = fullLengthLiningWorkDetailsGateway.GetDateOfSheet(workId);
tbxInversionDataDateOfSheet.Text = inversionDataDateOfSheet.Month.ToString() + "/" + inversionDataDateOfSheet.Day.ToString() + "/" + inversionDataDateOfSheet.Year.ToString();
int employeeId = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
tbxInversionDataMadeBy.Text = employeeGateway.GetLastName(employeeId) + " " + employeeGateway.GetFirstName(employeeId);
tbxInversionDataInstalledOn.Text = "";
if (fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId).HasValue)
{
DateTime? inversionDataInstalledOn = fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId);
DateTime inversionDataInstalledOnDateTime = (DateTime)inversionDataInstalledOn;
tbxInversionDataInstalledOn.Text = inversionDataInstalledOnDateTime.Month.ToString() + "/" + inversionDataInstalledOnDateTime.Day.ToString() + "/" + inversionDataInstalledOnDateTime.Year.ToString();
}
tbxInversionDataRunDetails2.Text = fullLengthLiningWorkDetailsGateway.GetRunDetails2(workId);
tbxInversionDataCommentsEdit.Text = fullLengthLiningWorkDetailsGateway.GetInversionComment(workId);
tbxInversionDataLinerSize.Text = confirmedSizeString + " ins x" + fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId);
tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(fullLengthLiningWorkDetailsGateway.GetLengthToLine(workId).ToString()), 1).ToString();
tbxInversionDataWetOutLenght.Text = fullLengthLiningWorkDetailsGateway.GetLengthToWetOut(workId).ToString();
ddlInversionDataInversionPipeType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPipeType(workId);
if (ddlInversionDataInversionPipeType.SelectedValue != "(Select)")
{
ckbxInversionDataIncludeInversionInformation.Checked = true;
}
else
{
ckbxInversionDataIncludeInversionInformation.Checked = false;
}
ddlInversionDataPipeCondition.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPipeCondition(workId);
ddlInversionDataGroundMoisture.SelectedValue = fullLengthLiningWorkDetailsGateway.GetGroundMoisture(workId);
tbxInversionDataBoilerSize.Text = fullLengthLiningWorkDetailsGateway.GetBoilerSize(workId).ToString();
tbxInversionDataPumpsTotalCapacity.Text = fullLengthLiningWorkDetailsGateway.GetPumpTotalCapacity(workId).ToString();
tbxInversionDataLayflatSize.Text = fullLengthLiningWorkDetailsGateway.GetLayFlatSize(workId).ToString();
tbxInversionDataLayflatQuantityTotal.Text = fullLengthLiningWorkDetailsGateway.GetLayFlatQuantityTotal(workId).ToString();
tbxInversionDataWaterStartTempTs.Text = fullLengthLiningWorkDetailsGateway.GetWaterStartTemp(workId).ToString();
tbxInversionDataTempT1.Text = fullLengthLiningWorkDetailsGateway.GetTemp1(workId).ToString();
tbxInversionDataHoldAtT1For.Text = fullLengthLiningWorkDetailsGateway.GetHoldAtT1(workId).ToString();
tbxInversionDataTempT2.Text = fullLengthLiningWorkDetailsGateway.GetTempT2(workId).ToString();
tbxInversionDataCookAtT2For.Text = fullLengthLiningWorkDetailsGateway.GetCookAtT2(workId).ToString();
tbxInversionDataCoolDownFor.Text = fullLengthLiningWorkDetailsGateway.GetCoolDownFor(workId).ToString();
tbxInversionDataCoolToTemp.Text = fullLengthLiningWorkDetailsGateway.GetCoolToTemp(workId).ToString();
tbxInversionDataDropInPipeRun.Text = fullLengthLiningWorkDetailsGateway.GetDropInPipeRun(workId).ToString();
tbxInversionDataPipeSlopeOf.Text = fullLengthLiningWorkDetailsGateway.GetPipeSlopOf(workId).ToString();
lblInversionData45F120F.Text = tbxInversionDataWaterStartTempTs.Text + "°F-" + tbxInversionDataTempT1.Text + "°F (hr)";
tbxInversionData45F120F.Text = fullLengthLiningWorkDetailsGateway.GetF45F120(workId).ToString();
tbxInversionDataHold.Text = fullLengthLiningWorkDetailsGateway.GetHold(workId).ToString();
lblInversionData120F185F.Text = tbxInversionDataTempT1.Text + "°F-" + tbxInversionDataTempT2.Text + "°F (hr)";
tbxInversionData120F185F.Text = fullLengthLiningWorkDetailsGateway.GetF120F185(workId).ToString();
tbxInversionDataCookTime.Text = fullLengthLiningWorkDetailsGateway.GetCookTime(workId).ToString();
tbxInversionDataCoolTime.Text = fullLengthLiningWorkDetailsGateway.GetCoolTime(workId).ToString();
tbxInversionDataAproxTotal.Text = fullLengthLiningWorkDetailsGateway.GetAproxTotal(workId).ToString();
tbxInversionDataWaterChangesPerHour.Text = fullLengthLiningWorkDetailsGateway.GetWaterChangesPerHour(workId).ToString();
tbxInversionDataReturnWaterVelocity.Text = fullLengthLiningWorkDetailsGateway.GetReturnWaterVelocity(workId).ToString();
tbxInversionDataLayflatBackPressure.Text = fullLengthLiningWorkDetailsGateway.GetLayflatBackPressure(workId).ToString();
tbxInversionDataPumpLiftAtIdealHead.Text = fullLengthLiningWorkDetailsGateway.GetPumpLiftAtIdealHead(workId).ToString();
tbxInversionDataWaterToFillLinerColumn.Text = fullLengthLiningWorkDetailsGateway.GetWaterToFillLinerColumn(workId).ToString();
tbxInversionDataWaterPerFit.Text = fullLengthLiningWorkDetailsGateway.GetWaterPerFit(workId).ToString();
tbxInversionDataNotesAndInstallationResults.Text = fullLengthLiningWorkDetailsGateway.GetInstallationResults(workId);
lblInversionDataLinerInfoGrey.Text = fullLengthLiningWorkDetailsGateway.GetInversionLinerTubeLabel(workId);
lblInversionDataHeadsGrey.Text = fullLengthLiningWorkDetailsGateway.GetHeadsIdealLabel(workId);
lblInversionDataPumpingCirculationSubtitle.Text = fullLengthLiningWorkDetailsGateway.GetPumpingAndCirculationLabel(workId);
// ... ... graphic labels
lblInversionDataMaxColdForTubeLabel.Text = tbxWetOutDataTubeMaxColdHead.Text + " ft = Max Cold for tube";
lblInversionDataMaxHotForTubeLabel.Text = tbxWetOutDataTubeMaxHotHead.Text + " ft = Max Hot for tube";
lblInversionDataIdelForTubeLabel.Text = tbxWetOutDataTubeIdealHead.Text + " ft = Ideal for tube";
double maxColdForTubeEnd = double.Parse(tbxWetOutDataTubeMaxColdHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text);
lblInversionDataMaxColdForTubeEndLabel.Text = decimal.Round(decimal.Parse(maxColdForTubeEnd.ToString()), 1).ToString() + " ft";
double maxHotForTubeEnd = double.Parse(tbxWetOutDataTubeMaxHotHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text);
lblInversionDataMaxHotForTubeEndLabel.Text = decimal.Round(decimal.Parse(maxHotForTubeEnd.ToString()), 1).ToString() + " ft";
double idealForTubeEnd = double.Parse(tbxWetOutDataTubeIdealHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text);
lblInversionDataIdelForTubeEndLabel.Text = decimal.Round(decimal.Parse(idealForTubeEnd.ToString()), 1).ToString() + " ft";
lblInversionDataPumpHeightLabel.Text = " " + tbxWetOutDataPumpHeightAboveGround.Text + " ft";
lblInversionDataLinerSizeLabel.Text = confirmedSize.ToString() + " ins x" + fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId) + " Liner";
lblInversionDataRunLengthLabel.Text = "Run Length: " + tbxInversionDataRunLength.Text + " ft; Fall: " + tbxInversionDataDropInPipeRun.Text + " ft";
lblInversionDataDepthOfInversionMHLabel.Text = " " + tbxWetOutDataDepthOfInversionMH.Text + " ft";
lblInversionDataEndLabel.Text = "End";
}
else
{
// Wet Out Data
// ... Show current day for new sheets
DateTime sheetDate = DateTime.Now;
tbxInversionDataDateOfSheet.Text = sheetDate.Month.ToString() + "/" + sheetDate.Day.ToString() + "/" + sheetDate.Year.ToString();
// Set default values.
lblInversionData45F120F.Text = "";
lblInversionData120F185F.Text = "";
tbxInversionDataBoilerSize.Text = "7000000";
tbxInversionDataPumpsTotalCapacity.Text = "300";
tbxInversionDataLayflatSize.Text = "4";
tbxInversionDataLayflatQuantityTotal.Text = "1";
tbxInversionDataWaterStartTempTs.Text = "45";
tbxInversionDataTempT1.Text = "120";
tbxInversionDataHoldAtT1For.Text = "0.5";
tbxInversionDataTempT2.Text = "185";
tbxInversionDataCookAtT2For.Text = "2";
tbxInversionDataCoolDownFor.Text = "1";
tbxInversionDataCoolToTemp.Text = "85";
// ...Section values
// ... ... Length To Line = Steel Tape Length, the first section to consider is the work one in Xft Yin
Distance steelTapeLength = new Distance(tbxSteelTapeLength.Text);
tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()), 1).ToString();
double lengthToLine = double.Parse(steelTapeLength.ToStringInEng3());
// ... Run details
if (cbxlSectionId.Items.Count > 1)
{
hdfRunDetails.Value = hdfSectionId.Value;
}
// .... Install Date
tbxInversionDataInstalledOn.Text = "";
if (tkrdpInstallDataInstallDate.SelectedDate.ToString() != "")
{
DateTime? inversionDataInstalledOn = tkrdpInstallDataInstallDate.SelectedDate;
DateTime installedOnDateTime = (DateTime)inversionDataInstalledOn;
tbxInversionDataInstalledOn.Text = installedOnDateTime.Month.ToString() + "/" + installedOnDateTime.Day.ToString() + "/" + installedOnDateTime.Year.ToString();
}
}
// ... Show FLL Comments + RA Comments
int flWorkId = workId;
// ... ... Get raWorkId
int raWorkId = 0;
int projectId = Int32.Parse(hdfCurrentProjectId.Value);
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByProjectIdAssetIdWorkType(projectId, assetId, "Rehab Assessment", companyId);
if (workGateway.Table.Rows.Count > 0)
{
raWorkId = workGateway.GetWorkId(assetId, "Rehab Assessment", projectId);
}
// ... ... Get comments
FullLengthLiningAllComments fullLengthLiningAllComments = new FullLengthLiningAllComments(fullLengthLiningTDS);
fullLengthLiningAllComments.LoadAllByFlWorkIdRaWorkId(flWorkId, raWorkId, companyId);
// ... ... Store datasets
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
// ... ... Show comments
tbxCommentsDataComments.Text = fullLengthLiningAllComments.GetFLOrRAComments(companyId, fullLengthLiningAllComments.Table.Rows.Count, "\n");
}
}
protected void ddlActionsNew_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = grdToDoList.FooterRow;
DropDownList action = ((DropDownList)row.FindControl("ddlActionsNew"));
switch (action.SelectedValue)
{
case "Assign To User":
((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).Visible = true;
((CustomValidator)row.FindControl("cvTeamMemberNew")).Visible = true;
((TextBox)row.FindControl("tbxUserNew")).Visible = false;
((Label)row.FindControl("lblUserNew")).Text = "Assign To";
break;
case "Add Comment":
int loginId = Convert.ToInt32(Session["loginID"]);
EmployeeGateway employeeGateway = new EmployeeGateway();
int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId);
((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).Visible = false;
((CustomValidator)row.FindControl("cvTeamMemberNew")).Visible = false;
((TextBox)row.FindControl("tbxUserNew")).Visible = true;
((Label)row.FindControl("lblUserNew")).Text = "Comment Added By";
EmployeeGateway employeeGatewayForUser = new EmployeeGateway();
employeeGatewayForUser.LoadByEmployeeId(employeeId);
((TextBox)row.FindControl("tbxUserNew")).Text = employeeGatewayForUser.GetFullName(employeeId);
break;
case "Complete":
((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).Visible = false;
((CustomValidator)row.FindControl("cvTeamMemberNew")).Visible = false;
((TextBox)row.FindControl("tbxUserNew")).Visible = true;
((Label)row.FindControl("lblUserNew")).Text = "To Do Completed By";
EmployeeGateway employeeGatewayForUserComplete = new EmployeeGateway();
employeeGatewayForUserComplete.LoadByEmployeeId(Int32.Parse(hdfAssignedUser.Value));
((TextBox)row.FindControl("tbxUserNew")).Text = employeeGatewayForUserComplete.GetFullName(Int32.Parse(hdfAssignedUser.Value));
break;
case "Put On Hold":
int loginIdOnHold = Convert.ToInt32(Session["loginID"]);
EmployeeGateway employeeGatewayOnHold = new EmployeeGateway();
int employeeIdOnHold = employeeGatewayOnHold.GetEmployeIdByLoginId(loginIdOnHold);
((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).Visible = false;
((CustomValidator)row.FindControl("cvTeamMemberNew")).Visible = false;
((TextBox)row.FindControl("tbxUserNew")).Visible = true;
((Label)row.FindControl("lblUserNew")).Text = "On Hold By";
EmployeeGateway employeeGatewayForOnHold = new EmployeeGateway();
employeeGatewayForOnHold.LoadByEmployeeId(employeeIdOnHold);
((TextBox)row.FindControl("tbxUserNew")).Text = employeeGatewayForOnHold.GetFullName(employeeIdOnHold);
break;
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Validate query string
if (((string)Request.QueryString["source_page"] == null) && ((string)Request.QueryString["others"] == null) && ((string)Request.QueryString["employee_id"] == null) && ((string)Request.QueryString["period_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_add.aspx");
}
// Security check
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (Request.QueryString["others"] == "no")
{
if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_ADD"])))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
else
{
if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_ADD"])))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_ADD"])))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
}
}
}
}
// Tag Page
hdfSaveClick.Value = "false";
hdfEmployeeID.Value = Request.QueryString["employee_id"].ToString();
hdfPeriodId.Value = Request.QueryString["period_id"];
hdfCompanyId.Value = Session["companyID"].ToString();
hdfIsMoreThan15.Value = "false";
hdfIsMoreThan15Edit.Value = "false";
Session.Remove("projectTimeTempNewDummy");
// Initialize viewstate variables
ViewState["others"] = Request.QueryString["others"];
ViewState["timesheetState"] = "For Approval";
// Get State
int employeeId = Int32.Parse(hdfEmployeeID.Value);
int periodId = Int32.Parse(hdfPeriodId.Value);
TimesheetGateway timesheet = new TimesheetGateway();
timesheet.LoadByEmployeeIdPayPeriodId(employeeId, periodId);
if (timesheet.Table.Rows.Count != 0)
{
ViewState["timesheetState"] = timesheet.GetStateByEmployeeIdPayPeriodId(employeeId, periodId);
}
if (Request.QueryString["source_page"] == "timesheet_summary.aspx" || Request.QueryString["source_page"] == "timesheet_summary_from_approve_project_times.aspx")
{
ViewState["projecttime_id"] = int.Parse(Request.QueryString["projecttime_id"]);
}
System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader();
ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString();
// Timesheet state check
if (((string)ViewState["LHMode"] == "Full") && (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])))
{
TimesheetGateway timesheetGateway = new TimesheetGateway();
timesheetGateway.LoadByEmployeeIdPayPeriodId(employeeId, periodId);
if ((timesheetGateway.Table.Rows.Count != 0) && (timesheetGateway.GetStateByEmployeeIdPayPeriodId(employeeId, periodId) != "Rejected"))
{
Response.Redirect("./../../error_page.aspx?error=" + "You cannot add project time to an approved or submitted timesheet.");
}
}
// Prepare initial data for client
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
employeeGateway.LoadByEmployeeId(employeeId);
tbxEmployee.Text = employeeGateway.GetFullName(employeeId);
tbxState.Text = "For Approval";
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesList companiesList = new CompaniesList(new DataSet());
companiesList.LoadAndAddItem(-1, "(Select a client)", companyId);
ddlClient.DataSource = companiesList.Table;
ddlClient.DataValueField = "COMPANIES_ID";
ddlClient.DataTextField = "Name";
ddlClient.DataBind();
ddlClient.SelectedIndex = 0;
ProjectList projectList = new ProjectList();
projectList.LoadActiveProjectsActiveInternalProjectsActiveBallparkProjectsAndAddItem(-1, "(Select a project)", -1);
ddlProject.DataSource = projectList.Table;
ddlProject.DataValueField = "ProjectID";
ddlProject.DataTextField = "Name";
ddlProject.DataBind();
ddlProject.SelectedIndex = 0;
CountryList countryList = new CountryList(new DataSet());
countryList.LoadAndAddItem(-1, " ");
ddlMealsCountry.DataSource = countryList.Table;
ddlMealsCountry.DataValueField = "CountryID";
ddlMealsCountry.DataTextField = "Name";
ddlMealsCountry.DataBind();
tkrdpStartDate.SelectedDate = DateTime.Now;
tkrdpEndDate.SelectedDate = DateTime.Now;
// Store timesheet dataset
projectTimeTDS = new ProjectTimeTDS();
Session["projectTimeTDS"] = projectTimeTDS;
projectTimeTemp = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
Session["projectTimeTemp"] = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
}
else
{
// Restore datasets
projectTimeTDS = (ProjectTimeTDS)Session["projectTimeTDS"];
projectTimeTemp = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
// Store datasets
Session["projectTimeTemp"] = projectTimeTemp;
}
}
protected void grdToDoList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("activityDataEdit");
if (Page.IsValid)
{
int toDoId = (int)e.Keys["ToDoID"];
int refId = (int)e.Keys["RefID"];
int employeeId = 0;
int loginId = Convert.ToInt32(Session["loginID"]);
EmployeeGateway employeeGateway = new EmployeeGateway();
string comment = ((TextBox)grdToDoList.Rows[e.RowIndex].Cells[4].FindControl("tbxCommentsEdit")).Text;
string employeeFullName = "";
string type_ = ((Label)grdToDoList.Rows[e.RowIndex].Cells[4].FindControl("lblType")).Text;
switch (type_)
{
case "AssignUser":
employeeId = Int32.Parse(((DropDownList)grdToDoList.Rows[e.RowIndex].Cells[4].FindControl("ddlAssignToTeamMemberEdit")).SelectedValue);
employeeGateway.LoadByEmployeeId(employeeId);
employeeFullName = employeeGateway.GetFullName(employeeId);
break;
case "AddComment":
employeeId = employeeGateway.GetEmployeIdByLoginId(loginId);
EmployeeGateway employeeGatewayForComment = new EmployeeGateway();
employeeGatewayForComment.LoadByEmployeeId(employeeId);
employeeFullName = employeeGatewayForComment.GetFullName(employeeId);
break;
case "CloseToDo":
employeeId = Int32.Parse(hdfAssignedUser.Value);
employeeGateway.LoadByEmployeeId(employeeId);
employeeFullName = employeeGateway.GetFullName(employeeId);
hdfCompleted.Value = "True";
break;
case "OnHoldToDo":
employeeId = employeeGateway.GetEmployeIdByLoginId(loginId);
EmployeeGateway employeeGatewayForOnHold = new EmployeeGateway();
employeeGatewayForOnHold.LoadByEmployeeId(employeeId);
employeeFullName = employeeGatewayForOnHold.GetFullName(employeeId);
break;
}
ToDoListInformationActivityInformation model = new ToDoListInformationActivityInformation(toDoListInformationTDS);
model.Update(toDoId, refId, employeeId, employeeFullName, comment);
// Store dataset
Session["toDoListInformationTDS"] = toDoListInformationTDS;
}
else
{
e.Cancel = true;
}
}
protected void cvJobClassEmptyFooter_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = true;
int employeeId = Int32.Parse(hdfEmployeeID.Value);
EmployeeGateway employee = new EmployeeGateway();
employee.LoadByEmployeeId(employeeId);
string jobClass = employee.GetJobClassType(employeeId);
if (jobClass == "")
{
args.IsValid = false;
}
}
private void GrdToDoAdd()
{
if (ValidateToDoFooter())
{
Page.Validate("activityDataNew");
if (Page.IsValid)
{
int employeeId = 0;
EmployeeGateway employeeGateway = new EmployeeGateway();
string dateTime_ = ((TextBox)grdToDoList.FooterRow.FindControl("tbxDateTimeNew")).Text;
string comment = ((TextBox)grdToDoList.FooterRow.FindControl("tbxCommentsNew")).Text;
string type_ = "";
string employeeFullName = "";
GridViewRow row = grdToDoList.FooterRow;
DropDownList action = ((DropDownList)row.FindControl("ddlActionsNew"));
switch (action.SelectedValue)
{
case "Assign To User":
employeeId = Int32.Parse(((DropDownList)grdToDoList.FooterRow.FindControl("ddlAssignToTeamMemberNew")).SelectedValue);
employeeGateway.LoadByEmployeeId(employeeId);
employeeFullName = employeeGateway.GetFullName(employeeId);
type_ = "AssignUser";
hdfToDoListState.Value = "In Progress";
break;
case "Add Comment":
int loginId = Convert.ToInt32(Session["loginID"]);
employeeId = employeeGateway.GetEmployeIdByLoginId(loginId);
type_ = "AddComment";
employeeFullName = employeeGateway.GetFullName(employeeId);
hdfToDoListState.Value = "In Progress";
break;
case "Complete":
employeeId = Int32.Parse(hdfAssignedUser.Value);
employeeGateway.LoadByEmployeeId(employeeId);
employeeFullName = employeeGateway.GetFullName(employeeId);
type_ = "CloseToDo";
hdfCompleted.Value = "True";
hdfToDoListState.Value = "Completed";
break;
case "Put On Hold":
int loginIdOnHold = Convert.ToInt32(Session["loginID"]);
employeeId = employeeGateway.GetEmployeIdByLoginId(loginIdOnHold);
type_ = "OnHoldToDo";
employeeFullName = employeeGateway.GetFullName(employeeId);
hdfToDoListState.Value = "On Hold";
break;
}
// static values
int toDoId = Int32.Parse(hdfToDoId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
bool inDatabase = false;
ToDoListInformationBasicInformation generalModel = new ToDoListInformationBasicInformation(toDoListInformationTDS);
generalModel.UpdateState(toDoId, hdfToDoListState.Value);
ToDoListInformationActivityInformation model = new ToDoListInformationActivityInformation(toDoListInformationTDS);
model.Insert(toDoId, employeeId, type_, DateTime.Parse(dateTime_), comment, false, companyId, inDatabase, employeeFullName);
Session.Remove("activityInformationDummy");
Session["toDoListInformationTDS"] = toDoListInformationTDS;
grdToDoList.DataBind();
}
}
}
// ////////////////////////////////////////////////////////////////////////
// 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_FULL_EDITING"]))
{
if (Request.QueryString["others"] == "no")
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
else
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]))
{
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) && ((string)Request.QueryString["others"] == null) && ((string)Request.QueryString["employee_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_all.aspx");
}
// Tag page
Session.Remove("timesheetAllDummy");
// Initialize variables
lblError.Visible = false;
ViewState["others"] = Request.QueryString["others"];
if ((string)ViewState["others"] == "yes")
{
ViewState["employee_id"] = int.Parse(Request.QueryString["employee_id"]);
}
else
{
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
}
System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader();
ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString();
// Prepare initial data for client
// ... Title
if ((string)ViewState["others"] == "no")
{
lblTitle.Text = "All My Timesheets";
}
else
{
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
employeeGateway.LoadByEmployeeId((int)ViewState["employee_id"]);
lblTitle.Text = "All Timesheets For " + employeeGateway.GetFullName((int)ViewState["employee_id"]);
}
// Load data
timesheetAllTDS = this.SubmitSearch();
Session["timesheetAllTDS"] = timesheetAllTDS;
timesheetAll = timesheetAllTDS.TIMESHEET_ALL;
Session["timesheetAll"] = timesheetAll;
}
else
{
// Restore dataset
timesheetAllTDS = (TimesheetAllTDS)Session["timesheetAllTDS"];
timesheetAll = timesheetAllTDS.TIMESHEET_ALL;
Session["timesheetAll"] = timesheetAll;
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm6 master = (mForm6)this.Master;
master.ActiveToolbar = "LabourHours";
// ... Labour Hours Mode
if ((string)ViewState["LHMode"] == "Partial")
{
// Access control
// ... Employees
EmployeeListGateway employeeListGateway = new EmployeeListGateway(new DataSet());
employeeListGateway.LoadByRequestProjectTime(1);
DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor");
ddlOthersFor.DataSource = employeeListGateway.Table;
ddlOthersFor.DataValueField = "EmployeeID";
ddlOthersFor.DataTextField = "FullName";
ddlOthersFor.DataBind();
tkrpbLeftMenuMyTimesheets.Visible = false;
tkrpbLeftMenuOthersTimesheets.Items[0].Text = "Timesheets";
tkrpbLeftMenuTools.Items[0].Items[1].Visible = false;
}
else
{
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
int employeeId = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
employeeGateway1.LoadByEmployeeId(employeeId);
if (Request.QueryString["source_page"] == "timesheet_approve.aspx")
{
tkrmTop.Items[3].Visible = false; //Timesheet
tkrmTop.Items[4].Visible = true; //Approve Project Times
}
else
{
tkrmTop.Items[3].Visible = true; //Timesheet
// Timesheet state check
ProjectTimeGateway projectTimeGatewayForState = new ProjectTimeGateway(projectTimeTDS);
int projecttime_id = Int32.Parse(ViewState["projecttime_id"].ToString());
if (projectTimeGatewayForState.GetProjectTimeState(projecttime_id) == "For Approval")
{
tkrmTop.Items[4].Visible = true; //Approve Project Times
}
else
{
tkrmTop.Items[4].Visible = false; //Approve Project Times
}
}
if (!employeeGateway1.GetApproveTimesheets(employeeId))
{
tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; //Approve Project Times
}
if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
tkrpbLeftMenuOthersTimesheets.Visible = true;
tkrpbLeftMenuTools.Items[0].Items[0].Visible = true; // Add Team Project Time
tkrpbLeftMenuTools.Items[0].Items[2].Visible = true; // Missing Project Time
// Access control
// ... Employees
EmployeeListGateway employeeListGateway = new EmployeeListGateway(new DataSet());
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
employeeListGateway.LoadByRequestProjectTimeWithoutEmployeeId(1, employeeId);
}
else
{
employeeListGateway.LoadByRequestProjectTime(1);
}
DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor");
ddlOthersFor.DataSource = employeeListGateway.Table;
ddlOthersFor.DataValueField = "EmployeeID";
ddlOthersFor.DataTextField = "FullName";
ddlOthersFor.DataBind();
try
{
ddlOthersFor.SelectedValue = Session["ddlOthersForSelectedValue"].ToString();
}
catch
{
}
}
else
{
tkrpbLeftMenuOthersTimesheets.Visible = false;
if (!employeeGateway1.GetApproveTimesheets(employeeId))
{
tkrpbLeftMenuTools.Visible = false;
}
tkrpbLeftMenuTools.Items[0].Items[0].Visible = false; // Add Team Project Time
tkrpbLeftMenuTools.Items[0].Items[2].Visible = false; // Missing Project Time
}
if (!((Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) && (employeeGateway1.GetRequestProjectTime(employeeId))))
{
tkrpbLeftMenuMyTimesheets.Visible = false;
tkrpbLeftMenuOthersTimesheets.Items[0].Text = "Timesheets";
}
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_REPORTS"]))
{
tkrpbLeftMenuReports.Visible = false;
}
}
// Get ProjectTime record, can't edit or delete approved timesheets
ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS);
projectTimeGateway.LoadByProjectTimeId((int)ViewState["projecttime_id"]);
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (projectTimeGateway.GetProjectTimeState((int)ViewState["projecttime_id"]) == "Approved")
{
tkrmTop.Items[1].Visible = false;
tkrmTop.Items[2].Visible = false;
}
}
}
}
private void LoadDetailaDataAssignmentData(int serviceId, ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway)
{
// Load for Assignment Tab
// ... pnlAssignmentData
tbxAssignmentDataAssignmentDateTime.Text = serviceInformationBasicInformationGateway.GetAssignmentDateTime(serviceId).ToString();
if (serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId).HasValue)
{
DateTime deadlineDate = (DateTime)serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId);
tkrdpAssignmentDataAssignedDeadlineDate.SelectedDate = DateTime.Parse(deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString());
}
if ((serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) == "")
{
// ... For team member
rbtnAssignmentDataToTeamMember.Checked = true;
rbtnAssignmentDataToTeamMemberReadOnly.Checked = true;
// ... For third party vendor
rbtnAssignmentDataToThirdPartyVendor.Checked = false;
rbtnAssignmentDataToThirdPartyVendorReadOnly.Checked = false;
}
else
{
if ((!serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) != "")
{
// ... For team member
rbtnAssignmentDataToTeamMember.Checked = false;
rbtnAssignmentDataToTeamMemberReadOnly.Checked = false;
// ... For third party vendor
rbtnAssignmentDataToThirdPartyVendor.Checked = true;
rbtnAssignmentDataToThirdPartyVendorReadOnly.Checked = true;
tbxAssignmentDataAssignToThirdPartyVendor.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId);
tbxAssignmentDataAssignToThirdPartyVendorReadOnly.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId);
}
else
{
rbtnAssignmentDataToTeamMember.Checked = false;
rbtnAssignmentDataToTeamMemberReadOnly.Checked = false;
rbtnAssignmentDataToThirdPartyVendor.Checked = false;
rbtnAssignmentDataToThirdPartyVendorReadOnly.Checked = false;
}
}
tbxAssignmentDataAcceptedDateTime.Text = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId).ToString();
DateTime? acceptedDateTime = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId);
if (acceptedDateTime.HasValue) tbxAssignmentDataAcceptedDateTime.Text = acceptedDateTime.ToString();
DateTime? rejectedDateTime = serviceInformationBasicInformationGateway.GetRejectedDateTime(serviceId);
if (rejectedDateTime.HasValue) tbxAssignmentDataRejectedDateTime.Text = rejectedDateTime.ToString();
tbxAssignmentDataRejectedReason.Text = serviceInformationBasicInformationGateway.GetRejectedReason(serviceId);
// ... pnlAssignmentDataReadOnly
tbxAssignmentDataAssignmentDateTimeReadOnly.Text = serviceInformationBasicInformationGateway.GetAssignmentDateTime(serviceId).ToString();
tbxAssignmentDataAssignedDeadlineDateReadOnly.Text = "";
if (serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId).HasValue)
{
DateTime deadlineDate = (DateTime)serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId);
tbxAssignmentDataAssignedDeadlineDateReadOnly.Text = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString();
}
if ((serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) == "")
{
// ... For team member
rbtnAssignmentDataReadOnlyToTeamMemberReadOnly.Checked = true;
if (serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId).HasValue)
{
int teamMemberId = (int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(teamMemberId);
tbxAssignmentDataReadOnlyAssignToTeamMemberReadOnly.Text = employeeGateway.GetLastName(teamMemberId) + " " + employeeGateway.GetFirstName(teamMemberId);
}
// ... For third party vendor
rbtnAssignmentDataReadOnlyToThirdPartyVendorReadOnly.Checked = false;
}
else
{
if ((!serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) != "")
{
// ... For team member
rbtnAssignmentDataReadOnlyToTeamMemberReadOnly.Checked = false;
// ... For third party vendor
rbtnAssignmentDataReadOnlyToThirdPartyVendorReadOnly.Checked = true;
tbxAssignmentDataReadOnlyAssignToThirdPartyVendorReadOnly.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId);
}
else
{
rbtnAssignmentDataReadOnlyToTeamMemberReadOnly.Checked = false;
rbtnAssignmentDataReadOnlyToThirdPartyVendorReadOnly.Checked = false;
}
}
tbxAssignmentDataAcceptedDateTimeReadOnly.Text = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId).ToString();
DateTime? acceptedDateTimeReadOnly = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId);
if (acceptedDateTimeReadOnly.HasValue) tbxAssignmentDataAcceptedDateTimeReadOnly.Text = acceptedDateTimeReadOnly.ToString();
DateTime? rejectedDateTimeReadOnly = serviceInformationBasicInformationGateway.GetRejectedDateTime(serviceId);
if (rejectedDateTimeReadOnly.HasValue) tbxAssignmentDataRejectedDateTimeReadOnly.Text = rejectedDateTimeReadOnly.ToString();
tbxAssignmentDataRejectedReasonReadOnly.Text = serviceInformationBasicInformationGateway.GetRejectedReason(serviceId);
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_VIEW"]) && Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_EDIT"])))
{
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) || ((string)Request.QueryString["employee_id"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in employees_summary.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfResourceType.Value = "Employees";
hdfActiveTab.Value = Request.QueryString["active_tab"].ToString();
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfCurrentEmployeeId.Value = Request.QueryString["employee_id"];
// Prepare initial data
Session.Remove("employeesNotesDummy");
Session.Remove("employeesCostsDummy");
Session.Remove("employeesCostsExceptionsDummy");
Session.Remove("employeesVacationsDummy");
Session.Remove("costIdSelected");
// ... for team member title
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int employeeId = Int32.Parse(hdfCurrentEmployeeId.Value);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
lblTitleTeamMember.Text = "Team Member: " + employeeGateway.GetFullName(employeeId);
// If coming from
// ... employees_navigator2.aspx, employees_add.aspx
if ((Request.QueryString["source_page"] == "employees_navigator2.aspx") || (Request.QueryString["source_page"] == "employees_add.aspx"))
{
StoreNavigatorState();
ViewState["update"] = "yes";
// ... ... Set initial tab
if ((string)Session["dialogOpenedEmployees"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
employeeInformationTDS = new EmployeeInformationTDS();
EmployeeInformationBasicInformation employeeInformationBasicInformation = new EmployeeInformationBasicInformation(employeeInformationTDS);
employeeInformationBasicInformation.LoadByEmployeeId(employeeId, companyId);
EmployeeInformationCostInformation employeeInformationCostInformation = new EmployeeInformationCostInformation(employeeInformationTDS);
employeeInformationCostInformation.LoadAllByEmployeeId(employeeId, companyId);
EmployeeInformationCostExceptionsInformation employeeInformationCostExceptionsInformation = new EmployeeInformationCostExceptionsInformation(employeeInformationTDS);
employeeInformationCostExceptionsInformation.LoadAllByEmployeeId(employeeId, companyId);
Session["costIdSelected"] = 0;
EmployeeInformationNoteInformation employeeInformationNoteInformationForEdit = new EmployeeInformationNoteInformation(employeeInformationTDS);
employeeInformationNoteInformationForEdit.LoadAllByEmployeeId(employeeId, companyId);
EmployeeInformationCategoryApproveTimesheetsInformation employeeInformationCategoryApproveTimesheetsInformation = new EmployeeInformationCategoryApproveTimesheetsInformation(employeeInformationTDS);
employeeInformationCategoryApproveTimesheetsInformation.LoadByEmployeeId(employeeId);
}
else
{
hdfActiveTab.Value = (string)Session["activeTabEmployees"];
// Restore datasets
employeeInformationTDS = (EmployeeInformationTDS)Session["employeeInformationTDS"];
}
tcDetailedInformation.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
// Store dataset
Session["employeeInformationTDS"] = employeeInformationTDS;
}
// ... employees_delete.aspx or employees_edit.aspx
if ((Request.QueryString["source_page"] == "employees_delete.aspx") || (Request.QueryString["source_page"] == "employees_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Restore dataset
employeeInformationTDS = (EmployeeInformationTDS)Session["employeeInformationTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedEmployees"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabEmployees"];
}
tcDetailedInformation.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
}
string filterOptions = string.Format("CostID = {0} AND Deleted = {1}", 0, 0);
odsCostsExceptions.FilterExpression = filterOptions;
// Prepare initial data
// ... Data for current employee
LoadData();
// Databind
Page.DataBind();
}
else
{
// Restore datasets
employeeInformationTDS = (EmployeeInformationTDS)Session["employeeInformationTDS"];
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcDetailedInformation.ActiveTabIndex = activeTab;
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_EDIT"])))
{
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) || ((string)Request.QueryString["service_id"] == null) || ((string)Request.QueryString["active_tab"] == null) || ((string)Request.QueryString["dashboard"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in services_edit.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfFmType.Value = "Services";
hdfServiceId.Value = Request.QueryString["service_id"].ToString();
hdfActiveTab.Value = Request.QueryString["active_tab"].ToString();
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfDashboard.Value = Request.QueryString["dashboard"].ToString();
// Prepare initial data
Session.Remove("serviceCostsDummy");
Session.Remove("serviceNotesDummy");
// If coming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int serviceId = Int32.Parse(hdfServiceId.Value.Trim());
string fmType = hdfFmType.Value;
// ... services_navigator2.aspx, services_add_request.aspx, services_manager_tool.aspx
if ((Request.QueryString["source_page"] == "services_navigator2.aspx") || (Request.QueryString["source_page"] == "services_add_request.aspx") || (Request.QueryString["source_page"] == "services_manager_tool.aspx"))
{
StoreNavigatorState();
ViewState["update"] = "no";
// ... Set initial tab
if ((string)Session["dialogOpenedServices"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
serviceInformationTDS = new ServiceInformationTDS();
ServiceInformationBasicInformation serviceInformationBasicInformation = new ServiceInformationBasicInformation(serviceInformationTDS);
serviceInformationBasicInformation.LoadByServiceId(serviceId, companyId);
ServiceInformationServiceCost serviceInformationServiceCostForEdit = new ServiceInformationServiceCost(serviceInformationTDS);
serviceInformationServiceCostForEdit.LoadByServiceId(serviceId, companyId);
ServiceInformationServiceNote serviceInformationServiceNoteForEdit = new ServiceInformationServiceNote(serviceInformationTDS);
serviceInformationServiceNoteForEdit.LoadByServiceId(serviceId, companyId);
}
else
{
hdfActiveTab.Value = (string)Session["activeTabServices"];
// Restore datasets
serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"];
}
// ... Store dataset
Session["serviceInformationTDS"] = serviceInformationTDS;
}
// ... services_summary.aspx or services_edit
if ((Request.QueryString["source_page"] == "services_summary.aspx") || (Request.QueryString["source_page"] == "services_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// ... Restore dataset
serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedServices"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
if (ViewState["update"].ToString().Trim() == "yes")
{
ServiceInformationBasicInformation serviceInformationBasicInformation = new ServiceInformationBasicInformation(serviceInformationTDS);
serviceInformationBasicInformation.LoadByServiceId(serviceId, companyId);
ServiceInformationServiceCost serviceInformationServiceCostForEdit = new ServiceInformationServiceCost(serviceInformationTDS);
serviceInformationServiceCostForEdit.LoadByServiceId(serviceId, companyId);
ServiceInformationServiceNote serviceInformationServiceNoteForEdit = new ServiceInformationServiceNote(serviceInformationTDS);
serviceInformationServiceNoteForEdit.LoadByServiceId(serviceId, companyId);
// ... Store dataset
Session["serviceInformationTDS"] = serviceInformationTDS;
}
}
else
{
hdfActiveTab.Value = (string)Session["activeTabServices"];
}
}
// Prepare initial data
lblMissingData.Visible = false;
// ... Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcDetailedInformation.ActiveTabIndex = activeTab;
// ... For total cost
ServiceInformationServiceCost serviceInformationServiceCostForTotalCost = new ServiceInformationServiceCost(serviceInformationTDS);
tbxTotalCost.Text = Decimal.Round(serviceInformationServiceCostForTotalCost.GetTotalCost(serviceId, companyId), 2).ToString();
// ... Data for current servicew
LoadServiceData(companyId);
// Databind
Page.DataBind();
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS);
if (serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId).HasValue)
{
try
{
ddlAssignmentDataAssignToTeamMember.SelectedValue = ((int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId)).ToString();
}
catch
{
ddlAssignmentDataAssignToTeamMember.SelectedIndex = 0;
}
int teamMemberId = (int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(teamMemberId);
tbxAssignmentDataAssignToTeamMemberReadOnly.Text = employeeGateway.GetLastName(teamMemberId) + " " + employeeGateway.GetFirstName(teamMemberId);
}
// For thirds party vendor autocomplete
aceThirdPartyVendor.ContextKey = serviceId.ToString() + "," + hdfCompanyId.Value;
// ... For Library
if (Session["libraryTDSForServices"] != null)
{
libraryTDSForServices = (LibraryTDS)Session["libraryTDSForServices"];
}
else
{
libraryTDSForServices = new LibraryTDS();
}
}
else
{
// Restore datasets
serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"];
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcDetailedInformation.ActiveTabIndex = activeTab;
if (Session["libraryTDSForServices"] != null)
{
libraryTDSForServices = (LibraryTDS)Session["libraryTDSForServices"];
}
else
{
libraryTDSForServices = new LibraryTDS();
}
LoadNotes();
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Validate query string
if ((string)Request.QueryString["source_page"] == null)
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_approve.aspx");
}
// Security check
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
int employeeId = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
hdfCurrentEmployeeId.Value = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])).ToString();
employeeGateway1.LoadByEmployeeId(employeeId);
if (!employeeGateway1.GetApproveTimesheets(employeeId))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Tag page
Session.Remove("projectTimeApproveDummy");
// Initialize variables
lblError.Visible = false;
// ... Initialize viewstate variables
System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader();
ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString();
// Labour Hours Mode check
if ((string)ViewState["LHMode"] == "Partial")
{
Response.Redirect("./../../error_page.aspx?error=" + "The system is on partial mode. Contact your system administrator.");
}
ViewState["others"] = Request.QueryString["others"];
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
ViewState["period_id"] = payPeriodGateway.GetPayPeriodId(DateTime.Now);
// Load data
// ... Loading employees accordingly to the admins country.
EmployeeList employeeList = new EmployeeList(new DataSet());
string employeeType = employeeGateway1.GetType(employeeId);
odsClient.SelectParameters.RemoveAt(2);
if (employeeType.Contains("CA"))
{
employeeList.LoadByRequestProjectTimeEmployeeTypeEmployeeIdApproveManagerAndAddItem(1, "CA", -1, "(All)", employeeId);
odsClient.SelectParameters.Add("countryId", "1");
}
else
{
if (employeeType.Contains("US"))
{
employeeList.LoadByRequestProjectTimeEmployeeTypeEmployeeIdApproveManagerAndAddItem(1, "US", -1, "(All)", employeeId);
odsClient.SelectParameters.Add("countryId", "2");
}
else
{
employeeList.LoadByRequestProjectTimeEmployeeTypeEmployeeIdApproveManagerAndAddItem(1, "SOTA", -1, "(All)", employeeId);
odsClient.SelectParameters.Add("countryId", "-1");
}
}
odsClient.Select();
ddlClient.SelectedIndex = 0;
upnlClient.Update();
ddlTeamMember.DataSource = employeeList.Table;
ddlTeamMember.DataValueField = "EmployeeID";
ddlTeamMember.DataTextField = "FullName";
ddlTeamMember.DataBind();
odsProject.SelectParameters.RemoveAt(2);
odsProject.SelectParameters.Add("clientId", "-1");
odsProject.Select();
ddlProject.DataBind();
ddlProject.SelectedIndex = 0;
upnlProject.Update();
projectTimeApproveTDS = this.SubmitSearch();
// Store Datasets
Session["projectTimeApproveTDS"] = projectTimeApproveTDS;
projectTimeApprove = projectTimeApproveTDS.ProjectTimeApprove;
Session["projectTimeApprove"] = projectTimeApproveTDS.ProjectTimeApprove;
// If coming from
// ... timesheet_edit.aspx, timesheet_summary.aspx or timesheet_delete.aspx
if ((Request.QueryString["source_page"] == "timesheet_edit.aspx") || (Request.QueryString["source_page"] == "timesheet_summary.aspx") || (Request.QueryString["source_page"] == "timesheet_delete.aspx"))
{
// ... restore top values
RestoreNavigatorState();
// ... filter grid information
//SetFilterByCountryIdClientIdProjectId();
//SetFilterByEmployeeIdDate();
SetFilterByClientIdProjectIdEmployeeIdDate();
}
ViewState["filter_expression"] = "Deleted = 0";
SetFocus();
}
else
{
// Restore dataset
projectTimeApproveTDS = (ProjectTimeApproveTDS)Session["projectTimeApproveTDS"];
projectTimeApprove = projectTimeApproveTDS.ProjectTimeApprove;
Session["projectTimeApprove"] = projectTimeApproveTDS.ProjectTimeApprove;
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string employeeType = (ddlEmployeeType.SelectedValue == "(All)") ? "%" : ddlEmployeeType.SelectedValue + "%";
string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue;
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
PrintMealsGateway printMealsGateway = new PrintMealsGateway();
if (ddlEmployee.SelectedValue == "-1")
{
if (ddlSalaried.SelectedValue == "(All)")
{
printMealsGateway.LoadByEmployeeTypeStartDateEndDateProjectTimeState(employeeType, startDate, endDate, projectTimeState);
}
else
{
printMealsGateway.LoadByEmployeeSalariedTypeStartDateEndDateProjectTimeState(employeeType, startDate, endDate, projectTimeState, int.Parse(ddlSalaried.SelectedValue));
}
}
else
{
if (ddlSalaried.SelectedValue == "(All)")
{
printMealsGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(ddlEmployee.SelectedValue), projectTimeState);
}
else
{
printMealsGateway.LoadByEmployeeTypeSalariedEmployeeIdStartDateEndDateProjectTimeState(employeeType, startDate, endDate, int.Parse(ddlEmployee.SelectedValue), projectTimeState, int.Parse(ddlSalaried.SelectedValue));
}
}
// ... set properties to master page
master.Data = printMealsGateway.Data;
master.Table = printMealsGateway.TableName;
// Get report
if (printMealsGateway.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintMealsReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintMealsReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... project time state
if (ddlProjectTimeState.SelectedValue == "(All)")
{
master.SetParameter("projectTimeState", "All");
}
else
{
master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text);
}
// ... ... team member
if (ddlEmployee.SelectedValue == "-1")
{
master.SetParameter("teamMember", "All");
}
else
{
int teamMemberId = Int32.Parse(ddlEmployee.SelectedValue);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(teamMemberId);
string fullName = employeeGateway.GetFullName(teamMemberId);
master.SetParameter("teamMember", fullName);
}
// ... ... team member type
if (ddlEmployeeType.SelectedValue == "(All)")
{
master.SetParameter("teamMemberType", "All");
}
else
{
if (ddlEmployeeType.SelectedValue == "LFSCA") master.SetParameter("teamMemberType", "LFS Canada");
if (ddlEmployeeType.SelectedValue == "LFSUS") master.SetParameter("teamMemberType", "LFS USA");
if (ddlEmployeeType.SelectedValue == "LFS") master.SetParameter("teamMemberType", "All LFS");
if (ddlEmployeeType.SelectedValue == "PAGCA") master.SetParameter("teamMemberType", "PAG Canada");
if (ddlEmployeeType.SelectedValue == "PAGUS") master.SetParameter("teamMemberType", "PAG USA");
if (ddlEmployeeType.SelectedValue == "PAG") master.SetParameter("teamMemberType", "All PAG");
if (ddlEmployeeType.SelectedValue == "SOTA") master.SetParameter("teamMemberType", "SOTA");
if (ddlEmployeeType.SelectedValue == "Salaried") master.SetParameter("teamMemberType", "Salaried");
if (ddlEmployeeType.SelectedValue == "Subcontractor") master.SetParameter("teamMemberType", "Subcontractor");
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... salaried
if (ddlSalaried.SelectedValue == "(All)")
{
master.SetParameter("salaried", "All");
}
else
{
if (ddlSalaried.SelectedValue == "1") master.SetParameter("salaried", "Yes");
if (ddlSalaried.SelectedValue == "0") master.SetParameter("salaried", "No");
}
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
else
{
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
}
}
private ProjectTimeApproveTDS SubmitSearch()
{
// Load data
ProjectTimeApproveTDS dataSet = new ProjectTimeApproveTDS();
ProjectTimeApproveGateway projectTimeApproveGateway = new ProjectTimeApproveGateway(dataSet);
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
int employeeId = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
employeeGateway1.LoadByEmployeeId(employeeId);
string employeeType = employeeGateway1.GetType(employeeId);
if (employeeType.Contains("CA"))
{
projectTimeApproveGateway.LoadByEmployeeTypeEmployeeIdApproveManager("CA", employeeId);
}
else
{
if (employeeType.Contains("US"))
{
projectTimeApproveGateway.LoadByEmployeeTypeEmployeeIdApproveManager("US", employeeId);
}
else
{
projectTimeApproveGateway.LoadByEmployeeTypeEmployeeIdApproveManager("SOTA", employeeId);
}
}
return dataSet;
}
protected void ddlWetOutDataMadeBy_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlWetOutDataMadeBy.SelectedValue != "(Select)")
{
int employeeId = Int32.Parse(ddlWetOutDataMadeBy.SelectedValue);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
tbxInversionDataMadeBy.Text = employeeGateway.GetLastName(employeeId) + " " + employeeGateway.GetFirstName(employeeId);
}
}