public UserPaginationDTO getTenUser(int currentPage)
{
int maxRows = 10;
using (MVCCRUDKNOCKOUTEntities dbEntities = new MVCCRUDKNOCKOUTEntities())
{
UserPaginationDTO userPaginationDTO = new UserPaginationDTO();
// userPaginationDTO = dbEntities.UserDetail.OrderBy(ds => ds.ID).Skip((currentPage - 1) * maxRows).Take(maxRows);
userPaginationDTO.User = (from ds in dbEntities.UserDetail
select new GetAllUsersDTO()
{
ID = ds.ID,
Address = ds.Address,
Age = ds.Age,
Name = ds.Name,
Gender = ds.Gender,
PhoneNumber = ds.PhoneNumber
})
.OrderBy(ds => ds.ID)
.Skip((currentPage - 1) * maxRows)
.Take(maxRows).ToList();
double pageCount = (double)(dbEntities.UserDetail.Count() / Convert.ToDecimal(maxRows));
userPaginationDTO.PageCount = (int)Math.Ceiling(pageCount);
userPaginationDTO.CurrentPage = currentPage;
return(userPaginationDTO);
}
}
public UserDetail getUser(int id)
{
using (MVCCRUDKNOCKOUTEntities dbEntities = new MVCCRUDKNOCKOUTEntities())
{
UserDetail user = dbEntities.UserDetail.Where(ds => ds.ID == id).FirstOrDefault();
return(user);
}
}
public bool InsertUser(UserDetail user)
{
using (MVCCRUDKNOCKOUTEntities dbEntities = new MVCCRUDKNOCKOUTEntities())
{
dbEntities.UserDetail.Add(user);
dbEntities.SaveChanges();
return(true);
}
}
public bool DeleteUser(int UserID)
{
using (MVCCRUDKNOCKOUTEntities dbEntities = new MVCCRUDKNOCKOUTEntities())
{
var deleteItem = dbEntities.UserDetail.FirstOrDefault(c => c.ID == UserID);
if (deleteItem != null)
{
dbEntities.UserDetail.Remove(deleteItem);
dbEntities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool update(int id, GetAllUsersDTO user)
{
using (MVCCRUDKNOCKOUTEntities dbEntities = new MVCCRUDKNOCKOUTEntities())
{
var updateItem = dbEntities.UserDetail.FirstOrDefault(c => c.ID == id);
if (updateItem != null)
{
updateItem.Address = user.Address;
updateItem.Age = user.Age;
updateItem.Name = user.Name;
updateItem.PhoneNumber = user.PhoneNumber;
updateItem.Gender = user.Gender;
dbEntities.Entry(updateItem).State = System.Data.Entity.EntityState.Modified;
dbEntities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public IList <GetAllUsersDTO> SearchUser(string SearchUser)
{
using (MVCCRUDKNOCKOUTEntities dbEntities = new MVCCRUDKNOCKOUTEntities())
{
IList <GetAllUsersDTO> userList = new List <GetAllUsersDTO>();
userList = (from u in dbEntities.UserDetail.Where(ds => ds.Name.Contains(SearchUser))
select new GetAllUsersDTO()
{
ID = u.ID,
Name = u.Name,
Address = u.Address,
Age = u.Age,
Gender = u.Gender,
}).ToList();
if (userList.Count > 0)
{
return(userList);
}
else
{
return(null);
}
}
}