private static void SeedInitialDataEmployees(ShelterDbContext context)
{
var data = GoogleService.ReadEntries(Constants.SheetEmployees);
if (data != null)
{
if (!context.Employees.Any())
{
var employees = new List <Employee>();
var first = true;
foreach (var row in data)
{
if (first)
{
first = false;
continue;
}
employees.Add(new Employee
{
Name = row[0].ToString(),
Surname = row[1].ToString(),
PhoneNumber = row[2].ToString(),
BirthDate = DateTime.ParseExact(row[3].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
Active = row[4].Equals("1"),
Position = Enum.Parse <Position>(row[5].ToString())
});
}
context.Employees.AddRange(employees);
context.SaveChanges();
}
}
}
private static void SeedInitialDataCustomers(ShelterDbContext context)
{
var data = GoogleService.ReadEntries(Constants.SheetCustomers);
if (data != null)
{
if (!context.Customers.Any())
{
var customers = new List <Customer>();
var first = true;
foreach (var row in data)
{
if (first)
{
first = false;
continue;
}
customers.Add(new Customer
{
Name = row[0].ToString(),
Surname = row[1].ToString(),
PhoneNumber = row[2].ToString(),
BirthDate = DateTime.ParseExact(row[3].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
});
}
context.Customers.AddRange(customers);
context.SaveChanges();
}
}
}
private static void SeedInitialDateTransactions(ShelterDbContext context)
{
var data = GoogleService.ReadEntries(Constants.SheetTransactions);
if (data != null)
{
var transactions = new List <Transaction>();
var first = true;
foreach (var row in data)
{
if (first)
{
first = false;
continue;
}
transactions.Add(new Transaction
{
Date = DateTime.ParseExact(row[0].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
Cost = Convert.ToDouble(row[1]) * (-1),
Type = TransactionType.Expenses
});
transactions.Add(new Transaction
{
Date = DateTime.ParseExact(row[0].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
Cost = Convert.ToDouble(row[2]),
Type = TransactionType.Budget
});
var salaries = context.Employees.Where(x => x.Active == true).Select(x => x.Position);
foreach (var salary in salaries)
{
transactions.Add(new Transaction
{
Date = DateTime.ParseExact(row[0].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
Cost = (int)Enum.Parse <Salaries>(salary.ToString()) * (-1),
Type = TransactionType.Salary
});
}
}
context.Transactions.AddRange(transactions);
context.SaveChanges();
}
}
private static void SeedInitialDataAnimals(ShelterDbContext context)
{
var data = GoogleService.ReadEntries(Constants.SheetAnimals);
if (data != null)
{
if (!context.Animals.Any())
{
var animals = new List <Animal>();
var first = true;
foreach (var row in data)
{
if (first)
{
first = false;
continue;
}
int?customerId = Convert.ToInt32(row[6]);
if (customerId.Equals(0))
{
customerId = null;
}
animals.Add(new Animal
{
Name = row[0].ToString(),
Age = Convert.ToInt32(row[1]),
Adopted = row[2].Equals("1"),
DateOfArrival = DateTime.ParseExact(row[3].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
Status = row[4].Equals("1"),
Feature = Enum.Parse <Feature>(row[5].ToString()),
Race = Enum.Parse <Race>(row[6].ToString()),
CustomerId = customerId
});
}
context.Animals.AddRange(animals);
context.SaveChanges();
}
}
}
private static void SeedInitialDataTreatments(ShelterDbContext context)
{
var data = GoogleService.ReadEntries(Constants.SheetTreatments);
if (data != null)
{
if (!context.Treatments.Any())
{
var treatments = new List <Treatment>();
var transactions = new List <Transaction>();
var first = true;
foreach (var row in data)
{
if (first)
{
first = false;
continue;
}
treatments.Add(new Treatment()
{
Date = DateTime.ParseExact(row[0].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
Cost = Convert.ToDouble(row[1]),
AnimalId = Convert.ToInt32(row[2]),
EmployeeId = Convert.ToInt32(row[3]),
Disease = Enum.Parse <Disease>(row[4].ToString())
});
transactions.Add(new Transaction
{
Date = DateTime.ParseExact(row[0].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
Cost = Convert.ToDouble(row[1]) * (-1),
Type = TransactionType.Treatment
});
}
context.Treatments.AddRange(treatments);
context.Transactions.AddRange(transactions);
context.SaveChanges();
}
}
}
private static void SeedInitialDataSponsorships(ShelterDbContext context)
{
var data = GoogleService.ReadEntries(Constants.SheetSponsorships);
if (data != null)
{
if (!context.Sponsorships.Any())
{
var sponsorships = new List <Sponsorship>();
var transactions = new List <Transaction>();
var first = true;
foreach (var row in data)
{
if (first)
{
first = false;
continue;
}
sponsorships.Add(new Sponsorship
{
Date = DateTime.ParseExact(row[0].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
Cost = Convert.ToDouble(row[1]),
VolunteerId = Convert.ToInt32(row[2])
});
transactions.Add(new Transaction
{
Date = DateTime.ParseExact(row[0].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
Cost = Convert.ToDouble(row[1]),
Type = TransactionType.Sponsoring
});
}
context.Sponsorships.AddRange(sponsorships);
context.Transactions.AddRange(transactions);
context.SaveChanges();
}
}
}
