internal static void UpdateStatuteInformation(StatuteInformation statuteInfo, string fileID) { string query = string.Format(Constants.EXISTS_CLIENT_STATUTE_INFORMATION_DETAILS_QUERY, fileID); object isPresent = DBHelper.GetScalarValue(query); int result = 0; if (isPresent == null) { query = string.Format(Constants.INSERT_CLIENT_STATUTE_INFORMATION_DETAILS_QUERY, fileID, statuteInfo.AccidentDate, statuteInfo.AccDateAfter1yr, statuteInfo.AccDateAfter2yr, statuteInfo.ComplaintFileDate, statuteInfo.ComplaintAfter60days, statuteInfo.ComplaintAfter2yrs, statuteInfo.ComplaintAfter3yrs, statuteInfo.ComplaintAfter5yrs, statuteInfo.IsGovtDClaim); result = DBHelper.ExecuteNonQuery(query); } else { query = string.Format(Constants.UPDATE_CLIENT_STATUTE_INFORMATION_DETAILS_QUERY, fileID, statuteInfo.AccidentDate, statuteInfo.AccDateAfter1yr, statuteInfo.AccDateAfter2yr, statuteInfo.ComplaintFileDate, statuteInfo.ComplaintAfter60days, statuteInfo.ComplaintAfter2yrs, statuteInfo.ComplaintAfter3yrs, statuteInfo.ComplaintAfter5yrs, statuteInfo.IsGovtDClaim); result = DBHelper.ExecuteNonQuery(query); } if (statuteInfo.CityClaim != null) { query = string.Format(Constants.EXISTS_GOVT_CITY_CLAIM_DETAILS_QUERY, fileID); isPresent = DBHelper.GetScalarValue(query); if (isPresent == null) { query = string.Format(Constants.INSERT_GOVT_CITY_CLAIM_DETAILS_QUERY, fileID, statuteInfo.CityClaim.DeniedDate, statuteInfo.CityClaim.ClaimDueDate, statuteInfo.CityClaim.FiledDate, statuteInfo.CityClaim.FiledDateAfter60Days, statuteInfo.CityClaim.FiledDateAfter2yrs, statuteInfo.CityClaim.FiledDateAfter3yrs, statuteInfo.CityClaim.FiledDateAfter5yrs); result = DBHelper.ExecuteNonQuery(query); } else { query = string.Format(Constants.UPDATE_GOVT_CITY_CLAIM_DETAILS_QUERY, fileID, statuteInfo.CityClaim.DeniedDate, statuteInfo.CityClaim.ClaimDueDate, statuteInfo.CityClaim.FiledDate, statuteInfo.CityClaim.FiledDateAfter60Days, statuteInfo.CityClaim.FiledDateAfter2yrs, statuteInfo.CityClaim.FiledDateAfter3yrs, statuteInfo.CityClaim.FiledDateAfter5yrs); result = DBHelper.ExecuteNonQuery(query); } } if (statuteInfo.StateClaim != null) { query = string.Format(Constants.EXISTS_GOVT_STATE_CLAIM_DETAILS_QUERY, fileID); isPresent = DBHelper.GetScalarValue(query); if (isPresent == null) { query = string.Format(Constants.INSERT_GOVT_STATE_CLAIM_DETAILS_QUERY, fileID, statuteInfo.StateClaim.DeniedDate, statuteInfo.StateClaim.ClaimDueDate, statuteInfo.StateClaim.FiledDate, statuteInfo.StateClaim.FiledDateAfter60Days, statuteInfo.StateClaim.FiledDateAfter2yrs, statuteInfo.StateClaim.FiledDateAfter3yrs, statuteInfo.StateClaim.FiledDateAfter5yrs); result = DBHelper.ExecuteNonQuery(query); } else { query = string.Format(Constants.UPDATE_GOVT_STATE_CLAIM_DETAILS_QUERY, fileID, statuteInfo.StateClaim.DeniedDate, statuteInfo.StateClaim.ClaimDueDate, statuteInfo.StateClaim.FiledDate, statuteInfo.StateClaim.FiledDateAfter60Days, statuteInfo.StateClaim.FiledDateAfter2yrs, statuteInfo.StateClaim.FiledDateAfter3yrs, statuteInfo.StateClaim.FiledDateAfter5yrs); result = DBHelper.ExecuteNonQuery(query); } } if (statuteInfo.CountyClaim != null) { query = string.Format(Constants.EXISTS_GOVT_COUNTY_CLAIM_DETAILS_QUERY, fileID); isPresent = DBHelper.GetScalarValue(query); if (isPresent == null) { query = string.Format(Constants.INSERT_GOVT_COUNTY_CLAIM_DETAILS_QUERY, fileID, statuteInfo.CountyClaim.DeniedDate, statuteInfo.CountyClaim.ClaimDueDate, statuteInfo.CountyClaim.FiledDate, statuteInfo.CountyClaim.FiledDateAfter60Days, statuteInfo.CountyClaim.FiledDateAfter2yrs, statuteInfo.CountyClaim.FiledDateAfter3yrs, statuteInfo.CountyClaim.FiledDateAfter5yrs); result = DBHelper.ExecuteNonQuery(query); } else { query = string.Format(Constants.UPDATE_GOVT_COUNTY_CLAIM_DETAILS_QUERY, fileID, statuteInfo.CountyClaim.DeniedDate, statuteInfo.CountyClaim.ClaimDueDate, statuteInfo.CountyClaim.FiledDate, statuteInfo.CountyClaim.FiledDateAfter60Days, statuteInfo.CountyClaim.FiledDateAfter2yrs, statuteInfo.CountyClaim.FiledDateAfter3yrs, statuteInfo.CountyClaim.FiledDateAfter5yrs); result = DBHelper.ExecuteNonQuery(query); } } if (statuteInfo.OtherClaim != null) { query = string.Format(Constants.EXISTS_GOVT_OTHER_CLAIM_DETAILS_QUERY, fileID); isPresent = DBHelper.GetScalarValue(query); if (isPresent == null) { query = string.Format(Constants.INSERT_GOVT_OTHER_CLAIM_DETAILS_QUERY, fileID, statuteInfo.OtherClaim.DeniedDate, statuteInfo.OtherClaim.ClaimDueDate, statuteInfo.OtherClaim.FiledDate, statuteInfo.OtherClaim.FiledDateAfter60Days, statuteInfo.OtherClaim.FiledDateAfter2yrs, statuteInfo.OtherClaim.FiledDateAfter3yrs, statuteInfo.OtherClaim.FiledDateAfter5yrs); result = DBHelper.ExecuteNonQuery(query); } else { query = string.Format(Constants.UPDATE_GOVT_OTHER_CLAIM_DETAILS_QUERY, fileID, statuteInfo.OtherClaim.DeniedDate, statuteInfo.OtherClaim.ClaimDueDate, statuteInfo.OtherClaim.FiledDate, statuteInfo.OtherClaim.FiledDateAfter60Days, statuteInfo.OtherClaim.FiledDateAfter2yrs, statuteInfo.OtherClaim.FiledDateAfter3yrs, statuteInfo.OtherClaim.FiledDateAfter5yrs); result = DBHelper.ExecuteNonQuery(query); } } }
private void btnSaveStatuteInfo_Click(object sender, RoutedEventArgs e) { try { if (dtStatuteComplaintFiledDate.SelectedDate == null && dtCityDeniedDate.SelectedDate == null && dtCityFileDate.SelectedDate == null && dtCountyDeniedDate.SelectedDate == null && dtCountyFileDate.SelectedDate == null && dtStateDeniedDate.SelectedDate == null && dtStateFileDate.SelectedDate == null && dtOtherDeniedDate.SelectedDate == null && dtOtherFileDate.SelectedDate == null) { return; } StatuteInformation statuteInfo = new StatuteInformation(); if (dtAccidentDate.SelectedDate != null) { statuteInfo.AccidentDate = dtAccidentDate.SelectedDate.Value.ToShortDateString(); statuteInfo.AccDateAfter1yr = dtAccidentDate.SelectedDate.Value.AddYears(1).ToShortDateString(); statuteInfo.AccDateAfter2yr = dtAccidentDate.SelectedDate.Value.AddYears(2).ToShortDateString(); } if (dtStatuteComplaintFiledDate.SelectedDate != null) { statuteInfo.ComplaintFileDate = dtStatuteComplaintFiledDate.SelectedDate.Value.ToShortDateString(); statuteInfo.ComplaintAfter60days = dtStatuteComplaintFiledDate.SelectedDate.Value.AddDays(60).ToShortDateString(); statuteInfo.ComplaintAfter2yrs = dtStatuteComplaintFiledDate.SelectedDate.Value.AddYears(2).ToShortDateString(); statuteInfo.ComplaintAfter3yrs = dtStatuteComplaintFiledDate.SelectedDate.Value.AddYears(3).ToShortDateString(); statuteInfo.ComplaintAfter5yrs = dtStatuteComplaintFiledDate.SelectedDate.Value.AddYears(5).ToShortDateString(); } statuteInfo.IsGovtDClaim = cbIsItAGovernmentClaim.IsChecked.Value; if (statuteInfo.IsGovtDClaim) { if (dtCityDeniedDate.SelectedDate != null) { statuteInfo.CityClaim = new GovertmentClaimInformation(); statuteInfo.CityClaim.DeniedDate = dtCityDeniedDate.SelectedDate.Value.ToString(); statuteInfo.CityClaim.ClaimDueDate = dtCityDeniedDate.SelectedDate.Value.AddDays(180).ToString(); } if (dtCityFileDate.SelectedDate != null) { statuteInfo.CityClaim = statuteInfo.CityClaim ?? new GovertmentClaimInformation(); statuteInfo.CityClaim.FiledDate = dtCityFileDate.SelectedDate.Value.ToString(); statuteInfo.CityClaim.FiledDateAfter60Days = dtCityFileDate.SelectedDate.Value.AddDays(60).ToString(); statuteInfo.CityClaim.FiledDateAfter2yrs = dtCityFileDate.SelectedDate.Value.AddYears(2).ToString(); statuteInfo.CityClaim.FiledDateAfter3yrs = dtCityFileDate.SelectedDate.Value.AddYears(3).ToString(); statuteInfo.CityClaim.FiledDateAfter5yrs = dtCityFileDate.SelectedDate.Value.AddYears(5).ToString(); } if (dtCountyDeniedDate.SelectedDate != null) { statuteInfo.CountyClaim = new GovertmentClaimInformation(); statuteInfo.CountyClaim.DeniedDate = dtCountyDeniedDate.SelectedDate.Value.ToString(); statuteInfo.CountyClaim.ClaimDueDate = dtCountyDeniedDate.SelectedDate.Value.AddDays(180).ToString(); } if (dtCountyFileDate.SelectedDate != null) { statuteInfo.CountyClaim = statuteInfo.CountyClaim ?? new GovertmentClaimInformation(); statuteInfo.CountyClaim.FiledDate = dtCountyFileDate.SelectedDate.Value.ToString(); statuteInfo.CountyClaim.FiledDateAfter60Days = dtCountyFileDate.SelectedDate.Value.AddDays(60).ToString(); statuteInfo.CountyClaim.FiledDateAfter2yrs = dtCountyFileDate.SelectedDate.Value.AddYears(2).ToString(); statuteInfo.CountyClaim.FiledDateAfter3yrs = dtCountyFileDate.SelectedDate.Value.AddYears(3).ToString(); statuteInfo.CountyClaim.FiledDateAfter5yrs = dtCountyFileDate.SelectedDate.Value.AddYears(5).ToString(); } if (dtStateDeniedDate.SelectedDate != null) { statuteInfo.StateClaim = new GovertmentClaimInformation(); statuteInfo.StateClaim.DeniedDate = dtStateDeniedDate.SelectedDate.Value.ToString(); statuteInfo.StateClaim.ClaimDueDate = dtStateDeniedDate.SelectedDate.Value.AddDays(180).ToString(); } if (dtStateFileDate.SelectedDate != null) { statuteInfo.StateClaim = statuteInfo.StateClaim ?? new GovertmentClaimInformation(); statuteInfo.StateClaim.FiledDate = dtStateFileDate.SelectedDate.Value.ToString(); statuteInfo.StateClaim.FiledDateAfter60Days = dtStateFileDate.SelectedDate.Value.AddDays(60).ToString(); statuteInfo.StateClaim.FiledDateAfter2yrs = dtStateFileDate.SelectedDate.Value.AddYears(2).ToString(); statuteInfo.StateClaim.FiledDateAfter3yrs = dtStateFileDate.SelectedDate.Value.AddYears(3).ToString(); statuteInfo.StateClaim.FiledDateAfter5yrs = dtStateFileDate.SelectedDate.Value.AddYears(5).ToString(); } if (dtOtherDeniedDate.SelectedDate != null) { statuteInfo.OtherClaim = new GovertmentClaimInformation(); statuteInfo.OtherClaim.DeniedDate = dtOtherDeniedDate.SelectedDate.Value.ToString(); statuteInfo.OtherClaim.ClaimDueDate = dtOtherDeniedDate.SelectedDate.Value.AddDays(180).ToString(); } if (dtOtherFileDate.SelectedDate != null) { statuteInfo.OtherClaim = statuteInfo.OtherClaim ?? new GovertmentClaimInformation(); statuteInfo.OtherClaim.FiledDate = dtOtherFileDate.SelectedDate.Value.ToString(); statuteInfo.OtherClaim.FiledDateAfter60Days = dtOtherFileDate.SelectedDate.Value.AddDays(60).ToString(); statuteInfo.OtherClaim.FiledDateAfter2yrs = dtOtherFileDate.SelectedDate.Value.AddYears(2).ToString(); statuteInfo.OtherClaim.FiledDateAfter3yrs = dtOtherFileDate.SelectedDate.Value.AddYears(3).ToString(); statuteInfo.OtherClaim.FiledDateAfter5yrs = dtOtherFileDate.SelectedDate.Value.AddYears(5).ToString(); } } BusinessLogic.UpdateStatuteInformation(statuteInfo, txtFileNo.Text); Helper.ShowInformationMessageBox("Statute Information Saved."); btnSaveStatuteInfo.IsEnabled = false; btnCancelStatuteInfo.IsEnabled = false; btnEditStatuteInfo.IsEnabled = true; UpdateStatusClientStatuteInfo(true); dgClientFileList.SelectedIndex = -1; dgClientFileList.SelectedIndex = 0; } catch (Exception ex) { Helper.LogException(ex); } }
private void SaveStatuteInformation() { try { if (dtStatuteComplaintFiledDate.SelectedDate == null && dtCityDeniedDate.SelectedDate == null && dtCityFileDate.SelectedDate == null && dtCountyDeniedDate.SelectedDate == null && dtCountyFileDate.SelectedDate == null && dtStateDeniedDate.SelectedDate == null && dtStateFileDate.SelectedDate == null && dtOtherDeniedDate.SelectedDate == null && dtOtherFileDate.SelectedDate == null) { return; } StatuteInformation statuteInfo = new StatuteInformation(); if (dtAccidentDate.SelectedDate != null) { statuteInfo.AccidentDate = dtAccidentDate.SelectedDate.Value.ToShortDateString(); statuteInfo.AccDateAfter1yr = dtAccidentDate.SelectedDate.Value.AddYears(1).ToShortDateString(); statuteInfo.AccDateAfter2yr = dtAccidentDate.SelectedDate.Value.AddYears(2).ToShortDateString(); } if (dtStatuteComplaintFiledDate.SelectedDate != null) { statuteInfo.ComplaintFileDate = dtStatuteComplaintFiledDate.SelectedDate.Value.ToShortDateString(); statuteInfo.ComplaintAfter60days = dtStatuteComplaintFiledDate.SelectedDate.Value.AddDays(60).ToShortDateString(); statuteInfo.ComplaintAfter2yrs = dtStatuteComplaintFiledDate.SelectedDate.Value.AddYears(2).ToShortDateString(); statuteInfo.ComplaintAfter3yrs = dtStatuteComplaintFiledDate.SelectedDate.Value.AddYears(3).ToShortDateString(); statuteInfo.ComplaintAfter5yrs = dtStatuteComplaintFiledDate.SelectedDate.Value.AddYears(5).ToShortDateString(); } statuteInfo.IsGovtDClaim = cbIsItAGovernmentClaim.IsChecked.Value; if (statuteInfo.IsGovtDClaim) { if (dtCityDeniedDate.SelectedDate != null) { statuteInfo.CityClaim = new GovertmentClaimInformation(); statuteInfo.CityClaim.DeniedDate = dtCityDeniedDate.SelectedDate.Value.ToShortDateString(); statuteInfo.CityClaim.ClaimDueDate = dtCityDeniedDate.SelectedDate.Value.AddDays(180).ToShortDateString(); } if (dtCityFileDate.SelectedDate != null) { statuteInfo.CityClaim = statuteInfo.CityClaim ?? new GovertmentClaimInformation(); statuteInfo.CityClaim.FiledDate = dtCityFileDate.SelectedDate.Value.ToShortDateString(); statuteInfo.CityClaim.FiledDateAfter60Days = dtCityFileDate.SelectedDate.Value.AddDays(60).ToShortDateString(); statuteInfo.CityClaim.FiledDateAfter2yrs = dtCityFileDate.SelectedDate.Value.AddYears(2).ToShortDateString(); statuteInfo.CityClaim.FiledDateAfter3yrs = dtCityFileDate.SelectedDate.Value.AddYears(3).ToShortDateString(); statuteInfo.CityClaim.FiledDateAfter5yrs = dtCityFileDate.SelectedDate.Value.AddYears(5).ToShortDateString(); } if (dtCountyDeniedDate.SelectedDate != null) { statuteInfo.CountyClaim = new GovertmentClaimInformation(); statuteInfo.CountyClaim.DeniedDate = dtCountyDeniedDate.SelectedDate.Value.ToShortDateString(); statuteInfo.CountyClaim.ClaimDueDate = dtCountyDeniedDate.SelectedDate.Value.AddDays(180).ToShortDateString(); } if (dtCountyFileDate.SelectedDate != null) { statuteInfo.CountyClaim = statuteInfo.CountyClaim ?? new GovertmentClaimInformation(); statuteInfo.CountyClaim.FiledDate = dtCountyFileDate.SelectedDate.Value.ToShortDateString(); statuteInfo.CountyClaim.FiledDateAfter60Days = dtCountyFileDate.SelectedDate.Value.AddDays(60).ToShortDateString(); statuteInfo.CountyClaim.FiledDateAfter2yrs = dtCountyFileDate.SelectedDate.Value.AddYears(2).ToShortDateString(); statuteInfo.CountyClaim.FiledDateAfter3yrs = dtCountyFileDate.SelectedDate.Value.AddYears(3).ToShortDateString(); statuteInfo.CountyClaim.FiledDateAfter5yrs = dtCountyFileDate.SelectedDate.Value.AddYears(5).ToShortDateString(); } if (dtStateDeniedDate.SelectedDate != null) { statuteInfo.StateClaim = new GovertmentClaimInformation(); statuteInfo.StateClaim.DeniedDate = dtStateDeniedDate.SelectedDate.Value.ToShortDateString(); statuteInfo.StateClaim.ClaimDueDate = dtStateDeniedDate.SelectedDate.Value.AddDays(180).ToShortDateString(); } if (dtStateFileDate.SelectedDate != null) { statuteInfo.StateClaim = statuteInfo.StateClaim ?? new GovertmentClaimInformation(); statuteInfo.StateClaim.FiledDate = dtStateFileDate.SelectedDate.Value.ToShortDateString(); statuteInfo.StateClaim.FiledDateAfter60Days = dtStateFileDate.SelectedDate.Value.AddDays(60).ToShortDateString(); statuteInfo.StateClaim.FiledDateAfter2yrs = dtStateFileDate.SelectedDate.Value.AddYears(2).ToShortDateString(); statuteInfo.StateClaim.FiledDateAfter3yrs = dtStateFileDate.SelectedDate.Value.AddYears(3).ToShortDateString(); statuteInfo.StateClaim.FiledDateAfter5yrs = dtStateFileDate.SelectedDate.Value.AddYears(5).ToShortDateString(); } if (dtOtherDeniedDate.SelectedDate != null) { statuteInfo.OtherClaim = new GovertmentClaimInformation(); statuteInfo.OtherClaim.DeniedDate = dtOtherDeniedDate.SelectedDate.Value.ToShortDateString(); statuteInfo.OtherClaim.ClaimDueDate = dtOtherDeniedDate.SelectedDate.Value.AddDays(180).ToShortDateString(); } if (dtOtherFileDate.SelectedDate != null) { statuteInfo.OtherClaim = statuteInfo.OtherClaim ?? new GovertmentClaimInformation(); statuteInfo.OtherClaim.FiledDate = dtOtherFileDate.SelectedDate.Value.ToShortDateString(); statuteInfo.OtherClaim.FiledDateAfter60Days = dtOtherFileDate.SelectedDate.Value.AddDays(60).ToShortDateString(); statuteInfo.OtherClaim.FiledDateAfter2yrs = dtOtherFileDate.SelectedDate.Value.AddYears(2).ToShortDateString(); statuteInfo.OtherClaim.FiledDateAfter3yrs = dtOtherFileDate.SelectedDate.Value.AddYears(3).ToShortDateString(); statuteInfo.OtherClaim.FiledDateAfter5yrs = dtOtherFileDate.SelectedDate.Value.AddYears(5).ToShortDateString(); } } BusinessLogic.SaveStatuteInformation(statuteInfo, txtFileNo.Text); } catch (Exception ex) { Helper.LogException(ex); } }
internal static void UpdateStatuteInformationSummary(StatuteInformation statuteInfo, string fileID) { try { SqlParameter pFileID = new SqlParameter(); pFileID.ParameterName = "@FileID"; pFileID.Value = fileID; SqlParameter pDA6MonthsLater = new SqlParameter(); pDA6MonthsLater.ParameterName = "@DA6MonthsLater"; pDA6MonthsLater.Value = statuteInfo.DA6MonthsLater; SqlParameter pSL1YearLater = new SqlParameter(); pSL1YearLater.ParameterName = "@SL1YearLater"; pSL1YearLater.Value = statuteInfo.AccDateAfter1yr; SqlParameter pSL2YearLater = new SqlParameter(); pSL2YearLater.ParameterName = "@SL2YearLater"; pSL2YearLater.Value = statuteInfo.AccDateAfter2yr; SqlParameter pCityFiledDate = new SqlParameter(); pCityFiledDate.ParameterName = "@CityFiledDate"; pCityFiledDate.Value = statuteInfo.CityClaim.FiledDate; SqlParameter pCityRejectedDate = new SqlParameter(); pCityRejectedDate.ParameterName = "@CityRejectedDate"; pCityRejectedDate.Value = statuteInfo.CityClaim.DeniedDate; SqlParameter pCityNextClaimDate = new SqlParameter(); pCityNextClaimDate.ParameterName = "@CityNextClaimDate"; pCityNextClaimDate.Value = statuteInfo.CityClaim.ClaimDueDate; SqlParameter pCountyFiledDate = new SqlParameter(); pCountyFiledDate.ParameterName = "@CountyFiledDate"; pCountyFiledDate.Value = statuteInfo.CountyClaim.FiledDate; SqlParameter pCountyRejectedDate = new SqlParameter(); pCountyRejectedDate.ParameterName = "@CountyRejectedDate"; pCountyRejectedDate.Value = statuteInfo.CountyClaim.DeniedDate; SqlParameter pCountyNextClaimDate = new SqlParameter(); pCountyNextClaimDate.ParameterName = "@CountyNextClaimDate"; pCountyNextClaimDate.Value = statuteInfo.CountyClaim.ClaimDueDate; SqlParameter pStateFiledDate = new SqlParameter(); pStateFiledDate.ParameterName = "@StateFiledDate"; pStateFiledDate.Value = statuteInfo.StateClaim.FiledDate; SqlParameter pStateRejectedDate = new SqlParameter(); pStateRejectedDate.ParameterName = "@StateRejectedDate"; pStateRejectedDate.Value = statuteInfo.StateClaim.DeniedDate; SqlParameter pStateNextClaimDate = new SqlParameter(); pStateNextClaimDate.ParameterName = "@StateNextClaimDate"; pStateNextClaimDate.Value = statuteInfo.StateClaim.ClaimDueDate; SqlParameter pOtherFiledDate = new SqlParameter(); pOtherFiledDate.ParameterName = "@OtherFiledDate"; pOtherFiledDate.Value = statuteInfo.OtherClaim.FiledDate; SqlParameter pOtherRejectedDate = new SqlParameter(); pOtherRejectedDate.ParameterName = "@OtherRejectedDate"; pOtherRejectedDate.Value = statuteInfo.OtherClaim.DeniedDate; SqlParameter pOtherNextClaimDate = new SqlParameter(); pOtherNextClaimDate.ParameterName = "@OtherNextClaimDate"; pOtherNextClaimDate.Value = statuteInfo.OtherClaim.ClaimDueDate; DBHelper.ExecuteStoredProcedure(Constants.UpdateGovtStatuteInformation, pFileID, pDA6MonthsLater, pSL1YearLater,pSL2YearLater, pCityFiledDate, pCityRejectedDate, pCityNextClaimDate,pCountyFiledDate, pCountyRejectedDate, pCountyNextClaimDate, pStateFiledDate, pStateRejectedDate, pStateNextClaimDate, pOtherFiledDate, pOtherRejectedDate, pOtherNextClaimDate); } catch (Exception ex) { Helper.LogException(ex); } }