public static void UpdatePaymentMethod(AspxCommonInfo aspxCommonObj, PaymentGateWayBasicInfo updatePaymentObj)
{
try
{
var fileObj = new FileHelperController();
updatePaymentObj.DestinationUrl = updatePaymentObj.DestinationUrl.Substring(updatePaymentObj.DestinationUrl.LastIndexOf("Module"));
updatePaymentObj.LogoUrl = fileObj.MoveFile(updatePaymentObj.LogoUrl, updatePaymentObj.DestinationUrl, updatePaymentObj.OldLogoUrl);
if (updatePaymentObj.LogoUrl == "Modules/AspxCommerce/AspxPaymentGateWayManagement/Logos/")
{
updatePaymentObj.LogoUrl = "";
}
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@PaymentGatewayTypeID", updatePaymentObj.PaymentGateWayID));
parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", updatePaymentObj.IsActive));
parameterCollection.Add(new KeyValuePair <string, object>("@IsUse", updatePaymentObj.IsUse));
parameterCollection.Add(new KeyValuePair <string, object>("@PaymentGatewayTypeName", updatePaymentObj.PaymentGatewayName));
parameterCollection.Add(new KeyValuePair <string, object>("@LogoUrl", updatePaymentObj.LogoUrl));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_UpdatePaymentMethod", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateStoreSettings(string settingKeys, string settingValues, string prevFilePath, string newFilePath, string prevStoreLogoPath, string newStoreLogoPath, AspxCommonInfo aspxCommonObj)
{
try
{
FileHelperController fileObj = new FileHelperController();
string uplodedValue;
if (newFilePath != null && prevFilePath != newFilePath)
{
string tempFolder = @"Upload\temp";
uplodedValue = fileObj.MoveFileToSpecificFolder(tempFolder, prevFilePath, newFilePath, @"Modules\AspxCommerce\AspxStoreSettingsManagement\uploads\", aspxCommonObj.StoreID, aspxCommonObj, "store_");
}
else
{
uplodedValue = prevFilePath;
}
string uploadStorelogoValue;
if (newStoreLogoPath != null && prevStoreLogoPath != newStoreLogoPath)
{
string tempFolder = @"Upload\temp";
uploadStorelogoValue = fileObj.MoveFileToSpecificFolder(tempFolder, prevStoreLogoPath, newStoreLogoPath, @"Modules\AspxCommerce\AspxStoreSettingsManagement\uploads\", aspxCommonObj.StoreID, aspxCommonObj, "storelogo_");
}
else
{
uploadStorelogoValue = prevStoreLogoPath;
}
settingKeys = "DefaultProductImageURL" + '*' + "StoreLogoURL" + '*' + settingKeys;
settingValues = uplodedValue + '*' + uploadStorelogoValue + '*' + settingValues;
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@SettingKeys", settingKeys));
parameter.Add(new KeyValuePair<string, object>("@SettingValues", settingValues));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_GetStoreSettingsUpdate", parameter);
StoreSettingConfig ssc = new StoreSettingConfig();
HttpContext.Current.Cache.Remove("AspxStoreSetting" + aspxCommonObj.PortalID.ToString() + aspxCommonObj.StoreID.ToString());
ssc.ResetStoreSettingKeys(aspxCommonObj.StoreID, aspxCommonObj.PortalID, aspxCommonObj.CultureName);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateStoreSettings(string settingKeys, string settingValues, string prevFilePath, string newFilePath, string prevStoreLogoPath, string newStoreLogoPath, AspxCommonInfo aspxCommonObj)
{
try
{
FileHelperController fileObj = new FileHelperController();
string uplodedValue;
if (newFilePath != null && prevFilePath != newFilePath)
{
string tempFolder = @"Upload\temp";
uplodedValue = fileObj.MoveFileToSpecificFolder(tempFolder, prevFilePath, newFilePath, @"Modules\AspxCommerce\AspxStoreSettingsManagement\uploads\", aspxCommonObj.StoreID, "store_");
}
else
{
uplodedValue = prevFilePath;
}
string uploadStorelogoValue;
if (newStoreLogoPath != null && prevStoreLogoPath != newStoreLogoPath)
{
string tempFolder = @"Upload\temp";
uploadStorelogoValue = fileObj.MoveFileToSpecificFolder(tempFolder, prevStoreLogoPath, newStoreLogoPath, @"Modules\AspxCommerce\AspxStoreSettingsManagement\uploads\", aspxCommonObj.StoreID, "storelogo_");
}
else
{
uploadStorelogoValue = prevStoreLogoPath;
}
settingKeys = "DefaultProductImageURL" + '*' + "StoreLogoURL" + '*' + settingKeys;
settingValues = uplodedValue + '*' + uploadStorelogoValue + '*' + settingValues;
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@SettingKeys", settingKeys));
parameter.Add(new KeyValuePair <string, object>("@SettingValues", settingValues));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_GetStoreSettingsUpdate", parameter);
StoreSettingConfig ssc = new StoreSettingConfig();
HttpContext.Current.Cache.Remove("AspxStoreSetting" + aspxCommonObj.PortalID.ToString() + aspxCommonObj.StoreID.ToString());
ssc.ResetStoreSettingKeys(aspxCommonObj.StoreID, aspxCommonObj.PortalID, aspxCommonObj.CultureName);
}
catch (Exception e)
{
throw e;
}
}
private static void ExtractFile(ShippingProvider provider)
{
// TempFileName
string extractedPath = "";
ZipUtil.UnZipFiles(provider.TempFolderPath + "\\" + provider.TempFileName,
HttpContext.Current.Server.MapPath("~/" + provider.ModuleFolder),
ref extractedPath, SageFrame.Common.RegisterModule.Common.Password, false);
FileHelperController fileHelper = new FileHelperController();
string temp = "";
temp = provider.TempFolderPath.Substring(provider.TempFolderPath.LastIndexOf("Module"));
//var thread = new Thread(() => fileHelper.DeleteTempDirectory(temp));
//thread.Start();
fileHelper.DeleteTempDirectory(temp);
}
public int SaveUpdateItemAndAttributes(ItemsInfo.ItemSaveBasicInfo itemObj, AspxCommonInfo aspxCommonObj)
{
bool isModified = false;
bool updateFlag = false;
int storeId = aspxCommonObj.StoreID;
int portalId = aspxCommonObj.PortalID;
string culture = aspxCommonObj.CultureName;
string userName = aspxCommonObj.UserName;
if (itemObj.ItemId > 0)
{
isModified = true;
updateFlag = true;
}
StoreSettingConfig ssc = new StoreSettingConfig();
int itemLargeThumbNailSize =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageSize, storeId, portalId, culture));
int itemMediumThumbNailSize =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageSize, storeId, portalId, culture));
int itemSmallThumbNailSize =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageSize, storeId, portalId, culture));
int _attributeID = 0;
int _inputTypeID = 0;
int _ValidationTypeID = 8;
int _attributeSetGroupID = 0;
bool _isIncludeInPriceRule = false;
bool _isIncludeInPromotions = false;
int _displayOrder = 0;
string sku = "";
string activeFrom = "";
string activeTo = "";
string hidePrice = "";
string isHideInRSS = "";
string isHideToAnonymous = "";
bool toInsertIntoDB = true;
bool isFormValid = true;
string imageVar = string.Empty;
int imageCounterFirst = 0;
ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider();
var formVars = JSONHelper.Deserialise <List <AspxNameValue> >(itemObj.FormVars);
// for (int i = 0; i < formVars.Length; i++)
for (int i = 0; i < formVars.Count; i++)
{
string attribValue = formVars[i].value;
//string jsonResult = formVars[i].name.Replace('%', '_');
string jsonResult = formVars[i].name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
FormValidation formValidation = new FormValidation();
if (jsonVar.Length > 1)
{
_attributeID = Int32.Parse(jsonVar[0]);
_inputTypeID = Int32.Parse(jsonVar[1]);
_ValidationTypeID = Int32.Parse(jsonVar[2]);
_attributeSetGroupID = Int32.Parse(jsonVar[4]);
_isIncludeInPriceRule = bool.Parse(jsonVar[5]);
_isIncludeInPromotions = bool.Parse(jsonVar[6]);
_displayOrder = Int32.Parse(jsonVar[7]);
//Save To Database 1. [aspx_Items] 2. Others
if (_attributeID == 4)
{
sku = formVars[i].value;
}
else if (_attributeID == 22)
{
activeFrom = formVars[i].value;
}
else if (_attributeID == 23)
{
activeTo = formVars[i].value;
}
else if (_attributeID == 26)
{
hidePrice = formVars[i].value;
}
else if (_attributeID == 27)
{
isHideInRSS = formVars[i].value;
}
else if (_attributeID == 28)
{
isHideToAnonymous = formVars[i].value;
}
if (itemObj.ItemId == 0 && updateFlag == false)
{
itemObj.ItemId = obj.AddItem(itemObj, aspxCommonObj, true, isModified, sku, activeFrom, activeTo,
hidePrice, isHideInRSS, isHideToAnonymous, updateFlag);
}
else if (itemObj.ItemId > 0 && i == (formVars.Count - 1))
{
itemObj.ItemId = obj.AddItem(itemObj, aspxCommonObj, true, isModified, sku, activeFrom, activeTo,
hidePrice, isHideInRSS, isHideToAnonymous, updateFlag);
}
if (itemObj.ItemId > 0)
{
if (_inputTypeID == 1)
{
if (_ValidationTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_ValidationTypeID == 5)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
}
else if (_inputTypeID == 2)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(formVars[i].value))
{
attribValue = formVars[i].value;
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 4)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(formVars[i].value))
{
attribValue = formVars[i].value;
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 5 || _inputTypeID == 6 || _inputTypeID == 9 || _inputTypeID == 10 ||
_inputTypeID == 11 || _inputTypeID == 12)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 7)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 8)
{
if (imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(formVars[i].value) &&
formVars[i].value.ToLower() != "undefined")
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID,
formVars[i].value))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
if (attribValue != imageVar)
{
//_imageVar = _imageVar.Replace("../", "");
imageVar = imageVar.Replace("/", "\\");
//attribValue = attribValue.Replace("../", "");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,
itemLargeThumbNailSize,
itemMediumThumbNailSize,
itemSmallThumbNailSize,
@"Modules\AspxCommerce\AspxItemsManagement\uploads\",
itemObj.ItemId, "item_");
}
}
imageCounterFirst++;
}
}
if (isFormValid && toInsertIntoDB)
{
obj.SaveUpdateItemAttributes(itemObj.ItemId, itemObj.AttributeSetId, aspxCommonObj, true,
isModified,
attribValue,
_attributeID, _inputTypeID, _ValidationTypeID, _attributeSetGroupID,
_isIncludeInPriceRule, _isIncludeInPromotions,
_displayOrder);
}
}
}
if (itemObj.ItemTypeId == 1 || itemObj.ItemTypeId == 2)
{
obj.InsertBrandMapping(itemObj.ItemId, itemObj.BrandId, storeId, portalId, userName, culture);
}
if (itemObj.ItemVideoIDs != "" || updateFlag == true)
{
obj.InsertAndUpdateItemVideos(itemObj.ItemId, itemObj.ItemVideoIDs, aspxCommonObj);
}
return(itemObj.ItemId);
}
//public int SaveCategory(Int32 storeID, Int32 portalID, Int32 categoryID, Int32 parentID, AspxNameValue[] formVars, string selectedItems, string userName, string culture, int categoryLargeThumbImage, int categoryMediumThumbImage, int categorySmallThumbImage)
//{
public int SaveCategory(CategoryInfo.CategorySaveBasicInfo categoryObj, AspxCommonInfo aspxCommonObj)
{
try
{
int catID;
CategoryInfo categoryInfo = new CategoryInfo();
FormValidation formValidation = new FormValidation();
List <CategoryAttributeInfo> listCategoryAttributes = new List <CategoryAttributeInfo>();
categoryInfo.CategoryID = categoryObj.CategoryId; //categoryID;
categoryInfo.ParentID = categoryObj.ParentId; //parentID;
categoryInfo.IsShowInCatalog = true;
categoryInfo.IsShowInMenu = true;
categoryInfo.IsShowInSearch = true;
categoryInfo.PortalID = aspxCommonObj.PortalID;
categoryInfo.StoreID = aspxCommonObj.StoreID;
categoryInfo.ActiveFrom = new DateTime(1970, 1, 1);
categoryInfo.ActiveTo = new DateTime(2999, 12, 30);
bool toInsertIntoDB = true;
bool isFormValid = true;
//int _imageCounter = 0;
string imageVar = string.Empty;
int imageCounterFirst = 0;
var formVarss = JSONHelper.Deserialise <List <AspxNameValue> >(categoryObj.FormVars);
foreach (var formVars in formVarss)
{
int inputTypeID;
int validationTypeID;
string attribName = formVars.name;
string attribValue = formVars.value;
string jsonResult = formVars.name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
CategoryAttributeInfo categoryAttribute = new CategoryAttributeInfo();
categoryAttribute.AttributeID = int.Parse(jsonVar[0]);
inputTypeID = int.Parse(jsonVar[1]);
validationTypeID = int.Parse(jsonVar[2]);
if (inputTypeID == 1)
{
if (validationTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.DecimalValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (validationTypeID == 5)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.IntValue = Int32.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.NvarcharValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
}
else if (inputTypeID == 2)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.TextValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.DateValue = DateTime.Parse(attribValue);
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 4)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.BooleanValue = (attribValue == "1" || attribValue.ToLower() == "true")? true: false;
}
else
{
categoryAttribute.BooleanValue = false;
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 5 || inputTypeID == 6 || inputTypeID == 9 || inputTypeID == 10 ||
inputTypeID == 11 || inputTypeID == 12)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.OptionValues = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 7)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.DecimalValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 8)
{
if (imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(attribValue) && attribValue.ToLower() != "undefined")
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
//_imageVar = _imageVar.Replace("../", "");
if (attribValue != imageVar)
{
imageVar = imageVar.Replace("/", "\\");
//attribValue = attribValue.Replace("../", "");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
//attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,categoryLargeThumbImage,categoryMediumThumbImage,categorySmallThumbImage,
// @"Modules\AspxCommerce\AspxCategoryManagement\uploads\",
// categoryID, "cat_");
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,
categoryObj.LargeThumbNailImageHeight,
categoryObj.LargeThumbNailImageWidth,
categoryObj.MediumImageHeight,
categoryObj.MediumImageWidth,
categoryObj.SmallImageHeight,
categoryObj.SmallImageWidth,
@"Modules\AspxCommerce\AspxCategoryManagement\uploads\",
categoryObj.CategoryId, "cat_");
categoryAttribute.FileValue = attribValue;
}
//else if (_imageVar == "")
//{
// categoryAttribute.FileValue = _imageVar;
//}
else
{
categoryAttribute.FileValue = attribValue;
}
}
imageCounterFirst++;
}
if (toInsertIntoDB)
{
listCategoryAttributes.Add(categoryAttribute);
}
}
if (isFormValid)
{
CategorySqlProvider categorySqlProvider = new CategorySqlProvider();
// categoryInfo = categorySqlProvider.CategoryAddUpdate(categoryInfo, selectedItems, listCategoryAttributes, userName, culture);
// catID = categorySqlProvider.CategoryAddUpdate(categoryInfo, selectedItems, listCategoryAttributes, userName, culture);
catID = categorySqlProvider.CategoryAddUpdate(categoryInfo, categoryObj.SelectedItems,
listCategoryAttributes, aspxCommonObj.UserName,
aspxCommonObj.CultureName);
}
else
{
throw new Exception("Form is not valid one");
}
//return categoryInfo;
return(catID);
}
catch (Exception ex)
{
throw ex;
}
}
public static int SaveUpdateItemAndAttributes(ItemsInfo.ItemSaveBasicInfo itemObj, AspxCommonInfo aspxCommonObj)
{
bool isModified = false;
bool updateFlag = false;
int storeId = aspxCommonObj.StoreID;
int portalId = aspxCommonObj.PortalID;
string culture = aspxCommonObj.CultureName;
string userName = aspxCommonObj.UserName;
if (itemObj.ItemId > 0)
{
isModified = true;
updateFlag = true;
}
StoreSettingConfig ssc = new StoreSettingConfig();
int itemLargeThumbNailHeight =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageHeight, storeId, portalId,
culture));
int itemLargeThumbNailWidth =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageWidth, storeId, portalId,
culture));
int itemMediumThumbNailHeight =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageHeight, storeId, portalId,
culture));
int itemMediumThumbNailWidth =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageWidth, storeId, portalId,
culture));
int itemSmallThumbNailHeight =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageHeight, storeId, portalId,
culture));
int itemSmallThumbNailWidth =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageWidth, storeId, portalId,
culture));
int _attributeID = 0;
int _inputTypeID = 0;
int _ValidationTypeID = 8;
int _GroupID = 0;
bool _isIncludeInPriceRule = false;
int _displayOrder = 0;
bool toInsertIntoDB = true;
bool isFormValid = true;
string imageVar = string.Empty;
int imageCounterFirst = 0;
var formVars = JSONHelper.Deserialise<List<AspxNameValue>>(itemObj.FormVars);
ItemInformationDetailsInfo itemInfo = new ItemInformationDetailsInfo();
ItemSetting itemSettings = new ItemSetting();
itemSettings = itemObj.Settings;
itemInfo.NewFromDate = "1900/01/01";
itemInfo.NewToDate = "2999/12/30";
itemInfo.FeaturedFrom = "1900/01/01";
itemInfo.FeaturedTo = "2999/12/30";
itemInfo.SpecialFrom = "1900/01/01";
itemInfo.SpecialTo = "2999/12/30";
itemInfo.SpecialPriceFrom = "1900/01/01";
itemInfo.SpecialPriceTo = "2999/12/30";
itemInfo.IsManageInventory = itemSettings.IsManageInventory;
itemInfo.IsUsedStoreSetting = itemSettings.IsUsedStoreSetting;
itemInfo.MinCartQuantity = itemSettings.MinCartQuantity;
itemInfo.MaxCartQuantity = itemSettings.MaxCartQuantity;
itemInfo.LowStockQuantity = itemSettings.LowStockQuantity;
itemInfo.OutOfStockQuantity = itemSettings.OutOfStockQuantity;
List<ItemAttributeDetailsInfo> listItemAttributes = new List<ItemAttributeDetailsInfo>();
bool hasSystemAttributesOnly = true;
string attributeIDs = "1,2,3,4,5,6,7,8,9,10,11,13,14,15,19,20,23,24,25,26,27,28,29,30,31,32,33,34,44,45,46,47,48";
for (int i = 0; i < formVars.Count; i++)
{
string attribValue = formVars[i].value;
//string jsonResult = formVars[i].name.Replace('%', '_');
string jsonResult = formVars[i].name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
FormValidation formValidation = new FormValidation();
ItemAttributeDetailsInfo itemAttribute = new ItemAttributeDetailsInfo();
if (jsonVar.Length > 1)
{
_attributeID = Int32.Parse(jsonVar[0]);
_inputTypeID = Int32.Parse(jsonVar[1]);
_ValidationTypeID = Int32.Parse(jsonVar[2]);
_GroupID = Int32.Parse(jsonVar[4]);
_isIncludeInPriceRule = bool.Parse(jsonVar[5]);
_displayOrder = Int32.Parse(jsonVar[6]);
itemAttribute.AttributeID = _attributeID;
itemAttribute.InputTypeID = _inputTypeID;
itemAttribute.ValidationTypeID = _ValidationTypeID;
itemAttribute.GroupID = _GroupID;
itemAttribute.IsIncludeInPriceRule = _isIncludeInPriceRule;
itemAttribute.DisplayOrder = _displayOrder;
if (_attributeID > 48)
{
if (hasSystemAttributesOnly)
{
hasSystemAttributesOnly = false;
}
}
if (_attributeID == 4)
{
itemInfo.SKU = formVars[i].value;
}
else if (_attributeID == 19)
{
itemInfo.ActiveFrom = formVars[i].value;
}
else if (_attributeID == 20)
{
itemInfo.ActiveTo = formVars[i].value;
}
else if (_attributeID == 23)
{
itemInfo.HidePrice = Convert.ToBoolean(formVars[i].value);
}
else if (_attributeID == 24)
{
itemInfo.HideInRSSFeed = Convert.ToBoolean(formVars[i].value);
}
else if (_attributeID == 25)
{
itemInfo.HideToAnonymous = Convert.ToBoolean(formVars[i].value);
}
else if (_attributeID == 1)
{
itemInfo.Name = formVars[i].value;
}
else if (_attributeID == 2)
{
itemInfo.Description = formVars[i].value;
}
else if (_attributeID == 3)
{
itemInfo.ShortDescription = formVars[i].value;
}
else if (_attributeID == 5)
{
itemInfo.Weight = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 6)
{
if (formVars[i].value == "" || formVars[i].value == null)
{
itemInfo.NewFromDate =itemInfo.NewFromDate;
}
else
{
itemInfo.NewFromDate = formVars[i].value;
}
}
else if (_attributeID == 7)
{
if (formVars[i].value == "" || formVars[i].value == null)
{
itemInfo.NewToDate = itemInfo.NewToDate;
}
else
{
itemInfo.NewToDate = formVars[i].value;
}
}
else if (_attributeID == 8)
{
itemInfo.Price = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 9)
{
itemInfo.MetaTitle = formVars[i].value;
}
else if (_attributeID == 10)
{
itemInfo.MetaKeyword = formVars[i].value;
}
else if (_attributeID == 11)
{
itemInfo.MetaDescription = formVars[i].value;
}
else if (_attributeID == 13 && formVars[i].value != "")
{
itemInfo.ListPrice = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 14)
{
itemInfo.VisibilityOptionValueID = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 15)
{
itemInfo.Quantity = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 26)
{
itemInfo.IsFeaturedOptionValueID = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 27)
{
if (formVars[i].value == "" || formVars[i].value == null)
{
itemInfo.FeaturedFrom = itemInfo.FeaturedFrom;
}
else
{
itemInfo.FeaturedFrom = formVars[i].value;
}
}
else if (_attributeID == 28)
{
if (formVars[i].value == "" || formVars[i].value == null)
{
itemInfo.FeaturedTo = itemInfo.FeaturedTo;
}
else
{
itemInfo.FeaturedTo = formVars[i].value;
}
}
else if (_attributeID == 29)
{
itemInfo.IsSpecialOptionValueID = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 30)
{
if (formVars[i].value == "" || formVars[i].value == null)
{
itemInfo.SpecialFrom = itemInfo.SpecialFrom;
}
else
{
itemInfo.SpecialFrom = formVars[i].value;
}
}
else if (_attributeID == 31)
{
if (formVars[i].value == "" || formVars[i].value == null)
{
itemInfo.SpecialTo = itemInfo.SpecialTo;
}
else
{
itemInfo.SpecialTo = formVars[i].value;
}
}
else if (_attributeID == 32 && formVars[i].value != "")
{
itemInfo.Length = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 33 && formVars[i].value != "")
{
itemInfo.Height = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 34 && formVars[i].value != "")
{
itemInfo.Width = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 35)
{
itemInfo.IsPromo = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 37)
{
itemInfo.ServiceDuration = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 44 && formVars[i].value != "")
{
itemInfo.CostPrice = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 45 && formVars[i].value != "")
{
itemInfo.SpecialPrice = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 46)
{
if (formVars[i].value == "" || formVars[i].value == null)
{
itemInfo.SpecialPriceFrom = itemInfo.SpecialPriceFrom;
}
else
{
itemInfo.SpecialPriceFrom = formVars[i].value;
}
}
else if (_attributeID == 47)
{
if (formVars[i].value == "" || formVars[i].value == null)
{
itemInfo.SpecialPriceTo = itemInfo.SpecialPriceTo;
}
else
{
itemInfo.SpecialPriceTo = formVars[i].value;
}
}
else if (_attributeID == 48 && formVars[i].value != "")
{
itemInfo.ManufacturerPrice = Convert.ToDecimal(formVars[i].value);
}
}
if (_attributeID == 37)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.IntValue = int.Parse(formVars[i].value);
listItemAttributes.Add(itemAttribute);
}
else
{
isFormValid = false;
break;
}
}
else if (_attributeID == 35)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.OptionValues = formVars[i].value;
listItemAttributes.Add(itemAttribute);
}
else
{
isFormValid = false;
break;
}
}
if (_attributeID > 48)
{
if (_inputTypeID == 1)
{
if (_ValidationTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.DecimalValue = decimal.Parse(formVars[i].value);
}
else
{
isFormValid = false;
break;
}
}
else if (_ValidationTypeID == 5)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.IntValue = int.Parse(formVars[i].value);
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.NvarcharValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
}
else if (_inputTypeID == 2)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.TextValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(formVars[i].value))
{
itemAttribute.DateValue = DateTime.Parse(formVars[i].value);
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 4)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(attribValue))
{
itemAttribute.BooleanValue = (formVars[i].value == "1" ||
formVars[i].value.ToLower() == "true")
? true
: false;
}
else
{
itemAttribute.BooleanValue = false;
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 5 || _inputTypeID == 6 || _inputTypeID == 9 || _inputTypeID == 10 ||
_inputTypeID == 11 || _inputTypeID == 12)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.OptionValues = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 7)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.DecimalValue = decimal.Parse(formVars[i].value);
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 8)
{
if (imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(formVars[i].value) &&
formVars[i].value.ToLower() != "undefined")
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID,
formVars[i].value))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
if (attribValue != imageVar)
{
//_imageVar = _imageVar.Replace("../", "");
imageVar = imageVar.Replace("/", "\\");
//attribValue = attribValue.Replace("../", "");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,
itemLargeThumbNailHeight,
itemLargeThumbNailWidth,
itemMediumThumbNailHeight,
itemMediumThumbNailWidth,
itemSmallThumbNailHeight,
itemSmallThumbNailWidth,
@"Modules\AspxCommerce\AspxItemsManagement\uploads\",
itemObj.ItemId, "item_");
itemAttribute.FileValue =
attribValue.Replace(@"Modules\AspxCommerce\AspxItemsManagement\uploads\", " ");
}
else
{
itemAttribute.FileValue =
attribValue.Replace(@"Modules\AspxCommerce\AspxItemsManagement\uploads\", " ");
}
}
imageCounterFirst++;
}
if (toInsertIntoDB)
{
listItemAttributes.Add(itemAttribute);
}
}
}
if (isFormValid)
{
string groupPrices = GetItemGroupPriceInString(itemObj.GroupPrice, itemObj.ItemId);
itemObj.ItemId = AspxItemMgntProvider.SaveUpdateItemAttributes(itemObj, aspxCommonObj, true,
isModified, itemInfo,
listItemAttributes, attributeIDs,
hasSystemAttributesOnly, updateFlag, groupPrices);
}
else
{
throw new Exception("Form is not valid one");
}
return itemObj.ItemId;
}
public CategoryInfo SaveCategory(Int32 storeID, Int32 portalID, Int32 categoryID, Int32 parentID, AspxNameValue[] formVars, string selectedItems, string userName, string culture, int categoryLargeThumbImage, int categoryMediumThumbImage, int categorySmallThumbImage)
{
try
{
CategoryInfo categoryInfo = new CategoryInfo();
FormValidation formValidation = new FormValidation();
List<CategoryAttributeInfo> listCategoryAttributes = new List<CategoryAttributeInfo>();
categoryInfo.CategoryID = categoryID;
categoryInfo.ParentID = parentID;
categoryInfo.IsShowInCatalog = true;
categoryInfo.IsShowInMenu = true;
categoryInfo.IsShowInSearch = true;
categoryInfo.PortalID = portalID;
categoryInfo.StoreID = storeID;
categoryInfo.ActiveFrom = new DateTime(1970, 1, 1);
categoryInfo.ActiveTo = new DateTime(2999, 12, 30);
bool toInsertIntoDB = true;
bool isFormValid = true;
//int _imageCounter = 0;
string imageVar = string.Empty;
int imageCounterFirst = 0;
for (int i = 0; i < formVars.Length; i++)
{
int inputTypeID;
int validationTypeID;
string attribName = formVars[i].name;
string attribValue = formVars[i].value;
string jsonResult = formVars[i].name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
CategoryAttributeInfo categoryAttribute = new CategoryAttributeInfo();
categoryAttribute.AttributeID = int.Parse(jsonVar[0]);
inputTypeID = int.Parse(jsonVar[1]);
validationTypeID = int.Parse(jsonVar[2]);
if (inputTypeID == 1)
{
if (validationTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.DecimalValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (validationTypeID == 5)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.IntValue = Int32.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.NvarcharValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
}
else if (inputTypeID == 2)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.TextValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.DateValue = DateTime.Parse(attribValue);
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 4)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.BooleanValue = (attribValue == "1" ||
attribValue.ToLower() == "true")
? true
: false;
}
else
{
categoryAttribute.BooleanValue = false;
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 5 || inputTypeID == 6 || inputTypeID == 9 || inputTypeID == 10 ||
inputTypeID == 11 || inputTypeID == 12)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.OptionValues = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 7)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.DecimalValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 8)
{
if (imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(attribValue) && attribValue.ToLower() != "undefined")
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
//_imageVar = _imageVar.Replace("../", "");
if (attribValue != imageVar)
{
imageVar = imageVar.Replace("/", "\\");
//attribValue = attribValue.Replace("../", "");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,categoryLargeThumbImage,categoryMediumThumbImage,categorySmallThumbImage,
@"Modules\AspxCommerce\AspxCategoryManagement\uploads\",
categoryID, "cat_");
categoryAttribute.FileValue = attribValue;
}
//else if (_imageVar == "")
//{
// categoryAttribute.FileValue = _imageVar;
//}
else
{
categoryAttribute.FileValue = attribValue;
}
}
imageCounterFirst++;
}
if (toInsertIntoDB)
{
listCategoryAttributes.Add(categoryAttribute);
}
}
if (isFormValid)
{
CategorySqlProvider categorySqlProvider = new CategorySqlProvider();
categoryInfo = categorySqlProvider.CategoryAddUpdate(categoryInfo, selectedItems, listCategoryAttributes, userName, culture);
}
else
{
throw new Exception("Form is not valid one");
}
return categoryInfo;
}
catch (Exception ex)
{
throw ex;
}
}
public string SaveImageContents(Int32 itemID, string imageRootPath, string sourceFileCol, string dataCollection, int itemLargeThumbNailSize, int itemMediumThumbNailSize, int itemSmallThumbNailSize, string imgPreFix)
{
if (dataCollection.Contains("#"))
{
dataCollection = dataCollection.Remove(dataCollection.LastIndexOf("#"));
}
SQLHandler sageSql = new SQLHandler();
string[] individualRow = dataCollection.Split('#');
string[] words;
StringBuilder sbPathList = new StringBuilder();
StringBuilder sbIsActiveList = new StringBuilder();
StringBuilder sbImageType = new StringBuilder();
StringBuilder sbDescription = new StringBuilder();
StringBuilder sbDisplayOrder = new StringBuilder();
StringBuilder sbSourcePathList = new StringBuilder();
foreach (string str in individualRow)
{
words = str.Split('%');
sbPathList.Append(words[0] + "%");
sbIsActiveList.Append(words[1] + "%");
sbImageType.Append(words[2] + "%");
sbDescription.Append(words[3] + "%");
sbDisplayOrder.Append(words[4] + "%");
}
string pathList = string.Empty;
string isActive = string.Empty;
string imageType = string.Empty;
string description = string.Empty;
string displayOrder = string.Empty;
pathList = sbPathList.ToString();
isActive = sbIsActiveList.ToString();
imageType = sbImageType.ToString();
description = sbDescription.ToString();
displayOrder = sbDisplayOrder.ToString();
if (pathList.Contains("%"))
{
pathList = pathList.Remove(pathList.LastIndexOf("%"));
}
if (isActive.Contains("%"))
{
isActive = isActive.Remove(isActive.LastIndexOf("%"));
}
if (imageType.Contains("%"))
{
imageType = imageType.Remove(imageType.LastIndexOf("%"));
}
if (sourceFileCol.Contains("%"))
{
sourceFileCol = sourceFileCol.Remove(sourceFileCol.LastIndexOf("%"));
}
ImageUploaderSqlhandler imageManager = new ImageUploaderSqlhandler();
try
{
FileHelperController fhc = new FileHelperController();
//TODO:: delete all previous files infos lists
fhc.FileMover(itemID, imageRootPath, sourceFileCol, pathList, isActive, imageType, description, displayOrder, imgPreFix, itemLargeThumbNailSize, itemMediumThumbNailSize, itemSmallThumbNailSize);
}
catch (Exception ex)
{
throw ex;
}
return "Success";
}
public void SaveItemAndAttributes(int itemID, int itemTypeID, int attributeSetID, int storeID, int portalID, string userName, string culture, int taxRuleID, string categoriesIds, string relatedItemsIds, string upSellItemsIds, string crossSellItemsIds, string downloadItemsValue, string sourceFileCol, string dataCollection, AspxNameValue[] formVars)
{
try
{
string uplodedDownlodableFormValue = string.Empty;
if (itemTypeID == 2 && downloadItemsValue != "")
{
FileHelperController downLoadableObj = new FileHelperController();
string tempFolder = @"Upload\temp";
uplodedDownlodableFormValue = downLoadableObj.MoveFileToDownlodableItemFolder(tempFolder,
downloadItemsValue,
@"Modules/AspxCommerce/AspxItemsManagement/DownloadableItems/",
itemID, "item_");
}
ItemsController itemController = new ItemsController();
itemID = itemController.SaveUpdateItemAndAttributes(itemID, itemTypeID, attributeSetID, storeID, portalID,
userName, culture, taxRuleID,
categoriesIds, relatedItemsIds, upSellItemsIds,
crossSellItemsIds, uplodedDownlodableFormValue,
formVars);
//return "({\"returnStatus\":1,\"Message\":'Item saved successfully.'})";
if (itemID > 0 && sourceFileCol != "" && dataCollection != "")
{
StoreSettingConfig ssc = new StoreSettingConfig();
int itemLargeThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageSize, storeID,
portalID, culture));
int itemMediumThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageSize,
storeID, portalID, culture));
int itemSmallThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageSize, storeID,
portalID, culture));
dataCollection = dataCollection.Replace("../", "");
SaveImageContents(itemID, @"Modules/AspxCommerce/AspxItemsManagement/uploads/", sourceFileCol,
dataCollection, itemLargeThumbNailSize, itemMediumThumbNailSize,
itemSmallThumbNailSize, "item_");
}
else if (itemID > 0 && sourceFileCol == "" && dataCollection == "")
{
DeleteImageContents(itemID);
}
//if (itemID==0)
//{
// //SaveImageContents(itemID, @"Modules/AspxCommerce/AspxItemsManagement/uploads/", sourceFileCol, dataCollection, "item_");
// //TODO:: DELTE UPLOADED FILE FROM DOWNLOAD FOLDER
//}
}
catch (Exception ex)
{
throw ex;
//ErrorHandler errHandler = new ErrorHandler();
//if (errHandler.LogWCFException(ex))
//{
// return "({\"returnStatus\":-1,\"errorMessage\":'" + ex.Message + "'})";
//}
//else
//{
// return "({\"returnStatus\":-1,\"errorMessage\":'Error while saving item!'})";
//}
}
}
public static int SaveCategory(CategoryInfo.CategorySaveBasicInfo categoryObj, AspxCommonInfo aspxCommonObj)
{
try
{
int catID;
CategoryInfo categoryInfo = new CategoryInfo();
FormValidation formValidation = new FormValidation();
List<CategoryAttributeInfo> listCategoryAttributes = new List<CategoryAttributeInfo>();
categoryInfo.CategoryID = categoryObj.CategoryId; //categoryID;
categoryInfo.ParentID = categoryObj.ParentId; //parentID;
categoryInfo.IsShowInCatalog = true;
categoryInfo.IsShowInMenu = true;
categoryInfo.IsShowInSearch = true;
categoryInfo.PortalID = aspxCommonObj.PortalID;
categoryInfo.StoreID = aspxCommonObj.StoreID;
categoryInfo.ActiveFrom = new DateTime(1970, 1, 1);
categoryInfo.ActiveTo = new DateTime(2999, 12, 30);
categoryInfo.SelectedItems = categoryObj.SelectedItems;
bool toInsertIntoDB = true;
bool isFormValid = true;
//int _imageCounter = 0;
string imageVar = string.Empty;
int imageCounterFirst = 0;
var formVarss = JSONHelper.Deserialise<List<AspxNameValue>>(categoryObj.FormVars);
foreach (var formVars in formVarss)
{
int inputTypeID;
int validationTypeID;
string attribName = formVars.name;
string attribValue = formVars.value;
string jsonResult = formVars.name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
CategoryAttributeInfo categoryAttribute = new CategoryAttributeInfo();
categoryAttribute.AttributeID = int.Parse(jsonVar[0]);
inputTypeID = int.Parse(jsonVar[1]);
validationTypeID = int.Parse(jsonVar[2]);
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
int _attributeID = categoryAttribute.AttributeID;
if (_attributeID == 36)
{
categoryInfo.IsService = int.Parse(formVars.value) != 9;
}
else if (_attributeID == 1)
{
categoryInfo.CategoryName = formVars.value;
}
else if (_attributeID == 9)
{
categoryInfo.MetaTitle = formVars.value;
}
else if (_attributeID == 2)
{
categoryInfo.Description = formVars.value;
}
else if (_attributeID == 3)
{
categoryInfo.ShortDescription = formVars.value;
}
else if (_attributeID == 10)
{
categoryInfo.MetaKeyword = formVars.value;
}
else if (_attributeID == 11)
{
categoryInfo.MetaDescription = formVars.value;
}
else if (_attributeID == 16)
{
categoryInfo.IsShowInMenu = bool.Parse(formVars.value);
}
else if (_attributeID == 17)
{
categoryInfo.IsShowInSearch = bool.Parse(formVars.value);
}
else if (_attributeID == 18)
{
categoryInfo.IsShowInCatalog = bool.Parse(formVars.value);
}
else if (_attributeID == 19)
{
categoryInfo.ActiveFrom = DateTime.Parse(formVars.value);
}
else if (_attributeID == 20)
{
categoryInfo.ActiveTo = DateTime.Parse(formVars.value);
}
else if (_attributeID == 12 || _attributeID == 21 || _attributeID == 22)
{
string _imagePath = string.Empty;
if (imageCounterFirst%2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(attribValue) && attribValue.ToLower() != "undefined")
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
if (imageVar != "")
{
string[] strArray = imageVar.Split('/');
if (strArray[1] == "temp")
{
if (attribValue != imageVar)
{
imageVar = imageVar.Replace("/", "\\");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFoldr(tempFolder, attribValue, imageVar,
categoryObj.LargeThumbNailImageHeight,
categoryObj.LargeThumbNailImageWidth,
categoryObj.MediumImageHeight,
categoryObj.MediumImageWidth,
categoryObj.SmallImageHeight,
categoryObj.SmallImageWidth,
@"Modules\AspxCommerce\AspxCategoryManagement\uploads\",
categoryObj.CategoryId, "cat_");
attribValue =
attribValue.Replace("Modules/AspxCommerce/AspxCategoryManagement/uploads/Small/", "");
_imagePath = attribValue;
}
//else if (_imageVar == "")
//{
// categoryAttribute.FileValue = _imageVar;
//}
else
{
_imagePath = attribValue;
}
}
else
{
_imagePath = strArray[strArray.Length - 1];
}
}
else
{
_imagePath = attribValue;
}
}
imageCounterFirst++;
if (toInsertIntoDB)
{
if (_attributeID == 12)
{
categoryInfo.CategoryBaseImage = _imagePath;
}
else if (_attributeID == 21)
{
categoryInfo.CategoryThumbnailImage = _imagePath;
}
else if (_attributeID == 22)
{
categoryInfo.CategorySmallImage = _imagePath;
}
//listCategoryAttributes.Add(categoryAttribute);
}
}
else if (categoryAttribute.AttributeID > 43)
{
if (categoryInfo.HasSystemAttribute)
{
categoryInfo.HasSystemAttribute = false;
}
if (inputTypeID == 1)
{
if (validationTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.DecimalValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (validationTypeID == 5)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.IntValue = Int32.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.NvarcharValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
}
else if (inputTypeID == 2)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.TextValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.DateValue = DateTime.Parse(attribValue);
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 4)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.BooleanValue = (attribValue == "1" ||
attribValue.ToLower() == "true")
? true
: false;
}
else
{
categoryAttribute.BooleanValue = false;
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 5 || inputTypeID == 6 || inputTypeID == 9 || inputTypeID == 10 ||
inputTypeID == 11 || inputTypeID == 12)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.OptionValues = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 7)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.DecimalValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 8)
{
if (imageCounterFirst%2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(attribValue) && attribValue.ToLower() != "undefined")
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
if (attribValue != imageVar)
{
imageVar = imageVar.Replace("/", "\\");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,
categoryObj.LargeThumbNailImageHeight,
categoryObj.LargeThumbNailImageWidth,
categoryObj.MediumImageHeight,
categoryObj.MediumImageWidth,
categoryObj.SmallImageHeight,
categoryObj.SmallImageWidth,
@"Modules\AspxCommerce\AspxCategoryManagement\uploads\",
categoryObj.CategoryId, "cat_");
categoryAttribute.FileValue = attribValue;
}
//else if (_imageVar == "")
//{
// categoryAttribute.FileValue = _imageVar;
//}
else
{
categoryAttribute.FileValue = attribValue;
}
}
imageCounterFirst++;
}
if (toInsertIntoDB)
{
listCategoryAttributes.Add(categoryAttribute);
}
}
}
if (isFormValid)
{
string attributeIDs = "1,2,3,9,10,11,12,16,17,18,19,20,21,22,36";
catID = AspxCategoryManageProvider.CategoryAddUpdate(categoryInfo,
listCategoryAttributes, aspxCommonObj.UserName,
aspxCommonObj.CultureName, attributeIDs);
}
else
{
throw new Exception("Form is not valid one");
}
return catID;
}
catch (Exception e)
{
throw e;
}
}
public int SaveUpdateItemAndAttributes(int itemID, int itemTypeID, int attributeSetID, int storeID, int portalID, string userName, string culture, int taxClassID, string categoriesIDs, string relatedItemsIDs, string upSellItemsIDs, string crossSellItemsIDs, string downloadItemsValue, AspxNameValue[] formVars)
{
bool isModified = false;
bool updateFlag = false;
if (itemID > 0)
{
isModified = true;
updateFlag = true;
}
StoreSettingConfig ssc = new StoreSettingConfig();
int itemLargeThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageSize, storeID,
portalID, culture));
int itemMediumThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageSize,
storeID, portalID, culture));
int itemSmallThumbNailSize = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageSize, storeID,
portalID, culture));
int _attributeID = 0;
int _inputTypeID = 0;
int _ValidationTypeID = 8;
int _attributeSetGroupID = 0;
bool _isIncludeInPriceRule = false;
bool _isIncludeInPromotions = false;
int _displayOrder = 0;
string sku = "";
string activeFrom = "";
string activeTo = "";
string hidePrice = "";
string isHideInRSS = "";
string isHideToAnonymous = "";
bool toInsertIntoDB = true;
bool isFormValid = true;
string imageVar = string.Empty;
int imageCounterFirst = 0;
ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider();
for (int i = 0; i < formVars.Length; i++)
{
string attribValue = formVars[i].value;
//string jsonResult = formVars[i].name.Replace('%', '_');
string jsonResult = formVars[i].name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
FormValidation formValidation = new FormValidation();
if (jsonVar.Length > 1)
{
_attributeID = Int32.Parse(jsonVar[0]);
_inputTypeID = Int32.Parse(jsonVar[1]);
_ValidationTypeID = Int32.Parse(jsonVar[2]);
_attributeSetGroupID = Int32.Parse(jsonVar[4]);
_isIncludeInPriceRule = bool.Parse(jsonVar[5]);
_isIncludeInPromotions = bool.Parse(jsonVar[6]);
_displayOrder = Int32.Parse(jsonVar[7]);
//Save To Database 1. [aspx_Items] 2. Others
if (_attributeID == 4)
{
sku = formVars[i].value;
}
else if (_attributeID == 22)
{
activeFrom = formVars[i].value;
}
else if (_attributeID == 23)
{
activeTo = formVars[i].value;
}
else if (_attributeID == 26)
{
hidePrice = formVars[i].value;
}
else if (_attributeID == 27)
{
isHideInRSS = formVars[i].value;
}
else if (_attributeID == 28)
{
isHideToAnonymous = formVars[i].value;
}
if (itemID == 0 && updateFlag == false)
{
itemID = obj.AddItem(itemID, itemTypeID, attributeSetID, taxClassID, storeID, portalID, userName, culture, true, isModified,
sku, activeFrom, activeTo, hidePrice, isHideInRSS, isHideToAnonymous, categoriesIDs, relatedItemsIDs, upSellItemsIDs, crossSellItemsIDs, downloadItemsValue, updateFlag);
}
else if (itemID > 0 && i == formVars.Length - 1)
{
itemID = obj.AddItem(itemID, itemTypeID, attributeSetID, taxClassID, storeID, portalID, userName, culture, true, isModified,
sku, activeFrom, activeTo, hidePrice, isHideInRSS, isHideToAnonymous, categoriesIDs, relatedItemsIDs, upSellItemsIDs, crossSellItemsIDs, downloadItemsValue, updateFlag);
}
if (itemID > 0)
{
if (_inputTypeID == 1)
{
if (_ValidationTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_ValidationTypeID == 5)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
}
else if (_inputTypeID == 2)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(formVars[i].value))
{
attribValue = formVars[i].value;
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 4)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(formVars[i].value))
{
attribValue = formVars[i].value;
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 5 || _inputTypeID == 6 || _inputTypeID == 9 || _inputTypeID == 10 ||
_inputTypeID == 11 || _inputTypeID == 12)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 7)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 8)
{
if (imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(formVars[i].value) && formVars[i].value.ToLower() != "undefined")
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
if (attribValue != imageVar)
{
//_imageVar = _imageVar.Replace("../", "");
imageVar = imageVar.Replace("/", "\\");
//attribValue = attribValue.Replace("../", "");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar, itemLargeThumbNailSize, itemMediumThumbNailSize, itemSmallThumbNailSize, @"Modules\AspxCommerce\AspxItemsManagement\uploads\", itemID, "item_");
}
}
imageCounterFirst++;
}
}
if (isFormValid && toInsertIntoDB)
{
obj.SaveUpdateItemAttributes(itemID, attributeSetID, storeID, portalID, userName, culture, true, isModified, attribValue,
_attributeID, _inputTypeID, _ValidationTypeID, _attributeSetGroupID, _isIncludeInPriceRule, _isIncludeInPromotions,
_displayOrder);
}
}
}
return itemID;
}
public void UpateStoreSettings(string settingKeys, string settingValues, string prevFilePath, string newFilePath, int storeID, int portalID, string cultureName)
{
try
{
FileHelperController fileObj = new FileHelperController();
string uplodedValue = string.Empty;
if (newFilePath != null && prevFilePath != newFilePath)
{
string tempFolder = @"Upload\temp";
uplodedValue = fileObj.MoveFileToSpecificFolder(tempFolder, prevFilePath, newFilePath, @"Modules\AspxCommerce\AspxStoreSettingsManagement\uploads\", storeID, "store_");
}
else
{
uplodedValue = prevFilePath;
}
settingKeys = "DefaultProductImageURL" + '#' + settingKeys;
settingValues = uplodedValue + '#' + settingValues;
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@SettingKeys", settingKeys));
parameter.Add(new KeyValuePair<string, object>("@SettingValues", settingValues));
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_GetStoreSettingsUpdate", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
public static void UpdatePaymentMethod(AspxCommonInfo aspxCommonObj, PaymentGateWayBasicInfo updatePaymentObj)
{
try
{
var fileObj = new FileHelperController();
updatePaymentObj.DestinationUrl = updatePaymentObj.DestinationUrl.Substring(updatePaymentObj.DestinationUrl.LastIndexOf("Module"));
updatePaymentObj.LogoUrl = fileObj.MoveFile(updatePaymentObj.LogoUrl, updatePaymentObj.DestinationUrl, updatePaymentObj.OldLogoUrl);
if (updatePaymentObj.LogoUrl == "Modules/AspxCommerce/AspxPaymentGateWayManagement/Logos/")
{
updatePaymentObj.LogoUrl = "";
}
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@PaymentGatewayTypeID", updatePaymentObj.PaymentGateWayID));
parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", updatePaymentObj.IsActive));
parameterCollection.Add(new KeyValuePair<string, object>("@IsUse", updatePaymentObj.IsUse));
parameterCollection.Add(new KeyValuePair<string, object>("@PaymentGatewayTypeName", updatePaymentObj.PaymentGatewayName));
parameterCollection.Add(new KeyValuePair<string, object>("@LogoUrl", updatePaymentObj.LogoUrl));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_UpdatePaymentMethod", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
private static void ExtractFile(ShippingProvider provider)
{
// TempFileName
string extractedPath = "";
ZipUtil.UnZipFiles(provider.TempFolderPath + "\\" + provider.TempFileName,
HttpContext.Current.Server.MapPath("~/" + provider.ModuleFolder),
ref extractedPath, SageFrame.Common.RegisterModule.Common.Password, false);
FileHelperController fileHelper = new FileHelperController();
string temp = "";
temp = provider.TempFolderPath.Substring(provider.TempFolderPath.LastIndexOf("Module"));
//var thread = new Thread(() => fileHelper.DeleteTempDirectory(temp));
//thread.Start();
fileHelper.DeleteTempDirectory(temp);
}
public void InsertNewBrand(string prevFilePath, AspxCommonInfo aspxCommonObj, BrandInfo brandInsertObj)
{
try
{
FileHelperController fileObj = new FileHelperController();
string uplodedValue = string.Empty;
string imagePath;
if (brandInsertObj.BrandImageUrl != null && prevFilePath != brandInsertObj.BrandImageUrl)
{
string tempFolder = @"Upload\temp";
uplodedValue = fileObj.MoveFileToSpecificFolder(tempFolder, prevFilePath, brandInsertObj.BrandImageUrl, @"Modules\AspxCommerce\AspxBrandManagement\uploads\", aspxCommonObj.StoreID, aspxCommonObj, "store_");
}
imagePath = uplodedValue.Length > 0 ? uplodedValue : "";
AspxBrandController.InsertNewBrand(prevFilePath, aspxCommonObj, brandInsertObj, imagePath);
}
catch (Exception e)
{
throw e;
}
}
public void SaveAndUpdateShippingMethods(int shippingMethodID, string shippingMethodName, string prevFilePath, string newFilePath, string alternateText, int displayOrder, string deliveryTime,
decimal weightLimitFrom, decimal weightLimitTo, int shippingProviderID, int storeID, int portalID, bool isActive, string userName, string cultureName)
{
try
{
FileHelperController fileObj = new FileHelperController();
string uplodedValue = string.Empty;
if (newFilePath != null && prevFilePath != newFilePath)
{
string tempFolder = @"Upload\temp";
uplodedValue = fileObj.MoveFileToSpecificFolder(tempFolder, prevFilePath, newFilePath, @"Modules\AspxCommerce\AspxShippingManagement\uploads\", shippingMethodID, "ship_");
}
else
{
uplodedValue = prevFilePath;
}
ShippingMethodSqlProvider obj = new ShippingMethodSqlProvider();
obj.SaveAndUpdateShippings(shippingMethodID, shippingMethodName, uplodedValue, alternateText, displayOrder, deliveryTime, weightLimitFrom, weightLimitTo, shippingProviderID, storeID, portalID, isActive, userName, cultureName);
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveAndUpdateItemCostVariantCombination(CostVariantsCombination itemCostVariants, AspxCommonInfo aspxCommonObj) // not used in ItemDetailPage
{
try
{
string cvCombinations = string.Empty;
foreach (var objCombination in itemCostVariants.VariantOptions)
{
cvCombinations += objCombination.CombinationIsActive;
cvCombinations += "," + objCombination.ImageFile;
cvCombinations += "," + objCombination.CombinationPriceModifier;
cvCombinations += "," + objCombination.CombinationPriceModifierType;
cvCombinations += "," + objCombination.CombinationQuantity;
cvCombinations += "," + objCombination.CombinationType;
cvCombinations += "," + objCombination.CombinationValues;
cvCombinations += "," + objCombination.CombinationValuesName;
cvCombinations += "," + objCombination.CombinationWeightModifier;
cvCombinations += "," + objCombination.CombinationWeightModifierType;
cvCombinations += "," + objCombination.DisplayOrder;
if (itemCostVariants.VariantOptions.Count - 1 != 0)
cvCombinations += "%";
}
// cvCombinations = cvCombinations.Replace("Upload/temp/", "Modules/AspxCommerce/AspxItemsManagement/uploads/");
FileHelperController Fch = new FileHelperController();
string tempFolder = @"Upload\temp";
string destPath = @"Modules/AspxCommerce/AspxItemsManagement/uploads/";
Fch.MoveVariantsImageFile(tempFolder, destPath, itemCostVariants, aspxCommonObj);
AspxItemMgntController.SaveAndUpdateItemCostVariantCombination(itemCostVariants, aspxCommonObj, cvCombinations);
}
catch (Exception e)
{
throw e;
}
}
public List<CardTypeInfo> AddUpdateCardType(int storeID, int portalID, string cultureName, string userName, int cardTypeID, string cardTypeName, bool isActive, string newFilePath, string prevFilePath, string alternateText)
{
FileHelperController imageObj = new FileHelperController();
string uploadedFile;
if (newFilePath != "" && prevFilePath != newFilePath)
{
string tempFolder = @"Upload\temp";
uploadedFile = imageObj.MoveFileToSpecificFolder(tempFolder, prevFilePath, newFilePath, @"Modules\AspxCommerce\AspxCardTypeManagement\uploads\", cardTypeID, "cardType_");
}
else
{
uploadedFile = prevFilePath;
}
try
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
parameter.Add(new KeyValuePair<string, object>("@UserName", userName));
parameter.Add(new KeyValuePair<string, object>("@CardTypeID", cardTypeID));
parameter.Add(new KeyValuePair<string, object>("@CardTypeName", cardTypeName));
parameter.Add(new KeyValuePair<string, object>("@ImagePath", uploadedFile));
parameter.Add(new KeyValuePair<string, object>("@AlternateText", alternateText));
parameter.Add(new KeyValuePair<string, object>("@IsActive", isActive));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteAsList<CardTypeInfo>("[dbo].[usp_Aspx_AddUpdateCardType]", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
public List<CardTypeInfo> AddUpdateCardType(AspxCommonInfo aspxCommonObj, CardTypeSaveInfo cardTypeSaveObj)
{
FileHelperController imageObj = new FileHelperController();
string uploadedFile;
if (cardTypeSaveObj.NewFilePath != "" && cardTypeSaveObj.PrevFilePath != cardTypeSaveObj.NewFilePath)
{
string tempFolder = @"Upload\temp";
uploadedFile = imageObj.MoveFileToSpecificFolder(tempFolder, cardTypeSaveObj.PrevFilePath,
cardTypeSaveObj.NewFilePath,
@"Modules\AspxCommerce\AspxCardTypeManagement\uploads\",
cardTypeSaveObj.CardTypeID, aspxCommonObj, "cardType_");
}
else
{
uploadedFile = cardTypeSaveObj.PrevFilePath;
}
try
{
List<CardTypeInfo> lstCardType = AspxCardTypeController.AddUpdateCardType(aspxCommonObj, cardTypeSaveObj, uploadedFile);
return lstCardType;
}
catch (Exception e)
{
throw e;
}
}
public static int SaveCategory(CategoryInfo.CategorySaveBasicInfo categoryObj, AspxCommonInfo aspxCommonObj)
{
try
{
int catID;
CategoryInfo categoryInfo = new CategoryInfo();
FormValidation formValidation = new FormValidation();
List <CategoryAttributeInfo> listCategoryAttributes = new List <CategoryAttributeInfo>();
categoryInfo.CategoryID = categoryObj.CategoryId; //categoryID;
categoryInfo.ParentID = categoryObj.ParentId; //parentID;
categoryInfo.IsShowInCatalog = true;
categoryInfo.IsShowInMenu = true;
categoryInfo.IsShowInSearch = true;
categoryInfo.PortalID = aspxCommonObj.PortalID;
categoryInfo.StoreID = aspxCommonObj.StoreID;
categoryInfo.ActiveFrom = new DateTime(1970, 1, 1);
categoryInfo.ActiveTo = new DateTime(2999, 12, 30);
categoryInfo.SelectedItems = categoryObj.SelectedItems;
bool toInsertIntoDB = true;
bool isFormValid = true;
//int _imageCounter = 0;
string imageVar = string.Empty;
int imageCounterFirst = 0;
var formVarss = JSONHelper.Deserialise <List <AspxNameValue> >(categoryObj.FormVars);
foreach (var formVars in formVarss)
{
int inputTypeID;
int validationTypeID;
string attribName = formVars.name;
string attribValue = formVars.value;
string jsonResult = formVars.name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
CategoryAttributeInfo categoryAttribute = new CategoryAttributeInfo();
categoryAttribute.AttributeID = int.Parse(jsonVar[0]);
inputTypeID = int.Parse(jsonVar[1]);
validationTypeID = int.Parse(jsonVar[2]);
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
int _attributeID = categoryAttribute.AttributeID;
if (_attributeID == 36)
{
categoryInfo.IsService = int.Parse(formVars.value) != 9;
}
else if (_attributeID == 1)
{
categoryInfo.CategoryName = formVars.value;
}
else if (_attributeID == 9)
{
categoryInfo.MetaTitle = formVars.value;
}
else if (_attributeID == 2)
{
categoryInfo.Description = formVars.value;
}
else if (_attributeID == 3)
{
categoryInfo.ShortDescription = formVars.value;
}
else if (_attributeID == 10)
{
categoryInfo.MetaKeyword = formVars.value;
}
else if (_attributeID == 11)
{
categoryInfo.MetaDescription = formVars.value;
}
else if (_attributeID == 16)
{
categoryInfo.IsShowInMenu = bool.Parse(formVars.value);
}
else if (_attributeID == 17)
{
categoryInfo.IsShowInSearch = bool.Parse(formVars.value);
}
else if (_attributeID == 18)
{
categoryInfo.IsShowInCatalog = bool.Parse(formVars.value);
}
else if (_attributeID == 19)
{
categoryInfo.ActiveFrom = DateTime.Parse(formVars.value);
}
else if (_attributeID == 20)
{
categoryInfo.ActiveTo = DateTime.Parse(formVars.value);
}
else if (_attributeID == 12 || _attributeID == 21 || _attributeID == 22)
{
string _imagePath = string.Empty;
if (imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(attribValue) && attribValue.ToLower() != "undefined")
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
if (attribValue != imageVar)
{
imageVar = imageVar.Replace("/", "\\");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,
categoryObj.LargeThumbNailImageSize,
categoryObj.MediumImageSize,
categoryObj.SmallImageSize,
@"Modules\AspxCommerce\AspxCategoryManagement\uploads\",
categoryObj.CategoryId, "cat_");
attribValue =
attribValue.Replace("Modules/AspxCommerce/AspxCategoryManagement/uploads/Small/", "");
_imagePath = attribValue;
}
//else if (_imageVar == "")
//{
// categoryAttribute.FileValue = _imageVar;
//}
else
{
_imagePath = attribValue;
}
}
imageCounterFirst++;
if (toInsertIntoDB)
{
if (_attributeID == 12)
{
categoryInfo.CategoryBaseImage = _imagePath;
}
else if (_attributeID == 21)
{
categoryInfo.CategoryThumbnailImage = _imagePath;
}
else if (_attributeID == 22)
{
categoryInfo.CategorySmallImage = _imagePath;
}
//listCategoryAttributes.Add(categoryAttribute);
}
}
else if (categoryAttribute.AttributeID > 43)
{
if (categoryInfo.HasSystemAttribute)
{
categoryInfo.HasSystemAttribute = false;
}
if (inputTypeID == 1)
{
if (validationTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.DecimalValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (validationTypeID == 5)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.IntValue = Int32.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.NvarcharValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
}
else if (inputTypeID == 2)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.TextValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.DateValue = DateTime.Parse(attribValue);
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 4)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.BooleanValue = (attribValue == "1" ||
attribValue.ToLower() == "true")
? true
: false;
}
else
{
categoryAttribute.BooleanValue = false;
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 5 || inputTypeID == 6 || inputTypeID == 9 || inputTypeID == 10 ||
inputTypeID == 11 || inputTypeID == 12)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.OptionValues = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 7)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.DecimalValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 8)
{
if (imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(attribValue) && attribValue.ToLower() != "undefined")
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
if (attribValue != imageVar)
{
imageVar = imageVar.Replace("/", "\\");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,
categoryObj.LargeThumbNailImageSize,
categoryObj.MediumImageSize,
categoryObj.SmallImageSize,
@"Modules\AspxCommerce\AspxCategoryManagement\uploads\",
categoryObj.CategoryId, "cat_");
categoryAttribute.FileValue = attribValue;
}
//else if (_imageVar == "")
//{
// categoryAttribute.FileValue = _imageVar;
//}
else
{
categoryAttribute.FileValue = attribValue;
}
}
imageCounterFirst++;
}
if (toInsertIntoDB)
{
listCategoryAttributes.Add(categoryAttribute);
}
}
}
if (isFormValid)
{
string attributeIDs = "1,2,3,9,10,11,12,16,17,18,19,20,21,22,36";
catID = AspxCategoryManageProvider.CategoryAddUpdate(categoryInfo,
listCategoryAttributes, aspxCommonObj.UserName,
aspxCommonObj.CultureName, attributeIDs);
}
else
{
throw new Exception("Form is not valid one");
}
return(catID);
}
catch (Exception e)
{
throw e;
}
}
public int SaveItemAndAttributes(ItemsInfo.ItemSaveBasicInfo itemObj, AspxCommonInfo aspxCommonObj)
{
try
{
string uplodedDownlodableFormValue = string.Empty;
if (itemObj.ItemTypeId == 2 && itemObj.DownloadItemsValue != "")
{
FileHelperController downLoadableObj = new FileHelperController();
string tempFolder = @"Upload\temp";
uplodedDownlodableFormValue = downLoadableObj.MoveFileToDownlodableItemFolder(tempFolder,
itemObj.DownloadItemsValue,
@"Modules/AspxCommerce/AspxItemsManagement/DownloadableItems/",
itemObj.ItemId, "item_");
itemObj.DownloadItemsValue = uplodedDownlodableFormValue;
}
int itemID = AspxItemMgntController.SaveUpdateItemAndAttributes(itemObj, aspxCommonObj);
//kit produtct
if (itemObj.ItemTypeId == 6)
{
AspxKitController _kitCtl = new AspxKitController();
_kitCtl.SaveKits(itemObj.KitConfig, itemID, aspxCommonObj);
}
//return "({\"returnStatus\":1,\"Message\":'Item saved successfully.'})";
int storeId = aspxCommonObj.StoreID;
int portalId = aspxCommonObj.PortalID;
string culture = aspxCommonObj.CultureName;
// if (itemID > 0 && sourceFileCol != "" && dataCollection != "")
if (itemID > 0 && itemObj.SourceFileCol != "" && itemObj.DataCollection != "")
{
StoreSettingConfig ssc = new StoreSettingConfig();
int itemLargeThumbNailHeight = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageHeight, storeId, portalId, culture));
int itemLargeThumbNailWidth = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageWidth, storeId, portalId, culture));
int itemMediumThumbNailHeight = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageHeight, storeId, portalId, culture));
int itemMediumThumbNailWidth = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageWidth, storeId, portalId, culture));
int itemSmallThumbNailHeight = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageHeight, storeId, portalId, culture));
int itemSmallThumbNailWidth = Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageWidth, storeId, portalId, culture));
var dataCollection = itemObj.DataCollection;
dataCollection = dataCollection.Replace("../", "");
SaveImageContents(itemID, @"Modules/AspxCommerce/AspxItemsManagement/uploads/", itemObj.SourceFileCol,
dataCollection, itemLargeThumbNailHeight, itemLargeThumbNailWidth, itemMediumThumbNailHeight, itemMediumThumbNailWidth,
itemSmallThumbNailHeight, itemSmallThumbNailWidth, "item_", aspxCommonObj.CultureName, aspxCommonObj.PortalID);
}
else if (itemID > 0 && itemObj.SourceFileCol == "" && itemObj.DataCollection == "")
{
DeleteImageContents(itemID);
}
return itemID;
//if (itemID == 0)
//{
// //SaveImageContents(itemID, @"Modules/AspxCommerce/AspxItemsManagement/uploads/", sourceFileCol, dataCollection, "item_");
// //TODO:: DELTE UPLOADED FILE FROM DOWNLOAD FOLDER
//}
}
catch (Exception ex)
{
throw ex;
//ErrorHandler errHandler = new ErrorHandler();
//if (errHandler.LogWCFException(ex))
//{
// return "({\"returnStatus\":-1,\"errorMessage\":'" + ex.Message + "'})";
//}
//else
//{
// return "({\"returnStatus\":-1,\"errorMessage\":'Error while saving item!'})";
//}
}
}
public int SaveUpdateItemAndAttributes(ItemsInfo.ItemSaveBasicInfo itemObj, AspxCommonInfo aspxCommonObj)
{
bool isModified = false;
bool updateFlag = false;
int storeId = aspxCommonObj.StoreID;
int portalId = aspxCommonObj.PortalID;
string culture = aspxCommonObj.CultureName;
string userName = aspxCommonObj.UserName;
if (itemObj.ItemId > 0)
{
isModified = true;
updateFlag = true;
}
StoreSettingConfig ssc = new StoreSettingConfig();
int itemLargeThumbNailHeight =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageHeight, storeId, portalId, culture));
int itemLargeThumbNailWidth =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageWidth, storeId, portalId, culture));
int itemMediumThumbNailHeight =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageHeight, storeId, portalId, culture));
int itemMediumThumbNailWidth =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageWidth, storeId, portalId, culture));
int itemSmallThumbNailHeight =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageHeight, storeId, portalId, culture));
int itemSmallThumbNailWidth =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageWidth, storeId, portalId, culture));
int _attributeID = 0;
int _inputTypeID = 0;
int _ValidationTypeID = 8;
int _attributeSetGroupID = 0;
bool _isIncludeInPriceRule = false;
bool _isIncludeInPromotions = false;
int _displayOrder = 0;
string sku = "";
string activeFrom = "";
string activeTo = "";
string hidePrice = "";
string isHideInRSS = "";
string isHideToAnonymous = "";
bool toInsertIntoDB = true;
bool isFormValid = true;
string imageVar = string.Empty;
int imageCounterFirst = 0;
ItemsManagementSqlProvider obj = new ItemsManagementSqlProvider();
var formVars = JSONHelper.Deserialise<List<AspxNameValue>>(itemObj.FormVars);
// for (int i = 0; i < formVars.Length; i++)
for (int i = 0; i < formVars.Count; i++)
{
string attribValue = formVars[i].value;
//string jsonResult = formVars[i].name.Replace('%', '_');
string jsonResult = formVars[i].name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
FormValidation formValidation = new FormValidation();
if (jsonVar.Length > 1)
{
_attributeID = Int32.Parse(jsonVar[0]);
_inputTypeID = Int32.Parse(jsonVar[1]);
_ValidationTypeID = Int32.Parse(jsonVar[2]);
_attributeSetGroupID = Int32.Parse(jsonVar[4]);
_isIncludeInPriceRule = bool.Parse(jsonVar[5]);
_isIncludeInPromotions = bool.Parse(jsonVar[6]);
_displayOrder = Int32.Parse(jsonVar[7]);
//Save To Database 1. [aspx_Items] 2. Others
if (_attributeID == 4)
{
sku = formVars[i].value;
}
else if (_attributeID == 22)
{
activeFrom = formVars[i].value;
}
else if (_attributeID == 23)
{
activeTo = formVars[i].value;
}
else if (_attributeID == 26)
{
hidePrice = formVars[i].value;
}
else if (_attributeID == 27)
{
isHideInRSS = formVars[i].value;
}
else if (_attributeID == 28)
{
isHideToAnonymous = formVars[i].value;
}
if (itemObj.ItemId == 0 && updateFlag == false)
{
itemObj.ItemId = obj.AddItem(itemObj, aspxCommonObj, true, isModified, sku, activeFrom, activeTo,
hidePrice, isHideInRSS, isHideToAnonymous, updateFlag);
}
else if (itemObj.ItemId > 0 && i == (formVars.Count - 1))
{
itemObj.ItemId = obj.AddItem(itemObj, aspxCommonObj, true, isModified, sku, activeFrom, activeTo,
hidePrice, isHideInRSS, isHideToAnonymous, updateFlag);
}
if (itemObj.ItemId > 0)
{
if (_inputTypeID == 1)
{
if (_ValidationTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_ValidationTypeID == 5)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
}
else if (_inputTypeID == 2)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(formVars[i].value))
{
attribValue = formVars[i].value;
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 4)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(formVars[i].value))
{
attribValue = formVars[i].value;
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 5 || _inputTypeID == 6 || _inputTypeID == 9 || _inputTypeID == 10 ||
_inputTypeID == 11 || _inputTypeID == 12)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 7)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
attribValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 8)
{
if (imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(formVars[i].value) &&
formVars[i].value.ToLower() != "undefined")
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID,
formVars[i].value))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
if (attribValue != imageVar)
{
//_imageVar = _imageVar.Replace("../", "");
imageVar = imageVar.Replace("/", "\\");
//attribValue = attribValue.Replace("../", "");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,
itemLargeThumbNailHeight,
itemLargeThumbNailWidth,
itemMediumThumbNailHeight,
itemMediumThumbNailWidth,
itemSmallThumbNailHeight,
itemSmallThumbNailWidth,
@"Modules\AspxCommerce\AspxItemsManagement\uploads\",
itemObj.ItemId, "item_");
}
}
imageCounterFirst++;
}
}
if (isFormValid && toInsertIntoDB)
{
obj.SaveUpdateItemAttributes(itemObj.ItemId, itemObj.AttributeSetId, aspxCommonObj, true,
isModified,
attribValue,
_attributeID, _inputTypeID, _ValidationTypeID, _attributeSetGroupID,
_isIncludeInPriceRule, _isIncludeInPromotions,
_displayOrder);
}
}
}
if (itemObj.ItemTypeId == 1 || itemObj.ItemTypeId == 2)
{
obj.InsertBrandMapping(itemObj.ItemId, itemObj.BrandId, storeId, portalId, userName, culture);
}
if (itemObj.ItemVideoIDs != "" || updateFlag == true)
obj.InsertAndUpdateItemVideos(itemObj.ItemId, itemObj.ItemVideoIDs, aspxCommonObj);
return itemObj.ItemId;
}
public static int SaveUpdateItemAndAttributes(ItemsInfo.ItemSaveBasicInfo itemObj, AspxCommonInfo aspxCommonObj)
{
bool isModified = false;
bool updateFlag = false;
int storeId = aspxCommonObj.StoreID;
int portalId = aspxCommonObj.PortalID;
string culture = aspxCommonObj.CultureName;
string userName = aspxCommonObj.UserName;
if (itemObj.ItemId > 0)
{
isModified = true;
updateFlag = true;
}
StoreSettingConfig ssc = new StoreSettingConfig();
int itemLargeThumbNailSize =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemLargeThumbnailImageSize, storeId, portalId,
culture));
int itemMediumThumbNailSize =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemMediumThumbnailImageSize, storeId, portalId,
culture));
int itemSmallThumbNailSize =
Convert.ToInt32(ssc.GetStoreSettingsByKey(StoreSetting.ItemSmallThumbnailImageSize, storeId, portalId,
culture));
int _attributeID = 0;
int _inputTypeID = 0;
int _ValidationTypeID = 8;
int _GroupID = 0;
bool _isIncludeInPriceRule = false;
int _displayOrder = 0;
bool toInsertIntoDB = true;
bool isFormValid = true;
string imageVar = string.Empty;
int imageCounterFirst = 0;
var formVars = JSONHelper.Deserialise <List <AspxNameValue> >(itemObj.FormVars);
ItemInformationDetailsInfo itemInfo = new ItemInformationDetailsInfo();
itemInfo.NewFromDate = "1900/01/01";
itemInfo.NewToDate = "2999/12/30";
itemInfo.FeaturedFrom = "1900/01/01";
itemInfo.FeaturedTo = "2999/12/30";
itemInfo.SpecialFrom = "1900/01/01";
itemInfo.SpecialTo = "2999/12/30";
List <ItemAttributeDetailsInfo> listItemAttributes = new List <ItemAttributeDetailsInfo>();
bool hasSystemAttributesOnly = true;
string attributeIDs = "1,2,3,4,5,6,7,8,9,10,11,13,14,15,19,20,23,24,25,26,27,28,29,30,31,32,33,34";
for (int i = 0; i < formVars.Count; i++)
{
string attribValue = formVars[i].value;
//string jsonResult = formVars[i].name.Replace('%', '_');
string jsonResult = formVars[i].name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
FormValidation formValidation = new FormValidation();
ItemAttributeDetailsInfo itemAttribute = new ItemAttributeDetailsInfo();
if (jsonVar.Length > 1)
{
_attributeID = Int32.Parse(jsonVar[0]);
_inputTypeID = Int32.Parse(jsonVar[1]);
_ValidationTypeID = Int32.Parse(jsonVar[2]);
_GroupID = Int32.Parse(jsonVar[4]);
_isIncludeInPriceRule = bool.Parse(jsonVar[5]);
_displayOrder = Int32.Parse(jsonVar[6]);
itemAttribute.AttributeID = _attributeID;
itemAttribute.InputTypeID = _inputTypeID;
itemAttribute.ValidationTypeID = _ValidationTypeID;
itemAttribute.GroupID = _GroupID;
itemAttribute.IsIncludeInPriceRule = _isIncludeInPriceRule;
itemAttribute.DisplayOrder = _displayOrder;
if (_attributeID > 43)
{
if (hasSystemAttributesOnly)
{
hasSystemAttributesOnly = false;
}
}
if (_attributeID == 4)
{
itemInfo.SKU = formVars[i].value;
}
else if (_attributeID == 19)
{
itemInfo.ActiveFrom = formVars[i].value;
}
else if (_attributeID == 20)
{
itemInfo.ActiveTo = formVars[i].value;
}
else if (_attributeID == 23)
{
itemInfo.HidePrice = Convert.ToBoolean(formVars[i].value);
}
else if (_attributeID == 24)
{
itemInfo.HideInRSSFeed = Convert.ToBoolean(formVars[i].value);
}
else if (_attributeID == 25)
{
itemInfo.HideToAnonymous = Convert.ToBoolean(formVars[i].value);
}
else if (_attributeID == 1)
{
itemInfo.Name = formVars[i].value;
}
else if (_attributeID == 2)
{
itemInfo.Description = formVars[i].value;
}
else if (_attributeID == 3)
{
itemInfo.ShortDescription = formVars[i].value;
}
else if (_attributeID == 5)
{
itemInfo.Weight = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 6)
{
itemInfo.NewFromDate = formVars[i].value;
}
else if (_attributeID == 7)
{
itemInfo.NewToDate = formVars[i].value;
}
else if (_attributeID == 8)
{
itemInfo.Price = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 9)
{
itemInfo.MetaTitle = formVars[i].value;
}
else if (_attributeID == 10)
{
itemInfo.MetaKeyword = formVars[i].value;
}
else if (_attributeID == 11)
{
itemInfo.MetaDescription = formVars[i].value;
}
else if (_attributeID == 13 && formVars[i].value != "")
{
itemInfo.ListPrice = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 14)
{
itemInfo.VisibilityOptionValueID = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 15)
{
itemInfo.Quantity = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 26)
{
itemInfo.IsFeaturedOptionValueID = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 27)
{
itemInfo.FeaturedFrom = formVars[i].value;
}
else if (_attributeID == 28)
{
itemInfo.FeaturedTo = formVars[i].value;
}
else if (_attributeID == 29)
{
itemInfo.IsSpecialOptionValueID = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 30)
{
itemInfo.SpecialFrom = formVars[i].value;
}
else if (_attributeID == 31)
{
itemInfo.SpecialTo = formVars[i].value;
}
else if (_attributeID == 32)
{
itemInfo.Length = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 33)
{
itemInfo.Height = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 34)
{
itemInfo.Width = Convert.ToDecimal(formVars[i].value);
}
else if (_attributeID == 35)
{
itemInfo.IsPromo = Convert.ToInt32(formVars[i].value);
}
else if (_attributeID == 37)
{
itemInfo.ServiceDuration = Convert.ToInt32(formVars[i].value);
}
}
if (_attributeID == 37)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.IntValue = int.Parse(formVars[i].value);
listItemAttributes.Add(itemAttribute);
}
else
{
isFormValid = false;
break;
}
}
else if (_attributeID == 35)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.OptionValues = formVars[i].value;
listItemAttributes.Add(itemAttribute);
}
else
{
isFormValid = false;
break;
}
}
if (_attributeID > 43)
{
if (_inputTypeID == 1)
{
if (_ValidationTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.DecimalValue = decimal.Parse(formVars[i].value);
}
else
{
isFormValid = false;
break;
}
}
else if (_ValidationTypeID == 5)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.IntValue = int.Parse(formVars[i].value);
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.NvarcharValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
}
else if (_inputTypeID == 2)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.TextValue = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 3)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(formVars[i].value))
{
itemAttribute.DateValue = DateTime.Parse(formVars[i].value);
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 4)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
if (!string.IsNullOrEmpty(attribValue))
{
itemAttribute.BooleanValue = (formVars[i].value == "1" ||
formVars[i].value.ToLower() == "true")
? true
: false;
}
else
{
itemAttribute.BooleanValue = false;
}
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 5 || _inputTypeID == 6 || _inputTypeID == 9 || _inputTypeID == 10 ||
_inputTypeID == 11 || _inputTypeID == 12)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.OptionValues = formVars[i].value;
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 7)
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID, formVars[i].value))
{
itemAttribute.DecimalValue = decimal.Parse(formVars[i].value);
}
else
{
isFormValid = false;
break;
}
}
else if (_inputTypeID == 8)
{
if (imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(formVars[i].value) &&
formVars[i].value.ToLower() != "undefined")
{
if (formValidation.ValidateValue(formVars[i].name, _ValidationTypeID,
formVars[i].value))
{
imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
imageVar = "";
}
}
else
{
toInsertIntoDB = true;
if (attribValue != imageVar)
{
//_imageVar = _imageVar.Replace("../", "");
imageVar = imageVar.Replace("/", "\\");
//attribValue = attribValue.Replace("../", "");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, imageVar,
itemLargeThumbNailSize,
itemMediumThumbNailSize,
itemSmallThumbNailSize,
@"Modules\AspxCommerce\AspxItemsManagement\uploads\",
itemObj.ItemId, "item_");
itemAttribute.FileValue =
attribValue.Replace(@"Modules\AspxCommerce\AspxItemsManagement\uploads\", " ");
}
else
{
itemAttribute.FileValue =
attribValue.Replace(@"Modules\AspxCommerce\AspxItemsManagement\uploads\", " ");
}
}
imageCounterFirst++;
}
if (toInsertIntoDB)
{
listItemAttributes.Add(itemAttribute);
}
}
}
if (isFormValid)
{
itemObj.ItemId = AspxItemMgntProvider.SaveUpdateItemAttributes(itemObj, aspxCommonObj, true,
isModified, itemInfo,
listItemAttributes, attributeIDs,
hasSystemAttributesOnly, updateFlag);
}
else
{
throw new Exception("Form is not valid one");
}
return(itemObj.ItemId);
}
