public Boolean Update(disasterDMCS id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_DISASTERDMCS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id.disaster_id); cmd.Parameters.AddWithValue("@disaster_description", id.disaster_description); cmd.ExecuteReader(); con.Close(); return(true); } catch (Exception ex) { return(false); } finally { con.Close(); } }
public disasterDMCS Insert(disasterDMCS id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DISASTERDMCS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_description", id.disaster_description); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DISASTERDMCS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_description", id.disaster_description); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.disaster_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public disasterDMCS Delete_disasterDMCS_select(int ID) { disasterDMCS = disasterDMCS.Select(ID); Delete_disaster_id_txt_lbl.Text = Convert.ToString(disasterDMCS.disaster_id); Delete_disaster_description_txt_lbl.Text = Convert.ToString(disasterDMCS.disaster_description); return disasterDMCS; }
public disasterDMCS Update_disasterDMCS_select(int ID) { disasterDMCS = disasterDMCS.Select(ID); Update_disaster_id_txt.Text = Convert.ToString(disasterDMCS.disaster_id); Update_disaster_description_txt.Text = Convert.ToString(disasterDMCS.disaster_description); return(disasterDMCS); }
public disasterDMCS Insert(disasterDMCS id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DISASTERDMCS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_description", id.disaster_description); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DISASTERDMCS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_description", id.disaster_description); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.disaster_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public disasterDMCS disasterDMCS_insert() { disasterDMCS.disaster_description = Insert_disaster_description_txt.Text; disasterDMCS = disasterDMCS.Insert(disasterDMCS); Insert_disasterDMCS_GridView.DataBind(); Update_disasterDMCS_GridView.DataBind(); Delete_disasterDMCS_GridView.DataBind(); return disasterDMCS; }
public disasterDMCS disasterDMCS_insert() { disasterDMCS.disaster_description = Insert_disaster_description_txt.Text; disasterDMCS = disasterDMCS.Insert(disasterDMCS); Insert_disasterDMCS_GridView.DataBind(); Update_disasterDMCS_GridView.DataBind(); Delete_disasterDMCS_GridView.DataBind(); return(disasterDMCS); }
public disasterDMCS disasterDMCS_update(int ID) { disasterDMCS = disasterDMCS.Select(ID); disasterDMCS.disaster_id = Convert.ToInt32(Update_disaster_id_txt.Text); disasterDMCS.disaster_description = Update_disaster_description_txt.Text; disasterDMCS.Update(disasterDMCS); Insert_disasterDMCS_GridView.DataBind(); Update_disasterDMCS_GridView.DataBind(); Delete_disasterDMCS_GridView.DataBind(); return disasterDMCS; }
public disasterDMCS disasterDMCS_update(int ID) { disasterDMCS = disasterDMCS.Select(ID); disasterDMCS.disaster_id = Convert.ToInt32(Update_disaster_id_txt.Text); disasterDMCS.disaster_description = Update_disaster_description_txt.Text; disasterDMCS.Update(disasterDMCS); Insert_disasterDMCS_GridView.DataBind(); Update_disasterDMCS_GridView.DataBind(); Delete_disasterDMCS_GridView.DataBind(); return(disasterDMCS); }
public disasterDMCS Select(int id) { disasterDMCS disasterDMCS = new disasterDMCS(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DISASTERDMCS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { disasterDMCS.disaster_id = rdr.GetInt32(0); } else { disasterDMCS.disaster_id = 0; } if (!rdr.IsDBNull(1)) { disasterDMCS.disaster_description = rdr.GetString(1); } else { disasterDMCS.disaster_description = " "; } } else { disasterDMCS.SetColumnDefaults(); } } catch (Exception ex) { disasterDMCS.SetColumnDefaults(); return(disasterDMCS); } finally { con.Close(); } return(disasterDMCS); }
public disasterDMCS Select(int id) { disasterDMCS disasterDMCS = new disasterDMCS(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DISASTERDMCS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { disasterDMCS.disaster_id = rdr.GetInt32(0); } else { disasterDMCS.disaster_id = 0; } if (!rdr.IsDBNull(1)) { disasterDMCS.disaster_description = rdr.GetString(1); } else { disasterDMCS.disaster_description = " "; } } else { disasterDMCS.SetColumnDefaults(); } } catch (Exception ex) { disasterDMCS.SetColumnDefaults(); return disasterDMCS; } finally { con.Close(); } return disasterDMCS; }
public disasterDMCS Insert_disasterDMCS_select(int ID) { disasterDMCS = disasterDMCS.Select(ID); Insert_disaster_description_txt.Text = Convert.ToString(disasterDMCS.disaster_description); return disasterDMCS; }
///////////////////////// //////////////////////// /////////////////////// ////////////////////// ///////////////////// //Update Tab Methods protected void Update_Select_Record(object sender, EventArgs e) { disasterDMCS = Update_disasterDMCS_select(Convert.ToInt32(Update_disasterDMCS_GridView.SelectedValue)); }
protected void UPDATE(object sender, EventArgs e) { disasterDMCS = disasterDMCS_update(Convert.ToInt32(Update_disasterDMCS_GridView.SelectedValue)); }
public Boolean Update(disasterDMCS id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_DISASTERDMCS", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@disaster_id", id.disaster_id); cmd.Parameters.AddWithValue("@disaster_description", id.disaster_description); cmd.ExecuteReader(); con.Close(); return true; } catch (Exception ex) { return false; } finally { con.Close(); } }
protected void INSERT(object sender, EventArgs e) { disasterDMCS = disasterDMCS_insert(); }
public disasterDMCS Insert_disasterDMCS_select(int ID) { disasterDMCS = disasterDMCS.Select(ID); Insert_disaster_description_txt.Text = Convert.ToString(disasterDMCS.disaster_description); return(disasterDMCS); }