//INSERT
        protected void insert_Click(object sender, EventArgs e)
        {
            try
            {
                address = address_insert();
                person  = person_insert();
                client  = client_insert();
                missing = missing_insert();

                if (Insert_deceasedYes.Checked == true)
                {
                    deceased = deceased_insert();
                }
                case_intake = case_intake_insert();
                case_client = case_client_insert();
                encounter   = encounter_insert();
            }
            catch { Insert_lbl_Client_Error.Text = "There has been an error updating information for the missing client."; }
            finally { Insert_lbl_Client_Error.Text = "The missing client's information has been successfully updated."; }
        }
示例#2
0
 public case_client case_client_update(int ID)
 {
     case_client                                   = case_client.Select(ID);
     case_client.case_id                           = Convert.ToInt32(Update_case_id_txt.Text);
     case_client.client_id                         = Convert.ToInt32(Update_client_id_txt.Text);
     case_client.address_id                        = Convert.ToInt32(Update_address_id_txt.Text);
     case_client.cable_amt_owed_today              = Convert.ToDecimal(Update_cable_amt_owed_today_txt.Text);
     case_client.colessee_name                     = Update_colessee_name_txt.Text;
     case_client.child_support                     = Update_child_support_txt.Text;
     case_client.child_support_memo                = Update_child_support_memo_txt.Text;
     case_client.curr_residence_date               = Convert.ToDateTime(Update_curr_residence_date_txt.Text);
     case_client.electric_amt_owed_today           = Convert.ToDecimal(Update_electric_amt_owed_today_txt.Text);
     case_client.employment_memo                   = Update_employment_memo_txt.Text;
     case_client.employment_status                 = Update_employment_status_txt.Text;
     case_client.gas_or_heating_amt_owed_today     = Convert.ToDecimal(Update_gas_or_heating_amt_owed_today_txt.Text);
     case_client.housing_amt_owed_today            = Convert.ToDecimal(Update_housing_amt_owed_today_txt.Text);
     case_client.housing_status                    = Update_housing_status_txt.Text;
     case_client.income_status                     = Update_income_status_txt.Text;
     case_client.lease_num_adults                  = Convert.ToInt32(Update_lease_num_adults_txt.Text);
     case_client.lease_start_date                  = Convert.ToDateTime(Update_lease_start_date_txt.Text);
     case_client.minor_children                    = Convert.ToInt32(Update_minor_children_txt.Text);
     case_client.monthly_rent_amt                  = Convert.ToDecimal(Update_monthly_rent_amt_txt.Text);
     case_client.Other_help_Sources                = Update_Other_help_Sources_txt.Text;
     case_client.Other_help_Sources_memo           = Update_Other_help_Sources_memo_txt.Text;
     case_client.prev_address_id                   = Convert.ToInt32(Update_prev_address_id_txt.Text);
     case_client.prev_residence_date               = Convert.ToDateTime(Update_prev_residence_date_txt.Text);
     case_client.relationship_to_head_of_household = Update_relationship_to_head_of_household_txt.Text;
     case_client.rental_name                       = Update_rental_name_txt.Text;
     case_client.rental_phone                      = Update_rental_phone_txt.Text;
     case_client.sewage_amt_owed_today             = Convert.ToDecimal(Update_sewage_amt_owed_today_txt.Text);
     case_client.telephone_amt_owed_today          = Convert.ToDecimal(Update_telephone_amt_owed_today_txt.Text);
     case_client.trash_removal_amt_owed_today      = Convert.ToDecimal(Update_trash_removal_amt_owed_today_txt.Text);
     case_client.us_status_memo                    = Update_us_status_memo_txt.Text;
     case_client.related_ll                        = Update_related_ll_txt.Text;
     case_client.relation_to_ll                    = Update_relation_to_ll_txt.Text;
     case_client.mtg_amt_owed_today                = Convert.ToDecimal(Update_mtg_amt_owed_today_txt.Text);
     case_client.utilities_list                    = Update_utilities_list_txt.Text;
     case_client.water_amt_owed_today              = Convert.ToDecimal(Update_water_amt_owed_today_txt.Text);
     case_client.public_asst_app_date              = Convert.ToDateTime(Update_public_asst_app_date_txt.Text);
     case_client.util_allot_app_date               = Convert.ToDateTime(Update_util_allot_app_date_txt.Text);
     case_client.util_allot_amt                    = Convert.ToDecimal(Update_util_allot_amt_txt.Text);
     case_client.utilities_incl                    = Update_utilities_incl_txt.Text;
     case_client.fd_stmps_app_date                 = Convert.ToDateTime(Update_fd_stmps_app_date_txt.Text);
     case_client.fd_stmps_amt                      = Convert.ToDecimal(Update_fd_stmps_amt_txt.Text);
     case_client.fd_Inc                            = Update_fd_Inc_txt.Text;
     case_client.afdc_app_date                     = Convert.ToDateTime(Update_afdc_app_date_txt.Text);
     case_client.afdc_amt                          = Convert.ToDecimal(Update_afdc_amt_txt.Text);
     case_client.afdc_Inc                          = Update_afdc_Inc_txt.Text;
     case_client.oth_trustee_app_date              = Convert.ToDateTime(Update_oth_trustee_app_date_txt.Text);
     case_client.oth_trustee_amt                   = Convert.ToDecimal(Update_oth_trustee_amt_txt.Text);
     case_client.oth_trustee_Inc                   = Update_oth_trustee_Inc_txt.Text;
     case_client.ss_app_date                       = Convert.ToDateTime(Update_ss_app_date_txt.Text);
     case_client.ss_amt                            = Convert.ToDecimal(Update_ss_amt_txt.Text);
     case_client.ss_Inc                            = Update_ss_Inc_txt.Text;
     case_client.va_app_date                       = Convert.ToDateTime(Update_va_app_date_txt.Text);
     case_client.va_amt                            = Convert.ToDecimal(Update_va_amt_txt.Text);
     case_client.va_Inc                            = Update_va_Inc_txt.Text;
     case_client.eap_app_date                      = Convert.ToDateTime(Update_eap_app_date_txt.Text);
     case_client.eap_amt                           = Convert.ToDecimal(Update_eap_amt_txt.Text);
     case_client.eap_Inc                           = Update_eap_Inc_txt.Text;
     case_client.fema_app_date                     = Convert.ToDateTime(Update_fema_app_date_txt.Text);
     case_client.fema_amt                          = Convert.ToDecimal(Update_fema_amt_txt.Text);
     case_client.fema_Inc                          = Update_fema_Inc_txt.Text;
     case_client.unempl_app_date                   = Convert.ToDateTime(Update_unempl_app_date_txt.Text);
     case_client.unempl_amt                        = Convert.ToDecimal(Update_unempl_amt_txt.Text);
     case_client.unempl_Inc                        = Update_unempl_Inc_txt.Text;
     case_client.grants_loans_app_date             = Convert.ToDateTime(Update_grants_loans_app_date_txt.Text);
     case_client.grants_loans_amt                  = Convert.ToDecimal(Update_grants_loans_amt_txt.Text);
     case_client.grants_Inc                        = Update_grants_Inc_txt.Text;
     case_client.other_app_date                    = Convert.ToDateTime(Update_other_app_date_txt.Text);
     case_client.other_amt                         = Convert.ToDecimal(Update_other_amt_txt.Text);
     case_client.other_Inc                         = Update_other_Inc_txt.Text;
     case_client.denial_memo                       = Update_denial_memo_txt.Text;
     case_client.welfr_fraud_memo                  = Update_welfr_fraud_memo_txt.Text;
     case_client.Client_issue_Desc                 = Update_Client_issue_Desc_txt.Text;
     case_client.Client_issue_resolved             = Update_Client_issue_resolved_txt.Text;
     case_client.Client_issue_comments             = Update_Client_issue_comments_txt.Text;
     case_client.Update(case_client);
     Insert_case_client_GridView.DataBind();
     Update_case_client_GridView.DataBind();
     Delete_case_client_GridView.DataBind();
     return(case_client);
 }
