Example #1
0
        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();
            }
        }
Example #2
0
        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;
 }
Example #4
0
 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);
 }
Example #5
0
 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);
 }
Example #6
0
 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;
 }
Example #8
0
        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);
        }
Example #9
0
 protected void INSERT(object sender, EventArgs e)
 {
     Pro_Require_Task_Res = Pro_Require_Task_Res_insert();
 }
 protected void INSERT(object sender, EventArgs e)
 {
     Pro_Require_Task_Res = Pro_Require_Task_Res_insert();
 }
Example #11
0
 /////////////////////////
 ////////////////////////
 ///////////////////////
 //////////////////////
 /////////////////////
 //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));
 }
Example #12
0
 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));
 }
 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 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;
 }