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)); SQLHandler sqlH = new SQLHandler(); List <GiftCardCategoryInfo> lstGCCat = sqlH.ExecuteAsList <GiftCardCategoryInfo>("usp_Aspx_GetAllGiftCardCategoryGrid", parameter); return(lstGCCat); } catch (Exception e) { throw e; } }
public static List <UserRatingInformationInfo> GetAllUserReviewsAndRatings(int offset, int limit, UserRatingBasicInfo userRatingObj, AspxCommonInfo aspxCommonObj) { 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>("@UserName", userRatingObj.UserName)); parameter.Add(new KeyValuePair <string, object>("@StatusName", userRatingObj.Status)); parameter.Add(new KeyValuePair <string, object>("@ItemName", userRatingObj.ItemName)); SQLHandler sqlH = new SQLHandler(); List <UserRatingInformationInfo> bind = sqlH.ExecuteAsList <UserRatingInformationInfo>("usp_Aspx_GetAllReviewsAndRatings", parameter); return(bind); } 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; } }
//--------------tax rates------------------ public static List <TaxRateInfo> GetTaxRateDetails(int offset, System.Nullable <int> limit, TaxRateDataTnfo taxRateDataObj, AspxCommonInfo aspxCommonObj) { 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>("@TaxName", taxRateDataObj.TaxName)); parameter.Add(new KeyValuePair <string, object>("@SearchCountry", taxRateDataObj.Country)); parameter.Add(new KeyValuePair <string, object>("@SerachState", taxRateDataObj.State)); parameter.Add(new KeyValuePair <string, object>("@Zip", taxRateDataObj.Zip)); SQLHandler sqlh = new SQLHandler(); List <TaxRateInfo> lstTaxRate = sqlh.ExecuteAsList <TaxRateInfo>("usp_Aspx_GetTaxRates", parameter); return(lstTaxRate); } catch (Exception e) { throw e; } }
public List <ServiceCoreAvailableTime> GetServiceAvailableTime(GetServiceCoreAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("CategoryID", getServiceTimeObj.CategoryID)); parameter.Add(new KeyValuePair <string, object>("BranchID", getServiceTimeObj.BranchID)); parameter.Add(new KeyValuePair <string, object>("EmployeeID", getServiceTimeObj.EmployeeID)); parameter.Add(new KeyValuePair <string, object>("ServiceDateID", getServiceTimeObj.ServiceDateID)); parameter.Add(new KeyValuePair <string, object>("ServiceDate", getServiceTimeObj.ServiceDate)); parameter.Add(new KeyValuePair <string, object>("ItemID", getServiceTimeObj.ItemID)); OracleHandler sqlh = new OracleHandler(); List <ServiceCoreAvailableTime> lstServTime = sqlh.ExecuteAsList <ServiceCoreAvailableTime>("usp_Aspx_GetServiceTime", parameter); return(lstServTime); } catch (Exception e) { throw e; } }
public static List <ServiceAvailableTimeInfo> GetServiceAvailableTime(GetServiceAvailableTimeInfo getServiceTimeObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@CategoryID", getServiceTimeObj.CategoryID)); parameter.Add(new KeyValuePair <string, object>("@BranchID", getServiceTimeObj.BranchID)); parameter.Add(new KeyValuePair <string, object>("@EmployeeID", getServiceTimeObj.EmployeeID)); parameter.Add(new KeyValuePair <string, object>("@ServiceDateID", getServiceTimeObj.ServiceDateID)); parameter.Add(new KeyValuePair <string, object>("@ServiceDate", getServiceTimeObj.ServiceDate)); parameter.Add(new KeyValuePair <string, object>("@ItemID", getServiceTimeObj.ItemID)); SQLHandler sqlh = new SQLHandler(); List <ServiceAvailableTimeInfo> lstServTime = sqlh.ExecuteAsList <ServiceAvailableTimeInfo>("[dbo].[usp_Aspx_GetServiceTime]", parameter); return(lstServTime); } catch (Exception e) { throw e; } }
public static List <UserRatingInformationInfo> GetAllItemReviewsList(int offset, System.Nullable <int> limit, UserRatingBasicInfo itemReviewObj, AspxCommonInfo aspxCommonObj) { 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>("ItemID", itemReviewObj.ItemID)); parameter.Add(new KeyValuePair <string, object>("UserName", itemReviewObj.UserName)); parameter.Add(new KeyValuePair <string, object>("StatusName", itemReviewObj.Status)); parameter.Add(new KeyValuePair <string, object>("ItemName", itemReviewObj.ItemName)); OracleHandler sqlH = new OracleHandler(); List <UserRatingInformationInfo> bind = sqlH.ExecuteAsList <UserRatingInformationInfo>("usp_Aspx_GetItemWiseReviewsList", parameter); return(bind); } catch (Exception e) { throw e; } }
public static void AddUpDateWareHouse(WareHouseAddress wareHouse, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj); paramCol.Add(new KeyValuePair <string, object>("WareHouseID", wareHouse.WareHouseID)); paramCol.Add(new KeyValuePair <string, object>("IsPrimary", wareHouse.IsPrimary)); paramCol.Add(new KeyValuePair <string, object>("Name", wareHouse.Name)); paramCol.Add(new KeyValuePair <string, object>("StreetAddress1", wareHouse.StreetAddress1)); paramCol.Add(new KeyValuePair <string, object>("StreetAddress2", wareHouse.StreetAddress2)); paramCol.Add(new KeyValuePair <string, object>("City", wareHouse.City)); paramCol.Add(new KeyValuePair <string, object>("Country", wareHouse.Country)); paramCol.Add(new KeyValuePair <string, object>("State", wareHouse.State)); paramCol.Add(new KeyValuePair <string, object>("PostalCode", wareHouse.PostalCode)); paramCol.Add(new KeyValuePair <string, object>("Phone", wareHouse.Phone)); paramCol.Add(new KeyValuePair <string, object>("Fax", wareHouse.Fax)); paramCol.Add(new KeyValuePair <string, object>("Email", wareHouse.Email)); paramCol.Add(new KeyValuePair <string, object>("AddedBy", aspxCommonObj.UserName)); OracleHandler sageSQL = new OracleHandler(); sageSQL.ExecuteNonQuery("usp_Aspx_InsertUpdateAspx_WareHouse", paramCol); }
public static List <CouponUserInfo> GetCouponUserDetails(int offset, int?limit, GetCouponUserDetailInfo couponUserObj, AspxCommonInfo aspxCommonObj, string userName) { try { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@UserName", userName)); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponUserObj.CouponCode)); parameter.Add(new KeyValuePair <string, object>("@CouponStatusID", couponUserObj.CouponStatusID)); parameter.Add(new KeyValuePair <string, object>("@ValidFrom", couponUserObj.ValidFrom)); parameter.Add(new KeyValuePair <string, object>("@ValidTo", couponUserObj.ValidTo)); SQLHandler sqlH = new SQLHandler(); List <CouponUserInfo> lstCoupUser = sqlH.ExecuteAsList <CouponUserInfo>("usp_Aspx_CouponUserDetails", parameter); return(lstCoupUser); } catch (Exception ex) { throw ex; } }
public static List <ShippingMethodInfo> GetShippingMethods(int offset, int limit, ShippingMethodInfoByProvider shippingMethodObj, AspxCommonInfo aspxCommonObj) { try { OracleHandler sqlH = new OracleHandler(); List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("ShippingMethodName", shippingMethodObj.ShippingMethodName)); parameterCollection.Add(new KeyValuePair <string, object>("DeliveryTime", shippingMethodObj.DeliveryTime)); parameterCollection.Add(new KeyValuePair <string, object>("WeightLimitFrom", shippingMethodObj.WeightLimitFrom)); parameterCollection.Add(new KeyValuePair <string, object>("WeightLimitTo", shippingMethodObj.WeightLimitTo)); parameterCollection.Add(new KeyValuePair <string, object>("IsActive", shippingMethodObj.IsActive)); List <ShippingMethodInfo> shipping = sqlH.ExecuteAsList <ShippingMethodInfo>("usp_Aspx_BindShippingMethodInGrid", parameterCollection); return(shipping); } catch (Exception e) { throw e; } }
//--------------------------get customer class---------------- public static List <TaxManageRulesInfo> GetTaxRules(int offset, int limit, TaxRuleDataInfo taxRuleDataObj, AspxCommonInfo aspxCommonObj) { 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>("@RuleName", taxRuleDataObj.TaxManageRuleName)); parameter.Add(new KeyValuePair <string, object>("@RoleName", taxRuleDataObj.RoleName)); parameter.Add(new KeyValuePair <string, object>("@ItemClassName", taxRuleDataObj.TaxItemClassName)); parameter.Add(new KeyValuePair <string, object>("@RateTitle", taxRuleDataObj.TaxRateTitle)); parameter.Add(new KeyValuePair <string, object>("@SearchPriority", taxRuleDataObj.Priority)); parameter.Add(new KeyValuePair <string, object>("@SearchDisplayOrder", taxRuleDataObj.DisplayOrder)); SQLHandler sqlh = new SQLHandler(); List <TaxManageRulesInfo> lstTaxManage = sqlh.ExecuteAsList <TaxManageRulesInfo>("usp_Aspx_GetTaxManageRules", parameter); return(lstTaxManage); } catch (Exception e) { throw e; } }
public static List <ReturnDetailsInfo> GetReturnDetails(int offset, System.Nullable <int> limit, AspxCommonInfo aspxCommonObj, RetunDetailsBasicInfo returnDetailObj) { 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>("ReturnID", returnDetailObj.ReturnID)); parameter.Add(new KeyValuePair <string, object>("OrderID", returnDetailObj.OrderID)); parameter.Add(new KeyValuePair <string, object>("UserName", returnDetailObj.CustomerName)); parameter.Add(new KeyValuePair <string, object>("StatusName", returnDetailObj.ReturnStatus)); parameter.Add(new KeyValuePair <string, object>("DateAdded", returnDetailObj.DateAdded)); parameter.Add(new KeyValuePair <string, object>("DateModified", returnDetailObj.DateModified)); OracleHandler sqlH = new OracleHandler(); List <ReturnDetailsInfo> info = sqlH.ExecuteAsList <ReturnDetailsInfo>("usp_Aspx_GetReturnDetails", parameter); return(info); } catch (Exception e) { throw e; } }
public static List <GiftCardReport> GetGiftCardReport(int offset, int?limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj); paramCol.Add(new KeyValuePair <string, object>("@offset", offset)); paramCol.Add(new KeyValuePair <string, object>("@limit", limit)); paramCol.Add(new KeyValuePair <string, object>("@FromDate", objGiftcard.FromDate)); paramCol.Add(new KeyValuePair <string, object>("@ToDate", objGiftcard.ToDate)); paramCol.Add(new KeyValuePair <string, object>("@SKU", objGiftcard.SKU)); paramCol.Add(new KeyValuePair <string, object>("@ItemName", objGiftcard.ItemName)); paramCol.Add(new KeyValuePair <string, object>("@GiftCardType", objGiftcard.GiftCardType)); SQLHandler sqlHl = new SQLHandler(); List <GiftCardReport> lstGiftCard = sqlHl.ExecuteAsList <GiftCardReport>("[dbo].[usp_Aspx_GetGiftCardReports]", paramCol); return(lstGiftCard); } catch (Exception e) { throw e; } }