public async Task <IActionResult> Create([Bind("ContactId,Address,Comment,EmailAddress,IsCustomer,IsSupplier,Name,PhoneNumber1,PhoneNumber2,PhoneNumber3,PhoneNumber4,Timestamp,VersionNumber")] Contact val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(val));
}
public async Task <IActionResult> Create([Bind("VehicleId,Comment,Name,RegistrationNumber,Timestamp,VersionNumber,WeightKg")] Vehicle val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(val));
}
public async Task <IActionResult> Create([Bind("EnumVehicleLifeEventTypeId,Comment,Description,Timestamp,VersionNumber")] EnumVehicleLifeEventType val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(val));
}
public async Task <IActionResult> Create([Bind("ProductId,Comment,DefaultVolume,Description,EnumProductTypeId,RequiresRefridgeration,Timestamp,VersionNumber")] Product val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["EnumProductTypeId"] = new SelectList(_context.EnumProductType, "EnumProductTypeId", "Description", val.EnumProductTypeId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("CritterImageId,Data")] CritterImage val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(val));
}
public async Task <IActionResult> Create([Bind("CritterLifeEventGiveBirthId,Comment,DateTime,Timestamp,VersionNumber")] CritterLifeEventDatetime val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(val));
}
public async Task <IActionResult> Create([Bind("TagId,Comment,CritterId,DateTime,Rfid,Tag1,Timestamp,UserId,VersionNumber")] Tag val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CritterId"] = new SelectList(_context.Critter, "CritterId", "CritterImageId", val.CritterId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("PoultryClassificationId,Comment,CritterTypeId,Timestamp,VersionNumber")] PoultryClassification val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CritterTypeId"] = new SelectList(_context.CritterType, "CritterTypeId", "Name", val.CritterTypeId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("HoldingId,Address,Comment,ContactId,GridReference,HoldingNumber,Postcode,RegisterForCows,RegisterForFish,RegisterForPigs,RegisterForPoultry,RegisterForSheepGoats,Timestamp,VersionNumber")] Holding val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ContactId"] = new SelectList(_context.Contact, "ContactId", "Name", val.ContactId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("AlUserInfoId,Comment,FirstName,LastName,PrivacyConsent,Timestamp,TosConsent")] AlUserInfo val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(val));
}
public async Task <IActionResult> Create([Bind("MenuItemId,Action,Comment,Controller,IconUri,RoleId,SequenceNumber,Timestamp,Title,VersionNumber")] MenuItem val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(val));
}
public async Task <IActionResult> Create([Bind("EnumCritterLifeEventTypeId,Comment,DataType,Description,EnumCritterLifeEventCategoryId,FlagCantReproduce,FlagEndOfSystem,FlagIllness,Timestamp,VersionNumber")] EnumCritterLifeEventType val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(val));
}
public async Task <IActionResult> Create([Bind("MenuHeaderId,ApplicationCode,Comment,ImageUri,MenuHeaderParentId,Name,RoleId,Timestamp,Title,VersionNumber")] MenuHeader val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MenuHeaderParentId"] = new SelectList(_context.MenuHeader, "MenuHeaderId", "Name", val.MenuHeaderParentId);
ViewData["RoleId"] = new SelectList(_context.Role, "RoleId", "Description", val.RoleId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("VehicleTrailerMapId,Comment,Timestamp,TrailerId,VehicleMainId,VersionNumber")] VehicleTrailerMap val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["TrailerId"] = new SelectList(_context.Vehicle, "VehicleId", "Name", val.TrailerId);
ViewData["VehicleMainId"] = new SelectList(_context.Vehicle, "VehicleId", "Name", val.VehicleMainId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("CritterImageVariantId,CritterImageModifiedId,CritterImageOriginalId,Height,Timestamp,Width")] CritterImageVariant val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CritterImageModifiedId"] = new SelectList(_context.CritterImage, "CritterImageId", "CritterImageId", val.CritterImageModifiedId);
ViewData["CritterImageOriginalId"] = new SelectList(_context.CritterImage, "CritterImageId", "CritterImageId", val.CritterImageOriginalId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("BreedId,BreedSocietyContactId,Comment,CritterTypeId,Description,Registerable,Timestamp,VersionNumber")] Breed val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["BreedSocietyContactId"] = new SelectList(_context.Contact, "ContactId", "Name", val.BreedSocietyContactId);
ViewData["CritterTypeId"] = new SelectList(_context.CritterType, "CritterTypeId", "Name", val.CritterTypeId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("MenuHeaderItemMapId,Comment,MenuHeaderId,MenuItemId,Timestamp,VersionNumber")] MenuHeaderItemMap val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MenuHeaderId"] = new SelectList(_context.MenuHeader, "MenuHeaderId", "Name", val.MenuHeaderId);
ViewData["MenuItemId"] = new SelectList(_context.MenuItem, "MenuItemId", "Title", val.MenuItemId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("CritterLifeEventId,Comment,CritterId,DateTime,Description,EnumCritterLifeEventDataId,EnumCritterLifeEventTypeId,Timestamp,VersionNumber")] CritterLifeEvent val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CritterId"] = new SelectList(_context.Critter, "CritterId", "CritterImageId", val.CritterId);
ViewData["EnumCritterLifeEventTypeId"] = new SelectList(_context.EnumCritterLifeEventType, "EnumCritterLifeEventTypeId", "Description", val.EnumCritterLifeEventTypeId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("ProductPurchaseId,BatchNumber,Comment,Cost,DateTime,Expiry,LocationId,ProductId,SupplierId,Timestamp,VersionNumber,Volume")] ProductPurchase val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["LocationId"] = new SelectList(_context.Location, "LocationId", "Name", val.LocationId);
ViewData["ProductId"] = new SelectList(_context.Product, "ProductId", "Description", val.ProductId);
ViewData["SupplierId"] = new SelectList(_context.Contact, "ContactId", "Name", val.SupplierId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("LocationId,Comment,EnumLocationTypeId,HoldingId,Name,ParentId,Timestamp,VersionNumber")] Location val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["EnumLocationTypeId"] = new SelectList(_context.EnumLocationType, "EnumLocationTypeId", "Description", val.EnumLocationTypeId);
ViewData["HoldingId"] = new SelectList(_context.Holding, "HoldingId", "Postcode", val.HoldingId);
ViewData["ParentId"] = new SelectList(_context.Location, "LocationId", "Name", val.ParentId);
return(View(val));
}
public async Task <IActionResult> Create([Bind("CritterId,BreedId,Comment,CritterImageId,CritterTypeId,DadCritterId,DadFurther,Flags,Gender,MumCritterId,MumFurther,Name,OwnerContactId,TagNumber,Timestamp,VersionNumber")] Critter val)
{
this.FixNullFields(val);
if (ModelState.IsValid)
{
_context.Add(val);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["BreedId"] = new SelectList(_context.Breed, "BreedId", "Description", val.BreedId);
ViewData["CritterImageId"] = new SelectList(_context.CritterImage, "CritterImageId", "CritterImageId", val.CritterImageId);
ViewData["CritterTypeId"] = new SelectList(_context.CritterType, "CritterTypeId", "Name", val.CritterTypeId);
ViewData["DadCritterId"] = new SelectList(_context.Critter, "CritterId", "CritterImageId", val.DadCritterId);
ViewData["MumCritterId"] = new SelectList(_context.Critter, "CritterId", "CritterImageId", val.MumCritterId);
ViewData["OwnerContactId"] = new SelectList(_context.Contact, "ContactId", "Name", val.OwnerContactId);
return(View(val));
}
/// <inheritdoc/>
public async Task <WeightTransaction> AddAsync(WeightTransaction item, CancellationToken cancellationToken)
{
_logger.LogInformation("Adding a new weight transaction for animal ({@AnimalId})", item.AnimalId);
ValidateAddAsyncParameters(item);
var transaction = new WeightTransactionModel
{
AnimalId = item.AnimalId,
TransactionDate = item.TransactionDate,
Weight = item.Weight
};
var changes = _context.WeightTransactions.Add(transaction);
await _context.SaveChangesAsync(cancellationToken).ConfigureAwait(false);
return(changes.Entity.MapToWeightTransaction());
}
/// <summary>
/// Adds an animal to the persisted store.
/// </summary>
/// <param name="item">The animal to be added.</param>
/// <param name="cancellationToken">A token that can be used to signal operation cancellation.</param>
/// <returns>The added animal.</returns>
public virtual async Task <IAnimal> AddAsync(IAnimal item, CancellationToken cancellationToken)
{
Logger.LogInformation("Adding an animal...");
var entity = AnimalMapper.Map(item);
var changes = await LivestockContext.AddAsync(entity, cancellationToken)
.ConfigureAwait(false);
await LivestockContext.SaveChangesAsync(cancellationToken)
.ConfigureAwait(false);
return(AnimalMapper.Map(changes.Entity));
}
/// <summary>
/// Removes the animal with an ID that matches the key value from the persisted store.
/// </summary>
/// <param name="key">The identifying value of the animal.</param>
/// <param name="cancellationToken">A token that can be used to signal operation cancellation.</param>
/// <returns>The ID of the animal that was removed.</returns>
/// <exception cref="EntityNotFoundException{AnimalModel}">When the animal with the given key is not found.</exception>
public virtual async Task <long> RemoveAsync(long key, CancellationToken cancellationToken)
{
Logger.LogInformation($"Removing the animal with ID {key}...");
var entity = await LivestockContext.Animals.FindAsync(new object[] { key }, cancellationToken)
.ConfigureAwait(false);
if (entity == null)
{
throw new EntityNotFoundException <AnimalModel>(key);
}
var changes = LivestockContext.Animals.Remove(entity);
await LivestockContext.SaveChangesAsync(cancellationToken)
.ConfigureAwait(false);
return(changes.Entity.Id);
}
/// <summary>
/// Updates the properties of an animal in the persisted store.
/// </summary>
/// <param name="item">The animal with its desired values.</param>
/// <param name="cancellationToken">A token that can be used to signal operation cancellation.</param>
/// <returns>The updated animal.</returns>
/// <exception cref="EntityNotFoundException{AnimalModel}">When the animal with the given key is not found.</exception>
public virtual async Task <IAnimal> UpdateAsync(IAnimal item, CancellationToken cancellationToken)
{
Logger.LogInformation($"Updating the animal with ID {item.Id}...");
var entity = await LivestockContext.Animals.FindAsync(new object[] { item.Id }, cancellationToken)
.ConfigureAwait(false);
if (entity == null)
{
throw new EntityNotFoundException <AnimalModel>(item.Id);
}
UpdateEntityValues(entity, item);
var changes = LivestockContext.Animals.Update(entity);
await LivestockContext.SaveChangesAsync(cancellationToken)
.ConfigureAwait(false);
return(AnimalMapper.Map(changes.Entity));
}
public static async Task SetRoleFor(this DataMapService <User> data, User user, RoleEnum role, LivestockContext db)
{
Contract.Requires(user != null);
Contract.Requires(data != null);
Contract.Requires(db != null);
var roleName = Convert.ToString(role).ToLower();
var dbRole = await db.Role.FirstOrDefaultAsync(r => r.Description == roleName);
if (dbRole == null)
{
dbRole = new Role
{
Comment = "N/A",
Description = roleName,
VersionNumber = 1
};
await db.Role.AddAsync(dbRole);
await db.SaveChangesAsync();
}
await data.SingleReference <Role>().SetAsync(user, dbRole);
}