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