public async Task <ActionResult <Docket> > PostDocket(Docket docket)
{
_context.Dockets.Add(docket);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetDocket", new { id = docket.Id }, docket));
}
public async Task <IActionResult> Edit(int id, [Bind("ID,CreateDate,Accussed,AccussedDescription,Offense,DateOfOffense,Victim,AddressOfOffender,OfficerOnCase,InvestigativeOfficer")] Docket docket)
{
if (id != docket.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(docket);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DocketExists(docket.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(docket));
}
public async Task <IActionResult> PutDocket(int id, Docket docket)
{
if (id != docket.Id)
{
return(BadRequest());
}
_context.Entry(docket).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DocketExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Init()
{
_options = TestDbOptions.GetInMemoryOptions <SettingsContext>();
var context = new SettingsContext(_options);
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
_emrs = Builder <EmrSystem> .CreateListOfSize(2).Build().ToList();
_docket = Builder <Docket> .CreateNew().Build();
_iqcareExtract = Builder <Extract> .CreateNew().With(x => x.DocketId = _docket.Id).With(x => x.EmrSystemId = _emrs.First().Id).Build();
_iqcareExtract.ExtractSql = @"SELECT * FROM [AppAdmin]";
_kenyaExtract = Builder <Extract> .CreateNew().With(x => x.DocketId = _docket.Id).With(x => x.EmrSystemId = _emrs.Last().Id).Build();
_kenyaExtract.ExtractSql = @"SELECT * FROM psmart";
_mssql =
new DatabaseProtocol(DatabaseType.MicrosoftSQL, @".\koske14", "sa", "maun", "iqcare");
_mysql =
new DatabaseProtocol(DatabaseType.MySQL, @"localhost", "root", "root", "openmrs");
context.Add(_docket);
context.AddRange(_emrs);
context.AddRange(new List <Extract> {
_iqcareExtract, _kenyaExtract
});
context.SaveChanges();
}
// GET: Docket
public ActionResult Details(int Id)
{
Docket Docket = _context.Docket
.Include(d => d.Activities)
.Where(d => d.Id == Id)
.SingleOrDefault();
ViewBag.Title = "Activities List";
return(View(Docket));
}
public async Task <IActionResult> Create([Bind("ID,CreateDate,Accussed,AccussedDescription,Offense,DateOfOffense,Victim,AddressOfOffender,OfficerOnCase,InvestigativeOfficer")] Docket docket)
{
if (ModelState.IsValid)
{
_context.Add(docket);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(docket));
}
public ActionResult Create(string Title)
{
Docket Docket = new Docket();
var userID = User.Identity.GetUserId();
Docket.UserId = userID;
Docket.Title = Title;
_context.Docket.Add(Docket);
_context.SaveChanges();
Details(Docket.Id);
return(View("Details")); // pass thru the ID?
}
public ActionResult Add(ActivityDocketViewModel Advm) //this will have to change to the view model im using above?
{
Activities NewActivity = new Activities();
NewActivity.DocketId = Advm.Activities.DocketId;
NewActivity.Title = Advm.Title;
NewActivity.Lat = Advm.Activities.Lat;
NewActivity.Lng = Advm.Activities.Lng;
_context.Activities.Add(NewActivity);
_context.SaveChanges();
Docket Docket = _context.Docket
.Include(d => d.Activities)
.Where(d => d.Id == NewActivity.DocketId)
.SingleOrDefault();
ViewBag.Title = "Activities List";
return(RedirectToAction("Details", "Docket", Docket)); // pass thru the ID?
}
public async Task <IEnumerable <Docket> > PostDocket(IEnumerable <DocketViewModel> docketsViewModels)
{
var dockets = new List <Docket>();
// loop through the view models
// foreach on,
foreach (var vm in docketsViewModels)
{
// Attempt 1
//get the courthouse for your own database
var courthouse = await _context.Courthouses.FirstOrDefaultAsync(f => f.CourtHouseId == vm.CourthouseId);
// and set the courthouseid == id of the courthouse in your database
var docket = new Docket(vm)
{
CourthouseId = courthouse.Id
};
dockets.Add(docket);
}
_context.Dockets.AddRange(dockets);
await _context.SaveChangesAsync();
return(dockets);
}
