예제 #1
0
        /// <summary>
        /// Purpose: Grabs administrator information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetAdministratorByID(int id)
        {
            Administrator obj = new Administrator();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.Administrators.FirstOrDefault(a => a.AdministratorID == id);
                if (obj != null)
                {
                    hsh["adminid"] = obj.AdministratorID;
                    hsh["username"] = obj.Username;
                    hsh["password"] = obj.Password;
                    hsh["firstname"] = obj.FirstName;
                    hsh["lastname"] = obj.LastName;
                    hsh["isactive"] = obj.IsActive;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "AdministratorData", "GetAdministratorByID");
            }

            return hsh;
        }
예제 #2
0
        /// <summary>
        /// Purpose: Grabs delivery type information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetDeliveryTypeByID(int id)
        {
            DeliveryType obj = new DeliveryType();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.DeliveryTypes.FirstOrDefault(d => d.DeliveryTypeID == id);
                if (obj != null)
                {
                    hsh["deliverytypeid"] = obj.DeliveryTypeID;
                    hsh["name"] = obj.Name;
                    hsh["description"] = obj.Description;
                    hsh["cost"] = obj.Cost;
                    hsh["created"] = obj.Created;
                    hsh["modified"] = obj.Modified;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "DeliveryTypeData", "GetDeliveryTypeByID");
            }

            return hsh;
        }
예제 #3
0
        /// <summary>
        /// Purpose: Grabs audit information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetAuditByID(int id)
        {
            Audit obj = new Audit();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.Audits.FirstOrDefault(a => a.AuditID == id);
                if (obj != null)
                {
                    hsh["auditid"] = obj.AuditID;
                    hsh["audittypeid"] = obj.AuditTypeID;
                    hsh["userid"] = obj.UserID;
                    hsh["adminid"] = obj.AdminID;
                    hsh["notes"] = obj.Notes;
                    hsh["created"] = obj.Created;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "AuditData", "GetAuditByID");
            }

            return hsh;
        }
        /// <summary>
        /// Purpose: Grabs product delivery type information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetProductDeliveryTypeByID(int id)
        {
            ProductDeliveryType obj = new ProductDeliveryType();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.ProductDeliveryTypes.FirstOrDefault(d => d.ProductDeliveryTypeID == id);
                if (obj != null)
                {
                    hsh["productdeliverytypeid"] = obj.ProductDeliveryTypeID;
                    hsh["deliverytypeid"] = obj.DeliveryTypeID;
                    hsh["productcode"] = obj.ProductCode;
                    hsh["created"] = obj.Created;
                    hsh["modified"] = obj.Modified;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "ProductDeliveryTypeData", "GetProductDeliveryTypeByID");
            }

            return hsh;
        }
예제 #5
0
        /// <summary>
        /// Purpose: Grabs state/province information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetStateProvinceByID(int id)
        {
            StatesProvince obj = new StatesProvince();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.StatesProvinces.FirstOrDefault(s => s.StateProvinceID == id);
                if (obj != null)
                {
                    hsh["stateprovinceid"] = obj.StateProvinceID;
                    hsh["name"] = obj.Name;
                    hsh["country"] = obj.Country;
                    hsh["currencycode"] = obj.CurrencyCode;
                    hsh["taxratepercentage"] = obj.TaxRatePercentage;
                    hsh["modified"] = obj.Modified;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "StateProvinceData", "GetStateProvinceByID");
            }

            return hsh;
        }
예제 #6
0
        /// <summary>
        /// Purpose: Grabs order information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetOrderByID(int id)
        {
            Order obj = new Order();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.Orders.FirstOrDefault(o => o.OrderID == id);
                if (obj != null)
                {
                    hsh["orderid"] = obj.OrderID;
                    hsh["userid"] = obj.UserID;
                    hsh["subtotal"] = obj.Subtotal;
                    hsh["taxes"] = obj.Taxes;
                    hsh["deliverytypeid"] = obj.DeliveryTypeID;
                    hsh["deliverycost"] = obj.DeliveryCost;
                    hsh["grandtotal"] = obj.GrandTotal;
                    hsh["created"] = obj.Created;
                    hsh["modified"] = obj.Modified;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "OrderData", "GetOrderByID");
            }

            return hsh;
        }
