private static void SaveDynamicMethods(ShippingProvider provider, int providerId, AspxCommonInfo commonInfo)
{
foreach (var dynamicMethod in provider.DynamicMethods)
{
try
{
List <KeyValuePair <string, object> > paraMeter = new List <KeyValuePair <string, object> >();
paraMeter.Add(new KeyValuePair <string, object>("ShippingProviderId", providerId));
paraMeter.Add(new KeyValuePair <string, object>("AssemblyName", provider.AssemblyName));
paraMeter.Add(new KeyValuePair <string, object>("ClassName", provider.ShippingProviderClass));
paraMeter.Add(new KeyValuePair <string, object>("NameSpace", provider.ShippingProviderNamespace));
paraMeter.Add(new KeyValuePair <string, object>("MethodName", dynamicMethod.MethodName));
paraMeter.Add(new KeyValuePair <string, object>("MethodType", dynamicMethod.MethodType));
paraMeter.Add(new KeyValuePair <string, object>("ParameterCount",
dynamicMethod.DynamicParams.Count()));
paraMeter.Add(new KeyValuePair <string, object>("StoreId", commonInfo.StoreID));
paraMeter.Add(new KeyValuePair <string, object>("PortalId", commonInfo.PortalID));
paraMeter.Add(new KeyValuePair <string, object>("UserName", commonInfo.UserName));
OracleHandler sqLh = new OracleHandler();
int dynamicmId = sqLh.ExecuteAsScalar <int>("usp_aspx_AddDynamicMethod", paraMeter);
SaveDynamicMethodParams(dynamicMethod.DynamicParams, dynamicmId, commonInfo);
}
catch (Exception ex)
{
throw ex;
}
}
}
public static void ShippingProviderAddUpdate(List <ShippingMethod> methods,
ShippingProvider provider, bool isAddedZip, AspxCommonInfo aspxCommonObj)
{
try
{
AspxShipProviderMgntProvider.ShippingProviderAddUpdate(methods, provider, isAddedZip, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
public int SaveUpdateProviderSetting(ShippingProvider provider, string settingKey, string settingValue, AspxCommonInfo commonInfo)
{
try
{
int providerID = AspxShipProviderMgntProvider.SaveUpdateProviderSetting(provider, settingKey, settingValue, commonInfo);
return(providerID);
}
catch (Exception e)
{
throw e;
}
}
public static int SaveUpdateProviderSetting(ShippingProvider provider, string settingKey, string settingValue, AspxCommonInfo commonInfo)
{
try
{
if (!provider.IsUnique)
{
DeleteShippingProvider(provider.ShippingProviderID, commonInfo);
}
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("ShippingProviderID", 0));
parameter.Add(new KeyValuePair <string, object>("StoreID", commonInfo.StoreID));
parameter.Add(new KeyValuePair <string, object>("PortalID", commonInfo.PortalID));
parameter.Add(new KeyValuePair <string, object>("CultureName", commonInfo.CultureName));
parameter.Add(new KeyValuePair <string, object>("UserName", commonInfo.UserName));
parameter.Add(new KeyValuePair <string, object>("ShippingProviderServiceCode",
provider.ShippingProviderServiceCode));
parameter.Add(new KeyValuePair <string, object>("ShippingProviderName", provider.ShippingProviderName));
parameter.Add(new KeyValuePair <string, object>("ShippingProviderAliasHelp",
provider.ShippingProviderAliasHelp));
parameter.Add(new KeyValuePair <string, object>("AssemblyName", provider.AssemblyName));
parameter.Add(new KeyValuePair <string, object>("Namespace", provider.ShippingProviderNamespace));
parameter.Add(new KeyValuePair <string, object>("Class", provider.ShippingProviderClass));
parameter.Add(new KeyValuePair <string, object>("SettingControlSrc", provider.SettingControlPath));
parameter.Add(new KeyValuePair <string, object>("LabelControlSrc", provider.LabelControlPath));
parameter.Add(new KeyValuePair <string, object>("TrackControlSrc", provider.TrackControlPath));
parameter.Add(new KeyValuePair <string, object>("IsActive", provider.IsActive));
parameter.Add(new KeyValuePair <string, object>("IsAddedZipFlag", true));
OracleHandler sqlH = new OracleHandler();
int providerId = sqlH.ExecuteAsScalar <int>("usp_Aspx_ShippingProviderAddUpdate", parameter);
SaveSetting(providerId, settingKey, settingValue, commonInfo);
SaveDynamicMethods(provider, providerId, commonInfo);
ExtractFile(provider);
return(providerId);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ProviderShippingMethod> GetProviderRemainingMethod(int shippingProviderId, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > paramCol = new List <KeyValuePair <string, object> >();
paramCol.Add(new KeyValuePair <string, object>("ShippingProviderId", shippingProviderId));
paramCol.Add(new KeyValuePair <string, object>("StoreId", aspxCommonObj.StoreID));
paramCol.Add(new KeyValuePair <string, object>("PortalId", aspxCommonObj.PortalID));
OracleHandler sqlHl = new OracleHandler();
ShippingProvider providerInfo = sqlHl.ExecuteAsObject <ShippingProvider>("usp_Aspx_GetProviderAssemblyInfo",
paramCol);
var obj1 =
(Dictionary <string, string>)
DynamicUtility.InvokeMethodAsObject(providerInfo.AssemblyName, providerInfo.ShippingProviderNamespace,
providerInfo.ShippingProviderClass, "GetAvailableServiceMethod");
List <ShippingMethodInfo> storeMethod = AspxShipMethodMgntController.GetStoreProvidersAvailableMethod(shippingProviderId, aspxCommonObj);
var services = obj1.Select(method => new ProviderShippingMethod()
{
ShippingMethodCode = method.Key,
ShippingMethodName = method.Value
}).ToList();
var filterdmethods = new List <ProviderShippingMethod>();
foreach (ShippingMethodInfo shippingMethod in storeMethod)
{
foreach (var providerShippingMethod in services)
{
if (providerShippingMethod.ShippingMethodName == shippingMethod.ShippingMethodName)
{
services.Remove(providerShippingMethod);
break;
}
}
}
return(services);
}
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 static void ShippingProviderAddUpdate(List<ShippingMethod> methods,
ShippingProvider provider, bool isAddedZip, AspxCommonInfo aspxCommonObj)
{
try
{
if (!isAddedZip)
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ShippingProviderID", provider.ShippingProviderID));
parameter.Add(new KeyValuePair<string, object>("@ShippingProviderServiceCode",
provider.ShippingProviderServiceCode));
parameter.Add(new KeyValuePair<string, object>("@ShippingProviderName", provider.ShippingProviderName));
parameter.Add(new KeyValuePair<string, object>("@ShippingProviderAliasHelp",
provider.ShippingProviderAliasHelp));
parameter.Add(new KeyValuePair<string, object>("@AssemblyName", null));
parameter.Add(new KeyValuePair<string, object>("@Namespace", null));
parameter.Add(new KeyValuePair<string, object>("@Class", null));
parameter.Add(new KeyValuePair<string, object>("@SettingControlSrc", null));
parameter.Add(new KeyValuePair<string, object>("@IsActive", provider.IsActive));
parameter.Add(new KeyValuePair<string, object>("@IsAddedZipFlag", false));
SQLHandler sqlH = new SQLHandler();
int id = sqlH.ExecuteAsScalar<int>("[dbo].[usp_Aspx_ShippingProviderAddUpdate]", parameter);
//add providers provided shipping methods/services
List<KeyValuePair<string, object>> param = new List<KeyValuePair<string, object>>();
param.Add(new KeyValuePair<string, object>("@StoreId", aspxCommonObj.StoreID));
param.Add(new KeyValuePair<string, object>("@PortalId", aspxCommonObj.PortalID));
int displayorder = sqlH.ExecuteAsScalar<int>("[dbo].[usp_Aspx_GetDisplayOrderForShippingMethod]", param);
if (methods != null)
{
if (provider.ShippingProviderID != 0)
{
foreach (ShippingMethod method in methods)
{
displayorder++;
List<KeyValuePair<string, object>> parameterz = new List<KeyValuePair<string, object>>();
parameterz.Add(new KeyValuePair<string, object>("@ShippingMethodName",
method.ShippingMethodName));
parameterz.Add(new KeyValuePair<string, object>("@ShippingMethodCode",
method.ShippingMethodCode));
parameterz.Add(new KeyValuePair<string, object>("@ImagePath", ""));
parameterz.Add(new KeyValuePair<string, object>("@AlternateText",
method.AlternateText));
parameterz.Add(new KeyValuePair<string, object>("@DisplayOrder", displayorder));
parameterz.Add(new KeyValuePair<string, object>("@DeliveryTime",
method.DeliveryTime));
parameterz.Add(new KeyValuePair<string, object>("@WeightLimitFrom",
method.WeightLimitFrom));
parameterz.Add(new KeyValuePair<string, object>("@WeightLimitTo",
method.WeightLimitTo));
parameterz.Add(new KeyValuePair<string, object>("@ShippingProviderID",
provider.ShippingProviderID));
parameterz.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameterz.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameterz.Add(new KeyValuePair<string, object>("@IsActive", method.IsActive));
parameterz.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
parameterz.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
sqlH.ExecuteNonQuery("usp_Aspx_AddProvidersShippingMethod", parameterz);
}
}
}
}
else
{
//add providers provided shipping methods/services
int displayorder = 0;
if (provider.ShippingProviderID != 0)
{
foreach (ShippingMethod method in methods)
{
displayorder++;
List<KeyValuePair<string, object>> parameterz = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterz.Add(new KeyValuePair<string, object>("@ShippingMethodName",
method.ShippingMethodName));
parameterz.Add(new KeyValuePair<string, object>("@ShippingMethodCode",
method.ShippingMethodCode));
parameterz.Add(new KeyValuePair<string, object>("@ImagePath", ""));
parameterz.Add(new KeyValuePair<string, object>("@AlternateText", method.AlternateText));
parameterz.Add(new KeyValuePair<string, object>("@DisplayOrder", displayorder));
parameterz.Add(new KeyValuePair<string, object>("@DeliveryTime", method.DeliveryTime));
parameterz.Add(new KeyValuePair<string, object>("@WeightLimitFrom", provider.MinWeight));
parameterz.Add(new KeyValuePair<string, object>("@WeightLimitTo", provider.MaxWeight));
parameterz.Add(new KeyValuePair<string, object>("@ShippingProviderID",
provider.ShippingProviderID));
parameterz.Add(new KeyValuePair<string, object>("@IsActive", method.IsActive));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddProvidersShippingMethod", parameterz);
}
}
}
}
catch (Exception e)
{
throw e;
}
}
private static void SaveDynamicMethods(ShippingProvider provider, int providerId, AspxCommonInfo commonInfo)
{
foreach (var dynamicMethod in provider.DynamicMethods)
{
try
{
List<KeyValuePair<string, object>> paraMeter = new List<KeyValuePair<string, object>>();
paraMeter.Add(new KeyValuePair<string, object>("@ShippingProviderId", providerId));
paraMeter.Add(new KeyValuePair<string, object>("@AssemblyName", provider.AssemblyName));
paraMeter.Add(new KeyValuePair<string, object>("@ClassName", provider.ShippingProviderClass));
paraMeter.Add(new KeyValuePair<string, object>("@NameSpace", provider.ShippingProviderNamespace));
paraMeter.Add(new KeyValuePair<string, object>("@MethodName", dynamicMethod.MethodName));
paraMeter.Add(new KeyValuePair<string, object>("@MethodType", dynamicMethod.MethodType));
paraMeter.Add(new KeyValuePair<string, object>("@ParameterCount",
dynamicMethod.DynamicParams.Count()));
paraMeter.Add(new KeyValuePair<string, object>("@StoreId", commonInfo.StoreID));
paraMeter.Add(new KeyValuePair<string, object>("@PortalId", commonInfo.PortalID));
paraMeter.Add(new KeyValuePair<string, object>("@UserName", commonInfo.UserName));
SQLHandler sqLh = new SQLHandler();
int dynamicmId = sqLh.ExecuteAsScalar<int>("usp_aspx_AddDynamicMethod", paraMeter);
SaveDynamicMethodParams(dynamicMethod.DynamicParams, dynamicmId,commonInfo);
}
catch (Exception ex)
{
throw ex;
}
}
}
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 static int SaveUpdateProviderSetting(ShippingProvider provider, string settingKey, string settingValue, AspxCommonInfo commonInfo)
{
try
{
if (!provider.IsUnique)
{
DeleteShippingProvider(provider.ShippingProviderID, commonInfo);
}
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@ShippingProviderID", 0));
parameter.Add(new KeyValuePair<string, object>("@StoreID", commonInfo.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", commonInfo.PortalID));
parameter.Add(new KeyValuePair<string, object>("@CultureName", commonInfo.CultureName));
parameter.Add(new KeyValuePair<string, object>("@UserName", commonInfo.UserName));
parameter.Add(new KeyValuePair<string, object>("@ShippingProviderServiceCode",
provider.ShippingProviderServiceCode));
parameter.Add(new KeyValuePair<string, object>("@ShippingProviderName", provider.ShippingProviderName));
parameter.Add(new KeyValuePair<string, object>("@ShippingProviderAliasHelp",
provider.ShippingProviderAliasHelp));
parameter.Add(new KeyValuePair<string, object>("@AssemblyName", provider.AssemblyName));
parameter.Add(new KeyValuePair<string, object>("@Namespace", provider.ShippingProviderNamespace));
parameter.Add(new KeyValuePair<string, object>("@Class", provider.ShippingProviderClass));
parameter.Add(new KeyValuePair<string, object>("@SettingControlSrc", provider.SettingControlPath));
parameter.Add(new KeyValuePair<string, object>("@LabelControlSrc", provider.LabelControlPath));
parameter.Add(new KeyValuePair<string, object>("@TrackControlSrc", provider.TrackControlPath));
parameter.Add(new KeyValuePair<string, object>("@IsActive", provider.IsActive));
parameter.Add(new KeyValuePair<string, object>("@IsAddedZipFlag", true));
SQLHandler sqlH = new SQLHandler();
int providerId = sqlH.ExecuteAsScalar<int>("[dbo].[usp_Aspx_ShippingProviderAddUpdate]", parameter);
SaveSetting(providerId, settingKey, settingValue, commonInfo);
SaveDynamicMethods(provider, providerId, commonInfo);
ExtractFile(provider);
return providerId;
}
catch (Exception ex)
{
throw ex;
}
}
public void ShippingProviderAddUpdate(List<ShippingMethod> methods,
ShippingProvider provider, bool isAddedZip, AspxCommonInfo aspxCommonObj)
{
try
{
AspxShipProviderMgntController.ShippingProviderAddUpdate(methods, provider, isAddedZip, aspxCommonObj);
}
catch (Exception ex)
{
throw ex;
}
}
private void UninstallShippingProvider(ShippingProvider provider)
{
string path = HttpContext.Current.Server.MapPath("~/");
DeleteAllDllsFromBin(provider.DllFiles);
}
private int Step1CheckLogic(string tempUnzippedPath, ShippingProvider provider)
{
if (CheckFormanifestFile(tempUnzippedPath, provider) != "")
{
var doc = new XmlDocument();
doc.Load(tempUnzippedPath + '\\' + provider.ManifestFile);
XmlElement root = doc.DocumentElement;
if (CheckValidManifestFile(root))
{
XmlNodeList xnList3 = doc.SelectNodes("sageframe/folders/folder/files/file");
if (xnList3.Count != 0)
{var dlls=new ArrayList();
foreach (XmlNode xn3 in xnList3)
{
string fileName = xn3["name"].InnerXml;
try
{
#region CheckValidDataSqlProvider
if (!String.IsNullOrEmpty(fileName) &&
fileName.Contains("1.00.00.SqlDataProvider"))
{
provider.InstallScript = fileName;
}
#endregion
#region CheckAlldllFiles
if (!String.IsNullOrEmpty(fileName) && fileName.Contains(".dll"))
{
dlls.Add(fileName);
_provider.DllFiles = dlls;
}
#endregion
#region ReadUninstall SQL FileName
if (!String.IsNullOrEmpty(fileName) && fileName.Contains("Uninstall.SqlDataProvider"))
{
provider.UninstallScript = fileName;
}
#endregion
}
catch
{
break;
}
}
}
XmlNodeList xnList = doc.SelectNodes("sageframe/folders/folder");
foreach (XmlNode xn in xnList)
{
provider.ShippingProviderName = xn["providername"].InnerXml;
provider.ShippingProviderAliasHelp = xn["provideraliashelp"].InnerXml;
provider.ShippingProviderServiceCode = xn["servicecode"].InnerXml;
provider.AssemblyName = xn["assemblyname"].InnerXml;
provider.ShippingProviderNamespace = xn["namespace"].InnerXml;
provider.ShippingProviderClass = xn["class"].InnerXml;
provider.ModuleFolder = "Modules/" + xn["foldername"].InnerXml;
provider.IsActive = true;
if (IsProviderExist(provider.ShippingProviderName,_storeId,_portalId))
{
XmlNodeList settingCtl = doc.SelectNodes("sageframe/folders/folder/modules/module/controls/control");
foreach (XmlNode xn5 in settingCtl)
{
if (xn5["name"].InnerXml.ToLower().Trim() == "setting")
provider.SettingControlPath = xn5["src"].InnerXml;
if (xn5["name"].InnerXml.ToLower().Trim() == "label")
provider.LabelControlPath = xn5["src"].InnerXml;
if (xn5["name"].InnerXml.ToLower().Trim() == "track")
provider.TrackControlPath = xn5["src"].InnerXml;
}
XmlNodeList xnList2 = doc.SelectNodes("sageframe/folders/folder/settings/setting");
foreach (XmlNode xn2 in xnList2)
{
string settingkey = xn2["key"].InnerXml;
string settingvalue = xn2["value"].InnerXml;
_providerSetting.Add(new KeyValuePair<string, string>(settingkey, settingvalue));
}
provider.Settings = _providerSetting;
XmlNodeList methods = doc.SelectNodes("sageframe/folders/folder/dynamicmethods/method");
foreach (XmlNode method in methods)
{
var dymethod = new DynamicMethod();
dymethod.MethodName = method["name"].InnerXml;
dymethod.MethodType = method.Attributes["type"].Value;
var parlist = new List<DynamicParam>();
XmlNodeList parameters= method.SelectNodes("params/param");
if (parameters != null)
{
int parCount = 0;
foreach (XmlNode param in parameters)
{
var pars = new DynamicParam();
parCount++;
pars.ParameterName = param.Attributes["type"].Value;
pars.ParameterType = param.Attributes["objectType"].Value;
pars.ParameterOrder =int.Parse(param.Attributes["order"].Value);
parlist.Add(pars);
}
dymethod.DynamicParams = parlist;
}
_dynamicMethods.Add(dymethod);
}
provider.DynamicMethods = _dynamicMethods;
_provider.SettingControlTempPath = ResolveUrl(this.AppRelativeTemplateSourceDirectory) +
"temp\\extracted\\" +
_provider.SettingControlPath.Split('/').Last();
_provider.SettingControlTempPath = Regex.Replace(_provider.SettingControlTempPath, @"(\\)", @"//");
return 1;//Already exist
}
else
{
XmlNodeList settingCtl = doc.SelectNodes("sageframe/folders/folder/modules/module/controls/control");
foreach (XmlNode xn5 in settingCtl)
{
if (xn5["name"].InnerXml.ToLower().Trim()=="setting")
provider.SettingControlPath = xn5["src"].InnerXml;
if (xn5["name"].InnerXml.ToLower().Trim() == "label")
provider.LabelControlPath = xn5["src"].InnerXml;
if (xn5["name"].InnerXml.ToLower().Trim() == "track")
provider.TrackControlPath = xn5["src"].InnerXml;
}
XmlNodeList xnList2 = doc.SelectNodes("sageframe/folders/folder/settings/setting");
foreach (XmlNode xn2 in xnList2)
{
string settingkey = xn2["key"].InnerXml;
string settingvalue = xn2["value"].InnerXml;
_providerSetting.Add(new KeyValuePair<string, string>(settingkey, settingvalue));
}
provider.Settings = _providerSetting;
XmlNodeList methods = doc.SelectNodes("sageframe/folders/folder/dynamicmethods/method");
foreach (XmlNode method in methods)
{
var dymethod = new DynamicMethod();
dymethod.MethodName = method["name"].InnerXml;
XmlNodeList parameters = method.SelectNodes("params/param");
if (parameters != null)
{
var listParam = new List<DynamicParam>();
int parCount = 0;
foreach (XmlNode param in parameters)
{
var pars = new DynamicParam();
parCount++;
pars.ParameterName = param.Attributes["type"].Value;
pars.ParameterType = param.Attributes["objectType"].Value;
pars.ParameterOrder = int.Parse(param.Attributes["order"].Value);
listParam.Add(pars);
}
dymethod.DynamicParams = listParam;
}
_dynamicMethods.Add(dymethod);
}
provider.DynamicMethods = _dynamicMethods;
_provider.SettingControlTempPath = ResolveUrl(this.AppRelativeTemplateSourceDirectory) +
"temp\\extracted\\" +
_provider.SettingControlPath.Split('/').Last();
_provider.SettingControlTempPath = Regex.Replace(_provider.SettingControlTempPath, @"(\\)", @"//");
return 2;//Not Exists
}
}
}
else
{
return -1;//Invalid Manifest file
}
}
return 0;//No manifest file
}
private string CheckFormanifestFile(string tempUnzippedPath, ShippingProvider provider)
{
DirectoryInfo dir = new DirectoryInfo(tempUnzippedPath);
foreach (FileInfo f in dir.GetFiles("*.*"))
{
if (f.Extension.ToLower() == ".sfe")
{
provider.ManifestFile = f.Name;
return provider.ManifestFile;
}
else
{
provider.ManifestFile = "";
}
}
return provider.ManifestFile;
}
public static void ShippingProviderAddUpdate(List <ShippingMethod> methods,
ShippingProvider provider, bool isAddedZip, AspxCommonInfo aspxCommonObj)
{
try
{
if (!isAddedZip)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ShippingProviderID", provider.ShippingProviderID));
parameter.Add(new KeyValuePair <string, object>("ShippingProviderServiceCode",
provider.ShippingProviderServiceCode));
parameter.Add(new KeyValuePair <string, object>("ShippingProviderName", provider.ShippingProviderName));
parameter.Add(new KeyValuePair <string, object>("ShippingProviderAliasHelp",
provider.ShippingProviderAliasHelp));
parameter.Add(new KeyValuePair <string, object>("AssemblyName", null));
parameter.Add(new KeyValuePair <string, object>("Namespace", null));
parameter.Add(new KeyValuePair <string, object>("Class", null));
parameter.Add(new KeyValuePair <string, object>("SettingControlSrc", null));
parameter.Add(new KeyValuePair <string, object>("IsActive", provider.IsActive));
parameter.Add(new KeyValuePair <string, object>("IsAddedZipFlag", false));
OracleHandler sqlH = new OracleHandler();
int id = sqlH.ExecuteAsScalar <int>("usp_Aspx_ShippingProviderAddUpdate", parameter);
//add providers provided shipping methods/services
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("StoreId", aspxCommonObj.StoreID));
param.Add(new KeyValuePair <string, object>("PortalId", aspxCommonObj.PortalID));
int displayorder = sqlH.ExecuteAsScalar <int>("usp_Aspx_GetDisplayOrderForShippingMethod", param);
if (methods != null)
{
if (provider.ShippingProviderID != 0)
{
foreach (ShippingMethod method in methods)
{
displayorder++;
List <KeyValuePair <string, object> > parameterz = new List <KeyValuePair <string, object> >();
parameterz.Add(new KeyValuePair <string, object>("ShippingMethodName",
method.ShippingMethodName));
parameterz.Add(new KeyValuePair <string, object>("ShippingMethodCode",
method.ShippingMethodCode));
parameterz.Add(new KeyValuePair <string, object>("ImagePath", ""));
parameterz.Add(new KeyValuePair <string, object>("AlternateText",
method.AlternateText));
parameterz.Add(new KeyValuePair <string, object>("DisplayOrder", displayorder));
parameterz.Add(new KeyValuePair <string, object>("DeliveryTime",
method.DeliveryTime));
parameterz.Add(new KeyValuePair <string, object>("WeightLimitFrom",
method.WeightLimitFrom));
parameterz.Add(new KeyValuePair <string, object>("WeightLimitTo",
method.WeightLimitTo));
parameterz.Add(new KeyValuePair <string, object>("ShippingProviderID",
provider.ShippingProviderID));
parameterz.Add(new KeyValuePair <string, object>("StoreID", aspxCommonObj.StoreID));
parameterz.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
parameterz.Add(new KeyValuePair <string, object>("IsActive", method.IsActive));
parameterz.Add(new KeyValuePair <string, object>("UserName", aspxCommonObj.UserName));
parameterz.Add(new KeyValuePair <string, object>("CultureName", aspxCommonObj.CultureName));
sqlH.ExecuteNonQuery("usp_Aspx_AddProvidersShippingMethod", parameterz);
}
}
}
}
else
{
//add providers provided shipping methods/services
int displayorder = 0;
if (provider.ShippingProviderID != 0)
{
foreach (ShippingMethod method in methods)
{
displayorder++;
List <KeyValuePair <string, object> > parameterz = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterz.Add(new KeyValuePair <string, object>("ShippingMethodName",
method.ShippingMethodName));
parameterz.Add(new KeyValuePair <string, object>("ShippingMethodCode",
method.ShippingMethodCode));
parameterz.Add(new KeyValuePair <string, object>("ImagePath", ""));
parameterz.Add(new KeyValuePair <string, object>("AlternateText", method.AlternateText));
parameterz.Add(new KeyValuePair <string, object>("DisplayOrder", displayorder));
parameterz.Add(new KeyValuePair <string, object>("DeliveryTime", method.DeliveryTime));
parameterz.Add(new KeyValuePair <string, object>("WeightLimitFrom", provider.MinWeight));
parameterz.Add(new KeyValuePair <string, object>("WeightLimitTo", provider.MaxWeight));
parameterz.Add(new KeyValuePair <string, object>("ShippingProviderID",
provider.ShippingProviderID));
parameterz.Add(new KeyValuePair <string, object>("IsActive", method.IsActive));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddProvidersShippingMethod", parameterz);
}
}
}
}
catch (Exception e)
{
throw e;
}
}