public disaster_project_task Insert_disaster_project_task_select(int ID) { disaster_project_task = disaster_project_task.Select(ID); Insert_skills_id_txt.Text = Convert.ToString(disaster_project_task.skills_id); Insert_disaster_project_task_description_txt.Text = Convert.ToString(disaster_project_task.disaster_project_task_description); return(disaster_project_task); }
public disaster_project_task Insert(disaster_project_task id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DISASTER_PROJECT_TASK", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@skills_id", id.skills_id); cmd.Parameters.AddWithValue("@disaster_project_task_description", id.disaster_project_task_description); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DISASTER_PROJECT_TASK", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@skills_id", id.skills_id); cmd.Parameters.AddWithValue("@disaster_project_task_description", id.disaster_project_task_description); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.disaster_project_task_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public Boolean Update(disaster_project_task id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_DISASTER_PROJECT_TASK", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_project_task_id", id.disaster_project_task_id); cmd.Parameters.AddWithValue("@skills_id", id.skills_id); cmd.Parameters.AddWithValue("@disaster_project_task_description", id.disaster_project_task_description); cmd.ExecuteReader(); con.Close(); return(true); } catch (Exception ex) { return(false); } finally { con.Close(); } }
public disaster_project_task Delete_disaster_project_task_select(int ID) { disaster_project_task = disaster_project_task.Select(ID); Delete_disaster_project_task_id_txt_lbl.Text = Convert.ToString(disaster_project_task.disaster_project_task_id); Delete_skills_id_txt_lbl.Text = Convert.ToString(disaster_project_task.skills_id); Delete_disaster_project_task_description_txt_lbl.Text = Convert.ToString(disaster_project_task.disaster_project_task_description); return disaster_project_task; }
public disaster_project_task Select(int id) { disaster_project_task disaster_project_task = new disaster_project_task(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DISASTER_PROJECT_TASK", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_project_task_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { disaster_project_task.disaster_project_task_id = rdr.GetInt32(0); } else { disaster_project_task.disaster_project_task_id = 0; } if (!rdr.IsDBNull(1)) { disaster_project_task.skills_id = rdr.GetInt32(1); } else { disaster_project_task.skills_id = 0; } if (!rdr.IsDBNull(2)) { disaster_project_task.disaster_project_task_description = rdr.GetString(2); } else { disaster_project_task.disaster_project_task_description = " "; } } else { disaster_project_task.SetColumnDefaults(); } } catch (Exception ex) { disaster_project_task.SetColumnDefaults(); return(disaster_project_task); } finally { con.Close(); } return(disaster_project_task); }
public disaster_project_task disaster_project_task_insert() { disaster_project_task.skills_id = Convert.ToInt32(Insert_skills_id_txt.Text); disaster_project_task.disaster_project_task_description = Insert_disaster_project_task_description_txt.Text; disaster_project_task = disaster_project_task.Insert(disaster_project_task); Insert_disaster_project_task_GridView.DataBind(); Update_disaster_project_task_GridView.DataBind(); Delete_disaster_project_task_GridView.DataBind(); return(disaster_project_task); }
public disaster_project_task disaster_project_task_insert() { disaster_project_task.skills_id = Convert.ToInt32(Insert_skills_id_txt.Text); disaster_project_task.disaster_project_task_description = Insert_disaster_project_task_description_txt.Text; disaster_project_task = disaster_project_task.Insert(disaster_project_task); Insert_disaster_project_task_GridView.DataBind(); Update_disaster_project_task_GridView.DataBind(); Delete_disaster_project_task_GridView.DataBind(); return disaster_project_task; }
public disaster_project_task disaster_project_task_update(int ID) { disaster_project_task = disaster_project_task.Select(ID); disaster_project_task.disaster_project_task_id = Convert.ToInt32(Update_disaster_project_task_id_txt.Text); disaster_project_task.skills_id = Convert.ToInt32(Update_skills_id_txt.Text); disaster_project_task.disaster_project_task_description = Update_disaster_project_task_description_txt.Text; disaster_project_task.Update(disaster_project_task); Insert_disaster_project_task_GridView.DataBind(); Update_disaster_project_task_GridView.DataBind(); Delete_disaster_project_task_GridView.DataBind(); return(disaster_project_task); }
public disaster_project_task disaster_project_task_update(int ID) { disaster_project_task = disaster_project_task.Select(ID); disaster_project_task.disaster_project_task_id = Convert.ToInt32(Update_disaster_project_task_id_txt.Text); disaster_project_task.skills_id = Convert.ToInt32(Update_skills_id_txt.Text); disaster_project_task.disaster_project_task_description = Update_disaster_project_task_description_txt.Text; disaster_project_task.Update(disaster_project_task); Insert_disaster_project_task_GridView.DataBind(); Update_disaster_project_task_GridView.DataBind(); Delete_disaster_project_task_GridView.DataBind(); return disaster_project_task; }
public disaster_project_task Insert(disaster_project_task id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DISASTER_PROJECT_TASK", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@skills_id", id.skills_id); cmd.Parameters.AddWithValue("@disaster_project_task_description", id.disaster_project_task_description); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DISASTER_PROJECT_TASK", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@skills_id", id.skills_id); cmd.Parameters.AddWithValue("@disaster_project_task_description", id.disaster_project_task_description); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.disaster_project_task_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
///////////////////////// //////////////////////// /////////////////////// ////////////////////// ///////////////////// //Update Tab Methods protected void Update_Select_Record(object sender, EventArgs e) { disaster_project_task = Update_disaster_project_task_select(Convert.ToInt32(Update_disaster_project_task_GridView.SelectedValue)); }
protected void UPDATE(object sender, EventArgs e) { disaster_project_task = disaster_project_task_update(Convert.ToInt32(Update_disaster_project_task_GridView.SelectedValue)); }
protected void INSERT(object sender, EventArgs e) { disaster_project_task = disaster_project_task_insert(); }
public disaster_project_task Select(int id) { disaster_project_task disaster_project_task = new disaster_project_task(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DISASTER_PROJECT_TASK", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_project_task_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { disaster_project_task.disaster_project_task_id = rdr.GetInt32(0); } else { disaster_project_task.disaster_project_task_id = 0; } if (!rdr.IsDBNull(1)) { disaster_project_task.skills_id = rdr.GetInt32(1); } else { disaster_project_task.skills_id = 0; } if (!rdr.IsDBNull(2)) { disaster_project_task.disaster_project_task_description = rdr.GetString(2); } else { disaster_project_task.disaster_project_task_description = " "; } } else { disaster_project_task.SetColumnDefaults(); } } catch (Exception ex) { disaster_project_task.SetColumnDefaults(); return disaster_project_task; } finally { con.Close(); } return disaster_project_task; }
public Boolean Update(disaster_project_task id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_DISASTER_PROJECT_TASK", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_project_task_id", id.disaster_project_task_id); cmd.Parameters.AddWithValue("@skills_id", id.skills_id); cmd.Parameters.AddWithValue("@disaster_project_task_description", id.disaster_project_task_description); cmd.ExecuteReader(); con.Close(); return true; } catch (Exception ex) { return false; } finally { con.Close(); } }