private void UpdateDatabase()
{
try
{
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
//LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway(libraryTDS);
//libraryFilesGateway.Update();
//libraryTDS.AcceptChanges();
//Getting projectId for Notes table
ProjectNotesGateway projectNotesGateway = new ProjectNotesGateway(projectTDS);
projectGateway.Update3();
projectTDS.AcceptChanges();
// Save notes
int companyId = Int32.Parse(hdfCompanyId.Value);
//ProjectNavigatorProjectNotesGateway projectNavigatorNotesGateway = new ProjectNavigatorProjectNotesGateway(projectNavigatorTDS);
//ProjectNavigatorProjectNotes projectNavigatorProjectNotes = new ProjectNavigatorProjectNotes(projectNavigatorTDS);
//foreach (ProjectNavigatorTDS.ProjectNotesRow rowNotes in (ProjectNavigatorTDS.ProjectNotesDataTable)projectNavigatorNotesGateway.Table)
//{
// if (!rowNotes.IsLIBRARY_FILES_IDNull())
// {
// if (rowNotes.LIBRARY_FILES_ID == 0 && rowNotes.FILENAME != "")
// {
// libraryFilesGateway.LoadByFileName(rowNotes.FILENAME, companyId);
// int newLibraryFilesId = libraryFilesGateway.GetlibraryFilesId(rowNotes.FILENAME);
// rowNotes.LIBRARY_FILES_ID = newLibraryFilesId;
// }
// }
//}
//projectNavigatorProjectNotes.Save(companyId);
// Save job info
ProjectNavigatorProjectJobInfo projectNavigatorProjectJobInfo = new ProjectNavigatorProjectJobInfo(projectNavigatorTDS);
projectNavigatorProjectJobInfo.Save(companyId);
// Save services
ProjectNavigatorProjectService projectNavigatorProjectService = new ProjectNavigatorProjectService(projectNavigatorTDS);
projectNavigatorProjectService.UpdateForSave();
projectNavigatorProjectService.Save(companyId);
// Save Cost Exceptions
// ... Save Job Class Type Rate Classification
ProjectNavigatorProjectJobClassTypeRate projectNavigatorProjectJobClassTypeRate = new ProjectNavigatorProjectJobClassTypeRate(projectNavigatorTDS);
projectNavigatorProjectJobClassTypeRate.Save(companyId);
// ... Save Work Function Fair Wage Classification
ProjectNavigatorProjectWorkFunctionFairWage projectNavigatorProjectWorkFunctionFairWage = new ProjectNavigatorProjectWorkFunctionFairWage(projectNavigatorTDS);
projectNavigatorProjectWorkFunctionFairWage.Save(companyId);
// ... Save budget
ProjectNavigatorProjectWorkFunctionBudget projectNavigatorProjectWorkFunctionBudget = new ProjectNavigatorProjectWorkFunctionBudget(projectNavigatorTDS);
projectNavigatorProjectWorkFunctionBudget.Save(companyId);
ProjectNavigatorProjectUnitsBudget projectNavigatorProjectUnitsBudget = new ProjectNavigatorProjectUnitsBudget(projectNavigatorTDS);
projectNavigatorProjectUnitsBudget.Save(companyId);
ProjectNavigatorProjectMaterialsBudget projectNavigatorProjectMaterialsBudget = new ProjectNavigatorProjectMaterialsBudget(projectNavigatorTDS);
projectNavigatorProjectMaterialsBudget.Save(companyId);
ProjectNavigatorProjectSubcontractorsBudget projectNavigatorProjectSubcontractorsBudget = new ProjectNavigatorProjectSubcontractorsBudget(projectNavigatorTDS);
projectNavigatorProjectSubcontractorsBudget.Save(companyId);
ProjectNavigatorProjectHotelsBudget projectNavigatorProjectHotelsBudget = new ProjectNavigatorProjectHotelsBudget(projectNavigatorTDS);
projectNavigatorProjectHotelsBudget.Save(companyId);
ProjectNavigatorProjectBondingsBudget projectNavigatorProjectBondingsBudget = new ProjectNavigatorProjectBondingsBudget(projectNavigatorTDS);
projectNavigatorProjectBondingsBudget.Save(companyId);
ProjectNavigatorProjectInsurancesBudget projectNavigatorProjectInsurancesBudget = new ProjectNavigatorProjectInsurancesBudget(projectNavigatorTDS);
projectNavigatorProjectInsurancesBudget.Save(companyId);
ProjectNavigatorProjectOtherCostsBudget projectNavigatorProjectOtherCostsBudget = new ProjectNavigatorProjectOtherCostsBudget(projectNavigatorTDS);
projectNavigatorProjectOtherCostsBudget.Save(companyId);
projectNavigatorTDS.AcceptChanges();
Session["projectNavigatorTDS"] = projectNavigatorTDS;
Session["lfsProjectTDS"] = projectTDS;
Session["lfsLibraryTDS"] = libraryTDS;
}
catch (Exception ex)
{
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
//private void GrdNotesDeleteAttachment(int libraryFileId, int refId)
//{
// // Button delete functionality
// if (libraryFileId != 0)
// {
// ProjectNavigatorProjectNotes projectNavigatorProjectNotes = new ProjectNavigatorProjectNotes(projectNavigatorTDS);
// projectNavigatorProjectNotes.UpdateLibraryFilesId(int.Parse(hdfProjectId.Value), refId, null, "", "");
// LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway(libraryTDS);
// libraryFilesGateway.DeleteByLibraryFilesId(libraryFileId);
// ViewState["update"] = "no";
// Session["lfsProjectTDS"] = projectTDS;
// Session["projectNavigatorTDS"] = projectNavigatorTDS;
// projectNotes = projectNavigatorTDS.ProjectNotes;
// Session["projectNotes"] = projectNavigatorTDS.ProjectNotes;
// Session["lfsLibraryTDS"] = libraryTDS;
//grdNotes.DataBind();
// }
//}
//private void GrdNotesOpenAttachment(string originalFileName, string fileName)
//{
// // Button download functionality
// if ((originalFileName != "") && (fileName != ""))
// {
// // Escape single quote
// originalFileName = originalFileName.Replace("'", "%27");
// fileName = fileName.Replace("'", "%27");
// string script = "<script language='javascript'>";
// string url = "./project_download_attachment.aspx?original_filename=" + Server.UrlEncode(originalFileName) + "&filename=" + Server.UrlEncode(fileName);
// script = script + string.Format("window.open('{0}', '_blank', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=0, height=0')", url);
// script = script + "</script>";
// ScriptManager.RegisterStartupScript(this, this.GetType(), "DownloadAttachment", script, false);
// }
//}
//private void GrdNotesAddAttachment(int? refId, string subject)
//{
// Save2();
// // Escape single quote
// subject = subject.Replace("'", "%27");
// if (refId.HasValue)
// {
// if (ViewState["libraryCategoriesId"] != null)
// {
// string script = "<script language='javascript'>";
// string url = "./project_add_attachment.aspx?source_page=project_notes.aspx&subject=" + Server.UrlEncode(subject) + "&refId=" + refId.ToString() + "&project_id=" + hdfProjectId.Value + "&library_categories_id=" + Int32.Parse(ViewState["libraryCategoriesId"].ToString()) + "&data_changed=" + hdfDataChanged.Value;
// script = script + string.Format("window.open('{0}', '_blank', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=510, height=270')", url);
// script = script + "</script>";
// ScriptManager.RegisterStartupScript(this, this.GetType(), "Notes", script, false);
// }
// }
// else
// {
// ProjectNavigatorProjectNotes model = new ProjectNavigatorProjectNotes(projectNavigatorTDS);
// refId = model.GetLastRefId();
// if (ViewState["libraryCategoriesId"] != null)
// {
// string script = "<script language='javascript'>";
// string url = "./project_add_attachment.aspx?source_page=project_notes.aspx&subject=" + Server.UrlEncode(subject) + "&refId=" + refId.ToString() + "&project_id=" + hdfProjectId.Value + "&library_categories_id=" + Int32.Parse(ViewState["libraryCategoriesId"].ToString()) + "&data_changed=" + hdfDataChanged.Value;
// script = script + string.Format("window.open('{0}', '_blank', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=510, height=270')", url);
// script = script + "</script>";
// ScriptManager.RegisterStartupScript(this, this.GetType(), "Notes", script, false);
// }
// }
//}
//private void GrdNotesAdd()
//{
// if (ValidateNotesFooter())
// {
// Page.Validate("notesDataAdd");
// if (Page.IsValid)
// {
// int companyId = Int32.Parse(hdfCompanyId.Value);
// int projectId = Int32.Parse(hdfProjectId.Value);
// string newSubject = ((TextBox)grdNotes.FooterRow.FindControl("tbxNoteSubjectNew")).Text.Trim();
// int loginId = Convert.ToInt32(Session["loginID"]);
// DateTime dateTime = DateTime.Now;
// string newNote = ((TextBox)grdNotes.FooterRow.FindControl("tbxNoteNoteNew")).Text.Trim();
// bool deleted = false;
// bool inNoteDatabase = false;
// int? libraryFilesId = null;
// string fileName = ((Label)grdNotes.FooterRow.FindControl("lblFileNameNoteAttachmentNew")).Text.Trim();
// if (fileName != "")
// {
// LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway();
// libraryFilesId = libraryFilesGateway.GetlibraryFilesId(fileName);
// }
// ProjectNavigatorProjectNotes model = new ProjectNavigatorProjectNotes(projectNavigatorTDS);
// model.Insert(projectId, newSubject, dateTime, loginId, newNote, deleted, libraryFilesId, companyId, inNoteDatabase);
// Session.Remove("projectNotesDummy");
// Session["projectNavigatorTDS"] = projectNavigatorTDS;
// grdNotes.DataBind();
// grdNotes.PageIndex = grdNotes.PageCount - 1;
// }
// }
//}
private void GrdJobClassClassificationAdd()
{
Page.Validate("jobClassClassificationDataAdd");
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int projectId = Int32.Parse(hdfProjectId.Value);
string jobClassType = ((DropDownList)grdJobClassClassification.FooterRow.FindControl("ddlJobClassNew")).SelectedValue;
decimal rate = decimal.Parse(((TextBox)grdJobClassClassification.FooterRow.FindControl("tbxRateNew")).Text);
decimal fringeRate = decimal.Parse(((TextBox)grdJobClassClassification.FooterRow.FindControl("tbxFringeRateNew")).Text);
ProjectNavigatorProjectJobClassTypeRate model = new ProjectNavigatorProjectJobClassTypeRate(projectNavigatorTDS);
model.Insert(projectId, jobClassType, rate, false, companyId, false, fringeRate);
Session.Remove("projectJobClassClassificationDummy");
Session["projectNavigatorTDS"] = projectNavigatorTDS;
projectJobClassClassification = projectNavigatorTDS.LFS_PROJECT_JOB_CLASS_TYPE_RATE;
Session["projectJobClassClassification"] = projectJobClassClassification;
grdJobClassClassification.DataBind();
}
}
//protected void grdNotes_RowUpdating(object sender, GridViewUpdateEventArgs e)
//{
// Page.Validate("notesDataEdit");
// if (Page.IsValid)
// {
// int companyId = Int32.Parse(hdfCompanyId.Value);
// int projectId = Int32.Parse(((Label)grdNotes.Rows[e.RowIndex].Cells[0].FindControl("lblProjectIDEdit")).Text.Trim());
// int refId = Int32.Parse(((Label)grdNotes.Rows[e.RowIndex].Cells[1].FindControl("lblRefIDEdit")).Text.Trim());
// string subject = ((TextBox)grdNotes.Rows[e.RowIndex].Cells[4].FindControl("tbxNoteSubjectEdit")).Text.Trim();
// string note = ((TextBox)grdNotes.Rows[e.RowIndex].Cells[5].FindControl("tbxNoteNoteEdit")).Text.Trim();
// int? libraryFilesId = null;
// if (((Label)grdNotes.Rows[e.RowIndex].Cells[3].FindControl("lblLibraryFileIdEdit")).Text.Trim() != "")
// {
// libraryFilesId = Int32.Parse(((Label)grdNotes.Rows[e.RowIndex].Cells[3].FindControl("lblLibraryFileIdEdit")).Text.Trim());
// }
// // Update data
// ProjectNavigatorProjectNotes model = new ProjectNavigatorProjectNotes(projectNavigatorTDS);
// model.Update(projectId, refId, subject, note, libraryFilesId);
// // Store dataset
// Session["projectNavigatorTDS"] = projectNavigatorTDS;
// }
// else
// {
// e.Cancel = true;
// }
//}
//protected void grdServices_RowUpdating(object sender, GridViewUpdateEventArgs e)
//{
// Page.Validate("serviceDataEdit");
// if (Page.IsValid)
// {
// int companyId = Int32.Parse(hdfCompanyId.Value);
// int projectId = Int32.Parse(((Label)grdServices.Rows[e.RowIndex].Cells[0].FindControl("lblProjectID")).Text.Trim());
// int refId = Int32.Parse(((Label)grdServices.Rows[e.RowIndex].Cells[1].FindControl("lblRefID")).Text.Trim());
// int? serviceId = null;
// if (((DropDownList)grdServices.Rows[e.RowIndex].Cells[2].FindControl("ddlServiceEdit")).SelectedValue != "-1")
// {
// serviceId = int.Parse(((DropDownList)grdServices.Rows[e.RowIndex].Cells[2].FindControl("ddlServiceEdit")).SelectedValue);
// }
// string description = ((TextBox)grdServices.Rows[e.RowIndex].Cells[3].FindControl("tbxDescriptionEdit")).Text.Trim();
// int quantity = 0;
// if (((TextBox)grdServices.Rows[e.RowIndex].Cells[4].FindControl("tbxQuantityEdit")).Text.Trim() != "")
// {
// quantity = int.Parse(((TextBox)grdServices.Rows[e.RowIndex].Cells[4].FindControl("tbxQuantityEdit")).Text.Trim());
// }
// string averageSize = ((TextBox)grdServices.Rows[e.RowIndex].Cells[5].FindControl("tbxAverageSizeEdit")).Text.Trim();
// decimal? averagePrice = 0.00M;
// decimal total = 0.00M;
// if (((TextBox)grdServices.Rows[e.RowIndex].Cells[6].FindControl("tbxAveragePriceEdit")).Text.Trim() != "")
// {
// averagePrice = decimal.Parse(((TextBox)grdServices.Rows[e.RowIndex].Cells[6].FindControl("tbxAveragePriceEdit")).Text.Trim());
// total = decimal.Round(((decimal)averagePrice * quantity), 2);
// }
// // Update data
// ProjectNavigatorProjectService model = new ProjectNavigatorProjectService(projectNavigatorTDS);
// model.Update(projectId, refId, serviceId, description, averageSize, averagePrice, quantity, total);
// // Store dataset
// Session["projectNavigatorTDS"] = projectNavigatorTDS;
// // ... Recalc total cost
// tbxTotalCost.Text = Decimal.Round(model.GetTotalCost(), 2).ToString();
// }
// else
// {
// e.Cancel = true;
// }
//}
protected void grdJobClassClassification_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("jobClassClassificationDataEdit");
if (Page.IsValid)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int projectId = Int32.Parse(((Label)grdJobClassClassification.Rows[e.RowIndex].Cells[0].FindControl("lblProjectIDEdit")).Text.Trim());
string jobClassType = ((Label)grdJobClassClassification.Rows[e.RowIndex].Cells[0].FindControl("lblJobClassTypeEdit")).Text.Trim();
int refId = Int32.Parse(((Label)grdJobClassClassification.Rows[e.RowIndex].Cells[1].FindControl("lblRefIDEdit")).Text.Trim());
decimal rate = Decimal.Parse(((TextBox)grdJobClassClassification.Rows[e.RowIndex].Cells[1].FindControl("tbxRateEdit")).Text.Trim());
decimal fringeRate = Decimal.Parse(((TextBox)grdJobClassClassification.Rows[e.RowIndex].Cells[1].FindControl("tbxFringeRateEdit")).Text.Trim());
// Update data
ProjectNavigatorProjectJobClassTypeRate model = new ProjectNavigatorProjectJobClassTypeRate(projectNavigatorTDS);
model.Update(projectId, jobClassType, refId, rate, fringeRate);
projectJobClassClassification = projectNavigatorTDS.LFS_PROJECT_JOB_CLASS_TYPE_RATE;
Session["projectJobClassClassification"] = projectJobClassClassification;
// Store dataset
Session["projectNavigatorTDS"] = projectNavigatorTDS;
}
else
{
e.Cancel = true;
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_PROJECTS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_PROJECTS_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["project_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in project_edit.aspx");
}
// Tag page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfProjectId.Value = Request.QueryString["project_id"];
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfDataChanged.Value = Request.QueryString["data_changed"];
hdfDataChangedMessage.Value = "Changes made to this project will not be saved.";
// Prepare initial data
Session.Remove("projectNotesDummy");
Session.Remove("projectServicesDummy");
Session.Remove("projectTypeOfWorkFunctionClassificationDummy");
Session.Remove("projectJobClassClassificationDummy");
Session.Remove("projectBudgetDummy");
Session.Remove("subcontractorsBudgetDummy");
Session.Remove("hotelsBudgetDummy");
Session.Remove("bondingsBudgetDummy");
Session.Remove("insurancesBudgetDummy");
Session.Remove("otherCostsBudgetDummy");
Session["fairWage"] = "None";
// ... Set initial tab
if ((string)Session["dialogOpenedProjects"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabProjects"];
}
// ... For Library
if (Session["lfsLibraryTDS"] != null)
{
libraryTDS = (LibraryTDS)Session["lfsLibraryTDS"];
}
else
{
libraryTDS = new LibraryTDS();
}
// If coming from
// ... projects2.aspx or project_add.aspx
if (Request.QueryString["source_page"] == "projects2.aspx" || Request.QueryString["source_page"] == "project_add.aspx")
{
// Store Navigator State, Update control and Origin
StoreNavigatorState();
ViewState["update"] = "no";
ViewState["origin"] = "navigator";
// Get Project Id
int projectId = int.Parse(hdfProjectId.Value);
// ... Attachment control
if (Session["fromAttachment"] != null)
{
if (Session["fromAttachment"].ToString() == "yes")
{
// Restore dataset
projectTDS = (ProjectTDS)Session["lfsProjectTDS"];
projectNavigatorTDS = (ProjectNavigatorTDS)Session["projectNavigatorTDS"];
projectNotes = (ProjectNavigatorTDS.ProjectNotesDataTable)Session["projectNotes"];
projectServices = (ProjectNavigatorTDS.ProjectServiceDataTable)Session["projectServices"];
projectJobClassClassification = (ProjectNavigatorTDS.LFS_PROJECT_JOB_CLASS_TYPE_RATEDataTable)Session["projectJobClassClassification"];
projectTypeOfWorkFunctionClassification = (ProjectNavigatorTDS.LFS_PROJECT_WORK_FUNCTION_FAIR_WAGEDataTable)Session["projectTypeOfWorkFunctionClassification"];
projectBudget = (ProjectNavigatorTDS.ProjectWorkFunctionBudgetDataTable)Session["projectBudget"];
unitsBudget = (ProjectNavigatorTDS.ProjectUnitsBudgetDataTable)Session["unitsBudget"];
materialsBudget = (ProjectNavigatorTDS.ProjectMaterialsBudgetDataTable)Session["materialsBudget"];
subcontractorsBudget = (ProjectNavigatorTDS.ProjectSubcontractorsBudgetDataTable)Session["subcontractorsBudget"];
hotelsBudget = (ProjectNavigatorTDS.ProjectHotelsBudgetDataTable)Session["hotelsBudget"];
bondingsBudget = (ProjectNavigatorTDS.ProjectBondingsBudgetDataTable)Session["bondingsBudget"];
insurancesBudget = (ProjectNavigatorTDS.ProjectInsurancesBudgetDataTable)Session["insurancesBudget"];
otherCostsBudget = (ProjectNavigatorTDS.ProjectOtherCostsBudgetDataTable)Session["otherCostsBudget"];
}
Session.Remove("fromAttachment");
}
else
{
// Get dataset
projectTDS = new ProjectTDS();
projectNavigatorTDS = new ProjectNavigatorTDS();
projectNotes = new ProjectNavigatorTDS.ProjectNotesDataTable();
projectServices = new ProjectNavigatorTDS.ProjectServiceDataTable();
projectTypeOfWorkFunctionClassification = new ProjectNavigatorTDS.LFS_PROJECT_WORK_FUNCTION_FAIR_WAGEDataTable();
projectJobClassClassification = new ProjectNavigatorTDS.LFS_PROJECT_JOB_CLASS_TYPE_RATEDataTable();
projectBudget = new ProjectNavigatorTDS.ProjectWorkFunctionBudgetDataTable();
unitsBudget = new ProjectNavigatorTDS.ProjectUnitsBudgetDataTable();
materialsBudget = new ProjectNavigatorTDS.ProjectMaterialsBudgetDataTable();
subcontractorsBudget = new ProjectNavigatorTDS.ProjectSubcontractorsBudgetDataTable();
hotelsBudget = new ProjectNavigatorTDS.ProjectHotelsBudgetDataTable();
bondingsBudget = new ProjectNavigatorTDS.ProjectBondingsBudgetDataTable();
insurancesBudget = new ProjectNavigatorTDS.ProjectInsurancesBudgetDataTable();
otherCostsBudget = new ProjectNavigatorTDS.ProjectOtherCostsBudgetDataTable();
// Get General Data
ProjectGateway projectGatewayForLoad = new ProjectGateway(projectTDS);
projectGatewayForLoad.LoadByProjectId(projectId);
// Get job info
ProjectJobInfoGateway projectJobInfoGateway = new ProjectJobInfoGateway(projectNavigatorTDS);
projectJobInfoGateway.LoadAllByProjectId(projectId);
// Get Sale/Billing/Pricing
ProjectSaleBillingPricingGateway projectSaleBillingPricingGatewayForLoad = new ProjectSaleBillingPricingGateway(projectTDS);
projectSaleBillingPricingGatewayForLoad.LoadAllByProjectId(projectId);
// ... Get Sale/Billing/Pricing - Services
ProjectNavigatorProjectService projectNavigatorProjectService = new ProjectNavigatorProjectService(projectNavigatorTDS);
projectNavigatorProjectService.LoadAllByProjectId(projectId);
projectNavigatorProjectService.UpdateForLoad();
// Get Costing Updates
ProjectCostingUpdatesGateway projectCostingUpdatesGatewayForLoad = new ProjectCostingUpdatesGateway(projectTDS);
projectCostingUpdatesGatewayForLoad.LoadByProjectId(projectId);
// Get Project Terms
ProjectTermsPOGateway projectTermsPOGatewayForLoad = new ProjectTermsPOGateway(projectTDS);
projectTermsPOGatewayForLoad.LoadByProjectId(projectId);
// Get Technical
ProjectTechnicalGateway projectTechnicalGatewayForLoad = new ProjectTechnicalGateway(projectTDS);
projectTechnicalGatewayForLoad.LoadByProjectId(projectId);
// Get Engineer Subcontractors
ProjectEngineerSubcontractorsGateway projectEngineerSubcontractorsGatewayForLoad = new ProjectEngineerSubcontractorsGateway(projectTDS);
projectEngineerSubcontractorsGatewayForLoad.LoadAllByProjectId(projectId);
// ... Get Subcontractors
ProjectSubcontractorGateway projectSubcontractorGatewayForLoad = new ProjectSubcontractorGateway(projectTDS);
projectSubcontractorGatewayForLoad.LoadAllByProjectId(projectId);
// Cost Exceptions
// ... Get Type Of Work & Function Classification
ProjectNavigatorProjectWorkFunctionFairWage projectNavigatorProjectWorkFunctionFairWage = new ProjectNavigatorProjectWorkFunctionFairWage(projectNavigatorTDS);
projectNavigatorProjectWorkFunctionFairWage.LoadAllByProjectId(projectId);
// ... Get Job Class Classification
ProjectNavigatorProjectJobClassTypeRate projectNavigatorProjectJobClassTypeRate = new ProjectNavigatorProjectJobClassTypeRate(projectNavigatorTDS);
projectNavigatorProjectJobClassTypeRate.LoadAllByProjectId(projectId);
// Get Budget
ProjectNavigatorProjectWorkFunctionBudget projectNavigatorProjectWorkFunctionBudget = new ProjectNavigatorProjectWorkFunctionBudget(projectNavigatorTDS);
projectNavigatorProjectWorkFunctionBudget.LoadAllByProjectId(projectId);
// Get Units Budget
ProjectNavigatorProjectUnitsBudget projectNavigatorProjectUnitsBudget = new ProjectNavigatorProjectUnitsBudget(projectNavigatorTDS);
projectNavigatorProjectUnitsBudget.LoadAllByProjectId(projectId);
// Get Materials Budget
ProjectNavigatorProjectMaterialsBudget projectNavigatorProjectMaterialsBudget = new ProjectNavigatorProjectMaterialsBudget(projectNavigatorTDS);
projectNavigatorProjectMaterialsBudget.LoadAllByProjectId(projectId);
// Get Subcontractors Budget
ProjectNavigatorProjectSubcontractorsBudget projectNavigatorProjectSubcontractorsBudget = new ProjectNavigatorProjectSubcontractorsBudget(projectNavigatorTDS);
projectNavigatorProjectSubcontractorsBudget.LoadAllByProjectId(projectId);
// Get Hotels Budget
ProjectNavigatorProjectHotelsBudget projectNavigatorProjectHotelsBudget = new ProjectNavigatorProjectHotelsBudget(projectNavigatorTDS);
projectNavigatorProjectHotelsBudget.LoadAllByProjectId(projectId);
// Get Bondings Budget
ProjectNavigatorProjectBondingsBudget projectNavigatorProjectBondingsBudget = new ProjectNavigatorProjectBondingsBudget(projectNavigatorTDS);
projectNavigatorProjectBondingsBudget.LoadAllByProjectId(projectId);
// Get Insurances Budget
ProjectNavigatorProjectInsurancesBudget projectNavigatorProjectInsurancesBudget = new ProjectNavigatorProjectInsurancesBudget(projectNavigatorTDS);
projectNavigatorProjectInsurancesBudget.LoadAllByProjectId(projectId);
// Get Other Costs Budget
ProjectNavigatorProjectOtherCostsBudget projectNavigatorProjectOtherCostsBudget = new ProjectNavigatorProjectOtherCostsBudget(projectNavigatorTDS);
projectNavigatorProjectOtherCostsBudget.LoadAllByProjectId(projectId);
// Get Notes
ProjectNavigatorProjectNotes projectNavigatorProjectNotes = new ProjectNavigatorProjectNotes(projectNavigatorTDS);
projectNavigatorProjectNotes.LoadAllByProjectId(projectId);
// Store dataset
Session["lfsProjectTDS"] = projectTDS;
Session["projectNavigatorTDS"] = projectNavigatorTDS;
Session["projectNotes"] = projectNavigatorTDS.ProjectNotes;
Session["projectServices"] = projectNavigatorTDS.ProjectService;
Session["projectTypeOfWorkFunctionClassification"] = projectNavigatorTDS.LFS_PROJECT_WORK_FUNCTION_FAIR_WAGE;
Session["projectJobClassClassification"] = projectNavigatorTDS.LFS_PROJECT_JOB_CLASS_TYPE_RATE;
Session["projectBudget"] = projectNavigatorTDS.ProjectWorkFunctionBudget;
Session["unitsBudget"] = projectNavigatorTDS.ProjectUnitsBudget;
Session["materialsBudget"] = projectNavigatorTDS.ProjectMaterialsBudget;
Session["subcontractorsBudget"] = projectNavigatorTDS.ProjectSubcontractorsBudget;
Session["hotelsBudget"] = projectNavigatorTDS.ProjectHotelsBudget;
Session["bondingsBudget"] = projectNavigatorTDS.ProjectBondingsBudget;
Session["insurancesBudget"] = projectNavigatorTDS.ProjectInsurancesBudget;
Session["otherCostsBudget"] = projectNavigatorTDS.ProjectOtherCostsBudget;
}
//grdNotes.DataBind();
//grdServices.DataBind();
grdTypeOfWorkFunctionClassification.DataBind();
grdJobClassClassification.DataBind();
grdBudget.DataBind();
/*grdSubcontractorsBudget.DataBind();
grdHotelsBudget.DataBind();
grdBondingsBudget.DataBind();
grdInsurancesBudget.DataBind();*/
grdOtherCostsBudget.DataBind();
}
// ... project_summary.aspx or project_edit.aspx
if ((Request.QueryString["source_page"] == "project_summary.aspx") || (Request.QueryString["source_page"] == "project_edit.aspx") || (Request.QueryString["source_page"] == "lm"))
{
// Store Navigator State, update control and origin
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
ViewState["origin"] = Request.QueryString["origin"]; //summary
// Restore dataset
projectTDS = (ProjectTDS)Session["lfsProjectTDS"];
projectNavigatorTDS = (ProjectNavigatorTDS)Session["projectNavigatorTDS"];
projectNotes = (ProjectNavigatorTDS.ProjectNotesDataTable)Session["projectNotes"];
projectServices = (ProjectNavigatorTDS.ProjectServiceDataTable)Session["projectServices"];
projectJobClassClassification = (ProjectNavigatorTDS.LFS_PROJECT_JOB_CLASS_TYPE_RATEDataTable)Session["projectJobClassClassification"];
projectTypeOfWorkFunctionClassification = (ProjectNavigatorTDS.LFS_PROJECT_WORK_FUNCTION_FAIR_WAGEDataTable)Session["projectTypeOfWorkFunctionClassification"];
projectBudget = (ProjectNavigatorTDS.ProjectWorkFunctionBudgetDataTable)Session["projectBudget"];
unitsBudget = (ProjectNavigatorTDS.ProjectUnitsBudgetDataTable)Session["unitsBudget"];
materialsBudget = (ProjectNavigatorTDS.ProjectMaterialsBudgetDataTable)Session["materialsBudget"];
subcontractorsBudget = (ProjectNavigatorTDS.ProjectSubcontractorsBudgetDataTable)Session["subcontractorsBudget"];
hotelsBudget = (ProjectNavigatorTDS.ProjectHotelsBudgetDataTable)Session["hotelsBudget"];
bondingsBudget = (ProjectNavigatorTDS.ProjectBondingsBudgetDataTable)Session["bondingsBudget"];
insurancesBudget = (ProjectNavigatorTDS.ProjectInsurancesBudgetDataTable)Session["insurancesBudget"];
otherCostsBudget = (ProjectNavigatorTDS.ProjectOtherCostsBudgetDataTable)Session["otherCostsBudget"];
// Get Project Id
int projectId = int.Parse(hdfProjectId.Value);
if (ViewState["update"].ToString().Trim() == "yes")
{
// Get General Data
ProjectGateway projectGatewayForLoad = new ProjectGateway(projectTDS);
projectGatewayForLoad.LoadByProjectId(projectId);
// Get job info
ProjectJobInfoGateway projectJobInfoGateway = new ProjectJobInfoGateway(projectNavigatorTDS);
projectJobInfoGateway.LoadAllByProjectId(projectId);
// Get Sale/Billing/Pricing
ProjectSaleBillingPricingGateway projectSaleBillingPricingGatewayForLoad = new ProjectSaleBillingPricingGateway(projectTDS);
projectSaleBillingPricingGatewayForLoad.LoadAllByProjectId(projectId);
// ... Get Sale/Billing/Pricing - Services
ProjectNavigatorProjectService projectNavigatorProjectService = new ProjectNavigatorProjectService(projectNavigatorTDS);
projectNavigatorProjectService.LoadAllByProjectId(projectId);
projectNavigatorProjectService.UpdateForLoad();
// Get Costing Updates
ProjectCostingUpdatesGateway projectCostingUpdatesGatewayForLoad = new ProjectCostingUpdatesGateway(projectTDS);
projectCostingUpdatesGatewayForLoad.LoadByProjectId(projectId);
// Get Project Terms
ProjectTermsPOGateway projectTermsPOGatewayForLoad = new ProjectTermsPOGateway(projectTDS);
projectTermsPOGatewayForLoad.LoadByProjectId(projectId);
// Get Technical
ProjectTechnicalGateway projectTechnicalGatewayForLoad = new ProjectTechnicalGateway(projectTDS);
projectTechnicalGatewayForLoad.LoadByProjectId(projectId);
// Get Engineer Subcontractors
ProjectEngineerSubcontractorsGateway projectEngineerSubcontractorsGatewayForLoad = new ProjectEngineerSubcontractorsGateway(projectTDS);
projectEngineerSubcontractorsGatewayForLoad.LoadAllByProjectId(projectId);
// ... Get Subcontractors
ProjectSubcontractorGateway projectSubcontractorGatewayForLoad = new ProjectSubcontractorGateway(projectTDS);
projectSubcontractorGatewayForLoad.LoadAllByProjectId(projectId);
// Cost Exceptions
// ... Get Type Of Work & Function Classification
ProjectNavigatorProjectWorkFunctionFairWage projectNavigatorProjectWorkFunctionFairWage = new ProjectNavigatorProjectWorkFunctionFairWage(projectNavigatorTDS);
projectNavigatorProjectWorkFunctionFairWage.LoadAllByProjectId(projectId);
// ... Get Job Class Classification
ProjectNavigatorProjectJobClassTypeRate projectNavigatorProjectJobClassTypeRate = new ProjectNavigatorProjectJobClassTypeRate(projectNavigatorTDS);
projectNavigatorProjectJobClassTypeRate.LoadAllByProjectId(projectId);
// Get Budget
ProjectNavigatorProjectWorkFunctionBudget projectNavigatorProjectWorkFunctionBudget = new ProjectNavigatorProjectWorkFunctionBudget(projectNavigatorTDS);
projectNavigatorProjectWorkFunctionBudget.LoadAllByProjectId(projectId);
// Get Units Budget
ProjectNavigatorProjectUnitsBudget projectNavigatorProjectUnitsBudget = new ProjectNavigatorProjectUnitsBudget(projectNavigatorTDS);
projectNavigatorProjectUnitsBudget.LoadAllByProjectId(projectId);
// Get Materials Budget
ProjectNavigatorProjectMaterialsBudget projectNavigatorProjectMaterialsBudget = new ProjectNavigatorProjectMaterialsBudget(projectNavigatorTDS);
projectNavigatorProjectMaterialsBudget.LoadAllByProjectId(projectId);
// Get Subcontractors Budget
ProjectNavigatorProjectSubcontractorsBudget projectNavigatorProjectSubcontractorsBudget = new ProjectNavigatorProjectSubcontractorsBudget(projectNavigatorTDS);
projectNavigatorProjectSubcontractorsBudget.LoadAllByProjectId(projectId);
// Get Hotels Budget
ProjectNavigatorProjectHotelsBudget projectNavigatorProjectHotelsBudget = new ProjectNavigatorProjectHotelsBudget(projectNavigatorTDS);
projectNavigatorProjectHotelsBudget.LoadAllByProjectId(projectId);
// Get Bondings Budget
ProjectNavigatorProjectBondingsBudget projectNavigatorProjectBondingsBudget = new ProjectNavigatorProjectBondingsBudget(projectNavigatorTDS);
projectNavigatorProjectBondingsBudget.LoadAllByProjectId(projectId);
// Get Insurances Budget
ProjectNavigatorProjectInsurancesBudget projectNavigatorProjectInsurancesBudget = new ProjectNavigatorProjectInsurancesBudget(projectNavigatorTDS);
projectNavigatorProjectInsurancesBudget.LoadAllByProjectId(projectId);
// Get Other Costs Budget
ProjectNavigatorProjectOtherCostsBudget projectNavigatorProjectOtherCostsBudget = new ProjectNavigatorProjectOtherCostsBudget(projectNavigatorTDS);
projectNavigatorProjectOtherCostsBudget.LoadAllByProjectId(projectId);
// Get Notes
ProjectNavigatorProjectNotes projectNavigatorProjectNotes = new ProjectNavigatorProjectNotes(projectNavigatorTDS);
projectNavigatorProjectNotes.LoadAllByProjectId(projectId);
//grdNotes.DataBind();
//grdServices.DataBind();
grdTypeOfWorkFunctionClassification.DataBind();
grdJobClassClassification.DataBind();
grdBudget.DataBind();
/*grdSubcontractorsBudget.DataBind();
grdHotelsBudget.DataBind();
grdBondingsBudget.DataBind();
grdInsurancesBudget.DataBind();*/
grdOtherCostsBudget.DataBind();
// Store dataset
Session["lfsProjectTDS"] = projectTDS;
Session["projectNavigatorTDS"] = projectNavigatorTDS;
Session["projectNotes"] = projectNavigatorTDS.ProjectNotes;
Session["projectServices"] = projectNavigatorTDS.ProjectService;
Session["projectTypeOfWorkFunctionClassification"] = projectNavigatorTDS.LFS_PROJECT_WORK_FUNCTION_FAIR_WAGE;
Session["projectJobClassClassification"] = projectNavigatorTDS.LFS_PROJECT_JOB_CLASS_TYPE_RATE;
Session["projectBudget"] = projectNavigatorTDS.ProjectWorkFunctionBudget;
Session["unitsBudget"] = projectNavigatorTDS.ProjectUnitsBudget;
Session["materialsBudget"] = projectNavigatorTDS.ProjectMaterialsBudget;
Session["subcontractorsBudget"] = projectNavigatorTDS.ProjectSubcontractorsBudget;
Session["hotelsBudget"] = projectNavigatorTDS.ProjectHotelsBudget;
Session["bondingsBudget"] = projectNavigatorTDS.ProjectBondingsBudget;
Session["insurancesBudget"] = projectNavigatorTDS.ProjectInsurancesBudget;
Session["otherCostsBudget"] = projectNavigatorTDS.ProjectOtherCostsBudget;
}
}
// Data for current project
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
// ... for project
int currentProjectId = Int32.Parse(hdfProjectId.Value.ToString());
string name = projectGateway.GetName(currentProjectId);
if (name.Length > 23) name = name.Substring(0, 20) + "...";
lblTitleProjectName.Text = name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
// ... for client
int companyId = Int32.Parse(hdfCompanyId.Value);
int currentClientId = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value.ToString()));
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadAllByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// Load Data
LoadData();
// Store Dataset
Session["lfsProjectTDS"] = projectTDS;
//// ... For total cost at services
//ProjectNavigatorProjectService projectNavigatorProjectServiceForCost = new ProjectNavigatorProjectService(projectNavigatorTDS);
//tbxTotalCost.Text = Decimal.Round(projectNavigatorProjectServiceForCost.GetTotalCost(), 2).ToString();
}
else
{
// Restore dataset
projectTDS = (ProjectTDS)Session["lfsProjectTDS"];
projectNavigatorTDS = (ProjectNavigatorTDS)Session["projectNavigatorTDS"];
projectNotes = (ProjectNavigatorTDS.ProjectNotesDataTable)Session["projectNotes"];
projectServices = (ProjectNavigatorTDS.ProjectServiceDataTable)Session["projectServices"];
projectJobClassClassification = (ProjectNavigatorTDS.LFS_PROJECT_JOB_CLASS_TYPE_RATEDataTable)Session["projectJobClassClassification"];
projectTypeOfWorkFunctionClassification = (ProjectNavigatorTDS.LFS_PROJECT_WORK_FUNCTION_FAIR_WAGEDataTable)Session["projectTypeOfWorkFunctionClassification"];
projectBudget = (ProjectNavigatorTDS.ProjectWorkFunctionBudgetDataTable)Session["projectBudget"];
unitsBudget = (ProjectNavigatorTDS.ProjectUnitsBudgetDataTable)Session["unitsBudget"];
materialsBudget = (ProjectNavigatorTDS.ProjectMaterialsBudgetDataTable)Session["materialsBudget"];
subcontractorsBudget = (ProjectNavigatorTDS.ProjectSubcontractorsBudgetDataTable)Session["subcontractorsBudget"];
hotelsBudget = (ProjectNavigatorTDS.ProjectHotelsBudgetDataTable)Session["hotelsBudget"];
bondingsBudget = (ProjectNavigatorTDS.ProjectBondingsBudgetDataTable)Session["bondingsBudget"];
insurancesBudget = (ProjectNavigatorTDS.ProjectInsurancesBudgetDataTable)Session["insurancesBudget"];
otherCostsBudget = (ProjectNavigatorTDS.ProjectOtherCostsBudgetDataTable)Session["otherCostsBudget"];
tbxProjectNumber.DataBind();
if (Session["lfsLibraryTDS"] != null)
{
libraryTDS = (LibraryTDS)Session["lfsLibraryTDS"];
}
else
{
libraryTDS = new LibraryTDS();
}
}
}
//protected void grdServices_RowDeleting(object sender, GridViewDeleteEventArgs e)
//{
// // Services Gridview, if the gridview is edition mode
// if (grdServices.EditIndex >= 0)
// {
// grdServices.UpdateRow(grdServices.EditIndex, true);
// }
// // Delete services
// int projectId = (int)e.Keys["ProjectID"];
// int refId = (int)e.Keys["RefID"];
// ProjectNavigatorProjectService model = new ProjectNavigatorProjectService(projectNavigatorTDS);
// model.Delete(projectId, refId);
// // Store dataset
// Session["projectNavigatorTDS"] = projectNavigatorTDS;
// // ... Recalc total cost
// tbxTotalCost.Text = Decimal.Round(model.GetTotalCost(), 2).ToString();
//}
protected void grdJobClassClassification_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// grdJobClassClassification Gridview, if the gridview is edition mode
if (grdJobClassClassification.EditIndex >= 0)
{
grdJobClassClassification.UpdateRow(grdJobClassClassification.EditIndex, true);
}
// Delete grdJobClassClassification
int projectId = (int)e.Keys["ProjectID"];
string jobClassType = (string)e.Keys["JobClassType"];
int refId = (int)e.Keys["RefID"];
// ... Delete
ProjectNavigatorProjectJobClassTypeRate model = new ProjectNavigatorProjectJobClassTypeRate(projectNavigatorTDS);
model.Delete(projectId, jobClassType, refId);
// Store dataset
Session["projectNavigatorTDS"] = projectNavigatorTDS;
grdJobClassClassification.DataBind();
}
