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