예제 #7
0
        /// <summary>
        /// Purpose: Grabs configuration information based on configuration code
        /// Accepts: String
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetConfigurationByCode(string code)
        {
            Configuration obj = new Configuration();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.Configurations.FirstOrDefault(c => c.ConfigurationCode == code);
                if (obj != null)
                {
                    hsh["configurationcode"] = obj.ConfigurationCode;
                    hsh["description"] = obj.Description;
                    hsh["value"] = obj.Value;
                    hsh["isyesnovalue"] = obj.IsYesNoValue;
                    hsh["yesnovalue"] = obj.YesNoValue;
                    hsh["modified"] = obj.Modified;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "ConfigurationData", "GetConfigurationByCode");
            }

            return hsh;
        }
예제 #8
0
        /// <summary>
        /// Purpose: Grabs category information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetCategoryByID(int id)
        {
            Category obj = new Category();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.Categories.FirstOrDefault(c => c.CategoryID == id);
                if (obj != null)
                {
                    hsh["categoryid"] = obj.CategoryID;
                    hsh["name"] = obj.Name;
                    hsh["description"] = obj.Description;
                    hsh["parentcategoryid"] = obj.ParentCategoryID;
                    hsh["created"] = obj.Created;
                    hsh["modified"] = obj.Modified;
                    hsh["isactive"] = obj.IsActive;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "CategoryData", "GetCategoryByID");
            }

            return hsh;
        }
예제 #9
0
        /// <summary>
        /// Purpose: Add new user's information to the DB
        /// Accepts: Hashtable
        /// Returns: int
        /// </summary>
        public int AddUser(Hashtable hsh)
        {
            int newId = -1;
            User usr = new User();
            QuickStart_DBEntities dbContext;

            try
            {
                dbContext = new QuickStart_DBEntities();
                usr.Username = Convert.ToString(hsh["username"]);
                usr.Password = Convert.ToString(hsh["password"]);
                usr.Salutation = Convert.ToString(hsh["salutation"]);
                usr.FirstName = Convert.ToString(hsh["firstName"]);
                usr.LastName = Convert.ToString(hsh["lastName"]);
                usr.Address1 = Convert.ToString(hsh["address1"]);
                usr.Address2 = Convert.ToString(hsh["address2"]);
                usr.City = Convert.ToString(hsh["city"]);
                usr.StateProvinceID = Convert.ToInt32(hsh["stateProv"]);
                usr.ZipPostalCode = Convert.ToString(hsh["zipPC"]);
                usr.Email = Convert.ToString(hsh["email"]);
                usr.IsReceiveNewsletters = Convert.ToBoolean(hsh["newsletters"]);
                usr.Created = DateTime.Now;

                dbContext.AddToUsers(usr);
                dbContext.SaveChanges();
                newId = usr.UserID;
                dbContext.Detach(usr);
            }
            catch (Exception e)
            {
                ErrorLoggerData.ErrorRoutine(e, "UserData", "AddUser");
            }

            return newId;
        }
예제 #10
0
        /// <summary>
        /// Purpose: Grabs orderitem information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetOrderItemByID(int id)
        {
            OrderItem obj = new OrderItem();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.OrderItems.FirstOrDefault(o => o.OrderItemID == id);
                if (obj != null)
                {
                    hsh["orderitemid"] = obj.OrderItemID;
                    hsh["orderid"] = obj.OrderID;
                    hsh["productcode"] = obj.ProductCode;
                    hsh["quantity"] = obj.Quantity;
                    hsh["created"] = obj.Created;
                    hsh["modified"] = obj.Modified;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "OrderItemData", "GetOrderItemByID");
            }

            return hsh;
        }
예제 #11
0
        /// <summary>
        /// Purpose: Add a new Product to the database
        /// Accepts: Hashtable
        /// Returns: String (Product Code)
        /// </summary>
        public string AddProduct(Hashtable hsh)
        {
            //The product code that was added to database
            string retProdcd = "";
            Product prod = new Product();
            QuickStart_DBEntities dbContext;
            try
            {
                dbContext = new QuickStart_DBEntities();
                prod.ProductCode = Convert.ToString(hsh["productcode"]);
                prod.Name = Convert.ToString(hsh["name"]);
                prod.Brand = Convert.ToString(hsh["brand"]);
                prod.Description = Convert.ToString(hsh["description"]);
                prod.CategoryID = Convert.ToInt32(hsh["categoryid"]);
                prod.MSRP = Convert.ToDouble(hsh["msrp"]);
                prod.isFreeShipping = Convert.ToBoolean(hsh["isfreeshipping"]);
                prod.isTaxFree = Convert.ToBoolean(hsh["istaxfree"]);
                prod.QuantityInStock = Convert.ToInt32(hsh["quantityinstock"]);
                prod.IsQuantityUnlimited = Convert.ToBoolean(hsh["isquantityunlimited"]);
                prod.Created = DateTime.Now;
                prod.Modified = null;
                prod.isActive = true; //set to active

                dbContext.AddToProducts(prod);
                dbContext.SaveChanges();
                retProdcd = prod.ProductCode;
                dbContext.Detach(prod);
            }
            catch (Exception e)
            {
                ErrorRoutine(e, "ProductData", "AddProduct");
            }

            return retProdcd;
        }
