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);
}
}