//////////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////// //database insert methods public case_intake case_intake_insert() { case_intake.applic_end_date_time = Convert.ToDateTime(9/9/9);//null case_intake.applic_start_date_time = DateTime.Now; case_intake.circum_emergency_event = "N/A"; case_intake.circum_help_request_memo = "N/A"; case_intake.circum_income_stolen = "N/A"; case_intake.circum_memo = "Warehouse to warehouse order"; case_intake.circum_no_income = "N/A"; case_intake.circum_not_enough_income = "N/A"; case_intake.agency_id = 0;//null case_intake.call_center_id = Convert.ToInt32(DDL_Call_Center.SelectedValue); case_intake = case_intake.Insert(case_intake); return case_intake; }
public case_intake Insert_case_intake_select(int ID) { case_intake = case_intake.Select(ID); Insert_applic_end_date_time_txt.Text = Convert.ToString(case_intake.applic_end_date_time); Insert_applic_start_date_time_txt.Text = Convert.ToString(case_intake.applic_start_date_time); Insert_circum_emergency_event_txt.Text = Convert.ToString(case_intake.circum_emergency_event); Insert_circum_help_request_memo_txt.Text = Convert.ToString(case_intake.circum_help_request_memo); Insert_circum_income_stolen_txt.Text = Convert.ToString(case_intake.circum_income_stolen); Insert_circum_memo_txt.Text = Convert.ToString(case_intake.circum_memo); Insert_circum_no_income_txt.Text = Convert.ToString(case_intake.circum_no_income); Insert_circum_not_enough_income_txt.Text = Convert.ToString(case_intake.circum_not_enough_income); Insert_agency_id_txt.Text = Convert.ToString(case_intake.agency_id); Insert_call_center_id_txt.Text = Convert.ToString(case_intake.call_center_id); return(case_intake); }
//////////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////// //database insert methods public case_intake case_intake_insert() { case_intake.applic_end_date_time = Convert.ToDateTime(9 / 9 / 9);//null case_intake.applic_start_date_time = DateTime.Now; case_intake.circum_emergency_event = "N/A"; case_intake.circum_help_request_memo = "N/A"; case_intake.circum_income_stolen = "N/A"; case_intake.circum_memo = "Warehouse to warehouse order"; case_intake.circum_no_income = "N/A"; case_intake.circum_not_enough_income = "N/A"; case_intake.agency_id = 0;//null case_intake.call_center_id = Convert.ToInt32(DDL_Call_Center.SelectedValue); case_intake = case_intake.Insert(case_intake); return(case_intake); }
public case_intake case_intake_insert() { case_intake.applic_end_date_time = Convert.ToDateTime("1 / 1 / 1900"); case_intake.applic_start_date_time = DateTime.Now; case_intake.circum_emergency_event = "YES"; case_intake.circum_help_request_memo = "MISSING PERSON"; case_intake.circum_income_stolen = "NO"; case_intake.circum_memo = "NO"; case_intake.circum_no_income = "NO"; case_intake.circum_not_enough_income = "NO"; case_intake.agency_id = 0; case_intake.call_center_id = Convert.ToInt32(Insert_DDL_Call_Center.SelectedValue); case_intake = case_intake.Insert(case_intake); //GridView1.DataBind(); return(case_intake); }
public case_intake case_intake_insert() { case_intake.applic_end_date_time = Convert.ToDateTime(Insert_applic_end_date_time_txt.Text); case_intake.applic_start_date_time = Convert.ToDateTime(Insert_applic_start_date_time_txt.Text); case_intake.circum_emergency_event = Insert_circum_emergency_event_txt.Text; case_intake.circum_help_request_memo = Insert_circum_help_request_memo_txt.Text; case_intake.circum_income_stolen = Insert_circum_income_stolen_txt.Text; case_intake.circum_memo = Insert_circum_memo_txt.Text; case_intake.circum_no_income = Insert_circum_no_income_txt.Text; case_intake.circum_not_enough_income = Insert_circum_not_enough_income_txt.Text; case_intake.agency_id = Convert.ToInt32(Insert_agency_id_txt.Text); case_intake.call_center_id = Convert.ToInt32(Insert_call_center_id_txt.Text); case_intake = case_intake.Insert(case_intake); Insert_case_intake_GridView.DataBind(); Update_case_intake_GridView.DataBind(); Delete_case_intake_GridView.DataBind(); return case_intake; }
public case_intake case_intake_insert() { case_intake.applic_end_date_time = Convert.ToDateTime(Insert_applic_end_date_time_txt.Text); case_intake.applic_start_date_time = Convert.ToDateTime(Insert_applic_start_date_time_txt.Text); case_intake.circum_emergency_event = Insert_circum_emergency_event_txt.Text; case_intake.circum_help_request_memo = Insert_circum_help_request_memo_txt.Text; case_intake.circum_income_stolen = Insert_circum_income_stolen_txt.Text; case_intake.circum_memo = Insert_circum_memo_txt.Text; case_intake.circum_no_income = Insert_circum_no_income_txt.Text; case_intake.circum_not_enough_income = Insert_circum_not_enough_income_txt.Text; case_intake.agency_id = Convert.ToInt32(Insert_agency_id_txt.Text); case_intake.call_center_id = Convert.ToInt32(Insert_call_center_id_txt.Text); case_intake = case_intake.Insert(case_intake); Insert_case_intake_GridView.DataBind(); Update_case_intake_GridView.DataBind(); Delete_case_intake_GridView.DataBind(); return(case_intake); }
protected void updateDatabase() { //product_id_array has all product ids call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue)); selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value)); address = address.Select(selected_Warehouse.address_id); //case_intake case_intake = case_intake_insert(); //encounter encounter = encounter_insert(); //requestor requestor = requestor_insert(); //requestor_Order requestor_Order = requestor_Order_insert(); //Order_product Order_Product = Order_Product_insert(); }
//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_intake Delete_case_intake_select(int ID) { case_intake = case_intake.Select(ID); Delete_case_id_txt_lbl.Text = Convert.ToString(case_intake.case_id); Delete_applic_end_date_time_txt_lbl.Text = Convert.ToString(case_intake.applic_end_date_time); Delete_applic_start_date_time_txt_lbl.Text = Convert.ToString(case_intake.applic_start_date_time); Delete_circum_emergency_event_txt_lbl.Text = Convert.ToString(case_intake.circum_emergency_event); Delete_circum_help_request_memo_txt_lbl.Text = Convert.ToString(case_intake.circum_help_request_memo); Delete_circum_income_stolen_txt_lbl.Text = Convert.ToString(case_intake.circum_income_stolen); Delete_circum_memo_txt_lbl.Text = Convert.ToString(case_intake.circum_memo); Delete_circum_no_income_txt_lbl.Text = Convert.ToString(case_intake.circum_no_income); Delete_circum_not_enough_income_txt_lbl.Text = Convert.ToString(case_intake.circum_not_enough_income); Delete_agency_id_txt_lbl.Text = Convert.ToString(case_intake.agency_id); Delete_call_center_id_txt_lbl.Text = Convert.ToString(case_intake.call_center_id); return case_intake; }
protected void Insert_refreshcase() { DataTable vlcaslst = new DataTable(); DataTable casedt = new DataTable(); vlcaslst.Columns.Add("Case_id", Type.GetType("System.Int32")); vlcaslst.Columns.Add("applic_end_Date_time", Type.GetType("System.DateTime")); vlcaslst.Columns.Add("applic_Start_Date_time", Type.GetType("System.DateTime")); String whereclause = "Client_id = " + person.person_id; casedt = case_client.Select(whereclause); if (casedt.Rows.Count > 0) { foreach (DataRow cr in casedt.Rows) { DataRow caserow = vlcaslst.NewRow(); case_intake = case_intake.Select(Convert.ToInt32(cr["Case_id"])); caserow.SetField(0, case_intake.case_id); caserow.SetField(1, case_intake.applic_end_date_time); caserow.SetField(2, case_intake.applic_start_date_time); vlcaslst.Rows.Add(caserow); } Insert_GVcases.DataSource = vlcaslst; Insert_GVcases.DataBind(); } else { Insert_lbl_pet_Error.Text = "No case information exists"; } }
//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_intake = case_intake_insert(); }
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 Insert_Select_Record(object sender, EventArgs e) { case_intake = Insert_case_intake_select(Convert.ToInt32(Insert_case_intake_GridView.SelectedValue)); }
protected void UPDATE(object sender, EventArgs e) { case_intake = case_intake_update(Convert.ToInt32(Update_case_intake_GridView.SelectedValue)); }
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); } }
public case_intake case_intake_insert() { case_intake.applic_end_date_time = Convert.ToDateTime("1 / 1 / 1900"); case_intake.applic_start_date_time = DateTime.Now; case_intake.circum_emergency_event = "YES"; case_intake.circum_help_request_memo = "MISSING PERSON"; case_intake.circum_income_stolen = "NO"; case_intake.circum_memo = "NO"; case_intake.circum_no_income = "NO"; case_intake.circum_not_enough_income = "NO"; case_intake.agency_id = 0; case_intake.call_center_id = Convert.ToInt32(Insert_DDL_Call_Center.SelectedValue); case_intake = case_intake.Insert(case_intake); //GridView1.DataBind(); return case_intake; }
protected void Update_Select_Record(object sender, EventArgs e) { case_intake = Update_case_intake_select(Convert.ToInt32(Update_case_intake_GridView.SelectedValue)); }
protected void UPDATE(object sender, EventArgs e) { case_intake = case_intake_update(Convert.ToInt32(Update_case_intake_GridView.SelectedValue)); }
protected void INSERT(object sender, EventArgs e) { case_intake = case_intake_insert(); }
private void Create_case() { clientCase_intake.applic_start_date_time = DateTime.Today; if (CBEmgEvent.Checked == false) { clientCase_intake.circum_emergency_event = "0"; } else { clientCase_intake.circum_emergency_event = "1"; } if (CbStolanincome.Checked == false) { clientCase_intake.circum_income_stolen = "0"; } else { clientCase_intake.circum_income_stolen = "1"; } if (CbNoIncome.Checked == false) { clientCase_intake.circum_no_income = "0"; } else { clientCase_intake.circum_no_income = "1"; } if (CbNotenoughIncome.Checked == false) { clientCase_intake.circum_not_enough_income = "0"; } else { clientCase_intake.circum_not_enough_income = "1"; } clientCase_intake.circum_help_request_memo = txt_Circum_Help_Request_Memo.Text; clientCase_intake.circum_memo = txt_Circum_Memo.Text; clientCase_intake = clientCase_intake.Insert(clientCase_intake); }
//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."; } }
protected void updateDatabase() { //product_id_array has all product ids call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue)); selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value)); address = address.Select(selected_Warehouse.address_id); //case_intake case_intake = case_intake_insert(); //encounter encounter = encounter_insert(); //requestor requestor = requestor_insert(); //requestor_Order requestor_Order = requestor_Order_insert(); //Order_product Order_Product = Order_Product_insert(); }