public async Task CreateAsync(StaffRecord record)
{
using var ctx = new RestaurantContext();
await ctx.StaffRecords.AddAsync(record);
await ctx.SaveChangesAsync();
}
public bool CompareToModel(StaffRecord model)
{
return(BeginDate == model.BeginDate &&
EndDate == model.EndDate &&
PersonId == model.PersonId &&
RestaurantId == model.RestaurantId);
}
public void TestCreateStaffRecordAsync()
{
ContextSeeders.Seed();
var srbo = new StaffRecordBusinessObject();
var pbo = new PersonBusinessObject();
var rbo = new RestaurantBusinessObject();
var lubo = new LennyouseUserBusinessObject();
var _lennyouseUser = new LennyouseUser(Guid.NewGuid());
lubo.Create(_lennyouseUser);
var _person = new Person(1234321, 23432456, "Marco", "Figueirnha", DateTime.UtcNow, _lennyouseUser.Id);
pbo.Create(_person);
var _restaurant = new Restaurant("Tasca do sol", "Bairro Alto 2", "12h", "00h", "Mondays", 3);
rbo.Create(_restaurant);
var _staffRecord = new StaffRecord(DateTime.UtcNow, DateTime.UtcNow, _person.Id, _restaurant.Id);
var resCreate = srbo.CreateAsync(_staffRecord).Result;
var resGet = srbo.ReadAsync(_staffRecord.Id).Result;
Assert.IsTrue(resCreate.Success && resGet.Success && resGet.Result != null);
}
// POST: api/Staff
public HttpResponseMessage Post([FromBody] StaffRecord staff)
{
services.AddStaff(staff);
services.SaveStaff();
//db.StaffRecords.Add(staff);
//db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
public StaffRecord ToModel(StaffRecord model)
{
model.PersonId = PersonId;
model.RestaurantId = RestaurantId;
model.BeginDate = BeginDate;
model.EndDate = EndDate;
return(model);
}
public ActionResult Create([FromBody] StaffRecordViewModel vm)
{
var sr = new StaffRecord(vm.BeginDate, vm.EndDate, vm.PersonId, vm.RestaurantId);
var res = _bo.Create(sr);
var code = res.Success ? HttpStatusCode.OK : HttpStatusCode.InternalServerError;
return(new ObjectResult(code));
}
public static StaffRecordViewModel Parse(StaffRecord staffRecord)
{
return(new StaffRecordViewModel()
{
Id = staffRecord.PersonId,
BeginDate = staffRecord.BeginDate,
EndDate = staffRecord.EndDate,
PersonId = staffRecord.PersonId
});
}
public static StaffRecordViewModel Parse(StaffRecord record)
{
return(new StaffRecordViewModel()
{
BeginDate = record.BeginDate,
EndDate = record.EndDate,
PersonId = record.PersonId,
RestaurantId = record.RestaurantId,
});
}
public ActionResult Create(StaffRecord staffRecord)
{
if (!ModelState.IsValid)
{
return(View());
}
carData.StaffRecords.Add(staffRecord);
carData.SaveChanges();
return(RedirectToAction("StaffList"));
}
public static StaffRecordViewModel Parse(StaffRecord Staff)
{
return(new StaffRecordViewModel()
{
Id = Staff.Id,
PersonId = Staff.PersonId,
RestaurantId = Staff.RestaurantId,
BeginDate = Staff.BeginDate,
EndDate = Staff.EndDate
});
}
public ActionResult Edit(StaffRecord staffRecord)
{
var orignalRecord = (from m in carData.StaffRecords where m.id == staffRecord.id select m).First();
if (!ModelState.IsValid)
{
return(View(orignalRecord));
}
carData.Entry(orignalRecord).CurrentValues.SetValues(staffRecord);
carData.SaveChanges();
return(RedirectToAction("StaffList"));
}
public void TestCreateAndReadStaffRecordAsync()
{
RestaurantSeeder.SeedCountries();
var bo = new StaffRecordBusinessObject();
var bop = new PersonBusinessObject();
var pe1 = bop.List().Result.First();
var bor = new RestaurantBusinessObject();
var rs1 = bor.List().Result.First();
var dr = new StaffRecord(DateTime.Parse("2020/05/05"), DateTime.Parse("2020/06/06"), pe1.Id, rs1.Id);
var resCreate = bo.CreateAsync(dr).Result;
var resGet = bo.ReadAsync(dr.Id).Result;
Assert.IsTrue(resCreate.Success && resGet.Success && resGet.Result != null);
}
public void TestCreateAndListStaffRecordAsync()
{
RestaurantSeeder.Seed();
var sbo = new StaffRecordBusinessObject();
var rbo = new RestaurantBusinessObject();
var pbo = new PersonBusinessObject();
var r = rbo.ListAsync().Result.Result.First();
var p = pbo.ListAsync().Result.Result.First();
var dr = new StaffRecord(p.Id, r.Id, DateTime.Now, DateTime.Now);
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(StaffRecord staffRecord)
{
try
{
_dao.Delete(staffRecord);
return(new OperationResult()
{
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = true, Exception = e
});
}
}
public OperationResult Create(StaffRecord item)
{
try
{
_dao.Create(item);
return(new OperationResult()
{
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = false, Exception = e
});
}
}
public virtual OperationResult Delete(StaffRecord staffRecord)
{
try
{
using var transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOptions, TransactionScopeAsyncFlowOption.Enabled);
_dao.Update(staffRecord);
transactionScope.Complete();
return(new OperationResult {
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = false, Exception = e
});
}
}
public async Task <OperationResult> DeleteAsync(StaffRecord staffRecord)
{
try
{
await _dao.DeleteAsync(staffRecord);
return(new OperationResult()
{
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = true, Exception = e
});
}
}
public async Task <OperationResult> CreateAsync(StaffRecord item)
{
try
{
await _dao.CreateAsync(item);
return(new OperationResult()
{
Success = true
});
}
catch (Exception e)
{
return(new OperationResult()
{
Success = false, Exception = e
});
}
}
public void TestUpdateStaffRecord()
{
ContextSeeders.Seed();
var srbo = new StaffRecordBusinessObject();
var resList = srbo.List();
var item = resList.Result.FirstOrDefault();
var pbo = new PersonBusinessObject();
var rbo = new RestaurantBusinessObject();
var lubo = new LennyouseUserBusinessObject();
var _lennyouseUser = new LennyouseUser(Guid.NewGuid());
lubo.Create(_lennyouseUser);
var _person = new Person(3654324444, 0000000, "Marco", "Figueirnha", DateTime.UtcNow, _lennyouseUser.Id);
pbo.Create(_person);
var _restaurant = new Restaurant("Tasca da Lua", "Bairro Alto 2", "12h", "00h", "Mondays", 7);
rbo.Create(_restaurant);
var _newStaffRecord = new StaffRecord(DateTime.UtcNow, DateTime.UtcNow, _person.Id, _restaurant.Id);
item.BeginDate = _newStaffRecord.BeginDate;
item.EndDate = _newStaffRecord.EndDate;
item.PersonId = _newStaffRecord.PersonId;
item.RestaurantId = _newStaffRecord.RestaurantId;
var resUpdate = srbo.Update(item);
resList = srbo.List();
Assert.IsTrue(resList.Success && resUpdate.Success &&
resList.Result.First().BeginDate == _newStaffRecord.BeginDate &&
resList.Result.First().EndDate == _newStaffRecord.EndDate &&
resList.Result.First().PersonId == _newStaffRecord.PersonId &&
resList.Result.First().RestaurantId == _newStaffRecord.RestaurantId
);
}
public async virtual Task <OperationResult> UpdateAsync(StaffRecord staffRecord)
{
try
{
using var transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOptions, TransactionScopeAsyncFlowOption.Enabled);
await _dao.UpdateAsync(staffRecord);
transactionScope.Complete();
return(new OperationResult <List <StaffRecord> > {
Success = true
});
}
catch (Exception e)
{
return(new OperationResult <List <StaffRecord> >()
{
Success = false, Exception = e
});
}
}
public async Task DeleteAsync(StaffRecord record)
{
record.IsDeleted = true;
await UpdateAsync(record);
}
public void Delete(StaffRecord record)
{
record.IsDeleted = true;
Update(record);
}
public async Task UpdateAsync(StaffRecord record)
{
using var ctx = new RestaurantContext();
ctx.Entry(record).State = EntityState.Modified;
await ctx.SaveChangesAsync();
}
public void Update(StaffRecord record)
{
using var ctx = new RestaurantContext();
ctx.Entry(record).State = EntityState.Modified;
ctx.SaveChanges();
}
public void Create(StaffRecord record)
{
using var ctx = new RestaurantContext();
ctx.StaffRecords.Add(record);
ctx.SaveChanges();
}
public void Delete(StaffRecord staffRecord)
{
staffRecord.IsDeleted = true;
Update(staffRecord);
}
public async Task UpdateAsync(StaffRecord staffRecord)
{
_context.Entry(staffRecord).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public void Update(StaffRecord staffRecord)
{
_context.Entry(staffRecord).State = EntityState.Modified;
_context.SaveChanges();
}
public async Task CreateAsync(StaffRecord staffRecord)
{
await _context.StaffRecords.AddAsync(staffRecord);
await _context.SaveChangesAsync();
}
public void Create(StaffRecord staffRecord)
{
_context.StaffRecords.Add(staffRecord);
_context.SaveChanges();
}
