/// <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);
}
protected void Page_Load(object sender, EventArgs e)
{
//Check if logged in
if (Session["UserID"] == null)
{
//Set a session variable to indicate return to checkout after login
Session.Add("ReturnToCheckout", true);
Response.Redirect("~/Login.aspx");
}
if (!IsPostBack)
{
List <Tuple <string, int> > list = new List <Tuple <string, int> >();
if (Session["cartList"] != null)
{
list = (List <Tuple <string, int> >)(Session["cartList"]);
}
else
{
Response.Redirect("~/Index.aspx");
}
//Collection that will be bound to the checkout datalist
List <CheckoutItem> coItems = new List <CheckoutItem>();
foreach (Tuple <string, int> item in list)
{
CheckoutItem coItem = new CheckoutItem();
coItem.Prodcd = item.Item1;
coItem.Quantity = item.Item2;
//Get product info
Product prod = new Product();
prod.GetProductByCode(item.Item1);
coItem.Name = prod.Name.ToString();
coItem.Msrp = prod.Msrp;
//Get all product delivery types
ProductDeliveryType pdt = new ProductDeliveryType();
List <ProductDeliveryType> pdtypes = pdt.GetAllProductDeliveryTypesByProdCode(prod.ProductCode.ToString());
foreach (ProductDeliveryType pdtype in pdtypes)
{
DeliveryType dt = new DeliveryType();
dt.GetDeliveryTypeByID(pdtype.DeliveryTypeID);
coItem.DeliveryTypes.Add(dt);
}
//Add checkout item to datasource list
coItems.Add(coItem);
}
//Bind to the datalist
DataListCheckout.DataSource = coItems;
DataListCheckout.DataBind();
}
}
protected void DataListCheckout_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var item = e.Item.DataItem as DataRowView;
if (item != null)
{
//Set the checkbox value attribute
var chk = e.Item.FindControl("CheckBoxUseUserAddress") as CheckBox;
if (chk != null)
{
chk.InputAttributes.Add("value", item["Prodcd"].ToString());
}
//Set the dropdownlist datasource
DropDownList spDDL = e.Item.FindControl("dropStateProv") as DropDownList;
StateProvince sp = new StateProvince();
List <StateProvince> states = sp.GetAllStatesProvinces();
spDDL.DataSource = states;
spDDL.DataTextField = "Name";
spDDL.DataValueField = "StateProvinceID";
spDDL.DataBind();
//Get all ProductDeliveryType objects for this prodcd
ProductDeliveryType pdt = new ProductDeliveryType();
List <ProductDeliveryType> pdtypes = pdt.GetAllProductDeliveryTypesByProdCode(item["Prodcd"].ToString());
//For each ProductDeliveryType, add its associated DeliveryType object to the list
List <DeliveryType> dTypes = new List <DeliveryType>();
foreach (ProductDeliveryType pdtype in pdtypes)
{
DeliveryType delType = new DeliveryType();
delType.GetDeliveryTypeByID(pdtype.DeliveryTypeID);
dTypes.Add(delType);
}
//Assign list of DeliveryType to data list
DropDownList delTypesDDL = e.Item.FindControl("DropDownListDeliveryType") as DropDownList;
delTypesDDL.DataSource = dTypes;
delTypesDDL.DataTextField = "Name";
delTypesDDL.DataValueField = "DeliveryTypeID";
delTypesDDL.DataBind();
}
}
}
public RenderProductDeliveryType(ProductDeliveryType pdt)
{
ProductDeliveryTypeID = pdt.ProductDeliveryTypeID;
ProductCode = Convert.ToString(pdt.ProductCode);
Created = Convert.ToDateTime(pdt.Created);
Modified = Convert.ToDateTime(pdt.Modified);
}
/// <summary>
/// Purpose: Grabs all product delivery types by product code
/// Accepts: String (Product Code)
/// Returns: List<ProductDeliveryType>
/// </summary>
public List<ProductDeliveryType> GetAllProductDeliveryTypesByProdCode(string prodcd)
{
List<ProductDeliveryType> pdtypes = new List<ProductDeliveryType>();
try
{
ProductDeliveryTypeData data = new ProductDeliveryTypeData();
List<QSRDataObjects.ProductDeliveryType> dataPDTypes = data.GetAllProductDeliveryTypesByProdCode(prodcd);
foreach (QSRDataObjects.ProductDeliveryType pdt in dataPDTypes)
{
ProductDeliveryType pdtype = new ProductDeliveryType();
pdtype.ProductDeliveryTypeID = pdt.ProductDeliveryTypeID;
pdtype.DeliveryTypeID = Convert.ToInt32(pdt.DeliveryTypeID);
pdtype.ProductCode = pdt.ProductCode;
pdtype.Created = pdt.Created;
pdtype.Modified = pdt.Modified;
pdtypes.Add(pdtype);
}
}
catch (Exception ex)
{
ErrorRoutine(ex, "ProductDeliveryType", "GetAllProductDeliveryTypesByProdCode");
}
return pdtypes;
}
protected void Page_Load(object sender, EventArgs e)
{
prodcd = Request.QueryString["prodcd"].ToString();
var prod = new Product();
prod.GetProductByCode(prodcd);
title.Text = prod.Name.ToString();
productCode.Text = prod.ProductCode.ToString();
brand.Text = prod.Brand.ToString();
//Get configurations
Configuration config = new Configuration();
config.GetConfigurationByCode("xCurrencyCode");
price.Text = "$" + prod.Msrp.ToString() + " " + config.Value;
LabelDescription.Text = prod.Description.ToString();
//If the unlimited quantity flag is set...
if (Convert.ToBoolean(prod.IsQuantityUnlimited) == true)
{
quantity.Text = "Quantity Remaining: Unlimited";
}
else
{
quantity.Text = "Quantity Remaining: " + prod.QuantityInStock.ToString();
}
//Attempt to display image (if it is found)
try
{
itemPic.ImageUrl = "~/Images/Product_Images/" + prodcd + ".jpg";
}
catch (Exception)
{
itemPic.ImageUrl = "";
}
//Fill gridview with available delivery types
ProductDeliveryType pdt = new ProductDeliveryType();
List <ProductDeliveryType> pdtypes = pdt.GetAllProductDeliveryTypesByProdCode(prodcd);
List <DeliveryType> deliveryTypes = new List <DeliveryType>();
foreach (ProductDeliveryType prodDelType in pdtypes)
{
DeliveryType dt = new DeliveryType();
dt.GetDeliveryTypeByID(prodDelType.DeliveryTypeID);
deliveryTypes.Add(dt);
}
GridViewDeliveryTypes.DataSource = deliveryTypes;
GridViewDeliveryTypes.DataBind();
//Don't show "Delivery Types" title if there are no delivery types listed
if (deliveryTypes.Count == 0)
{
LabelDeliveryTypesTitle.Visible = false;
}
}
public void CreateProductTypeIfDoesntExist(string titleSingular, string titlePlural, ProductDeliveryType deliveryType)
{
MetadataManager metadataManager = MetadataManager.GetManager();
CatalogDefinitionManager catalogDefinitionManager = new CatalogDefinitionManager();
using (EcommerceManager ecommerceManager = EcommerceManager.GetManager())
{
int productTypesCount = ecommerceManager.GetProductTypes().Count();
if (!ecommerceManager.GetProductTypes().Any(p => p.Title == titleSingular))
{
ProductType productType = ecommerceManager.CreateProductType();
productType.Title = titleSingular;
productType.TitlePlural = titlePlural;
productType.ProductDeliveryType = deliveryType;
string productClrType;
ecommerceManager.CreateProductTypePersistance(productType, metadataManager, out productClrType);
productType.ClrType = productClrType;
catalogDefinitionManager.AddProductTypeDefinition(productType, ecommerceManager.Provider.Name);
if (productTypesCount == 1)
{
var singleType = ecommerceManager.GetProductTypes().Single();
catalogDefinitionManager.AdjustForMultipleProductTypes(singleType);
}
ecommerceManager.SaveChanges();
metadataManager.SaveChanges(true);
//Starting 6.0 we have workflows for products so whenever you are creating a product you have to create a associated workflow
var productTypeWorkFlowInstaller = new ProductTypeWorkflowInstaller();
productTypeWorkFlowInstaller.InstallWorkflowForProductType(productType);
ProductTypeResolver.RestartProductServiceHost();
}
}
}
private void reloadGridView()
{
if (DropDownListDBTables.SelectedValue == "Administrators")
{
//Get all objects
Administrator obj = new Administrator();
List <Administrator> list = obj.GetAllAdministrators(false);
//Fill a rendered object list
List <RenderAdministrator> renderedList = new List <RenderAdministrator>();
foreach (Administrator x in list)
{
renderedList.Add(new RenderAdministrator(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Audits")
{
//Get all objects
Audit obj = new Audit();
List <Audit> list = obj.GetAllAudits();
//Fill a rendered object list
List <RenderAudit> renderedList = new List <RenderAudit>();
foreach (Audit x in list)
{
renderedList.Add(new RenderAudit(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "AuditTypes")
{
//Get all objects
AuditType obj = new AuditType();
List <AuditType> list = obj.GetAllAuditTypes();
//Fill a rendered object list
List <RenderAuditType> renderedList = new List <RenderAuditType>();
foreach (AuditType x in list)
{
renderedList.Add(new RenderAuditType(x));
}
GridViewDBTable.DataSource = renderedList;
}
if (DropDownListDBTables.SelectedValue == "Categories")
{
//Get all objects
Category obj = new Category();
List <Category> list = obj.GetAllCategories(false);
//Fill a rendered object list
List <RenderCategory> renderedList = new List <RenderCategory>();
foreach (Category x in list)
{
renderedList.Add(new RenderCategory(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Configurations")
{
//Get all objects
Configuration obj = new Configuration();
List <Configuration> list = obj.GetAllConfigurations();
//Fill a rendered object list
List <RenderConfiguration> renderedList = new List <RenderConfiguration>();
foreach (Configuration x in list)
{
renderedList.Add(new RenderConfiguration(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "DeliveryType")
{
//Get all objects
DeliveryType obj = new DeliveryType();
List <DeliveryType> list = obj.GetAllDeliveryTypes();
//Fill a rendered object list
List <RenderDeliveryType> renderedList = new List <RenderDeliveryType>();
foreach (DeliveryType x in list)
{
renderedList.Add(new RenderDeliveryType(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "LangLabels")
{
//Get all objects
LangLabel obj = new LangLabel();
List <LangLabel> list = obj.GetAllLangLabels();
//Fill a rendered object list
List <RenderLangLabel> renderedList = new List <RenderLangLabel>();
foreach (LangLabel x in list)
{
renderedList.Add(new RenderLangLabel(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "OrderItems")
{
//Get all objects
OrderItem obj = new OrderItem();
List <OrderItem> list = obj.GetAllOrderItems();
//Fill a rendered object list
List <RenderOrderItem> renderedList = new List <RenderOrderItem>();
foreach (OrderItem x in list)
{
renderedList.Add(new RenderOrderItem(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Orders")
{
//Get all objects
Order obj = new Order();
List <Order> list = obj.GetAllOrders();
//Fill a rendered object list
List <RenderOrder> renderedList = new List <RenderOrder>();
foreach (Order x in list)
{
renderedList.Add(new RenderOrder(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "ProductDeliveryTypes")
{
//Get all objects
ProductDeliveryType obj = new ProductDeliveryType();
List <ProductDeliveryType> list = obj.GetAllProductDeliveryTypes();
//Fill a rendered object list
List <RenderProductDeliveryType> renderedList = new List <RenderProductDeliveryType>();
foreach (ProductDeliveryType x in list)
{
renderedList.Add(new RenderProductDeliveryType(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Products")
{
//Get all objects
Product obj = new Product();
List <Product> list = obj.GetAllProducts(false);
//Fill a rendered object list
List <RenderProduct> renderedList = new List <RenderProduct>();
foreach (Product x in list)
{
renderedList.Add(new RenderProduct(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "StatesProvinces")
{
//Get all objects
StateProvince obj = new StateProvince();
List <StateProvince> list = obj.GetAllStatesProvinces();
//Fill a rendered object list
List <RenderStateProvince> renderedList = new List <RenderStateProvince>();
foreach (StateProvince x in list)
{
renderedList.Add(new RenderStateProvince(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Users")
{
//Get all objects
User obj = new User();
List <User> list = obj.GetAllUsers();
//Fill a rendered object list
List <RenderUser> renderedList = new List <RenderUser>();
foreach (User x in list)
{
renderedList.Add(new RenderUser(x));
}
GridViewDBTable.DataSource = renderedList;
}
//Databind the new datasource obtained above
GridViewDBTable.DataBind();
}