예제 #12
0
        /// <summary>
        /// Purpose: Grabs all InvoiceItems via stored procedure 
        /// Accepts: Nothing
        /// Returns: List<InvoiceItem>
        /// </summary>
        public List<InvoiceItem> GetAllInvoiceItemsByOrderID(int orderid)
        {
            QuickStart_DBEntities dbContext;
            List<InvoiceItem> retList = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all Invoice Items are returned for this order id
                retList = dbContext.spGetInvoiceItemsByOrderID(orderid).ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "InvoiceItemData", "GetAllInvoiceItemsByOrderID");
            }

            return retList;
        }
예제 #13
0
        /// <summary>
        /// Purpose: Grabs all StatesProvinces
        /// Accepts: Nothing
        /// Returns: List<StatesProvince>
        /// </summary>
        public List<StatesProvince> GetAllStatesProvinces()
        {
            QuickStart_DBEntities dbContext;
            List<StatesProvince> allstatesprovinces = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all states/provinces are returned
                allstatesprovinces = dbContext.StatesProvinces.ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "StatesProvinceData", "GetAllStatesProvinces");
            }

            return allstatesprovinces;
        }
예제 #14
0
        /// <summary>
        /// Purpose: Grabs all audits
        /// Accepts: Nothing
        /// Returns: List<Audit>
        /// </summary>
        public List<Audit> GetAllAudits()
        {
            QuickStart_DBEntities dbContext;
            List<Audit> allaudits = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all audits are returned
                allaudits = dbContext.Audits.ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "AuditData", "GetAllAudits");
            }

            return allaudits;
        }
예제 #15
0
        /// <summary>
        /// Purpose: Grabs all configuration settings
        /// Accepts: Nothing
        /// Returns: List<Configuration>
        /// </summary>
        public List<Configuration> GetAllConfigurations()
        {
            QuickStart_DBEntities dbContext;
            List<Configuration> allconfigs = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all configurations are returned
                allconfigs = dbContext.Configurations.ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "ConfigurationData", "GetAllConfigurations");
            }

            return allconfigs;
        }
        /// <summary>
        /// Purpose: Grabs all product delivery types by product code
        /// Accepts: String (Product Code)
        /// Returns: List<ProductDeliveryType>
        /// </summary>
        public List<ProductDeliveryType> GetAllProductDeliveryTypesByProdCode(string prodcd)
        {
            QuickStart_DBEntities dbContext;
            List<ProductDeliveryType> proddeliverytypes = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all product delivery types for this product are returned
                proddeliverytypes = dbContext.ProductDeliveryTypes.Where(pdt => pdt.ProductCode == prodcd).ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "ProductDeliveryTypeData", "GetAllDeliveryTypesByProdCode");
            }

            return proddeliverytypes;
        }
예제 #17
0
        /// <summary>
        /// Purpose: Grabs all users
        /// Accepts: Nothing
        /// Returns: List<User>
        /// </summary>
        public List<User> GetAllUsers()
        {
            QuickStart_DBEntities dbContext;
            List<User> allusers = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all users are returned
                allusers = dbContext.Users.ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "UserData", "GetAllUsers");
            }

            return allusers;
        }
예제 #18
0
        /// <summary>
        /// Purpose: Grabs all order items
        /// Accepts: Nothing
        /// Returns: List<OrderItem>
        /// </summary>
        public List<OrderItem> GetAllOrderItems()
        {
            QuickStart_DBEntities dbContext;
            List<OrderItem> allorderitems = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all order items are returned
                allorderitems = dbContext.OrderItems.ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "OrderItemData", "GetAllOrderItems");
            }

            return allorderitems;
        }
예제 #19
0
        /// <summary>
        /// Purpose: Grabs all language labels
        /// Accepts: Nothing
        /// Returns: List<LanguageLabel>
        /// </summary>
        public List<LangLabel> GetAllLangLabels()
        {
            QuickStart_DBEntities dbContext;
            List<LangLabel> alllanglabels = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all language labels are returned
                alllanglabels = dbContext.LangLabels.ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "LangLabelData", "GetAllLangLabels");
            }

            return alllanglabels;
        }
