public Boolean Update(users2 id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_USERS2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", id.id); cmd.Parameters.AddWithValue("@firstName", id.firstName); cmd.Parameters.AddWithValue("@lastName", id.lastName); cmd.ExecuteReader(); con.Close(); return(true); } catch (Exception ex) { return(false); } finally { con.Close(); } }
public users2 Insert(users2 id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_USERS2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@firstName", id.firstName); cmd.Parameters.AddWithValue("@lastName", id.lastName); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_USERS2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@firstName", id.firstName); cmd.Parameters.AddWithValue("@lastName", id.lastName); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public users2 Insert_users2_select(int ID) { users2 = users2.Select(ID); Insert_firstName_txt.Text = Convert.ToString(users2.firstName); Insert_lastName_txt.Text = Convert.ToString(users2.lastName); return users2; }
public users2 Insert_users2_select(int ID) { users2 = users2.Select(ID); Insert_firstName_txt.Text = Convert.ToString(users2.firstName); Insert_lastName_txt.Text = Convert.ToString(users2.lastName); return(users2); }
public users2 Update_users2_select(int ID) { users2 = users2.Select(ID); Update_id_txt.Text = Convert.ToString(users2.id); Update_firstName_txt.Text = Convert.ToString(users2.firstName); Update_lastName_txt.Text = Convert.ToString(users2.lastName); return(users2); }
public users2 Update_users2_select(int ID) { users2 = users2.Select(ID); Update_id_txt.Text = Convert.ToString(users2.id); Update_firstName_txt.Text = Convert.ToString(users2.firstName); Update_lastName_txt.Text = Convert.ToString(users2.lastName); return users2; }
public users2 Select(int id) { users2 users2 = new users2(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_USERS2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { users2.id = rdr.GetInt32(0); } else { users2.id = 0; } if (!rdr.IsDBNull(1)) { users2.firstName = rdr.GetString(1); } else { users2.firstName = " "; } if (!rdr.IsDBNull(2)) { users2.lastName = rdr.GetString(2); } else { users2.lastName = " "; } } else { users2.SetColumnDefaults(); } } catch (Exception ex) { users2.SetColumnDefaults(); return(users2); } finally { con.Close(); } return(users2); }
public users2 users2_insert() { users2.firstName = Insert_firstName_txt.Text; users2.lastName = Insert_lastName_txt.Text; users2 = users2.Insert(users2); Insert_users2_GridView.DataBind(); Update_users2_GridView.DataBind(); Delete_users2_GridView.DataBind(); return(users2); }
public users2 users2_update(int ID) { users2 = users2.Select(ID); users2.id = Convert.ToInt32(Update_id_txt.Text); users2.firstName = Update_firstName_txt.Text; users2.lastName = Update_lastName_txt.Text; users2.Update(users2); Insert_users2_GridView.DataBind(); Update_users2_GridView.DataBind(); Delete_users2_GridView.DataBind(); return(users2); }
public users2 Insert(users2 id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_USERS2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@firstName", id.firstName); cmd.Parameters.AddWithValue("@lastName", id.lastName); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_USERS2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@firstName", id.firstName); cmd.Parameters.AddWithValue("@lastName", id.lastName); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public Boolean Update(users2 id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_USERS2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", id.id); cmd.Parameters.AddWithValue("@firstName", id.firstName); cmd.Parameters.AddWithValue("@lastName", id.lastName); cmd.ExecuteReader(); con.Close(); return true; } catch (Exception ex) { return false; } finally { con.Close(); } }
///////////////////////// //////////////////////// /////////////////////// ////////////////////// ///////////////////// //Update Tab Methods protected void Update_Select_Record(object sender, EventArgs e) { users2 = Update_users2_select(Convert.ToInt32(Update_users2_GridView.SelectedValue)); }
protected void INSERT(object sender, EventArgs e) { users2 = users2_insert(); }
protected void UPDATE(object sender, EventArgs e) { users2 = users2_update(Convert.ToInt32(Update_users2_GridView.SelectedValue)); }
public users2 Select(int id) { users2 users2 = new users2(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_USERS2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { users2.id = rdr.GetInt32(0); } else { users2.id = 0; } if (!rdr.IsDBNull(1)) { users2.firstName = rdr.GetString(1); } else { users2.firstName = " "; } if (!rdr.IsDBNull(2)) { users2.lastName = rdr.GetString(2); } else { users2.lastName = " "; } } else { users2.SetColumnDefaults(); } } catch (Exception ex) { users2.SetColumnDefaults(); return users2; } finally { con.Close(); } return users2; }
public users2 users2_insert() { users2.firstName = Insert_firstName_txt.Text; users2.lastName = Insert_lastName_txt.Text; users2 = users2.Insert(users2); Insert_users2_GridView.DataBind(); Update_users2_GridView.DataBind(); Delete_users2_GridView.DataBind(); return users2; }
public users2 users2_update(int ID) { users2 = users2.Select(ID); users2.id = Convert.ToInt32(Update_id_txt.Text); users2.firstName = Update_firstName_txt.Text; users2.lastName = Update_lastName_txt.Text; users2.Update(users2); Insert_users2_GridView.DataBind(); Update_users2_GridView.DataBind(); Delete_users2_GridView.DataBind(); return users2; }