/// //////////////////////////////////////////////////////////////////////// /// EVENTS /// protected void Page_Load(object sender, System.EventArgs e) { if (!IsPostBack) { //--- Security check if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"])) { Response.Redirect("./../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Prepare initial Session.Remove("lfsM2TablesDummy"); //... Restore data set lfs record tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"]; // ... for client CompaniesGateway companiesGateway = new CompaniesGateway(); tbxCOMPANIES_ID.Text = companiesGateway.GetName((int)tdsLfsRecord.LFS_MASTER_AREA.Rows[0]["COMPANIES_ID"], Convert.ToInt32(Session["companyID"])); // ... for measurement type LFSMeasurementTypeGateway lfsMeasurementTypeGateway = new LFSMeasurementTypeGateway(); DataSet dsLfsMeasurementType = lfsMeasurementTypeGateway.GetLFSMeasurementTypeForDropDownList(""); ddlMeasurementType.DataSource = dsLfsMeasurementType; ddlMeasurementType.DataTextField = "MeasurementType"; // Load LfsM2Tables data int companyId = Convert.ToInt32(Session["companyID"]); Guid id = new Guid(Request.QueryString["id"].ToString()); hdfId.Value = Request.QueryString["id"].ToString(); viewFullLengthLiningTDS = new ViewFullLengthLiningTDS(); ViewFullLengthLiningLfsM2TablesGateway viewFullLengthLiningLfsM2TablesGateway = new ViewFullLengthLiningLfsM2TablesGateway(viewFullLengthLiningTDS); viewFullLengthLiningLfsM2TablesGateway.LoadById(id, companyId); Session["viewFullLengthLiningTDS"] = viewFullLengthLiningTDS; lfsM2Tables = viewFullLengthLiningTDS.LfsM2Tables; Session["lfsM2Tables"] = lfsM2Tables; // Databind Page.DataBind(); TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.FindByIDCOMPANY_ID(new Guid(tbxID.Text), Convert.ToInt32(Session["companyID"])); ddlMeasurementType.SelectedValue = (lfsMasterAreaRow.IsMeasurementTypeNull()) ? "" : lfsMasterAreaRow.MeasurementType; } else { // Restore data set lfs record tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"]; viewFullLengthLiningTDS = (ViewFullLengthLiningTDS)Session["viewFullLengthLiningTDS"]; } }
/// <summary> /// Save all to database (direct) /// </summary> /// <param name="companyId">companyId</param> /// <param name="newId">newId</param> public void Save(int companyId, Guid newId) { ViewFullLengthLiningTDS lfsM2TablesChanges = (ViewFullLengthLiningTDS)Data.GetChanges(); if (lfsM2TablesChanges.LfsM2Tables.Rows.Count > 0) { ViewFullLengthLiningLfsM2TablesGateway viewFullLengthLiningLfsM2TablesGateway = new ViewFullLengthLiningLfsM2TablesGateway(lfsM2TablesChanges); foreach (ViewFullLengthLiningTDS.LfsM2TablesRow row in (ViewFullLengthLiningTDS.LfsM2TablesDataTable)lfsM2TablesChanges.LfsM2Tables) { // Insert new Notes if ((!row.Deleted) && (!row.InDatabase)) { float? videoDistance = null; if (!row.IsVideoDistanceNull()) videoDistance = row.VideoDistance; string clockPosition = ""; if (!row.IsClockPositionNull()) clockPosition = row.ClockPosition; string liveOrAbandoned = ""; if (!row.IsLiveOrAbandonedNull()) liveOrAbandoned = row.LiveOrAbandoned; string distanceToCentreOfLateral = ""; if (!row.IsDistanceToCentreOfLateralNull()) distanceToCentreOfLateral = row.DistanceToCentreOfLateral; string lateralDiameter = ""; if (!row.IsLateralDiameterNull()) lateralDiameter = row.LateralDiameter; string lateralType = ""; if (!row.IsLateralTypeNull()) lateralType = row.LateralType; string dateTimeOpened = ""; if (!row.IsDateTimeOpenedNull()) dateTimeOpened = row.DateTimeOpened; string comments = ""; if (!row.IsCommentsNull()) comments = row.Comments; string reverseSetup = ""; if (!row.IsReverseSetupNull()) reverseSetup = row.ReverseSetup; bool deleted = false; bool archived = row.Archived; LFSRecordM2Tables lfsRecordM2Tables = new LFSRecordM2Tables(null); lfsRecordM2Tables.InsertDirect(newId, row.RefID, row.COMPANY_ID, videoDistance, clockPosition, liveOrAbandoned, distanceToCentreOfLateral, lateralDiameter, lateralType, dateTimeOpened, comments, reverseSetup, deleted, archived); } // Update Notes if ((!row.Deleted) && (row.InDatabase)) { Guid id = row.ID; int refId = row.RefID; // original values float? originalVideoDistance = viewFullLengthLiningLfsM2TablesGateway.GetVideoDistanceOriginal(id, refId, companyId); string originalClockPosition = viewFullLengthLiningLfsM2TablesGateway.GetClockPositionOriginal(id, refId, companyId); string originalLiveOrAbandoned = viewFullLengthLiningLfsM2TablesGateway.GetLiveOrAbandonedOriginal(id, refId, companyId); string originalDistanceToCentreOfLateral = viewFullLengthLiningLfsM2TablesGateway.GetDistanceToCentreOfLateralOriginal(id, refId, companyId); string originalLateralDiameter = viewFullLengthLiningLfsM2TablesGateway.GetLateralDiameterOriginal(id, refId, companyId); string originalLateralType = viewFullLengthLiningLfsM2TablesGateway.GetLateralTypeOriginal(id, refId, companyId); string originalDateTimeOpened = viewFullLengthLiningLfsM2TablesGateway.GetDateTimeOpenedOriginal(id, refId, companyId); string originalComments = viewFullLengthLiningLfsM2TablesGateway.GetCommentsOriginal(id, refId, companyId); string originalReverseSetup = viewFullLengthLiningLfsM2TablesGateway.GetReverseSetupOriginal(id, refId, companyId); bool originalDeleted = false; bool originalArchived = viewFullLengthLiningLfsM2TablesGateway.GetArchivedOriginal(id, refId, companyId); // new values float? newVideoDistance = viewFullLengthLiningLfsM2TablesGateway.GetVideoDistance(id, refId, companyId); string newClockPosition = viewFullLengthLiningLfsM2TablesGateway.GetClockPosition(id, refId, companyId); string newLiveOrAbandoned = viewFullLengthLiningLfsM2TablesGateway.GetLiveOrAbandoned(id, refId, companyId); string newDistanceToCentreOfLateral = viewFullLengthLiningLfsM2TablesGateway.GetDistanceToCentreOfLateral(id, refId, companyId); string newLateralDiameter = viewFullLengthLiningLfsM2TablesGateway.GetLateralDiameter(id, refId, companyId); string newLateralType = viewFullLengthLiningLfsM2TablesGateway.GetLateralType(id, refId, companyId); string newDateTimeOpened = viewFullLengthLiningLfsM2TablesGateway.GetDateTimeOpened(id, refId, companyId); string newComments = viewFullLengthLiningLfsM2TablesGateway.GetComments(id, refId, companyId); string newReverseSetup = viewFullLengthLiningLfsM2TablesGateway.GetReverseSetup(id, refId, companyId); bool newDeleted = false; bool newArchived = viewFullLengthLiningLfsM2TablesGateway.GetArchived(id, refId, companyId); LFSRecordM2Tables lfsRecordM2Tables = new LFSRecordM2Tables(null); lfsRecordM2Tables.UpdateDirect(id, refId, row.COMPANY_ID, originalVideoDistance, originalClockPosition, originalLiveOrAbandoned, originalDistanceToCentreOfLateral, originalLateralDiameter, originalLateralType, originalDateTimeOpened, originalComments, originalReverseSetup, originalDeleted, originalArchived, id, refId, row.COMPANY_ID, newVideoDistance, newClockPosition, newLiveOrAbandoned, newDistanceToCentreOfLateral, newLateralDiameter, newLateralType, newDateTimeOpened, newComments, newReverseSetup, newDeleted, newArchived); } // Deleted notes if ((row.Deleted) && (row.InDatabase)) { LFSRecordM2Tables lfsRecordM2Tables = new LFSRecordM2Tables(null); lfsRecordM2Tables.DeleteDirect(row.ID, row.RefID, row.COMPANY_ID); } } } }