예제 #20
0
        /// <summary>
        /// Purpose: Grabs all orders
        /// Accepts: Int representing the userID
        /// Returns: List<Order>
        /// </summary>
        public List<Order> GetAllOrdersByUserID(int uId)
        {
            QuickStart_DBEntities dbContext;
            List<Order> allorders = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all orders are returned
                allorders = dbContext.Orders.Where(o => o.UserID == uId).ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "OrderData", "GetAllOrders");
            }

            return allorders;
        }
예제 #21
0
        /// <summary>
        /// Purpose: Grabs all delivery types
        /// Accepts: Nothing
        /// Returns: List<DeliveryType>
        /// </summary>
        public List<DeliveryType> GetAllDeliveryTypes()
        {
            QuickStart_DBEntities dbContext;
            List<DeliveryType> alldeliverytypes = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                //all delivery types are returned
                alldeliverytypes = dbContext.DeliveryTypes.ToList();
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "DeliveryTypeData", "GetAllDeliveryTypes");
            }

            return alldeliverytypes;
        }
예제 #22
0
        /// <summary>
        /// Purpose: Grabs audit type information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetAuditTypeByID(int id)
        {
            AuditType obj = new AuditType();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.AuditTypes.FirstOrDefault(a => a.AuditTypeID == id);
                if (obj != null)
                {
                    hsh["audittypeid"] = obj.AuditTypeID;
                    hsh["description"] = obj.Description;
                    hsh["isadmin"] = obj.IsAdmin;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "AuditTypeData", "GetAuditTypeByID");
            }

            return hsh;
        }
예제 #23
0
        /// <summary>
        /// Purpose: Grabs language label information based on language label code
        /// Accepts: String
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetLangLabelByCode(string code)
        {
            LangLabel obj = new LangLabel();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.LangLabels.FirstOrDefault(l => l.LangLabelCode == code);
                if (obj != null)
                {
                    hsh["langlabelcode"] = obj.LangLabelCode;
                    hsh["value"] = obj.Value;
                    hsh["modified"] = obj.Modified;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "LangLabelData", "GetLangLabelByCode");
            }

            return hsh;
        }
예제 #24
0
        /// <summary>
        /// Purpose: Grabs all administrators
        /// Accepts: Boolean
        /// Returns: List<Administrator>
        /// </summary>
        public List<Administrator> GetAllAdministrators(bool onlyActive)
        {
            QuickStart_DBEntities dbContext;
            List<Administrator> alladministrators = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                if (onlyActive == true) //only the active administrators are returned
                {
                    alladministrators = dbContext.Administrators.Where(a => a.IsActive == true).ToList();
                }
                else //all administrators are returned
                {
                    alladministrators = dbContext.Administrators.ToList();
                }
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "AdministratorData", "GetAllAdministrators");
            }

            return alladministrators;
        }
예제 #25
0
        /// <summary>
        /// Purpose: Grabs all products
        /// Accepts: Boolean
        /// Returns: List<Product>
        /// </summary>
        public List<Product> GetAllProducts(bool onlyActive)
        {
            QuickStart_DBEntities dbContext;
            List<Product> allproducts = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                if (onlyActive == true) //only the active products are returned
                {
                    allproducts = dbContext.Products.Where(p => p.isActive == true).ToList();
                }
                else //all products are returned
                {
                    allproducts = dbContext.Products.ToList();
                }
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "ProductData", "GetAllProducts");
            }

            return allproducts;
        }
예제 #26
0
        /// <summary>
        /// Purpose: Grabs all categories
        /// Accepts: Boolean
        /// Returns: List<Category>
        /// </summary>
        public List<Category> GetAllCategories(bool onlyActive)
        {
            QuickStart_DBEntities dbContext;
            List<Category> allCategories = null;
            try
            {
                dbContext = new QuickStart_DBEntities();

                if (onlyActive == true) //only the active categories are returned
                {
                    allCategories = dbContext.Categories.Where(c => c.IsActive == true).ToList();
                }
                else //all categories are returned
                {
                    allCategories = dbContext.Categories.ToList();
                }
            }
            catch (Exception ex)
            {
                ErrorRoutine(ex, "CategoryData", "GetAllCategories");
            }

            return allCategories;
        }
예제 #27
0
        /// <summary>
        /// Purpose: Grabs administrator ID based on administrator login information
        /// Accepts: Hashtable 
        /// Returns: Int
        /// </summary>
        public int Login(Hashtable hsh)
        {
            QuickStart_DBEntities dbContext;
            int retAdminID = -1;

            try
            {
                String username = Convert.ToString(hsh["username"]);
                String password = Convert.ToString(hsh["password"]);

                dbContext = new QuickStart_DBEntities();

                //Use Linq to Entities syntax to retrieve desired Administrator
                Administrator admin = null;
                admin = dbContext.Administrators.FirstOrDefault(a => a.Username == username);

                if (admin != null)
                {
                    if (admin.Password == password)
                    {
                        retAdminID = admin.AdministratorID;
                    }
                }

            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "AdministratorData", "Login");
                retAdminID = -1;
            }

            return retAdminID;
        }
