public disaster_project_task_location disaster_project_task_location_insert() { disaster_project_task_location.disaster_id = Convert.ToInt32(Insert_disaster_id_txt.Text); disaster_project_task_location.project_id = Convert.ToInt32(Insert_project_id_txt.Text); disaster_project_task_location.task_id = Convert.ToInt32(Insert_task_id_txt.Text); disaster_project_task_location.demo_location_id = Convert.ToInt32(Insert_demo_location_id_txt.Text); disaster_project_task_location.demo_id = Convert.ToInt32(Insert_demo_id_txt.Text); disaster_project_task_location.est_task_hours = Convert.ToDecimal(Insert_est_task_hours_txt.Text); disaster_project_task_location.est_task_costs = Convert.ToDecimal(Insert_est_task_costs_txt.Text); disaster_project_task_location.auth_name_rec_perf_rating = Insert_auth_name_rec_perf_rating_txt.Text; disaster_project_task_location.date_rec_perf_date = Convert.ToDateTime(Insert_date_rec_perf_date_txt.Text); disaster_project_task_location.aut_name_review_time = Insert_aut_name_review_time_txt.Text; disaster_project_task_location.date_ok_timesh_rep = Convert.ToDateTime(Insert_date_ok_timesh_rep_txt.Text); disaster_project_task_location.auth_name_pay_rel_person = Insert_auth_name_pay_rel_person_txt.Text; disaster_project_task_location.date_person_paid_rel = Convert.ToDateTime(Insert_date_person_paid_rel_txt.Text); disaster_project_task_location.aut_name_prod_inv_ck_pay_ven = Insert_aut_name_prod_inv_ck_pay_ven_txt.Text; disaster_project_task_location.aut_name_eq_ret_refurb = Insert_aut_name_eq_ret_refurb_txt.Text; disaster_project_task_location.date_prod_inv_rel_ven_paid = Convert.ToDateTime(Insert_date_prod_inv_rel_ven_paid_txt.Text); disaster_project_task_location.date_eq_rel_ven_paid = Convert.ToDateTime(Insert_date_eq_rel_ven_paid_txt.Text); disaster_project_task_location.task_authorized_name_reimburse = Insert_task_authorized_name_reimburse_txt.Text; disaster_project_task_location.date_task_reimburse = Convert.ToDateTime(Insert_date_task_reimburse_txt.Text); disaster_project_task_location.ok_close_task_name = Insert_ok_close_task_name_txt.Text; disaster_project_task_location.close_task_date = Convert.ToDateTime(Insert_close_task_date_txt.Text); disaster_project_task_location = disaster_project_task_location.Insert(disaster_project_task_location); Insert_disaster_project_task_location_GridView.DataBind(); Update_disaster_project_task_location_GridView.DataBind(); Delete_disaster_project_task_location_GridView.DataBind(); return(disaster_project_task_location); }
public disaster_project_task_location Delete_disaster_project_task_location_select(int ID) { disaster_project_task_location = disaster_project_task_location.Select(ID); Delete_disaster_project_task_location_id_txt_lbl.Text = Convert.ToString(disaster_project_task_location.disaster_project_task_location_id); Delete_disaster_id_txt_lbl.Text = Convert.ToString(disaster_project_task_location.disaster_id); Delete_project_id_txt_lbl.Text = Convert.ToString(disaster_project_task_location.project_id); Delete_task_id_txt_lbl.Text = Convert.ToString(disaster_project_task_location.task_id); Delete_demo_location_id_txt_lbl.Text = Convert.ToString(disaster_project_task_location.demo_location_id); Delete_demo_id_txt_lbl.Text = Convert.ToString(disaster_project_task_location.demo_id); Delete_est_task_hours_txt_lbl.Text = Convert.ToString(disaster_project_task_location.est_task_hours); Delete_est_task_costs_txt_lbl.Text = Convert.ToString(disaster_project_task_location.est_task_costs); Delete_auth_name_rec_perf_rating_txt_lbl.Text = Convert.ToString(disaster_project_task_location.auth_name_rec_perf_rating); Delete_date_rec_perf_date_txt_lbl.Text = Convert.ToString(disaster_project_task_location.date_rec_perf_date); Delete_aut_name_review_time_txt_lbl.Text = Convert.ToString(disaster_project_task_location.aut_name_review_time); Delete_date_ok_timesh_rep_txt_lbl.Text = Convert.ToString(disaster_project_task_location.date_ok_timesh_rep); Delete_auth_name_pay_rel_person_txt_lbl.Text = Convert.ToString(disaster_project_task_location.auth_name_pay_rel_person); Delete_date_person_paid_rel_txt_lbl.Text = Convert.ToString(disaster_project_task_location.date_person_paid_rel); Delete_aut_name_prod_inv_ck_pay_ven_txt_lbl.Text = Convert.ToString(disaster_project_task_location.aut_name_prod_inv_ck_pay_ven); Delete_aut_name_eq_ret_refurb_txt_lbl.Text = Convert.ToString(disaster_project_task_location.aut_name_eq_ret_refurb); Delete_date_prod_inv_rel_ven_paid_txt_lbl.Text = Convert.ToString(disaster_project_task_location.date_prod_inv_rel_ven_paid); Delete_date_eq_rel_ven_paid_txt_lbl.Text = Convert.ToString(disaster_project_task_location.date_eq_rel_ven_paid); Delete_task_authorized_name_reimburse_txt_lbl.Text = Convert.ToString(disaster_project_task_location.task_authorized_name_reimburse); Delete_date_task_reimburse_txt_lbl.Text = Convert.ToString(disaster_project_task_location.date_task_reimburse); Delete_ok_close_task_name_txt_lbl.Text = Convert.ToString(disaster_project_task_location.ok_close_task_name); Delete_close_task_date_txt_lbl.Text = Convert.ToString(disaster_project_task_location.close_task_date); return disaster_project_task_location; }
public disaster_project_task_location Insert_disaster_project_task_location_select(int ID) { disaster_project_task_location = disaster_project_task_location.Select(ID); Insert_disaster_id_txt.Text = Convert.ToString(disaster_project_task_location.disaster_id); Insert_project_id_txt.Text = Convert.ToString(disaster_project_task_location.project_id); Insert_task_id_txt.Text = Convert.ToString(disaster_project_task_location.task_id); Insert_demo_location_id_txt.Text = Convert.ToString(disaster_project_task_location.demo_location_id); Insert_demo_id_txt.Text = Convert.ToString(disaster_project_task_location.demo_id); Insert_est_task_hours_txt.Text = Convert.ToString(disaster_project_task_location.est_task_hours); Insert_est_task_costs_txt.Text = Convert.ToString(disaster_project_task_location.est_task_costs); Insert_auth_name_rec_perf_rating_txt.Text = Convert.ToString(disaster_project_task_location.auth_name_rec_perf_rating); Insert_date_rec_perf_date_txt.Text = Convert.ToString(disaster_project_task_location.date_rec_perf_date); Insert_aut_name_review_time_txt.Text = Convert.ToString(disaster_project_task_location.aut_name_review_time); Insert_date_ok_timesh_rep_txt.Text = Convert.ToString(disaster_project_task_location.date_ok_timesh_rep); Insert_auth_name_pay_rel_person_txt.Text = Convert.ToString(disaster_project_task_location.auth_name_pay_rel_person); Insert_date_person_paid_rel_txt.Text = Convert.ToString(disaster_project_task_location.date_person_paid_rel); Insert_aut_name_prod_inv_ck_pay_ven_txt.Text = Convert.ToString(disaster_project_task_location.aut_name_prod_inv_ck_pay_ven); Insert_aut_name_eq_ret_refurb_txt.Text = Convert.ToString(disaster_project_task_location.aut_name_eq_ret_refurb); Insert_date_prod_inv_rel_ven_paid_txt.Text = Convert.ToString(disaster_project_task_location.date_prod_inv_rel_ven_paid); Insert_date_eq_rel_ven_paid_txt.Text = Convert.ToString(disaster_project_task_location.date_eq_rel_ven_paid); Insert_task_authorized_name_reimburse_txt.Text = Convert.ToString(disaster_project_task_location.task_authorized_name_reimburse); Insert_date_task_reimburse_txt.Text = Convert.ToString(disaster_project_task_location.date_task_reimburse); Insert_ok_close_task_name_txt.Text = Convert.ToString(disaster_project_task_location.ok_close_task_name); Insert_close_task_date_txt.Text = Convert.ToString(disaster_project_task_location.close_task_date); return(disaster_project_task_location); }
public Boolean Update(disaster_project_task_location id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_DISASTER_PROJECT_TASK_LOCATION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_project_task_location_id", id.disaster_project_task_location_id); cmd.Parameters.AddWithValue("@disaster_id", id.disaster_id); cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@demo_location_id", id.demo_location_id); cmd.Parameters.AddWithValue("@demo_id", id.demo_id); cmd.Parameters.AddWithValue("@est_task_hours", id.est_task_hours); cmd.Parameters.AddWithValue("@est_task_costs", id.est_task_costs); cmd.Parameters.AddWithValue("@auth_name_rec_perf_rating", id.auth_name_rec_perf_rating); cmd.Parameters.AddWithValue("@date_rec_perf_date", id.date_rec_perf_date); cmd.Parameters.AddWithValue("@aut_name_review_time", id.aut_name_review_time); cmd.Parameters.AddWithValue("@date_ok_timesh_rep", id.date_ok_timesh_rep); cmd.Parameters.AddWithValue("@auth_name_pay_rel_person", id.auth_name_pay_rel_person); cmd.Parameters.AddWithValue("@date_person_paid_rel", id.date_person_paid_rel); cmd.Parameters.AddWithValue("@aut_name_prod_inv_ck_pay_ven", id.aut_name_prod_inv_ck_pay_ven); cmd.Parameters.AddWithValue("@aut_name_eq_ret_refurb", id.aut_name_eq_ret_refurb); cmd.Parameters.AddWithValue("@date_prod_inv_rel_ven_paid", id.date_prod_inv_rel_ven_paid); cmd.Parameters.AddWithValue("@date_eq_rel_ven_paid", id.date_eq_rel_ven_paid); cmd.Parameters.AddWithValue("@task_authorized_name_reimburse", id.task_authorized_name_reimburse); cmd.Parameters.AddWithValue("@date_task_reimburse", id.date_task_reimburse); cmd.Parameters.AddWithValue("@ok_close_task_name", id.ok_close_task_name); cmd.Parameters.AddWithValue("@close_task_date", id.close_task_date); cmd.ExecuteReader(); con.Close(); return(true); } catch (Exception ex) { return(false); } finally { con.Close(); } }
public disaster_project_task_location disaster_project_task_location_insert() { disaster_project_task_location.disaster_id = Convert.ToInt32(Insert_disaster_id_txt.Text); disaster_project_task_location.project_id = Convert.ToInt32(Insert_project_id_txt.Text); disaster_project_task_location.task_id = Convert.ToInt32(Insert_task_id_txt.Text); disaster_project_task_location.demo_location_id = Convert.ToInt32(Insert_demo_location_id_txt.Text); disaster_project_task_location.demo_id = Convert.ToInt32(Insert_demo_id_txt.Text); disaster_project_task_location.est_task_hours = Convert.ToDecimal(Insert_est_task_hours_txt.Text); disaster_project_task_location.est_task_costs = Convert.ToDecimal(Insert_est_task_costs_txt.Text); disaster_project_task_location.auth_name_rec_perf_rating = Insert_auth_name_rec_perf_rating_txt.Text; disaster_project_task_location.date_rec_perf_date = Convert.ToDateTime(Insert_date_rec_perf_date_txt.Text); disaster_project_task_location.aut_name_review_time = Insert_aut_name_review_time_txt.Text; disaster_project_task_location.date_ok_timesh_rep = Convert.ToDateTime(Insert_date_ok_timesh_rep_txt.Text); disaster_project_task_location.auth_name_pay_rel_person = Insert_auth_name_pay_rel_person_txt.Text; disaster_project_task_location.date_person_paid_rel = Convert.ToDateTime(Insert_date_person_paid_rel_txt.Text); disaster_project_task_location.aut_name_prod_inv_ck_pay_ven = Insert_aut_name_prod_inv_ck_pay_ven_txt.Text; disaster_project_task_location.aut_name_eq_ret_refurb = Insert_aut_name_eq_ret_refurb_txt.Text; disaster_project_task_location.date_prod_inv_rel_ven_paid = Convert.ToDateTime(Insert_date_prod_inv_rel_ven_paid_txt.Text); disaster_project_task_location.date_eq_rel_ven_paid = Convert.ToDateTime(Insert_date_eq_rel_ven_paid_txt.Text); disaster_project_task_location.task_authorized_name_reimburse = Insert_task_authorized_name_reimburse_txt.Text; disaster_project_task_location.date_task_reimburse = Convert.ToDateTime(Insert_date_task_reimburse_txt.Text); disaster_project_task_location.ok_close_task_name = Insert_ok_close_task_name_txt.Text; disaster_project_task_location.close_task_date = Convert.ToDateTime(Insert_close_task_date_txt.Text); disaster_project_task_location = disaster_project_task_location.Insert(disaster_project_task_location); Insert_disaster_project_task_location_GridView.DataBind(); Update_disaster_project_task_location_GridView.DataBind(); Delete_disaster_project_task_location_GridView.DataBind(); return disaster_project_task_location; }
///////////////////////// //////////////////////// /////////////////////// ////////////////////// ///////////////////// //Update Tab Methods protected void Update_Select_Record(object sender, EventArgs e) { disaster_project_task_location = Update_disaster_project_task_location_select(Convert.ToInt32(Update_disaster_project_task_location_GridView.SelectedValue)); }
protected void UPDATE(object sender, EventArgs e) { disaster_project_task_location = disaster_project_task_location_update(Convert.ToInt32(Update_disaster_project_task_location_GridView.SelectedValue)); }
protected void INSERT(object sender, EventArgs e) { disaster_project_task_location = disaster_project_task_location_insert(); }
public disaster_project_task_location Insert(disaster_project_task_location id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DISASTER_PROJECT_TASK_LOCATION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id.disaster_id); cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@demo_location_id", id.demo_location_id); cmd.Parameters.AddWithValue("@demo_id", id.demo_id); cmd.Parameters.AddWithValue("@est_task_hours", id.est_task_hours); cmd.Parameters.AddWithValue("@est_task_costs", id.est_task_costs); cmd.Parameters.AddWithValue("@auth_name_rec_perf_rating", id.auth_name_rec_perf_rating); cmd.Parameters.AddWithValue("@date_rec_perf_date", id.date_rec_perf_date); cmd.Parameters.AddWithValue("@aut_name_review_time", id.aut_name_review_time); cmd.Parameters.AddWithValue("@date_ok_timesh_rep", id.date_ok_timesh_rep); cmd.Parameters.AddWithValue("@auth_name_pay_rel_person", id.auth_name_pay_rel_person); cmd.Parameters.AddWithValue("@date_person_paid_rel", id.date_person_paid_rel); cmd.Parameters.AddWithValue("@aut_name_prod_inv_ck_pay_ven", id.aut_name_prod_inv_ck_pay_ven); cmd.Parameters.AddWithValue("@aut_name_eq_ret_refurb", id.aut_name_eq_ret_refurb); cmd.Parameters.AddWithValue("@date_prod_inv_rel_ven_paid", id.date_prod_inv_rel_ven_paid); cmd.Parameters.AddWithValue("@date_eq_rel_ven_paid", id.date_eq_rel_ven_paid); cmd.Parameters.AddWithValue("@task_authorized_name_reimburse", id.task_authorized_name_reimburse); cmd.Parameters.AddWithValue("@date_task_reimburse", id.date_task_reimburse); cmd.Parameters.AddWithValue("@ok_close_task_name", id.ok_close_task_name); cmd.Parameters.AddWithValue("@close_task_date", id.close_task_date); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DISASTER_PROJECT_TASK_LOCATION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id.disaster_id); cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@demo_location_id", id.demo_location_id); cmd.Parameters.AddWithValue("@demo_id", id.demo_id); cmd.Parameters.AddWithValue("@est_task_hours", id.est_task_hours); cmd.Parameters.AddWithValue("@est_task_costs", id.est_task_costs); cmd.Parameters.AddWithValue("@auth_name_rec_perf_rating", id.auth_name_rec_perf_rating); cmd.Parameters.AddWithValue("@date_rec_perf_date", id.date_rec_perf_date); cmd.Parameters.AddWithValue("@aut_name_review_time", id.aut_name_review_time); cmd.Parameters.AddWithValue("@date_ok_timesh_rep", id.date_ok_timesh_rep); cmd.Parameters.AddWithValue("@auth_name_pay_rel_person", id.auth_name_pay_rel_person); cmd.Parameters.AddWithValue("@date_person_paid_rel", id.date_person_paid_rel); cmd.Parameters.AddWithValue("@aut_name_prod_inv_ck_pay_ven", id.aut_name_prod_inv_ck_pay_ven); cmd.Parameters.AddWithValue("@aut_name_eq_ret_refurb", id.aut_name_eq_ret_refurb); cmd.Parameters.AddWithValue("@date_prod_inv_rel_ven_paid", id.date_prod_inv_rel_ven_paid); cmd.Parameters.AddWithValue("@date_eq_rel_ven_paid", id.date_eq_rel_ven_paid); cmd.Parameters.AddWithValue("@task_authorized_name_reimburse", id.task_authorized_name_reimburse); cmd.Parameters.AddWithValue("@date_task_reimburse", id.date_task_reimburse); cmd.Parameters.AddWithValue("@ok_close_task_name", id.ok_close_task_name); cmd.Parameters.AddWithValue("@close_task_date", id.close_task_date); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.disaster_project_task_location_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public disaster_project_task_location Select(int id) { disaster_project_task_location disaster_project_task_location = new disaster_project_task_location(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DISASTER_PROJECT_TASK_LOCATION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_project_task_location_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { disaster_project_task_location.disaster_project_task_location_id = rdr.GetInt32(0); } else { disaster_project_task_location.disaster_project_task_location_id = 0; } if (!rdr.IsDBNull(1)) { disaster_project_task_location.disaster_id = rdr.GetInt32(1); } else { disaster_project_task_location.disaster_id = 0; } if (!rdr.IsDBNull(2)) { disaster_project_task_location.project_id = rdr.GetInt32(2); } else { disaster_project_task_location.project_id = 0; } if (!rdr.IsDBNull(3)) { disaster_project_task_location.task_id = rdr.GetInt32(3); } else { disaster_project_task_location.task_id = 0; } if (!rdr.IsDBNull(4)) { disaster_project_task_location.demo_location_id = rdr.GetInt32(4); } else { disaster_project_task_location.demo_location_id = 0; } if (!rdr.IsDBNull(5)) { disaster_project_task_location.demo_id = rdr.GetInt32(5); } else { disaster_project_task_location.demo_id = 0; } if (!rdr.IsDBNull(6)) { disaster_project_task_location.est_task_hours = rdr.GetDecimal(6); } else { disaster_project_task_location.est_task_hours = 0; } if (!rdr.IsDBNull(7)) { disaster_project_task_location.est_task_costs = rdr.GetDecimal(7); } else { disaster_project_task_location.est_task_costs = 0; } if (!rdr.IsDBNull(8)) { disaster_project_task_location.auth_name_rec_perf_rating = rdr.GetString(8); } else { disaster_project_task_location.auth_name_rec_perf_rating = " "; } if (!rdr.IsDBNull(9)) { disaster_project_task_location.date_rec_perf_date = rdr.GetDateTime(9); } else { disaster_project_task_location.date_rec_perf_date = DateTime.Now; } if (!rdr.IsDBNull(10)) { disaster_project_task_location.aut_name_review_time = rdr.GetString(10); } else { disaster_project_task_location.aut_name_review_time = " "; } if (!rdr.IsDBNull(11)) { disaster_project_task_location.date_ok_timesh_rep = rdr.GetDateTime(11); } else { disaster_project_task_location.date_ok_timesh_rep = DateTime.Now; } if (!rdr.IsDBNull(12)) { disaster_project_task_location.auth_name_pay_rel_person = rdr.GetString(12); } else { disaster_project_task_location.auth_name_pay_rel_person = " "; } if (!rdr.IsDBNull(13)) { disaster_project_task_location.date_person_paid_rel = rdr.GetDateTime(13); } else { disaster_project_task_location.date_person_paid_rel = DateTime.Now; } if (!rdr.IsDBNull(14)) { disaster_project_task_location.aut_name_prod_inv_ck_pay_ven = rdr.GetString(14); } else { disaster_project_task_location.aut_name_prod_inv_ck_pay_ven = " "; } if (!rdr.IsDBNull(15)) { disaster_project_task_location.aut_name_eq_ret_refurb = rdr.GetString(15); } else { disaster_project_task_location.aut_name_eq_ret_refurb = " "; } if (!rdr.IsDBNull(16)) { disaster_project_task_location.date_prod_inv_rel_ven_paid = rdr.GetDateTime(16); } else { disaster_project_task_location.date_prod_inv_rel_ven_paid = DateTime.Now; } if (!rdr.IsDBNull(17)) { disaster_project_task_location.date_eq_rel_ven_paid = rdr.GetDateTime(17); } else { disaster_project_task_location.date_eq_rel_ven_paid = DateTime.Now; } if (!rdr.IsDBNull(18)) { disaster_project_task_location.task_authorized_name_reimburse = rdr.GetString(18); } else { disaster_project_task_location.task_authorized_name_reimburse = " "; } if (!rdr.IsDBNull(19)) { disaster_project_task_location.date_task_reimburse = rdr.GetDateTime(19); } else { disaster_project_task_location.date_task_reimburse = DateTime.Now; } if (!rdr.IsDBNull(20)) { disaster_project_task_location.ok_close_task_name = rdr.GetString(20); } else { disaster_project_task_location.ok_close_task_name = " "; } if (!rdr.IsDBNull(21)) { disaster_project_task_location.close_task_date = rdr.GetDateTime(21); } else { disaster_project_task_location.close_task_date = DateTime.Now; } } else { disaster_project_task_location.SetColumnDefaults(); } } catch (Exception ex) { disaster_project_task_location.SetColumnDefaults(); return(disaster_project_task_location); } finally { con.Close(); } return(disaster_project_task_location); }
public Boolean Update(disaster_project_task_location id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_DISASTER_PROJECT_TASK_LOCATION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_project_task_location_id", id.disaster_project_task_location_id); cmd.Parameters.AddWithValue("@disaster_id", id.disaster_id); cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@demo_location_id", id.demo_location_id); cmd.Parameters.AddWithValue("@demo_id", id.demo_id); cmd.Parameters.AddWithValue("@est_task_hours", id.est_task_hours); cmd.Parameters.AddWithValue("@est_task_costs", id.est_task_costs); cmd.Parameters.AddWithValue("@auth_name_rec_perf_rating", id.auth_name_rec_perf_rating); cmd.Parameters.AddWithValue("@date_rec_perf_date", id.date_rec_perf_date); cmd.Parameters.AddWithValue("@aut_name_review_time", id.aut_name_review_time); cmd.Parameters.AddWithValue("@date_ok_timesh_rep", id.date_ok_timesh_rep); cmd.Parameters.AddWithValue("@auth_name_pay_rel_person", id.auth_name_pay_rel_person); cmd.Parameters.AddWithValue("@date_person_paid_rel", id.date_person_paid_rel); cmd.Parameters.AddWithValue("@aut_name_prod_inv_ck_pay_ven", id.aut_name_prod_inv_ck_pay_ven); cmd.Parameters.AddWithValue("@aut_name_eq_ret_refurb", id.aut_name_eq_ret_refurb); cmd.Parameters.AddWithValue("@date_prod_inv_rel_ven_paid", id.date_prod_inv_rel_ven_paid); cmd.Parameters.AddWithValue("@date_eq_rel_ven_paid", id.date_eq_rel_ven_paid); cmd.Parameters.AddWithValue("@task_authorized_name_reimburse", id.task_authorized_name_reimburse); cmd.Parameters.AddWithValue("@date_task_reimburse", id.date_task_reimburse); cmd.Parameters.AddWithValue("@ok_close_task_name", id.ok_close_task_name); cmd.Parameters.AddWithValue("@close_task_date", id.close_task_date); cmd.ExecuteReader(); con.Close(); return true; } catch (Exception ex) { return false; } finally { con.Close(); } }
public disaster_project_task_location Select(int id) { disaster_project_task_location disaster_project_task_location = new disaster_project_task_location(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DISASTER_PROJECT_TASK_LOCATION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_project_task_location_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { disaster_project_task_location.disaster_project_task_location_id = rdr.GetInt32(0); } else { disaster_project_task_location.disaster_project_task_location_id = 0; } if (!rdr.IsDBNull(1)) { disaster_project_task_location.disaster_id = rdr.GetInt32(1); } else { disaster_project_task_location.disaster_id = 0; } if (!rdr.IsDBNull(2)) { disaster_project_task_location.project_id = rdr.GetInt32(2); } else { disaster_project_task_location.project_id = 0; } if (!rdr.IsDBNull(3)) { disaster_project_task_location.task_id = rdr.GetInt32(3); } else { disaster_project_task_location.task_id = 0; } if (!rdr.IsDBNull(4)) { disaster_project_task_location.demo_location_id = rdr.GetInt32(4); } else { disaster_project_task_location.demo_location_id = 0; } if (!rdr.IsDBNull(5)) { disaster_project_task_location.demo_id = rdr.GetInt32(5); } else { disaster_project_task_location.demo_id = 0; } if (!rdr.IsDBNull(6)) { disaster_project_task_location.est_task_hours = rdr.GetDecimal(6); } else { disaster_project_task_location.est_task_hours = 0; } if (!rdr.IsDBNull(7)) { disaster_project_task_location.est_task_costs = rdr.GetDecimal(7); } else { disaster_project_task_location.est_task_costs = 0; } if (!rdr.IsDBNull(8)) { disaster_project_task_location.auth_name_rec_perf_rating = rdr.GetString(8); } else { disaster_project_task_location.auth_name_rec_perf_rating = " "; } if (!rdr.IsDBNull(9)) { disaster_project_task_location.date_rec_perf_date = rdr.GetDateTime(9); } else { disaster_project_task_location.date_rec_perf_date = DateTime.Now; } if (!rdr.IsDBNull(10)) { disaster_project_task_location.aut_name_review_time = rdr.GetString(10); } else { disaster_project_task_location.aut_name_review_time = " "; } if (!rdr.IsDBNull(11)) { disaster_project_task_location.date_ok_timesh_rep = rdr.GetDateTime(11); } else { disaster_project_task_location.date_ok_timesh_rep = DateTime.Now; } if (!rdr.IsDBNull(12)) { disaster_project_task_location.auth_name_pay_rel_person = rdr.GetString(12); } else { disaster_project_task_location.auth_name_pay_rel_person = " "; } if (!rdr.IsDBNull(13)) { disaster_project_task_location.date_person_paid_rel = rdr.GetDateTime(13); } else { disaster_project_task_location.date_person_paid_rel = DateTime.Now; } if (!rdr.IsDBNull(14)) { disaster_project_task_location.aut_name_prod_inv_ck_pay_ven = rdr.GetString(14); } else { disaster_project_task_location.aut_name_prod_inv_ck_pay_ven = " "; } if (!rdr.IsDBNull(15)) { disaster_project_task_location.aut_name_eq_ret_refurb = rdr.GetString(15); } else { disaster_project_task_location.aut_name_eq_ret_refurb = " "; } if (!rdr.IsDBNull(16)) { disaster_project_task_location.date_prod_inv_rel_ven_paid = rdr.GetDateTime(16); } else { disaster_project_task_location.date_prod_inv_rel_ven_paid = DateTime.Now; } if (!rdr.IsDBNull(17)) { disaster_project_task_location.date_eq_rel_ven_paid = rdr.GetDateTime(17); } else { disaster_project_task_location.date_eq_rel_ven_paid = DateTime.Now; } if (!rdr.IsDBNull(18)) { disaster_project_task_location.task_authorized_name_reimburse = rdr.GetString(18); } else { disaster_project_task_location.task_authorized_name_reimburse = " "; } if (!rdr.IsDBNull(19)) { disaster_project_task_location.date_task_reimburse = rdr.GetDateTime(19); } else { disaster_project_task_location.date_task_reimburse = DateTime.Now; } if (!rdr.IsDBNull(20)) { disaster_project_task_location.ok_close_task_name = rdr.GetString(20); } else { disaster_project_task_location.ok_close_task_name = " "; } if (!rdr.IsDBNull(21)) { disaster_project_task_location.close_task_date = rdr.GetDateTime(21); } else { disaster_project_task_location.close_task_date = DateTime.Now; } } else { disaster_project_task_location.SetColumnDefaults(); } } catch (Exception ex) { disaster_project_task_location.SetColumnDefaults(); return disaster_project_task_location; } finally { con.Close(); } return disaster_project_task_location; }
public disaster_project_task_location Insert(disaster_project_task_location id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DISASTER_PROJECT_TASK_LOCATION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id.disaster_id); cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@demo_location_id", id.demo_location_id); cmd.Parameters.AddWithValue("@demo_id", id.demo_id); cmd.Parameters.AddWithValue("@est_task_hours", id.est_task_hours); cmd.Parameters.AddWithValue("@est_task_costs", id.est_task_costs); cmd.Parameters.AddWithValue("@auth_name_rec_perf_rating", id.auth_name_rec_perf_rating); cmd.Parameters.AddWithValue("@date_rec_perf_date", id.date_rec_perf_date); cmd.Parameters.AddWithValue("@aut_name_review_time", id.aut_name_review_time); cmd.Parameters.AddWithValue("@date_ok_timesh_rep", id.date_ok_timesh_rep); cmd.Parameters.AddWithValue("@auth_name_pay_rel_person", id.auth_name_pay_rel_person); cmd.Parameters.AddWithValue("@date_person_paid_rel", id.date_person_paid_rel); cmd.Parameters.AddWithValue("@aut_name_prod_inv_ck_pay_ven", id.aut_name_prod_inv_ck_pay_ven); cmd.Parameters.AddWithValue("@aut_name_eq_ret_refurb", id.aut_name_eq_ret_refurb); cmd.Parameters.AddWithValue("@date_prod_inv_rel_ven_paid", id.date_prod_inv_rel_ven_paid); cmd.Parameters.AddWithValue("@date_eq_rel_ven_paid", id.date_eq_rel_ven_paid); cmd.Parameters.AddWithValue("@task_authorized_name_reimburse", id.task_authorized_name_reimburse); cmd.Parameters.AddWithValue("@date_task_reimburse", id.date_task_reimburse); cmd.Parameters.AddWithValue("@ok_close_task_name", id.ok_close_task_name); cmd.Parameters.AddWithValue("@close_task_date", id.close_task_date); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DISASTER_PROJECT_TASK_LOCATION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id.disaster_id); cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@demo_location_id", id.demo_location_id); cmd.Parameters.AddWithValue("@demo_id", id.demo_id); cmd.Parameters.AddWithValue("@est_task_hours", id.est_task_hours); cmd.Parameters.AddWithValue("@est_task_costs", id.est_task_costs); cmd.Parameters.AddWithValue("@auth_name_rec_perf_rating", id.auth_name_rec_perf_rating); cmd.Parameters.AddWithValue("@date_rec_perf_date", id.date_rec_perf_date); cmd.Parameters.AddWithValue("@aut_name_review_time", id.aut_name_review_time); cmd.Parameters.AddWithValue("@date_ok_timesh_rep", id.date_ok_timesh_rep); cmd.Parameters.AddWithValue("@auth_name_pay_rel_person", id.auth_name_pay_rel_person); cmd.Parameters.AddWithValue("@date_person_paid_rel", id.date_person_paid_rel); cmd.Parameters.AddWithValue("@aut_name_prod_inv_ck_pay_ven", id.aut_name_prod_inv_ck_pay_ven); cmd.Parameters.AddWithValue("@aut_name_eq_ret_refurb", id.aut_name_eq_ret_refurb); cmd.Parameters.AddWithValue("@date_prod_inv_rel_ven_paid", id.date_prod_inv_rel_ven_paid); cmd.Parameters.AddWithValue("@date_eq_rel_ven_paid", id.date_eq_rel_ven_paid); cmd.Parameters.AddWithValue("@task_authorized_name_reimburse", id.task_authorized_name_reimburse); cmd.Parameters.AddWithValue("@date_task_reimburse", id.date_task_reimburse); cmd.Parameters.AddWithValue("@ok_close_task_name", id.ok_close_task_name); cmd.Parameters.AddWithValue("@close_task_date", id.close_task_date); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.disaster_project_task_location_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
///////////////////////// //////////////////////// /////////////////////// ////////////////////// ///////////////////// //Insert Tab Methods protected void Insert_Select_Record(object sender, EventArgs e) { disaster_project_task_location = Insert_disaster_project_task_location_select(Convert.ToInt32(Insert_disaster_project_task_location_GridView.SelectedValue)); }