public override List <IProduct> Select()
{
Source = "sp_FetchProductOnly";
// Product fetching stored procedure
try
{
Object[] param = null;
DataSet Output = Commands.ExecuteQuery(Source, CommandType.StoredProcedure, param);
List <IProduct> ProductList = new List <IProduct>();
foreach (DataRow dr in Output.Tables[0].Rows)
{
IProduct Product = new ProductsOnly();
Product.SetProductId(Int32.Parse(dr["pID"].ToString()));
Product.SetProductName(dr["productName"].ToString());
Product.SetProductImage(dr["productImage"].ToString());
ProductList.Add(Product);
}
return(ProductList);
}
catch (Exception ex)
{
Logger.Instance().Log(Fatal.Instance(), ex);
throw ex;
}
}
public void AddProductOnly_1()
{
int ExpectedOutput = 1;
int GotOutput = 0;
CRUDTemplate <IProduct> ProductTemplateObj = new ProductTemplate();
ProductsOnly ProductsOnlyObj = new ProductsOnly();
ProductsOnlyObj.SetProductName("Test_Product");
ProductsOnlyObj.SetProductImage("images\test.png");
try
{
GotOutput = ProductTemplateObj.Insert(ProductsOnlyObj);
}
catch (Exception)
{
GotOutput = -2;
}
Assert.AreEqual(ExpectedOutput, GotOutput);
// deleting the Product by product id
List <IProduct> Output = ProductTemplateObj.Select();
foreach (IProduct Product in Output)
{
if ("Test_Product" == Product.GetProductImage())
{
int ProductId = Product.GetProductId();
ProductsOnlyObj.SetProductId(ProductId);
break;
}
}
ProductTemplateObj.Delete(ProductsOnlyObj);
}
public IOrderDetailsResponse FetchOrderDetailsByOrderID(IOrder OrderObj, IUserProfile UserProfileObj)
{
try
{
IOrderDetailsResponse Response = null;
List <ITaxOrderDetailsByProduct> ProductList;
DataSet OrderDetailsResponse = new OrderDetailsDataLayer(UserProfileObj, OrderObj).FetchOrderDetailsByID();
if (OrderDetailsResponse.Tables[0].Rows.Count > 0)
{
ProductList = new List <ITaxOrderDetailsByProduct>();
IOrderDetailsDateAndStatus OrderDetailsDateAndStatusObj = new OrderDetailsDateAndStatus(DateTime.Parse(OrderDetailsResponse.Tables[0].Rows[0]["date"].ToString()), OrderDetailsResponse.Tables[0].Rows[0]["statusName"].ToString());
foreach (DataRow dr in OrderDetailsResponse.Tables[2].Rows)
{
IStores StoreObj = new Stores();
StoreObj.SetStoreLogo(dr["storeLogo"].ToString());
IProduct ProductObj = new ProductsOnly();
ProductObj.SetProductName(dr["productName"].ToString());
ProductObj.SetProductImage(dr["productImage"].ToString());
ProductObj.SetProductQuantity(int.Parse(dr["quantity"].ToString()));
ITaxOrderDetailsByProduct ProductListObj = new TaxOrderDetailsByProduct(StoreObj, ProductObj, double.Parse(dr["PreTaxProductPrice"].ToString()), double.Parse(dr["PostTaxProductPrice"].ToString()), double.Parse(dr["taxAmount"].ToString()));
ProductList.Add(ProductListObj);
}
DataRow AddressRow = OrderDetailsResponse.Tables[1].Rows[0];
IAddress AddressObj = new Address(
AddressRow["addressName"].ToString(),
AddressRow["appt"].ToString(),
AddressRow["postalCode"].ToString(),
AddressRow["phone"].ToString(),
AddressRow["city"].ToString(),
AddressRow["city"].ToString(),
AddressRow["Province"].ToString()
);
DataRow TaxComputedRow = OrderDetailsResponse.Tables[3].Rows[0];
IComputedTaxPrice ComputedObj = new ComputedTaxPrice(
int.Parse(TaxComputedRow["TotalUniqueQuantity"].ToString()),
int.Parse(TaxComputedRow["TotalQuantity"].ToString()),
double.Parse(TaxComputedRow["TotalPreTaxProductPrice"].ToString()),
double.Parse(TaxComputedRow["TotalPostTaxProductPrice"].ToString()),
double.Parse(TaxComputedRow["TotalTaxAmount"].ToString())
);
ICardDetails CardObj = new CardDetails(int.Parse(OrderDetailsResponse.Tables[0].Rows[0]["caID"].ToString()));
ICardDetails OutputCardDecrypted = new CardDetailsBusinessLayerTemplate(UserProfileObj).Select(CardObj);
Response = new OrderDetailResponse(true, ProductList, OrderDetailsDateAndStatusObj, AddressObj, ComputedObj, OutputCardDecrypted);
}
else
{
Response = new OrderDetailResponse(false);
}
return(Response);
}
catch (Exception ex)
{
Logger.Instance().Log(Warn.Instance(), ex);
throw ex;
}
}