public List <dtoSystemPrivilege> GetSystemPrivileges()
{
dalSystemPrivilege dalSystemPrivilege = new dalSystemPrivilege();
List <dtoSystemPrivilege> listEmp = new List <dtoSystemPrivilege>();
DataTable SystemPrivileges = dalSystemPrivilege.GetSystemPrivileges();
for (int i = 0; i < SystemPrivileges.Rows.Count; i++)
{
dtoSystemPrivilege SystemPrivilege = new dtoSystemPrivilege();
DataRow row = SystemPrivileges.Rows[i];
SystemPrivilege.PrivilegeID = Convert.ToInt32(row[0]);
SystemPrivilege.PrivilegeName = row[1].ToString();
listEmp.Add(SystemPrivilege);
}
return(listEmp);
}
/// <summary>
/// Hàm để Insert một đối tượng vào Database
/// </summary>
/// <param name="privilege"></param>
/// <returns></returns>
public int InsertPrivilege(dtoSystemPrivilege privilege)
{
int count = 0;
try
{
string sql = "INSERT [dbo].[SystemPrivilege] ([PrivilegeName]) VALUES (@PrivilegeName)";
SqlParameter parameterPrivilegeName = new SqlParameter("@PrivilegeName", SqlDbType.Int);
parameterPrivilegeName.Value = privilege.PrivilegeName;
count = InsertUpdateDeleteData(sql, new[] { parameterPrivilegeName });
}
finally
{
CloseConnection();
}
return(count);
}
public int UpdatePrivilege(dtoSystemPrivilege privilege)
{
int count = 0;
try
{
string sql = "UPDATE [dbo].[SystemPrivilege] SET [PrivilegeName] = @PrivilegeName WHERE [PrivilegeID] = @PrivilegeID";
SqlParameter parameterPrivilegeID = new SqlParameter("@PrivilegeID", SqlDbType.Int);
parameterPrivilegeID.Value = privilege.PrivilegeID;
SqlParameter parameterPrivilegeName = new SqlParameter("@PrivilegeName", SqlDbType.NVarChar);
parameterPrivilegeName.Value = privilege.PrivilegeName;
count = InsertUpdateDeleteData(sql, new[] { parameterPrivilegeID, parameterPrivilegeName });
}
finally
{
CloseConnection();
}
return(count);
}