예제 #28
0
        /// <summary>
        /// Purpose: Update an existing Product in the database
        /// Accepts: Hashtable
        /// Returns: Boolean
        /// </summary>
        public bool UpdateProduct(Hashtable hsh)
        {
            bool isSuccess = false;
            Product prod = new Product();
            QuickStart_DBEntities dbContext;
            try
            {
                dbContext = new QuickStart_DBEntities();
                string prodcd = hsh["productcode"].ToString();
                prod = dbContext.Products.FirstOrDefault(p => p.ProductCode == prodcd);
                prod.Name = Convert.ToString(hsh["name"]);
                prod.Brand = Convert.ToString(hsh["brand"]);
                prod.Description = Convert.ToString(hsh["description"]);
                prod.CategoryID = Convert.ToInt32(hsh["categoryid"]);
                prod.MSRP = Convert.ToDouble(hsh["msrp"]);
                prod.isFreeShipping = Convert.ToBoolean(hsh["isfreeshipping"]);
                prod.isTaxFree = Convert.ToBoolean(hsh["istaxfree"]);
                prod.QuantityInStock = Convert.ToInt32(hsh["quantityinstock"]);
                prod.IsQuantityUnlimited = Convert.ToBoolean(hsh["isquantityunlimited"]);
                //need 'modified' but not 'created' during an update
                prod.Modified = DateTime.Now;
                prod.isActive = Convert.ToBoolean(hsh["isactive"]);

                dbContext.SaveChanges();
                isSuccess = true;
            }
            catch (Exception e)
            {
                ErrorRoutine(e, "ProductData", "UpdateProduct");
            }

            return isSuccess;
        }
예제 #29
0
        /// <summary>
        /// Purpose: Grabs product information based on product code
        /// Accepts: String
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetProductByCode(string code)
        {
            Product obj = new Product();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.Products.FirstOrDefault(p => p.ProductCode == code);
                if (obj != null)
                {
                    hsh["productcode"] = obj.ProductCode;
                    hsh["name"] = obj.Name;
                    hsh["brand"] = obj.Brand;
                    hsh["description"] = obj.Description;
                    hsh["categoryid"] = obj.CategoryID;
                    hsh["msrp"] = obj.MSRP;
                    hsh["isfreeshipping"] = obj.isFreeShipping;
                    hsh["istaxfree"] = obj.isTaxFree;
                    hsh["quantityinstock"] = obj.QuantityInStock;
                    hsh["isquantityunlimited"] = obj.IsQuantityUnlimited;
                    hsh["created"] = obj.Created;
                    hsh["modified"] = obj.Modified;
                    hsh["isactive"] = obj.isActive;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "ProductData", "GetProductByCode");
            }

            return hsh;
        }
예제 #30
0
        /// <summary>
        /// Purpose: Grabs user information based on ID
        /// Accepts: Int
        /// Returns: Hashtable
        /// </summary>
        public Hashtable GetUserByID(int id)
        {
            User obj = new User();
            QuickStart_DBEntities dbContext;
            Hashtable hsh = new Hashtable();
            try
            {
                dbContext = new QuickStart_DBEntities();
                obj = dbContext.Users.FirstOrDefault(u => u.UserID == id);
                if (obj != null)
                {
                    hsh["userid"] = obj.UserID;
                    hsh["username"] = obj.Username;
                    hsh["password"] = obj.Password;
                    hsh["salutation"] = obj.Salutation;
                    hsh["firstname"] = obj.FirstName;
                    hsh["lastname"] = obj.LastName;
                    hsh["address1"] = obj.Address1;
                    hsh["address2"] = obj.Address2;
                    hsh["city"] = obj.City;
                    hsh["stateprovinceid"] = obj.StateProvinceID;
                    hsh["zippostalcode"] = obj.ZipPostalCode;
                    hsh["email"] = obj.Email;
                    hsh["isreceivenewsletters"] = obj.IsReceiveNewsletters;
                    hsh["created"] = obj.Created;
                    hsh["modified"] = obj.Modified;
                }
            }
            catch (Exception ex)
            {
                ErrorLoggerData.ErrorRoutine(ex, "UserData", "GetUserByID");
            }

            return hsh;
        }