/// <summary>
/// GetFLAndRAHistory.
/// </summary>
/// <param name="companyId">companyId</param>
/// <param name="numberOfHistory">numberOfHistory</param>
/// <param name="enterString">enterString</param>
/// <returns>a string with all historys separeted with the enterString</returns>
public string GetJLOrFLOrRAHistory(int companyId, int numberOfHistory, string enterString)
{
string history = "";
foreach (FlatSectionJlTDS.AllHistoryRow row in (FlatSectionJlTDS.AllHistoryDataTable)Table)
{
// ... Get user name
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadAllByLoginId(row.UserID, row.COMPANY_ID);
string user = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID);
// ... Form the history string
string rowHistory = ""; if (!row.IsHistoryNull()) rowHistory = row.History; else rowHistory = "( None )";
history = history + row.DateTime_ + " (" + user.Trim() + ")";
if (!row.IsWorkTypeNull()) history = history + ", Created At: " + row.WorkType;
history = history + ", Type: " + row.Type;
history = history + ", Subject: " + row.Subject + enterString;
history = history + "Comment: " + rowHistory;
// Insert enter when correspond
if (numberOfHistory > 1)
{
history = history + enterString + enterString;
numberOfHistory--;
}
}
return (history);
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
PlLiningPlanTDS prLiningPlanTDS = (PlLiningPlanTDS)Session["prLiningPlanTDS"];
PrLiningPlan prLiningPlan = new PrLiningPlan();
prLiningPlan.ProcessForReport(prLiningPlanTDS);
// ... set properties to master page
master.Data = prLiningPlan.Data;
master.Table = prLiningPlan.TableName;
// Get report
if (prLiningPlan.Table.Rows.Count > 0)
{
master.Report = new PrLiningPlanReport();
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
master.SetParameter("name", Request.QueryString["name"]);
}
}
/// <summary>
/// GetAllRehabAssessmentComments.
/// </summary>
/// <param name="workId">workId</param>
/// <param name="companyId">companyId</param>
/// <param name="numberOfComments">numberOfComments</param>
/// <param name="enterString">enterString</param>
/// <returns>a string with all comments separeted with the enterString</returns>
public string GetAllRehabAssessmentComments(int workId, int companyId, int numberOfComments, string enterString)
{
string comment = "";
foreach (RehabAssessmentTDS.CommentDetailsRow row in (RehabAssessmentTDS.CommentDetailsDataTable)Table)
{
if ((row.WorkID == workId) && (row.COMPANY_ID == companyId) && (!row.Deleted))
{
// ... Get user name
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadAllByLoginId(row.UserID, companyId);
string user = loginGateway.GetLastName(row.UserID, companyId) + " " + loginGateway.GetFirstName(row.UserID, companyId);
// ... Form the comment string
string rowComment = ""; if (!row.IsCommentNull()) rowComment = row.Comment; else rowComment = "( None )";
comment = comment + row.DateTime_ + " (" + user.Trim() + ")";
if (!row.IsWorkTypeNull()) comment = comment + ", Created At: " + row.WorkType;
comment = comment + ", Type: " + row.Type ;
comment = comment + ", Subject: " + row.Subject + enterString;
comment = comment + "Comment: " + rowComment;
}
// Insert enter when correspond
if (numberOfComments > 1)
{
comment = comment + enterString + enterString;
numberOfComments--;
}
}
return (comment);
}
/// <summary>
/// GetAllHistory.
/// </summary>
/// <param name="id">id</param>
/// <param name="refId">refId</param>
/// <param name="companyId">companyId</param>
/// <param name="numberOfComments">numberOfComments</param>
/// <param name="enterString">enterString</param>
/// <returns>a string with all comments at history separeted with the enterString</returns>
public string GetAllHistory(Guid id, int refId, int companyId, int numberOfComments, string enterString)
{
string history = "";
foreach (FlatSectionJlinerTDS.JuntionLiner2HistoryRow row in (FlatSectionJlinerTDS.JuntionLiner2HistoryDataTable)Table)
{
if ((row.ID == id) && (row.RefID == refId) && (row.COMPANY_ID == companyId))
{
// ... Get user name
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(row.LoginID, companyId);
string user = loginGateway.GetLastName(row.LoginID, companyId) + " " + loginGateway.GetFirstName(row.LoginID, companyId);
// ... Form the comment string
history = history + row.DateTime_ + " ( " + user.Trim() + " )" + enterString + row.History;
}
// Insert enter when correspond
if (numberOfComments > 1)
{
history = history + enterString + enterString;
numberOfComments--;
}
}
return (history);
}
/// <summary>
/// GetFLAndRAComments.
/// </summary>
/// <param name="companyId">companyId</param>
/// <param name="numberOfComments">numberOfComments</param>
/// <param name="enterString">enterString</param>
/// <returns>a string with all comments separeted with the enterString</returns>
public string GetFLOrRAComments(int companyId, int numberOfComments, string enterString)
{
string comment = "";
foreach (FullLengthLiningTDS.AllCommentsRow row in (FullLengthLiningTDS.AllCommentsDataTable)Table)
{
// ... Get user name
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadAllByLoginId(row.UserID, row.COMPANY_ID);
string user = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID);
// ... Form the comment string
string rowComment = ""; if (!row.IsCommentNull()) rowComment = row.Comment; else rowComment = "( None )";
comment = comment + row.DateTime_ + " (" + user.Trim() + ")";
if (!row.IsWorkTypeNull()) comment = comment + ", Created At: " + row.WorkType;
comment = comment + ", Type: " + row.Type;
comment = comment + ", Subject: " + row.Subject + enterString;
comment = comment + "Comment: " + rowComment;
// Insert enter when correspond
if (numberOfComments > 1)
{
comment = comment + enterString + enterString;
numberOfComments--;
}
}
return (comment);
}
/// <summary>
/// GetAllProjectNotes.
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="companyId">companyId</param>
/// <param name="numberOfNotes">numberOfNotes</param>
/// <param name="enterString">enterString</param>
/// <returns>a string with all Notes separeted with the enterString</returns>
public string GetAllProjectNotes(int projectId, int companyId, int numberOfNotes, string enterString)
{
string note = "";
foreach (ProjectTDS.LFS_PROJECT_NOTERow row in (ProjectTDS.LFS_PROJECT_NOTEDataTable)Table)
{
if ((row.ProjectID == projectId) && (row.COMPANY_ID == companyId) && (!row.Deleted))
{
// ... Get user name
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadAllByLoginId(row.LoginID, companyId);
string user = loginGateway.GetLastName(row.LoginID, companyId) + " " + loginGateway.GetFirstName(row.LoginID, companyId);
// ... Form the note string
string rowNote = ""; if (!row.IsNoteNull()) rowNote = row.Note; else rowNote = "( None )";
note = note + row.DateTime + " (" + user.Trim() + ")";
note = note + ", Subject: " + row.Subject + enterString;
note = note + "note: " + rowNote;
// Insert enter when correspond
if (numberOfNotes > 1)
{
note = note + enterString + enterString;
numberOfNotes--;
}
}
}
return (note);
}
/// <summary>
/// GetAllNotes.
/// </summary>
/// <param name="materialId">materialId</param>
/// <param name="companyId">COMPANY_UD</param>
/// <param name="numberOfNotes">numberOfNotes</param>
/// <param name="enterString">enterString</param>
/// <returns>a string with all comments at history separeted with the enterString</returns>
public string GetAllNotes(int materialId, int companyId, int numberOfNotes, string enterString)
{
string note = "";
foreach (MaterialsInformationTDS.NoteInformationRow row in (MaterialsInformationTDS.NoteInformationDataTable)Table)
{
if ((row.MaterialID == materialId) && (row.COMPANY_ID == companyId))
{
// ... Get user name
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(row.UserID, row.COMPANY_ID);
string user = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID);
// ... Form the comment string
note = note + row.DateTime_ + " ( " + user.Trim() + " )" + enterString + row.Note;
}
// Insert enter when correspond
if (numberOfNotes > 1)
{
note = note + enterString + enterString;
numberOfNotes--;
}
}
return (note);
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
SubcontractorHoursNavigatorTDS subcontractorHoursNavigatorTDS = (SubcontractorHoursNavigatorTDS)Session["subcontractorHoursNavigatorTDS"];
LiquiForce.LFSLive.BL.LabourHours.SubcontractorHours.SubcontractorHoursNavigator subcontractorHoursNavigator = new LiquiForce.LFSLive.BL.LabourHours.SubcontractorHours.SubcontractorHoursNavigator(subcontractorHoursNavigatorTDS);
// ... Set properties to master page
master.Data = subcontractorHoursNavigator.Data;
master.Table = subcontractorHoursNavigator.TableName;
if (subcontractorHoursNavigator.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.SubcontractorHours.SubcontractorHoursPrintSearchResultsReport();
LoginGateway loginGateway = new LoginGateway();
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// Report format
master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
master.Report.PrintOptions.PaperSize = PaperSize.PaperLegal;
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.SubcontractorHours.SubcontractorHoursPrintSearchResultsReportExport();
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
RevenueNavigatorTDS revenueNavigatorTDS = (RevenueNavigatorTDS)Session["revenueNavigatorTDS"];
LiquiForce.LFSLive.BL.Projects.Revenue.RevenueNavigator revenueNavigator = new LiquiForce.LFSLive.BL.Projects.Revenue.RevenueNavigator(revenueNavigatorTDS);
// ... Set properties to master page
master.Data = revenueNavigator.Data;
master.Table = revenueNavigator.TableName;
if (revenueNavigator.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Revenue.RevenuePrintSearchResultsReport();
// ... Parameters
int j;
for (int i = 0; i < int.Parse(Request.QueryString["totalColumnsPreview"]); i++)
{
j = i + 1;
master.SetParameter("header" + j, Request.QueryString["header" + j]);
}
master.SetParameter("headerComments", Request.QueryString["comments"]);
master.SetParameter("Title", Request.QueryString["title"]);
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// Report format
master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
master.Report.PrintOptions.PaperSize = PaperSize.PaperLegal;
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.Projects.Revenue.RevenuePrintSearchResultsReportExport();
// ... Parameters
int j;
for (int i = 0; i < int.Parse(Request.QueryString["totalColumnsExport"]); i++)
{
j = i + 1;
master.SetParameter("header" + j, Request.QueryString["header" + j]);
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Get user data
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Int32.Parse(Session["companyID"].ToString());
LoginGateway loginGateway = new LoginGateway(new DataSet());
loginGateway.LoadByLoginId(loginId, companyId);
string userName = loginGateway.GetUserName(loginId, companyId);
string userMail = loginGateway.GetEmail(loginId, companyId);
string password = loginGateway.GetPassword(loginId, companyId);
// Fomat new pass
string newPassword = password;
if (password.Length <= 7)
{
for (int i = password.Length; i <= 7; i++)
{
newPassword = newPassword + "!";
}
}
else
{
newPassword = newPassword + "!";
}
// Verify pass, if not a valid user create one
if (!(Membership.ValidateUser(userName, newPassword)))
{
MembershipCreateStatus createStatus;
Membership.CreateUser(userName, newPassword, userMail, "Password question", "password answer", true, out createStatus);
}
FormsAuthentication.RedirectFromLoginPage(userName, false);
if (Convert.ToBoolean(Session["sgLFS_ITTST_SUPPORTTICKET_ADMIN"]))
{
Response.Redirect(".//dashboardManager.aspx?source_page=out");
}
else
{
Response.Redirect(".//dashboard.aspx?source_page=out");
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// UpdateForReport
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="companyId">companyId</param>
public void UpdateForReport(int projectId, int companyId)
{
// For LFS_PROJECT_NOTE
// ... for Writer Name
foreach (ProjectSynopsisReportTDS.LFS_PROJECT_NOTERow row in this.Table.Rows)
{
if (row.ProjectID == projectId)
{
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadAllByLoginId(Convert.ToInt32(row.LoginID), companyId);
try
{
row.WrittenBy = loginGateway.GetLastName(Convert.ToInt32(row.LoginID), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(row.LoginID), companyId);
}
catch
{
row.WrittenBy = "";
}
}
}
}
/// <summary>
/// UpdateForProcess. Update the author of each comment
/// </summary>
public void UpdateForProcess()
{
LoginGateway loginGateway = new LoginGateway();
foreach (RehabAssessmentTDS.CommentDetailsRow row in (RehabAssessmentTDS.CommentDetailsDataTable)Table)
{
loginGateway.LoadByLoginId(row.UserID, row.COMPANY_ID);
row.UserFullName = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID);
}
}
private void GrdCommentsAdd()
{
if (ValidateCommentsFooter())
{
Page.Validate("commentsDataAdd");
if (Page.IsValid)
{
int workId = Int32.Parse(hdfWorkId.Value);
int workIdFll = Int32.Parse(hdfWorkIdFll.Value.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value);
int loginId = Convert.ToInt32(Session["loginID"]);
DateTime dateTime_ = DateTime.Now;
bool inDatabase = false;
bool toHistory = false;
bool deleted = false;
string workType = hdfWorkType.Value;
string newSubject = ((TextBox)grdComments.FooterRow.FindControl("tbxSubjectNew")).Text.Trim();
string newType = ((DropDownList)grdComments.FooterRow.FindControl("ddlTypeNew")).SelectedValue.ToString().Trim();
string newComment = ((TextBox)grdComments.FooterRow.FindControl("tbxCommentsNew")).Text.Trim();
int? libraryFilesId = null; if (((Label)grdComments.FooterRow.FindControl("lblLIBRARY_FILES_IDNew")).Text != "") libraryFilesId = Int32.Parse(((Label)grdComments.FooterRow.FindControl("lblLIBRARY_FILES_IDNew")).Text.Trim());
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string userFullName = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
if (newType == "Rehab Assessment")
{
RehabAssessmentCommentDetails model = new RehabAssessmentCommentDetails(rehabAssessmentTDS);
model.Insert(workId, newType, newSubject, loginId, dateTime_, newComment, libraryFilesId, deleted, companyId, inDatabase, userFullName, toHistory, workType);
}
else
{
if (workIdFll != 0)
{
RehabAssessmentCommentDetails model = new RehabAssessmentCommentDetails(rehabAssessmentTDS);
model.Insert(workIdFll, newType, newSubject, loginId, dateTime_, newComment, libraryFilesId, deleted, companyId, inDatabase, userFullName, toHistory, workType);
}
}
Session.Remove("rehabAssessmentCommentDetailsDummy");
Session["rehabAssessmentTDS"] = rehabAssessmentTDS;
Session["rehabAssessmentCommentDetails"] = rehabAssessmentTDS.CommentDetails;
grdComments.DataBind();
grdComments.PageIndex = grdComments.PageCount - 1;
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlOutstandingInvestigationIssuesReport flOutstandingInvestigationIssuesReport = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlOutstandingInvestigationIssuesReport();
if (ddlClient.SelectedValue == "-1")
{
flOutstandingInvestigationIssuesReport.Load(int.Parse(hdfCompanyId.Value));
}
else
{
if (ddlProject.SelectedValue == "-1")
{
flOutstandingInvestigationIssuesReport.LoadByCompaniesId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue));
}
else
{
flOutstandingInvestigationIssuesReport.LoadByCompaniesIdProjectId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue));
}
}
// ... set properties to master page
master.Data = flOutstandingInvestigationIssuesReport.Data;
master.Table = flOutstandingInvestigationIssuesReport.TableName;
// Get report
if (flOutstandingInvestigationIssuesReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new FlOutstandingInvestigationIssuesReport();
}
else
{
master.Report = new FlOutstandingInvestigationIssuesReportExport();
}
// ... set parameters to report
int companyId = Convert.ToInt32(Session["companyID"]);
if (master.Format == "pdf")
{
if (ddlClient.SelectedValue != "-1")
{
// ... for client
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter("Client", "All");
}
if (ddlProject.SelectedValue != "-1")
{
// ... for project
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", name);
}
else
{
master.SetParameter("Project", "All");
}
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
}
}
}
private void Generate2()
{
mReportForM12 master = (mReportForM12)this.Master;
string unitType = ddlUnitType.SelectedValue;
// Get Data
LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM2Report flM2Report = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM2Report();
if (ddlClient.SelectedValue == "-1")
{
if (cbxSectionId.Checked)
{
ArrayList sectionsId = new ArrayList();
foreach (ListItem lst in cbxlSectionId.Items)
{
if (lst.Selected)
{
sectionsId.Add(lst.Value);
}
}
flM2Report.LoadBySectionId(int.Parse(hdfCompanyId.Value), sectionsId, unitType);
}
else
{
if (cbxDate.Checked)
{
DateTime m1Date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString());
flM2Report.LoadByDate(int.Parse(hdfCompanyId.Value), m1Date.ToShortDateString(), unitType);
}
else
{
if (cbxStreet.Checked)
{
flM2Report.LoadByStreet(int.Parse(hdfCompanyId.Value), tbxStreet.Text.Trim(), unitType);
}
else
{
if (cbxSubArea.Checked)
{
flM2Report.LoadBySubArea(int.Parse(hdfCompanyId.Value), tbxSubArea.Text.Trim(), unitType);
}
else
{
flM2Report.Load(int.Parse(hdfCompanyId.Value), unitType);
}
}
}
}
}
else
{
if (ddlProject.SelectedValue == "-1")
{
if (cbxSectionId.Checked)
{
ArrayList sectionsId = new ArrayList();
foreach (ListItem lst in cbxlSectionId.Items)
{
if (lst.Selected)
{
sectionsId.Add(lst.Value);
}
}
flM2Report.LoadByCompaniesIdSectionId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, sectionsId);
}
else
{
if (cbxDate.Checked)
{
DateTime m1Date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString());
flM2Report.LoadByCompaniesIdDate(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, m1Date.ToShortDateString());
}
else
{
if (cbxStreet.Checked)
{
flM2Report.LoadByCompaniesIdStreet(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, tbxStreet.Text.Trim());
}
else
{
if (cbxSubArea.Checked)
{
flM2Report.LoadByCompaniesIdSubArea(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType, tbxSubArea.Text.Trim());
}
else
{
flM2Report.LoadByCompaniesId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), unitType);
}
}
}
}
}
else
{
if (cbxSectionId.Checked)
{
ArrayList sectionsId = new ArrayList();
foreach (ListItem lst in cbxlSectionId.Items)
{
if (lst.Selected)
{
sectionsId.Add(lst.Value);
}
}
flM2Report.LoadByCompaniesIdProjectIdSectionId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, sectionsId);
}
else
{
if (cbxDate.Checked)
{
DateTime m1Date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString());
flM2Report.LoadByCompaniesIdProjectIdDate(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, m1Date.ToShortDateString());
}
else
{
if (cbxStreet.Checked)
{
flM2Report.LoadByCompaniesIdProjectIdStreet(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, tbxStreet.Text.Trim());
}
else
{
if (cbxSubArea.Checked)
{
flM2Report.LoadByCompaniesIdProjectIdSubArea(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType, tbxSubArea.Text.Trim());
}
else
{
flM2Report.LoadByCompaniesIdProjectId(int.Parse(hdfCompanyId.Value), int.Parse(ddlClient.SelectedValue), int.Parse(ddlProject.SelectedValue), unitType);
}
}
}
}
}
}
// ... set properties to master page
master.Data2 = flM2Report.Data;
master.Table2 = flM2Report.TableName;
// Get report
if (flM2Report.Table.Rows.Count > 0)
{
if (master.Format2 == "pdf")
{
master.Report2 = new FlM2Report();
}
else
{
master.Report2 = new FlM2ReportExport();
}
// ... set parameters to report
int companyId = Convert.ToInt32(Session["companyID"]);
if (master.Format2 == "pdf")
{
if (ddlClient.SelectedValue != "-1")
{
// ... for client
int currentCompanyId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentCompanyId, companyId);
master.SetParameter2("Client", companiesGateway.GetName(currentCompanyId));
}
else
{
master.SetParameter2("Client", "All");
}
if (ddlProject.SelectedValue != "-1")
{
// ... for project
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter2("Project", name);
}
else
{
master.SetParameter2("Project", "All");
}
master.SetParameter2("UnitType", unitType);
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter2("User", user.Trim());
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
int companyId = Convert.ToInt32(Session["companyID"]);
string type = Request.QueryString["type"].ToString();
int costingSheetId = 0;
int projectId = 0;
ProjectCostingSheetInformationBasicInformation projectCostingSheetInformationBasicInformation = new ProjectCostingSheetInformationBasicInformation();
if (ddlCostingSheets.SelectedValue != "-1")
{
// Get Data
costingSheetId = Convert.ToInt32(ddlCostingSheets.SelectedValue);
projectCostingSheetInformationBasicInformation.LoadByCostingSheetIdForPreviewReport(costingSheetId, companyId);
ProjectCostingSheetInformationBasicInformationGateway projectCostingSheetInformationBasicInformationGateway = new ProjectCostingSheetInformationBasicInformationGateway(projectCostingSheetInformationBasicInformation.Data);
projectId = projectCostingSheetInformationBasicInformationGateway.GetProjectID(costingSheetId);
// ... set properties to master page
master.Data = projectCostingSheetInformationBasicInformation.Data;
master.Table = projectCostingSheetInformationBasicInformation.TableName;
master.Report = new ProjectCostingSheetsPreview();
// Get report
if (projectCostingSheetInformationBasicInformation.Table.Rows.Count > 0)
{
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
int clientId = projectGateway.GetClientID(projectId);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(clientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(clientId));
string name = projectGateway.GetName(projectId);
master.SetParameter("Project", name);
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
master.SetParameter("CostingSheet", projectCostingSheetInformationBasicInformationGateway.GetName(costingSheetId));
if (type == "resume")
{
((Section)master.Report.ReportDefinition.Sections["detailsLabourHours"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsLabourHours2"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsUnits"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsUnits2"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsMaterials"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsMaterials2"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts2"]).SectionFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors"]).SectionFormat.EnableSuppress = true;
//((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors2"]).SectionFormat.EnableSuppress = true;
}
else
{
((Section)master.Report.ReportDefinition.Sections["detailsLabourHours"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsLabourHours2"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsUnits"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsUnits2"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsMaterials"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsMaterials2"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsOtherCosts2"]).SectionFormat.EnableSuppress = false;
((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors"]).SectionFormat.EnableSuppress = false;
//((Section)master.Report.ReportDefinition.Sections["detailsSubcontractors2"]).SectionFormat.EnableSuppress = false;
}
if (projectGateway.GetCountryID(projectId) == 1)//Canada
{
// General
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text32"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text34"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text36"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text38"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["headerTotalSubcontractorsUsd"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalLabourHoursUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalUnitsUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalMaterialsUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalOtherCostsUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["GrandTotalUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalSubcontractorsUsd1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["GrandTotalUsd2"].ObjectFormat.EnableSuppress = true;
// Labour Hours
ReportDocument rpLabourHoursDetails = master.Report.OpenSubreport("LabourHoursDetails");
ReportDocument rpLabourHoursResume = master.Report.OpenSubreport("LabourHoursResume");
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["LHCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
//
((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
// Units
ReportDocument rpUnitsDetails = master.Report.OpenSubreport("UnitsDetails");
ReportDocument rpUnitsResume = master.Report.OpenSubreport("UnitsResume");
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
//
((Section)rpUnitsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
// Materials
ReportDocument rpMaterialsDetails = master.Report.OpenSubreport("MaterialsDetails");
ReportDocument rpMaterialsResune = master.Report.OpenSubreport("MaterialsResume");
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
///
((Section)rpMaterialsResune.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsResune.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsResune.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
// Subcontractors
ReportDocument rpSubcontractorsDetails = master.Report.OpenSubreport("SubcontractorsDetails");
//ReportDocument rpSubcontractorsResune = master.Report.OpenSubreport("SubcontractorsResume");
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
///
//((Section)rpSubcontractorsResune.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
//((Section)rpSubcontractorsResune.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
//((Section)rpSubcontractorsResune.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
// Other Costs
ReportDocument rpOtherCostsDetails = master.Report.OpenSubreport("OtherCostsDetails");
ReportDocument rpOtherCostsResume = master.Report.OpenSubreport("OtherCostsResume");
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text3"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text2"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
///
((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostUsd1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostUsd2"].ObjectFormat.EnableSuppress = true;
}
else//USA
{
// General
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text31"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text33"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text35"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text37"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["Text1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupHeaderSection1"]).ReportObjects["headerTotalSubcontractorsCad"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalLabourHoursCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalUnitsCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalMaterialsCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalOtherCostsCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["GrandTotalCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["Section3"]).ReportObjects["TotalSubcontractorsCad1"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)master.Report.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["GrandTotalCad2"].ObjectFormat.EnableSuppress = true;
// Labour Hours
ReportDocument rpLabourHoursDetails = master.Report.OpenSubreport("LabourHoursDetails");
ReportDocument rpLabourHoursResume = master.Report.OpenSubreport("LabourHoursResume");
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text9"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text6"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["LHCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
//
((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpLabourHoursResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
// Units
ReportDocument rpUnitsDetails = master.Report.OpenSubreport("UnitsDetails");
ReportDocument rpUnitsResume = master.Report.OpenSubreport("UnitsResume");
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
//
((Section)rpUnitsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpUnitsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
// Materials
ReportDocument rpMaterialsDetails = master.Report.OpenSubreport("MaterialsDetails");
ReportDocument rpMaterialsResune = master.Report.OpenSubreport("MaterialsResume");
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
///
((Section)rpMaterialsResune.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsResune.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpMaterialsResune.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
// Subcontractors
ReportDocument rpSubcontractorsDetails = master.Report.OpenSubreport("SubcontractorsDetails");
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpSubcontractorsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
// Other Costs
ReportDocument rpOtherCostsDetails = master.Report.OpenSubreport("OtherCostsDetails");
ReportDocument rpOtherCostsResume = master.Report.OpenSubreport("OtherCostsResume");
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text5"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["CostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["DetailSection1"]).ReportObjects["TotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsDetails.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
///
((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportHeaderSection2"]).ReportObjects["Text4"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsResume.ReportDefinition.Sections["GroupFooterSection1"]).ReportObjects["SumofTotalCostCad1"].ObjectFormat.EnableSuppress = true;
((Section)rpOtherCostsResume.ReportDefinition.Sections["ReportFooterSection1"]).ReportObjects["SumofTotalCostCad2"].ObjectFormat.EnableSuppress = true;
}
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
PrintUnnapprovedProjectTimes printUnnapprovedProjectTimes = new PrintUnnapprovedProjectTimes();
if (ddlCountry.SelectedValue == "-1")
{
printUnnapprovedProjectTimes.LoadByStartDateEndDate(startDate, endDate);
}
else
{
printUnnapprovedProjectTimes.LoadByStartDateEndDateCountryId(startDate, endDate, int.Parse(ddlCountry.SelectedValue));
}
// ... set properties to master page
master.Data = printUnnapprovedProjectTimes.Data;
master.Table = printUnnapprovedProjectTimes.TableName;
// Get report
if (printUnnapprovedProjectTimes.Table.Rows.Count > 0)
{
// ... set parameters to report
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintUnapprovedProjectTimesReport();
// ... For report
// ... ... country
if (ddlCountry.SelectedValue == "2")
{
master.SetParameter("Country", "USA");
}
else
{
if (ddlCountry.SelectedValue == "1")
{
master.SetParameter("Country", "Canada");
}
else
{
master.SetParameter("Country", "All");
}
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintUnapprovedProjectTimesReportExport();
}
}
}
/// <summary>
/// GetAllComments.
/// </summary>
/// <param name="workId">workId</param>
/// <param name="companyId">companyId</param>
/// <param name="numberOfComments">numberOfComments</param>
/// <param name="enterString">enterString</param>
/// <returns>a string with all comments separeted with the enterString</returns>
public string GetAllHistory(int workId, int companyId, int numberOfHistory, string enterString)
{
string history = "";
foreach (WorkTDS.LFS_WORK_HISTORYRow row in (WorkTDS.LFS_WORK_HISTORYDataTable)Table)
{
if ((row.WorkID == workId) && (row.COMPANY_ID == companyId))
{
// ... Get user name
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadAllByLoginId(row.UserID, companyId);
string user = loginGateway.GetLastName(row.UserID, companyId) + " " + loginGateway.GetFirstName(row.UserID, companyId);
// ... Form the comment string
string rowHistory = ""; if (!row.IsHistoryNull()) rowHistory = row.History; else rowHistory = "( None )";
history = history + row.DateTime_ + " (" + user.Trim() + ")";
if (!row.IsWorkTypeNull()) history = history + ", Created At: " + row.WorkType;
history = history + ", Type: " + row.Type;
history = history + ", Subject: " + row.Subject + enterString;
history = history + "Comment: " + rowHistory;
}
// Insert enter when correspond
if (numberOfHistory > 1)
{
history = history + enterString + enterString;
numberOfHistory--;
}
}
return (history);
}
/// <summary>
/// UpdateForProcess. Update the author, and date of each comment at history
/// </summary>
public void UpdateForProcess()
{
LoginGateway loginGateway = new LoginGateway();
foreach (SectionTDS.LFS_JUNCTION_LINER2_HISTORYRow row in (SectionTDS.LFS_JUNCTION_LINER2_HISTORYDataTable)Table)
{
loginGateway.LoadByLoginId(row.LoginID, row.COMPANY_ID);
row.UserFullName = loginGateway.GetLastName(row.LoginID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.LoginID, row.COMPANY_ID);
row.CreationDateTime = row.DateTime_.ToString();
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
int companyId = Convert.ToInt32(Session["companyID"]);
ProjectCostingSheetInformationReportInformation projectCostingSheetInformationReportInformation = new ProjectCostingSheetInformationReportInformation();
if (ddlClient.SelectedValue == "-1")
{
projectCostingSheetInformationReportInformation.Load(companyId);
}
else
{
if (ddlProject.SelectedValue == "-1")
{
projectCostingSheetInformationReportInformation.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), companyId);
}
else
{
projectCostingSheetInformationReportInformation.LoadByCompaniesIdProjectId(Int32.Parse(ddlClient.SelectedValue), Int32.Parse(ddlProject.SelectedValue), companyId);
}
}
// ... set properties to master page
master.Data = projectCostingSheetInformationReportInformation.Data;
master.Table = projectCostingSheetInformationReportInformation.TableName;
// Get report
if (projectCostingSheetInformationReportInformation.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new ConsolidatedCostingSheetReport();
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// For process code
ProjectCostingSheetInformationReportInformationGateway projectCostingSheetInformationReportInformationGateway = new ProjectCostingSheetInformationReportInformationGateway(projectCostingSheetInformationReportInformation.Data);
// ... ... client
if (ddlClient.SelectedValue == "-1")
{
master.SetParameter("client", "All");
}
else
{
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), Int32.Parse(hdfCompanyId.Value));
string clientName = companiesGateway.GetName(Int32.Parse(ddlClient.SelectedValue));
master.SetParameter("client", clientName);
}
// ... ... project
if (ddlProject.SelectedValue == "-1")
{
master.SetParameter("project", "All");
}
else
{
int projectId2 = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId2);
string project = projectGateway.GetName(projectId2);
master.SetParameter("project", project);
}
}
else
{
master.Report = new ConsolidatedCostingSheetPreviewReport();
}
}
}
private void Generate3()
{
mReportForM12 master = (mReportForM12)this.Master;
string unitType = ddlUnitType.SelectedValue;
int companyId = Convert.ToInt32(hdfCompanyId.Value);
FlM1ReportTDS flM1ReportTDS = new FlM1ReportTDS();
// Get Data
LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM1Report flM1Report = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM1Report(flM1ReportTDS);
LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM12Report flM2Report = new LiquiForce.LFSLive.BL.CWP.FullLengthLining.FlM12Report(flM1ReportTDS);
GetM1Data(flM1Report, unitType, companyId);
GetM2Data(flM2Report, unitType);
// ... set properties to master page
//FlM1ReportTDS dataSet = new FlM1ReportTDS();
//dataSet.M1ReportByClient.Merge(flM1Report, true);
//dataSet.M2_SECTION.Merge(flM2Report, true);
master.Data3 = flM1ReportTDS;
master.Table1 = flM1Report.TableName;
master.Table2 = flM2Report.TableName;
// Get report
if (flM2Report.Table.Rows.Count > 0 || flM1Report.Table.Rows.Count > 0)
{
if (master.Format3 == "pdf")
{
master.Report3 = new FlM12Report();
if (ddlClient.SelectedValue != "-1")
{
// ... for client
int currentClientId = Int32.Parse(ddlClient.SelectedValue);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter3("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter3("Client", "All");
}
if (ddlProject.SelectedValue != "-1")
{
// ... for project
int currentProjectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter3("Project", name);
}
else
{
master.SetParameter3("Project", "All");
}
master.SetParameter3("UnitType", unitType);
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter3("User", user.Trim());
}
else
{
//master.Report2 = new FlM12ReportExport();
}
}
}
/// <summary>
/// UpdateForProcess. Update the author of each comment
/// </summary>
public void UpdateForProcess()
{
LoginGateway loginGateway = new LoginGateway();
foreach (FlatSectionJlTDS.FlatSectionJlHistoryDetailsRow row in (FlatSectionJlTDS.FlatSectionJlHistoryDetailsDataTable)Table)
{
loginGateway.LoadByLoginId(row.UserID, row.COMPANY_ID);
row.UserFullName = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID);
}
}
// ////////////////////////////////////////////////////////////////////////
// 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["client_id"] == null) || ((string)Request.QueryString["project_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in project_notes.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfUpdate.Value = "yes";
// Prepare initial data
Session.Remove("projectNotesDummy");
// ... Names for UserList
int companyId = Int32.Parse(hdfCompanyId.Value);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(Convert.ToInt32(hdfLoginId.Value),companyId);
hdfCreatedBy.Value = loginGateway.GetLastName(Convert.ToInt32(hdfLoginId.Value), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(hdfLoginId.Value), companyId);
hdfCreationDateTime.Value = DateTime.Now.ToString();
// If coming from
// ... project_summary.aspx or project_edit.aspx
if (Request.QueryString["source_page"] == "project_summary.aspx" || Request.QueryString["source_page"] == "project_edit.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
projectNavigatorTDS = (ProjectNavigatorTDS)Session["projectNavigatorTDS"];
projectNotes = (ProjectNavigatorTDS.ProjectNotesDataTable)Session["projectNotes"];
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
// Get Notes
ProjectNavigatorProjectNotes projectNavigatorProjectNotes = new ProjectNavigatorProjectNotes(projectNavigatorTDS);
projectNavigatorProjectNotes.LoadAllByProjectId(currentProjectId);
// ... Store datasets
Session["projectNavigatorTDS"] = projectNavigatorTDS;
Session["projectNotes"] = projectNavigatorTDS.ProjectNotes;
}
}
else
{
// Restore datasets
projectNavigatorTDS = (ProjectNavigatorTDS)Session["projectNavigatorTDS"];
projectNotes = (ProjectNavigatorTDS.ProjectNotesDataTable)Session["projectNotes"];
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue;
DateTime date = DateTime.Parse(tkrdpDate.SelectedDate.Value.ToShortDateString());
Print3ChartReportGateway print3ChartReportGateway = new Print3ChartReportGateway();
print3ChartReportGateway.LoadByDateProjectTimeState(date, projectTimeState);
// ... set properties to master page
master.Data = print3ChartReportGateway.Data;
master.Table = print3ChartReportGateway.TableName;
// Get report
if (print3ChartReportGateway.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.Print3ChartReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.Print3ChartReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... project time state
if (ddlProjectTimeState.SelectedValue == "(All)")
{
master.SetParameter("projectTimeState", "All");
}
else
{
master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text);
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
// ... ... Date
master.SetParameter("date", tkrdpDate.SelectedDate.Value.ToShortDateString());
}
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
JlLiningPlanTDS jlLiningPlanTDS = (JlLiningPlanTDS)Session["jlLiningPlanTDS"];
JlLiningPlan jlLiningPlan = new JlLiningPlan();
jlLiningPlan.ProcessForReport(jlLiningPlanTDS);
// ... set properties to master page
master.Data = jlLiningPlan.Data;
master.Table = jlLiningPlan.TableName;
// Get report
if (jlLiningPlan.Table.Rows.Count > 0)
{
master.Report = new JlLiningPlanReport();
// ... for client
int companyId = Int32.Parse(Session["companyID"].ToString());
int currentClientId = Int32.Parse(hdfCurrentClientId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
master.SetParameter("Project", projectGateway.GetProjectNumber(currentProjectId));
int loginId = Convert.ToInt32(Session["loginID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
RaNavigatorTDS raNavigatorTDS = (RaNavigatorTDS)Session["raNavigatorTDS"];
LiquiForce.LFSLive.BL.CWP.RehabAssessment.RaNavigator raNavigator = new LiquiForce.LFSLive.BL.CWP.RehabAssessment.RaNavigator(raNavigatorTDS);
// ... set properties to master page
master.Data = raNavigator.Data;
master.Table = raNavigator.TableName;
if (raNavigator.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.CWP.RehabAssessment.RaPrintSearchResultsReport();
master.SetParameter("name", Server.UrlDecode(Request.QueryString["name"].ToString()));
master.SetParameter("Title", Server.UrlDecode(Request.QueryString["title"].ToString()));
// ... Parameters
int j;
for (int i = 0; i < int.Parse(Request.QueryString["totalColumnsPreview"]); i++)
{
j = i + 1;
master.SetParameter("header" + j, Request.QueryString["header" + j]);
}
master.SetParameter("headerComments", Request.QueryString["comments"]);
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
if (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 12)
{
((Section)master.Report.ReportDefinition.Sections["sDetail12columns"]).SectionFormat.EnableSuppress = false;
}
else
{
if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 12) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 24))
{
((Section)master.Report.ReportDefinition.Sections["sDetail24columns"]).SectionFormat.EnableSuppress = false;
}
else
{
if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 25) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 36))
{
((Section)master.Report.ReportDefinition.Sections["sDetail36columns"]).SectionFormat.EnableSuppress = false;
}
else
{
if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 36) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 48))
{
((Section)master.Report.ReportDefinition.Sections["sDetail48columns"]).SectionFormat.EnableSuppress = false;
}
else
{
if ((int.Parse(Request.QueryString["totalSelectedColumns"]) > 48) && (int.Parse(Request.QueryString["totalSelectedColumns"]) <= 60))
{
((Section)master.Report.ReportDefinition.Sections["sDetail60columns"]).SectionFormat.EnableSuppress = false;
}
}
}
}
}
// Report format
master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape;
master.Report.PrintOptions.PaperSize = PaperSize.PaperLegal;
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.CWP.RehabAssessment.RaPrintSearchResultsReportExport();
// ... Parameters
int j;
for (int i = 0; i < int.Parse(Request.QueryString["totalColumnsExport"]); i++)
{
j = i + 1;
master.SetParameter("header" + j, Request.QueryString["header" + j]);
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_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["client_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["work_id"] == null) || ((string)Request.QueryString["asset_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in ra_comments.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfAdminPermission.Value = Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_ADMIN"]).ToString();
hdfWorkType.Value = "Rehab Assessment";
hdfWorkId.Value = Request.QueryString["work_id"].ToString();
hdfAssetId.Value = Request.QueryString["asset_id"].ToString();
hdfUpdate.Value = "yes";
// Prepare initial data
Session.Remove("rehabAssessmentCommentDetailsDummy");
// ... Names for UserList
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(Convert.ToInt32(hdfLoginId.Value),companyId);
hdfCreatedBy.Value = loginGateway.GetLastName(Convert.ToInt32(hdfLoginId.Value), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(hdfLoginId.Value), companyId);
hdfCreationDateTime.Value = DateTime.Now.ToString();
// If coming from
// ... ra_summary.aspx or ra_edit.aspx
if (Request.QueryString["source_page"] == "ra_summary.aspx" || Request.QueryString["source_page"] == "ra_edit.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// For RA
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
int workId = Int32.Parse(hdfWorkId.Value.Trim());
if (workId != 0)
{
// ... update comments
RehabAssessmentCommentDetailsGateway rehabAssessmentCommentDetailsGateway = new RehabAssessmentCommentDetailsGateway(rehabAssessmentTDS);
rehabAssessmentCommentDetailsGateway.LoadAllByWorkIdWorkType(workId, companyId, workType);
RehabAssessmentCommentDetails rehabAssessmentCommentDetails = new RehabAssessmentCommentDetails(rehabAssessmentCommentDetailsGateway.Data);
rehabAssessmentCommentDetails.UpdateForProcess();
}
// For FLL
int workIdFll = GetWorkId(currentProjectId, assetId, "Full Length Lining", companyId);
hdfWorkIdFll.Value = workIdFll.ToString();
if (workIdFll != 0)
{
// ... update comments
FullLengthLiningCommentDetailsGateway fullLengthLiningCommentDetailsGateway = new FullLengthLiningCommentDetailsGateway();
fullLengthLiningCommentDetailsGateway.LoadAllByWorkIdWorkType(workIdFll, companyId, "Full Length Lining");
FullLengthLiningCommentDetails fullLengthLiningCommentDetails = new FullLengthLiningCommentDetails(fullLengthLiningCommentDetailsGateway.Data);
fullLengthLiningCommentDetails.UpdateForProcess();
}
// ... Store datasets
Session["rehabAssessmentTDS"] = rehabAssessmentTDS;
Session["rehabAssessmentCommentDetails"] = rehabAssessmentTDS.CommentDetails;
}
}
else
{
// Restore datasets
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
rehabAssessmentCommentDetails = rehabAssessmentTDS.CommentDetails;
}
}
/// <summary>
/// UpdateForProcess. Update the author of each comment
/// </summary>
public void UpdateForProcess()
{
LoginGateway loginGateway = new LoginGateway();
foreach (FullLengthLiningTDS.WetOutCommentsDetailsRow row in (FullLengthLiningTDS.WetOutCommentsDetailsDataTable)Table)
{
loginGateway.LoadByLoginId(row.UserID, row.COMPANY_ID);
row.UserFullName = loginGateway.GetLastName(row.UserID, row.COMPANY_ID) + " " + loginGateway.GetFirstName(row.UserID, row.COMPANY_ID);
}
}
protected string GetCommentCreatedBy(object userId)
{
if (userId != DBNull.Value)
{
if (Convert.ToInt32(userId) != -1)
{
try
{
// Created By
int companyId = Int32.Parse(hdfCompanyId.Value);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(Convert.ToInt32(userId),companyId);
string userName = loginGateway.GetLastName(Convert.ToInt32(userId), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(userId), companyId);
return userName.ToString();
}
catch
{
return "";
}
}
else
{
return "";
}
}
else
{
return "";
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
string employeeType = (ddlEmployeeType.SelectedValue == "(All)") ? "%" : ddlEmployeeType.SelectedValue + "%";
string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue;
DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString());
DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString());
PrintEmployeeHoursForRestartWeekGateway printEmployeeHoursForRestartWeekGateway = new PrintEmployeeHoursForRestartWeekGateway();
printEmployeeHoursForRestartWeekGateway.LoadByEmployeeTypeStartDateEndDateProjectTimeState(employeeType, startDate, endDate, projectTimeState);
// ... set properties to master page
master.Data = printEmployeeHoursForRestartWeekGateway.Data;
master.Table = printEmployeeHoursForRestartWeekGateway.TableName;
// Get report
if (printEmployeeHoursForRestartWeekGateway.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintEmployeeHoursForRestartWeekReport();
}
else
{
master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintEmployeeHoursForRestartWeekReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
// ... For report
// ... ... project time state
if (ddlProjectTimeState.SelectedValue == "(All)")
{
master.SetParameter("projectTimeState", "All");
}
else
{
master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text);
}
// ... ... team member type
if (ddlEmployeeType.SelectedValue == "(All)")
{
master.SetParameter("teamMemberType", "All");
}
else
{
if (ddlEmployeeType.SelectedValue == "LFSCA") master.SetParameter("teamMemberType", "LFS Canada");
if (ddlEmployeeType.SelectedValue == "LFSUS") master.SetParameter("teamMemberType", "LFS USA");
if (ddlEmployeeType.SelectedValue == "LFS") master.SetParameter("teamMemberType", "All LFS");
if (ddlEmployeeType.SelectedValue == "PAGCA") master.SetParameter("teamMemberType", "PAG Canada");
if (ddlEmployeeType.SelectedValue == "PAGUS") master.SetParameter("teamMemberType", "PAG USA");
if (ddlEmployeeType.SelectedValue == "PAG") master.SetParameter("teamMemberType", "All PAG");
if (ddlEmployeeType.SelectedValue == "SOTA") master.SetParameter("teamMemberType", "SOTA");
if (ddlEmployeeType.SelectedValue == "Salaried") master.SetParameter("teamMemberType", "Salaried");
if (ddlEmployeeType.SelectedValue == "Subcontractor") master.SetParameter("teamMemberType", "Subcontractor");
}
// ... ... user
int loginId = Convert.ToInt32(Session["loginID"]);
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(loginId, companyId);
string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId);
master.SetParameter("User", user.Trim());
master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString());
master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString());
}
}
}