/// <summary>
/// Update4 - Duplicate proposal
/// </summary>
public void Update4()
{
ProjectCostingUpdatesGateway projectCostingUpdatesGateway = new ProjectCostingUpdatesGateway(Data);
ProjectEngineerSubcontractorsGateway projectEngineerSubcontractorsGateway = new ProjectEngineerSubcontractorsGateway(Data);
ProjectHistoryGateway projectHistoryGateway = new ProjectHistoryGateway(Data);
ProjectNotesGateway projectNotesGateway = new ProjectNotesGateway(Data);
ProjectSaleBillingPricingGateway projectSaleBillingPricingGateway = new ProjectSaleBillingPricingGateway(Data);
ProjectServiceGateway projectServiceGateway = new ProjectServiceGateway(Data);
ProjectSubcontractorGateway projectSubcontractorGateway = new ProjectSubcontractorGateway(Data);
ProjectTechnicalGateway projectTechnicalGateway = new ProjectTechnicalGateway(Data);
ProjectTermsPOGateway projectTermsPOGateway = new ProjectTermsPOGateway(Data);
DataTable projectChanges = Table.GetChanges();
DataTable projectCostingUpdatesChanges = projectCostingUpdatesGateway.Table.GetChanges();
DataTable projectEngineerSubcontractorsChanges = projectEngineerSubcontractorsGateway.Table.GetChanges();
DataTable projectHistoryChanges = projectHistoryGateway.Table.GetChanges();
DataTable projectNotesChanges = projectNotesGateway.Table.GetChanges();
DataTable projectSaleBillingPricingChanges = projectSaleBillingPricingGateway.Table.GetChanges();
DataTable projectServiceChanges = projectServiceGateway.Table.GetChanges();
DataTable projectSubcontractorChanges = projectSubcontractorGateway.Table.GetChanges();
DataTable projectTechnicalChanges = projectTechnicalGateway.Table.GetChanges();
DataTable projectTermsPOChanges = projectTermsPOGateway.Table.GetChanges();
if ((projectChanges == null) && (projectCostingUpdatesChanges == null) && (projectEngineerSubcontractorsChanges == null) && (projectHistoryChanges == null) && (projectNotesChanges == null) && (projectSaleBillingPricingChanges == null) && (projectServiceChanges == null) && (projectSubcontractorChanges == null) && (projectTechnicalChanges == null) && (projectTermsPOChanges == null)) return;
try
{
DB.Open();
DB.BeginTransaction();
Adapter.InsertCommand.Transaction = DB.Transaction;
Adapter.UpdateCommand.Transaction = DB.Transaction;
Adapter.DeleteCommand.Transaction = DB.Transaction;
projectCostingUpdatesGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectCostingUpdatesGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectCostingUpdatesGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectEngineerSubcontractorsGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectEngineerSubcontractorsGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectEngineerSubcontractorsGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectHistoryGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectHistoryGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectHistoryGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectNotesGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectNotesGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectNotesGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectSaleBillingPricingGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectSaleBillingPricingGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectSaleBillingPricingGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectServiceGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectServiceGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectServiceGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectSubcontractorGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectSubcontractorGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectSubcontractorGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectTechnicalGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectTechnicalGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectTechnicalGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectTermsPOGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectTermsPOGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectTermsPOGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
if ((projectChanges != null) && (projectChanges.Rows.Count > 0))
{
Adapter.Update(projectChanges);
int newProjectId = DB.GetIdentCurrent("LFS_PROJECT", DB.Transaction);
//Getting projectId for History table
ProjectTDS.LFS_PROJECT_HISTORYRow rowHistory = ((ProjectTDS.LFS_PROJECT_HISTORYDataTable)projectHistoryGateway.Table).FindByProjectIDRefID(0, 1);
rowHistory.ProjectID = newProjectId;
projectHistoryChanges = projectHistoryGateway.Table.GetChanges();
//Getting projectId for Costing Updates table
if (projectCostingUpdatesGateway.Table.Rows.Count > 0)
{
ProjectTDS.LFS_PROJECT_COSTING_UPDATESRow rowProjectCosting = ((ProjectTDS.LFS_PROJECT_COSTING_UPDATESDataTable)projectCostingUpdatesGateway.Table).FindByProjectID(0);
rowProjectCosting.ProjectID = newProjectId;
projectCostingUpdatesChanges = projectCostingUpdatesGateway.Table.GetChanges();
}
//Getting projectId for Engineer Subcontractors table
if (projectEngineerSubcontractorsGateway.Table.Rows.Count > 0)
{
ProjectTDS.LFS_PROJECT_ENGINEER_SUBCONTRACTORSRow rowEngineerSubcontractors = ((ProjectTDS.LFS_PROJECT_ENGINEER_SUBCONTRACTORSDataTable)projectEngineerSubcontractorsGateway.Table).FindByProjectID(0);
rowEngineerSubcontractors.ProjectID = newProjectId;
projectEngineerSubcontractorsChanges = projectEngineerSubcontractorsGateway.Table.GetChanges();
}
//Getting projectId for Notes table
foreach (ProjectTDS.LFS_PROJECT_NOTERow rowNotes in (ProjectTDS.LFS_PROJECT_NOTEDataTable)projectNotesGateway.Table)
{
if (rowNotes.ProjectID == 0)
{
rowNotes.ProjectID = newProjectId;
}
}
projectNotesChanges = projectNotesGateway.Table.GetChanges();
//Getting projectId for SaleBillingPricing
if (projectSaleBillingPricingGateway.Table.Rows.Count > 0)
{
ProjectTDS.LFS_PROJECT_SALE_BILLING_PRICINGRow rowSaleBillingPricing = ((ProjectTDS.LFS_PROJECT_SALE_BILLING_PRICINGDataTable)projectSaleBillingPricingGateway.Table).FindByProjectID(0);
rowSaleBillingPricing.ProjectID = newProjectId;
projectSaleBillingPricingChanges = projectSaleBillingPricingGateway.Table.GetChanges();
}
//Getting projectId for Subcontractors
foreach (ProjectTDS.LFS_PROJECT_SUBCONTRACTORRow rowSubcontractor in (ProjectTDS.LFS_PROJECT_SUBCONTRACTORDataTable)projectSubcontractorGateway.Table)
{
if (rowSubcontractor.ProjectID == 0)
{
rowSubcontractor.ProjectID = newProjectId;
}
}
projectSubcontractorChanges = projectSubcontractorGateway.Table.GetChanges();
//Getting projectId for Services
foreach (ProjectTDS.LFS_PROJECT_SERVICERow rowService in (ProjectTDS.LFS_PROJECT_SERVICEDataTable)projectServiceGateway.Table)
{
if (rowService.ProjectID == 0)
{
rowService.ProjectID = newProjectId;
}
}
projectServiceChanges = projectServiceGateway.Table.GetChanges();
//Getting projectId for Technical
if (projectTechnicalGateway.Table.Rows.Count > 0)
{
ProjectTDS.LFS_PROJECT_TECHNICALRow rowTechnical = ((ProjectTDS.LFS_PROJECT_TECHNICALDataTable)projectTechnicalGateway.Table).FindByProjectID(0);
rowTechnical.ProjectID = newProjectId;
projectTechnicalChanges = projectTechnicalGateway.Table.GetChanges();
}
//Getting projectId for Terms
if (projectTermsPOGateway.Table.Rows.Count > 0)
{
ProjectTDS.LFS_PROJECT_TERMSRow rowTerms = ((ProjectTDS.LFS_PROJECT_TERMSDataTable)projectTermsPOGateway.Table).FindByProjectID(0);
rowTerms.ProjectID = newProjectId;
projectTermsPOChanges = projectTermsPOGateway.Table.GetChanges();
}
}
if ((projectCostingUpdatesChanges != null) && (projectCostingUpdatesChanges.Rows.Count > 0))
{
projectCostingUpdatesGateway.Adapter.Update(projectCostingUpdatesChanges);
}
if ((projectEngineerSubcontractorsChanges != null) && (projectEngineerSubcontractorsChanges.Rows.Count > 0))
{
projectEngineerSubcontractorsGateway.Adapter.Update(projectEngineerSubcontractorsChanges);
}
if ((projectHistoryChanges != null) && (projectHistoryChanges.Rows.Count > 0))
{
projectHistoryGateway.Adapter.Update(projectHistoryChanges);
}
if ((projectNotesChanges != null) && (projectNotesChanges.Rows.Count > 0))
{
projectNotesGateway.Adapter.Update(projectNotesChanges);
}
if ((projectSaleBillingPricingChanges != null) && (projectSaleBillingPricingChanges.Rows.Count > 0))
{
projectSaleBillingPricingGateway.Adapter.Update(projectSaleBillingPricingChanges);
}
if ((projectServiceChanges != null) && (projectServiceChanges.Rows.Count > 0))
{
projectServiceGateway.Adapter.Update(projectServiceChanges);
}
if ((projectSubcontractorChanges != null) && (projectSubcontractorChanges.Rows.Count > 0))
{
projectSubcontractorGateway.Adapter.Update(projectSubcontractorChanges);
}
if ((projectTechnicalChanges != null) && (projectTechnicalChanges.Rows.Count > 0))
{
projectTechnicalGateway.Adapter.Update(projectTechnicalChanges);
}
if ((projectTermsPOChanges != null) && (projectTermsPOChanges.Rows.Count > 0))
{
projectTermsPOGateway.Adapter.Update(projectTermsPOChanges);
}
DB.CommitTransaction();
}
catch (DBConcurrencyException dBConcurrencyException)
{
DB.RollbackTransaction();
throw new Exception("Concurrency error: Another user already updated the data you are working on. Your operation has been cancelled.", dBConcurrencyException);
}
catch (SqlException sqlException)
{
DB.RollbackTransaction();
byte severityLevel = sqlException.Class;
if (severityLevel <= 16)
{
throw new Exception("Low severity error. Your operation has been cancelled. SQL Error " + severityLevel + ".");
}
if ((severityLevel >= 17) && (severityLevel <= 19))
{
throw new Exception("Mid severity error. Your operation has been cancelled. SQL Error " + severityLevel + ".");
}
if (severityLevel >= 20)
{
throw new Exception("High severity error. Your operation has been cancelled. SQL Error " + severityLevel + ".");
}
}
catch (Exception e)
{
DB.RollbackTransaction();
throw new Exception("Unknow error. Your operation has been cancelled.", e);
}
finally
{
DB.Close();
}
}
/// <summary>
/// Update3 - Update all project
/// </summary>
public void Update3()
{
ProjectCostingUpdatesGateway projectCostingUpdatesGateway = new ProjectCostingUpdatesGateway(Data);
ProjectEngineerSubcontractorsGateway projectEngineerSubcontractorsGateway = new ProjectEngineerSubcontractorsGateway(Data);
ProjectHistoryGateway projectHistoryGateway = new ProjectHistoryGateway(Data);
ProjectSaleBillingPricingGateway projectSaleBillingPricingGateway = new ProjectSaleBillingPricingGateway(Data);
ProjectSubcontractorGateway projectSubcontractorGateway = new ProjectSubcontractorGateway(Data);
ProjectTechnicalGateway projectTechnicalGateway = new ProjectTechnicalGateway(Data);
ProjectTermsPOGateway projectTermsPOGateway = new ProjectTermsPOGateway(Data);
DataTable projectChanges = Table.GetChanges();
DataTable projectCostingUpdatesChanges = projectCostingUpdatesGateway.Table.GetChanges();
DataTable projectEngineerSubcontractorsChanges = projectEngineerSubcontractorsGateway.Table.GetChanges();
DataTable projectHistoryChanges = projectHistoryGateway.Table.GetChanges();
DataTable projectSaleBillingPricingChanges = projectSaleBillingPricingGateway.Table.GetChanges();
DataTable projectSubcontractorChanges = projectSubcontractorGateway.Table.GetChanges();
DataTable projectTechnicalChanges = projectTechnicalGateway.Table.GetChanges();
DataTable projectTermsPOChanges = projectTermsPOGateway.Table.GetChanges();
if ((projectChanges == null) && (projectCostingUpdatesChanges == null) && (projectEngineerSubcontractorsChanges == null) && (projectHistoryChanges == null) && (projectSaleBillingPricingChanges == null) && (projectSubcontractorChanges == null) && (projectTechnicalChanges == null) && (projectTermsPOChanges == null)) return;
try
{
DB.Open();
DB.BeginTransaction();
Adapter.InsertCommand.Transaction = DB.Transaction;
Adapter.UpdateCommand.Transaction = DB.Transaction;
Adapter.DeleteCommand.Transaction = DB.Transaction;
projectCostingUpdatesGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectCostingUpdatesGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectCostingUpdatesGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectEngineerSubcontractorsGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectEngineerSubcontractorsGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectEngineerSubcontractorsGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectHistoryGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectHistoryGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectHistoryGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectSaleBillingPricingGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectSaleBillingPricingGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectSaleBillingPricingGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectSubcontractorGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectSubcontractorGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectSubcontractorGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectTechnicalGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectTechnicalGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectTechnicalGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectTermsPOGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectTermsPOGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectTermsPOGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
if ((projectChanges != null) && (projectChanges.Rows.Count > 0))
{
Adapter.Update(projectChanges);
}
if ((projectCostingUpdatesChanges != null) && (projectCostingUpdatesChanges.Rows.Count > 0))
{
projectCostingUpdatesGateway.Adapter.Update(projectCostingUpdatesChanges);
}
if ((projectEngineerSubcontractorsChanges != null) && (projectEngineerSubcontractorsChanges.Rows.Count > 0))
{
projectEngineerSubcontractorsGateway.Adapter.Update(projectEngineerSubcontractorsChanges);
}
if ((projectHistoryChanges != null) && (projectHistoryChanges.Rows.Count > 0))
{
projectHistoryGateway.Adapter.Update(projectHistoryChanges);
}
if ((projectSaleBillingPricingChanges != null) && (projectSaleBillingPricingChanges.Rows.Count > 0))
{
projectSaleBillingPricingGateway.Adapter.Update(projectSaleBillingPricingChanges);
}
if ((projectSubcontractorChanges != null) && (projectSubcontractorChanges.Rows.Count > 0))
{
projectSubcontractorGateway.Adapter.Update(projectSubcontractorChanges);
}
if ((projectTechnicalChanges != null) && (projectTechnicalChanges.Rows.Count > 0))
{
projectTechnicalGateway.Adapter.Update(projectTechnicalChanges);
}
if ((projectTermsPOChanges != null) && (projectTermsPOChanges.Rows.Count > 0))
{
projectTermsPOGateway.Adapter.Update(projectTermsPOChanges);
}
DB.CommitTransaction();
}
catch (DBConcurrencyException dBConcurrencyException)
{
DB.RollbackTransaction();
throw new Exception("Concurrency error: Another user already updated the data you are working on. Your operation has been cancelled.", dBConcurrencyException);
}
catch (SqlException sqlException)
{
DB.RollbackTransaction();
byte severityLevel = sqlException.Class;
if (severityLevel <= 16)
{
throw new Exception("Low severity error. Your operation has been cancelled. SQL Error " + severityLevel + ".");
}
if ((severityLevel >= 17) && (severityLevel <= 19))
{
throw new Exception("Mid severity error. Your operation has been cancelled. SQL Error " + severityLevel + ".");
}
if (severityLevel >= 20)
{
throw new Exception("High severity error. Your operation has been cancelled. SQL Error " + severityLevel + ".");
}
}
catch (Exception e)
{
DB.RollbackTransaction();
throw new Exception("Unknow error. Your operation has been cancelled.", e);
}
finally
{
DB.Close();
}
}
/// <summary>
/// Update2 - ProjectNumber and ProjectHistory
/// </summary>
public void Update2()
{
ProjectNumberGateway projectNumberGateway = new ProjectNumberGateway(Data);
ProjectHistoryGateway projectHistoryGateway = new ProjectHistoryGateway(Data);
DataTable projectChanges = Table.GetChanges();
DataTable projectNumberChanges = projectNumberGateway.Table.GetChanges();
DataTable projectHistoryChanges = projectHistoryGateway.Table.GetChanges();
if ((projectChanges == null) && (projectNumberChanges == null) && (projectHistoryChanges == null)) return;
try
{
DB.Open();
DB.BeginTransaction();
Adapter.InsertCommand.Transaction = DB.Transaction;
Adapter.UpdateCommand.Transaction = DB.Transaction;
Adapter.DeleteCommand.Transaction = DB.Transaction;
projectNumberGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectNumberGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectNumberGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
projectHistoryGateway.Adapter.InsertCommand.Transaction = DB.Transaction;
projectHistoryGateway.Adapter.UpdateCommand.Transaction = DB.Transaction;
projectHistoryGateway.Adapter.DeleteCommand.Transaction = DB.Transaction;
if ((projectChanges != null) && (projectChanges.Rows.Count > 0))
{
Adapter.Update(projectChanges);
int newProjectId = DB.GetIdentCurrent("LFS_PROJECT", DB.Transaction);
//Getting projectId for History table
ProjectTDS.LFS_PROJECT_HISTORYRow row = ((ProjectTDS.LFS_PROJECT_HISTORYDataTable)projectHistoryGateway.Table).FindByProjectIDRefID(0, 1);
row.ProjectID = newProjectId;
projectHistoryChanges = projectHistoryGateway.Table.GetChanges();
}
if ((projectNumberChanges != null) && (projectNumberChanges.Rows.Count > 0))
{
projectNumberGateway.Adapter.Update(projectNumberChanges);
}
if ((projectHistoryChanges != null) && (projectHistoryChanges.Rows.Count > 0))
{
projectHistoryGateway.Adapter.Update(projectHistoryChanges);
}
DB.CommitTransaction();
}
catch (DBConcurrencyException dBConcurrencyException)
{
DB.RollbackTransaction();
throw new Exception("Concurrency error: Another user already updated the data you are working on. Your operation has been cancelled.", dBConcurrencyException);
}
catch (SqlException sqlException)
{
DB.RollbackTransaction();
byte severityLevel = sqlException.Class;
if (severityLevel <= 16)
{
throw new Exception("Low severity error. Your operation has been cancelled. SQL Error " + severityLevel + ".");
}
if ((severityLevel >= 17) && (severityLevel <= 19))
{
throw new Exception("Mid severity error. Your operation has been cancelled. SQL Error " + severityLevel + ".");
}
if (severityLevel >= 20)
{
throw new Exception("High severity error. Your operation has been cancelled. SQL Error " + severityLevel + ".");
}
}
catch (Exception e)
{
DB.RollbackTransaction();
throw new Exception("Unknow error. Your operation has been cancelled.", e);
}
finally
{
DB.Close();
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// Load
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="companyId">companyId</param>
/// <para>Load Original table to process data for Project Costing report without filters </para>
public void Load(int projectId, int companyId)
{
// Initialization of Gateways
ProjectGateway projectGateway = new ProjectGateway(Data);
projectGateway.LoadByProjectId(projectId);
int companiesId = (int)projectGateway.GetClientID(projectId);
ProjectJobInfoGateway projectJobInfoGateway = new ProjectJobInfoGateway(Data);
projectJobInfoGateway.LoadAllByProjectId(projectId);
ProjectSaleBillingPricingGateway projectSaleBillingPricingGateway = new ProjectSaleBillingPricingGateway(Data);
projectSaleBillingPricingGateway.LoadAllByProjectId(projectId);
ProjectTechnicalGateway projectTechnicalGateway = new ProjectTechnicalGateway(Data);
projectTechnicalGateway.LoadByProjectId(projectId);
ProjectTermsPOGateway projectTermsPOGateway = new ProjectTermsPOGateway(Data);
projectTermsPOGateway.LoadByProjectId(projectId);
ProjectSubcontractorGateway projectSubcontractorGateway = new ProjectSubcontractorGateway(Data);
projectSubcontractorGateway.LoadByProjectId(projectId);
ProjectEngineerSubcontractorsGateway projectEngineerSubcontractorsGateway = new ProjectEngineerSubcontractorsGateway(Data);
projectEngineerSubcontractorsGateway.LoadAllByProjectId(projectId);
ProjectHistoryGateway projectHistoryGateway = new ProjectHistoryGateway(Data);
projectHistoryGateway.LoadFirstRow(projectId);
ProjectNotesGateway projectNoteGateway = new ProjectNotesGateway(Data);
projectNoteGateway.LoadByProjectId(projectId);
ProjectServiceGateway projectServiceGateway = new ProjectServiceGateway(Data);
projectServiceGateway.LoadByProjectId(projectId);
// For Updates
// ...Get the loginId for submitted field at report
// ...Update LFS_PROJECT
this.UpdateForReport(projectId, companiesId, projectGateway.GetSalesmanID(projectId), (projectGateway.GetProjectLeadID(projectId)).GetValueOrDefault(), companyId);
// ...Update LFS_PROJECT_ENGINEER_SUBCONTRACTOR
ProjectSynopsisEngineerSubcontractors projectSynopsisEngineerSubcontractors = new ProjectSynopsisEngineerSubcontractors(Data);
if (projectSynopsisEngineerSubcontractors.Table.Rows.Count > 0)
{
projectSynopsisEngineerSubcontractors.UpdateForReport(projectId, companiesId, companyId);
}
// ...Update LFS_PROJECT_SUBCONTRACTOR
ProjectSynopsisSubcontractor projectSynopsisSubcontractor = new ProjectSynopsisSubcontractor(Data);
if (projectSynopsisSubcontractor.Table.Rows.Count > 0)
{
projectSynopsisSubcontractor.UpdateForReport(projectId, companiesId, companyId);
}
// ...Update LFS_PROJECT_NOTE
ProjectSynopsisNote projectSynopsisNote = new ProjectSynopsisNote(Data);
if (projectSynopsisNote.Table.Rows.Count > 0)
{
projectSynopsisNote.UpdateForReport(projectId, companyId);
}
// ...Update LFS_PROJECT_SERVICE and Total Average Price
ProjectSynopsisService projectSynopsisService = new ProjectSynopsisService(Data);
if (projectSynopsisService.Table.Rows.Count > 0)
{
ProjectSynopsisReportTDS.LFS_PROJECTRow rowTotalAveragePrice = ((ProjectSynopsisReportTDS.LFS_PROJECTDataTable)Table).FindByProjectID(projectId);
rowTotalAveragePrice.TotalAveragePrice = projectSynopsisService.UpdateForReport(projectId, companyId);
}
}
// ////////////////////////////////////////////////////////////////////////
// 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["state"] == null) || ((string)Request.QueryString["project_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in project_state.aspx");
}
// Tag page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfProjectId.Value = Request.QueryString["project_id"];
// If coming from project_summary.aspx
if ((string)Request.QueryString["source_page"] == "project_summary.aspx")
{
// Store Navigator State and Update control
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Get project record
projectTDS = (ProjectTDS)Session["lfsProjectTDS"];
ProjectHistoryGateway projectHistoryGateway = new ProjectHistoryGateway(projectTDS);
projectHistoryGateway.LoadByProjectId(int.Parse(hdfProjectId.Value));
// Store datasets
Session["lfsProjectTDS"] = projectTDS;
}
// Restore dataset
projectTDS = (ProjectTDS)Session["lfsProjectTDS"];
// Prepare initial data
// ... for project
int currentProjectId = Int32.Parse(hdfProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
if (name.Length > 23) name = name.Substring(0, 20) + "...";
lblTitleProjectName.Text = name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
// ... for client
int currentClientId = projectGateway.GetClientID(Int32.Parse(hdfProjectId.Value.ToString()));
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadAllByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// for employees
cbxlEmployee.DataBind();
}
else
{
// Restore dataset
projectTDS = (ProjectTDS)Session["lfsProjectTDS"];
}
}
private void UpdateDatabase()
{
try
{
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
projectGateway.Update();
ProjectHistoryGateway projectHistoryGateway = new ProjectHistoryGateway(projectTDS);
projectHistoryGateway.Update();
projectTDS.AcceptChanges();
Session["lfsProjectTDS"] = projectTDS;
}
catch (Exception ex)
{
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
