public List<OnDemandVideo> GetOnDemandAudioVideos() { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetOnDemandVideos"; List<OnDemandVideo> medias = new List<OnDemandVideo>(); DataTable dt = db.Execute(cmd); foreach (DataRow dr in dt.Rows) { OnDemandVideo media = new OnDemandVideo { ID = Int32.Parse(dr["ID"].ToString()), Location = dr["Location"].ToString(), DateCreated = Convert.ToDateTime(dr["DateCreated"].ToString()), PreviewImageURL = dr["PreviewImageURL"].ToString(), Sort = Int32.Parse(dr["Sort"].ToString()), Active = Convert.ToBoolean(dr["Active"]), Message = dr["Message"].ToString(), Url = dr["Url"].ToString(), }; medias.Add(media); } return medias; }
public bool SetCMEDCustomerPassword(string email, string password) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SetCMEDCustomerPassword"; cmd.Parameters.AddWithValue("@Email", email); cmd.Parameters.AddWithValue("@password", password); DataTable dt = db.Execute(cmd); return true; }
public void UpdateCMEDShopProduct(CMEDShopProduct product) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "UpdateCMEDShopProduct"; cmd.Parameters.AddWithValue("@product_id", product.product_id); cmd.Parameters.AddWithValue("@product_title", product.product_title); cmd.Parameters.AddWithValue("@category_id", product.category_id); cmd.Parameters.AddWithValue("@supplier_id", product.supplier_id); cmd.Parameters.AddWithValue("@product_price", product.product_price); cmd.Parameters.AddWithValue("@product_status", product.product_status); cmd.Parameters.AddWithValue("@short_description", product.short_description); cmd.Parameters.AddWithValue("@long_description", product.long_description); cmd.Parameters.AddWithValue("@thumb_pic_url", product.thumb_pic_url); cmd.Parameters.AddWithValue("@full_pic_url", product.full_pic_url); cmd.Parameters.AddWithValue("@year", product.year); cmd.Parameters.AddWithValue("@location", product.location); cmd.Parameters.AddWithValue("@topic", product.topic); cmd.Parameters.AddWithValue("@active", product.active); cmd.Parameters.AddWithValue("@updated_by", product.updated_by); db.Execute(cmd); return; }
public long SaveLunar(CMEDLunar lunar) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveLunar"; cmd.Parameters.AddWithValue("@ordernum", lunar.order_id); cmd.Parameters.AddWithValue("@bmonth", lunar.bmonth); cmd.Parameters.AddWithValue("@bday", lunar.bday); cmd.Parameters.AddWithValue("@byear", lunar.byear); cmd.Parameters.AddWithValue("@bhour", lunar.bhour); cmd.Parameters.AddWithValue("@bmin", lunar.bmin); cmd.Parameters.AddWithValue("@ampm", lunar.ampm); cmd.Parameters.AddWithValue("@bcity", lunar.bcity); cmd.Parameters.AddWithValue("@bstate", lunar.bstate); cmd.Parameters.AddWithValue("@bcountry", lunar.bcountry); cmd.Parameters.AddWithValue("@fname", lunar.fname); cmd.Parameters.AddWithValue("@lname", lunar.lname); cmd.Parameters.AddWithValue("@gender", lunar.gender); DataTable dt = db.Execute(cmd); DataRow row = dt.Rows[0]; return long.Parse(row["order_id"].ToString()); }
public void SaveUserTransaction(UserTransaction transaction) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddUserTransaction"; cmd.Parameters.AddWithValue("@ProductID", transaction.ProductID); cmd.Parameters.AddWithValue("@FirstName", transaction.FirstName); cmd.Parameters.AddWithValue("@LastName", transaction.LastName); cmd.Parameters.AddWithValue("@Email", transaction.Email); cmd.Parameters.AddWithValue("@Password", transaction.Password); cmd.Parameters.AddWithValue("@Address", transaction.Address); cmd.Parameters.AddWithValue("@City", transaction.City); cmd.Parameters.AddWithValue("@Zip", transaction.Zip); cmd.Parameters.AddWithValue("@State", transaction.State); cmd.Parameters.AddWithValue("@Phone", transaction.Phone); cmd.Parameters.AddWithValue("@Amount", transaction.Amount); db.Execute(cmd); return; }
public bool SaveCMEDRegisterCustomer(CMEDCustomer customer) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveCMEDRegisterCustomer"; cmd.Parameters.AddWithValue("@first_name", customer.first_name); cmd.Parameters.AddWithValue("@last_name", customer.last_name); cmd.Parameters.AddWithValue("@phone_number", customer.phone_number); cmd.Parameters.AddWithValue("@Email", customer.email); cmd.Parameters.AddWithValue("@Password", customer.password); cmd.Parameters.AddWithValue("@opt_in", customer.opt_in); db.Execute(cmd); return true; }
public void SaveCMEDWorkshop(CMEDWorkshop worshop) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveCMEDWorkshop"; cmd.Parameters.AddWithValue("@ID", worshop.ID); cmd.Parameters.AddWithValue("@ProductID", worshop.ProductID); cmd.Parameters.AddWithValue("@Title", worshop.Title); cmd.Parameters.AddWithValue("@SubTitle", worshop.SubTitle); cmd.Parameters.AddWithValue("@Location", worshop.Location); cmd.Parameters.AddWithValue("@DateLine", worshop.DateLine); cmd.Parameters.AddWithValue("@Prerequisite", worshop.Prerequisite); cmd.Parameters.AddWithValue("@ShortDescription", worshop.ShortDescription); cmd.Parameters.AddWithValue("@LongDescription", worshop.LongDescription); cmd.Parameters.AddWithValue("@PurchaseDescription", worshop.PurchaseDescription); cmd.Parameters.AddWithValue("@RegisterURL", worshop.RegisterURL); cmd.Parameters.AddWithValue("@ThumbNailImageUrl", worshop.ThumbNailImageUrl); cmd.Parameters.AddWithValue("@FullImageUrl", worshop.FullImageUrl); cmd.Parameters.AddWithValue("@Cost", worshop.Cost); cmd.Parameters.AddWithValue("@MealsCost", worshop.MealsCost); cmd.Parameters.AddWithValue("@MealsCount", worshop.MealsCount); cmd.Parameters.AddWithValue("@Deposit", worshop.Deposit); cmd.Parameters.AddWithValue("@Active", worshop.Active); cmd.Parameters.AddWithValue("@Archive", worshop.Archive); cmd.Parameters.AddWithValue("@Sort", worshop.Sort); cmd.Parameters.AddWithValue("@DepositOn", worshop.DepositOn); cmd.Parameters.AddWithValue("@MealCostOn", worshop.MealCostOn); cmd.Parameters.AddWithValue("@CanPurchase", worshop.CanPurchase); db.Execute(cmd); return; }
public List<WorkShop> GetWorkShops() { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetWorkShops"; List<WorkShop> Workshops = new List<WorkShop>(); DataTable dt = db.Execute(cmd); foreach (DataRow dr in dt.Rows) { WorkShop workshop = new WorkShop { ID = Int32.Parse(dr["ID"].ToString()), Location = dr["Location"].ToString(), Title = dr["Title"].ToString(), Sort = Int32.Parse(dr["Sort"].ToString()), Active = Convert.ToBoolean(dr["Active"]), ShortDescription = dr["ShortDescription"].ToString(), Dates = dr["Dates"].ToString(), DetailsURL = dr["DetailsURL"].ToString(), ResortDescription = dr["ResortDescription"].ToString(), ResortImageURL = dr["ResortImageURL"].ToString(), CMyssImageURL = dr["CMyssImageURL"].ToString(), }; Workshops.Add(workshop); } return Workshops; }
public List<UserTransactionReport> GetWorkshopsPurchased(int ProductID) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetWorkshopsPurchasedByProduct"; cmd.Parameters.AddWithValue("@ProductID", ProductID); List<UserTransactionReport> Students = new List<UserTransactionReport>(); DataTable dt = db.Execute(cmd); foreach (DataRow dr in dt.Rows) { UserTransactionReport Student = new UserTransactionReport { Email = dr["Email"].ToString(), ProductID = Int32.Parse(dr["ProductID"].ToString()), ProductName = dr["ProductName"].ToString(), OrderDate = DateTime.Parse(dr["OrderDate"].ToString()), Status = dr["Status"].ToString(), FullName = dr["FullName"].ToString(), Amount = Decimal.Parse(dr["Amount"].ToString()), Phone = dr["Phone"].ToString(), Location = dr["Location"].ToString(), }; Students.Add(Student); } return Students; }
public MyssProduct getProduct(int ProductID) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetProduct"; cmd.Parameters.AddWithValue("@ProductID", ProductID); DataTable dt = db.Execute(cmd); DataRow dr = dt.Rows[0]; MyssProduct product = new MyssProduct { LongDescription = dr["LongDescription"].ToString(), ShortDescrption = dr["ShortDescrption"].ToString(), ProductName = dr["ProductName"].ToString(), ProductID = Int32.Parse(dr["ProductID"].ToString()), ProductPrice = Double.Parse(dr["ProductPrice"].ToString()), }; return product; }
public List<CMEDTimeZone> GetTimeZones() { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetTimeZomes"; DataTable dt = db.Execute(cmd); List<CMEDTimeZone> timezones = new List<CMEDTimeZone>(); foreach (DataRow dr in dt.Rows) { CMEDTimeZone timezone = new CMEDTimeZone { timezone_code = dr["timezone_code"].ToString(), timezone_title = dr["timezone_title"].ToString(), }; timezones.Add(timezone); } return timezones; }
public List<OrderItem> getOrdersByEmail(string email) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "getOrdersByEmail"; cmd.Parameters.AddWithValue("@email", email); DataTable dt = db.Execute(cmd); List<OrderItem> OrderItems = new List<OrderItem>(); foreach (DataRow dr in dt.Rows) { OrderItem orderitem = new OrderItem { LineItemID = Int32.Parse(dr["LineItemNo"].ToString()), OrderID = Int32.Parse(dr["OrderNo"].ToString()), OrderDate = DateTime.Parse(dr["OrderDate"].ToString()).Date, Name = dr["ProductName"].ToString(), ItemType = dr["ProductType"].ToString(), Status = dr["LineStatus"].ToString(), UnitPrice = double.Parse(dr["UnitPrice"].ToString()), TotalPrice = double.Parse(dr["TotalPrice"].ToString()), Quantity = Int32.Parse(dr["Quantity"].ToString()), Url = dr["Url"].ToString(), ViewOrder = dr["ViewOrder"].ToString(), }; OrderItems.Add(orderitem); } return OrderItems; }
public List<OrderSummary> getOrders(string email) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetOrders"; cmd.Parameters.AddWithValue("@email", email); DataTable dt = db.Execute(cmd); List<OrderSummary> orders = new List<OrderSummary>(); foreach (DataRow dr in dt.Rows) { OrderSummary ordersummary = new OrderSummary { OrderID = Int32.Parse(dr["OrderNo"].ToString()), OrderDate = DateTime.Parse(dr["OrderDate"].ToString()), ShipDate = DateTime.Parse(dr["ShipDate"].ToString()).Date, OrderStatus = dr["OrderStatus"].ToString(), BillingStatus = dr["BillingStatus"].ToString(), OrderType = dr["OrderType"].ToString(), OrderAmount = double.Parse(dr["OrderAmount"].ToString()) }; orders.Add(ordersummary); } return orders; }
public OrderSummary getOrder(int OrderID) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetOrder"; cmd.Parameters.AddWithValue("@OrderNo", OrderID); DataTable dt = db.Execute(cmd); DataRow dr = dt.Rows[0]; OrderSummary ordersummary = new OrderSummary { OrderID = Int32.Parse(dr["OrderNo"].ToString()), OrderDate = DateTime.Parse(dr["OrderDate"].ToString()), ShipDate = DateTime.Parse(dr["ShipDate"].ToString()).Date, OrderStatus = dr["OrderStatus"].ToString(), BillingStatus = dr["BillingStatus"].ToString(), OrderType = dr["OrderType"].ToString(), OrderAmount = double.Parse(dr["OrderAmount"].ToString()) }; return ordersummary; }
public void SaveCartItem(long product_id, decimal price, long cart_id, string email, string ip_address) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveCartItemWithPrice"; cmd.Parameters.AddWithValue("@product_id", product_id); cmd.Parameters.AddWithValue("@price", price); cmd.Parameters.AddWithValue("@cart_id", cart_id); cmd.Parameters.AddWithValue("@email", email); cmd.Parameters.AddWithValue("@ip", ip_address); db.Execute(cmd); return; }
public int IsSalonMember(string email) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "IsSalonMember"; cmd.Parameters.AddWithValue("@email", email); DataTable dt = db.Execute(cmd); DataRow row = dt.Rows[0]; return Int32.Parse(row["SALON_STATUS"].ToString()); }
public void SaveCMEDNesLetterMember(string email, string FirstName, string LastName ) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveCMEDNesLetterMember"; cmd.Parameters.AddWithValue("@FirstName", FirstName); cmd.Parameters.AddWithValue("@LastName", LastName); cmd.Parameters.AddWithValue("@email", email); db.Execute(cmd); }
public long IssueNewGlobalID() { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "IssueNewGlobalID"; DataTable dt = db.Execute(cmd); DataRow row = dt.Rows[0]; return long.Parse(row["ID"].ToString()); }
public bool SaveCMEDUserBio(CMEDGraduate graduate) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveCMEDUserBio"; cmd.Parameters.AddWithValue("@user_id", graduate.user_id); cmd.Parameters.AddWithValue("@FirstName", graduate.first_name); cmd.Parameters.AddWithValue("@LastName", graduate.last_name); cmd.Parameters.AddWithValue("@Email", graduate.email); cmd.Parameters.AddWithValue("@City", graduate.City); cmd.Parameters.AddWithValue("@State", graduate.State); cmd.Parameters.AddWithValue("@Region", graduate.Region); cmd.Parameters.AddWithValue("@Bio", graduate.Bio); cmd.Parameters.AddWithValue("@url", graduate.URL); cmd.Parameters.AddWithValue("@Photo", graduate.Photo); DataTable dt = db.Execute(cmd); return true; }
public bool IsWorkShop(long order_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "IsWorkShop"; cmd.Parameters.AddWithValue("@order_id", order_id); DataTable dt = db.Execute(cmd); DataRow row = dt.Rows[0]; return Boolean.Parse(row["IsWorkShop"].ToString()); }
public long SaveCosWin(CMEDCosWin calwin) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveCosWin"; cmd.Parameters.AddWithValue("@ordernum", calwin.order_id); cmd.Parameters.AddWithValue("@bmonth", calwin.bmonth); cmd.Parameters.AddWithValue("@bday", calwin.bday); cmd.Parameters.AddWithValue("@byear", calwin.byear); cmd.Parameters.AddWithValue("@bhour", calwin.bhour); cmd.Parameters.AddWithValue("@bmin", calwin.bmin); cmd.Parameters.AddWithValue("@ampm", calwin.ampm); cmd.Parameters.AddWithValue("@bcity", calwin.bcity); cmd.Parameters.AddWithValue("@bstate", calwin.bstate); cmd.Parameters.AddWithValue("@bcountry", calwin.bcountry); cmd.Parameters.AddWithValue("@fname", calwin.fname); cmd.Parameters.AddWithValue("@lname", calwin.lname); cmd.Parameters.AddWithValue("@BeginDate", calwin.begindate); cmd.Parameters.AddWithValue("@TimeZone", calwin.timezone); cmd.Parameters.AddWithValue("@gender", calwin.gender); DataTable dt = db.Execute(cmd); DataRow row = dt.Rows[0]; return long.Parse(row["order_id"].ToString()); }
public Cart LoadCart(long cart_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDShopShoppingCart"; cmd.Parameters.AddWithValue("@cart_id", cart_id); DataTable dt = db.Execute(cmd); DataRow dr = dt.Rows[0]; Cart cart = new Cart { cart_id = long.Parse(dr["cart_id"].ToString()), customer_id = long.Parse(dr["customer_id"].ToString()), order_status = dr["order_status"].ToString(), email = dr["email"].ToString(), first_name = dr["first_name"].ToString(), last_name = dr["last_name"].ToString(), order_amount = double.Parse(dr["order_amount"].ToString()), ip_address = dr["ip_address"].ToString(), ip_address_country_code = dr["ip_address_country_code"].ToString(), active = Boolean.Parse(dr["active"].ToString()), date_created = DateTime.Parse(dr["date_created"].ToString()), created_by = dr["created_by"].ToString(), date_updated = DateTime.Parse(dr["date_updated"].ToString()), updated_by = dr["updated_by"].ToString(), }; DB dbItems = new DB(); SqlCommand cmdItems = new SqlCommand(); cmdItems.CommandType = CommandType.StoredProcedure; cmdItems.CommandText = "GetCMEDShopCartItems"; cmdItems.Parameters.AddWithValue("@cart_id", cart_id); DataTable dtItems = dbItems.Execute(cmdItems); foreach (DataRow drItems in dtItems.Rows) { CartItem cartitem = new CartItem { cart_item_id = long.Parse(drItems["cart_item_id"].ToString()), cart_id = long.Parse(drItems["cart_id"].ToString()), product_id = long.Parse(drItems["product_id"].ToString()), product_title = drItems["product_title"].ToString(), quantity = Int32.Parse(drItems["quantity"].ToString()), price = double.Parse(drItems["price"].ToString()), final_price = double.Parse(drItems["final_price"].ToString()), discount_code = drItems["discount_code"].ToString(), date_created = DateTime.Parse(drItems["date_created"].ToString()), created_by = drItems["created_by"].ToString(), date_updated = DateTime.Parse(drItems["date_updated"].ToString()), updated_by = drItems["updated_by"].ToString(), }; cart.CartItems.Add(cartitem); cart.order_amount = cart.order_amount + cartitem.final_price; } return cart; }
public long SaveRelationShip(CMEDRelationship relationship) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveRelationShip"; cmd.Parameters.AddWithValue("@ordernum", relationship.order_id); cmd.Parameters.AddWithValue("@bmonth", relationship.bmonth); cmd.Parameters.AddWithValue("@bday", relationship.bday); cmd.Parameters.AddWithValue("@byear", relationship.byear); cmd.Parameters.AddWithValue("@bhour", relationship.bhour); cmd.Parameters.AddWithValue("@bmin", relationship.bmin); cmd.Parameters.AddWithValue("@ampm", relationship.ampm); cmd.Parameters.AddWithValue("@bcity", relationship.bcity); cmd.Parameters.AddWithValue("@bstate", relationship.bstate); cmd.Parameters.AddWithValue("@bcountry", relationship.bcountry); cmd.Parameters.AddWithValue("@fname", relationship.fname); cmd.Parameters.AddWithValue("@lname", relationship.lname); cmd.Parameters.AddWithValue("@gender", relationship.gender); cmd.Parameters.AddWithValue("@bmonth2", relationship.bmonth); cmd.Parameters.AddWithValue("@bday2", relationship.bday); cmd.Parameters.AddWithValue("@byear2", relationship.byear); cmd.Parameters.AddWithValue("@bhour2", relationship.bhour); cmd.Parameters.AddWithValue("@bmin2", relationship.bmin); cmd.Parameters.AddWithValue("@ampm2", relationship.ampm); cmd.Parameters.AddWithValue("@bcity2", relationship.bcity); cmd.Parameters.AddWithValue("@bstate2", relationship.bstate); cmd.Parameters.AddWithValue("@bcountry2", relationship.bcountry); cmd.Parameters.AddWithValue("@fname2", relationship.fname); cmd.Parameters.AddWithValue("@lname2", relationship.lname); cmd.Parameters.AddWithValue("@gender2", relationship.gender2); DataTable dt = db.Execute(cmd); DataRow row = dt.Rows[0]; return long.Parse(row["order_id"].ToString()); }
public CMEDShopOrder LoadOrder(long order_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDShopOrder"; cmd.Parameters.AddWithValue("@order_id", order_id); DataTable dt = db.Execute(cmd); DataRow dr = dt.Rows[0]; CMEDShopOrder order = new CMEDShopOrder { order_id = long.Parse(dr["order_id"].ToString()), customer_id = long.Parse(dr["customer_id"].ToString()), order_status = dr["order_status"].ToString(), email = dr["email"].ToString(), first_name = dr["first_name"].ToString(), last_name = dr["last_name"].ToString(), ip_address = dr["ip_address"].ToString(), ip_address_country_code = dr["ip_address_country_code"].ToString(), date_created = DateTime.Parse(dr["date_created"].ToString()), created_by = dr["created_by"].ToString(), date_updated = DateTime.Parse(dr["date_updated"].ToString()), updated_by = dr["updated_by"].ToString(), }; DB dbItems = new DB(); SqlCommand cmdItems = new SqlCommand(); cmdItems.CommandType = CommandType.StoredProcedure; cmdItems.CommandText = "GetCMEDShopOrderItems"; cmdItems.Parameters.AddWithValue("@order_id", order_id); DataTable dtItems = dbItems.Execute(cmdItems); foreach (DataRow drItems in dtItems.Rows) { CMEDShopOrderItem orderitem = new CMEDShopOrderItem { order_item_id = long.Parse(drItems["order_item_id"].ToString()), order_id = long.Parse(drItems["order_id"].ToString()), product_id = long.Parse(drItems["product_id"].ToString()), product_title = drItems["product_title"].ToString(), quantity = Int32.Parse(drItems["quantity"].ToString()), price = double.Parse(drItems["price"].ToString()), final_price = double.Parse(drItems["final_price"].ToString()), discount_code = drItems["discount_code"].ToString(), order_item_status = drItems["order_item_status"].ToString(), date_created = DateTime.Parse(drItems["date_created"].ToString()), created_by = drItems["created_by"].ToString(), date_updated = DateTime.Parse(drItems["date_updated"].ToString()), updated_by = drItems["updated_by"].ToString(), }; order.OrderItems.Add(orderitem); order.order_amount = order.order_amount + (decimal)orderitem.final_price; } return order; }
public void SaveWebStreamEmail(string email, string StreamName) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddWebStreamEmail"; cmd.Parameters.AddWithValue("@email", email); cmd.Parameters.AddWithValue("@StreamName", StreamName); db.Execute(cmd); return; }
public LoginResult LoginEmailWebStream(string email, int ProductID) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoginEmailWebStream"; cmd.Parameters.AddWithValue("@email", email); cmd.Parameters.AddWithValue("@ProductID", ProductID); DataTable dt = db.Execute(cmd); DataRow dr = dt.Rows[0]; return new LoginResult { ProductID = Int32.Parse(dr["ProductID"].ToString()), PageURL = dr["PageURL"].ToString() }; }
public void UpateCMEDShopTransactionByOrderID(long order_id, string status, string auth_code, string auth_message, string auth_response_code, string auth_transaction_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "UpateCMEDShopTransactionByOrderID"; cmd.Parameters.AddWithValue("@order_id", order_id); cmd.Parameters.AddWithValue("@status", status); cmd.Parameters.AddWithValue("@auth_code", auth_code); cmd.Parameters.AddWithValue("@auth_message", auth_message); cmd.Parameters.AddWithValue("@auth_response_code", auth_response_code); cmd.Parameters.AddWithValue("@auth_transaction_id", auth_transaction_id); db.Execute(cmd); return; }
public void RemoveCartItem(long cart_id, long product_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "RemoveCartItem"; cmd.Parameters.AddWithValue("@product_id", product_id); cmd.Parameters.AddWithValue("@cart_id", cart_id); db.Execute(cmd); return; }
public bool Update() { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "UpdateMediaGroupItem"; cmd.Parameters.AddWithValue("@AssetID", AssetID); cmd.Parameters.AddWithValue("@FileName", FileName); cmd.Parameters.AddWithValue("@FilePath", FilePath); cmd.Parameters.AddWithValue("@PermanentLink", PermanentLinkURL); cmd.Parameters.AddWithValue("@PreviewImage", PreviewImageURL); cmd.Parameters.AddWithValue("@Sort", Sort); DB db = new DB(); db.Execute(cmd); return true; }
public List<OnDemandVideoItem> GetOnDemandAudioVideoItems(int location_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetOnDemandVideoItems"; cmd.Parameters.AddWithValue("@location_id", location_id); List<OnDemandVideoItem> VideoItems = new List<OnDemandVideoItem>(); DataTable dt = db.Execute(cmd); foreach (DataRow dr in dt.Rows) { OnDemandVideoItem VideoItem = new OnDemandVideoItem { ID = Int32.Parse(dr["ID"].ToString()), MediaID = Int32.Parse(dr["MediaID"].ToString()), MediaTitle = dr["MediaTitle"].ToString(), MediaType = dr["MediaType"].ToString(), AssetID = dr["AssetID"].ToString(), StoreFrontURL = dr["StoreFrontURL"].ToString(), }; VideoItems.Add(VideoItem); } return VideoItems; }