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