/// <summary>
/// Generate Project Number for new Project
/// </summary>
/// <param name="countryId">CountryId</param>
/// <param name="officeId">OfficeId</param>
/// <param name="salesmanId">SalesmanId - EmployeeId</param>
/// <param name="date">Date to generate</param>
/// <param name="companyId">companyId</param>
/// <returns>Project Number generated</returns>
public string GenerateProjectNumber(Int64 countryId, int officeId, int salesmanId, DateTime date, int companyId)
{
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(countryId);
string pnCountryId = countryGateway.GetIdForProjects(countryId);
OfficeGateway officeGateway = new OfficeGateway(new DataSet());
officeGateway.LoadByOfficeId(officeId);
string pnOfficeId = officeGateway.GetIdForProjects(officeId);
SalesmanGateway salesmanGateway = new SalesmanGateway(new DataSet());
salesmanGateway.LoadBySalesmanId(salesmanId);
string pnSalesmanId = salesmanGateway.GetIdForProjects(salesmanId);
ProjectNumberGateway projectNumberGateway = new ProjectNumberGateway(Data);
projectNumberGateway.Load();
ProjectNumber projectNumber = new ProjectNumber(Data);
string pnYearCode = projectNumber.GetYearCode(date.Year);
string pnProjectIncrement = projectNumber.GetProjectIncrement(date.Year, companyId);
string newProjectNumber = pnCountryId + pnOfficeId + pnSalesmanId + pnYearCode + pnProjectIncrement;
return newProjectNumber;
}
private void LoadDetailedData(int unitId)
{
UnitInformationUnitDetailsGateway unitInformationUnitDetailsGateway = new UnitInformationUnitDetailsGateway(unitInformationTDS);
if (unitInformationUnitDetailsGateway.Table.Rows.Count > 0)
{
// Load for General Tab
if (unitInformationUnitDetailsGateway.GetAcquisitionDate(unitId).HasValue) tbxAcquisitionDate.Text = ((DateTime)unitInformationUnitDetailsGateway.GetAcquisitionDate(unitId)).ToShortDateString();
if (unitInformationUnitDetailsGateway.GetDispositionDate(unitId).HasValue) tbxDispositionDate.Text = ((DateTime)unitInformationUnitDetailsGateway.GetDispositionDate(unitId)).ToShortDateString();
tbxDispositionReason.Text = unitInformationUnitDetailsGateway.GetDispositionReason(unitId);
int companyLevelId = unitInformationUnitDetailsGateway.GetCompanyLevelId(unitId);
GetNodeForCategory(tvCategoriesRoot.Nodes, 0);
GetNodeForCompanyLevels(tvCompanyLevelsRoot.Nodes, 0, companyLevelId);
foreach (TreeNode nodes in tvCategoriesRoot.Nodes)
{
GetCategoriesParent(nodes);
}
foreach (TreeNode nodes in tvCompanyLevelsRoot.Nodes)
{
GetCompanyLevelsParent(nodes);
}
// Load for Plate and Technical Tabs
if (unitInformationUnitDetailsGateway.GetType(unitId) == "Vehicle")
{
if (unitInformationUnitDetailsGateway.GetLicenseCountry(unitId).HasValue)
{
Int64 countryId = (Int64)unitInformationUnitDetailsGateway.GetLicenseCountry(unitId);
CountryGateway countryGateway = new CountryGateway();
countryGateway.LoadByCountryId(countryId);
tbxLicenseCountry.Text = countryGateway.GetName(countryId);
}
if (unitInformationUnitDetailsGateway.GetLicenseState(unitId).HasValue)
{
Int64 stateId = (Int64)unitInformationUnitDetailsGateway.GetLicenseState(unitId);
ProvinceGateway provinceGateway = new ProvinceGateway();
provinceGateway.LoadByProvinceId(stateId);
tbxLicenseState.Text = provinceGateway.GetName(stateId);
}
tbxLicensePlateNumber.Text = unitInformationUnitDetailsGateway.GetLicensePlateNumbver(unitId);
tbxActualWeight.Text = unitInformationUnitDetailsGateway.GetActualWeight(unitId);
tbxRegisteredWeight.Text = unitInformationUnitDetailsGateway.GetRegisteredWeight(unitId);
tbxTireSizeFront.Text = unitInformationUnitDetailsGateway.GetTireSizeFront(unitId);
tbxTireSizeBack.Text = unitInformationUnitDetailsGateway.GetTireSizeBack(unitId);
tbxNumberOfAxes.Text = unitInformationUnitDetailsGateway.GetNumberOfAxes(unitId);
tbxFuelType.Text = unitInformationUnitDetailsGateway.GetFuelType(unitId);
tbxBeginningOdometer.Text = unitInformationUnitDetailsGateway.GetBeginningOdometer(unitId);
cbxIsReeferEquipped.Checked = unitInformationUnitDetailsGateway.GetIsReeferEquipped(unitId);
cbxIsPtoEquipped.Checked = unitInformationUnitDetailsGateway.GetIsPTOEquipped(unitId);
}
// Load for Ownership tab
tbxOwnerType.Text = unitInformationUnitDetailsGateway.GetOwnerType(unitId);
tbxOwnerName.Text = unitInformationUnitDetailsGateway.GetOwnerName(unitId);
tbxOwnerContact.Text = unitInformationUnitDetailsGateway.GetOwnerContact(unitId);
if (unitInformationUnitDetailsGateway.GetOwnerCountry(unitId).HasValue)
{
Int64 countryId = (Int64)unitInformationUnitDetailsGateway.GetOwnerCountry(unitId);
CountryGateway countryGateway = new CountryGateway();
countryGateway.LoadByCountryId(countryId);
tbxOwnerCountry.Text = countryGateway.GetName(countryId);
if (unitInformationUnitDetailsGateway.GetOwnerState(unitId).HasValue)
{
Int64 stateId = (Int64)unitInformationUnitDetailsGateway.GetOwnerState(unitId);
ProvinceGateway provinceGateway = new ProvinceGateway();
provinceGateway.LoadByProvinceId(stateId);
tbxOwnerState.Text = provinceGateway.GetName(stateId);
}
}
// Load for Inspection Tab (Qualification data)
if (unitInformationUnitDetailsGateway.GetQualifiedDate(unitId).HasValue) tbxQualifiedDate.Text = ((DateTime)unitInformationUnitDetailsGateway.GetQualifiedDate(unitId)).ToShortDateString();
if (unitInformationUnitDetailsGateway.GetNotQualifiedDate(unitId).HasValue) tbxNotQualifiedDate.Text = ((DateTime)unitInformationUnitDetailsGateway.GetNotQualifiedDate(unitId)).ToShortDateString();
tbxIfNotQualifiedExplain.Text = unitInformationUnitDetailsGateway.GetNotQualifiedExplain(unitId);
}
}
private void LoadDetailedData(int unitId)
{
UnitInformationUnitDetailsGateway unitInformationUnitDetailsGateway = new UnitInformationUnitDetailsGateway(unitInformationTDS);
if (unitInformationUnitDetailsGateway.Table.Rows.Count > 0)
{
// Load for General Tab
if (upnlGeneralDataEdit.Visible)
{
if (unitInformationUnitDetailsGateway.GetAcquisitionDate(unitId).HasValue)
{
tkrdpAcquisitionDate.SelectedDate = unitInformationUnitDetailsGateway.GetAcquisitionDate(unitId);
}
if (unitInformationUnitDetailsGateway.GetDispositionDate(unitId).HasValue)
{
tkrdpDispositionDate.SelectedDate = unitInformationUnitDetailsGateway.GetDispositionDate(unitId);
}
tbxDispositionReason.Text = unitInformationUnitDetailsGateway.GetDispositionReason(unitId);
int companyLevelId = unitInformationUnitDetailsGateway.GetCompanyLevelId(unitId);
GetNodeForCategory(tvCategoriesRoot.Nodes, 0);
GetNodeForCompanyLevels(tvCompanyLevelsRoot.Nodes, 0, companyLevelId);
foreach (TreeNode nodes in tvCategoriesRoot.Nodes)
{
GetCategoriesParent(nodes);
}
foreach (TreeNode nodes in tvCompanyLevelsRoot.Nodes)
{
GetCompanyLevelsParent(nodes);
}
}
else
{
if (unitInformationUnitDetailsGateway.GetAcquisitionDate(unitId).HasValue) tbxAcquisitionDateSummary.Text = ((DateTime)unitInformationUnitDetailsGateway.GetAcquisitionDate(unitId)).ToShortDateString();
if (unitInformationUnitDetailsGateway.GetDispositionDate(unitId).HasValue) tbxDispositionDateSummary.Text = ((DateTime)unitInformationUnitDetailsGateway.GetDispositionDate(unitId)).ToShortDateString();
tbxDispositionReasonSummary.Text = unitInformationUnitDetailsGateway.GetDispositionReason(unitId);
int companyLevelId = unitInformationUnitDetailsGateway.GetCompanyLevelId(unitId);
GetNodeForCategory(tvCategoriesRootSummary.Nodes, 0);
GetNodeForCompanyLevels(tvCompanyLevelsRootSummary.Nodes, 0, companyLevelId);
foreach (TreeNode nodes in tvCategoriesRootSummary.Nodes)
{
GetCategoriesParent(nodes);
}
foreach (TreeNode nodes in tvCompanyLevelsRootSummary.Nodes)
{
GetCompanyLevelsParent(nodes);
}
}
// Load for Plate and Technical Tabs
if (unitInformationUnitDetailsGateway.GetType(unitId) == "Vehicle")
{
if (upnlPlateDataEdit.Visible)
{
if (unitInformationUnitDetailsGateway.GetLicenseCountry(unitId).HasValue)
{
Int64 countryId = (Int64)unitInformationUnitDetailsGateway.GetLicenseCountry(unitId);
ddlLicenseCountry.SelectedValue = countryId.ToString();
if (unitInformationUnitDetailsGateway.GetLicenseState(unitId).HasValue)
{
Int64? stateId = null;
stateId = unitInformationUnitDetailsGateway.GetLicenseState(unitId);
if (stateId.HasValue)
{
tbxLicenseState.Text = "";
hdfLicenseStateId.Value = "";
if (stateId.ToString() == "12435")
{
tbxLicenseState.Text = "Ontario";
hdfLicenseStateId.Value = "12435";
}
else
{
if (ddlLicenseCountry.SelectedValue == "2")
{
tbxLicenseState.Text = "Michigan";
hdfLicenseStateId.Value = "84026";
}
}
}
}
}
tbxLicensePlateNumber.Text = unitInformationUnitDetailsGateway.GetLicensePlateNumbver(unitId);
}
else
{
if (unitInformationUnitDetailsGateway.GetLicenseCountry(unitId).HasValue)
{
Int64 countryId = (Int64)unitInformationUnitDetailsGateway.GetLicenseCountry(unitId);
CountryGateway countryGateway = new CountryGateway();
countryGateway.LoadByCountryId(countryId);
tbxLicenseCountrySummary.Text = countryGateway.GetName(countryId);
}
if (unitInformationUnitDetailsGateway.GetLicenseState(unitId).HasValue)
{
Int64 stateId = (Int64)unitInformationUnitDetailsGateway.GetLicenseState(unitId);
ProvinceGateway provinceGateway = new ProvinceGateway();
provinceGateway.LoadByProvinceId(stateId);
tbxLicenseStateSummary.Text = provinceGateway.GetName(stateId);
}
tbxLicensePlateNumberSummary.Text = unitInformationUnitDetailsGateway.GetLicensePlateNumbver(unitId);
}
if (upnlTechnicalEdit.Visible)
{
tbxActualWeight.Text = unitInformationUnitDetailsGateway.GetActualWeight(unitId);
tbxRegisteredWeight.Text = unitInformationUnitDetailsGateway.GetRegisteredWeight(unitId);
tbxTireSizeFront.Text = unitInformationUnitDetailsGateway.GetTireSizeFront(unitId);
tbxTireSizeBack.Text = unitInformationUnitDetailsGateway.GetTireSizeBack(unitId);
ddlNumberOfAxes.SelectedValue = unitInformationUnitDetailsGateway.GetNumberOfAxes(unitId);
ddlFuelType.SelectedValue = unitInformationUnitDetailsGateway.GetFuelType(unitId);
tbxBeginningOdometer.Text = unitInformationUnitDetailsGateway.GetBeginningOdometer(unitId);
cbxIsReeferEquipped.Checked = unitInformationUnitDetailsGateway.GetIsReeferEquipped(unitId);
cbxIsPtoEquipped.Checked = unitInformationUnitDetailsGateway.GetIsPTOEquipped(unitId);
}
else
{
tbxActualWeightSummary.Text = unitInformationUnitDetailsGateway.GetActualWeight(unitId);
tbxRegisteredWeightSummary.Text = unitInformationUnitDetailsGateway.GetRegisteredWeight(unitId);
tbxTireSizeFrontSummary.Text = unitInformationUnitDetailsGateway.GetTireSizeFront(unitId);
tbxTireSizeBackSummary.Text = unitInformationUnitDetailsGateway.GetTireSizeBack(unitId);
tbxNumberOfAxesSummary.Text = unitInformationUnitDetailsGateway.GetNumberOfAxes(unitId);
tbxFuelTypeSummary.Text = unitInformationUnitDetailsGateway.GetFuelType(unitId);
tbxBeginningOdometerSummary.Text = unitInformationUnitDetailsGateway.GetBeginningOdometer(unitId);
cbxIsReeferEquippedSummary.Checked = unitInformationUnitDetailsGateway.GetIsReeferEquipped(unitId);
cbxIsPtoEquippedSummary.Checked = unitInformationUnitDetailsGateway.GetIsPTOEquipped(unitId);
}
}
// Load for Ownership tab
if (upnlOwnershipEdit.Visible)
{
ddlOwnerType.SelectedValue = unitInformationUnitDetailsGateway.GetOwnerType(unitId);
tbxOwnerName.Text = unitInformationUnitDetailsGateway.GetOwnerName(unitId);
tbxOwnerContact.Text = unitInformationUnitDetailsGateway.GetOwnerContact(unitId);
if (unitInformationUnitDetailsGateway.GetOwnerCountry(unitId).HasValue)
{
Int64 countryId = (Int64)unitInformationUnitDetailsGateway.GetOwnerCountry(unitId);
ddlOwnerCountry.SelectedValue = countryId.ToString();
ProvinceList provinceList = new ProvinceList();
provinceList.LoadByCountryIdAndAddItem(-1, "(Select a state)", countryId);
ddlOwnerState.DataSource = provinceList.Table;
ddlOwnerState.DataValueField = "ProvinceID";
ddlOwnerState.DataTextField = "Name";
ddlOwnerState.DataBind();
if (unitInformationUnitDetailsGateway.GetOwnerState(unitId).HasValue)
{
Int64 stateId = (Int64)unitInformationUnitDetailsGateway.GetOwnerState(unitId);
ddlOwnerState.SelectedValue = stateId.ToString();
}
}
}
else
{
tbxOwnerTypeSummary.Text = unitInformationUnitDetailsGateway.GetOwnerType(unitId);
tbxOwnerNameSummary.Text = unitInformationUnitDetailsGateway.GetOwnerName(unitId);
tbxContactInfoSummary.Text = unitInformationUnitDetailsGateway.GetOwnerContact(unitId);
if (unitInformationUnitDetailsGateway.GetOwnerCountry(unitId).HasValue)
{
Int64 countryId = (Int64)unitInformationUnitDetailsGateway.GetOwnerCountry(unitId);
CountryGateway countryGateway = new CountryGateway();
countryGateway.LoadByCountryId(countryId);
tbxOwnerCountrySummary.Text = countryGateway.GetName(countryId);
if (unitInformationUnitDetailsGateway.GetOwnerState(unitId).HasValue)
{
Int64 stateId = (Int64)unitInformationUnitDetailsGateway.GetOwnerState(unitId);
ProvinceGateway provinceGateway = new ProvinceGateway();
provinceGateway.LoadByProvinceId(stateId);
tbxOwnerStateSummary.Text = provinceGateway.GetName(stateId);
}
}
}
// Load for Inspection Tab (Qualification data)
if (upnlInspectionEdit.Visible)
{
if (unitInformationUnitDetailsGateway.GetQualifiedDate(unitId).HasValue)
{
tkrdpQualifiedDate.SelectedDate = unitInformationUnitDetailsGateway.GetQualifiedDate(unitId);
}
if (unitInformationUnitDetailsGateway.GetNotQualifiedDate(unitId).HasValue)
{
tkrdpNotQualifiedDate.SelectedDate = (DateTime)unitInformationUnitDetailsGateway.GetNotQualifiedDate(unitId);
}
tbxIfNotQualifiedExplain.Text = unitInformationUnitDetailsGateway.GetNotQualifiedExplain(unitId);
}
else
{
if (unitInformationUnitDetailsGateway.GetQualifiedDate(unitId).HasValue) tbxQualifiedDateSummary.Text = ((DateTime)unitInformationUnitDetailsGateway.GetQualifiedDate(unitId)).ToShortDateString();
if (unitInformationUnitDetailsGateway.GetNotQualifiedDate(unitId).HasValue) tbxNotQualifiedDateSummary.Text = ((DateTime)unitInformationUnitDetailsGateway.GetNotQualifiedDate(unitId)).ToShortDateString();
tbxIfNotQualifiedExplainSummary.Text = unitInformationUnitDetailsGateway.GetNotQualifiedExplain(unitId);
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Validate query string
if (((string)Request.QueryString["source_page"] == null) && ((string)Request.QueryString["others"] == null) && ((string)Request.QueryString["employee_id"] == null) && ((string)Request.QueryString["period_id"] == null) && ((string)Request.QueryString["projecttime_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_summary.aspx");
}
// Security check
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (Request.QueryString["others"] == "no")
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
else
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
}
}
}
}
// Initialize viewstate's variables
ViewState["others"] = Request.QueryString["others"];
ViewState["employee_id"] = int.Parse(Request.QueryString["employee_id"]);
ViewState["period_id"] = int.Parse(Request.QueryString["period_id"]);
ViewState["projecttime_id"] = int.Parse(Request.QueryString["projecttime_id"]);
System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader();
ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString();
// Get ProjectTime record
projectTimeTDS = new ProjectTimeTDS();
ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS);
projectTimeGateway.LoadByProjectTimeId((int)ViewState["projecttime_id"]);
// Store datasets
Session["projectTimeTDS"] = projectTimeTDS;
// Databind
tbxDate.DataBind();
tbxWorkingDetails.DataBind();
tbxStartTime.DataBind();
tbxEndTime.DataBind();
tbxLunch.DataBind();
tbxComments.DataBind();
tbxState.DataBind();
// Prepare initial data for client
StoreNavigatorState();
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
employeeGateway.LoadByEmployeeId((int)ViewState["employee_id"]);
tbxEmployee.Text = employeeGateway.GetFullName((int)ViewState["employee_id"]);
int companyId = Int32.Parse(Session["companyID"].ToString());
CompaniesGateway companiesGateway = new CompaniesGateway(new DataSet());
companiesGateway.LoadAllByCompaniesId(projectTimeGateway.GetCompaniesId((int)ViewState["projecttime_id"]), companyId);
tbxClient.Text = companiesGateway.GetName(projectTimeGateway.GetCompaniesId((int)ViewState["projecttime_id"]));
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"]));
tbxProject.Text = projectGateway.GetName(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])) + "(" + projectGateway.GetProjectNumber(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])) + ")";
if (projectGateway.GetFairWageApplies(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])))
{
tbxJobClassType.Visible = true;
lblJobClassType.Visible = true;
tbxJobClassType.Text = projectTimeGateway.GetJobClassType((int)ViewState["projecttime_id"]);
}
else
{
tbxJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
if (projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]).HasValue)
{
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId((Int64)projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]));
tbxMealsCountry.Text = countryGateway.GetName((Int64)projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]));
}
//if (projectTimeGateway.GetMealsAllowance((int)ViewState["projecttime_id"]) > 0)
//{
// cbxMealsAllowance.Checked = true;
//}
//if (projectTimeGateway.GetFairWage((int)ViewState["projecttime_id"]))
//{
// cbxFairWage.Checked = true;
//}
if (projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]).HasValue)
{
UnitsGateway unitGateway = new UnitsGateway(new DataSet());
unitGateway.LoadByUnitId((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]), Convert.ToInt32(Session["companyID"]));
tbxUnit.Text = unitGateway.GetUnitCode((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]));
}
if (projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]).HasValue)
{
UnitsGateway unitGateway = new UnitsGateway(new DataSet());
unitGateway.LoadByUnitId((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]), Convert.ToInt32(Session["companyID"]));
tbxTowed.Text = unitGateway.GetUnitCode((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]));
}
tbxTypeOfWork.Text = "";
if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]) != "")
{
tbxTypeOfWork.Text = projectTimeGateway.GetWork((int)ViewState["projecttime_id"]);
}
tbxFunction.Text = "";
if (projectTimeGateway.GetFunction((int)ViewState["projecttime_id"]) != "")
{
tbxFunction.Text = projectTimeGateway.GetFunction((int)ViewState["projecttime_id"]);
}
}
else
{
// Restore datasets
projectTimeTDS = (ProjectTimeTDS)Session["projectTimeTDS"];
}
}
private void LoadGeneralData()
{
// ... 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()));
hdfClientId.Value = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value)).ToString();
// ... for client
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadAllByCompaniesId(currentCompanyId, companyId);
if (projectTDS.LFS_PROJECT.Rows.Count > 0)
{
tkrdpStartDate.DataBind();
tkrdpEndDate.DataBind();
tkrdpProposalDate.DataBind();
tbxProjectNumber.DataBind();
tbxName.DataBind();
tbxDescription.DataBind();
tbxClientName.Text = companiesGateway.GetName(projectGateway.GetClientID(int.Parse(hdfProjectId.Value)));
tbxClientProjectNumber.DataBind();
// ... ... for primary contact
ContactsList contactList = new ContactsList();
contactList.LoadAllAndAddItemByCompaniesId(-1, " ", projectGateway.GetClientID(int.Parse(hdfProjectId.Value)), companyId);
ddlClientPrimaryContactId.DataSource = contactList.Table;
ddlClientPrimaryContactId.DataValueField = "CONTACTS_ID";
ddlClientPrimaryContactId.DataTextField = "Name";
if (projectGateway.GetClientPrimaryContactID(int.Parse(hdfProjectId.Value)).HasValue)
{
ddlClientPrimaryContactId.SelectedValue = projectGateway.GetClientPrimaryContactID(int.Parse(hdfProjectId.Value)).ToString();
}
else
{
ddlClientPrimaryContactId.SelectedValue = "-1";
}
ddlClientPrimaryContactId.DataBind();
// ... ... for secondary contact
ddlClientSecondaryContactId.DataSource = contactList.Table;
ddlClientSecondaryContactId.DataValueField = "CONTACTS_ID";
ddlClientSecondaryContactId.DataTextField = "Name";
if (projectGateway.GetClientSecondaryContactID(int.Parse(hdfProjectId.Value)).HasValue)
{
ddlClientSecondaryContactId.SelectedValue = projectGateway.GetClientSecondaryContactID(int.Parse(hdfProjectId.Value)).ToString();
}
else
{
ddlClientSecondaryContactId.SelectedValue = "-1";
}
ddlClientSecondaryContactId.DataBind();
// ... for resources
// ... ... for project lead
EmployeeList employeeList = new EmployeeList();
employeeList.LoadAndAddItem(-1, " ");
ddlProjectLeadId.DataSource = employeeList.Table;
ddlProjectLeadId.DataValueField = "EmployeeID";
ddlProjectLeadId.DataTextField = "FullName";
ddlProjectLeadId.SelectedValue = (projectGateway.GetProjectLeadID(int.Parse(hdfProjectId.Value)).HasValue) ? ((int)projectGateway.GetProjectLeadID(int.Parse(hdfProjectId.Value))).ToString() : "-1";
ddlProjectLeadId.DataBind();
// ... ... for salesman
SalesmanListGateway salesmanListGateway = new SalesmanListGateway(new DataSet());
salesmanListGateway.Load();
ddlSalesmanId.DataSource = salesmanListGateway.Table;
ddlSalesmanId.DataValueField = "SalesmanID";
ddlSalesmanId.DataTextField = "FullName";
ddlSalesmanId.SelectedValue = ((int)projectGateway.GetSalesmanID(int.Parse(hdfProjectId.Value))).ToString();
ddlSalesmanId.DataBind();
// ... ... for Pricing
if (projectGateway.GetProjectType(int.Parse(hdfProjectId.Value)) == "Ballpark")
{
ProjectSaleBillingPricingGateway projectSaleBillingPricingGateway = new ProjectSaleBillingPricingGateway(projectTDS);
if (projectSaleBillingPricingGateway.Table.Rows.Count > 0)
{
tbxBillPrice.DataBind();
ddlBillMoney.DataBind();
}
else
{
if (projectGateway.GetCountryID(int.Parse(hdfProjectId.Value)) == 1)
{
ddlBillMoney.SelectedValue = "CAD";
}
else
{
ddlBillMoney.SelectedValue = "USD";
}
}
}
}
cbxFairWageApplies.DataBind();
// 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();
}
private void GrdProjectTimeAdd()
{
Page.Validate("generalData");
int projectId = int.Parse(ddlProject.SelectedValue);
if (Page.IsValid)
{
Page.Validate("footerValidData");
if (Page.IsValid)
{
Page.Validate("footerData");
if (Page.IsValid)
{
// Validate project times
if (FooterValidate())
{
// Save data
int employeeId = Int32.Parse(hdfEmployeeID.Value);
int companiesId = int.Parse(ddlClient.SelectedValue);
if (projectId != 35 && projectId != 39 && projectId != 716)
{
DateTime date_ = tkrdpStartDate.SelectedDate.Value;
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string startTimeFooter = "";
string startHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue != "") startHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue.Trim();
string startMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue != "") startMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue.Trim();
if ((startHoursFooter != "") && (startMinutesFooter != ""))
{
startTimeFooter = startHoursFooter + ":" + startMinutesFooter;
}
string endTimeFooter = "";
string endHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue != "") endHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue.Trim();
string endMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue != "") endMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue.Trim();
if ((endHoursFooter != "") && (endMinutesFooter != ""))
{
endTimeFooter = endHoursFooter + ":" + endMinutesFooter;
}
decimal? offsetFooter = 0; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlLunchFooter")).SelectedValue != "0") offsetFooter = Decimal.Round(decimal.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlLunchFooter")).SelectedValue), 2);
double? offsetFooterFinal = null; if (offsetFooter.HasValue) offsetFooterFinal = double.Parse(((decimal)offsetFooter).ToString());
string typeOfWorkFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTypeOfWorkFooter")).SelectedValue;
int? unitIdFooter = null; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlUnitFooter")).SelectedValue != "-1") unitIdFooter = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlUnitFooter")).SelectedValue);
int? towedIdFooter = null; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTowedFooter")).SelectedValue != "-1") towedIdFooter = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTowedFooter")).SelectedValue);
string workingDetailsFooter = "Canada";
workingDetailsFooter = hdfWorkingDetails.Value;
bool isMealsAllowanceFooter = false;// ((CheckBox)grdProjectTime.FooterRow.FindControl("ckbxMealsAllowanceFooter")).Checked;
string commentsFooter = ((TextBox)grdProjectTime.FooterRow.FindControl("tbxCommentsFooter")).Text;
int companyId = Int32.Parse(hdfCompanyId.Value);
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
bool fairWage = projectGateway.GetFairWageApplies(projectId);
string projectTimeState = "For Approval"; if ((string)ViewState["LHMode"] == "Partial") projectTimeState = "Approved";
string work_ = "";
string function_ = "";
if (typeOfWorkFooter != "(Select)" && typeOfWorkFooter != "")
{
string[] workFunction = typeOfWorkFooter.ToString().Trim().Split('.');
work_ = workFunction[0].Trim();
function_ = workFunction[1].Trim();
}
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = "";
if (countryGateway.Table.Rows.Count > 0)
{
location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
}
string mealsAllowanceType = ""; if (isMealsAllowanceFooter) mealsAllowanceType = "Full Day";
decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, isMealsAllowanceFooter, "Full Day");
string jobClassType = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlJobClassTypeFooter")).SelectedValue;
// Insert Data
ProjectTimeTemp model = new ProjectTimeTemp(projectTimeTDS);
model.Insert(employeeId, companiesId, projectId, date_, startTimeFooter, endTimeFooter, offsetFooterFinal, workingDetailsFooter, location, mealsCountry, mealsAllowanceType, isMealsAllowanceFooter, mealsAllowance, unitIdFooter, towedIdFooter, projectTimeState, commentsFooter, work_, function_, typeOfWorkFooter, fairWage, jobClassType);
// Store Dataset
Session.Remove("projectTimeTempNewDummy");
Session["projectTimeTDS"] = projectTimeTDS;
Session["projectTimeTemp"] = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
grdProjectTime.DataBind();
grdProjectTime.PageIndex = grdProjectTime.PageCount - 1;
}
}
}
}
hdfIsMoreThan15.Value = "false";
upIsMoreThan15.Update();
}
}
protected void grdProjectTime_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("generalData");
if (Page.IsValid)
{
Page.Validate("editValidData");
if (Page.IsValid)
{
Page.Validate("editData");
if (Page.IsValid)
{
int projectTimeId = (int)e.Keys["ProjectTimeID"];
int employeeId = Int32.Parse(hdfEmployeeID.Value);
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
DateTime date_ = tkrdpStartDate.SelectedDate.Value;
string workingDetails = hdfWorkingDetails.Value;
if (projectId == 35 || projectId == 39 || projectId == 716)
{
Page.Validate("specialData");
}
if (Page.IsValid)
{
if (projectId == 35 || projectId == 39 || projectId == 716)
{
date_ = Convert.ToDateTime(((HiddenField)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("hdfDateEdit")).Value);
workingDetails = ddlWorkingDetails.SelectedValue;
}
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string startTime = "";
string startHoursEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlStartTimeHourEdit")).SelectedValue.Trim();
string startMinutesEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlStartTimeMinuteEdit")).SelectedValue.Trim();
if ((startHoursEdit != "") && (startMinutesEdit != "") )
{
startTime = startHoursEdit + ":" + startMinutesEdit;
}
string endTime = "";
string endHoursEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlEndTimeHourEdit")).SelectedValue.Trim();
string endMinutesEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlEndTimeMinuteEdit")).SelectedValue.Trim();
if ((endHoursEdit != "") && (endMinutesEdit != ""))
{
endTime = endHoursEdit + ":" + endMinutesEdit;
}
decimal? offset = 0; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlLunchEdit")).SelectedValue != "0") offset = decimal.Round(Decimal.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlLunchEdit")).SelectedValue), 2);
double? offsetFinal = null; if (offset.HasValue) offsetFinal = double.Parse(((decimal)offset).ToString());
bool isMealsAllowance = false;// ((CheckBox)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ckbxMealsAllowanceEdit")).Checked;
int? unitId = null; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlUnitEdit")).SelectedValue != "-1") unitId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlUnitEdit")).SelectedValue);
int? towedUnitId = null; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlTowedEdit")).SelectedValue != "-1") towedUnitId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlTowedEdit")).SelectedValue);
string comments = ((TextBox)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("tbxCommentsEdit")).Text;
string workFunctionConcat = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlTypeOfWorkFunctionEdit")).SelectedValue;
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
bool fairWage = projectGateway.GetFairWageApplies(projectId);
string work_ = "";
string function_ = "";
if (workFunctionConcat != "(Select)" && workFunctionConcat != "")
{
string[] workFunction = workFunctionConcat.ToString().Trim().Split('.');
work_ = workFunction[0].Trim();
function_ = workFunction[1].Trim();
}
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
string mealsAllowanceType = ""; if (isMealsAllowance) mealsAllowanceType = "Full Day";
decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, isMealsAllowance, "Full Day");
string jobClassType = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlJobClassTypeEdit")).SelectedValue;
// Update data
ProjectTimeTemp model = new ProjectTimeTemp(projectTimeTDS);
model.Update(projectTimeId, companiesId, projectId, date_, startTime, endTime, offsetFinal, workingDetails, location, mealsCountry, mealsAllowanceType, isMealsAllowance, mealsAllowance, unitId, towedUnitId, comments, work_, function_, workFunctionConcat, fairWage, jobClassType);
// Store dataset
Session.Remove("projectTimeTempNewDummy");
Session["projectTimeTDS"] = projectTimeTDS;
Session["projectTimeTemp"] = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}
private void GrdTeamProjectTimeDetailAdd()
{
Page.Validate();
if (Page.IsValid)
{
Page.Validate("footerValidData");
if (Page.IsValid)
{
Page.Validate("footerData");
if (Page.IsValid)
{
int teamProjectTimeId = Int32.Parse(hdfTeamProjectTimeID.Value);
int employeeId = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEmployeesFooter")).SelectedValue);
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
DateTime date_ = tkrdpDate_.SelectedDate.Value;
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string startTimeFooter = "";
string startHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue != "") startHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue.Trim();
string startMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue != "") startMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue.Trim();
if ((startHoursFooter != "") && (startMinutesFooter != ""))
{
startTimeFooter = startHoursFooter + ":" + startMinutesFooter;
}
string endTimeFooter = "";
string endHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue != "") endHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue.Trim();
string endMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue != "") endMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue.Trim();
if ((endHoursFooter != "") && (endMinutesFooter != ""))
{
endTimeFooter = endHoursFooter + ":" + endMinutesFooter;
}
decimal? offsetFooter = 0; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlLunchFooter")).SelectedValue != "0") offsetFooter = Decimal.Round(decimal.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlLunchFooter")).SelectedValue), 2);
double? offsetFooterFinal = null; if (offsetFooter.HasValue) offsetFooterFinal = double.Parse(((decimal)offsetFooter).ToString());
string typeOfWorkFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTypeOfWorkFooter")).SelectedValue;
int? unitIdFooter = null; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlUnitFooter")).SelectedValue != "-1") unitIdFooter = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlUnitFooter")).SelectedValue);
int? towedIdFooter = null; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTowedFooter")).SelectedValue != "-1") towedIdFooter = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTowedFooter")).SelectedValue);
string workingDetailsFooter = tbxWorkingDetails.Text;
bool isMealsAllowanceFooter = false;// ((CheckBox)grdProjectTime.FooterRow.FindControl("ckbxMealsAllowanceFooter")).Checked;
string commentsFooter = ((TextBox)grdProjectTime.FooterRow.FindControl("tbxCommentsFooter")).Text;
int companyId = Int32.Parse(hdfCompanyId.Value);
bool fairWageFooter = false; if (hdfFairWage.Value == "True") fairWageFooter = true;
string jobClassTypeFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlJobClassTypeFooter")).SelectedValue;
string projectTimeState = "For Approval"; if ((string)ViewState["LHMode"] == "Partial") projectTimeState = "Approved";
string work_ = "";
string function_ = "";
if (typeOfWorkFooter != "(Select)")
{
string[] workFunction = typeOfWorkFooter.ToString().Trim().Split('.');
work_ = workFunction[0].Trim();
function_ = workFunction[1].Trim();
}
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
// Insert Data
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
teamProjectTime2DetailTemp.Insert(teamProjectTimeId, employeeId, companiesId, projectId, date_, startTimeFooter, endTimeFooter, offsetFooterFinal, workingDetailsFooter, location, mealsCountry, isMealsAllowanceFooter, unitIdFooter, towedIdFooter, projectTimeState, commentsFooter, work_, function_, typeOfWorkFooter, fairWageFooter, jobClassTypeFooter);
// Store Dataset
Session.Remove("teamProjectTimeDetailTempDummy");
Session["teamProjectTime2TDS"] = teamProjectTime2TDS;
teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; ;
grdProjectTime.DataBind();
grdProjectTime.PageIndex = grdProjectTime.PageCount - 1;
}
}
}
}
private void PostPageChanges()
{
int projectTimeId = (int)ViewState["projecttime_id"];
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
DateTime date_ = tkrdpDate_.SelectedDate.Value;
string workingDetails = ""; if (ddlWorkingDetails.SelectedValue != "(Select)") workingDetails = ddlWorkingDetails.SelectedValue;
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
DateTime? startTime = null;
if ((ddlStartTimeHour.SelectedValue.Trim() != "") && (ddlStartTimeMinute.SelectedValue.Trim() != "") )
{
startTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlStartTimeHour.SelectedValue), Int32.Parse(ddlStartTimeMinute.SelectedValue), 0);
}
DateTime? endTime = null;
if ((ddlEndTimeHour.SelectedValue.Trim() != "") && (ddlEndTimeMinute.SelectedValue.Trim() != "") )
{
endTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlEndTimeHour.SelectedValue), Int32.Parse(ddlEndTimeMinute.SelectedValue), 0);
}
string work_ = ""; if (ddlTypeOfWork.SelectedValue != "(Select a Type)") work_ = ddlTypeOfWork.SelectedValue;
string function_ = ""; if (ddlFunction.SelectedValue != "(Select a Function)") function_ = ddlFunction.SelectedValue;
double? offset = 0; if (ddlLunch.SelectedValue != "0") offset = double.Parse(ddlLunch.SelectedValue);
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string mealsAllowanceType = ""; //if (cbxMealsAllowance.Checked) mealsAllowanceType = "Full Day";
decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, false, "Full Day");
int? unitId = null; if (ddlUnit.SelectedValue != "-1") unitId = int.Parse(ddlUnit.SelectedValue);
int? towedUnitId = null; if (ddlTowed.SelectedValue != "-1") towedUnitId = int.Parse(ddlTowed.SelectedValue);
string comments = tbxComments.Text.Trim();
bool fairWage = projectGateway.GetFairWageApplies(projectId);
string jobClassType = ""; if (ddlJobClassType.SelectedValue != "(Select a Job Class Type)") jobClassType = ddlJobClassType.SelectedValue;
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
int employeeId = employeeGateway.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime projectTime = new LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime(projectTimeTDS);
projectTime.Update(projectTimeId, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, work_, function_, fairWage, jobClassType, employeeId);
}
protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
if ((ddlProject.SelectedValue != null) && (ddlProject.SelectedValue != "-1"))
{
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
if (projectGateway.GetFairWageApplies(projectId))
{
if (projectGateway.GetCountryID(Int32.Parse(ddlProject.SelectedValue)) == 1) //Canada
{
odsJobClassType.SelectParameters.Clear();
odsJobClassType.SelectParameters.Add("countryId", "1");
odsJobClassType.SelectParameters.Add("jobClassType", "(Select a Job Class Type)");
odsJobClassType.SelectParameters.Add("companyId", "3");
odsJobClassType.Select();
}
else
{
odsJobClassType.SelectParameters.Clear();
odsJobClassType.SelectParameters.Add("countryId", "2");
odsJobClassType.SelectParameters.Add("jobClassType", "(Select a Job Class Type)");
odsJobClassType.SelectParameters.Add("companyId", "3");
odsJobClassType.Select();
}
}
else
{
odsJobClassType.SelectParameters.Clear();
odsJobClassType.SelectParameters.Add("countryId", "-1");
odsJobClassType.SelectParameters.Add("jobClassType", "");
odsJobClassType.SelectParameters.Add("companyId", "3");
odsJobClassType.Select();
}
if (projectId != 35 && projectId != 39 && projectId != 716)
{
switch (projectGateway.GetCountryID(projectId))
{
case 1:
ddlMealsCountry.SelectedValue = "1";
hdfWorkingDetails.Value = "Canada";
break;
case 2:
ddlMealsCountry.SelectedValue = "2";
hdfWorkingDetails.Value = "USA";
break;
}
if (tkrdpEndDate.Visible)
{
lblStartDate.Text = "Date";
lblLastDate.Visible = false;
tkrdpEndDate.Visible = false;
}
odsWorkingDetails.SelectParameters.RemoveAt(0);
odsWorkingDetails.SelectParameters.Add("workingDetails", "");
odsWorkingDetails.Select();
ddlWorkingDetails.DataBind();
ddlWorkingDetails.SelectedIndex = 0;
lblWorkingDetails.Visible = false;
ddlWorkingDetails.Visible = false;
lblMealsCountry.Visible = true;
ddlMealsCountry.Visible = true;
grdProjectTime.Visible = true;
lblCommentsVacation.Visible = false;
tbxCommentsVacation.Visible = false;
odsWorkFunctionConcat.SelectParameters.RemoveAt(0);
odsWorkFunctionConcat.SelectParameters.Add("workFunctionConcat", "(Select)");
odsWorkFunctionConcat.Select();
}
else
{
ddlMealsCountry.SelectedIndex = 0;
if (!tkrdpEndDate.Visible)
{
lblStartDate.Text = "Start Date";
lblLastDate.Visible = true;
tkrdpEndDate.Visible = true;
}
odsWorkingDetails.SelectParameters.RemoveAt(0);
odsWorkingDetails.SelectParameters.Add("workingDetails", "(Select)");
odsWorkingDetails.Select();
ddlWorkingDetails.DataBind();
ddlWorkingDetails.SelectedIndex = 0;
lblWorkingDetails.Visible = true;
ddlWorkingDetails.Visible = true;
lblMealsCountry.Visible = false;
ddlMealsCountry.Visible = false;
grdProjectTime.Visible = false;
lblCommentsVacation.Visible = true;
tbxCommentsVacation.Visible = true;
odsWorkFunctionConcat.SelectParameters.RemoveAt(0);
odsWorkFunctionConcat.SelectParameters.Add("workFunctionConcat", "");
odsWorkFunctionConcat.Select();
}
}
grdProjectTime.DataBind();
}
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();
}
/// <summary>
/// GetProjectNumber
/// </summary>
/// <param name="row">row</param>
/// <param name="companyId">companyId</param>
/// <returns></returns>
private string GetProjectNumber(DataMigrationTDS.DataMigrationProjectRow row, int companyId)
{
DateTime date = DateTime.Now;
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(row.CountryID);
string pnCountryId = countryGateway.GetIdForProjects(row.CountryID);
OfficeGateway officeGateway = new OfficeGateway(new DataSet());
officeGateway.LoadByOfficeId(row.OfficeID);
string pnOfficeId = officeGateway.GetIdForProjects(row.OfficeID);
SalesmanGateway salesmanGateway = new SalesmanGateway(new DataSet());
salesmanGateway.LoadBySalesmanId(row.SalesmanID);
string pnSalesmanId = salesmanGateway.GetIdForProjects(row.SalesmanID);
ProjectNumberGateway projectNumberGateway = new ProjectNumberGateway();
projectNumberGateway.Load();
ProjectNumber projectNumber = new ProjectNumber(projectNumberGateway.Data);
string pnYearCode = projectNumber.GetYearCode(date.Year);
string pnProjectIncrement = projectNumber.GetProjectIncrement(date.Year, companyId);
string newProjectNumber = pnCountryId + pnOfficeId + pnSalesmanId + pnYearCode + pnProjectIncrement;
return newProjectNumber;
}
private void PostStepDataChanges()
{
int teamProjectTimeId = (int)ViewState["teamProjectTimeId"];
string templateName = "";
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
DateTime date_ = tkrdpDate_.SelectedDate.Value;
string workingDetails = ""; if (tbxWorkingDetails.Text != "(Select)") workingDetails = tbxWorkingDetails.Text;
string work_ = ddlTypeOfWork.SelectedValue;
string function_ = ddlFunction.SelectedValue;
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
DateTime? startTime = null;
if ((ddlStartTimeHour.SelectedValue.Trim() != "") && (ddlStartTimeMinute.SelectedValue.Trim() != "") )
{
startTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlStartTimeHour.SelectedValue), Int32.Parse(ddlStartTimeMinute.SelectedValue), 0);
}
DateTime? endTime = null;
if ((ddlEndTimeHour.SelectedValue.Trim() != "") && (ddlEndTimeMinute.SelectedValue.Trim() != "") )
{
endTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlEndTimeHour.SelectedValue), Int32.Parse(ddlEndTimeMinute.SelectedValue), 0);
}
double? offset = 0; if (ddlLunch.SelectedValue != "0") offset = double.Parse(ddlLunch.SelectedValue);
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string mealsAllowanceType = ""; //if (cbxMealsAllowance.Checked) mealsAllowanceType = "Full Day";
decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, false, "Full Day");
string comments = "";
string type = "Template";
string state = "Done";
int loginId = Convert.ToInt32(Session["loginID"]);
bool deleted = false;
int? unitId = null;
int? towedUnitId = null;
bool fairWage = false; if (hdfFairWage.Value == "True") fairWage = true;
// New template check
TeamProjectTime2 teamProjectTime2 = new TeamProjectTime2(teamProjectTime2TDS);
if (((int)ViewState["teamProjectTimeId"] == 0) && ((string)ViewState["StepFrom"] != "Employees"))
{
// ... Insert team project time
teamProjectTime2.Insert(teamProjectTimeId, templateName, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, type, state, loginId, deleted, work_, function_, fairWage);
}
else
{
// ... Update team project time
teamProjectTime2.Update(teamProjectTimeId, templateName, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, type, state, loginId, deleted, work_, function_, fairWage);
}
// Store date in date edit for employees step
tbxDate.Text = tkrdpDate_.SelectedDate.Value.ToString();
hdfDate.Value = tkrdpDate_.SelectedDate.Value.ToString();
// Store data in hidden components for employees step
hdfTeamProjectTimeID.Value = teamProjectTimeId.ToString();
hdfCompaniesID.Value = companiesId.ToString();
hdfProjectID.Value = projectId.ToString();
string startTimeForNextStep = "";
if ((ddlStartTimeHour.SelectedValue.Trim() != "") && (ddlStartTimeMinute.SelectedValue.Trim() != ""))
{
startTimeForNextStep = ddlStartTimeHour.SelectedValue.Trim() + ":" + ddlStartTimeMinute.SelectedValue.Trim();
}
hdfStartTime.Value = startTimeForNextStep;
string endTimeForNextStep = "";
if ((ddlEndTimeHour.SelectedValue.Trim() != "") && (ddlEndTimeMinute.SelectedValue.Trim() != ""))
{
endTimeForNextStep = ddlEndTimeHour.SelectedValue.Trim() + ":" + ddlEndTimeMinute.SelectedValue.Trim();
}
hdfEndTime.Value = endTimeForNextStep;
if (offset != null) hdfOffset.Value = offset.ToString(); else hdfOffset.Value = "";
hdfWorkingDetails.Value = workingDetails.ToString();
hdfLocation.Value = location.ToString();
hdfMealsCountry.Value = ddlMealsCountry.SelectedValue;
hdfIsMealsAllowance.Value = "false";// cbxMealsAllowance.Checked.ToString();
hdfMealsAllowance.Value = mealsAllowance.ToString();
hdfProjectTimeState.Value = "For Approval"; if ((string)ViewState["LHMode"] == "Partial") hdfProjectTimeState.Value = "Approved";
//if (cbxClearUnitAssigment.Checked)
hdfClearUnitAssigment.Value = "false";
// ... For work and function string
hdfWork_.Value = work_;
hdfFunction_.Value = function_;
hdfWorkFunctionConcat.Value = work_ + " . " + function_;
// Clear Unit Assigment validation
//if (cbxClearUnitAssigment.Checked)
//{
// // ... Update detail
// TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
// teamProjectTime2DetailTemp.UpdateAll(teamProjectTimeId);
//}
//else
//{
// ... Update detail
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
teamProjectTime2DetailTemp.UpdateAll(teamProjectTimeId, false);
//}
// Store datasets
Session["teamProjectTime2TDS"] = teamProjectTime2TDS;
teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
}
protected string GetCountry(object country)
{
if (country == DBNull.Value)
{
return "";
}
else
{
Int64 countryId = Int64.Parse(country.ToString());
if (countryId > 0)
{
CountryGateway countryGateway = new CountryGateway();
countryGateway.LoadByCountryId(countryId);
return countryGateway.GetName(countryId);
}
else
{
return "";
}
}
}
// ////////////////////////////////////////////////////////////////////////
// NAVIGATION EVENTS
//
protected void tkrmTop_ItemClick(object sender, RadMenuEventArgs e)
{
DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor");
Session["ddlOthersForSelectedValue"] = ddlOthersFor.SelectedValue;
int employeeId = Int32.Parse(hdfEmployeeID.Value);
int periodId = Int32.Parse(hdfPeriodId.Value);
switch (e.Item.Value)
{
case "mSave":
if (ValidatePage())
{
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
if (projectId == 35 || projectId == 39 || projectId == 716)
{
Page.Validate("specialData");
if (Page.IsValid)
{
DateTime startDate = tkrdpStartDate.SelectedDate.Value;
DateTime lastDate = tkrdpEndDate.SelectedDate.Value;
DateTime date_ = startDate;
while (date_ <= lastDate)
{
Int64? mealsCountry = null;
string startTimeFooter = "";
string endTimeFooter = "";
double? offsetFooterFinal = 0;
string typeOfWorkFooter = "";
int? unitIdFooter = null;
int? towedIdFooter = null;
string workingDetailsFooter = ddlWorkingDetails.SelectedValue;
bool isMealsAllowanceFooter = false;
string commentsFooter = tbxCommentsVacation.Text;
int companyId = Int32.Parse(hdfCompanyId.Value);
bool fairWage = false;
string projectTimeState = "For Approval"; if ((string)ViewState["LHMode"] == "Partial") projectTimeState = "Approved";
string work_ = "";
string function_ = "";
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = "";
if (countryGateway.Table.Rows.Count > 0)
{
location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
}
string mealsAllowanceType = "";
decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, isMealsAllowanceFooter, "Full Day");
string jobClassType = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlJobClassTypeFooter")).SelectedValue;
// Insert Data
ProjectTimeTemp model = new ProjectTimeTemp(projectTimeTDS);
model.Insert(employeeId, companiesId, projectId, date_, startTimeFooter, endTimeFooter, offsetFooterFinal, workingDetailsFooter, location, mealsCountry, mealsAllowanceType, isMealsAllowanceFooter, mealsAllowance, unitIdFooter, towedIdFooter, projectTimeState, commentsFooter, work_, function_, typeOfWorkFooter, fairWage, jobClassType);
date_ = date_.AddDays(1);
// ... ... Store Dataset
Session.Remove("projectTimeTempNewDummy");
Session["projectTimeTDS"] = projectTimeTDS;
Session["projectTimeTemp"] = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
}
PostPageChanges();
UpdateDatabase();
Response.Redirect("./../timesheet/timesheet.aspx?source_page=timesheet_add.aspx&others=" + ViewState["others"] + "&employee_id=" + employeeId.ToString() + "&period_id=" + periodId.ToString() + "&projecttime_id=" + DB.GetIdentCurrent("LFS_PROJECT_TIME").ToString());
}
}
else
{
// Project time Gridview, if the gridview is edition mode
if (grdProjectTime.EditIndex >= 0)
{
grdProjectTime.UpdateRow(grdProjectTime.EditIndex, true);
}
// Insert Data
GrdProjectTimeAdd();
PostPageChanges();
UpdateDatabase();
Response.Redirect("./../timesheet/timesheet.aspx?source_page=timesheet_add.aspx&others=" + ViewState["others"] + "&employee_id=" + employeeId.ToString() + "&period_id=" + periodId.ToString() + "&projecttime_id=" + DB.GetIdentCurrent("LFS_PROJECT_TIME").ToString());
}
}
break;
case "mCancel":
if (Request.QueryString["source_page"] == "timesheet.aspx")
{
Response.Redirect("./../timesheet/timesheet.aspx?source_page=timesheet_add.aspx&others=" + ViewState["others"] + "&employee_id=" + employeeId.ToString() + "&period_id=" + periodId.ToString());
}
else
{
if (Request.QueryString["source_page"] == "timesheet_summary_from_approve_project_times.aspx")
{
Response.Redirect("./timesheet_summary.aspx?source_page=timesheet_approve.aspx&others=" + ViewState["others"] + "&employee_id=" + employeeId.ToString() + "&period_id=" + periodId.ToString() + "&projecttime_id=" + ViewState["projecttime_id"]);
}
else
{
Response.Redirect("./timesheet_summary.aspx?source_page=timesheet_add.aspx&others=" + ViewState["others"] + "&employee_id=" + employeeId.ToString() + "&period_id=" + periodId.ToString() + "&projecttime_id=" + ViewState["projecttime_id"]);
}
}
break;
}
}
private void TagPage()
{
hdfWorkType.Value = Request.QueryString["work_type"].ToString();
hdfCompanyId.Value = Session["companyID"].ToString();
hdfProjectId.Value = Request.QueryString["project_id"].ToString();
// Get ids & location
int projectId = Int32.Parse(hdfProjectId.Value.Trim());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
// ... Get ids
Int64 currentCountry = projectGateway.GetCountryID(projectId);
Int64? currentProvince = null; if (projectGateway.GetProvinceID(projectId).HasValue) currentProvince = (Int64)projectGateway.GetProvinceID(projectId);
Int64? currentCounty = null; if (projectGateway.GetCountyID(projectId).HasValue) currentCounty = (Int64)projectGateway.GetCountyID(projectId);
Int64? currentCity = null; if (projectGateway.GetCityID(projectId).HasValue) currentCity = (Int64)projectGateway.GetCityID(projectId);
hdfCountryId.Value = currentCountry.ToString();
hdfProvinceId.Value = currentProvince.ToString();
hdfCountyId.Value = currentCounty.ToString();
hdfCityId.Value = currentCity.ToString();
// .. Get location
string projectLocation = "";
CountryGateway countryGateway = new CountryGateway();
countryGateway.LoadByCountryId(currentCountry);
projectLocation = projectLocation + countryGateway.GetName(currentCountry);
if (currentProvince.HasValue)
{
ProvinceGateway provinceGateway = new ProvinceGateway();
provinceGateway.LoadByProvinceId((Int64)currentProvince);
projectLocation = projectLocation + ", " + provinceGateway.GetName((Int64)currentProvince);
}
if (currentCounty.HasValue)
{
CountyGateway countyGateway = new CountyGateway();
countyGateway.LoadByCountyId((Int64)currentCounty);
projectLocation = projectLocation + ", " + countyGateway.GetName((Int64)currentCounty);
}
if (currentCity.HasValue)
{
CityGateway cityGateway = new CityGateway();
cityGateway.LoadByCityId((Int64)currentCity);
projectLocation = projectLocation + ", " + cityGateway.GetName((Int64)currentCity);
}
hdfSearchTitle.Value = projectLocation;
}
protected void grdProjectTime_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("editValidData");
if (Page.IsValid)
{
Page.Validate("editData");
if (Page.IsValid)
{
int teamProjectTimeId = (int)e.Keys["TeamProjectTimeID"];
int detailId = (int)e.Keys["DetailID"];
DateTime date_ = DateTime.Parse(hdfDate.Value);
int employeeId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlEmployeesEdit")).SelectedValue);
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string startTime = "";
string startHoursEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlStartTimeHourEdit")).SelectedValue.Trim();
string startMinutesEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlStartTimeMinuteEdit")).SelectedValue.Trim();
if ((startHoursEdit != "") && (startMinutesEdit != ""))
{
startTime = startHoursEdit + ":" + startMinutesEdit;
}
string endTime = "";
string endHoursEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlEndTimeHourEdit")).SelectedValue.Trim();
string endMinutesEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlEndTimeMinuteEdit")).SelectedValue.Trim();
if ((endHoursEdit != "") && (endMinutesEdit != ""))
{
endTime = endHoursEdit + ":" + endMinutesEdit;
}
decimal? offset = 0; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlLunchEdit")).SelectedValue != "0") offset = decimal.Round(Decimal.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlLunchEdit")).SelectedValue), 2);
double? offsetFinal = null; if (offset.HasValue) offsetFinal = double.Parse(((decimal)offset).ToString());
string workingDetails = tbxWorkingDetails.Text;
bool isMealsAllowance = false;// ((CheckBox)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ckbxMealsAllowanceEdit")).Checked;
int? unitId = null; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlUnitEdit")).SelectedValue != "-1") unitId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlUnitEdit")).SelectedValue);
int? towedUnitId = null; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlTowedEdit")).SelectedValue != "-1") towedUnitId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlTowedEdit")).SelectedValue);
string comments = ((TextBox)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("tbxCommentsEdit")).Text;
string workFunctionConcat = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlTypeOfWorkFunctionEdit")).SelectedValue;
string work_ = "";
string function_ = "";
if (workFunctionConcat != "(Select)")
{
string[] workFunction = workFunctionConcat.ToString().Trim().Split('.');
work_ = workFunction[0].Trim();
function_ = workFunction[1].Trim();
}
bool fairWage = false; if (hdfFairWage.Value == "True") fairWage = true;
string jobClassType = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlJobClassTypeEdit")).SelectedValue;
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
// Update data
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
teamProjectTime2DetailTemp.Update(teamProjectTimeId, detailId, employeeId, date_, startTime, endTime, offsetFinal, workingDetails, location, mealsCountry, isMealsAllowance, unitId, towedUnitId, comments, work_, function_, workFunctionConcat, fairWage, jobClassType);
// Store dataset
Session.Remove("teamProjectTimeDetailTempDummy");
Session["teamProjectTime2TDS"] = teamProjectTime2TDS;
Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}