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