//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."; }
}
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);
}
protected void UPDATE(object sender, EventArgs e)
{
case_client = case_client_update(Convert.ToInt32(Update_case_client_GridView.SelectedValue));
}
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));
}
protected void Insert_Select_Record(object sender, EventArgs e)
{
case_client = Insert_case_client_select(Convert.ToInt32(Insert_case_client_GridView.SelectedValue));
}
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;
}