private void workUpdate() { // Get general variables int workId = Int32.Parse(hdfWorkId.Value.Trim()); int projectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); int assetId = Int32.Parse(hdfAssetId.Value.Trim()); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); string workType = hdfWorkType.Value.Trim(); // Update comments for rehab assessment // Get original variables WorkGateway workGateway = new WorkGateway(); workGateway.LoadByWorkId(workId, companyId); string originalWorkType = workGateway.GetWorkTypeOriginal(workId); int? originalLibraryCategoriesId = workGateway.GetLibraryCategoriesIdOriginal(workId); string originalComment = workGateway.GetCommentsOriginal(workId); string originalHistory = workGateway.GetHistoryOriginal(workId); //Get all new rehab assessment comments RehabAssessmentCommentDetailsGateway rehabAssessmentCommentDetailsGateway = new RehabAssessmentCommentDetailsGateway(rehabAssessmentTDS); rehabAssessmentCommentDetailsGateway.LoadAllByWorkIdWorkType(workId, companyId, workType); RehabAssessmentCommentDetails rehabAssessmentCommentDetails = new RehabAssessmentCommentDetails(rehabAssessmentCommentDetailsGateway.Data); string newComment = rehabAssessmentCommentDetails.GetAllRehabAssessmentComments(workId, companyId, rehabAssessmentCommentDetailsGateway.Table.Rows.Count, "\n"); Work work = new Work(null); work.UpdateDirect(workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, originalComment, originalHistory, workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, newComment, originalHistory); // Update comments for full length lining int workIdFll = Int32.Parse(hdfWorkIdFll.Value.Trim()); if (workIdFll != 0) { WorkGateway workGatewayForFll = new WorkGateway(); workGatewayForFll.LoadByWorkId(workIdFll, companyId); string originalWorkTypeForFll = workGatewayForFll.GetWorkTypeOriginal(workIdFll); int? originalLibraryCategoriesIdForFll = workGatewayForFll.GetLibraryCategoriesIdOriginal(workIdFll); string originalCommentForFll = workGatewayForFll.GetCommentsOriginal(workIdFll); string originalHistoryForFll = workGatewayForFll.GetHistoryOriginal(workIdFll); //Get all new fulllengthlining comments FullLengthLiningCommentDetailsGateway fullLengthLiningCommentDetailsGateway = new FullLengthLiningCommentDetailsGateway(); fullLengthLiningCommentDetailsGateway.LoadAllByWorkIdWorkType(workIdFll, companyId, "Full Length Lining"); FullLengthLiningCommentDetails fullLengthLiningCommentDetails = new FullLengthLiningCommentDetails(fullLengthLiningCommentDetailsGateway.Data); string newCommentForFll = fullLengthLiningCommentDetails.GetAllFullLengthLiningComments(workIdFll, companyId, fullLengthLiningCommentDetailsGateway.Table.Rows.Count, "\n"); // Save comments Work workForFll = new Work(null); workForFll.UpdateDirect(workIdFll, projectId, assetId, originalWorkTypeForFll, originalLibraryCategoriesIdForFll, false, companyId, originalCommentForFll, originalHistoryForFll, workIdFll, projectId, assetId, originalWorkTypeForFll, originalLibraryCategoriesIdForFll, false, companyId, newCommentForFll, originalHistoryForFll); } }
public void UpdateDataToCorrectDataSet(int workIdRa, int workIdFll, RehabAssessmentCommentDetails raCommentDetails, FullLengthLiningCommentDetails fllCommentDetails, string workType) { foreach (RehabAssessmentTDS.CommentDetailsRow row in (RehabAssessmentTDS.CommentDetailsDataTable)Table) { int workId = row.WorkID; string type = row.Type; string subject = row.Subject; int loginId = row.UserID; DateTime dateTime_ = row.DateTime_; string comment = row.Comment; int? libraryFilesId = null; if (!row.IsLIBRARY_FILES_IDNull() ) libraryFilesId = row.LIBRARY_FILES_ID; bool deleted = row.Deleted; int companyId = row.COMPANY_ID; bool inDatabase = row.InDatabase; string userFullName = row.UserFullName; bool toHistory = row.ToHistory; if (row.WorkID == workIdRa) { raCommentDetails.Insert(workId, type, subject, loginId, dateTime_, comment, libraryFilesId, deleted, companyId, inDatabase, userFullName, toHistory, workType); } else { if (row.WorkID == workIdFll) { fllCommentDetails.Insert(workId, type, subject, loginId, dateTime_, comment, libraryFilesId, deleted, companyId, inDatabase, userFullName, toHistory, workType); } } } }
// //////////////////////////////////////////////////////////////////////// // 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; } }
private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { int companyId = Int32.Parse(hdfCompanyId.Value); // Update comments FullLengthLiningCommentDetails fullLengthLiningCommentDetails = new FullLengthLiningCommentDetails(fullLengthLiningTDS); fullLengthLiningCommentDetails.Save(companyId); // Update works workUpdate(); // Update section int workId = Int32.Parse(hdfWorkId.Value.Trim()); FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS); fullLengthLiningWorkDetails.UpdateCommentsForSummaryEdit(workId, companyId); // Store datasets Session["fullLengthLiningTDS"] = fullLengthLiningTDS; DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void GrdCommentsAdd() { if (ValidateCommentsFooter()) { Page.Validate("commentsDataAdd"); if (Page.IsValid) { int workId = Int32.Parse(hdfWorkId.Value); 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); FullLengthLiningCommentDetails model = new FullLengthLiningCommentDetails(fullLengthLiningTDS); model.Insert(workId, newType, newSubject, loginId, dateTime_, newComment, libraryFilesId, deleted, companyId, inDatabase, userFullName, toHistory, workType); Session.Remove("fullLengthLiningCommentDetailsDummy"); Session["fullLengthLiningTDS"] = fullLengthLiningTDS; Session["fullLengthLiningCommentDetails"] = fullLengthLiningTDS.CommentDetails; grdComments.DataBind(); grdComments.PageIndex = grdComments.PageCount - 1; } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_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 fl_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_FULLLENGTHLINING_ADMIN"]).ToString(); hdfWorkType.Value = "Full Length Lining"; hdfWorkId.Value = Request.QueryString["work_id"].ToString(); hdfAssetId.Value = Request.QueryString["asset_id"].ToString(); hdfUpdate.Value = "yes"; // ... 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); // Prepare initial data Session.Remove("fullLengthLiningCommentDetailsDummy"); // If coming from // ... flsummary.aspx and fl_edit.aspx if (Request.QueryString["source_page"] == "fl_summary.aspx" || Request.QueryString["source_page"] == "fl_edit.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"]; int assetId = Int32.Parse(hdfAssetId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); int flWorkId = Int32.Parse(hdfWorkId.Value.Trim()); int raWorkId = 0; // ... If the project has fl works if (flWorkId != 0) { WorkGateway workGateway = new WorkGateway(); workGateway.LoadByProjectIdAssetIdWorkType(currentProjectId, assetId, "Rehab Assessment", companyId); if (workGateway.Table.Rows.Count > 0) { raWorkId = workGateway.GetWorkId(assetId, "Rehab Assessment", currentProjectId); } // ... update fl and ra comments FullLengthLiningCommentDetailsGateway fullLengthLiningCommentDetailsGateway = new FullLengthLiningCommentDetailsGateway(fullLengthLiningTDS); fullLengthLiningCommentDetailsGateway.LoadAllByFlWorkIdRaWorkId(flWorkId, raWorkId, companyId); FullLengthLiningCommentDetails fullLengthLiningCommentDetailsForLoad = new FullLengthLiningCommentDetails(fullLengthLiningCommentDetailsGateway.Data); fullLengthLiningCommentDetailsForLoad.UpdateForProcess(); } // ... Store datasets Session["fullLengthLiningTDS"] = fullLengthLiningTDS; Session["fullLengthLiningCommentDetails"] = fullLengthLiningTDS.CommentDetails; } } else { // Restore datasets fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"]; fullLengthLiningCommentDetails = fullLengthLiningTDS.CommentDetails; // Store Session["fullLengthLiningCommentDetails"] = fullLengthLiningTDS.CommentDetails; } }
protected void grdComments_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("commentsDataEdit"); if (Page.IsValid) { int workId = (int)e.Keys["WorkID"]; int refId = (int)e.Keys["RefID"]; int companyId = Int32.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(Session["loginID"]); bool adminPermission = Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_ADMIN"]); bool toHistory = false; string newSubject = ((TextBox)grdComments.Rows[e.RowIndex].Cells[3].FindControl("tbxSubjectEdit")).Text.Trim(); string newComment = ((TextBox)grdComments.Rows[e.RowIndex].Cells[4].FindControl("tbxCommentsEdit")).Text.Trim(); string newType = ""; if (((DropDownList)grdComments.Rows[e.RowIndex].Cells[3].FindControl("ddlTypeEdit")).Visible) { newType = ((DropDownList)grdComments.Rows[e.RowIndex].Cells[3].FindControl("ddlTypeEdit")).SelectedValue.ToString().Trim(); } else { newType = ((TextBox)grdComments.Rows[e.RowIndex].Cells[3].FindControl("tbxTypeEdit")).Text; } // Update data FullLengthLiningCommentDetails model = new FullLengthLiningCommentDetails(fullLengthLiningTDS); model.Update(workId, refId, newType, newSubject, companyId, newComment, loginId, adminPermission, toHistory); // Store dataset Session["fullLengthLiningTDS"] = fullLengthLiningTDS; Session["fullLengthLiningCommentDetails"] = fullLengthLiningTDS.CommentDetails; } else { e.Cancel = true; } }
protected void grdComments_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Comments Gridview, if the gridview is edition mode if (grdComments.EditIndex >= 0) { grdComments.UpdateRow(grdComments.EditIndex, true); } // Delete comments int workId = (int)e.Keys["WorkID"]; int refId = (int)e.Keys["RefID"]; int companyId = Int32.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(hdfLoginId.Value); bool adminPermission = Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_ADMIN"]); // Delete comment FullLengthLiningCommentDetails model = new FullLengthLiningCommentDetails(fullLengthLiningTDS); model.Delete(workId, refId, companyId, loginId, adminPermission); // Store dataset Session["fullLengthLiningTDS"] = fullLengthLiningTDS; }