public AddWishListModel AddBookToWishList(int userId, ShowWishListModel showWishListModel)
{
try
{
DatabaseConnection databaseConnection = new DatabaseConnection(this.configuration);
List <StoredProcedureParameterData> paramList = new List <StoredProcedureParameterData>();
paramList.Add(new StoredProcedureParameterData("@UserId", userId));
paramList.Add(new StoredProcedureParameterData("@BookId", showWishListModel.BookId));
paramList.Add(new StoredProcedureParameterData("@IsUsed", true));
paramList.Add(new StoredProcedureParameterData("@CreatedDate", DateTime.Now));
paramList.Add(new StoredProcedureParameterData("@ModifiedDate", DateTime.Now));
DataTable table = databaseConnection.StoredProcedureExecuteReader("BookAddToWishList", paramList);
var wishListData = new AddWishListModel();
foreach (DataRow dataRow in table.Rows)
{
wishListData = new AddWishListModel();
wishListData.Id = (int)dataRow["Id"];
wishListData.UserId = Convert.ToInt32(dataRow["UserId"].ToString());
wishListData.BookId = Convert.ToInt32(dataRow["BookId"].ToString());
wishListData.IsUsed = Convert.ToBoolean(dataRow["IsUsed"].ToString());
wishListData.CreatedDate = Convert.ToDateTime(dataRow["CreatedDate"]);
wishListData.ModifiedDate = Convert.ToDateTime(dataRow["ModifiedDate"]);
}
return(wishListData);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public List <AddWishListModel> GetAllWishList(int userId)
{
try
{
DatabaseConnection databaseConnection = new DatabaseConnection(this.configuration);
List <StoredProcedureParameterData> paramList = new List <StoredProcedureParameterData>();
paramList.Add(new StoredProcedureParameterData("@UserId", userId));
DataTable table = databaseConnection.StoredProcedureExecuteReader("GetAllWishList", paramList);
var wishListData = new AddWishListModel();
List <AddWishListModel> wishLists = new List <AddWishListModel>();
foreach (DataRow dataRow in table.Rows)
{
wishListData = new AddWishListModel();
wishListData.Id = (int)dataRow["Id"];
wishListData.UserId = Convert.ToInt32(dataRow["UserId"].ToString());
wishListData.BookId = Convert.ToInt32(dataRow["BookId"].ToString());
wishListData.IsUsed = Convert.ToBoolean(dataRow["IsUsed"].ToString());
wishListData.CreatedDate = Convert.ToDateTime(dataRow["CreatedDate"]);
wishListData.ModifiedDate = Convert.ToDateTime(dataRow["ModifiedDate"]);
wishLists.Add(wishListData);
}
if (wishLists.Count != 0)
{
return(wishLists);
}
else
{
return(null);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}