public static void SaveItemRating(ItemReviewBasicInfo ratingSaveObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxRatingReviewProvider.SaveItemRating(ratingSaveObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
//---------------------update rating/ review Items From User DashBoard-----------------------
public static void UpdateItemRatingByUser(ItemReviewBasicInfo updateItemRatingObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxUserDashProvider.UpdateItemRatingByUser(updateItemRatingObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
public static void SaveItemRating(ItemReviewBasicInfo ratingSaveObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxRatingReviewProvider.SaveItemRating(ratingSaveObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateItemRating(ItemReviewBasicInfo ratingManageObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxCommonProvider.UpdateItemRating(ratingManageObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateItemRating(ItemReviewBasicInfo ratingManageObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxCommonProvider.UpdateItemRating(ratingManageObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateUserProductReview(ItemReviewBasicInfo productReviewObj, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ItemID", productReviewObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("ItemReviewID", productReviewObj.ItemReviewID));
parameter.Add(new KeyValuePair <string, object>("RatingIDs", productReviewObj.RatingIDs));
parameter.Add(new KeyValuePair <string, object>("RatingValues", productReviewObj.RatingValues));
parameter.Add(new KeyValuePair <string, object>("ReviewSummary", productReviewObj.ReviewSummary));
parameter.Add(new KeyValuePair <string, object>("Review", productReviewObj.Review));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_GetUserProductReviewUpdate", parameter);
}
public void UpdateUserProductReview(ItemReviewBasicInfo productReviewObj, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@ItemID", productReviewObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("@ItemReviewID", productReviewObj.ItemReviewID));
parameter.Add(new KeyValuePair <string, object>("@RatingIDs", productReviewObj.RatingIDs));
parameter.Add(new KeyValuePair <string, object>("@RatingValues", productReviewObj.RatingValues));
parameter.Add(new KeyValuePair <string, object>("@ReviewSummary", productReviewObj.ReviewSummary));
parameter.Add(new KeyValuePair <string, object>("@Review", productReviewObj.Review));
parameter.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_GetUserProductReviewUpdate", parameter);
}
//---------------------update rating/ review Items From User DashBoard-----------------------
public static void UpdateItemRatingByUser(ItemReviewBasicInfo updateItemRatingObj, AspxCommonInfo aspxCommonObj)
{
try
{
OracleHandler sqlH = new OracleHandler();
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ReviewSummary", updateItemRatingObj.ReviewSummary));
parameter.Add(new KeyValuePair <string, object>("Review", updateItemRatingObj.Review));
parameter.Add(new KeyValuePair <string, object>("ItemReviewID", updateItemRatingObj.ItemReviewID));
parameter.Add(new KeyValuePair <string, object>("ItemID", updateItemRatingObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("UserBy", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_UpdateItemRatingByUser", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void UpdateItemRating(ItemReviewBasicInfo ratingManageObj, AspxCommonInfo aspxCommonObj)
{
try
{
OracleHandler sqlH = new OracleHandler();
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("RatingCriteriaValue", ratingManageObj.ItemRatingCriteria));
parameter.Add(new KeyValuePair <string, object>("StatusID", ratingManageObj.StatusID));
parameter.Add(new KeyValuePair <string, object>("ReviewSummary", ratingManageObj.ReviewSummary));
parameter.Add(new KeyValuePair <string, object>("Review", ratingManageObj.Review));
parameter.Add(new KeyValuePair <string, object>("ItemReviewID", ratingManageObj.ItemReviewID));
parameter.Add(new KeyValuePair <string, object>("ViewFromIP", ratingManageObj.ViewFromIP));
parameter.Add(new KeyValuePair <string, object>("ViewFromCountry", ratingManageObj.viewFromCountry));
parameter.Add(new KeyValuePair <string, object>("ItemID", ratingManageObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("UserBy", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_UpdateItemRating", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
public static void SaveItemRating(ItemReviewBasicInfo ratingSaveObj, AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@RatingCriteriaValue", ratingSaveObj.ItemRatingCriteria));
parameter.Add(new KeyValuePair<string, object>("@StatusID", ratingSaveObj.StatusID));
parameter.Add(new KeyValuePair<string, object>("@ItemReviewID", 0));
parameter.Add(new KeyValuePair<string, object>("@ReviewSummary", ratingSaveObj.ReviewSummary));
parameter.Add(new KeyValuePair<string, object>("@Review", ratingSaveObj.Review));
parameter.Add(new KeyValuePair<string, object>("@ViewFromIP", ratingSaveObj.ViewFromIP));
parameter.Add(new KeyValuePair<string, object>("@ViewFromCountry", ratingSaveObj.viewFromCountry));
parameter.Add(new KeyValuePair<string, object>("@ItemID", ratingSaveObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@UserName", ratingSaveObj.UserName));
parameter.Add(new KeyValuePair<string, object>("@AddedBy", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_SaveItemRating", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static void SaveItemRating(ItemReviewBasicInfo ratingSaveObj, AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@RatingCriteriaValue", ratingSaveObj.ItemRatingCriteria));
parameter.Add(new KeyValuePair <string, object>("@StatusID", ratingSaveObj.StatusID));
parameter.Add(new KeyValuePair <string, object>("@ItemReviewID", 0));
parameter.Add(new KeyValuePair <string, object>("@ReviewSummary", ratingSaveObj.ReviewSummary));
parameter.Add(new KeyValuePair <string, object>("@Review", ratingSaveObj.Review));
parameter.Add(new KeyValuePair <string, object>("@ViewFromIP", ratingSaveObj.ViewFromIP));
parameter.Add(new KeyValuePair <string, object>("@ViewFromCountry", ratingSaveObj.viewFromCountry));
parameter.Add(new KeyValuePair <string, object>("@ItemID", ratingSaveObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("@UserName", ratingSaveObj.UserName));
parameter.Add(new KeyValuePair <string, object>("@AddedBy", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_SaveItemRating", parameter);
}
catch (Exception e)
{
throw e;
}
}
//---------------------update rating/ review Items From User DashBoard-----------------------
public static void UpdateItemRatingByUser(ItemReviewBasicInfo updateItemRatingObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxUserDashProvider.UpdateItemRatingByUser(updateItemRatingObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateUserProductReview(ItemReviewBasicInfo productReviewObj, AspxCommonInfo aspxCommonObj)
{
AspxUserDashProvider.UpdateUserProductReview(productReviewObj, aspxCommonObj);
}
//---------------------update rating/ review Items From User DashBoard-----------------------
public static void UpdateItemRatingByUser(ItemReviewBasicInfo updateItemRatingObj, AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ReviewSummary", updateItemRatingObj.ReviewSummary));
parameter.Add(new KeyValuePair<string, object>("@Review", updateItemRatingObj.Review));
parameter.Add(new KeyValuePair<string, object>("@ItemReviewID", updateItemRatingObj.ItemReviewID));
parameter.Add(new KeyValuePair<string, object>("@ItemID", updateItemRatingObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@UserBy", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_UpdateItemRatingByUser", parameter);
}
catch (Exception e)
{
throw e;
}
}
//---------------------save rating/ review Items-----------------------
public void SaveItemRating(ItemReviewBasicInfo ratingSaveObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxRatingReviewController.SaveItemRating(ratingSaveObj, aspxCommonObj);
}
catch (Exception ex)
{
throw ex;
}
}
public static void UpdateUserProductReview(ItemReviewBasicInfo productReviewObj, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ItemID", productReviewObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@ItemReviewID", productReviewObj.ItemReviewID));
parameter.Add(new KeyValuePair<string, object>("@RatingIDs", productReviewObj.RatingIDs));
parameter.Add(new KeyValuePair<string, object>("@RatingValues", productReviewObj.RatingValues));
parameter.Add(new KeyValuePair<string, object>("@ReviewSummary", productReviewObj.ReviewSummary));
parameter.Add(new KeyValuePair<string, object>("@Review", productReviewObj.Review));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_GetUserProductReviewUpdate", parameter);
}
public static void UpdateUserProductReview(ItemReviewBasicInfo productReviewObj, AspxCommonInfo aspxCommonObj)
{
AspxUserDashProvider.UpdateUserProductReview(productReviewObj, aspxCommonObj);
}
public void UpdateUserProductReview(ItemReviewBasicInfo productReviewObj,AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@ItemID", productReviewObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@ItemReviewID", productReviewObj.ItemReviewID));
parameter.Add(new KeyValuePair<string, object>("@RatingIDs", productReviewObj.RatingIDs));
parameter.Add(new KeyValuePair<string, object>("@RatingValues", productReviewObj.RatingValues));
parameter.Add(new KeyValuePair<string, object>("@ReviewSummary", productReviewObj.ReviewSummary));
parameter.Add(new KeyValuePair<string, object>("@Review", productReviewObj.Review));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_GetUserProductReviewUpdate", parameter);
}
