public static bool Delete(
Guid productGuid,
Guid userGuid,
string userIPAddress)
{
Product product = new Product(productGuid);
if (
(product.Guid == productGuid) &&
(productGuid != Guid.Empty)
)
{
DBProduct.AddHistory(
Guid.NewGuid(),
product.Guid,
product.StoreGuid,
product.TaxClassGuid,
product.Sku,
ConvertProductStatusToByte(product.Status),
ConvertFulfillmentTypeToByte(product.FulfillmentType),
product.Weight,
product.QuantityOnHand,
product.ImageFileName,
product.ImageFileBytes,
product.Created,
product.CreatedBy,
product.LastModified,
product.LastModifedBy,
DateTime.UtcNow,
product.shippingAmount);
OfferProduct.DeleteByProduct(
productGuid,
userGuid,
userIPAddress);
}
return(DBProduct.Delete(
productGuid,
DateTime.UtcNow,
userGuid,
userIPAddress));
}
//public decimal CalculateItemTax(
// Guid siteGuid,
// Guid taxZoneGuid,
// Guid taxClassGuid,
// decimal itemPrice,
// int quantity)
//{
// decimal taxAmount = 0;
// if (taxZoneGuid == Guid.Empty) { return taxAmount; }
// if (taxClassGuid == Guid.Empty) { return taxAmount; }
// if (itemPrice == 0) { return taxAmount; }
// Collection<TaxRate> taxRates = TaxRate.GetTaxRates(siteGuid, taxZoneGuid);
// if (taxRates.Count > 0)
// {
// foreach (TaxRate taxRate in taxRates)
// {
// if (taxClassGuid == taxRate.TaxClassGuid)
// {
// taxAmount += (taxRate.Rate * (itemPrice * quantity));
// break;
// }
// }
// }
// return taxAmount;
//}
public void CalculateShipping(Cart cart)
{
decimal shippingAmount = 0;
foreach (CartOffer offer in cart.CartOffers)
{
Collection <OfferProduct> offerProducts = OfferProduct.GetbyOffer(offer.OfferGuid);
if (offerProducts != null)
{
foreach (OfferProduct offerProduct in offerProducts)
{
Product product = new Product(offerProduct.ProductGuid);
if (product != null)
{
shippingAmount += (product.ShippingAmount * offer.Quantity);
}
}
}
}
cart.ShippingTotal = Math.Round(shippingAmount, this.RoundingDecimalPlaces, this.RoundingMode);
cart.Save();
}
public static Collection <OfferProduct> GetbyOffer(Guid offerGuid)
{
Collection <OfferProduct> offerProducts = new Collection <OfferProduct>();
using (IDataReader reader = DBOfferProduct.GetByOffer(offerGuid))
{
while (reader.Read())
{
OfferProduct offerProduct = new OfferProduct();
offerProduct.fullFillTermsGuid = new Guid(reader["FullfillTermsGuid"].ToString());
offerProduct.fullfillType = Convert.ToByte(reader["FullfillType"]);
offerProduct.guid = new Guid(reader["Guid"].ToString());
offerProduct.offerGuid = offerGuid;
offerProduct.productGuid = new Guid(reader["ProductGuid"].ToString());
offerProduct.quantity = Convert.ToInt32(reader["Quantity"]);
offerProduct.sortOrder = Convert.ToInt32(reader["SortOrder"]);
offerProducts.Add(offerProduct);
}
}
return(offerProducts);
}
public static Collection<OfferProduct> GetbyOffer(Guid offerGuid)
{
Collection<OfferProduct> offerProducts = new Collection<OfferProduct>();
using (IDataReader reader = DBOfferProduct.GetByOffer(offerGuid))
{
while (reader.Read())
{
OfferProduct offerProduct = new OfferProduct();
offerProduct.fullFillTermsGuid = new Guid(reader["FullfillTermsGuid"].ToString());
offerProduct.fullfillType = Convert.ToByte(reader["FullfillType"]);
offerProduct.guid = new Guid(reader["Guid"].ToString());
offerProduct.offerGuid = offerGuid;
offerProduct.productGuid = new Guid(reader["ProductGuid"].ToString());
offerProduct.quantity = Convert.ToInt32(reader["Quantity"]);
offerProduct.sortOrder = Convert.ToInt32(reader["SortOrder"]);
offerProducts.Add(offerProduct);
}
}
return offerProducts;
}
private void grdOfferProduct_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (store == null) { return; }
GridView grid = (GridView)sender;
Guid guid = (Guid)grid.DataKeys[e.RowIndex].Value;
if (guid == Guid.Empty)
{
grdOfferProduct.EditIndex = -1;
grdOfferProduct.Columns[2].Visible = true;
grdOfferProduct.Columns[3].Visible = true;
BindProductGrid();
upProducts.Update();
return;
}
HiddenField hdnFType = (HiddenField)grid.Rows[e.RowIndex].Cells[0].FindControl("hdnFType");
DropDownList ddFullFillTerms = (DropDownList)grid.Rows[e.RowIndex].Cells[1].FindControl("ddFullFillTerms");
TextBox txtQuantity = (TextBox)grid.Rows[e.RowIndex].Cells[1].FindControl("txtQuantity");
TextBox txtSortOrder = (TextBox)grid.Rows[e.RowIndex].Cells[1].FindControl("txtSortOrder");
FulfillmentType fulfillmentType = Product.FulfillmentTypeFromString(hdnFType.Value);
OfferProduct offerProduct = new OfferProduct(guid);
Guid fulfillTermsGuid = Guid.Empty;
if((fulfillmentType == FulfillmentType.Download)&&(ddFullFillTerms != null))
{
if (ddFullFillTerms.SelectedValue.Length == 36)
{
fulfillTermsGuid = new Guid(ddFullFillTerms.SelectedValue);
}
offerProduct.FullFillTermsGuid = fulfillTermsGuid;
}
int qty;
if(!int.TryParse(txtQuantity.Text, out qty)) qty = 1;
offerProduct.Quantity = qty;
int sort;
if (!int.TryParse(txtSortOrder.Text, out sort)) sort = 100;
offerProduct.SortOrder = sort;
if (siteUser == null) siteUser = SiteUtils.GetCurrentSiteUser();
offerProduct.LastModifiedBy = siteUser.UserGuid;
offerProduct.LastModifiedFromIP = SiteUtils.GetIP4Address();
offerProduct.Save();
grdOfferProduct.EditIndex = -1;
grdOfferProduct.Columns[2].Visible = true;
grdOfferProduct.Columns[3].Visible = true;
BindProductGrid();
upProducts.Update();
}
void btnAddFromGreyBox_Click(object sender, ImageClickEventArgs e)
{
Guid productGuid = Guid.Empty;
FulfillmentType fType = FulfillmentType.None;
Guid fulfillmentTermsGuid = Guid.Empty;
if (hdnProductGuid.Value.Length == 36)
{
productGuid = new Guid(hdnProductGuid.Value);
}
if (hdnFulfillmentType.Value.Length == 1)
{
fType = Product.FulfillmentTypeFromString(hdnFulfillmentType.Value);
}
if (hdnFulfillmentTermsGuid.Value.Length == 36)
{
fulfillmentTermsGuid = new Guid(hdnFulfillmentTermsGuid.Value);
}
if ((offerGuid != Guid.Empty) && (productGuid != Guid.Empty))
{
OfferProduct offerProduct = new OfferProduct();
offerProduct.CreatedBy = siteUser.UserGuid;
offerProduct.CreatedFromIP = SiteUtils.GetIP4Address();
offerProduct.ProductGuid = productGuid;
offerProduct.FullfillType = (byte)fType;
offerProduct.FullFillTermsGuid = fulfillmentTermsGuid;
offerProduct.Quantity = 1;
offerProduct.SortOrder = 100;
offerProduct.OfferGuid = offerGuid;
offerProduct.Save();
}
hdnFulfillmentTermsGuid.Value = string.Empty;
hdnFulfillmentType.Value = string.Empty;
hdnProductGuid.Value = string.Empty;
BindProductGrid();
upProducts.Update();
}
public void InstallContent(Module module, string configInfo)
{
if (string.IsNullOrEmpty(configInfo)) { return; }
Store store = new Store(module.SiteGuid, module.ModuleId);
if (store.Guid == Guid.Empty) // No store created yet
{
store = new Store();
store.SiteGuid = module.SiteGuid;
store.ModuleId = module.ModuleId;
store.Save();
}
SiteSettings siteSettings = new SiteSettings(module.SiteId);
Guid taxClassGuid = Guid.Empty;
List<TaxClass> taxClasses = TaxClass.GetList(siteSettings.SiteGuid);
if (taxClasses.Count == 0)
{
TaxClass taxClass = new TaxClass();
taxClass.SiteGuid = siteSettings.SiteGuid;
taxClass.Title = "Taxable";
taxClass.Description = "Taxable";
taxClass.Save();
taxClass = new TaxClass();
taxClass.SiteGuid = siteSettings.SiteGuid;
taxClass.Title = "Not Taxable";
taxClass.Description = "Not Taxable";
taxClass.Save();
taxClassGuid = taxClass.Guid;
}
else
{
foreach (TaxClass t in taxClasses)
{
if (t.Title == "Not Taxable")
{
taxClassGuid = t.Guid;
}
}
}
SiteUser admin = SiteUser.GetNewestUser(siteSettings);
XmlDocument xml = new XmlDocument();
using (StreamReader stream = File.OpenText(HostingEnvironment.MapPath(configInfo)))
{
xml.LoadXml(stream.ReadToEnd());
}
CultureInfo currencyCulture = new CultureInfo("en-US");
if (xml.DocumentElement.Name == "store")
{
// update the store
XmlAttributeCollection storeAttrributes = xml.DocumentElement.Attributes;
if (storeAttrributes["storeName"] != null)
{
store.Name = storeAttrributes["storeName"].Value;
}
if (storeAttrributes["emailFrom"] != null)
{
store.EmailFrom = storeAttrributes["emailFrom"].Value;
}
if (storeAttrributes["currencyCulture"] != null)
{
currencyCulture = new CultureInfo(storeAttrributes["currencyCulture"].Value);
}
if (storeAttrributes["ownerName"] != null)
{
store.OwnerName = storeAttrributes["ownerName"].Value;
}
if (storeAttrributes["ownerEmail"] != null)
{
store.OwnerEmail = storeAttrributes["ownerEmail"].Value;
}
if (storeAttrributes["city"] != null)
{
store.City = storeAttrributes["city"].Value;
}
if (storeAttrributes["postalCode"] != null)
{
store.PostalCode = storeAttrributes["postalCode"].Value;
}
if (storeAttrributes["phone"] != null)
{
store.Phone = storeAttrributes["phone"].Value;
}
if (storeAttrributes["address"] != null)
{
store.Address = storeAttrributes["address"].Value;
}
if (storeAttrributes["countryGuid"] != null)
{
string g = storeAttrributes["countryGuid"].Value;
if(g.Length == 36)
{
Guid countryGuid = new Guid(g);
store.CountryGuid = countryGuid;
}
}
if (storeAttrributes["stateGuid"] != null)
{
string s = storeAttrributes["stateGuid"].Value;
if(s.Length == 36)
{
Guid stateGuid = new Guid(s);
store.ZoneGuid = stateGuid;
}
}
foreach (XmlNode descriptionNode in xml.DocumentElement.ChildNodes)
{
if (descriptionNode.Name == "storeDescription")
{
store.Description = descriptionNode.InnerText;
break;
}
}
store.Save();
//module settings
foreach (XmlNode node in xml.DocumentElement.ChildNodes)
{
if (node.Name == "moduleSetting")
{
XmlAttributeCollection settingAttributes = node.Attributes;
if ((settingAttributes["settingKey"] != null) && (settingAttributes["settingKey"].Value.Length > 0))
{
string key = settingAttributes["settingKey"].Value;
string val = string.Empty;
if (settingAttributes["settingValue"] != null)
{
val = settingAttributes["settingValue"].Value;
}
ModuleSettings.UpdateModuleSetting(module.ModuleGuid, module.ModuleId, key, val);
}
}
}
if (storeAttrributes["productFilesPath"] != null)
{
if (storeAttrributes["productFilesPath"].Value.Length > 0)
{
string destPath = "~/Data/Sites/" + module.SiteId.ToInvariantString() + "/webstoreproductfiles/";
if (!Directory.Exists(HostingEnvironment.MapPath(destPath)))
{
Directory.CreateDirectory(HostingEnvironment.MapPath(destPath));
}
IOHelper.CopyFolderContents(HostingEnvironment.MapPath(storeAttrributes["productFilesPath"].Value), HostingEnvironment.MapPath(destPath));
}
}
if (storeAttrributes["teaserFilesPath"] != null)
{
if (storeAttrributes["teaserFilesPath"].Value.Length > 0)
{
string destPath = "~/Data/Sites/" + module.SiteId.ToInvariantString() + "/webstoreproductpreviewfiles/";
if (!Directory.Exists(HostingEnvironment.MapPath(destPath)))
{
Directory.CreateDirectory(HostingEnvironment.MapPath(destPath));
}
IOHelper.CopyFolderContents(HostingEnvironment.MapPath(storeAttrributes["teaserFilesPath"].Value), HostingEnvironment.MapPath(destPath));
}
}
FullfillDownloadTerms term = new FullfillDownloadTerms();
term.Name = WebStoreResources.DownloadUnlimited;
term.Description = WebStoreResources.DownloadUnlimited;
if (admin != null)
{
term.CreatedBy = admin.UserGuid;
}
term.StoreGuid = store.Guid;
term.Save();
XmlNode offersNode = null;
foreach (XmlNode n in xml.DocumentElement.ChildNodes)
{
if (n.Name == "offers")
{
offersNode = n;
break;
}
}
if (offersNode != null)
{
foreach (XmlNode node in offersNode.ChildNodes)
{
if (node.Name == "offer")
{
XmlAttributeCollection offerAttrributes = node.Attributes;
Offer offer = new Offer();
offer.StoreGuid = store.Guid;
offer.Created = DateTime.UtcNow;
offer.LastModified = DateTime.UtcNow;
if (admin != null)
{
offer.CreatedBy = admin.UserGuid;
offer.LastModifiedBy = admin.UserGuid;
}
if (offerAttrributes["offerName"] != null)
{
offer.Name = offerAttrributes["offerName"].Value;
}
if (offerAttrributes["nameOnProductList"] != null)
{
offer.ProductListName = offerAttrributes["nameOnProductList"].Value;
}
if (
(offerAttrributes["isVisible"] != null)
&& (offerAttrributes["isVisible"].Value.ToLower() == "true")
)
{
offer.IsVisible = true;
}
if (
(offerAttrributes["isSpecial"] != null)
&& (offerAttrributes["isSpecial"].Value.ToLower() == "true")
)
{
offer.IsSpecial = true;
}
//offer.IsDonation = chkIsDonation.Checked;
if (
(offerAttrributes["showOfferDetailLink"] != null)
&& (offerAttrributes["showOfferDetailLink"].Value.ToLower() == "true")
)
{
offer.ShowDetailLink = true;
}
if (offerAttrributes["primarySort"] != null)
{
int sort = 5000;
if (int.TryParse(offerAttrributes["primarySort"].Value,
out sort))
{
offer.SortRank1 = sort;
}
}
if (offerAttrributes["secondarySort"] != null)
{
int sort = 5000;
if (int.TryParse(offerAttrributes["secondarySort"].Value,
out sort))
{
offer.SortRank2 = sort;
}
}
if (offerAttrributes["price"] != null)
{
offer.Price = decimal.Parse(offerAttrributes["price"].Value, NumberStyles.Currency, currencyCulture);
}
offer.TaxClassGuid = taxClassGuid;
offer.Url = "/"
+ SiteUtils.SuggestFriendlyUrl(
offer.Name + WebStoreResources.OfferUrlSuffix,
siteSettings);
foreach (XmlNode descriptionNode in node.ChildNodes)
{
if (descriptionNode.Name == "abstract")
{
offer.Teaser = descriptionNode.InnerText;
break;
}
}
foreach (XmlNode descriptionNode in node.ChildNodes)
{
if (descriptionNode.Name == "description")
{
offer.Description = descriptionNode.InnerText;
break;
}
}
if (offer.Save())
{
FriendlyUrl newUrl = new FriendlyUrl();
newUrl.SiteId = siteSettings.SiteId;
newUrl.SiteGuid = siteSettings.SiteGuid;
newUrl.PageGuid = offer.Guid;
newUrl.Url = offer.Url.Replace("/", string.Empty);
newUrl.RealUrl = "~/WebStore/OfferDetail.aspx?pageid="
+ module.PageId.ToInvariantString()
+ "&mid=" + module.ModuleId.ToInvariantString()
+ "&offer=" + offer.Guid.ToString();
newUrl.Save();
}
foreach (XmlNode productNode in node.ChildNodes)
{
if (productNode.Name == "product")
{
XmlAttributeCollection productAttrributes = productNode.Attributes;
Product product = new Product();
product.StoreGuid = store.Guid;
if (admin != null)
{
product.CreatedBy = admin.UserGuid;
}
product.Created = DateTime.UtcNow;
product.TaxClassGuid = taxClassGuid;
if (productAttrributes["name"] != null)
{
product.Name = productAttrributes["name"].Value;
}
if (productAttrributes["modelNumber"] != null)
{
product.ModelNumber = productAttrributes["modelNumber"].Value;
}
if (productAttrributes["teaser"] != null)
{
product.TeaserFile = productAttrributes["teaser"].Value;
}
if (productAttrributes["fulfillmentType"] != null)
{
product.FulfillmentType
= Product.FulfillmentTypeFromString(productAttrributes["fulfillmentType"].Value);
}
product.Status = ProductStatus.Available;
product.Weight = 0;
product.QuantityOnHand = 0;
if (
(productAttrributes["showInProductList"] != null)
&& (productAttrributes["showInProductList"].Value.ToLower() == "true")
)
{
product.ShowInProductList = true;
}
if (
(productAttrributes["enableRating"] != null)
&& (productAttrributes["enableRating"].Value.ToLower() == "true")
)
{
product.EnableRating = true;
}
if (productAttrributes["primarySort"] != null)
{
int sort = 5000;
if (int.TryParse(productAttrributes["primarySort"].Value,
out sort))
{
product.SortRank1 = sort;
}
}
if (productAttrributes["secondarySort"] != null)
{
int sort = 5000;
if (int.TryParse(productAttrributes["secondarySort"].Value,
out sort))
{
product.SortRank2 = sort;
}
}
product.Url = "/"
+ SiteUtils.SuggestFriendlyUrl(
product.Name + WebStoreResources.ProductUrlSuffix,
siteSettings);
foreach (XmlNode descriptionNode in productNode.ChildNodes)
{
if (descriptionNode.Name == "abstract")
{
product.Teaser = descriptionNode.InnerText;
break;
}
}
foreach (XmlNode descriptionNode in productNode.ChildNodes)
{
if (descriptionNode.Name == "description")
{
product.Description = descriptionNode.InnerText;
break;
}
}
if (product.Save())
{
if (productAttrributes["file"] != null)
{
ProductFile productFile = new ProductFile(product.Guid);
productFile.ServerFileName = productAttrributes["file"].Value;
if (productAttrributes["fileName"] != null)
{
productFile.FileName = productAttrributes["fileName"].Value;
}
if (admin != null)
{
productFile.CreatedBy = admin.UserGuid;
}
productFile.Save();
}
FriendlyUrl newUrl = new FriendlyUrl();
newUrl.SiteId = siteSettings.SiteId;
newUrl.SiteGuid = siteSettings.SiteGuid;
newUrl.PageGuid = product.Guid;
newUrl.Url = product.Url.Replace("/", string.Empty);
newUrl.RealUrl = "~/WebStore/ProductDetail.aspx?pageid="
+ module.PageId.ToInvariantString()
+ "&mid=" + module.ModuleId.ToInvariantString()
+ "&product=" + product.Guid.ToString();
newUrl.Save();
}
// create offer product
OfferProduct offerProduct = new OfferProduct();
if (admin != null)
{
offerProduct.CreatedBy = admin.UserGuid;
}
offerProduct.ProductGuid = product.Guid;
if (productAttrributes["fulfillmentType"] != null)
{
offerProduct.FullfillType = Convert.ToByte(productAttrributes["fulfillmentType"].Value);
}
if (productAttrributes["sortOrder"] != null)
{
int sort = 100;
if (int.TryParse(productAttrributes["sortOrder"].Value, out sort))
{
offerProduct.SortOrder = sort;
}
}
if (productAttrributes["quantity"] != null)
{
int qty = 1;
if (int.TryParse(productAttrributes["quantity"].Value, out qty))
{
offerProduct.Quantity = qty;
}
}
offerProduct.FullfillType = (byte)product.FulfillmentType;
offerProduct.FullFillTermsGuid = term.Guid;
offerProduct.OfferGuid = offer.Guid;
offerProduct.Save();
}
}
}
}
}
}
//create product
}