private void AddSampleIfNotExists(string line) { var values = line.Split(','); if (values.Length < 5) { return; } var barcode = values[1]; var createdAt = DateTime.Parse(values[2]); var createdBy = int.Parse(values[3]) + 1; // Because UserId in Users.txt begin 0 var statusId = int.Parse(values[4]) + 1; // Because StatusId in Statuses.txt begin 0 if (context.Samples.Any(s => s.Barcode == barcode)) { return; } context.Samples.Add(new Sample { Barcode = barcode, CreateAt = createdAt, CreateBy = createdBy, StatusId = statusId }); context.SaveChanges(); }
public async Task EnsureSeedData() { new DefaultUserCreator(context).Create(); new DefaultStatusesCreator(context).Create(); new DefaultSampleCreator(context).Create(); context.SaveChanges(); }
private void AddStatusIfNotExists(string line) { var values = line.Split(','); if (values.Length < 2) { return; } var description = values[1]; if (context.Statuses.Any(s => s.Description == description)) { return; } context.Statuses.Add(new Status { Description = description }); context.SaveChanges(); }
private void AddUserIfNotExists(string line) { var values = line.Split(','); if (values.Length < 3) { return; } var firstName = values[1]; var lastName = values[2]; if (context.Users.Any(s => s.FirstName == firstName && s.LastName == lastName)) { return; } context.Users.Add(new User { FirstName = firstName, LastName = lastName }); context.SaveChanges(); }
public override TPrimaryKey InsertAndGetId(TEntity entity) { entity = Insert(entity); dbContext.SaveChanges(); return(entity.Id); }