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