//UPDATE protected void update_Click(object sender, EventArgs e) { try { //check to see if a insert is needed for deceased person = person.Select(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue)); client = client.Select(person.person_id); if (Update_deceasedYes.Checked == true) { person = person_update(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue)); missing = missing_update(person.person_id); //check if update of insert of deceased deceased = deceased.Select(client.client_id); if (deceased.deceased_id == 0) { deceased = deceased_insert_For_Update(); } else { deceased = deceased_update(person.person_id); } } else { person = person_update(Convert.ToInt32(Update_gvClientSearchresult.SelectedValue)); missing = missing_update(person.person_id); } address = address_update(person.address_id); client = client_update(person.person_id); encounter = encounter_insert(); Update_refreshclient(); } catch { Update_lbl_Client_Error.Text = "There has been an error updating information for the missing client."; } finally { Update_lbl_Client_Error.Text = "The missing client's information has been successfully updated."; } }
public missing Insert_missing_select(int ID) { missing = missing.Select(ID); Insert_client_other_info_txt.Text = Convert.ToString(missing.client_other_info); Insert_clothing_txt.Text = Convert.ToString(missing.clothing); Insert_date_of_disappearance_txt.Text = Convert.ToString(missing.date_of_disappearance); Insert_last_known_location_txt.Text = Convert.ToString(missing.last_known_location); return missing; }
public missing Insert_missing_select(int ID) { missing = missing.Select(ID); Insert_client_other_info_txt.Text = Convert.ToString(missing.client_other_info); Insert_clothing_txt.Text = Convert.ToString(missing.clothing); Insert_date_of_disappearance_txt.Text = Convert.ToString(missing.date_of_disappearance); Insert_last_known_location_txt.Text = Convert.ToString(missing.last_known_location); return(missing); }
public missing Delete_missing_select(int ID) { missing = missing.Select(ID); Delete_Missing_id_txt_lbl.Text = Convert.ToString(missing.Missing_id); Delete_client_other_info_txt_lbl.Text = Convert.ToString(missing.client_other_info); Delete_clothing_txt_lbl.Text = Convert.ToString(missing.clothing); Delete_date_of_disappearance_txt_lbl.Text = Convert.ToString(missing.date_of_disappearance); Delete_last_known_location_txt_lbl.Text = Convert.ToString(missing.last_known_location); return missing; }
public missing Delete_missing_select(int ID) { missing = missing.Select(ID); Delete_Missing_id_txt_lbl.Text = Convert.ToString(missing.Missing_id); Delete_client_other_info_txt_lbl.Text = Convert.ToString(missing.client_other_info); Delete_clothing_txt_lbl.Text = Convert.ToString(missing.clothing); Delete_date_of_disappearance_txt_lbl.Text = Convert.ToString(missing.date_of_disappearance); Delete_last_known_location_txt_lbl.Text = Convert.ToString(missing.last_known_location); return(missing); }
public missing missing_update(int ID) { missing = missing.Select(ID); missing.client_other_info = Update_client_other_info_txt.Text; missing.clothing = Update_clothing_txt.Text; missing.date_of_disappearance = Convert.ToDateTime(Update_date_of_disappearance_txt.Text); missing.last_known_location = Update_LocationDiscription_txt.Text; missing.Update(missing); //Insert_gvClientSearchresult.DataBind(); return(missing); }
public missing missing_insert() { missing.Missing_id = client.client_id; missing.client_other_info = Insert_client_other_info_txt.Text; missing.clothing = Insert_clothing_txt.Text; missing.date_of_disappearance = Convert.ToDateTime(Insert_date_of_disappearance_txt.Text); missing.last_known_location = Insert_LocationDiscription_txt.Text; missing = missing.Insert(missing); //Insert_gvClientSearchresult.DataBind(); return(missing); }
public missing missing_insert() { missing.client_other_info = Insert_client_other_info_txt.Text; missing.clothing = Insert_clothing_txt.Text; missing.date_of_disappearance = Convert.ToDateTime(Insert_date_of_disappearance_txt.Text); missing.last_known_location = Insert_last_known_location_txt.Text; missing = missing.Insert(missing); Insert_missing_GridView.DataBind(); Update_missing_GridView.DataBind(); Delete_missing_GridView.DataBind(); return missing; }
public missing missing_insert() { missing.client_other_info = Insert_client_other_info_txt.Text; missing.clothing = Insert_clothing_txt.Text; missing.date_of_disappearance = Convert.ToDateTime(Insert_date_of_disappearance_txt.Text); missing.last_known_location = Insert_last_known_location_txt.Text; missing = missing.Insert(missing); Insert_missing_GridView.DataBind(); Update_missing_GridView.DataBind(); Delete_missing_GridView.DataBind(); return(missing); }
public missing missing_update(int ID) { missing = missing.Select(ID); missing.Missing_id = Convert.ToInt32(Update_Missing_id_txt.Text); missing.client_other_info = Update_client_other_info_txt.Text; missing.clothing = Update_clothing_txt.Text; missing.date_of_disappearance = Convert.ToDateTime(Update_date_of_disappearance_txt.Text); missing.last_known_location = Update_last_known_location_txt.Text; missing.Update(missing); Insert_missing_GridView.DataBind(); Update_missing_GridView.DataBind(); Delete_missing_GridView.DataBind(); return(missing); }
//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 Insert_Select_Record(object sender, EventArgs e) { missing = Insert_missing_select(Convert.ToInt32(Insert_missing_GridView.SelectedValue)); }
protected void Update_Select_Record(object sender, EventArgs e) { missing = Update_missing_select(Convert.ToInt32(Update_missing_GridView.SelectedValue)); }
protected void UPDATE(object sender, EventArgs e) { missing = missing_update(Convert.ToInt32(Update_missing_GridView.SelectedValue)); }
public missing missing_update(int ID) { missing = missing.Select(ID); missing.client_other_info = Update_client_other_info_txt.Text; missing.clothing = Update_clothing_txt.Text; missing.date_of_disappearance = Convert.ToDateTime(Update_date_of_disappearance_txt.Text); missing.last_known_location = Update_LocationDiscription_txt.Text; missing.Update(missing); //Insert_gvClientSearchresult.DataBind(); return missing; }
public missing missing_update(int ID) { missing = missing.Select(ID); missing.Missing_id = Convert.ToInt32(Update_Missing_id_txt.Text); missing.client_other_info = Update_client_other_info_txt.Text; missing.clothing = Update_clothing_txt.Text; missing.date_of_disappearance = Convert.ToDateTime(Update_date_of_disappearance_txt.Text); missing.last_known_location = Update_last_known_location_txt.Text; missing.Update(missing); Insert_missing_GridView.DataBind(); Update_missing_GridView.DataBind(); Delete_missing_GridView.DataBind(); return missing; }
protected void INSERT(object sender, EventArgs e) { missing = missing_insert(); }
public missing missing_insert() { missing.Missing_id = client.client_id; missing.client_other_info = Insert_client_other_info_txt.Text; missing.clothing = Insert_clothing_txt.Text; missing.date_of_disappearance = Convert.ToDateTime(Insert_date_of_disappearance_txt.Text); missing.last_known_location = Insert_LocationDiscription_txt.Text; missing = missing.Insert(missing); //Insert_gvClientSearchresult.DataBind(); return missing; }
//select a client and display data protected void Update_gvClientSearchresult_SelectedIndexChanged(object sender, EventArgs e) { person = person.Select(Convert.ToInt32(Update_gvClientSearchresult.SelectedDataKey.Value)); GlobalVariables.PersonID = Convert.ToInt32(Update_gvClientSearchresult.SelectedDataKey.Value); address = address.Select(person.address_id); missing = missing.Select(person.person_id); deceased = deceased.Select(person.person_id); client = client.Select(person.person_id); GlobalVariables.ClientID = client.client_id; Update_LocationDiscription_txt.Text = missing.last_known_location; Update_reason_of_death_txt.Text = deceased.reason_of_death; Update_time_of_death_txt.Text = Convert.ToString(deceased.time_of_death); Update_identifying_marks_txt.Text = deceased.identifying_marks; Update_external_exam_txt.Text = deceased.external_exam; Update_date_of_autopsy_txt.Text = Convert.ToString(deceased.date_of_autopsy.ToShortDateString()); Update_internal_exam_txt.Text = deceased.external_exam; Update_client_other_info_txt.Text = missing.client_other_info; Update_Client_latitude_txt.Text = Convert.ToString(address.latitude); Update_Client_longitude_txt.Text = Convert.ToString(address.longitude); Update_Client_zip_plus_four_txt.Text = Convert.ToString(address.zip_plus_four); Update_Client_str_add2_txt.Text = address.str_add; Update_Client_str_add_txt.Text = address.str_add2; Update_Client_County_Township_txt.Text = address.County_Township; Update_Client_country_txt.Text = address.country; Update_Client_state_txt.Text = address.state; Update_Client_city_txt.Text = address.city; Update_hair_color_ddl.SelectedValue = client.hair_color; Update_skin_color_ddl.SelectedValue = client.skin_color; Update_eye_color_ddl.SelectedValue = client.eye_color; Update_ethnicity_txt.Text = client.ethnicity; Update_weight_txt.Text = Convert.ToString(client.weight); Update_height_ddl.SelectedValue = Convert.ToString(client.height); Update_date_of_disappearance_txt.Text = Convert.ToString(missing.date_of_disappearance.ToShortDateString()); Update_clothing_txt.Text = missing.clothing; Update_phone_primary_txt.Text = person.phone_primary; Update_ssn_txt.Text = Convert.ToString(person.ssn); Update_gender_ddl.SelectedValue = person.gender; Update_l_name_txt.Text = person.l_name; Update_m_initial_txt.Text = person.m_initial; Update_f_name_txt.Text = person.f_name; //change condishions Update_txtFirstName.Text = person.f_name.ToString(); Update_txtLastName.Text = person.l_name.ToString(); if (client.client_status == "D") { Update_Deceased_Div.Style.Add("display", "block"); Update_deceasedYes.Checked = true; Update_missingYes.Checked = false; } else { Update_Deceased_Div.Style.Add("display", "none"); Update_deceasedYes.Checked = false; Update_missingYes.Checked = true; } Update_sClient_L.Text = "</br>" + person.f_name + " " + person.l_name + " is selected."; }