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;
}
protected void INSERT(object sender, EventArgs e)
{
disaster_project_task_location = disaster_project_task_location_insert();
}
/////////////////////////
////////////////////////
///////////////////////
//////////////////////
/////////////////////
//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));
}
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));
}
