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;
}
