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; } }