public void DeleteAbandonedCartItems(int storeID, int portalID, decimal timeToDeleteCartItems, decimal timeToAbandonCart)
{
try
{
List <SecurePageInfo> portalRoleCollection = new List <SecurePageInfo>();
OracleHandler sqlH = new OracleHandler();
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>("TimeToDeleteCartItems", timeToDeleteCartItems));
ParaMeter.Add(new KeyValuePair <string, object>("AbandonedCartTime", timeToAbandonCart));
sqlH.ExecuteAsList <SecurePageInfo>("usp_Aspx_DeleteAbandonedCartIt", ParaMeter);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ItemsForPromoInfo> ItemsForPromoCode(int offset, int limit, AspxCommonInfo aspxCommomObj, string itemName, int?couponId)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommomObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("ItemName", itemName));
parameter.Add(new KeyValuePair <string, object>("CouponID", couponId));
OracleHandler sqlh = new OracleHandler();
List <ItemsForPromoInfo> lst = sqlh.ExecuteAsList <ItemsForPromoInfo>("dbo.usp_Aspx_ItemsForPromoCode", parameter);
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UpdateCartAnonymoususertoRegistered(int storeID, int portalID, int customerID, string sessionCode)
{
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>("CustomerID", customerID));
parameter.Add(new KeyValuePair <string, object>("SessionCode", sessionCode));
OracleHandler sqlH = new OracleHandler();
bool isUpdate = sqlH.ExecuteNonQueryAsBool("usp_Aspx_UpdateCartAnonymousUserToRegistered", parameter, "IsUpdate");
return(isUpdate);
}
catch (Exception e)
{
throw e;
}
}
public static void DeleteCategory(Int32 storeID, Int32 portalID, Int32 categoryID, string userName, string culture)
{
try
{
OracleHandler sqlHandler = new OracleHandler();
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("CategoryID", categoryID));
parameterCollection.Add(new KeyValuePair <string, object>("UserName", userName));
parameterCollection.Add(new KeyValuePair <string, object>("StoreID", storeID));
parameterCollection.Add(new KeyValuePair <string, object>("PortalID", portalID));
parameterCollection.Add(new KeyValuePair <string, object>("CultureName", culture));
sqlHandler.ExecuteNonQuery("usp_Aspx_CategoryDelete", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
public static decimal GetCostVariantQuantity(int itemID, int storeID, int portalID, string itemCostVariantIDs)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("ItemID", itemID));
parameter.Add(new KeyValuePair <string, object>("StoreID", storeID));
parameter.Add(new KeyValuePair <string, object>("PortalID", portalID));
parameter.Add(new KeyValuePair <string, object>("ItemCostVariantIDs", itemCostVariantIDs));
OracleHandler sqlH = new OracleHandler();
decimal cvQty = sqlH.ExecuteAsScalar <decimal>("usp_Aspx_GetCostVariantQuantity", parameter);
return(cvQty);
}
catch (Exception e)
{
throw e;
}
}
public static bool CheckOutOfStock(int itemID, int storeID, int portalID, string itemCostVariantIDs)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("ItemID", itemID));
parameter.Add(new KeyValuePair <string, object>("StoreID", storeID));
parameter.Add(new KeyValuePair <string, object>("PortalID", portalID));
parameter.Add(new KeyValuePair <string, object>("ItemCostVariantIDs", itemCostVariantIDs));
OracleHandler sqlH = new OracleHandler();
bool isOutStock = sqlH.ExecuteNonQueryAsGivenType <bool>("[dbo].[usp_Aspx_CheckOutOfStockForCostVariants]", parameter, "IsOutOfStock");
return(isOutStock);
}
catch (Exception e)
{
throw e;
}
}
public static ItemCartInfo CheckItemQuantityInCart(int itemID, AspxCommonInfo aspxCommonObj, string itemCostVariantIDs)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPSCt(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", itemID));
parameter.Add(new KeyValuePair <string, object>("iv_ItemCostVariantIDs", itemCostVariantIDs));
OracleHandler sqlH = new OracleHandler();
ItemCartInfo itemCartObj = sqlH.ExecuteAsObject <ItemCartInfo>("usp_Aspx_CheckCustomerQuantity", parameter);
//ItemCartInfo itemCartObj = sqlH.ExecuteAsObject<ItemCartInfo>("usp_Aspx_CheckCustomerQuantityInCart", parameter);
return(itemCartObj);
}
catch (Exception e)
{
throw e;
}
}
public static List <BreadCrumInfo> GetCategoryName(string name, AspxCommonInfo commonInfo)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("CategoryName", name));
ParaMeterCollection.Add(new KeyValuePair <string, object>("StoreID", commonInfo.StoreID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("PortalID", commonInfo.PortalID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("CultureName", commonInfo.CultureName));
OracleHandler SQLH = new OracleHandler();
return(SQLH.ExecuteAsList <BreadCrumInfo>("usp_Aspx_GetCategoryForBreadCr", ParaMeterCollection));
//return SQLH.ExecuteAsList<BreadCrumInfo>("usp_Aspx_GetCategoryForBreadCrumb", ParaMeterCollection);
}
catch (Exception ex)
{
throw ex;
}
}
public static string GetCategoryForItem(int storeID, int portalID, string itemSku, string cultureName)
{
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>("ItemSku", itemSku));
parameter.Add(new KeyValuePair <string, object>("CultureName", cultureName));
OracleHandler sqlH = new OracleHandler();
string retString = sqlH.ExecuteAsScalar <string>("usp_Aspx_GetCategoryforItems", parameter);
return(retString);
}
catch (Exception e)
{
throw e;
}
}
public static List <PaymentGateWayInfo> GetAllPaymentMethod(int offset, int limit, AspxCommonInfo aspxCommonObj, PaymentGateWayBasicInfo paymentMethodObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("offset", offset));
parameterCollection.Add(new KeyValuePair <string, object>("limit", limit));
parameterCollection.Add(new KeyValuePair <string, object>("PaymentGatewayName", paymentMethodObj.PaymentGatewayName));
parameterCollection.Add(new KeyValuePair <string, object>("IsActive", paymentMethodObj.IsActive));
OracleHandler sqlH = new OracleHandler();
List <PaymentGateWayInfo> lstPayGateWay = sqlH.ExecuteAsList <PaymentGateWayInfo>("usp_Aspx_GetPaymentGateWayMethod", parameterCollection);
return(lstPayGateWay);
}
catch (Exception e)
{
throw e;
}
}
public static List <MenuInfo> GetFooterMenu(int PortalID, string UserName, string CultureCode)
{
List <MenuInfo> lstPages = new List <MenuInfo>();
string StoredProcedureName = "usp_SageMenuGetFooter";
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("UserName", UserName));
ParaMeterCollection.Add(new KeyValuePair <string, object>("CultureCode", CultureCode));
OracleDataReader SQLReader = null;
try
{
OracleHandler sagesql = new OracleHandler();
SQLReader = sagesql.ExecuteAsDataReader(StoredProcedureName, ParaMeterCollection);
while (SQLReader.Read())
{
MenuInfo objMenu = new MenuInfo();
objMenu.PageID = int.Parse(SQLReader["PageID"].ToString());
objMenu.PageOrder = int.Parse(SQLReader["PageOrder"].ToString());
objMenu.ParentID = int.Parse(SQLReader["ParentID"].ToString());
objMenu.Level = int.Parse(SQLReader["Level"].ToString());
objMenu.LevelPageName = SQLReader["LevelPageName"].ToString();
objMenu.SEOName = SQLReader["SEOName"].ToString();
objMenu.TabPath = SQLReader["TabPath"].ToString();
objMenu.IsVisible = bool.Parse(SQLReader["IsVisible"].ToString());
objMenu.ShowInMenu = bool.Parse(SQLReader["ShowInMenu"].ToString());
objMenu.PageName = SQLReader["PageName"].ToString();
lstPages.Add(objMenu);
}
return(lstPages);
}
catch (Exception e)
{
throw e;
}
finally
{
if (SQLReader != null)
{
SQLReader.Close();
}
}
}
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;
}
}
public void SetUserModulePermission(List <ModulePermissionInfo> lstPermission, OracleTransaction tran, int UserModuleID, int PortalID, string AddedBy, int ModuleDefID)
{
try
{
foreach (ModulePermissionInfo objPerm in lstPermission)
{
if (objPerm == null)
{
continue;
}
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>(
"@ModuleDefID", ModuleDefID),
new KeyValuePair <string, object>(
"@UserModuleID", UserModuleID),
new KeyValuePair <string, object>(
"@AllowAccess", objPerm.AllowAccess),
new KeyValuePair <string, object>(
"@RoleID", objPerm.RoleID),
new KeyValuePair <string, object>(
"@UserName", objPerm.UserName),
new KeyValuePair <string, object>(
"@IsActive", true),
new KeyValuePair <string, object>(
"@AddedOn", DateTime.Now),
new KeyValuePair <string, object>(
"@PortalID", PortalID),
new KeyValuePair <string, object>(
"@AddedBy", AddedBy),
new KeyValuePair <string, object>(
"@PermissionID", objPerm.PermissionID)
};
//SQLHandler sqlH = new SQLHandler();
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_UserModulesPermissionAdd",
ParaMeterCollection);
}
}
catch (Exception ex)
{
throw ex;
}
}
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));
OracleHandler sqlH = new OracleHandler();
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 List <SubscriptionInfo> NotificationUsersGetAll(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
OracleHandler sqLH = new OracleHandler();
DataSet ds = sqLH.ExecuteAsDataSet("usp_Aspx_NotificationUsersGetAll", parameterCollection);
List <SubscriptionInfo> SubscriptionDetails = new List <SubscriptionInfo>();
if (ds.Tables.Count > 0)
{
SubscriptionDetails = DataSourceHelper.FillCollection <SubscriptionInfo>(ds.Tables[0]);
}
return(SubscriptionDetails);
}
catch (Exception e)
{
throw e;
}
}
public static List <CardTypeInfo> AddUpdateCardType(AspxCommonInfo aspxCommonObj, CardTypeSaveInfo cardTypeSaveObj, string uploadedFile)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("CardTypeID", cardTypeSaveObj.CardTypeID));
parameter.Add(new KeyValuePair <string, object>("CardTypeName", cardTypeSaveObj.CardTypeName));
parameter.Add(new KeyValuePair <string, object>("ImagePath", uploadedFile));
parameter.Add(new KeyValuePair <string, object>("AlternateText", cardTypeSaveObj.AlternateText));
parameter.Add(new KeyValuePair <string, object>("IsActive", cardTypeSaveObj.IsActive));
OracleHandler sqlH = new OracleHandler();
List <CardTypeInfo> lstCardType = sqlH.ExecuteAsList <CardTypeInfo>("[dbo].[usp_Aspx_AddUpdateCardType]", parameter);
return(lstCardType);
}
catch (Exception e)
{
throw e;
}
}
//--ShipmentsListManagement
public static List <ShipmentsDetailsInfo> GetShipmentsDetails(int offset, System.Nullable <int> limit, ShipmentsBasicinfo shipmentObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("ShippingMethodName", shipmentObj.ShippingMethodName));
parameter.Add(new KeyValuePair <string, object>("ShipToName", shipmentObj.ShipToName));
parameter.Add(new KeyValuePair <string, object>("OrderID", shipmentObj.OrderID));
OracleHandler sqlH = new OracleHandler();
List <ShipmentsDetailsInfo> lstShipmentDet = sqlH.ExecuteAsList <ShipmentsDetailsInfo>("usp_Aspx_GetShipmentsDetails", parameter);
return(lstShipmentDet);
}
catch (Exception e)
{
throw e;
}
}
public static bool CheckUniquenessText(Int32 flag, Int32 storeID, Int32 portalID, Int32 attributeID, string attributeValue)
{
try
{
OracleHandler sqlH = new OracleHandler();
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("Flag", flag));
parameterCollection.Add(new KeyValuePair <string, object>("PortalID", portalID));
parameterCollection.Add(new KeyValuePair <string, object>("StoreID", storeID));
parameterCollection.Add(new KeyValuePair <string, object>("AttributeID", attributeID));
parameterCollection.Add(new KeyValuePair <string, object>("AttributeValue", attributeValue));
bool isUnique = sqlH.ExecuteAsScalar <bool>("usp_Aspx_CheckUniqueness_Text", parameterCollection);
return(isUnique);
}
catch (Exception e)
{
throw e;
}
}
public static int GetModuleID(int UserModuleID)
{
OracleHandler Objsql = new OracleHandler();
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("UserModuleID", UserModuleID));
//SQLHandler sqlh = new SQLHandler();
OracleHandler sqlh = new OracleHandler();
int ModuleID = 0;
ModuleID = sqlh.ExecuteAsScalar <int>("usp_ModuleControlGetModuleIdFromUserModuleId", ParaMeterCollection);
return(ModuleID);
}
catch (Exception ex)
{
throw ex;
}
}
public static void SaveUpdateStoreAccess(int edit, int storeAccessKeyID, string storeAccessData, string reason, bool isActive, AspxCommonInfo aspxCommonObj)
{
try
{
OracleHandler sqlH = new OracleHandler();
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("StoreAccessKeyID", storeAccessKeyID));
parameter.Add(new KeyValuePair <string, object>("StoreAccessData", storeAccessData));
parameter.Add(new KeyValuePair <string, object>("IsActive", isActive));
parameter.Add(new KeyValuePair <string, object>("Reason", reason));
parameter.Add(new KeyValuePair <string, object>("AddedBy", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair <string, object>("StoreAccessID", edit));
sqlH.ExecuteNonQuery("usp_Aspx_StoreAccessAddUpdate", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static List <BookingDetailsInfo> GetServiceBookingDetails(int offset, int limit, AspxCommonInfo aspxCommonObj, int employeeId, int?statusId, int branchID)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("EmployeeID", employeeId));
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("StatusID", statusId));
parameter.Add(new KeyValuePair <string, object>("BranchID", branchID));
OracleHandler sqlh = new OracleHandler();
List <BookingDetailsInfo> list = sqlh.ExecuteAsList <BookingDetailsInfo>("usp_Aspx_GetBookingDetails", parameter);
return(list);
}
catch (Exception e)
{
throw e;
}
}
public static List <GiftCardCategoryInfo> GetAllGiftCardCategoryGrid(int offset, int limit, AspxCommonInfo aspxCommonObj, string categoryName, DateTime?addedon, bool?status)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
parameter.Add(new KeyValuePair <string, object>("@CategoryName", categoryName));
parameter.Add(new KeyValuePair <string, object>("@AddedDate", addedon));
parameter.Add(new KeyValuePair <string, object>("@Status", status));
OracleHandler sqlH = new OracleHandler();
List <GiftCardCategoryInfo> lstGCCat = sqlH.ExecuteAsList <GiftCardCategoryInfo>("usp_Aspx_GetAllGiftCardCategoryGrid", parameter);
return(lstGCCat);
}
catch (Exception e)
{
throw e;
}
}
public static List <StoreLocatorInfo> GetLocationsNearBy(double latitude, double longitude, double searchDistance, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("CenterLatitude", latitude));
parameterCollection.Add(new KeyValuePair <string, object>("CenterLongitude", longitude));
parameterCollection.Add(new KeyValuePair <string, object>("SearchDistance", searchDistance));
parameterCollection.Add(new KeyValuePair <string, object>("EarthRadius", 3961));
try
{
OracleHandler sqlH = new OracleHandler();
List <StoreLocatorInfo> lstStoreLocate = sqlH.ExecuteAsList <StoreLocatorInfo>("usp_Aspx_StoreLocatorGetNearbyStore", parameterCollection);
return(lstStoreLocate);
}
catch (Exception e)
{
throw e;
}
}
public ImageGalleryInfo GetGallerySettingValues(int userModuleID, AspxCommonInfo aspxCommonObj)
{
ImageGalleryInfo infoObject;
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
try
{
parameterCollection.Add(new KeyValuePair <string, object>("UserModuleID", userModuleID));
parameterCollection.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair <string, object>("Culture", aspxCommonObj.CultureName));
OracleHandler sagesql = new OracleHandler();
infoObject = sagesql.ExecuteAsObject <ImageGalleryInfo>("usp_Aspx_GetGallerySettings", parameterCollection);
return(infoObject);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <LayoutMgrInfo> GetSortModules(int flag, bool isAdmin, int PortalID, int IncludePortalModules)
{
//SQLHandler SQLH = new SQLHandler();
OracleHandler SQLH = new OracleHandler();
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("flag", flag));
ParaMeterCollection.Add(new KeyValuePair <string, object>("isAdmin", isAdmin));
ParaMeterCollection.Add(new KeyValuePair <string, object>("PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("IncludePortalModules", IncludePortalModules));
try
{
return(SQLH.ExecuteAsList <LayoutMgrInfo>("usp_ModuleMgrSortModules", ParaMeterCollection));
}
catch (Exception)
{
throw;
}
}
public static List <BookAppointmentGridInfo> GetBookAppointmentList(int offset, int limit, AspxCommonInfo aspxCommonObj, string appointmentStatusName, string branchName, string employeeName)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("AppointmentStatusName", appointmentStatusName));
parameter.Add(new KeyValuePair <string, object>("BranchName", branchName));
parameter.Add(new KeyValuePair <string, object>("EmployeeName", employeeName));
OracleHandler sqlh = new OracleHandler();
List <BookAppointmentGridInfo> lstBookAppoint = sqlh.ExecuteAsList <BookAppointmentGridInfo>("usp_Aspx_GetAppointmentList", parameter);
return(lstBookAppoint);
}
catch (Exception e)
{
throw e;
}
}
public int SaveCompareItems(SaveCompareItemInfo saveCompareItemObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", saveCompareItemObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("CompareItemID", 0));
parameter.Add(new KeyValuePair <string, object>("IP", saveCompareItemObj.IP));
parameter.Add(new KeyValuePair <string, object>("CountryName", saveCompareItemObj.CountryName));
parameter.Add(new KeyValuePair <string, object>("CostVariantValueIDs", saveCompareItemObj.CostVariantIDs));
OracleHandler sqlH = new OracleHandler();
int compareID = sqlH.ExecuteNonQuery("usp_Aspx_AddItemsToCompare", parameter, "CompareAddedItemID");
return(compareID);
}
catch (Exception e)
{
throw e;
}
}
public static void SaveServiceProvider(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerSaveInfo)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("StoreBranchID", providerSaveInfo.StoreBranchID));
parameter.Add(new KeyValuePair <string, object>("EmployeeID", providerSaveInfo.EmployeeID));
parameter.Add(new KeyValuePair <string, object>("EmployeeName", providerSaveInfo.EmployeeName));
parameter.Add(new KeyValuePair <string, object>("EmployeeNickName", providerSaveInfo.EmployeeNickName));
parameter.Add(new KeyValuePair <string, object>("EmployeeImage", providerSaveInfo.EmployeeImage));
OracleHandler sqlh = new OracleHandler();
sqlh.ExecuteNonQuery("usp_Aspx_AddUpdateServiceProvider", parameter);
}
catch (Exception e)
{
throw e;
}
}
public int?GetAttributeSetGroupID(int attributeId, int attributeSetId, int storeId, int portalId)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("AttributeID", attributeId));
parameterCollection.Add(new KeyValuePair <string, object>("AttributeSetID", attributeSetId));
parameterCollection.Add(new KeyValuePair <string, object>("StoreID", storeId));
parameterCollection.Add(new KeyValuePair <string, object>("PortalID", portalId));
OracleHandler sqlH = new OracleHandler();
int? id = sqlH.ExecuteAsScalar <int>("usp_Aspx_GetGroupIDByAttributeSetID",
parameterCollection);
return(id);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ServiceEmpInfo> GetServiceEmployee(int offset, int limit, AspxCommonInfo aspxCommonObj, int serviceId, int branchID, string serviceEmpName)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("ServiceID", serviceId));
parameter.Add(new KeyValuePair <string, object>("ServiceEmpNm", serviceEmpName));
parameter.Add(new KeyValuePair <string, object>("BranchID", branchID));
OracleHandler sqlh = new OracleHandler();
List <ServiceEmpInfo> list = sqlh.ExecuteAsList <ServiceEmpInfo>("usp_Aspx_GetEmployeeByServiceID", parameter);
return(list);
}
catch (Exception e)
{
throw e;
}
}
