public static PlanCase CreateCase(SqlDataReader dr, int planId, int defendantId) { PlanCase tmpcase = null; if (!dr.IsClosed && dr.HasRows) { // getting id that uniquely identifies the object string casename = dr["casename"].ToString(); string updatedby = dr["updatedby"].ToString(); DateTime updateddate = (DateTime)dr["updateddate"]; tmpcase = new PlanCase(planId, defendantId, casename, updatedby, updateddate); tmpcase.RaiseChangedEvents = false; tmpcase.CountyId = (!dr.IsDBNull(dr.GetOrdinal("countyid"))) ? Convert.ToInt32(dr["countyid"]) : -1; tmpcase.Committed = Convert.ToBoolean(dr["committed"].ToString()); if (!dr.IsDBNull(dr.GetOrdinal("commitdate"))) { tmpcase.CommitDate = dr["commitdate"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("commitbasedate"))) { tmpcase.CommitBaseDate = dr["commitbasedate"].ToString(); } tmpcase.CommitDaysTill = (!dr.IsDBNull(dr.GetOrdinal("commitdaystill"))) ? Convert.ToDouble(dr["commitdaystill"]) : 0; tmpcase.CAPP = Convert.ToBoolean(dr["capp"].ToString()); tmpcase.Save(); tmpcase.RaiseChangedEvents = true; } return(tmpcase); }
public PlanCase Clone() { PlanCase tmpcase = new PlanCase(this.ID, this.DefendantId, this.CaseName, this.UpdatedBy, this.UpdatedDate); tmpcase.RaiseChangedEvents = false; tmpcase.CountyId = this.CountyId; tmpcase.Committed = this.Committed; tmpcase.CommitDate = this.CommitDate; tmpcase.CommitBaseDate = this.CommitBaseDate; tmpcase.CommitDaysTill = this.CommitDaysTill; tmpcase.CAPP = this.CAPP; tmpcase.Save(); tmpcase.RaiseChangedEvents = true; return(tmpcase); }
public static PlanCase UpdateCaseIds(PlanCase planCase, int planId, int defendantId) { PlanCase tmpcase = null; // getting id that uniquely identifies the object tmpcase = new PlanCase(planId, defendantId, planCase.CaseName, planCase.UpdatedBy, planCase.UpdatedDate); tmpcase.RaiseChangedEvents = false; tmpcase.CountyId = planCase.CountyId; tmpcase.Committed = planCase.Committed; tmpcase.CommitDate = planCase.CommitDate; tmpcase.CommitBaseDate = planCase.CommitBaseDate; tmpcase.CommitDaysTill = planCase.CommitDaysTill; tmpcase.CAPP = planCase.CAPP; tmpcase.Save(); tmpcase.MyState = planCase.MyState; tmpcase.RaiseChangedEvents = true; return(tmpcase); }
/* * * This particular function is very specific in how it pastes data based on specific client requests. * * in this case I don't care about all the cells that come out of the columns. * All we really want is the first column. This should accomodate pasting using ALT, or * selecting all rows and columns and then pasting. */ private void PasteClipboard() { bool dataFormatCorrect = true; bool excludedDupes = false; bool excludedPrefixes = false; string strCaseName = string.Empty; string strClipboardData = string.Empty; string[] rowSplitter = { "\r\n", "\r", "\n" }; this.SuspendLayout(); dgvCases.SuspendLayout(); // get text from clipboard try { strClipboardData = ((IDataObject)Clipboard.GetDataObject()).GetData(DataFormats.Text).ToString(); } catch { } if (!string.IsNullOrEmpty(strClipboardData)) { // split clipboard data into lines and add each as row in datagridview foreach (string strRow in strClipboardData.Split(rowSplitter, StringSplitOptions.RemoveEmptyEntries)) { // 132 character matches input file. if (strRow.Length == 132) { // checking obligor, owed, paid, and balance columns if (!strRow.Substring(78, 14).Contains("$") || !strRow.Substring(93, 14).Contains("$") || !strRow.Substring(108, 14).Contains("$") || strRow.Substring(28, 25).Trim().Length < 1) { dataFormatCorrect = false; continue; } strCaseName = strRow.Substring(0, 18).Trim(); } else if (strRow.Trim().Length <= 18 && strRow.Trim().Length > 0 && !strRow.ToLower().Contains("rows selected")) { strCaseName = strRow.Trim(); } else { dataFormatCorrect = false; continue; } // does the case already exist if (CaseExists(strCaseName)) { excludedDupes = true; continue; } // does the case have an excluded prefix if (Helper.HasRestrictedCasePrefix(strCaseName)) { excludedPrefixes = true; continue; } // adding case PlanCase plancase = (PlanCase)bindingCases.AddNew(); plancase.CaseName = strCaseName; if (strCaseName.ToUpper().Contains("NT") || strCaseName.ToUpper().Contains("ST")) { plancase.CAPP = true; } } bindingCases.ResetBindings(false); } dgvCases.ResumeLayout(false); this.ResumeLayout(false); if (excludedDupes || excludedPrefixes || !dataFormatCorrect) { string strMessage = ""; if (excludedDupes) { strMessage += "Duplicate case(s) encountered.\n"; } if (excludedPrefixes) { strMessage += "Case(s) encountered that had an excluded prefix.\n"; } if (!dataFormatCorrect) { strMessage += "*Clipboard line(s) encountered that do not match a recognizable format:\n\n" + "1. a line exactly 132 characters.\n" + "2. a line that is 19 characters or less.\n\n" + "*This message should be expected if pasting an entire file and not specific rows."; } MessageBox.Show(this, strMessage, "Cases", MessageBoxButtons.OK, MessageBoxIcon.Information); } }