public DataSet CreateOrderID(IAddress AddressObj, ICardDetails CardObj, IUserProfile UserProfileObj) { string Source = "sp_CreateOrderID"; try { object[] paramToken = { new MySqlParameter("@aID", AddressObj.GetAddressID()), new MySqlParameter("@caID", CardObj.GetCardID()), new MySqlParameter("@paramToken", UserProfileObj.GetToken()) }; return(MySQLCommands.Instance().ExecuteQuery(Source, CommandType.StoredProcedure, paramToken)); } catch (Exception ex) { Logger.Instance().Log(Fatal.Instance(), ex); throw ex; } }
public List <ITaxProducts> CalculateTaxByProduct(ICart cartObj, IAddress AddressObj, IUserProfile UserProfile) { try { List <ITaxProducts> ProductList = new List <ITaxProducts>(); ISecurity Security = new Security(UserProfile); if (Security.AuthenticateUser() == true) { DataSet TaxDS = new TaxManagementDataLayer().GetTaxDetailsFromDB(AddressObj.GetAddressID()); double TaxFromDB = Math.Round(double.Parse(TaxDS.Tables[0].Rows[0]["Tax"].ToString()), 2); foreach (CartItems Items in cartObj.GetCartItems()) { double TotalAmount = Math.Round(Items.ProductObj.Price * Items.ProductObj.Quantity * 0.01 * TaxFromDB, 2); ProductList.Add(new TaxProduct(Items.ProductObj.pbsID, TotalAmount)); } } return(ProductList); } catch (Exception ex) { Logger.Instance().Log(Fatal.Instance(), ex); throw ex; } }
public ITaxResult CalculateTaxFromCartItems(ICart CartObj, IAddress AddressObj, IUserProfile UserProfile) { try { ISecurity Security = new Security(UserProfile); if (Security.AuthenticateUser() == true) { double PreTaxAmount = CalculateCartPrice(CartObj); DataSet TaxResultFromDB = new TaxManagementDataLayer().GetTaxDetailsFromDB(AddressObj.GetAddressID()); double FinalAmount = PreTaxAmount + CalculateCartTax(PreTaxAmount, TaxResultFromDB); return(new TaxResult(true, TaxResultFromDB.Tables[0].Rows[0]["tax_type"].ToString(), double.Parse(TaxResultFromDB.Tables[0].Rows[0]["tax"].ToString()), CalculateCartTax(PreTaxAmount, TaxResultFromDB), FinalAmount, PreTaxAmount)); } return(new TaxResult(false)); } catch (Exception ex) { Logger.Instance().Log(Fatal.Instance(), ex); throw ex; } }