protected void Button1_Click(object sender, EventArgs e)
{
var DC = new DataClassesDataContext();
IQueryable <tblOrder> str = from obj in DC.tblOrders
where obj.MACAddress == GetMACAddress() && obj.ClientID == Convert.ToInt32(Session["ClientID"]) && (obj.IsActive == false || obj.IsActive == null) && obj.ItemID != null
select obj;
foreach (tblOrder item in str)
{
tblRate RateData = new tblRate();
RateData.FoodID = Convert.ToInt32(item.ItemID);
RateData.IsItem = true;
RateData.Point = Convert.ToInt32(txtRate.Value);
RateData.CreatedOn = DateTime.Now;
DC.tblRates.InsertOnSubmit(RateData);
DC.SubmitChanges();
}
IQueryable <tblOrder> str1 = from obj in DC.tblOrders
where obj.MACAddress == GetMACAddress() && obj.ClientID == Convert.ToInt32(Session["ClientID"]) && (obj.IsActive == false || obj.IsActive == null) && obj.MealID != null
select obj;
foreach (tblOrder item in str1)
{
tblRate RateData = new tblRate();
RateData.FoodID = Convert.ToInt32(item.MealID);
RateData.IsItem = false;
RateData.Point = Convert.ToInt32(txtRate.Value);
RateData.CreatedOn = DateTime.Now;
DC.tblRates.InsertOnSubmit(RateData);
DC.SubmitChanges();
}
}
public newAddItemForm(tblPhysio MyPhysio, tblRate MyRate, tblClaimant MyClaimant)
{
InitializeComponent();
myRate = MyRate;
myPhysio = MyPhysio;
myClaimant = MyClaimant;
}
public ActionResult Vote(int?id, int star)
{
HttpCookie member_cookie = Request.Cookies["member_id"];
tblUser user = db.tblUsers.Find(int.Parse(member_cookie.Value.ToString()));
if (db.tblRates.FirstOrDefault(t => t.Rate_Post == id && t.Rate_User == user.User_ID) != null)
{
db.tblRates.FirstOrDefault(t => t.Rate_Post == id && t.Rate_User == user.User_ID).Rate_Star = star;
}
else
{
tblRate addItem = new tblRate()
{
Rate_User = user.User_ID,
Rate_Star = star,
Rate_Post = id,
Rate_DateVote = DateTime.Now
};
db.tblRates.Add(addItem);
}
db.SaveChanges();
return(RedirectToAction("Details", new { id }));
}
