public void edit(USER_PERMISSIONS obj)
{
DAL.edit(obj.UserPermissionID, obj.UserID, obj.Category, obj.Permission, obj.Allowed, obj.Type, obj.Active);
}
public void delete(USER_PERMISSIONS obj)
{
DAL.delete(obj.UserPermissionID);
}
// dung file get data
// dung file get list( data source)
public List <USER_PERMISSIONS> getDataSource()
{
List <USER_PERMISSIONS> list = new List <USER_PERMISSIONS>();
USER_PERMISSIONS obj = null;
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
String sql = "USE [rbi]" +
"SELECT [UserPermissionID]" +
",[UserID]" +
",[Category]" +
",[Permission]" +
",[Allowed]" +
",[Type]" +
",[Active]" +
" FROM [rbi].[dbo].[USER_PERMISSIONS]";
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader.HasRows)
{
obj = new USER_PERMISSIONS();
obj.UserPermissionID = reader.GetInt32(0);
if (!reader.IsDBNull(1))
{
obj.UserID = reader.GetString(1);
}
if (!reader.IsDBNull(2))
{
obj.Category = reader.GetString(2);
}
if (!reader.IsDBNull(3))
{
obj.Permission = reader.GetString(3);
}
obj.Allowed = reader.GetInt32(4);
if (!reader.IsDBNull(5))
{
obj.Type = reader.GetString(5);
}
obj.Active = reader.GetInt32(5);
list.Add(obj);
}
}
}
}
catch
{
MessageBox.Show("GET DATA SOURCE FAIL!");
}
finally
{
conn.Close();
}
return(list);
}
