/// <summary> /// Update - JLiner /// </summary> public void Update() { Fix1JlinerGateway jlinerGateway = new Fix1JlinerGateway(Data); DataTable sectionChanges = Table.GetChanges(); if (sectionChanges == null ) return; try { DB.Open(); DB.BeginTransaction(); Adapter.InsertCommand.Transaction = DB.Transaction; Adapter.UpdateCommand.Transaction = DB.Transaction; Adapter.DeleteCommand.Transaction = DB.Transaction; if ((sectionChanges != null) && (sectionChanges.Rows.Count > 0)) { Adapter.Update(sectionChanges); } DB.CommitTransaction(); } catch (DBConcurrencyException dBConcurrencyException) { DB.RollbackTransaction(); throw new Exception("Concurrency error: Another user already updated the data you are working on. Your operation has been cancelled.", dBConcurrencyException); } catch (SqlException sqlException) { DB.RollbackTransaction(); byte severityLevel = sqlException.Class; if (severityLevel <= 16) { throw new Exception("Low severity error. Your operation has been cancelled. SQL Error " + severityLevel + "."); } if ((severityLevel >= 17) && (severityLevel <= 19)) { throw new Exception("Mid severity error. Your operation has been cancelled. SQL Error " + severityLevel + "."); } if (severityLevel >= 20) { throw new Exception("High severity error. Your operation has been cancelled. SQL Error " + severityLevel + "."); } } catch (Exception e) { DB.RollbackTransaction(); throw new Exception("Unknow error. Your operation has been cancelled.", e); } finally { DB.Close(); } }
protected void btnFixCommentsAndHistory_Click(object sender, EventArgs e) { Fix1JlinerGateway fix1JlinerGateway = new Fix1JlinerGateway(); // Load all jliners fix1JlinerGateway.LoadAll(); Fix1Jliner fix1Jliner = new Fix1Jliner(fix1JlinerGateway.Data); fix1Jliner.UpdateCommentsHistory(); fix1JlinerGateway.Update(); }
// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// SectionUpdate /// </summary> public void SectionUpdate() { foreach (Fix1TDS.LFS_MASTER_AREARow masterAreaRow in (Fix1TDS.LFS_MASTER_AREADataTable)Table) { LinningPlanGateway liningPlanGateway = new LinningPlanGateway(); Fix1JlinerGateway fix1JlinerGateway = new Fix1JlinerGateway(); fix1JlinerGateway.LoadByIdCompanyId(masterAreaRow.ID, masterAreaRow.COMPANY_ID); Fix1Jliner fix1Jliner = new Fix1Jliner(fix1JlinerGateway.Data); // Update variables int numLats = fix1Jliner.GetNumLats(masterAreaRow.ID, masterAreaRow.COMPANY_ID); int notLinedYeet = fix1Jliner.GetNotLinedYet(masterAreaRow.ID, masterAreaRow.COMPANY_ID); bool allMeasured = fix1Jliner.GetAllMeasured(masterAreaRow.ID, masterAreaRow.COMPANY_ID); int notMeasuredYet = fix1Jliner.GetNotMeasuredYet(masterAreaRow.ID, masterAreaRow.COMPANY_ID); int notDeliveredYet = fix1Jliner.GetNotDeliveredYet(masterAreaRow.ID, masterAreaRow.COMPANY_ID); masterAreaRow.NumLats = numLats; masterAreaRow.NotLinedYet = notLinedYeet; masterAreaRow.AllMeasured = (numLats == 0) ? false : allMeasured; masterAreaRow.NotMeasuredYet = notMeasuredYet; masterAreaRow.NotDeliveredYet = notDeliveredYet; // Update IssueWithtLaterals Guid rowId = masterAreaRow.ID; if (liningPlanGateway.IsLateralsIssueNo(rowId)) { masterAreaRow.IssueWithLaterals = "No"; } else { if (liningPlanGateway.IsLateralsIssueOutOfScope(rowId)) { masterAreaRow.IssueWithLaterals = "Out Of Scope"; } else { if (liningPlanGateway.IsLateralsIssueYesOutOfScope(rowId)) { masterAreaRow.IssueWithLaterals = "Yes, Out Of Scope"; } else { if (liningPlanGateway.IsLateralsIssueYes(rowId)) { masterAreaRow.IssueWithLaterals = "Yes"; } } } } } }
/// <summary> /// LoadAll /// </summary> public void LoadAll() { Fix1JlinerGateway fix1JlinerGateway = new Fix1JlinerGateway(Data); fix1JlinerGateway.LoadAll(); //Load comments and History UpdateCommentsHistory(); }