public static bool AddBookRating(MilkRatings milkrating)
{
string sql =
"INSERT MilkRatings (MilkId,UserId,Rating,Comment)" +
"VALUES (@MilkId, @UserId, @Rating, @Comment)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@MilkId", milkrating.MilkId),
new SqlParameter("@UserId", milkrating.User.Id),
new SqlParameter("@Rating", milkrating.Rating),
new SqlParameter("@Comment", milkrating.Comment)
};
int newId = DBHelper.GetScalar(sql, para);
if (newId > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
private static IList <MilkRatings> GetMilkRatings(string safeSql)
{
List <MilkRatings> list = new List <MilkRatings>();
try
{
DataTable table = DBHelper.GetDataSet(safeSql);
foreach (DataRow row in table.Rows)
{
MilkRatings mrating = new MilkRatings();
mrating.Id = (int)row["Id"];
mrating.MilkId = (int)row["MilkId"];
mrating.Rating = (int)row["Rating"];
int userId = (int)row["UserId"];
mrating.User = UserService.GetAdminUserById(userId);
mrating.Comment = (string)row["Comment"];
list.Add(mrating);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
protected void btnAddComment_Click(object sender, EventArgs e)
{
MilkRatings rating = new MilkRatings();
int bid = int.Parse(ViewState["MilkId"].ToString());
rating.MilkId = bid;
rating.Rating = rtBook.CurrentRating;
rating.Comment = txbComment.Text;
if (Session["AdminUser"] != null)
{
Users currentUser = (Users)Session["AdminUser"];
rating.User = currentUser;
}
else
{
Response.Redirect("~/LoginUpdateProgress.aspx");
}
MilkRatingManager.AddMilkRating(rating);
lblRating.Text = "";
txbComment.Text = "";
DisplayMilkInfo(bid);
}
public static bool AddMilkRating(MilkRatings milkrating)
{
return(MilkRatingService.AddBookRating(milkrating));
}
