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);
}