public static Meal LoadById(Guid id)
{
try
{
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
tblMeal row = dc.tblMeals.FirstOrDefault(g => g.Id == id);
if (row != null)
{
Meal meal = new Meal
{
Id = row.Id,
UserId = row.UserId,
Description = row.Description,
Time = row.Time,
FoodItems = FoodItemManager.Load(row.Id)
};
return(meal);
}
else
{
throw new Exception("Row was not found!");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
internal NewGuestViewModel(NewGuestView view, string ordererPersonalNo)
{
this.view = view;
Meals = LoadMeals();
selectedMeal = new tblMeal();
Meal = new tblMeal();
newOrder = new tblOrder();
orderedMeals = new List <tblMealOrder>();
this.ordererPersonalNo = ordererPersonalNo;
}
public void LoadTest()
{
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
DbContextTransaction transaction = null;
tblMeal row = dc.tblMeals.FirstOrDefault(m => m.Description == "Ate 4 eggs");
Assert.IsTrue(row != null);
transaction.Rollback();
}
}
public void DeleteTest()
{
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
DbContextTransaction transaction = null;
tblMeal row = dc.tblMeals.FirstOrDefault(m => m.Description == "Ate 4 eggs");
dc.tblMeals.Remove(row);
Assert.IsTrue(dc.SaveChanges() == 1);
transaction.Rollback();
}
}
public ActionResult SubmitMeal(List <UserCheckedDAO> us, FormCollection f)
{
Thread.Sleep(2000);
int sl = us.Count(i => i.IsChecked == true);
float money = float.Parse(f.Get("money").ToString());
string des = f.Get("description");
string res = "";
tblUser actor = (tblUser)Session["User"];
if (money % 1000 != 0 || money < 1000)
{
return(Content("Erro! Nhập tiền sai! "));
}
tblMeal meal = new tblMeal();
meal.Datetime = DateTime.Now;
meal.Totalmoney = money;
meal.Description = des;
meal.IDActor = actor.ID;
meal.Status = false;
db.tblMeals.Add(meal);
db.SaveChanges();
foreach (UserCheckedDAO it in us)
{
if (it.IsChecked)
{
var tempu = db.tblUsers.FirstOrDefault(i => i.ID == it.UserChecked.ID);
tblUser_Meal um = new tblUser_Meal();
um.IDMeal = meal.ID;
um.IDUser = it.UserChecked.ID;
um.Status = false;
db.tblUser_Meal.Add(um);
db.SaveChanges();
res += " " + tempu.Fullname;
}
}
res += "trung bình: " + money / sl;
return(Content("Gửi yêu cầu tính tiền cho: " + res));
}
public static int Insert(Meal meal, bool rollback = false)
{
try
{
int results;
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
DbContextTransaction transaction = null;
if (rollback)
{
transaction = dc.Database.BeginTransaction();
}
// Make a new row
tblMeal row = new tblMeal();
// Set the properties
row.Id = Guid.NewGuid();
row.UserId = meal.UserId;
row.Description = meal.Description;
row.Time = meal.Time;
// Back fill the Id on the object (parameter)
meal.Id = row.Id;
// Insert the row
dc.tblMeals.Add(row);
results = dc.SaveChanges();
//insert the food items
FoodItemManager.InsertList(meal.FoodItems, meal.Id);
if (rollback)
{
transaction.Rollback();
}
}
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertTest()
{
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
DbContextTransaction transaction = null;
tblMeal row = new tblMeal
{
Id = Guid.NewGuid(),
Description = "Ate 4 eggs",
Time = DateTime.Now,
UserId = dc.tblUsers.FirstOrDefault(m => m.FirstName == "Phillip").Id
};
dc.tblMeals.Add(row);
Assert.IsTrue(dc.SaveChanges() == 1);
transaction.Rollback();
}
}
public static int Update(Meal meal, bool rollback = false)
{
//Update Row
try
{
int results;
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
DbContextTransaction transaction = null;
if (rollback)
{
transaction = dc.Database.BeginTransaction();
}
//New Table Object for row
tblMeal row = dc.tblMeals.FirstOrDefault(g => g.Id == meal.Id);
if (row != null)
{
//Set properties
row.UserId = meal.UserId;
row.Description = meal.Description;
row.Time = meal.Time;
results = dc.SaveChanges();
meal.FoodItems.ForEach(f => FoodItemManager.Update(f));
if (rollback)
{
transaction.Rollback();
}
}
else
{
throw new Exception("Row was not found!!");
}
return(results);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Delete(Meal meal, bool rollback = false)
{
try
{
int results;
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
DbContextTransaction transaction = null;
if (rollback)
{
transaction = dc.Database.BeginTransaction();
}
//New Table Object for row
tblMeal row = dc.tblMeals.FirstOrDefault(g => g.Id == meal.Id);
if (row != null)
{
//Delete object
dc.tblMeals.Remove(row);
results = dc.SaveChanges();
if (rollback)
{
transaction.Rollback();
}
}
else
{
throw new Exception("Row was not found!!");
}
return(results);
}
}
catch (Exception ex)
{
throw ex;
}
}
