public void InsertUsers(DTO_users user) { conn.Open(); string sql = "INSERT INTO users (username,userstatus,userip) VALUES (@username,@userstatus,@userip)"; using (SqlCommand sqlCmd = new SqlCommand(sql, conn)) { sqlCmd.Parameters.AddWithValue("@username", user.username); sqlCmd.Parameters.AddWithValue("@userstatus", user.userstatus); sqlCmd.Parameters.AddWithValue("@userip", user.userip); sqlCmd.ExecuteNonQuery(); } conn.Close(); }
public void UpdateUsers(DTO_users user) { conn.Open(); string sql = "UPDATE users SET username = @username, userstatus = @userstatus, userip = @userip WHERE userid = @userid"; using (SqlCommand sqlCmd = new SqlCommand(sql, conn)) { sqlCmd.Parameters.AddWithValue("@username", user.username); sqlCmd.Parameters.AddWithValue("@userstatus", user.userstatus); sqlCmd.Parameters.AddWithValue("@userip", user.userip); sqlCmd.Parameters.AddWithValue("@userid", user.userid); sqlCmd.ExecuteNonQuery(); } conn.Close(); }
public DTO_users GetUsers(int userid) { DTO_users user = new DTO_users(); DataTable dataTable = new DataTable(); conn.Open(); string sql = "SELECT * FROM users WHERE userid = @userid"; using (SqlCommand SqlCmd = new SqlCommand(sql, conn)) { SqlCmd.Parameters.AddWithValue("@userid", userid); using (SqlDataAdapter dataAdapter = new SqlDataAdapter(SqlCmd)) { dataAdapter.Fill(dataTable); } } user.userid = dataTable.Rows[0].Field <int>(0); user.username = dataTable.Rows[0].Field <string>(1); user.userstatus = dataTable.Rows[0].Field <bool>(2); conn.Close(); return(user); }
public void UpdateUsers(DTO_users user) { DAL_USER.UpdateUsers(user); }
public void InsertUsers(DTO_users user) { DAL_USER.InsertUsers(user); }