public bool CompareToModel(StaffTitle model)
{
return(BeginDate == model.BeginDate &&
EndDate == model.EndDate &&
StaffId == model.StaffId &&
TitleId == model.TitleId);
}
public async Task CreateAsync(StaffTitle title)
{
using var ctx = new RestaurantContext();
await ctx.StaffTitles.AddAsync(title);
await ctx.SaveChangesAsync();
}
public void TestUpdateStaffTitleAsync()
{
ContextSeeders.Seed();
var boStaffRecord = new StaffRecordBusinessObject();
var staffRecord = boStaffRecord.List().Result.First();
var boTitle = new TitleBusinessObject();
var title = boTitle.List().Result.First();
var mbo = new StaffTitleBusinessObject();
var resList = mbo.List();
var item = resList.Result.FirstOrDefault();
var newRestaurant = new StaffTitle(staffRecord.Id, title.Id, DateTime.Parse("14/07/2020"), DateTime.Parse("14/07/2021"));
item.StartDate = newRestaurant.StartDate;
item.EndDate = newRestaurant.EndDate;
var resUpdate = mbo.UpdateAsync(item).Result;
resList = mbo.ListAsync().Result;
Assert.IsTrue(resList.Success && resUpdate.Success &&
resList.Result.First().StartDate == newRestaurant.StartDate &&
resList.Result.First().EndDate == newRestaurant.EndDate);
}
public StaffTitle ToModel(StaffTitle model)
{
model.BeginDate = BeginDate;
model.EndDate = EndDate;
model.StaffId = StaffId;
model.TitleId = TitleId;
return(model);
}
public ActionResult Create([FromBody] StaffTitleViewModel vm)
{
var st = new StaffTitle(vm.StaffRecordId, vm.TitleId, vm.StartDate, vm.EndDate);
var res = _bo.Create(st);
var code = res.Success ? HttpStatusCode.OK : HttpStatusCode.InternalServerError;
return(new ObjectResult(code));
}
public static StaffTitleViewModel Parse(StaffTitle restaurant)
{
return(new StaffTitleViewModel()
{
BeginDate = restaurant.BeginDate,
EndDate = restaurant.EndDate,
StaffId = restaurant.StaffId,
TitleId = restaurant.TitleId,
});
}
public static StaffTitleViewModel Parse(StaffTitle staffTitle)
{
return(new StaffTitleViewModel()
{
StaffRecordId = staffTitle.StaffRecordId,
TitleId = staffTitle.TitleId,
StartDate = staffTitle.StartDate,
EndDate = staffTitle.EndDate,
Id = staffTitle.Id
});
}
public void TestCreateAndReadStaffTitleRecordAsync()
{
RestaurantSeeder.SeedCountries();
var bo = new StaffTitleBusinessObject();
var tbo = new TitleBusinessObject();
var tl = tbo.List().Result.First();
var sbo = new StaffRecordBusinessObject();
var sr = sbo.List().Result.First();
var st = new StaffTitle(DateTime.Parse("2015/05/05"), DateTime.Parse("2020/05/05"), tl.Id, sr.Id);
var resCreate = bo.CreateAsync(st).Result;
var resGet = bo.ReadAsync(st.Id).Result;
Assert.IsTrue(resCreate.Success && resGet.Success && resGet.Result != null);
}
public void TestCreateStaffTitle()
{
ContextSeeders.Seed();
var boStaffRecord = new StaffRecordBusinessObject();
var staffRecord = boStaffRecord.List().Result.First();
var boTitle = new TitleBusinessObject();
var title = boTitle.List().Result.First();
var bo = new StaffTitleBusinessObject();
var staffTitle = new StaffTitle(staffRecord.Id, title.Id, DateTime.Parse("13/07/2020"), DateTime.Parse("13/07/2021"));;
var resCreate = bo.Create(staffTitle);
Assert.IsTrue(resCreate.Success);
}
public void TestCreateAndListStaffTitleAsync()
{
RestaurantSeeder.Seed();
var sbo = new StaffTitleBusinessObject();
var tbo = new TitleBusinessObject();
var srbo = new StaffRecordBusinessObject();
var t = tbo.ListAsync().Result.Result.First();
var sr = srbo.ListAsync().Result.Result.First();
var dr = new StaffTitle(DateTime.Now, DateTime.Now, sr.Id, t.Id);
var resCreate = sbo.CreateAsync(dr).Result;
var resGet = sbo.ReadAsync(dr.Id).Result;
Assert.IsTrue(resCreate.Success && resGet.Success && resGet.Result != null);
}
public OperationResult Delete(StaffTitle staffTitle)
{
try
{
_dao.Delete(staffTitle);
return(new OperationResult()
{
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = true, Exception = e
});
}
}
public OperationResult Create(StaffTitle item)
{
try
{
_dao.Create(item);
return(new OperationResult()
{
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = false, Exception = e
});
}
}
public virtual OperationResult Delete(StaffTitle staffTitle)
{
try
{
using var transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOptions, TransactionScopeAsyncFlowOption.Enabled);
_dao.Update(staffTitle);
transactionScope.Complete();
return(new OperationResult {
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = false, Exception = e
});
}
}
public async Task <OperationResult> CreateAsync(StaffTitle item)
{
try
{
await _dao.CreateAsync(item);
return(new OperationResult()
{
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = false, Exception = e
});
}
}
public async Task <OperationResult> DeleteAsync(StaffTitle staffTitle)
{
try
{
await _dao.DeleteAsync(staffTitle);
return(new OperationResult()
{
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = true, Exception = e
});
}
}
public async virtual Task <OperationResult> UpdateAsync(StaffTitle staffTitle)
{
try
{
using var transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOptions, TransactionScopeAsyncFlowOption.Enabled);
await _dao.UpdateAsync(staffTitle);
transactionScope.Complete();
return(new OperationResult <List <StaffTitle> > {
Success = true
});
}
catch (Exception e)
{
return(new OperationResult <List <StaffTitle> >()
{
Success = false, Exception = e
});
}
}
public async Task DeleteAsync(StaffTitle client)
{
client.IsDeleted = true;
await UpdateAsync(client);
}
public void Delete(StaffTitle client)
{
client.IsDeleted = true;
Update(client);
}
public async Task UpdateAsync(StaffTitle client)
{
_context.Entry(client).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public void Update(StaffTitle client)
{
_context.Entry(client).State = EntityState.Modified;
_context.SaveChanges();
}
public async Task CreateAsync(StaffTitle client)
{
await _context.StaffTitles.AddAsync(client);
await _context.SaveChangesAsync();
}
public void Create(StaffTitle client)
{
_context.StaffTitles.Add(client);
_context.SaveChanges();
}
public void Update(StaffTitle title)
{
using var ctx = new RestaurantContext();
ctx.Entry(title).State = EntityState.Modified;
ctx.SaveChanges();
}
public async Task UpdateAsync(StaffTitle title)
{
using var ctx = new RestaurantContext();
ctx.Entry(title).State = EntityState.Modified;
await ctx.SaveChangesAsync();
}
public void Delete(StaffTitle title)
{
title.IsDeleted = true;
Update(title);
}
public void Create(StaffTitle staffTitle)
{
_context.StaffTitle.Add(staffTitle);
_context.SaveChanges();
}
public async Task CreatAsync(StaffTitle staffTitle)
{
await _context.StaffTitle.AddAsync(staffTitle);
await _context.SaveChangesAsync();
}
public void Delete(StaffTitle staffTitle)
{
staffTitle.IsDeleted = true;
Update(staffTitle);
}
public async Task DeleteAsync(StaffTitle staffTitle)
{
staffTitle.IsDeleted = true;
await UpdateAsync(staffTitle);
}
public static void Seed()
{
using var _ctx = new RestaurantContext();
_ctx.Database.EnsureDeleted();
_ctx.Database.EnsureCreated();
var dr = new List <DietaryRestriction>()
{
new DietaryRestriction("Vegan"),
new DietaryRestriction("Vegetarian"),
new DietaryRestriction("Pescatarian"),
new DietaryRestriction("Omni")
};
var c = new List <Course>()
{
new Course("Entry"),
new Course("Main dish"),
new Course("Dessert"),
new Course("Drink")
};
var m = new List <Meal>()
{
new Meal("Breakfast", "8:00", "12:00"),
new Meal("Lunch", "12:00", "14:00"),
new Meal("Tea", "16:00", "17:00"),
new Meal("Dinner", "18:00", "21:00")
};
var p1 = new Person(DateTime.Now, "A", "B", 1203, 1203);
var r1 = new Restaurant("asd", "owewq", "123", "1232", "23ed", 4);
var cr1 = new ClientRecord(p1.Id, r1.Id, DateTime.Now);
var t1 = new Title("123", "4134", "woe");
var sr1 = new StaffRecord(p1.Id, r1.Id, DateTime.Now, DateTime.Now);
var st1 = new StaffTitle(DateTime.Now, DateTime.Now, sr1.Id, t1.Id);
var b1 = new Booking(DateTime.Now, cr1.Id);
var me = new List <Menu>()
{
new Menu(DateTime.Now, r1.Id, m[0].Id),
new Menu(DateTime.Now, r1.Id, m[1].Id),
new Menu(DateTime.Now, r1.Id, m[2].Id),
new Menu(DateTime.Now, r1.Id, m[3].Id)
};
var dsh = new List <Dish>
{
new Dish("Roasted Esparagus", dr[0].Id),
new Dish("Veggie Lasagna", dr[0].Id),
new Dish("Brownie Vegan", dr[0].Id),
new Dish("Poached Egg", dr[1].Id),
new Dish("Small Fish from the garden", dr[1].Id),
new Dish("Green Broth Sorbet", dr[1].Id),
new Dish("Toast and Fish Eggs", dr[2].Id),
new Dish("CodFish at Joseph Small Barrel", dr[2].Id),
new Dish("Sardine Panacotta", dr[2].Id),
new Dish("Beef Tartar", dr[3].Id),
new Dish("Female Gardner", dr[3].Id),
new Dish("Camel's Drool", dr[3].Id)
};
var se = new List <Serving>()
{
new Serving(me[0].Id, dsh[0].Id, c[0].Id),
new Serving(me[0].Id, dsh[1].Id, c[1].Id),
new Serving(me[0].Id, dsh[2].Id, c[2].Id),
new Serving(me[0].Id, dsh[3].Id, c[0].Id),
new Serving(me[0].Id, dsh[4].Id, c[1].Id),
new Serving(me[0].Id, dsh[5].Id, c[2].Id),
new Serving(me[0].Id, dsh[6].Id, c[0].Id),
new Serving(me[0].Id, dsh[7].Id, c[1].Id),
new Serving(me[0].Id, dsh[8].Id, c[2].Id),
new Serving(me[0].Id, dsh[9].Id, c[0].Id),
new Serving(me[0].Id, dsh[10].Id, c[1].Id),
new Serving(me[0].Id, dsh[11].Id, c[2].Id)
};
_ctx.DietaryRestrictions.AddRange(dr);
_ctx.ClientRecords.AddRange(cr1);
_ctx.StaffRecords.AddRange(sr1);
_ctx.StaffTitles.AddRange(st1);
_ctx.Restaurants.AddRange(r1);
_ctx.Servings.AddRange(se);
_ctx.Bookings.AddRange(b1);
_ctx.Dishes.AddRange(dsh);
_ctx.Courses.AddRange(c);
_ctx.Titles.AddRange(t1);
_ctx.People.AddRange(p1);
_ctx.Meals.AddRange(m);
_ctx.Menus.AddRange(me);
_ctx.SaveChanges();
}
