public IEnumerable <Object> GetAllPaging(int pageIndex, int pageSize, string sortColumn, int sortOrder, List <BodyObject> requestBody)
{
try
{
ProviderDAL providerDAL = new ProviderDAL();
DataTable dt = providerDAL.GetDataPaging("spGetBookPaging", pageIndex, pageSize, sortColumn, sortOrder);
var books = dt.AsEnumerable().Select(row => new Book()
{
Id = (int)row["id"],
BookCode = (string)row["bookcode"],
BookName = (string)row["bookname"],
Inventory = (int)row["inventory"],
Author = (string)row["author"],
MainContent = (string)row["maincontent"],
Description = (string)row["description"],
BookCategory_Id = (int)row["bookcategory_id"],
IsActive = (bool)row["isactive"],
Image = (string)row["image"]
}).ToList();
return(books);
}
catch (Exception ex)
{
throw new Exception("Error from BookDAL: " + ex.Message.ToString());
}
}
public string ModifyProvider(Provider provider)
{
ProviderDAL providerdal = new ProviderDAL();
return(providerdal.ModifyProvider(provider));
}
public IEnumerable <Object> GetAllPaging(int pageIndex, int pageSize, string sortColumn, int sortOrder)
{
try
{
ProviderDAL providerDAL = new ProviderDAL();
DataTable dt = providerDAL.GetDataPaging("spGetStudentPaging", pageIndex, pageSize, sortColumn, sortOrder);
var students = dt.AsEnumerable().Select(row => new Student()
{
Id = (int)row["id"],
StudentCode = (string)row["studentcode"],
StudentName = (string)row["studentname"],
Class = (string)row["class"],
DoB = (DateTime)row["dob"],
NativeLand = (string)row["nativeland"],
Course = (string)row["course"],
Faculty = (string)row["faculty"],
Description = (string)row["description"],
IsActive = (bool)row["isactive"]
}).ToList();
return(students);
}
catch (Exception ex)
{
throw new Exception("Error from StudentDAL: " + ex.Message.ToString());
}
}
public string DeleteProvider(long code)
{
ProviderDAL providerdal = new ProviderDAL();
return(providerdal.DeleteProvider(code));
}
public bool ChangePassword(ProviderDTO provider, string NewPassword)
{
int result = 0;
providerdal = new ProviderDAL();
result = providerdal.ChangePassword(provider, NewPassword);
if (result > 0)
{
return(true);
}
return(false);
}
public IEnumerable <Object> GetAllPaging(int pageIndex, int pageSize, string sortColumn, int sortOrder)
{
try
{
ProviderDAL providerDAL = new ProviderDAL();
DataTable dt = providerDAL.GetDataPaging("spGetUserPaging", pageIndex, pageSize, sortColumn, sortOrder);
var users = dt.AsEnumerable().Select(row => new User()
{
Id = (int)row["id"],
Username = (string)row["username"],
Description = (string)row["description"],
IsActive = (bool)row["isactive"]
}).ToList();
return(users);
}
catch (Exception ex)
{
throw new Exception("Error from UserDAL: " + ex.Message.ToString());
}
}
public IEnumerable <Object> GetAllPaging(int pageIndex, int pageSize, string sortColumn, int sortOrder)
{
try
{
ProviderDAL providerDAL = new ProviderDAL();
DataTable dt = providerDAL.GetDataPaging("spGetPostPaging", pageIndex, pageSize, sortColumn, sortOrder);
var posts = dt.AsEnumerable().Select(row => new Post()
{
Id = (int)row["id"],
CodePost = (string)row["codepost"],
Message = (string)row["message"],
Description = (string)row["description"],
IsActive = (bool)row["isactive"],
}).ToList();
return(posts);
}
catch (Exception ex)
{
throw new Exception("Error from PostDAL: " + ex.Message.ToString());
}
}
public IEnumerable <Object> GetAllPaging(int pageIndex, int pageSize, string sortColumn, int sortOrder)
{
try
{
ProviderDAL providerDAL = new ProviderDAL();
DataTable dt = providerDAL.GetDataPaging("spGetBookCategoryPaging", pageIndex, pageSize, sortColumn, sortOrder);
var bookCategories = dt.AsEnumerable().Select(row => new BookCategory()
{
Id = (int)row["id"],
BookCategoryCode = (string)row["bookcategorycode"],
BookCategoryName = (string)row["bookcategoryname"],
Description = (string)row["description"],
IsActive = (bool)row["isactive"],
}).ToList();
return(bookCategories);
}
catch (Exception ex)
{
throw new Exception("Error from BookCategoryDAL: " + ex.Message.ToString());
}
}
public IEnumerable <Object> GetAllPaging(int pageIndex, int pageSize, string sortColumn, int sortOrder, List <BodyObject> requestBody)
{
try
{
ProviderDAL providerDAL = new ProviderDAL();
DataTable dt = providerDAL.GetDataPaging("spGetBorrowBookPaging", pageIndex, pageSize, sortColumn, sortOrder);
var borrowBooks = dt.AsEnumerable().Select(row => new BorrowBook()
{
Id = (int)row["id"],
BorrowBookCode = (string)row["borrowbookcode"],
BorrowDate = (DateTime)row["borrowdate"],
NumberOfDayBorrow = (int)row["numberofdayborrow"],
Description = (string)row["description"],
Student_Id = (int)row["student_id"],
IsReturn = (bool)row["isreturn"]
}).ToList();
return(borrowBooks);
}
catch (Exception ex)
{
throw new Exception("Error from borrowBookDAL: " + ex.Message.ToString());
}
}
public List <Provider> ExtractAllProviders()
{
ProviderDAL providerdal = new ProviderDAL();
return(providerdal.ExtractAllProviders());
}
public Provider Extractprovider(string provider)
{
ProviderDAL providerdal = new ProviderDAL();
return(providerdal.Extractprovider(provider));
}
public string InsertProvider(Provider provider)
{
ProviderDAL providerdal = new ProviderDAL();
return(providerdal.InsertProvider(provider));
}
public Provider ExtractById(long?code)
{
ProviderDAL provider = new ProviderDAL();
return(provider.ExtractById(code));
}
public Provider ExtractproviderByID(long code)
{
ProviderDAL providerdal = new ProviderDAL();
return(providerdal.ExtractById(code));
}
public int UpdateProvider(ProviderDTO Provider)
{
providerdal = new ProviderDAL();
return(providerdal.UpdateProvider(Provider));
}
public long AuthenticateUser(ProviderDTO provider)
{
providerdal = new ProviderDAL();
return(providerdal.AuthenticateUser(provider));
}
public int UpdateProviderIntroducation(ProviderDTO Provider)
{
providerdal = new ProviderDAL();
return(providerdal.UpdateProviderIntroducation(Provider));
}
public ProviderDTO GetProviderPassword(long providerid)
{
providerdal = new ProviderDAL();
return(providerdal.GetProviderPassword(providerid));
}
public Stream GetProviderImage(long providerid)
{
providerdal = new ProviderDAL();
return(providerdal.GetProviderImage(providerid));
}
public ProviderDTO GetProviderContactById(long ProviderId)
{
providerdal = new ProviderDAL();
return(providerdal.GetProviderContactById(ProviderId));
}
public long UpdateProviderContact(ProviderDTO Provider)
{
providerdal = new ProviderDAL();
return(providerdal.UpdateProviderContact(Provider));
}
public List <ProviderDTO> SelectAllProvider(int PageNo, int PageSize)
{
providerdal = new ProviderDAL();
return(providerdal.SelectAllProvider(PageNo, PageSize));
}
public long InsertProvider(ProviderDTO Provider)
{
providerdal = new ProviderDAL();
return(providerdal.InsertProvider(Provider));
}
public void AddProviderImage(long providerid, byte[] imagename)
{
providerdal = new ProviderDAL();
providerdal.AddProviderImage(providerid, imagename);
}
public ProviderDTO GetProviderIntroductionById(long ProviderId)
{
providerdal = new ProviderDAL();
return(providerdal.GetProviderIntroductionById(ProviderId));
}