Example #1
0
        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);
            }
        }