public int GetProductRowIndexByProductID(string productID, string sortBy, string sortOrder)
{
int n = 0;
using (ProductRepository rpt = new ProductRepository())
{
n = rpt.GetRowIndexByProductID(productID, sortBy, sortOrder);
}
return n;
}
/// <summary>
/// show the product detail by getting existing id (150930)
/// </summary>
public ProductDetailsModels GetProductDetails(string productID)
{
ProductDetailsModels n = new ProductDetailsModels();
Product data = new Product();
using (ProductRepository rpt = new ProductRepository())
{
data = rpt.GetProductByProductID(productID);
n.productID = data.ProductID;
n.name = data.Name;
n.decription = data.Description;
n.cetagory = data.Category;
n.price = data.Price;
}
return n;
}
/// <summary>
/// if productID is not null, will force showing this record by adjusting current page (150923)
/// </summary>
public ShoppingCartModels GetShoppingCartModel(ShoppingCartModels inputModel, HttpCookieCollection cookies, string productID)
{
ShoppingCartModels n = new ShoppingCartModels();
if (inputModel == null)
{
inputModel = new ShoppingCartModels();
inputModel.newBeginWith = "all";
inputModel.newSortOrder = "ascending";
inputModel.newSortBy = "productID";
inputModel.isSubmit = "";
inputModel.newPage = 1;
inputModel.newPageSize = 10;
if (cookies != null)
{
if (cookies["cookieSortBy"] != null) inputModel.newSortBy = cookies["cookieSortBy"].Value;
if (cookies["cookieSortOrder"] != null) inputModel.newSortOrder = cookies["cookieSortOrder"].Value;
if (cookies["cookieBeginWith"] != null) inputModel.newBeginWith = cookies["cookieBeginWith"].Value;
if (cookies["cookiePage"] != null) inputModel.newPage = int.Parse(cookies["cookiePage"].Value);
if (cookies["cookiePageSize"] != null) inputModel.newPageSize = int.Parse(cookies["cookiePageSize"].Value);
}
}
n.currentSortOrder = inputModel.newSortOrder;
n.currentSortBy = inputModel.newSortBy;
n.currentBeginWith = inputModel.newBeginWith;
n.isSubmit = inputModel.isSubmit;
n.currentPage = inputModel.newPage;
n.currentPageSize = inputModel.newPageSize;
if (productID != null)
{
using (ProductRepository rpt = new ProductRepository())
{
int rowIndex = rpt.GetRowIndexByProductID(productID, n.currentSortBy, n.currentSortOrder);
// determine the currentPage based on this rowIndex (150923)
n.currentPage = (rowIndex / n.currentPageSize) + 1;
}
cookies["cookiePage"].Value = n.currentPage.ToString();
}
else if (n.currentPage < 1)
{
n.currentPage = 1;
}
else if (inputModel.currentSortBy != inputModel.newSortBy || inputModel.currentSortOrder != inputModel.newSortOrder || inputModel.currentBeginWith != inputModel.newBeginWith || inputModel.currentPageSize != inputModel.newPageSize)
{
n.currentPage = 1;
}
int startRowIndex = (n.currentPage - 1) * n.currentPageSize;
int maximumRows = n.currentPageSize;
using (ProductRepository rpt = new ProductRepository())
{
n.Products = rpt.GetProductListByName(n.currentBeginWith, n.currentSortBy, n.currentSortOrder, startRowIndex, maximumRows);
n.numOfProducts = rpt.GetProductCountByName(n.currentBeginWith);
}
if (n.numOfProducts % n.currentPageSize == 0) n.numOfPages = (n.numOfProducts / n.currentPageSize);
else n.numOfPages = ((n.numOfProducts / n.currentPageSize) + 1);
return n;
}
public MyError InsertOrUpdateProduct(Product product, bool isModify, out string ackMsg, out bool isProductIDOk, out bool isNameOk, out bool isDescriptionOk, out bool isCategoryOk, out bool isPriceOk)
{
int count;
MyError n = MyError.Success;
ackMsg = null;
isProductIDOk = isNameOk = isDescriptionOk = isCategoryOk = isPriceOk = true;
if (!isModify)
{
using (ProductRepository checkExistID = new ProductRepository())
{
count = checkExistID.CheckExistID(product.ProductID);
}
if(count > 0)
{
n = MyError.Invalid;
ackMsg = "Invalid Input!";
isProductIDOk = false;
}
}
if (string.IsNullOrEmpty(product.ProductID) == true)
{
n = MyError.Invalid;
ackMsg = "Invalid Input!";
isProductIDOk = false;
}
if (string.IsNullOrEmpty(product.Name) == true)
{
n = MyError.Invalid;
ackMsg = "Invalid Input!";
isNameOk = false;
}
if (string.IsNullOrEmpty(product.Description) == true)
{
n = MyError.Invalid;
ackMsg = "Invalid Input!";
isDescriptionOk = false;
}
if (product.Price == 0)
{
n = MyError.Invalid;
ackMsg = "Invalid Input!";
isPriceOk = false;
}
if (n == MyError.Success)
{
using (ProductRepository rpt = new ProductRepository())
{
if (!isModify) n = rpt.InsertProduct(product);
else rpt.UpdateProduct(product);
}
}
return n;
}
public SpreadsheetGear.IRange ListProducts(SpreadsheetGear.IRange cells)
{
List<Product> listOfProducts = new List<Product>();
cells["A1"].Formula = "#";
cells["B1"].Formula = "ID";
cells["C1"].Formula = "Name";
cells["D1"].Formula = "Decription";
cells["E1"].Formula = "Category";
cells["F1"].Formula = "Price";
cells["A1,F1"].HorizontalAlignment = SpreadsheetGear.HAlign.Right;
cells["B1:E1"].HorizontalAlignment = SpreadsheetGear.HAlign.Left;
cells["A1:F1"].Font.Bold = true;
using (ProductRepository rpt = new ProductRepository())
{
int i = 2;
listOfProducts = rpt.GetlistProducts();
foreach (Product n in listOfProducts)
{
cells["A" + i].Value = i;
cells["B" + i].Formula = "=\"" + n.ProductID + "\"";
cells["C" + i].Formula = "=\"" + n.Name + "\"";
cells["D" + i].Formula = "=\"" + n.Description + "\"";
cells["E" + i].Formula = "=\"" + n.Category + "\"";
cells["F" + i].Value = n.Price;
i++;
}
}
return cells;
}
