public static List<UserRatingInformationInfo> GetAllUserReviewsAndRatings(int offset, int limit, UserRatingBasicInfo userRatingObj, AspxCommonInfo aspxCommonObj) { try { List<UserRatingInformationInfo> bind = AspxRatingReviewProvider.GetAllUserReviewsAndRatings(offset, limit, userRatingObj, aspxCommonObj); return bind; } catch (Exception e) { throw e; } }
public static List<UserRatingInformationInfo> GetAllItemReviewsList(int offset, System.Nullable<int> limit, UserRatingBasicInfo itemReviewObj, AspxCommonInfo aspxCommonObj) { try { List<UserRatingInformationInfo> bind = AspxRatingReviewProvider.GetAllItemReviewsList(offset, limit, itemReviewObj, aspxCommonObj); return bind; } catch (Exception e) { throw e; } }
public static List <UserRatingInformationInfo> GetAllItemReviewsList(int offset, System.Nullable <int> limit, UserRatingBasicInfo itemReviewObj, AspxCommonInfo aspxCommonObj) { try { List <UserRatingInformationInfo> bind = AspxRatingReviewProvider.GetAllItemReviewsList(offset, limit, itemReviewObj, aspxCommonObj); return(bind); } catch (Exception e) { throw e; } }
public static List <UserRatingInformationInfo> GetAllUserReviewsAndRatings(int offset, int limit, UserRatingBasicInfo userRatingObj, AspxCommonInfo aspxCommonObj) { try { List <UserRatingInformationInfo> bind = AspxRatingReviewProvider.GetAllUserReviewsAndRatings(offset, limit, userRatingObj, aspxCommonObj); return(bind); } catch (Exception e) { throw e; } }
//---------------------Show All Customer Reviews------------------------- public List<UserRatingInformationInfo> GetAllCustomerReviewsList(int offset, System.Nullable<int> limit, AspxCommonInfo aspxCommonObj, UserRatingBasicInfo customerReviewObj) { try { List<UserRatingInformationInfo> bind = AspxRatingReviewController.GetAllCustomerReviewsList(offset, limit, aspxCommonObj, customerReviewObj); return bind; } catch (Exception ex) { throw ex; } }
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)); SQLHandler sqlH = new SQLHandler(); List <UserRatingInformationInfo> bind = sqlH.ExecuteAsList <UserRatingInformationInfo>("usp_Aspx_GetItemWiseReviewsList", parameter); return(bind); } 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)); SQLHandler sqlH = new SQLHandler(); List<UserRatingInformationInfo> bind = sqlH.ExecuteAsList<UserRatingInformationInfo>("usp_Aspx_GetItemWiseReviewsList", parameter); return bind; } catch (Exception e) { throw e; } }
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)); OracleHandler sqlH = new OracleHandler(); List <UserRatingInformationInfo> bind = sqlH.ExecuteAsList <UserRatingInformationInfo>("usp_Aspx_GetCustomerWiseReviewsList", parameter); return(bind); } 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)); OracleHandler sqlH = new OracleHandler(); List <UserRatingInformationInfo> bind = sqlH.ExecuteAsList <UserRatingInformationInfo>("usp_Aspx_GetAllReviewsAndRatings", parameter); return(bind); } catch (Exception e) { throw e; } }