public void Put(int id, Lock_Account la)
{
using (SqlConnection dbConnection = new SqlConnection(Conn))
{
dbConnection.Open();
using (SqlCommand command = new SqlCommand("UPDATE shabz_lock_account SET AccountId = @accountId, LockId = @lockId, RoleId = @roleId WHERE id = @id", dbConnection))
{
command.Parameters.AddWithValue("@id", id);
command.Parameters.AddWithValue("@accountId", la.AccountId);
command.Parameters.AddWithValue("@lockId", la.LockId);
command.Parameters.AddWithValue("@roleId", la.RoleId);
command.ExecuteNonQuery();
}
}
}
public void Post(Lock_Account la)
{
using (SqlConnection dbConnection = new SqlConnection(Conn))
{
dbConnection.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO shabz_lock_account (AccountId, LockId, RoleId) VALUES (@accountId, @lockId, @roleId)", dbConnection))
{
command.Parameters.AddWithValue("@accountId", la.AccountId);
command.Parameters.AddWithValue("@lockId", la.LockId);
command.Parameters.AddWithValue("@roleId", la.RoleId);
command.ExecuteNonQuery();
}
}
}
public Lock_Account Get(int id)
{
using (SqlConnection dbConnection = new SqlConnection(Conn))
{
dbConnection.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM shabz_lock_account WHERE Id = @id", dbConnection))
{
command.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Lock_Account la = new Lock_Account(Convert.ToInt32(reader[0]), Convert.ToInt32(reader[1]), Convert.ToInt32(reader[2]), Convert.ToInt32(reader[3]));
return(la);
}
}
}
}
return(null);
}
public List <Lock_Account> GetLockAccount()
{
LAList.Clear();
using (SqlConnection dbConnection = new SqlConnection(Conn))
{
dbConnection.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM shabz_lock_account", dbConnection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Lock_Account la = new Lock_Account(Convert.ToInt32(reader[0]), Convert.ToInt32(reader[1]), Convert.ToInt32(reader[2]), Convert.ToInt32(reader[3]));
LAList.Add(la);
}
}
}
}
return(LAList);
}