示例#3
0
 protected void UPDATE(object sender, EventArgs e)
 {
     case_client = case_client_update(Convert.ToInt32(Update_case_client_GridView.SelectedValue));
 }
示例#4
0
 protected void INSERT(object sender, EventArgs e)
 {
     case_client = case_client_insert();
 }
 public case_client case_client_insert()
 {
     case_client.case_id = case_intake.case_id;
     case_client.client_id = client.client_id ;
     case_client.address_id = address.address_id;
     case_client.cable_amt_owed_today = 0;
     case_client.colessee_name = "";
     case_client.child_support = "X";
     case_client.child_support_memo = "";
     case_client.curr_residence_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.electric_amt_owed_today = 0;
     case_client.employment_memo = "";
     case_client.employment_status = "X";
     case_client.gas_or_heating_amt_owed_today = 0;
     case_client.housing_amt_owed_today = 0;
     case_client.housing_status = "X";
     case_client.income_status = "X";
     case_client.lease_num_adults = 0;
     case_client.lease_start_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.minor_children = 0;
     case_client.monthly_rent_amt = 0;
     case_client.Other_help_Sources = "";
     case_client.Other_help_Sources_memo = "";
     case_client.prev_address_id = 0;
     case_client.prev_residence_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.relationship_to_head_of_household = "X";
     case_client.rental_name = "";
     case_client.rental_phone = "";
     case_client.sewage_amt_owed_today = 0;
     case_client.telephone_amt_owed_today = 0;
     case_client.trash_removal_amt_owed_today = 0;
     case_client.us_status_memo = "";
     case_client.related_ll = "X";
     case_client.relation_to_ll = "X";
     case_client.mtg_amt_owed_today = 0;
     case_client.utilities_list = "";
     case_client.water_amt_owed_today = 0;
     case_client.public_asst_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.util_allot_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.util_allot_amt = 0;
     case_client.utilities_incl = "";
     case_client.fd_stmps_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.fd_stmps_amt = 0;
     case_client.fd_Inc = "";
     case_client.afdc_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.afdc_amt = 0;
     case_client.afdc_Inc = "";
     case_client.oth_trustee_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.oth_trustee_amt = 0;
     case_client.oth_trustee_Inc = "";
     case_client.ss_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.ss_amt = 0;
     case_client.ss_Inc = "";
     case_client.va_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.va_amt = 0;
     case_client.va_Inc = "";
     case_client.eap_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.eap_amt = 0;
     case_client.eap_Inc = "";
     case_client.fema_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.fema_amt = 0;
     case_client.fema_Inc = "";
     case_client.unempl_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.unempl_amt = 0;
     case_client.unempl_Inc = "";
     case_client.grants_loans_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.grants_loans_amt = 0;
     case_client.grants_Inc = "";
     case_client.other_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.other_amt = 0;
     case_client.other_Inc = "";
     case_client.denial_memo = "";
     case_client.welfr_fraud_memo = "";
     case_client.Client_issue_Desc = "";
     case_client.Client_issue_resolved = "";
     case_client.Client_issue_comments = "";
     case_client = case_client.Insert(case_client);
     //GridView1.DataBind();
     return case_client;
 }
        //INSERT
        protected void insert_Click(object sender, EventArgs e)
        {
            try
            {
                address = address_insert();
                person = person_insert();
                client = client_insert();
                missing = missing_insert();

                if (Insert_deceasedYes.Checked == true)
                {
                    deceased = deceased_insert();
                }
                case_intake = case_intake_insert();
                case_client = case_client_insert();
                encounter = encounter_insert();
            }
            catch { Insert_lbl_Client_Error.Text = "There has been an error updating information for the missing client."; }
            finally { Insert_lbl_Client_Error.Text = "The missing client's information has been successfully updated."; }
        }
        //case search gridview
        protected void Insert_GVcases_SelectedIndexChanged(object sender, EventArgs e)
        {
            case_intake = case_intake.Select(Convert.ToInt32(Insert_GVcases.SelectedDataKey.Value));
            case_client = case_client.Select(Convert.ToInt32(Insert_GVcases.SelectedDataKey.Value), Convert.ToInt32(GlobalVariables.PersonID));

            GlobalVariables.CaseID = case_client.case_id;
            GlobalVariables.ClientID = case_client.client_id;
        }
 protected void INSERT(object sender, EventArgs e)
 {
     case_client = case_client_insert();
 }
 public case_client case_client_insert()
 {
     case_client.case_id                           = case_intake.case_id;
     case_client.client_id                         = client.client_id;
     case_client.address_id                        = address.address_id;
     case_client.cable_amt_owed_today              = 0;
     case_client.colessee_name                     = "";
     case_client.child_support                     = "X";
     case_client.child_support_memo                = "";
     case_client.curr_residence_date               = Convert.ToDateTime("1 / 1 / 1900");
     case_client.electric_amt_owed_today           = 0;
     case_client.employment_memo                   = "";
     case_client.employment_status                 = "X";
     case_client.gas_or_heating_amt_owed_today     = 0;
     case_client.housing_amt_owed_today            = 0;
     case_client.housing_status                    = "X";
     case_client.income_status                     = "X";
     case_client.lease_num_adults                  = 0;
     case_client.lease_start_date                  = Convert.ToDateTime("1 / 1 / 1900");
     case_client.minor_children                    = 0;
     case_client.monthly_rent_amt                  = 0;
     case_client.Other_help_Sources                = "";
     case_client.Other_help_Sources_memo           = "";
     case_client.prev_address_id                   = 0;
     case_client.prev_residence_date               = Convert.ToDateTime("1 / 1 / 1900");
     case_client.relationship_to_head_of_household = "X";
     case_client.rental_name                       = "";
     case_client.rental_phone                      = "";
     case_client.sewage_amt_owed_today             = 0;
     case_client.telephone_amt_owed_today          = 0;
     case_client.trash_removal_amt_owed_today      = 0;
     case_client.us_status_memo                    = "";
     case_client.related_ll                        = "X";
     case_client.relation_to_ll                    = "X";
     case_client.mtg_amt_owed_today                = 0;
     case_client.utilities_list                    = "";
     case_client.water_amt_owed_today              = 0;
     case_client.public_asst_app_date              = Convert.ToDateTime("1 / 1 / 1900");
     case_client.util_allot_app_date               = Convert.ToDateTime("1 / 1 / 1900");
     case_client.util_allot_amt                    = 0;
     case_client.utilities_incl                    = "";
     case_client.fd_stmps_app_date                 = Convert.ToDateTime("1 / 1 / 1900");
     case_client.fd_stmps_amt                      = 0;
     case_client.fd_Inc                = "";
     case_client.afdc_app_date         = Convert.ToDateTime("1 / 1 / 1900");
     case_client.afdc_amt              = 0;
     case_client.afdc_Inc              = "";
     case_client.oth_trustee_app_date  = Convert.ToDateTime("1 / 1 / 1900");
     case_client.oth_trustee_amt       = 0;
     case_client.oth_trustee_Inc       = "";
     case_client.ss_app_date           = Convert.ToDateTime("1 / 1 / 1900");
     case_client.ss_amt                = 0;
     case_client.ss_Inc                = "";
     case_client.va_app_date           = Convert.ToDateTime("1 / 1 / 1900");
     case_client.va_amt                = 0;
     case_client.va_Inc                = "";
     case_client.eap_app_date          = Convert.ToDateTime("1 / 1 / 1900");
     case_client.eap_amt               = 0;
     case_client.eap_Inc               = "";
     case_client.fema_app_date         = Convert.ToDateTime("1 / 1 / 1900");
     case_client.fema_amt              = 0;
     case_client.fema_Inc              = "";
     case_client.unempl_app_date       = Convert.ToDateTime("1 / 1 / 1900");
     case_client.unempl_amt            = 0;
     case_client.unempl_Inc            = "";
     case_client.grants_loans_app_date = Convert.ToDateTime("1 / 1 / 1900");
     case_client.grants_loans_amt      = 0;
     case_client.grants_Inc            = "";
     case_client.other_app_date        = Convert.ToDateTime("1 / 1 / 1900");
     case_client.other_amt             = 0;
     case_client.other_Inc             = "";
     case_client.denial_memo           = "";
     case_client.welfr_fraud_memo      = "";
     case_client.Client_issue_Desc     = "";
     case_client.Client_issue_resolved = "";
     case_client.Client_issue_comments = "";
     case_client = case_client.Insert(case_client);
     //GridView1.DataBind();
     return(case_client);
 }
        protected void Save_Case_information()
        {
            clientCase_intake.SetColumnDefaults();
            clientcase.SetColumnDefaults();

            clientCase_intake.circum_no_income = Convert.ToString(CbNoIncome.Checked);
            clientCase_intake.circum_not_enough_income = Convert.ToString(CbNotenoughIncome.Checked);
            clientCase_intake.circum_income_stolen = Convert.ToString(CbStolanincome.Checked);
            clientCase_intake.circum_emergency_event = Convert.ToString(CBEmgEvent.Checked);
            clientCase_intake.circum_memo = txt_Circum_Memo.Text;
            clientCase_intake.circum_help_request_memo = txt_Circum_Help_Request_Memo.Text;
            clientCase_intake.applic_start_date_time = DateTime.Now;
            clientCase_intake.applic_end_date_time = DateTime.MaxValue;
            clientCase_intake.call_center_id = Convert.ToInt32(DDL_Call_Center.SelectedValue);
            clientCase_intake.case_id = GlobalVariables.CaseID;
            clientcase.case_id = GlobalVariables.CaseID;
            clientcase.client_id = GlobalVariables.ClientID;
            clientcase.address_id = GlobalVariables.ClientAddressID;

            if (clientCase_intake.case_id == 0)
            {
                clientCase_intake = clientCase_intake.Insert(clientCase_intake);
            }
            else
            {
                clientCase_intake.Update(clientCase_intake);
            }

            clientcase.housing_status = ddlHousingStatus.SelectedValue;
            clientcase.income_status = ddlIncomeStatus.SelectedValue;
            clientcase.employment_status = ddlEmpStatus.SelectedValue;
            clientcase.welfr_fraud_memo = txt_welfr_fraud_memo.Text;
            clientcase.denial_memo = txt_AFDC_denial_memo.Text;

            if (TxtCurr_addr_date_ocup.Text != "")
            {
                clientcase.curr_residence_date = Convert.ToDateTime(TxtCurr_addr_date_ocup.Text);
            }

            if (TxtPrev_addr_date_ocup.Text != "")
            {
                clientcase.prev_residence_date = Convert.ToDateTime(TxtPrev_addr_date_ocup.Text);
            }

            if (TxtutilallAmt.Text != "")
            {
                clientcase.util_allot_amt = Convert.ToDecimal(TxtutilallAmt.Text);
            }

            if (TxtutilallDate.Text != "")
            {
                clientcase.util_allot_app_date = Convert.ToDateTime(TxtutilallDate.Text);
            }
            clientcase.utilities_incl = ddlUtilall.SelectedValue;

            if (TxtFoodstmpAmt.Text != "")
            {
                clientcase.fd_stmps_amt = Convert.ToDecimal(TxtFoodstmpAmt.Text);
            }

            if (TxtFoodstmpDate.Text != "")
            {
                clientcase.fd_stmps_app_date = Convert.ToDateTime(TxtFoodstmpDate.Text);
            }
            clientcase.fd_Inc = ddlFoodstmp.SelectedValue;

            if (TxtAFDCAmt.Text != "")
            {
                clientcase.afdc_amt = Convert.ToDecimal(TxtAFDCAmt.Text);
            }

            if (TxtAFDCDate.Text != "")
            {
                clientcase.afdc_app_date = Convert.ToDateTime(TxtAFDCDate.Text);
            }
            clientcase.afdc_Inc = ddlAFDC.SelectedValue;

            if (TxtTrustOffAmt.Text != "")
            {
                clientcase.oth_trustee_amt = Convert.ToDecimal(TxtTrustOffAmt.Text);
            }

            if (TxtTrustOffDate.Text != "")
            {
                clientcase.oth_trustee_app_date = Convert.ToDateTime(TxtTrustOffDate.Text);
            }
            clientcase.oth_trustee_Inc = ddlOtherhelp.SelectedValue;
            if (txtssAmt.Text != "")
            {
                clientcase.ss_amt = Convert.ToDecimal(txtssAmt.Text);
            }
            if (txtssDate.Text != "")
            {
                clientcase.ss_app_date = Convert.ToDateTime(txtssDate.Text);
            }
            clientcase.ss_Inc = ddlSS.SelectedValue;
            if (txtVAAmt.Text != "")
            {
                clientcase.va_amt = Convert.ToDecimal(txtVAAmt.Text);
            }
            if (TxtutilallDate.Text != "")
            {
                clientcase.va_app_date = Convert.ToDateTime(TxtutilallDate.Text);
            }
            clientcase.va_Inc = ddlVA.SelectedValue;
            if (txtEAPAmt.Text != "")
            {
                clientcase.eap_amt = Convert.ToDecimal(txtEAPAmt.Text);
            }
            if (txtEAPDate.Text != "")
            {
                clientcase.eap_app_date = Convert.ToDateTime(txtEAPDate.Text);
            }
            clientcase.eap_Inc = ddlEAP.SelectedValue;
            if (TxtFemaAmt.Text != "")
            {
                clientcase.fema_amt = Convert.ToDecimal(TxtFemaAmt.Text);
            }
            if (TxtFEMADate.Text != "")
            {
                clientcase.fema_app_date = Convert.ToDateTime(TxtFEMADate.Text);
            }
            clientcase.fema_Inc = ddlFema.SelectedValue;
            if (txtUnemplAmt.Text != "")
            {
                clientcase.unempl_amt = Convert.ToDecimal(txtUnemplAmt.Text);
            }
            if (txtUnemplDate.Text != "")
            {
                clientcase.unempl_app_date = Convert.ToDateTime(txtUnemplDate.Text);
            }
            clientcase.unempl_Inc = ddlUnemployment.SelectedValue;
            if (txtGrantLoanAmt.Text != "")
            {
                clientcase.grants_loans_amt = Convert.ToDecimal(txtGrantLoanAmt.Text);
            }
            if (txtGrantLoanDate.Text != "")
            {
                clientcase.grants_loans_app_date = Convert.ToDateTime(txtGrantLoanDate.Text);
            }
            clientcase.grants_Inc = ddlGrantloan.SelectedValue;
            if (TxtotherhelpAmt.Text != "")
            {
                clientcase.other_amt = Convert.ToDecimal(TxtotherhelpAmt.Text);
            }
            if (TxtotherhelpDate.Text != "")
            {
                clientcase.other_app_date = Convert.ToDateTime(TxtotherhelpDate.Text);
            }
            clientcase.other_Inc = ddlOtherhelp.SelectedValue;
            if (txt_Mtg_Amt_Owed_Today.Text != "")
            {
                clientcase.mtg_amt_owed_today = Convert.ToDecimal(txt_Mtg_Amt_Owed_Today.Text);
            }
            if (txt_Electric_Amt_Owed_Today.Text != "")
            {
                clientcase.electric_amt_owed_today = Convert.ToDecimal(txt_Electric_Amt_Owed_Today.Text);
            }
            if (txt_Gas_or_Heating_Amt_Owed_Today.Text != "")
            {
                clientcase.gas_or_heating_amt_owed_today = Convert.ToDecimal(txt_Gas_or_Heating_Amt_Owed_Today.Text);
            }
            if (txt_Water_Amt_Owed_Today.Text != "")
            {
                clientcase.water_amt_owed_today = Convert.ToDecimal(txt_Water_Amt_Owed_Today.Text);
            }
            if (txt_Cable_Amt_Owed_Today.Text != "")
            {
                clientcase.cable_amt_owed_today = Convert.ToDecimal(txt_Cable_Amt_Owed_Today.Text);
            }
            if (txt_Telephone_Amt_Owed_Today.Text != "")
            {
                clientcase.telephone_amt_owed_today = Convert.ToDecimal(txt_Telephone_Amt_Owed_Today.Text);
            }
            if (txt_Sewage_Amt_Owed_Today.Text != "")
            {
                clientcase.sewage_amt_owed_today = Convert.ToDecimal(txt_Sewage_Amt_Owed_Today.Text);
            }
            if (txt_Trash_Removal_Amt_Owed_Today.Text != "")
            {
                clientcase.trash_removal_amt_owed_today = Convert.ToDecimal(txt_Trash_Removal_Amt_Owed_Today.Text);
            }

            if (clientcase.case_id == 0 && clientcase.client_id == 0)
            {
                clientcase.client_id = clientperson.person_id;
                clientcase.case_id = clientCase_intake.case_id;
                clientcase.address_id = clientAddress.address_id;
                clientcase = clientcase.Insert(clientcase);
            }
            else
            {
                clientcase.Update(clientcase);
            }
        }
        protected void GVcases_SelectedIndexChanged(object sender, EventArgs e)
        {
            clientCase_intake = clientCase_intake.Select(Convert.ToInt32(GVcases.SelectedDataKey.Value));
            clientcase = clientcase.Select(Convert.ToInt32(GVcases.SelectedDataKey.Value), Convert.ToInt32(GlobalVariables.PersonID));

            GlobalVariables.CaseID = clientcase.case_id;
            GlobalVariables.ClientID = clientcase.client_id;

            fill_Case_information();
            fill_pet_info();
            fill_employer_info();
            fill_Income_info();
            Fill_Expense_info();
            Fill_vehicle_info();
            fill_military_info();
            Fill_Debt_info();
            fill_Disaster_encouter();
        }
 protected void Update_Select_Record(object sender, EventArgs e)
 {
     case_client = Update_case_client_select(Convert.ToInt32(Update_case_client_GridView.SelectedValue));
 }
 public case_client case_client_insert()
 {
     case_client.client_id = Convert.ToInt32(Insert_client_id_txt.Text);
     case_client.address_id = Convert.ToInt32(Insert_address_id_txt.Text);
     case_client.cable_amt_owed_today = Convert.ToDecimal(Insert_cable_amt_owed_today_txt.Text);
     case_client.colessee_name = Insert_colessee_name_txt.Text;
     case_client.child_support = Insert_child_support_txt.Text;
     case_client.child_support_memo = Insert_child_support_memo_txt.Text;
     case_client.curr_residence_date = Convert.ToDateTime(Insert_curr_residence_date_txt.Text);
     case_client.electric_amt_owed_today = Convert.ToDecimal(Insert_electric_amt_owed_today_txt.Text);
     case_client.employment_memo = Insert_employment_memo_txt.Text;
     case_client.employment_status = Insert_employment_status_txt.Text;
     case_client.gas_or_heating_amt_owed_today = Convert.ToDecimal(Insert_gas_or_heating_amt_owed_today_txt.Text);
     case_client.housing_amt_owed_today = Convert.ToDecimal(Insert_housing_amt_owed_today_txt.Text);
     case_client.housing_status = Insert_housing_status_txt.Text;
     case_client.income_status = Insert_income_status_txt.Text;
     case_client.lease_num_adults = Convert.ToInt32(Insert_lease_num_adults_txt.Text);
     case_client.lease_start_date = Convert.ToDateTime(Insert_lease_start_date_txt.Text);
     case_client.minor_children = Convert.ToInt32(Insert_minor_children_txt.Text);
     case_client.monthly_rent_amt = Convert.ToDecimal(Insert_monthly_rent_amt_txt.Text);
     case_client.Other_help_Sources = Insert_Other_help_Sources_txt.Text;
     case_client.Other_help_Sources_memo = Insert_Other_help_Sources_memo_txt.Text;
     case_client.prev_address_id = Convert.ToInt32(Insert_prev_address_id_txt.Text);
     case_client.prev_residence_date = Convert.ToDateTime(Insert_prev_residence_date_txt.Text);
     case_client.relationship_to_head_of_household = Insert_relationship_to_head_of_household_txt.Text;
     case_client.rental_name = Insert_rental_name_txt.Text;
     case_client.rental_phone = Insert_rental_phone_txt.Text;
     case_client.sewage_amt_owed_today = Convert.ToDecimal(Insert_sewage_amt_owed_today_txt.Text);
     case_client.telephone_amt_owed_today = Convert.ToDecimal(Insert_telephone_amt_owed_today_txt.Text);
     case_client.trash_removal_amt_owed_today = Convert.ToDecimal(Insert_trash_removal_amt_owed_today_txt.Text);
     case_client.us_status_memo = Insert_us_status_memo_txt.Text;
     case_client.related_ll = Insert_related_ll_txt.Text;
     case_client.relation_to_ll = Insert_relation_to_ll_txt.Text;
     case_client.mtg_amt_owed_today = Convert.ToDecimal(Insert_mtg_amt_owed_today_txt.Text);
     case_client.utilities_list = Insert_utilities_list_txt.Text;
     case_client.water_amt_owed_today = Convert.ToDecimal(Insert_water_amt_owed_today_txt.Text);
     case_client.public_asst_app_date = Convert.ToDateTime(Insert_public_asst_app_date_txt.Text);
     case_client.util_allot_app_date = Convert.ToDateTime(Insert_util_allot_app_date_txt.Text);
     case_client.util_allot_amt = Convert.ToDecimal(Insert_util_allot_amt_txt.Text);
     case_client.utilities_incl = Insert_utilities_incl_txt.Text;
     case_client.fd_stmps_app_date = Convert.ToDateTime(Insert_fd_stmps_app_date_txt.Text);
     case_client.fd_stmps_amt = Convert.ToDecimal(Insert_fd_stmps_amt_txt.Text);
     case_client.fd_Inc = Insert_fd_Inc_txt.Text;
     case_client.afdc_app_date = Convert.ToDateTime(Insert_afdc_app_date_txt.Text);
     case_client.afdc_amt = Convert.ToDecimal(Insert_afdc_amt_txt.Text);
     case_client.afdc_Inc = Insert_afdc_Inc_txt.Text;
     case_client.oth_trustee_app_date = Convert.ToDateTime(Insert_oth_trustee_app_date_txt.Text);
     case_client.oth_trustee_amt = Convert.ToDecimal(Insert_oth_trustee_amt_txt.Text);
     case_client.oth_trustee_Inc = Insert_oth_trustee_Inc_txt.Text;
     case_client.ss_app_date = Convert.ToDateTime(Insert_ss_app_date_txt.Text);
     case_client.ss_amt = Convert.ToDecimal(Insert_ss_amt_txt.Text);
     case_client.ss_Inc = Insert_ss_Inc_txt.Text;
     case_client.va_app_date = Convert.ToDateTime(Insert_va_app_date_txt.Text);
     case_client.va_amt = Convert.ToDecimal(Insert_va_amt_txt.Text);
     case_client.va_Inc = Insert_va_Inc_txt.Text;
     case_client.eap_app_date = Convert.ToDateTime(Insert_eap_app_date_txt.Text);
     case_client.eap_amt = Convert.ToDecimal(Insert_eap_amt_txt.Text);
     case_client.eap_Inc = Insert_eap_Inc_txt.Text;
     case_client.fema_app_date = Convert.ToDateTime(Insert_fema_app_date_txt.Text);
     case_client.fema_amt = Convert.ToDecimal(Insert_fema_amt_txt.Text);
     case_client.fema_Inc = Insert_fema_Inc_txt.Text;
     case_client.unempl_app_date = Convert.ToDateTime(Insert_unempl_app_date_txt.Text);
     case_client.unempl_amt = Convert.ToDecimal(Insert_unempl_amt_txt.Text);
     case_client.unempl_Inc = Insert_unempl_Inc_txt.Text;
     case_client.grants_loans_app_date = Convert.ToDateTime(Insert_grants_loans_app_date_txt.Text);
     case_client.grants_loans_amt = Convert.ToDecimal(Insert_grants_loans_amt_txt.Text);
     case_client.grants_Inc = Insert_grants_Inc_txt.Text;
     case_client.other_app_date = Convert.ToDateTime(Insert_other_app_date_txt.Text);
     case_client.other_amt = Convert.ToDecimal(Insert_other_amt_txt.Text);
     case_client.other_Inc = Insert_other_Inc_txt.Text;
     case_client.denial_memo = Insert_denial_memo_txt.Text;
     case_client.welfr_fraud_memo = Insert_welfr_fraud_memo_txt.Text;
     case_client.Client_issue_Desc = Insert_Client_issue_Desc_txt.Text;
     case_client.Client_issue_resolved = Insert_Client_issue_resolved_txt.Text;
     case_client.Client_issue_comments = Insert_Client_issue_comments_txt.Text;
     case_client = case_client.Insert(case_client);
     Insert_case_client_GridView.DataBind();
     Update_case_client_GridView.DataBind();
     Delete_case_client_GridView.DataBind();
     return case_client;
 }
 protected void UPDATE(object sender, EventArgs e)
 {
     case_client = case_client_update(Convert.ToInt32(Update_case_client_GridView.SelectedValue));
 }
