public Boolean Update(Pro_Require_Task_Res id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_PRO_REQUIRE_TASK_RES", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Proj_Require_Task_Res_ID", id.Proj_Require_Task_Res_ID); cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@Requirement_ID", id.Requirement_ID); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID); cmd.Parameters.AddWithValue("@Project_Catagory", id.Project_Catagory); cmd.Parameters.AddWithValue("@Proj_Require_Description", id.Proj_Require_Description); cmd.Parameters.AddWithValue("@Project_Task_Description", id.Project_Task_Description); cmd.Parameters.AddWithValue("@Applicant_Name", id.Applicant_Name); cmd.Parameters.AddWithValue("@Equipment_Description", id.Equipment_Description); cmd.Parameters.AddWithValue("@Vehicle", id.Vehicle); cmd.ExecuteReader(); con.Close(); return(true); } catch (Exception ex) { return(false); } finally { con.Close(); } }
public Pro_Require_Task_Res Insert(Pro_Require_Task_Res id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_PRO_REQUIRE_TASK_RES", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@Requirement_ID", id.Requirement_ID); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID); cmd.Parameters.AddWithValue("@Project_Catagory", id.Project_Catagory); cmd.Parameters.AddWithValue("@Proj_Require_Description", id.Proj_Require_Description); cmd.Parameters.AddWithValue("@Project_Task_Description", id.Project_Task_Description); cmd.Parameters.AddWithValue("@Applicant_Name", id.Applicant_Name); cmd.Parameters.AddWithValue("@Equipment_Description", id.Equipment_Description); cmd.Parameters.AddWithValue("@Vehicle", id.Vehicle); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_PRO_REQUIRE_TASK_RES", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@Requirement_ID", id.Requirement_ID); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID); cmd.Parameters.AddWithValue("@Project_Catagory", id.Project_Catagory); cmd.Parameters.AddWithValue("@Proj_Require_Description", id.Proj_Require_Description); cmd.Parameters.AddWithValue("@Project_Task_Description", id.Project_Task_Description); cmd.Parameters.AddWithValue("@Applicant_Name", id.Applicant_Name); cmd.Parameters.AddWithValue("@Equipment_Description", id.Equipment_Description); cmd.Parameters.AddWithValue("@Vehicle", id.Vehicle); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.Proj_Require_Task_Res_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public Pro_Require_Task_Res Insert_Pro_Require_Task_Res_select(int ID) { Pro_Require_Task_Res = Pro_Require_Task_Res.Select(ID); Insert_project_id_txt.Text = Convert.ToString(Pro_Require_Task_Res.project_id); Insert_Requirement_ID_txt.Text = Convert.ToString(Pro_Require_Task_Res.Requirement_ID); Insert_task_id_txt.Text = Convert.ToString(Pro_Require_Task_Res.task_id); Insert_Resource_ID_txt.Text = Convert.ToString(Pro_Require_Task_Res.Resource_ID); Insert_Project_Catagory_txt.Text = Convert.ToString(Pro_Require_Task_Res.Project_Catagory); Insert_Proj_Require_Description_txt.Text = Convert.ToString(Pro_Require_Task_Res.Proj_Require_Description); Insert_Project_Task_Description_txt.Text = Convert.ToString(Pro_Require_Task_Res.Project_Task_Description); Insert_Applicant_Name_txt.Text = Convert.ToString(Pro_Require_Task_Res.Applicant_Name); Insert_Equipment_Description_txt.Text = Convert.ToString(Pro_Require_Task_Res.Equipment_Description); Insert_Vehicle_txt.Text = Convert.ToString(Pro_Require_Task_Res.Vehicle); return Pro_Require_Task_Res; }
public Pro_Require_Task_Res Insert_Pro_Require_Task_Res_select(int ID) { Pro_Require_Task_Res = Pro_Require_Task_Res.Select(ID); Insert_project_id_txt.Text = Convert.ToString(Pro_Require_Task_Res.project_id); Insert_Requirement_ID_txt.Text = Convert.ToString(Pro_Require_Task_Res.Requirement_ID); Insert_task_id_txt.Text = Convert.ToString(Pro_Require_Task_Res.task_id); Insert_Resource_ID_txt.Text = Convert.ToString(Pro_Require_Task_Res.Resource_ID); Insert_Project_Catagory_txt.Text = Convert.ToString(Pro_Require_Task_Res.Project_Catagory); Insert_Proj_Require_Description_txt.Text = Convert.ToString(Pro_Require_Task_Res.Proj_Require_Description); Insert_Project_Task_Description_txt.Text = Convert.ToString(Pro_Require_Task_Res.Project_Task_Description); Insert_Applicant_Name_txt.Text = Convert.ToString(Pro_Require_Task_Res.Applicant_Name); Insert_Equipment_Description_txt.Text = Convert.ToString(Pro_Require_Task_Res.Equipment_Description); Insert_Vehicle_txt.Text = Convert.ToString(Pro_Require_Task_Res.Vehicle); return(Pro_Require_Task_Res); }
public Pro_Require_Task_Res Pro_Require_Task_Res_insert() { Pro_Require_Task_Res.project_id = Convert.ToInt32(Insert_project_id_txt.Text); Pro_Require_Task_Res.Requirement_ID = Convert.ToInt32(Insert_Requirement_ID_txt.Text); Pro_Require_Task_Res.task_id = Convert.ToInt32(Insert_task_id_txt.Text); Pro_Require_Task_Res.Resource_ID = Convert.ToInt32(Insert_Resource_ID_txt.Text); Pro_Require_Task_Res.Project_Catagory = Insert_Project_Catagory_txt.Text; Pro_Require_Task_Res.Proj_Require_Description = Insert_Proj_Require_Description_txt.Text; Pro_Require_Task_Res.Project_Task_Description = Insert_Project_Task_Description_txt.Text; Pro_Require_Task_Res.Applicant_Name = Insert_Applicant_Name_txt.Text; Pro_Require_Task_Res.Equipment_Description = Insert_Equipment_Description_txt.Text; Pro_Require_Task_Res.Vehicle = Insert_Vehicle_txt.Text; Pro_Require_Task_Res = Pro_Require_Task_Res.Insert(Pro_Require_Task_Res); Insert_Pro_Require_Task_Res_GridView.DataBind(); Update_Pro_Require_Task_Res_GridView.DataBind(); Delete_Pro_Require_Task_Res_GridView.DataBind(); return(Pro_Require_Task_Res); }
public Pro_Require_Task_Res Pro_Require_Task_Res_update(int ID) { Pro_Require_Task_Res = Pro_Require_Task_Res.Select(ID); Pro_Require_Task_Res.Proj_Require_Task_Res_ID = Convert.ToInt32(Update_Proj_Require_Task_Res_ID_txt.Text); Pro_Require_Task_Res.project_id = Convert.ToInt32(Update_project_id_txt.Text); Pro_Require_Task_Res.Requirement_ID = Convert.ToInt32(Update_Requirement_ID_txt.Text); Pro_Require_Task_Res.task_id = Convert.ToInt32(Update_task_id_txt.Text); Pro_Require_Task_Res.Resource_ID = Convert.ToInt32(Update_Resource_ID_txt.Text); Pro_Require_Task_Res.Project_Catagory = Update_Project_Catagory_txt.Text; Pro_Require_Task_Res.Proj_Require_Description = Update_Proj_Require_Description_txt.Text; Pro_Require_Task_Res.Project_Task_Description = Update_Project_Task_Description_txt.Text; Pro_Require_Task_Res.Applicant_Name = Update_Applicant_Name_txt.Text; Pro_Require_Task_Res.Equipment_Description = Update_Equipment_Description_txt.Text; Pro_Require_Task_Res.Vehicle = Update_Vehicle_txt.Text; Pro_Require_Task_Res.Update(Pro_Require_Task_Res); Insert_Pro_Require_Task_Res_GridView.DataBind(); Update_Pro_Require_Task_Res_GridView.DataBind(); Delete_Pro_Require_Task_Res_GridView.DataBind(); return(Pro_Require_Task_Res); }
public Pro_Require_Task_Res Insert(Pro_Require_Task_Res id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_PRO_REQUIRE_TASK_RES", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@Requirement_ID", id.Requirement_ID); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID); cmd.Parameters.AddWithValue("@Project_Catagory", id.Project_Catagory); cmd.Parameters.AddWithValue("@Proj_Require_Description", id.Proj_Require_Description); cmd.Parameters.AddWithValue("@Project_Task_Description", id.Project_Task_Description); cmd.Parameters.AddWithValue("@Applicant_Name", id.Applicant_Name); cmd.Parameters.AddWithValue("@Equipment_Description", id.Equipment_Description); cmd.Parameters.AddWithValue("@Vehicle", id.Vehicle); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_PRO_REQUIRE_TASK_RES", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@Requirement_ID", id.Requirement_ID); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID); cmd.Parameters.AddWithValue("@Project_Catagory", id.Project_Catagory); cmd.Parameters.AddWithValue("@Proj_Require_Description", id.Proj_Require_Description); cmd.Parameters.AddWithValue("@Project_Task_Description", id.Project_Task_Description); cmd.Parameters.AddWithValue("@Applicant_Name", id.Applicant_Name); cmd.Parameters.AddWithValue("@Equipment_Description", id.Equipment_Description); cmd.Parameters.AddWithValue("@Vehicle", id.Vehicle); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.Proj_Require_Task_Res_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public Pro_Require_Task_Res Select(int id) { Pro_Require_Task_Res Pro_Require_Task_Res = new Pro_Require_Task_Res(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_PRO_REQUIRE_TASK_RES", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Proj_Require_Task_Res_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Pro_Require_Task_Res.Proj_Require_Task_Res_ID = rdr.GetInt32(0); } else { Pro_Require_Task_Res.Proj_Require_Task_Res_ID = 0; } if (!rdr.IsDBNull(1)) { Pro_Require_Task_Res.project_id = rdr.GetInt32(1); } else { Pro_Require_Task_Res.project_id = 0; } if (!rdr.IsDBNull(2)) { Pro_Require_Task_Res.Requirement_ID = rdr.GetInt32(2); } else { Pro_Require_Task_Res.Requirement_ID = 0; } if (!rdr.IsDBNull(3)) { Pro_Require_Task_Res.task_id = rdr.GetInt32(3); } else { Pro_Require_Task_Res.task_id = 0; } if (!rdr.IsDBNull(4)) { Pro_Require_Task_Res.Resource_ID = rdr.GetInt32(4); } else { Pro_Require_Task_Res.Resource_ID = 0; } if (!rdr.IsDBNull(5)) { Pro_Require_Task_Res.Project_Catagory = rdr.GetString(5); } else { Pro_Require_Task_Res.Project_Catagory = " "; } if (!rdr.IsDBNull(6)) { Pro_Require_Task_Res.Proj_Require_Description = rdr.GetString(6); } else { Pro_Require_Task_Res.Proj_Require_Description = " "; } if (!rdr.IsDBNull(7)) { Pro_Require_Task_Res.Project_Task_Description = rdr.GetString(7); } else { Pro_Require_Task_Res.Project_Task_Description = " "; } if (!rdr.IsDBNull(8)) { Pro_Require_Task_Res.Applicant_Name = rdr.GetString(8); } else { Pro_Require_Task_Res.Applicant_Name = " "; } if (!rdr.IsDBNull(9)) { Pro_Require_Task_Res.Equipment_Description = rdr.GetString(9); } else { Pro_Require_Task_Res.Equipment_Description = " "; } if (!rdr.IsDBNull(10)) { Pro_Require_Task_Res.Vehicle = rdr.GetString(10); } else { Pro_Require_Task_Res.Vehicle = " "; } } else { Pro_Require_Task_Res.SetColumnDefaults(); } } catch (Exception ex) { Pro_Require_Task_Res.SetColumnDefaults(); return(Pro_Require_Task_Res); } finally { con.Close(); } return(Pro_Require_Task_Res); }
protected void INSERT(object sender, EventArgs e) { Pro_Require_Task_Res = Pro_Require_Task_Res_insert(); }
///////////////////////// //////////////////////// /////////////////////// ////////////////////// ///////////////////// //Insert Tab Methods protected void Insert_Select_Record(object sender, EventArgs e) { Pro_Require_Task_Res = Insert_Pro_Require_Task_Res_select(Convert.ToInt32(Insert_Pro_Require_Task_Res_GridView.SelectedValue)); }
protected void UPDATE(object sender, EventArgs e) { Pro_Require_Task_Res = Pro_Require_Task_Res_update(Convert.ToInt32(Update_Pro_Require_Task_Res_GridView.SelectedValue)); }
public Pro_Require_Task_Res Pro_Require_Task_Res_insert() { Pro_Require_Task_Res.project_id = Convert.ToInt32(Insert_project_id_txt.Text); Pro_Require_Task_Res.Requirement_ID = Convert.ToInt32(Insert_Requirement_ID_txt.Text); Pro_Require_Task_Res.task_id = Convert.ToInt32(Insert_task_id_txt.Text); Pro_Require_Task_Res.Resource_ID = Convert.ToInt32(Insert_Resource_ID_txt.Text); Pro_Require_Task_Res.Project_Catagory = Insert_Project_Catagory_txt.Text; Pro_Require_Task_Res.Proj_Require_Description = Insert_Proj_Require_Description_txt.Text; Pro_Require_Task_Res.Project_Task_Description = Insert_Project_Task_Description_txt.Text; Pro_Require_Task_Res.Applicant_Name = Insert_Applicant_Name_txt.Text; Pro_Require_Task_Res.Equipment_Description = Insert_Equipment_Description_txt.Text; Pro_Require_Task_Res.Vehicle = Insert_Vehicle_txt.Text; Pro_Require_Task_Res = Pro_Require_Task_Res.Insert(Pro_Require_Task_Res); Insert_Pro_Require_Task_Res_GridView.DataBind(); Update_Pro_Require_Task_Res_GridView.DataBind(); Delete_Pro_Require_Task_Res_GridView.DataBind(); return Pro_Require_Task_Res; }
///////////////////////// //////////////////////// /////////////////////// ////////////////////// ///////////////////// //Update Tab Methods protected void Update_Select_Record(object sender, EventArgs e) { Pro_Require_Task_Res = Update_Pro_Require_Task_Res_select(Convert.ToInt32(Update_Pro_Require_Task_Res_GridView.SelectedValue)); }
public Pro_Require_Task_Res Select(int id) { Pro_Require_Task_Res Pro_Require_Task_Res = new Pro_Require_Task_Res(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_PRO_REQUIRE_TASK_RES", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Proj_Require_Task_Res_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Pro_Require_Task_Res.Proj_Require_Task_Res_ID = rdr.GetInt32(0); } else { Pro_Require_Task_Res.Proj_Require_Task_Res_ID = 0; } if (!rdr.IsDBNull(1)) { Pro_Require_Task_Res.project_id = rdr.GetInt32(1); } else { Pro_Require_Task_Res.project_id = 0; } if (!rdr.IsDBNull(2)) { Pro_Require_Task_Res.Requirement_ID = rdr.GetInt32(2); } else { Pro_Require_Task_Res.Requirement_ID = 0; } if (!rdr.IsDBNull(3)) { Pro_Require_Task_Res.task_id = rdr.GetInt32(3); } else { Pro_Require_Task_Res.task_id = 0; } if (!rdr.IsDBNull(4)) { Pro_Require_Task_Res.Resource_ID = rdr.GetInt32(4); } else { Pro_Require_Task_Res.Resource_ID = 0; } if (!rdr.IsDBNull(5)) { Pro_Require_Task_Res.Project_Catagory = rdr.GetString(5); } else { Pro_Require_Task_Res.Project_Catagory = " "; } if (!rdr.IsDBNull(6)) { Pro_Require_Task_Res.Proj_Require_Description = rdr.GetString(6); } else { Pro_Require_Task_Res.Proj_Require_Description = " "; } if (!rdr.IsDBNull(7)) { Pro_Require_Task_Res.Project_Task_Description = rdr.GetString(7); } else { Pro_Require_Task_Res.Project_Task_Description = " "; } if (!rdr.IsDBNull(8)) { Pro_Require_Task_Res.Applicant_Name = rdr.GetString(8); } else { Pro_Require_Task_Res.Applicant_Name = " "; } if (!rdr.IsDBNull(9)) { Pro_Require_Task_Res.Equipment_Description = rdr.GetString(9); } else { Pro_Require_Task_Res.Equipment_Description = " "; } if (!rdr.IsDBNull(10)) { Pro_Require_Task_Res.Vehicle = rdr.GetString(10); } else { Pro_Require_Task_Res.Vehicle = " "; } } else { Pro_Require_Task_Res.SetColumnDefaults(); } } catch (Exception ex) { Pro_Require_Task_Res.SetColumnDefaults(); return Pro_Require_Task_Res; } finally { con.Close(); } return Pro_Require_Task_Res; }
public Boolean Update(Pro_Require_Task_Res id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_PRO_REQUIRE_TASK_RES", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Proj_Require_Task_Res_ID", id.Proj_Require_Task_Res_ID); cmd.Parameters.AddWithValue("@project_id", id.project_id); cmd.Parameters.AddWithValue("@Requirement_ID", id.Requirement_ID); cmd.Parameters.AddWithValue("@task_id", id.task_id); cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID); cmd.Parameters.AddWithValue("@Project_Catagory", id.Project_Catagory); cmd.Parameters.AddWithValue("@Proj_Require_Description", id.Proj_Require_Description); cmd.Parameters.AddWithValue("@Project_Task_Description", id.Project_Task_Description); cmd.Parameters.AddWithValue("@Applicant_Name", id.Applicant_Name); cmd.Parameters.AddWithValue("@Equipment_Description", id.Equipment_Description); cmd.Parameters.AddWithValue("@Vehicle", id.Vehicle); cmd.ExecuteReader(); con.Close(); return true; } catch (Exception ex) { return false; } finally { con.Close(); } }
public Pro_Require_Task_Res Pro_Require_Task_Res_update(int ID) { Pro_Require_Task_Res = Pro_Require_Task_Res.Select(ID); Pro_Require_Task_Res.Proj_Require_Task_Res_ID = Convert.ToInt32(Update_Proj_Require_Task_Res_ID_txt.Text); Pro_Require_Task_Res.project_id = Convert.ToInt32(Update_project_id_txt.Text); Pro_Require_Task_Res.Requirement_ID = Convert.ToInt32(Update_Requirement_ID_txt.Text); Pro_Require_Task_Res.task_id = Convert.ToInt32(Update_task_id_txt.Text); Pro_Require_Task_Res.Resource_ID = Convert.ToInt32(Update_Resource_ID_txt.Text); Pro_Require_Task_Res.Project_Catagory = Update_Project_Catagory_txt.Text; Pro_Require_Task_Res.Proj_Require_Description = Update_Proj_Require_Description_txt.Text; Pro_Require_Task_Res.Project_Task_Description = Update_Project_Task_Description_txt.Text; Pro_Require_Task_Res.Applicant_Name = Update_Applicant_Name_txt.Text; Pro_Require_Task_Res.Equipment_Description = Update_Equipment_Description_txt.Text; Pro_Require_Task_Res.Vehicle = Update_Vehicle_txt.Text; Pro_Require_Task_Res.Update(Pro_Require_Task_Res); Insert_Pro_Require_Task_Res_GridView.DataBind(); Update_Pro_Require_Task_Res_GridView.DataBind(); Delete_Pro_Require_Task_Res_GridView.DataBind(); return Pro_Require_Task_Res; }