public CommentsInformation GetCommentInformationDetails(Hashtable listingCriteria)
{
var _db = new DBUtility();
var temp = new CommentsInformation();
var _dt = new DataTable();
_cmd = new SqlCommand();
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.CommandText = "GP_SP_GetCommentInformationDetails";
_cmd.Parameters.AddWithValue("@UserId", Convert.ToString(listingCriteria["UserID"]));
_cmd.Parameters.AddWithValue("@ListingDetailsID", Convert.ToInt64(listingCriteria["ID"]));
_dt = _db.FillDataTable(_cmd, _dt);
if (_dt.Rows.Count > 0)
{
foreach (DataRow dr in _dt.Rows)
{
temp.ID = Convert.ToInt64(dr["ID"]);
temp.Comments = Convert.ToString(dr["Comments"]);
temp.IsSellerOffering = Convert.ToBoolean(dr["IsSellerOffering"]);
temp.SellerOfferingPercentage = Convert.ToDouble(dr["SellerOfferingPercentage"]);
temp.ListingStatusID = Convert.ToInt32(dr["ListingStatusID"]);
}
}
return(temp);
}
public ActionResult SaveCommentsInformation(CommentsInformation model)
{
var serialization = new Serialization();
var listingsBA = new Listings();
long listingID = 0;
if (ModelState.IsValid)
{
Hashtable HashCriteria = new Hashtable();
HashCriteria.Add("ListingID", model.ID);
HashCriteria.Add("Comments", model.Comments);
HashCriteria.Add("IsSellerOffering", model.IsSellerOffering);
HashCriteria.Add("SellerOfferingPercentage", model.SellerOfferingPercentage);
HashCriteria.Add("UserID", userID);
var actualCriteria = serialization.SerializeBinary((object)HashCriteria);
var result = listingsBA.SaveCommentsInformation(actualCriteria);
listingID = Convert.ToInt64(serialization.DeSerializeBinary(Convert.ToString(result)));
}
else
{
return(PartialView("_Comments", model));
}
var ListingID = CipherTool.EncryptString(Convert.ToString(listingID), true);
var jsonResult = new[] {
new { ListingID = ListingID, ID = listingID },
};
return(Json(jsonResult, JsonRequestBehavior.AllowGet));
}