示例#15
0
 protected void Insert_Select_Record(object sender, EventArgs e)
 {
     case_client = Insert_case_client_select(Convert.ToInt32(Insert_case_client_GridView.SelectedValue));
 }
示例#16
0
 public case_client Insert_case_client_select(int ID)
 {
     case_client = case_client.Select(ID);
     Insert_client_id_txt.Text                         = Convert.ToString(case_client.client_id);
     Insert_address_id_txt.Text                        = Convert.ToString(case_client.address_id);
     Insert_cable_amt_owed_today_txt.Text              = Convert.ToString(case_client.cable_amt_owed_today);
     Insert_colessee_name_txt.Text                     = Convert.ToString(case_client.colessee_name);
     Insert_child_support_txt.Text                     = Convert.ToString(case_client.child_support);
     Insert_child_support_memo_txt.Text                = Convert.ToString(case_client.child_support_memo);
     Insert_curr_residence_date_txt.Text               = Convert.ToString(case_client.curr_residence_date);
     Insert_electric_amt_owed_today_txt.Text           = Convert.ToString(case_client.electric_amt_owed_today);
     Insert_employment_memo_txt.Text                   = Convert.ToString(case_client.employment_memo);
     Insert_employment_status_txt.Text                 = Convert.ToString(case_client.employment_status);
     Insert_gas_or_heating_amt_owed_today_txt.Text     = Convert.ToString(case_client.gas_or_heating_amt_owed_today);
     Insert_housing_amt_owed_today_txt.Text            = Convert.ToString(case_client.housing_amt_owed_today);
     Insert_housing_status_txt.Text                    = Convert.ToString(case_client.housing_status);
     Insert_income_status_txt.Text                     = Convert.ToString(case_client.income_status);
     Insert_lease_num_adults_txt.Text                  = Convert.ToString(case_client.lease_num_adults);
     Insert_lease_start_date_txt.Text                  = Convert.ToString(case_client.lease_start_date);
     Insert_minor_children_txt.Text                    = Convert.ToString(case_client.minor_children);
     Insert_monthly_rent_amt_txt.Text                  = Convert.ToString(case_client.monthly_rent_amt);
     Insert_Other_help_Sources_txt.Text                = Convert.ToString(case_client.Other_help_Sources);
     Insert_Other_help_Sources_memo_txt.Text           = Convert.ToString(case_client.Other_help_Sources_memo);
     Insert_prev_address_id_txt.Text                   = Convert.ToString(case_client.prev_address_id);
     Insert_prev_residence_date_txt.Text               = Convert.ToString(case_client.prev_residence_date);
     Insert_relationship_to_head_of_household_txt.Text = Convert.ToString(case_client.relationship_to_head_of_household);
     Insert_rental_name_txt.Text                       = Convert.ToString(case_client.rental_name);
     Insert_rental_phone_txt.Text                      = Convert.ToString(case_client.rental_phone);
     Insert_sewage_amt_owed_today_txt.Text             = Convert.ToString(case_client.sewage_amt_owed_today);
     Insert_telephone_amt_owed_today_txt.Text          = Convert.ToString(case_client.telephone_amt_owed_today);
     Insert_trash_removal_amt_owed_today_txt.Text      = Convert.ToString(case_client.trash_removal_amt_owed_today);
     Insert_us_status_memo_txt.Text                    = Convert.ToString(case_client.us_status_memo);
     Insert_related_ll_txt.Text                        = Convert.ToString(case_client.related_ll);
     Insert_relation_to_ll_txt.Text                    = Convert.ToString(case_client.relation_to_ll);
     Insert_mtg_amt_owed_today_txt.Text                = Convert.ToString(case_client.mtg_amt_owed_today);
     Insert_utilities_list_txt.Text                    = Convert.ToString(case_client.utilities_list);
     Insert_water_amt_owed_today_txt.Text              = Convert.ToString(case_client.water_amt_owed_today);
     Insert_public_asst_app_date_txt.Text              = Convert.ToString(case_client.public_asst_app_date);
     Insert_util_allot_app_date_txt.Text               = Convert.ToString(case_client.util_allot_app_date);
     Insert_util_allot_amt_txt.Text                    = Convert.ToString(case_client.util_allot_amt);
     Insert_utilities_incl_txt.Text                    = Convert.ToString(case_client.utilities_incl);
     Insert_fd_stmps_app_date_txt.Text                 = Convert.ToString(case_client.fd_stmps_app_date);
     Insert_fd_stmps_amt_txt.Text                      = Convert.ToString(case_client.fd_stmps_amt);
     Insert_fd_Inc_txt.Text                = Convert.ToString(case_client.fd_Inc);
     Insert_afdc_app_date_txt.Text         = Convert.ToString(case_client.afdc_app_date);
     Insert_afdc_amt_txt.Text              = Convert.ToString(case_client.afdc_amt);
     Insert_afdc_Inc_txt.Text              = Convert.ToString(case_client.afdc_Inc);
     Insert_oth_trustee_app_date_txt.Text  = Convert.ToString(case_client.oth_trustee_app_date);
     Insert_oth_trustee_amt_txt.Text       = Convert.ToString(case_client.oth_trustee_amt);
     Insert_oth_trustee_Inc_txt.Text       = Convert.ToString(case_client.oth_trustee_Inc);
     Insert_ss_app_date_txt.Text           = Convert.ToString(case_client.ss_app_date);
     Insert_ss_amt_txt.Text                = Convert.ToString(case_client.ss_amt);
     Insert_ss_Inc_txt.Text                = Convert.ToString(case_client.ss_Inc);
     Insert_va_app_date_txt.Text           = Convert.ToString(case_client.va_app_date);
     Insert_va_amt_txt.Text                = Convert.ToString(case_client.va_amt);
     Insert_va_Inc_txt.Text                = Convert.ToString(case_client.va_Inc);
     Insert_eap_app_date_txt.Text          = Convert.ToString(case_client.eap_app_date);
     Insert_eap_amt_txt.Text               = Convert.ToString(case_client.eap_amt);
     Insert_eap_Inc_txt.Text               = Convert.ToString(case_client.eap_Inc);
     Insert_fema_app_date_txt.Text         = Convert.ToString(case_client.fema_app_date);
     Insert_fema_amt_txt.Text              = Convert.ToString(case_client.fema_amt);
     Insert_fema_Inc_txt.Text              = Convert.ToString(case_client.fema_Inc);
     Insert_unempl_app_date_txt.Text       = Convert.ToString(case_client.unempl_app_date);
     Insert_unempl_amt_txt.Text            = Convert.ToString(case_client.unempl_amt);
     Insert_unempl_Inc_txt.Text            = Convert.ToString(case_client.unempl_Inc);
     Insert_grants_loans_app_date_txt.Text = Convert.ToString(case_client.grants_loans_app_date);
     Insert_grants_loans_amt_txt.Text      = Convert.ToString(case_client.grants_loans_amt);
     Insert_grants_Inc_txt.Text            = Convert.ToString(case_client.grants_Inc);
     Insert_other_app_date_txt.Text        = Convert.ToString(case_client.other_app_date);
     Insert_other_amt_txt.Text             = Convert.ToString(case_client.other_amt);
     Insert_other_Inc_txt.Text             = Convert.ToString(case_client.other_Inc);
     Insert_denial_memo_txt.Text           = Convert.ToString(case_client.denial_memo);
     Insert_welfr_fraud_memo_txt.Text      = Convert.ToString(case_client.welfr_fraud_memo);
     Insert_Client_issue_Desc_txt.Text     = Convert.ToString(case_client.Client_issue_Desc);
     Insert_Client_issue_resolved_txt.Text = Convert.ToString(case_client.Client_issue_resolved);
     Insert_Client_issue_comments_txt.Text = Convert.ToString(case_client.Client_issue_comments);
     return(case_client);
 }
 public case_client Update_case_client_select(int ID)
 {
     case_client = case_client.Select(ID);
     Update_case_id_txt.Text = Convert.ToString(case_client.case_id);
     Update_client_id_txt.Text = Convert.ToString(case_client.client_id);
     Update_address_id_txt.Text = Convert.ToString(case_client.address_id);
     Update_cable_amt_owed_today_txt.Text = Convert.ToString(case_client.cable_amt_owed_today);
     Update_colessee_name_txt.Text = Convert.ToString(case_client.colessee_name);
     Update_child_support_txt.Text = Convert.ToString(case_client.child_support);
     Update_child_support_memo_txt.Text = Convert.ToString(case_client.child_support_memo);
     Update_curr_residence_date_txt.Text = Convert.ToString(case_client.curr_residence_date);
     Update_electric_amt_owed_today_txt.Text = Convert.ToString(case_client.electric_amt_owed_today);
     Update_employment_memo_txt.Text = Convert.ToString(case_client.employment_memo);
     Update_employment_status_txt.Text = Convert.ToString(case_client.employment_status);
     Update_gas_or_heating_amt_owed_today_txt.Text = Convert.ToString(case_client.gas_or_heating_amt_owed_today);
     Update_housing_amt_owed_today_txt.Text = Convert.ToString(case_client.housing_amt_owed_today);
     Update_housing_status_txt.Text = Convert.ToString(case_client.housing_status);
     Update_income_status_txt.Text = Convert.ToString(case_client.income_status);
     Update_lease_num_adults_txt.Text = Convert.ToString(case_client.lease_num_adults);
     Update_lease_start_date_txt.Text = Convert.ToString(case_client.lease_start_date);
     Update_minor_children_txt.Text = Convert.ToString(case_client.minor_children);
     Update_monthly_rent_amt_txt.Text = Convert.ToString(case_client.monthly_rent_amt);
     Update_Other_help_Sources_txt.Text = Convert.ToString(case_client.Other_help_Sources);
     Update_Other_help_Sources_memo_txt.Text = Convert.ToString(case_client.Other_help_Sources_memo);
     Update_prev_address_id_txt.Text = Convert.ToString(case_client.prev_address_id);
     Update_prev_residence_date_txt.Text = Convert.ToString(case_client.prev_residence_date);
     Update_relationship_to_head_of_household_txt.Text = Convert.ToString(case_client.relationship_to_head_of_household);
     Update_rental_name_txt.Text = Convert.ToString(case_client.rental_name);
     Update_rental_phone_txt.Text = Convert.ToString(case_client.rental_phone);
     Update_sewage_amt_owed_today_txt.Text = Convert.ToString(case_client.sewage_amt_owed_today);
     Update_telephone_amt_owed_today_txt.Text = Convert.ToString(case_client.telephone_amt_owed_today);
     Update_trash_removal_amt_owed_today_txt.Text = Convert.ToString(case_client.trash_removal_amt_owed_today);
     Update_us_status_memo_txt.Text = Convert.ToString(case_client.us_status_memo);
     Update_related_ll_txt.Text = Convert.ToString(case_client.related_ll);
     Update_relation_to_ll_txt.Text = Convert.ToString(case_client.relation_to_ll);
     Update_mtg_amt_owed_today_txt.Text = Convert.ToString(case_client.mtg_amt_owed_today);
     Update_utilities_list_txt.Text = Convert.ToString(case_client.utilities_list);
     Update_water_amt_owed_today_txt.Text = Convert.ToString(case_client.water_amt_owed_today);
     Update_public_asst_app_date_txt.Text = Convert.ToString(case_client.public_asst_app_date);
     Update_util_allot_app_date_txt.Text = Convert.ToString(case_client.util_allot_app_date);
     Update_util_allot_amt_txt.Text = Convert.ToString(case_client.util_allot_amt);
     Update_utilities_incl_txt.Text = Convert.ToString(case_client.utilities_incl);
     Update_fd_stmps_app_date_txt.Text = Convert.ToString(case_client.fd_stmps_app_date);
     Update_fd_stmps_amt_txt.Text = Convert.ToString(case_client.fd_stmps_amt);
     Update_fd_Inc_txt.Text = Convert.ToString(case_client.fd_Inc);
     Update_afdc_app_date_txt.Text = Convert.ToString(case_client.afdc_app_date);
     Update_afdc_amt_txt.Text = Convert.ToString(case_client.afdc_amt);
     Update_afdc_Inc_txt.Text = Convert.ToString(case_client.afdc_Inc);
     Update_oth_trustee_app_date_txt.Text = Convert.ToString(case_client.oth_trustee_app_date);
     Update_oth_trustee_amt_txt.Text = Convert.ToString(case_client.oth_trustee_amt);
     Update_oth_trustee_Inc_txt.Text = Convert.ToString(case_client.oth_trustee_Inc);
     Update_ss_app_date_txt.Text = Convert.ToString(case_client.ss_app_date);
     Update_ss_amt_txt.Text = Convert.ToString(case_client.ss_amt);
     Update_ss_Inc_txt.Text = Convert.ToString(case_client.ss_Inc);
     Update_va_app_date_txt.Text = Convert.ToString(case_client.va_app_date);
     Update_va_amt_txt.Text = Convert.ToString(case_client.va_amt);
     Update_va_Inc_txt.Text = Convert.ToString(case_client.va_Inc);
     Update_eap_app_date_txt.Text = Convert.ToString(case_client.eap_app_date);
     Update_eap_amt_txt.Text = Convert.ToString(case_client.eap_amt);
     Update_eap_Inc_txt.Text = Convert.ToString(case_client.eap_Inc);
     Update_fema_app_date_txt.Text = Convert.ToString(case_client.fema_app_date);
     Update_fema_amt_txt.Text = Convert.ToString(case_client.fema_amt);
     Update_fema_Inc_txt.Text = Convert.ToString(case_client.fema_Inc);
     Update_unempl_app_date_txt.Text = Convert.ToString(case_client.unempl_app_date);
     Update_unempl_amt_txt.Text = Convert.ToString(case_client.unempl_amt);
     Update_unempl_Inc_txt.Text = Convert.ToString(case_client.unempl_Inc);
     Update_grants_loans_app_date_txt.Text = Convert.ToString(case_client.grants_loans_app_date);
     Update_grants_loans_amt_txt.Text = Convert.ToString(case_client.grants_loans_amt);
     Update_grants_Inc_txt.Text = Convert.ToString(case_client.grants_Inc);
     Update_other_app_date_txt.Text = Convert.ToString(case_client.other_app_date);
     Update_other_amt_txt.Text = Convert.ToString(case_client.other_amt);
     Update_other_Inc_txt.Text = Convert.ToString(case_client.other_Inc);
     Update_denial_memo_txt.Text = Convert.ToString(case_client.denial_memo);
     Update_welfr_fraud_memo_txt.Text = Convert.ToString(case_client.welfr_fraud_memo);
     Update_Client_issue_Desc_txt.Text = Convert.ToString(case_client.Client_issue_Desc);
     Update_Client_issue_resolved_txt.Text = Convert.ToString(case_client.Client_issue_resolved);
     Update_Client_issue_comments_txt.Text = Convert.ToString(case_client.Client_issue_comments);
     return case_client;
 }