public static List <CategoryWiseItemInfo> GetCategoryWiseItemList(int offset, int limit, int noOfItemsInCategory, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@noOfItemsInCategory", noOfItemsInCategory)); parameter.Add(new KeyValuePair <string, object>("offset", offset)); parameter.Add(new KeyValuePair <string, object>("limit", limit)); SQLHandler sqlH = new SQLHandler(); List <CategoryWiseItemInfo> lstCatWiseItem = sqlH.ExecuteAsList <CategoryWiseItemInfo>("[dbo].[usp_Aspx_CategoryWiseItemList]", parameter); return(lstCatWiseItem); } catch (Exception e) { throw e; } }
public static List <CouponStatusInfo> AddUpdateCouponStatus(AspxCommonInfo aspxCommonObj, CouponStatusInfo SaveCouponStatusObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("CouponStatusID", SaveCouponStatusObj.CouponStatusID)); parameter.Add(new KeyValuePair <string, object>("CouponStatusName", SaveCouponStatusObj.CouponStatus)); parameter.Add(new KeyValuePair <string, object>("IsActive", SaveCouponStatusObj.IsActive)); OracleHandler sqlH = new OracleHandler(); List <CouponStatusInfo> lstCouponStat = sqlH.ExecuteAsList <CouponStatusInfo>("usp_Aspx_CouponStatusAddUpdate", parameter); return(lstCouponStat); } catch (Exception e) { throw e; } }
public static List <BrandItemsInfo> GetAllBrandForCategory(string categorykey, bool isByCategory, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("categorykey", categorykey)); parameterCollection.Add(new KeyValuePair <string, object>("isByCategory", Convert.ToString(isByCategory).ToLower())); OracleHandler sqlH = new OracleHandler(); List <BrandItemsInfo> lstBrandItem = sqlH.ExecuteAsList <BrandItemsInfo>("usp_Aspx_GetAllBrandForCategor", parameterCollection); //List<BrandItemsInfo> lstBrandItem = sqlH.ExecuteAsList<BrandItemsInfo>("usp_Aspx_GetAllBrandForCategory", parameterCollection); return(lstBrandItem); } catch (Exception ex) { throw ex; } }
public static List <CategoryItemInfo> GetCategoryItems(Int32 offset, int?limit, GetCategoryItemInfo categoryItemsInfo, AspxCommonInfo aspxCommonObj, bool serviceBit) { OracleHandler sqlHandler = new OracleHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("serviceBit", serviceBit)); parameterCollection.Add(new KeyValuePair <string, object>("CategoryID", categoryItemsInfo.CategoryID)); parameterCollection.Add(new KeyValuePair <string, object>("SKU", categoryItemsInfo.SKU)); parameterCollection.Add(new KeyValuePair <string, object>("Name", categoryItemsInfo.Name)); parameterCollection.Add(new KeyValuePair <string, object>("PriceFrom", categoryItemsInfo.PriceFrom)); parameterCollection.Add(new KeyValuePair <string, object>("PriceTo", categoryItemsInfo.PriceTo)); List <CategoryItemInfo> listCategoryItem = sqlHandler.ExecuteAsList <CategoryItemInfo>("usp_Aspx_GetItemsByCategoryIDService", parameterCollection); return(listCategoryItem); }
public static void AddUpdateCouponType(CouponTypeInfo couponTypeObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("CouponTypeID", couponTypeObj.CouponTypeID)); parameter.Add(new KeyValuePair <string, object>("CouponType", couponTypeObj.CouponType)); parameter.Add(new KeyValuePair <string, object>("IsActive", couponTypeObj.IsActive)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateCouponType", parameter); } catch (Exception e) { throw e; } }
/// <summary> /// To Bind grid with all Cross Sell Items /// </summary> public static List <ItemsInfo> GetCrossSellItemsByItemID(int offset, int limit, ItemDetailsCommonInfo CrossSellCommonObj, AspxCommonInfo aspxCommonObj) { List <ItemsInfo> ml; SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("@SelfItemID", CrossSellCommonObj.SelfItemID)); parameterCollection.Add(new KeyValuePair <string, object>("@ItemSKU", CrossSellCommonObj.ItemSKU)); parameterCollection.Add(new KeyValuePair <string, object>("@ItemName", CrossSellCommonObj.ItemName)); parameterCollection.Add(new KeyValuePair <string, object>("@ItemTypeID", CrossSellCommonObj.ItemTypeID)); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", CrossSellCommonObj.AttributeSetID)); parameterCollection.Add(new KeyValuePair <string, object>("@ServiceBit", CrossSellCommonObj.ServiceBit)); ml = sqlH.ExecuteAsList <ItemsInfo>("dbo.usp_Aspx_GetCrossSellItemsByItemID", parameterCollection); return(ml); }
public static void UpdateShoppingCart(UpdateCartInfo updateCartObj, AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameter =CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair<string, object>("@CartID", updateCartObj.CartID)); parameter.Add(new KeyValuePair<string, object>("@CartItemIDs", updateCartObj.CartItemIDs)); parameter.Add(new KeyValuePair<string, object>("@Quantities", updateCartObj.Quantities)); parameter.Add(new KeyValuePair<string, object>("@AllowOutOfStock", updateCartObj.AllowOutOfStock)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("usp_Aspx_UpdateShoppingCart", parameter); } catch (Exception e) { throw e; } }
public int SaveComponent(KitComponent kitcomponent, AspxCommonInfo commonInfo) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(commonInfo); parameter.Add(new KeyValuePair <string, object>("@KitComponentID", kitcomponent.KitComponentID)); parameter.Add(new KeyValuePair <string, object>("@ComponentName", kitcomponent.KitComponentName)); parameter.Add(new KeyValuePair <string, object>("@KitComponentType", kitcomponent.KitComponentType)); SQLHandler sqLh = new SQLHandler(); int kitComponentID = sqLh.ExecuteAsScalar <int>("[dbo].[usp_Aspx_AddUpdateKitComponent]", parameter); return(kitComponentID); } catch (Exception ex) { throw ex; } }
public static List <CustomerDetailsInfo> GetCustomerDetails(string customerName, int offset, int limit, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@CustomerName", customerName)); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); SQLHandler sqlH = new SQLHandler(); List <CustomerDetailsInfo> lstCustDetail = sqlH.ExecuteAsList <CustomerDetailsInfo>("[dbo].[usp_Aspx_GetCustomerDetails]", parameter); return(lstCustDetail); } catch (Exception e) { throw e; } }
public static List <CategoryDetailsInfo> BindCategoryDetails(int categoryID, int count, int level, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@CategoryID", categoryID)); parameterCollection.Add(new KeyValuePair <string, object>("@Count", count)); parameterCollection.Add(new KeyValuePair <string, object>("@Level", level)); SQLHandler sqlH = new SQLHandler(); List <CategoryDetailsInfo> lstCatDetail = sqlH.ExecuteAsList <CategoryDetailsInfo>("usp_Aspx_GetCategoryDetails", parameterCollection); return(lstCatDetail); } catch (Exception e) { throw e; } }
public static List <CustomerRecentOrders> GetCustomerRecentOrdersByCustomerID(int offset, int limit, int customerID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@customerID", customerID)); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); SQLHandler sqlH = new SQLHandler(); List <CustomerRecentOrders> lstCustRecentOrders = sqlH.ExecuteAsList <CustomerRecentOrders>("[dbo].[usp_Aspx_GetCustomerRecentOrdersByCustomerID]", parameter); return(lstCustRecentOrders); } catch (Exception e) { throw e; } }
public static List <LatestItemsWithOptionsInfo> LatestItemsList(int offset, int limit, AspxCommonInfo aspxCommonObj, int count, int sortBy) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("@SortBy", sortBy)); SQLHandler sqlH = new SQLHandler(); List <LatestItemsWithOptionsInfo> lstLatestItems = sqlH.ExecuteAsList <LatestItemsWithOptionsInfo>("dbo.usp_Aspx_GetLatestItems", parameterCollection); return(lstLatestItems); } catch (Exception e) { throw e; } }
public static List <MyOrderListInfo> GetOrderDetails(int offset, System.Nullable <int> limit, System.Nullable <int> orderStatusName, 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>("@OrderStatusID", orderStatusName)); OracleHandler sqlH = new OracleHandler(); List <MyOrderListInfo> lstMyOrder = sqlH.ExecuteAsList <MyOrderListInfo>("usp_Aspx_GetOrderDetails", parameter); return(lstMyOrder); } catch (Exception e) { throw e; } }
/// <summary> /// To Bind grid with all Items /// </summary> public static List <ItemsInfo> GetAllItems(int offset, int limit, GetItemListInfo getItemObj, AspxCommonInfo aspxCommonObj) { List <ItemsInfo> ml; SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("@SKU", getItemObj.SKU)); parameterCollection.Add(new KeyValuePair <string, object>("@ItemName", getItemObj.ItemName)); parameterCollection.Add(new KeyValuePair <string, object>("@ItemTypeID", getItemObj.ItemTypeID)); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", getItemObj.AttributeSetID)); parameterCollection.Add(new KeyValuePair <string, object>("@Visibility", getItemObj.Visibility)); parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", getItemObj.IsActive)); ml = sqlH.ExecuteAsList <ItemsInfo>("dbo.usp_Aspx_ItemsGetAll", parameterCollection); return(ml); }
public static List <ItemBasicDetailsInfo> GetUserTaggedItems(int offset, int limit, string tagIDs, int SortBy, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("@TagIDs", tagIDs)); parameterCollection.Add(new KeyValuePair <string, object>("@SortBy", SortBy)); SQLHandler sqlH = new SQLHandler(); List <ItemBasicDetailsInfo> lstItemBasic = sqlH.ExecuteAsList <ItemBasicDetailsInfo>("usp_Aspx_GetItemsByTagID", parameterCollection); return(lstItemBasic); } catch (Exception e) { throw e; } }
public static List <AppointmentSatusInfoBasic> GetAppointmentStatusListGrid(int limit, int offset, string statusName, bool?isActive, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("limit", limit)); parameter.Add(new KeyValuePair <string, object>("offset", offset)); parameter.Add(new KeyValuePair <string, object>("AppointmentStatusName", statusName)); parameter.Add(new KeyValuePair <string, object>("IsActive", isActive)); OracleHandler sqlh = new OracleHandler(); List <AppointmentSatusInfoBasic> lstAppointStatus = sqlh.ExecuteAsList <AppointmentSatusInfoBasic>("usp_Aspx_GetAppointmentStatusListGrid", parameter); return(lstAppointStatus); } catch (Exception e) { throw e; } }
public static List <ItemBasicDetailsInfo> GetBrandItemsByBrandID(int offset, int limit, string brandName, int SortBy, 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>("@BrandName", brandName)); parameter.Add(new KeyValuePair <string, object>("@SortBy", SortBy)); SQLHandler sqlH = new SQLHandler(); List <ItemBasicDetailsInfo> lstItem = sqlH.ExecuteAsList <ItemBasicDetailsInfo>("usp_Aspx_GetBrandItemByBrandID", parameter); return(lstItem); } catch (Exception e) { throw e; } }
public static List <CategoryDetailsOptionsInfo> GetGiftCardItemsDetails(int offset, int limit, AspxCommonInfo aspxCommonObj, int sortBy, int rowTotal) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("@SortBy", sortBy)); parameterCollection.Add(new KeyValuePair <string, object>("@RowTotal", rowTotal)); SQLHandler sqlH = new SQLHandler(); List <CategoryDetailsOptionsInfo> lstCatDetail = sqlH.ExecuteAsList <CategoryDetailsOptionsInfo>("[usp_Aspx_GetLatestGiftCards]", parameterCollection); return(lstCatDetail); } catch (Exception e) { throw e; } }
public static List <CustomerWishList> GetCustomerWishListByCustomerID(int offset, int limit, int customerID, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("customerID", customerID)); parameter.Add(new KeyValuePair <string, object>("offset", offset)); parameter.Add(new KeyValuePair <string, object>("limit", limit)); OracleHandler sqlH = new OracleHandler(); List <CustomerWishList> lstCustWishList = sqlH.ExecuteAsList <CustomerWishList>("usp_Aspx_GetCustWishlistDetails", parameter); return(lstCustWishList); } catch (Exception e) { throw e; } }
public static List <CouponStatusInfo> GetAllCouponStatusList(int offset, int limit, AspxCommonInfo aspxCommonObj, string couponStatusName, System.Nullable <bool> isActive) { 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>("@CouponStatusName", couponStatusName)); parameter.Add(new KeyValuePair <string, object>("@IsActive", isActive)); SQLHandler sqlH = new SQLHandler(); List <CouponStatusInfo> lstCouponStat = sqlH.ExecuteAsList <CouponStatusInfo>("[dbo].[usp_Aspx_GetCouponAliasStatusList]", parameter); return(lstCouponStat); } catch (Exception e) { throw e; } }
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)); SQLHandler sqlh = new SQLHandler(); List <ItemsForPromoInfo> lst = sqlh.ExecuteAsList <ItemsForPromoInfo>("dbo.usp_Aspx_ItemsForPromoCode", parameter); return(lst); } catch (Exception ex) { throw ex; } }
public static List <ShippingProviderNameListInfo> GetShippingProviderNameList(int offset, int limit, AspxCommonInfo aspxCommonObj, string shippingProviderName, System.Nullable <bool> isActive) { 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>("ShippingProviderName", shippingProviderName)); parameter.Add(new KeyValuePair <string, object>("IsActive", isActive)); OracleHandler sqlH = new OracleHandler(); List <ShippingProviderNameListInfo> lstShipProvider = sqlH.ExecuteAsList <ShippingProviderNameListInfo>("usp_Aspx_GetShippingProviderNameList", parameter); return(lstShipProvider); } catch (Exception e) { throw e; } }
public static List <ItemBasicDetailsInfo> GetShoppingFilterItemsResult(int offset, int limit, string itemIds, int sortBy, 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>("@ItemIDs", itemIds)); parameter.Add(new KeyValuePair <string, object>("@SortBy", sortBy)); SQLHandler sqlH = new SQLHandler(); List <ItemBasicDetailsInfo> lstItemBasic = sqlH.ExecuteAsList <ItemBasicDetailsInfo>("usp_Aspx_GetShoppingOptionsItemsResult", parameter); return(lstItemBasic); } catch (Exception ex) { throw ex; } }
public static List <AttributeFormInfo> GetItemDetailsInfoByItemSKU(string itemSKU, int attributeSetID, int itemTypeID, AspxCommonInfo aspxCommonObj) { try { List <AttributeFormInfo> itemAttributes; SQLHandler sqlH = new SQLHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@itemSKU", itemSKU)); parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", attributeSetID)); parameterCollection.Add(new KeyValuePair <string, object>("@ItemTypeID", itemTypeID)); itemAttributes = sqlH.ExecuteAsList <AttributeFormInfo>("dbo.usp_Aspx_GetItemDetailsByItemSKU", parameterCollection); return(itemAttributes); } catch (Exception e) { throw e; } }
public static List <CouponUserListInfo> GetCouponUserList(int offset, int limit, CouponCommonInfo bindCouponUserObj, 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>("@CouponID", bindCouponUserObj.CouponID)); parameter.Add(new KeyValuePair <string, object>("@CouponCode", bindCouponUserObj.CouponCode)); parameter.Add(new KeyValuePair <string, object>("@CouponStatusID", bindCouponUserObj.CouponStatusID)); SQLHandler sqlH = new SQLHandler(); List <CouponUserListInfo> lstCoupUser = sqlH.ExecuteAsList <CouponUserListInfo>("[usp_Aspx_GetCouponUserList]", parameter); return(lstCoupUser); } catch (Exception ex) { throw ex; } }
public static List <UserRatingInformationInfo> GetAllCustomerReviewsList(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, UserRatingBasicInfo customerReviewObj) { 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>("@User", customerReviewObj.UserName)); parameter.Add(new KeyValuePair <string, object>("@StatusName", customerReviewObj.Status)); parameter.Add(new KeyValuePair <string, object>("@ItemName", customerReviewObj.ItemName)); SQLHandler sqlH = new SQLHandler(); List <UserRatingInformationInfo> bind = sqlH.ExecuteAsList <UserRatingInformationInfo>("usp_Aspx_GetCustomerWiseReviewsList", parameter); return(bind); } 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 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 List <InvoiceDetailsInfo> GetInvoiceDetailsList(int offset, System.Nullable <int> limit, InvoiceBasicInfo invoiceObj, 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>("@InvoiceNumber", invoiceObj.InvoiceNumber)); parameter.Add(new KeyValuePair <string, object>("@BillToName", invoiceObj.BillToName)); parameter.Add(new KeyValuePair <string, object>("@OrderStatusID", invoiceObj.OrderStatusName)); SQLHandler sqlH = new SQLHandler(); List <InvoiceDetailsInfo> lstInvoiceDetail = sqlH.ExecuteAsList <InvoiceDetailsInfo>("usp_Aspx_GetInvoiceDetails", parameter); return(lstInvoiceDetail); } catch (Exception e) { throw e; } }