public List<User> GetAllUsers() { using (var entities = new EazyWizyEntities()) { var result = entities.GetAllUsers(); return (from item in result select new User() { CreateDate = item.CreateDate, CreatedBy = item.CreatedBy, EmailID = item.EmailID, FirstName = item.FirstName, HashId = item.HashId, IsActive = item.IsActive, LastName = item.LastName, ModifiedBy = item.ModifiedBy, Password = item.Password, ModifiedDate = item.ModifiedDate, RoleID = item.RoleID, RoleName = item.RoleName, UserID = item.UserID }).ToList(); } }
public void ActiveDeactiveCategory(long categoryId, bool status) { using (var entities = new EazyWizyEntities()) { entities.ManageCategory(categoryId, null, null, null, null, status, null, (int)DatabaseAction.ActiveDeactive); } }
public void AddCategory(Category entity) { using (var entities = new EazyWizyEntities()) { entities.ManageCategory(entity.CategoryId, entity.ParentCategoryId, entity.Name, entity.Description, entity.ImageName, entity.IsActive, null, (int) DatabaseAction.Insert); } }
public List<Category> GetAllCategories() { using (var entities = new EazyWizyEntities()) { var result = entities.GetAllCategories(); return (from item in result select new Category() { CategoryId = item.CategoryId, ImageName = item.ImageName, Description = item.Description, IsActive = item.IsActive.HasValue && item.IsActive.Value, Name = item.Name, ParentCategoryId = item.ParentCategoryId }).ToList(); } }
public void RemoveCategory(long id) { using (var entities = new EazyWizyEntities()) { entities.ManageCategory(id, null, null, null, null, null, null, (int) DatabaseAction.Delete); } }
public User GetUser(string email) { using (var entities = new EazyWizyEntities()) { var result = entities.GetUser(email); return (from item in result select new User() { CreateDate = item.CreateDate, CreatedBy = item.CreatedBy, EmailID = item.EmailID, FirstName = item.FirstName, HashId = item.HashId, IsActive = item.IsActive, LastName = item.LastName, ModifiedBy = item.ModifiedBy, Password = item.Password, ModifiedDate = item.ModifiedDate, RoleID = item.RoleID, RoleName = item.RoleName, UserID = item.UserID }).SingleOrDefault(); } }