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);
}
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);
}
// ////////////////////////////////////////////////////////////////////////
// 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"];
}
}
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());
}
}
}
// ////////////////////////////////////////////////////////////////////////
// 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;
}
}
// ////////////////////////////////////////////////////////////////////////
// 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;
}
}
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)
{
// 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"];
}
}
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;
}
}
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();
}
}
}
private void UpdateDatabase()
{
// Get ids
int companyId = Int32.Parse(hdfCompanyId.Value);
DB.Open();
DB.BeginTransaction();
try
{
// ... Update general todo list state
SupportTicketInformationBasicInformation supportTicketInformationBasicInformation = new SupportTicketInformationBasicInformation(supportTicketInformationTDS);
supportTicketInformationBasicInformation.Save(companyId);
// ... Save to do list details
SupportTicketInformationActivityInformation supportTicketInformationActivityInformation = new SupportTicketInformationActivityInformation(supportTicketInformationTDS);
supportTicketInformationActivityInformation.Save(companyId);
// ... Send mails
int createdBy = Int32.Parse(hdfCreatedById.Value);
string mailTo = "";
string nameTo = "";
// ... ... MailtTo, nameTo
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(createdBy);
mailTo = employeeGateway.GetEMail(createdBy);
nameTo = employeeGateway.GetFullName(createdBy);
SupportTicketInformationActivityInformation supportTicketInformationActivityInformationForMails = new SupportTicketInformationActivityInformation(supportTicketInformationTDS);
foreach (GridViewRow row in grdSupportTicket.Rows)
{
bool sendMail = bool.Parse(((Label)row.FindControl("lblSendMail")).Text);
if (sendMail)
{
string subject = "";
string body = "";
string comment = "";
string type_ = ((Label)row.FindControl("lblType")).Text;
switch (type_)
{
case "AssignUser":
// Get mail information
subject = "A usser was assigned to the following ticket.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nA usser was assigned to the following ticket. \n";
body = body + "\n Subject: " + lblTitleSubjectName.Text;
body = body + "\n Created By: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Category: " + tbxCategoryName.Text;
string assignedUser = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
case "AssignToOwner":
// Get mail information
subject = "The following ticket was assigned to it's owner.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following ticket was assigned to it's owner. \n";
body = body + "\n Subject: " + lblTitleSubjectName.Text;
body = body + "\n Owner: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Category: " + tbxCategoryName.Text;
string assignedOwer = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n Assigned To Owner: " + assignedOwer;
body = body + "\n Due Date: " + tbxDueDate.Text;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
case "AddComment":
// Get mail information
subject = "A comment was added to the following ticket.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nA comment was added to the following ticket. \n";
body = body + "\n Subject: " + lblTitleSubjectName.Text;
body = body + "\n Created By: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Category: " + tbxCategoryName.Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
string commentAddedBy = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n Comment added by: " + commentAddedBy;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
case "CloseTicket":
// Get mail information
subject = "A support ticket was completed.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following support ticket 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 Category: " + tbxCategoryName.Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
string completedBy = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n Completed by: " + completedBy;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
case "OnHold":
// Get mail information
subject = "The following ticket was put on hold.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following ticket was put on hold. \n";
body = body + "\n Subject: " + lblTitleSubjectName.Text;
body = body + "\n Created By: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Category: " + tbxCategoryName.Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
string onHoldBy = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n On hold by: " + onHoldBy;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
}
}
}
DB.CommitTransaction();
// Store datasets
supportTicketInformationTDS.AcceptChanges();
Session["supportTicketInformationTDS"] = supportTicketInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
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;
}
}
private void LoadData(int supportTicketId)
{
SupportTicketInformationBasicInformationGateway supportTicketInformationBasicInformationGateway = new SupportTicketInformationBasicInformationGateway(supportTicketInformationTDS);
if (supportTicketInformationBasicInformationGateway.Table.Rows.Count > 0)
{
// Load to do Details
int companyId = Int32.Parse(hdfCompanyId.Value);
int createdById = supportTicketInformationBasicInformationGateway.GetCreatedByID(supportTicketId);
hdfCreatedById.Value = createdById.ToString();
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(createdById);
tbxCreatedBy.Text = employeeGateway.GetFullName(createdById);
tbxCreationDate.Text = supportTicketInformationBasicInformationGateway.GetCreationDate(supportTicketId).ToString();
tbxState.Text = supportTicketInformationBasicInformationGateway.GetState(supportTicketId);
tbxCategoryName.Text = supportTicketInformationBasicInformationGateway.GetCategoryName(supportTicketId);
if (supportTicketInformationBasicInformationGateway.GetDueDate(supportTicketId).HasValue)
{
DateTime dueDateValue = (DateTime)supportTicketInformationBasicInformationGateway.GetDueDate(supportTicketId);
tbxDueDate.Text = dueDateValue.Month.ToString() + "/" + dueDateValue.Day.ToString() + "/" + dueDateValue.Year.ToString();
}
}
}
protected void ddlActionsNew_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = grdSupportTicket.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 "Assign To Owner":
((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";
int currentSupportTicketId = Int32.Parse(hdfSupportTicketId.Value.ToString());
SupportTicketInformationBasicInformationGateway supportTicketInformationBasicInformationGatewayForState = new SupportTicketInformationBasicInformationGateway(supportTicketInformationTDS);
int ownerId = supportTicketInformationBasicInformationGatewayForState.GetCreatedByID(currentSupportTicketId);
((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).SelectedValue = ownerId.ToString();
((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).Enabled = false;
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 = "Support Ticket 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) && ((string)Request.QueryString["projecttime_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_edit.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_EDIT"])))
{
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_EDIT"])))
{
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_EDIT"])))
{
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 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();
hdfCompanyId.Value = Session["companyID"].ToString();
// Get ProjectTime record
ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS);
projectTimeGateway.LoadByProjectTimeId((int)ViewState["projecttime_id"]);
// Project time state check
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (projectTimeGateway.GetProjectTimeState((int)ViewState["projecttime_id"]) == "Approved")
{
Response.Redirect("./../../error_page.aspx?error=" + "You cannot edit an approved project time.");
}
}
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]))
{
bool isValidLimitPayPeriodToManagementEdit = LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime.ValidateLimitedPayPeriodToManagementEdit(projectTimeGateway.GetDate_((int)ViewState["projecttime_id"]), projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"]));
if (!isValidLimitPayPeriodToManagementEdit)
{
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_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]))
{
bool isValidLimitPayPeriodToManagementEdit = LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime.ValidateLimitedPayPeriodToWednesdayManagementEdit(projectTimeGateway.GetDate_((int)ViewState["projecttime_id"]), projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"]));
if (!isValidLimitPayPeriodToManagementEdit)
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
// Store datasets
Session["projectTimeTDS"] = projectTimeTDS;
// Databind
tkrdpDate_.DataBind();
ddlLunch.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.Parse(Request.QueryString["employee_id"]));
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesList companiesList = new CompaniesList();
companiesList.LoadAndAddItem(-1, "(Select a client)", companyId);
ddlClient.DataSource = companiesList.Table;
ddlClient.DataValueField = "COMPANIES_ID";
ddlClient.DataTextField = "Name";
ddlClient.DataBind();
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadAllByCompaniesId(Int32.Parse(DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].CompaniesID").ToString()), companyId);
// ... If Company is active
bool deleted = companiesGateway.GetDeleted(Int32.Parse(DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].CompaniesID").ToString()));
if (deleted)
{
ddlClient.SelectedIndex = -1;
}
else
{
ddlClient.SelectedValue = DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].CompaniesID").ToString();
}
ProjectList projectList = new ProjectList();
projectList.LoadProjectsInternalProjectsBallparkProjectsAndAddItem(-1, "(Select a project)", int.Parse(ddlClient.SelectedValue));
ddlProject.DataSource = projectList.Table;
ddlProject.DataValueField = "ProjectID";
ddlProject.DataTextField = "Name";
ddlProject.DataBind();
if (!deleted)
{
try
{
ddlProject.SelectedValue = DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].ProjectID").ToString();
}
catch
{
ddlProject.SelectedIndex = -1;
}
}
else
{
ddlProject.SelectedIndex = -1;
}
if (ddlProject.SelectedIndex != 0)
{
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(Int32.Parse(ddlProject.SelectedValue));
if (projectGateway.GetCountryID(Int32.Parse(ddlProject.SelectedValue)) == 1) //Canada
{
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
ddlJobClassType.Visible = true;
lblJobClassType.Visible = true;
ProjectTimeJobClassTypeList projectTimeJobClassTypeList = new ProjectTimeJobClassTypeList();
projectTimeJobClassTypeList.LoadAndAddItem(1, companyId, "(Select a Job Class Type)");
ddlJobClassType.DataSource = projectTimeJobClassTypeList.Table;
ddlJobClassType.DataValueField = "JobClassType";
ddlJobClassType.DataTextField = "JobClassType";
ddlJobClassType.DataBind();
if (projectTimeGateway.GetJobClassType((int)ViewState["projecttime_id"]).ToString() == "")
{
ddlJobClassType.SelectedIndex = 0;
}
else
{
ddlJobClassType.SelectedValue = (string)DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].JobClassType");
}
}
else
{
ddlJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
}
else
{
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
ddlJobClassType.Visible = true;
lblJobClassType.Visible = true;
ProjectTimeJobClassTypeList projectTimeJobClassTypeList = new ProjectTimeJobClassTypeList();
projectTimeJobClassTypeList.LoadAndAddItem(2, companyId, "(Select a Job Class Type)");
ddlJobClassType.DataSource = projectTimeJobClassTypeList.Table;
ddlJobClassType.DataValueField = "JobClassType";
ddlJobClassType.DataTextField = "JobClassType";
ddlJobClassType.DataBind();
if (projectTimeGateway.GetJobClassType((int)ViewState["projecttime_id"]).ToString() == "")
{
ddlJobClassType.SelectedIndex = 0;
}
else
{
ddlJobClassType.SelectedValue = (string)DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].JobClassType");
}
}
else
{
ddlJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
}
}
else
{
ddlJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
WorkingDetailsGateway workingDetailsGateway = new WorkingDetailsGateway(new DataSet());
workingDetailsGateway.Load();
ddlWorkingDetails.DataSource = workingDetailsGateway.Table;
ddlWorkingDetails.DataValueField = "WorkingDetails";
ddlWorkingDetails.DataTextField = "WorkingDetails";
ddlWorkingDetails.DataBind();
if (!deleted)
{
ddlWorkingDetails.SelectedValue = projectTimeGateway.GetWorkingDetails((int)ViewState["projecttime_id"]);
}
else
{
ddlWorkingDetails.SelectedIndex = -1;
}
ProjectTimeWorkList projectTimeWorkList = new ProjectTimeWorkList(new DataSet());
int projectId = 0;
try
{
projectId = Int32.Parse(ddlProject.SelectedValue);
}
catch
{
}
if (projectId == 35 || projectId == 39 || projectId == 716)
{
projectTimeWorkList.LoadAndAddItem("");
}
else
{
projectTimeWorkList.LoadAndAddItem("(Select a Type)");
}
// Setting start time, end time
string startTime = DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].StartTime", "{0:H:mm}").ToString();
if (!String.IsNullOrEmpty(startTime))
{
string[] hoursMin1 = startTime.Split(':');
ddlStartTimeHour.SelectedValue = hoursMin1[0].Trim();
ddlStartTimeMinute.SelectedValue = hoursMin1[1].Trim();
}
else
{
ddlStartTimeHour.SelectedIndex = 0;
ddlStartTimeMinute.SelectedIndex = 0;
}
string endTime = DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].EndTime", "{0:H:mm}").ToString();
if (!String.IsNullOrEmpty(endTime))
{
string[] endHoursMin1 = endTime.Split(':');
ddlEndTimeHour.SelectedValue = endHoursMin1[0].Trim();
ddlEndTimeMinute.SelectedValue = endHoursMin1[1].Trim();
}
else
{
ddlEndTimeHour.SelectedIndex = 0;
ddlEndTimeMinute.SelectedIndex = 0;
}
// Setting type of Work
ddlTypeOfWork.DataSource = projectTimeWorkList.Table;
ddlTypeOfWork.DataValueField = "Work_";
ddlTypeOfWork.DataTextField = "Work_";
ddlTypeOfWork.DataBind();
if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]) == "") ddlTypeOfWork.SelectedIndex = -1; else ddlTypeOfWork.SelectedValue = projectTimeGateway.GetWork((int)ViewState["projecttime_id"]);
ProjectTimeWorkFunctionList projectTimeWorkFunctionList = new ProjectTimeWorkFunctionList(new DataSet());
if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]) == "")
{
// ... If there is no type of Work, no function should be loaded
projectTimeWorkFunctionList.LoadAndAddItem("", "-1");
}
else
{
projectTimeWorkFunctionList.LoadAndAddItem("(Select a Function)", projectTimeGateway.GetWork((int)ViewState["projecttime_id"]).ToString());
}
ddlFunction.DataSource = projectTimeWorkFunctionList.Table;
ddlFunction.DataValueField = "Function_";
ddlFunction.DataTextField = "Function_";
ddlFunction.DataBind();
if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]).ToString() == "")
{
ddlFunction.SelectedValue = "";
}
else
{
ddlFunction.SelectedValue = (string)DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].Function_");
}
CountryList countryList = new CountryList(new DataSet());
countryList.LoadAndAddItem(-1, " ");
ddlMealsCountry.DataSource = countryList.Table;
ddlMealsCountry.DataValueField = "CountryID";
ddlMealsCountry.DataTextField = "Name";
ddlMealsCountry.DataBind();
if (!deleted)
{
if (projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]).HasValue)
{
ddlMealsCountry.SelectedValue = projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]).ToString();
}
else
{
ddlMealsCountry.SelectedValue = "-1";
}
}
else
{
ddlMealsCountry.SelectedIndex = -1;
}
//if (projectTimeGateway.GetMealsAllowance((int)ViewState["projecttime_id"]) > 0)
//{
// cbxMealsAllowance.Checked = true;
//}
string unitType = "Vehicle";
UnitsList unitsList = new UnitsList(new DataSet());
unitsList.LoadAndAddItem("-1", " ", Int32.Parse(Session["companyID"].ToString()), true, 0, unitType);
ddlUnit.DataSource = unitsList.Table;
ddlUnit.DataValueField = "UnitID";
ddlUnit.DataTextField = "UnitCode";
ddlUnit.DataBind();
if (projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]).HasValue)
{
ddlUnit.SelectedValue = ((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"])).ToString();
}
UnitsList towed = new UnitsList(new DataSet());
towed.LoadAndAddItem("-1", " ", Int32.Parse(Session["companyID"].ToString()), true, 1, unitType);
ddlTowed.DataSource = towed.Table;
ddlTowed.DataValueField = "UnitID";
ddlTowed.DataTextField = "UnitCode";
ddlTowed.DataBind();
if (projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]).HasValue)
{
ddlTowed.SelectedValue = ((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"])).ToString();
}
}
else
{
// Restore datasets
projectTimeTDS = (ProjectTimeTDS)Session["projectTimeTDS"];
}
}
private void LoadGeneralData()
{
// Data for General Data
tbxProjectNumber.DataBind();
tbxName.DataBind();
tbxProposalDate.DataBind();
tbxStartDate.DataBind();
tbxEndDate.DataBind();
tbxDescription.DataBind();
cbxFairWageApplies.DataBind();
// ... for geographical location
hdfCountryId.DataBind();
if (hdfCountryId.Value != "")
{
CountryGateway countryGateway = new CountryGateway();
countryGateway.LoadByCountryId(Int64.Parse(hdfCountryId.Value));
tbxCountry.Text = countryGateway.GetName(Int64.Parse(hdfCountryId.Value));
}
else
{
tbxCountry.Text = "";
}
hdfProvinceStateId.DataBind();
if (hdfProvinceStateId.Value != "")
{
ProvinceGateway provinceGateway = new ProvinceGateway();
provinceGateway.LoadByProvinceId(Int64.Parse(hdfProvinceStateId.Value));
tbxProvinceState.Text = provinceGateway.GetName(Int64.Parse(hdfProvinceStateId.Value));
}
else
{
tbxProvinceState.Text = "";
}
hdfCountyId.DataBind();
if (hdfCountyId.Value != "")
{
CountyGateway countyGateway = new CountyGateway();
countyGateway.LoadByCountyId(Int64.Parse(hdfCountyId.Value));
tbxCounty.Text = countyGateway.GetName(Int64.Parse(hdfCountyId.Value));
}
else
{
tbxCounty.Text = "";
}
hdfCityId.DataBind();
if (hdfCityId.Value != "")
{
CityGateway cityGateway = new CityGateway();
cityGateway.LoadByCityId(Int64.Parse(hdfCityId.Value));
tbxCity.Text = cityGateway.GetName(Int64.Parse(hdfCityId.Value));
}
else
{
tbxCity.Text = "";
}
// ... for project
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
int currentCompanyId = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value.ToString()));
// ... for client
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadAllByCompaniesId(currentCompanyId, companyId);
tbxClientName.Text = companiesGateway.GetName(currentCompanyId);
hdfClientId.Value = projectGateway.GetClientID(int.Parse(hdfProjectId.Value)).ToString();
tbxClientProjectNumber.DataBind();
// ... ... for primary contact
if (projectGateway.GetClientPrimaryContactID(int.Parse(hdfProjectId.Value)).HasValue)
{
hdfClientPrimaryContactID.Value = ((int)projectGateway.GetClientPrimaryContactID(int.Parse(hdfProjectId.Value))).ToString();
ContactsGateway contactsGatewayForPrimaryContact = new ContactsGateway();
contactsGatewayForPrimaryContact.LoadAllByContactId(int.Parse(hdfClientPrimaryContactID.Value), companyId);
tbxClientPrimaryContact.Text = contactsGatewayForPrimaryContact.GetCompleteName(int.Parse(hdfClientPrimaryContactID.Value));
}
// ... ... for secondary contact
if (projectGateway.GetClientSecondaryContactID(int.Parse(hdfProjectId.Value)).HasValue)
{
hdfClientSecondaryContactID.Value = ((int)projectGateway.GetClientSecondaryContactID(int.Parse(hdfProjectId.Value))).ToString();
ContactsGateway contactsGatewayForSecondaryContact = new ContactsGateway();
contactsGatewayForSecondaryContact.LoadAllByContactId(int.Parse(hdfClientSecondaryContactID.Value), companyId);
tbxClientSecondaryContact.Text = contactsGatewayForSecondaryContact.GetCompleteName(int.Parse(hdfClientSecondaryContactID.Value));
}
// ... for resources
// ... ... for project lead
if (projectGateway.GetProjectLeadID(int.Parse(hdfProjectId.Value)).HasValue)
{
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId((int)projectGateway.GetProjectLeadID(int.Parse(hdfProjectId.Value)));
tbxProjectLead.Text = employeeGateway.GetFullName((int)projectGateway.GetProjectLeadID(int.Parse(hdfProjectId.Value)));
}
// ... ... for salesman
SalesmanGateway salesmanGateway = new SalesmanGateway();
salesmanGateway.LoadExpandedBySalesmanId(projectGateway.GetSalesmanID(int.Parse(hdfProjectId.Value)));
tbxSalesman.Text = salesmanGateway.GetFullName(projectGateway.GetSalesmanID(int.Parse(hdfProjectId.Value)));
// ... ... for Pricing
if (projectGateway.GetProjectType(int.Parse(hdfProjectId.Value)) == "Ballpark")
{
ProjectSaleBillingPricingGateway projectSaleBillingPricingGateway = new ProjectSaleBillingPricingGateway(projectTDS);
if (projectSaleBillingPricingGateway.Table.Rows.Count > 0)
{
if (projectSaleBillingPricingGateway.GetBillPrice(int.Parse(hdfProjectId.Value)).HasValue) tbxBillPrice.Text = ((decimal)projectSaleBillingPricingGateway.GetBillPrice(int.Parse(hdfProjectId.Value))).ToString("n2");
tbxBillMoney.Text = projectSaleBillingPricingGateway.GetBillMoney(int.Parse(hdfProjectId.Value));
}
else
{
if (projectGateway.GetCountryID(int.Parse(hdfProjectId.Value)) == 1)
{
tbxBillMoney.Text = "CAD";
}
else
{
tbxBillMoney.Text = "USD";
}
}
}
// Data for unit budget tab
ProjectNavigatorProjectUnitsBudgetGateway projectNavigatorProjectUnitsBudgetGateway = new ProjectNavigatorProjectUnitsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectUnitsBudgetGateway.Table.Rows.Count > 0)
{
tbxUnitsBudget.Text = projectNavigatorProjectUnitsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value)).ToString("n2");
}
// Data for materials budget tab
ProjectNavigatorProjectMaterialsBudgetGateway projectNavigatorProjectMaterialsBudgetGateway = new ProjectNavigatorProjectMaterialsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectMaterialsBudgetGateway.Table.Rows.Count > 0)
{
tbxMaterialsBudget.Text = projectNavigatorProjectMaterialsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value)).ToString("n2");
}
// Data for subcontractors budget tab
ProjectNavigatorProjectSubcontractorsBudgetGateway projectNavigatorProjectSubcontractorsBudgetGateway = new ProjectNavigatorProjectSubcontractorsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectSubcontractorsBudgetGateway.Table.Rows.Count > 0)
{
tbxSubcontractorsBudget.Text = projectNavigatorProjectSubcontractorsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2");
}
// Data for hotels budget tab
ProjectNavigatorProjectHotelsBudgetGateway projectNavigatorProjectHotelsBudgetGateway = new ProjectNavigatorProjectHotelsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectHotelsBudgetGateway.Table.Rows.Count > 0)
{
tbxHotelsBudget.Text = projectNavigatorProjectHotelsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2");
}
// Data for bondings budget tab
ProjectNavigatorProjectBondingsBudgetGateway projectNavigatorProjectBondingsBudgetGateway = new ProjectNavigatorProjectBondingsBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectBondingsBudgetGateway.Table.Rows.Count > 0)
{
tbxBondingsBudget.Text = projectNavigatorProjectBondingsBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2");
}
// Data for insurances budget tab
ProjectNavigatorProjectInsurancesBudgetGateway projectNavigatorProjectInsurancesBudgetGateway = new ProjectNavigatorProjectInsurancesBudgetGateway(projectNavigatorTDS);
if (projectNavigatorProjectInsurancesBudgetGateway.Table.Rows.Count > 0)
{
tbxInsurancesBudget.Text = projectNavigatorProjectInsurancesBudgetGateway.GetBudget(int.Parse(hdfProjectId.Value), 1, 1).ToString("n2");
}
CalculateTotalBudget();
}
// ////////////////////////////////////////////////////////////////////////
// FINAL EVENTS
//
protected void Page_PreRender(object sender, EventArgs e)
{
// Set wizard title
int employeeId = Int32.Parse(hdfEmployeeId.Value);
//... Employee
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
Label title = (Label)this.Master.FindControl("lblTitle");
title.Text = "Add Or Remove Role For " + employeeGateway.GetFullName(employeeId);
}
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 bool StepBeginNext()
{
Page.Validate("Begin");
if (Page.IsValid)
{
// Tag values
hdfSubject.Value = tbxSubject.Text.Trim();
hdfComments.Value = tbxComment.Text.Trim();
hdfDueDate.Value = tkrdpDueDate.SelectedDate.ToString();
// Assign Dan Anzovino
int loginId = 115;
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
hdfTeamMemberId.Value = employeeGateway.GetEmployeIdByLoginId(loginId).ToString();
int employeeId = Int32.Parse(hdfTeamMemberId.Value);
hdfTeamMemberFullName.Value = employeeGateway.GetFullName(employeeId).ToString();
//hdfAssignToMyself.Value = rbtnAssignToMyself.Checked.ToString();
//if (rbtnAssignToMyself.Checked)
//{
// int loginId = Convert.ToInt32(Session["loginID"]);
// EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
// hdfTeamMemberId.Value = employeeGateway.GetEmployeIdByLoginId(loginId).ToString();
// int employeeId = Int32.Parse(hdfTeamMemberId.Value);
// hdfTeamMemberFullName.Value = employeeGateway.GetFullName(employeeId).ToString();
//}
//hdfAssignToTeamMember.Value = rbtnAssignToTeamMember.Checked.ToString();
//if (rbtnAssignToTeamMember.Checked)
//{
// hdfTeamMemberId.Value = ""; if (ddlAssignToTeamMember.SelectedValue != "") hdfTeamMemberId.Value = ddlAssignToTeamMember.SelectedValue;
// hdfTeamMemberFullName.Value = ""; if (ddlAssignToTeamMember.SelectedItem.Text != "") hdfTeamMemberFullName.Value = ddlAssignToTeamMember.SelectedItem.Text;
//}
foreach (int categoriesId in arrayCategoriesSelectedForAdd)
{
hdfCategoriesSelected.Value = categoriesId.ToString();
}
return true;
}
return false;
}
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);
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)
{
tkrdpDueDate.SelectedDate = (DateTime)toDoListInformationBasicInformationGateway.GetDueDate(toDoId);
}
int? unitId = toDoListInformationBasicInformationGateway.GetUnitID(toDoId);
if (unitId.HasValue)
{
ddlUnit.SelectedValue = unitId.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_FULL_EDITING"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) && !Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_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_OTHERS_TIMESHEETS_MANAGEMENT"]) && !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) && ((string)Request.QueryString["period_id"] == null) && ((string)Request.QueryString["projecttime_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet.aspx");
}
// Tag page
Session.Remove("timesheetNavigatorDummy");
// Initialize variables
lblError.Visible = false;
// ... Labour Hours Mode
System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader();
ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString();
// ... If coming from out
if ((string)Request.QueryString["source_page"] == "out")
{
Session.Remove("ddlOthersForSelectedValue");
// Store search parameters
ViewState["current"] = "yes";
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"]))
{
ViewState["others"] = "yes";
}
else
{
ViewState["others"] = "no";
}
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
ViewState["period_id"] = payPeriodGateway.GetPayPeriodId(DateTime.Now);
if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_AUTOREPORT"]))
{
string script = "<script language='javascript'>";
script += "window.open('./../projecttime/timesheet_missing.aspx?source_page=timesheet.aspx', '_blank', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=550, height=420')";
script += "</script>";
ScriptManager.RegisterStartupScript(this, this.GetType(), "Report", script, false);
}
}
// ... If coming from left menu
if ((string)Request.QueryString["source_page"] == "lm")
{
// Store search parameters
ViewState["current"] = "yes";
ViewState["others"] = Request.QueryString["others"];
if (Request.QueryString["others"] == "yes")
{
ViewState["employee_id"] = int.Parse((string)Request.QueryString["employee_id"]);
}
else
{
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
}
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
ViewState["period_id"] = payPeriodGateway.GetPayPeriodId(DateTime.Now);
}
// ... If coming from timesheet_all.aspx
if ((string)Request.QueryString["source_page"] == "timesheet_all.aspx")
{
// Store search parameters
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
int currentPeriod = payPeriodGateway.GetCurrent();
if (currentPeriod == int.Parse((string)Request.QueryString["period_id"]))
{
ViewState["current"] = "yes";
}
else
{
ViewState["current"] = "no";
}
ViewState["others"] = Request.QueryString["others"];
ViewState["employee_id"] = int.Parse((string)Request.QueryString["employee_id"]);
ViewState["period_id"] = int.Parse((string)Request.QueryString["period_id"]);
}
// ... If coming from timesheet.aspx
if ((string)Request.QueryString["source_page"] == "timesheet.aspx")
{
// Store search parameters
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
int currentPeriod = payPeriodGateway.GetCurrent();
if (currentPeriod == int.Parse((string)Request.QueryString["period_id"]))
{
ViewState["current"] = "yes";
}
else
{
ViewState["current"] = "no";
}
ViewState["others"] = Request.QueryString["others"];
ViewState["employee_id"] = int.Parse((string)Request.QueryString["employee_id"]);
ViewState["period_id"] = int.Parse((string)Request.QueryString["period_id"]);
if (Session["OpenTimesheetMissing"] == null)
{
if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_AUTOREPORT"]))
{
string script = "<script language='javascript'>";
script += "window.open('./../projecttime/timesheet_missing.aspx?source_page=timesheet.aspx', '_blank', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=550, height=420')";
script += "</script>";
ScriptManager.RegisterStartupScript(this, this.GetType(), "Report", script, false);
}
}
}
// ... If coming from timesheet_summary.aspx, timesheet_add.aspx, timesheet_edit.aspx, timesheet_delete.aspx or timesheet_state.aspx
if (((string)Request.QueryString["source_page"] == "timesheet_summary.aspx") || ((string)Request.QueryString["source_page"] == "timesheet_add.aspx") || ((string)Request.QueryString["source_page"] == "timesheet_edit.aspx") || ((string)Request.QueryString["source_page"] == "timesheet_delete.aspx") || ((string)Request.QueryString["source_page"] == "timesheet_state.aspx"))
{
// Store search parameters
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
int currentPeriod = payPeriodGateway.GetCurrent();
if (currentPeriod == int.Parse((string)Request.QueryString["period_id"]))
{
ViewState["current"] = "yes";
}
else
{
ViewState["current"] = "no";
}
ViewState["others"] = Request.QueryString["others"];
ViewState["employee_id"] = int.Parse((string)Request.QueryString["employee_id"]);
ViewState["period_id"] = int.Parse((string)Request.QueryString["period_id"]);
}
// ... If coming from timesheet_approve.aspx
if ((string)Request.QueryString["source_page"] == "timesheet_approve.aspx")
{
// Store search parameters
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
int currentPeriod = payPeriodGateway.GetCurrent();
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
ViewState["current"] = "yes";
ViewState["others"] = "yes";
ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
ViewState["period_id"] = currentPeriod;
}
// Access control
// ... Employees
EmployeeListGateway employeeListGateway = new EmployeeListGateway(new DataSet());
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
employeeListGateway.LoadByRequestProjectTimeWithoutEmployeeId(1, (int)ViewState["employee_id"]);
}
else
{
employeeListGateway.LoadByRequestProjectTime(1);
}
DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor");
ddlOthersFor.DataSource = employeeListGateway.Table;
ddlOthersFor.DataValueField = "EmployeeID";
ddlOthersFor.DataTextField = "FullName";
ddlOthersFor.DataBind();
// ... Title
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
if ((int)ViewState["employee_id"] != 0)
{
employeeGateway.LoadByEmployeeId((int)ViewState["employee_id"]);
if ((string)ViewState["others"] == "no")
{
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"])) && (employeeGateway.GetRequestProjectTime((int)ViewState["employee_id"])))
{
if ((string)ViewState["current"] == "yes")
{
lblTitle.Text = "Current Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]);
}
else
{
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
payPeriodGateway.LoadByPayPeriodId((int)ViewState["period_id"]);
lblTitle.Text = "Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]) + " From " + payPeriodGateway.GetStartDate((int)ViewState["period_id"]).ToShortDateString() + " To " + payPeriodGateway.GetEndDate((int)ViewState["period_id"]).ToShortDateString();
}
}
else
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
else
{
EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet());
int employeeIdNow = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
if ((int)ViewState["employee_id"] == employeeIdNow)
{
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"])) && (employeeGateway.GetRequestProjectTime((int)ViewState["employee_id"]))))
{
if ((string)ViewState["current"] == "yes")
{
lblTitle.Text = "Current Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]);
}
else
{
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
payPeriodGateway.LoadByPayPeriodId((int)ViewState["period_id"]);
lblTitle.Text = "Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]) + " From " + payPeriodGateway.GetStartDate((int)ViewState["period_id"]).ToShortDateString() + " To " + payPeriodGateway.GetEndDate((int)ViewState["period_id"]).ToShortDateString();
}
}
else
{
if (ddlOthersFor.Items.Count > 0)
{
Session["ddlOthersForSelectedValue"] = ddlOthersFor.SelectedValue;
Response.Redirect("./timesheet.aspx?source_page=timesheet.aspx&others=yes&employee_id=" + ddlOthersFor.SelectedValue + "&period_id=" + ((int)ViewState["period_id"]).ToString());
}
else
{
Response.Redirect("./../../error_page.aspx?error=" + "No team members with 'Request Timesheet' property are defined in the system. Contact your system administrator for further assistance.");
}
}
}
else
{
if ((string)ViewState["current"] == "yes")
{
lblTitle.Text = "Current Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]);
}
else
{
PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet());
payPeriodGateway.LoadByPayPeriodId((int)ViewState["period_id"]);
lblTitle.Text = "Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]) + " From " + payPeriodGateway.GetStartDate((int)ViewState["period_id"]).ToShortDateString() + " To " + payPeriodGateway.GetEndDate((int)ViewState["period_id"]).ToShortDateString();
}
}
}
}
else
{
Response.Redirect("./../../error_page.aspx?error=" + "You cannot use the Labour Hours subsystem since you are not registered as a team member in LFS Live. Please contact your system administrator for further assistance."); ;
}
// Load data
timesheetNavigatorTDS = this.SubmitSearch();
Session["timesheetNavigatorTDS"] = timesheetNavigatorTDS;
timesheetNavigator = timesheetNavigatorTDS.LFS_PROJECT_TIME;
Session["timesheetNavigator"] = timesheetNavigator;
// Set Total project time
TimesheetNavigator timesheetNavigatorForTotal = new TimesheetNavigator(timesheetNavigatorTDS);
tbxTotalCost.Text = timesheetNavigatorForTotal.GetTotalProjectTime().ToString();
}
else
{
// Restore dataset
timesheetNavigatorTDS = (TimesheetNavigatorTDS)Session["timesheetNavigatorTDS"];
timesheetNavigator = timesheetNavigatorTDS.LFS_PROJECT_TIME;
// Store datase
Session["timesheetNavigator"] = timesheetNavigator;
}
}
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);
}
}
}
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());
}
}
}
// ////////////////////////////////////////////////////////////////////////
// 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;
}
}
private bool StepBeginNext()
{
Page.Validate("Begin");
if (Page.IsValid)
{
// Tag values
hdfSubject.Value = tbxSubject.Text.Trim();
hdfComments.Value = tbxComment.Text.Trim();
hdfDueDate.Value = tkrdpDueDate.SelectedDate.ToString();
hdfUnitId.Value = ddlUnit.SelectedValue;
hdfUnitCode.Value = ddlUnit.SelectedItem.Text;
hdfAssignToMyself.Value = rbtnAssignToMyself.Checked.ToString();
if (rbtnAssignToMyself.Checked)
{
int loginId = Convert.ToInt32(Session["loginID"]);
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
hdfTeamMemberId.Value = employeeGateway.GetEmployeIdByLoginId(loginId).ToString();
int employeeId = Int32.Parse(hdfTeamMemberId.Value);
hdfTeamMemberFullName.Value = employeeGateway.GetFullName(employeeId).ToString();
}
hdfAssignToTeamMember.Value = rbtnAssignToTeamMember.Checked.ToString();
if (rbtnAssignToTeamMember.Checked)
{
hdfTeamMemberId.Value = ""; if (ddlAssignToTeamMember.SelectedValue != "") hdfTeamMemberId.Value = ddlAssignToTeamMember.SelectedValue;
hdfTeamMemberFullName.Value = ""; if (ddlAssignToTeamMember.SelectedItem.Text != "") hdfTeamMemberFullName.Value = ddlAssignToTeamMember.SelectedItem.Text;
}
return true;
}
return false;
}
