public void Seed(RaisinsDB context)
{
foreach (var seeder in Seeders)
{
seeder.Seed(context);
}
}
public List<MailQueue> GetMailers()
{
var db = new RaisinsDB();
var mails = db.MailQueues.Take(10);
var items = mails.ToList();
db.MailQueues.RemoveRange(mails);
db.SaveChanges();
db.Dispose();
return items;
}
private static void AddActivity(RaisinsDB context, string activityName, params string[] roleNames)
{
if (!context.Activities.Any(a => a.Name == activityName))
{
Activity newActivity = new Activity() { Name = activityName };
List<Role> roles = new List<Role>();
foreach (string roleName in roleNames)
{
roles.Add(Role.Find(roleName));
}
newActivity.Roles = roles;
Activity.Add(newActivity);
}
}
private static void AddAdmin(
RaisinsDB context,
string userName,
string password,
string name)
{
if (!context.Accounts.Any(a => a.UserName == userName))
{
var role = Role.Find("Administrator");
var beneficiaries = Beneficiary.GetAll();
var currencies = Currency.GetAll();
Account.CreateUser(userName, password, new List<Role>() { role }, new AccountProfile()
{
Name = name,
Beneficiaries = beneficiaries,
Currencies = currencies
});
}
}
private static void AddAccountant(
RaisinsDB context,
string userName,
string password,
string name,
int beneficiaryId,
int currencyId)
{
if (!context.Accounts.Any(a => a.UserName == userName))
{
var role = Role.Find("Accountant");
var beneficiary = Beneficiary.Find(beneficiaryId);
var currency = Currency.Find(currencyId);
Account.CreateUser(userName, password, new List<Role>() { role }, new AccountProfile()
{
Name = name,
Beneficiaries = new List<Beneficiary>() { beneficiary },
Currencies = new List<Currency>() { currency }
});
}
}
public void Seed(RaisinsDB context)
{
#region Administrators
AddAdmin(context, "admin", "@dmin!23", "Developer Accounts");
AddAdmin(context, "mendozg", "mendozg!23", "Gen Mendoza");
AddAdmin(context, "delacle", "delacle!23", "Lei dela Cruz");
AddAdmin(context, "pascuaa", "pascuaa!23", "Arla Pascual");
#endregion
#region Accountants/Auditors
AddAccountant(context, "linggay", "linggay!23", "Gayle Ling", 1, 1);
AddAccountant(context, "jaraban", "jaraban!23", "Noreen Jaraba", 1, 1);
AddAccountant(context, "pardoja", "pardoja!23", "Jazel Pardo", 2, 1);
AddAccountant(context, "logicam", "logicam!23", "Mia Logica", 3, 1);
AddAccountant(context, "macalim", "macalim!23", "Dianne Macalintal", 5, 1);
AddAccountant(context, "candalm", "candalm!23", "Marlo Candaliza", 6, 1);
AddAccountant(context, "evangec", "evangec!23", "Charry Evangelista", 4, 1);
AddAccountant(context, "soriajo", "soriajo!23", "Jan Alvin Soria", 4, 1);
#endregion
#region Users
AddUser(context, "cadizbl", "cadizbl!23", "Bless Cadiz", 4, 1);
AddUser(context, "tagapag", "tagapag!23", "Grace Tagapan", 4, 1);
AddUser(context, "gabriem", "gabriem!23", "Leslie Gabriel", 4, 1);
AddUser(context, "corteza", "corteza!23", "Aldrin Cortrez", 3, 1);
AddUser(context, "pascuac", "pascuac!23", "Carmelyn Pascual", 3, 1);
AddUser(context, "perezan", "perezan!23", "Venerando Perez", 5, 1);
AddUser(context, "padernj", "padernj!23", "John Carlos Padernal", 5, 1);
AddUser(context, "quillas", "quillas!23", "Shane Quillan", 6, 1);
AddUser(context, "bolalie", "bolalie!23", "Eliza Bolalin", 6, 1);
AddUser(context, "decastt", "decastt!23", "Teodore De Castro", 6, 1);
AddUser(context, "leonorw", "leonorw!23", "William Leonor", 1, 1);
AddUser(context, "vidallu", "vidallu!23", "Lui Vidal", 1, 1);
AddUser(context, "evangel", "evangel!23", "Lesley Evangelista", 2, 1);
#endregion
}
public void Seed(RaisinsDB context)
{
AddActivity(context, "Payment.Edit", "Administrator", "User");
AddActivity(context, "Payment.Lock", "Administrator", "Accountant");
AddActivity(context, "Home.Dashboard", "Administrator");
}
public TicketRepository(RaisinsDB raisinsDb)
{
_raisinsDb = raisinsDb;
}
public PaymentRepository(RaisinsDB raisinsDb)
{
_raisinsDb = raisinsDb;
}
public ExecutiveRepository(RaisinsDB raisinsDb)
{
_raisinsDb = raisinsDb;
}
public MailQueuesRepository(RaisinsDB raisinsDb)
{
_raisinsDb = raisinsDb;
}
public ActivityRepository(RaisinsDB raisinsDb)
{
_raisinDb = raisinsDb;
}
public BeneficiaryRepository(RaisinsDB raisinsDb)
{
_raisinsDb = raisinsDb;
}
public CurrencyRepository(RaisinsDB raisinsDB)
{
_raisinsDb = raisinsDB;
}
public void Seed(RaisinsDB context)
{
#region Administrators
AddAdmin(context, "admin", "@dmin!23", "Developer Accounts");
AddAdmin(context, "mendozg", "mendozg!23", "Gen Mendoza");
AddAdmin(context, "delacle", "delacle!23", "Lei dela Cruz");
AddAdmin(context, "pascuaa", "pascuaa!23", "Arla Pascual");
AddAdmin(context, "delosrd", "delosrd!23", "Danica Delos Reyes");
#endregion
#region Accountants/Auditors
//Group 1 QAiTS
AddAccountant(context, "adacrue", "adacrue!23", " Edhiko Adacruz", 1, 1);
AddAccountant(context, "andagda", "andagda!23", "Danielito Andag", 1, 1);
AddAccountant(context, "catigum", "catigum!23", " Michelle Rodrigo", 1, 1);
//Group 2 QAiTS Manileños
AddAccountant(context, "linggay", "linggay!23", " Gayle Udelle Ling", 2, 1);
AddAccountant(context, "jaraban", "jaraban!23", "Noreen Jaraba", 2, 1);
//Group 3 The TimeJumpers
AddAccountant(context, "seejoan", "seejoan!23", "Joan See", 3, 1);
AddAccountant(context, "paguiad", "paguiad!23", "Dominic John Paguia", 3, 1);
// AddAccountant(context, "Navarro", "Navarro!23", "Mai Navarro", 3, 1); //same type of user
//Group 4 Funny is the New Pogi
AddAccountant(context, "tanjoan", "tanjoan", "Joan Tan", 4, 1);
AddAccountant(context, "espirip", "espirip!23", "Pam Espiritu", 4, 1);
//Group 5 OCSDO Angels
AddAccountant(context, "evangel", "evangel!23", "Lesley Evangelista", 5, 1);
AddAccountant(context, "dizonro", "dizonro!23", "Roberto Dizon", 5, 1);
//Group 6 The Chronicles of Naina
AddAccountant(context, "cortesf", "cortesf!23", "Francis Pio Cortes", 6, 1);
AddAccountant(context, "lomedag", "lomedag!23", "Geronimo Lomeda, Jr.", 6, 1);
//Group 7 *TBA
#endregion
#region Users
//Group 1 QAiTS
AddUser(context, "trinidp", "trinidp!23", "Paolo Trinidad", 1, 1);
AddUser(context, "lumawim", "lumawim!23", "Mark Lester Lumawig", 1, 1);
AddUser(context, "soriajo", "soriajo!23", "Japs Soria", 1, 1);
AddUser(context, "logicam", "logicam!23", "Mia Logica", 1, 1);
AddUser(context, "jugosja", "jugosja!23", "Jason Jugos", 1, 1);
AddUser(context, "mundoma", "mundoma!23", "Trina Mundo", 1, 1);
//Group 2 Manileños
AddUser(context, "galsiml", "galsiml!23", "Leah Galsim", 2, 1);
AddUser(context, "domingb", "domingb!23", "Bon Domingo", 2, 1);
//Group 3 The TimeJumpers
AddUser(context, "navarrs", "navarrs!23", "Mai Navarro", 3, 1);
AddUser(context, "micukas", "micukas!23", "Kass Micu", 3, 1);
AddUser(context, "tobiasa", "tobiasa!23", "Angie Tobias", 3, 1);
AddUser(context, "taagkar", "taagkar!23", "Karl Alex Taag", 3, 1);
AddUser(context, "cadizbl", "cadizbl!23", "Blesilda Cadiz", 3, 1);
AddUser(context, "soanjer", "soanjer!23", "Jeremiah Soan", 3, 1);
//Group 4 Funny is the New Pogi
AddUser(context, "macalim", "macalim!23", "Dianne Macalintal", 4, 1);
AddUser(context, "miharam", "miharam!23", "Myra Mihara", 4, 1);
AddUser(context, "chiujef", "chiujef!23", "Jeff Chiu", 4, 1);
AddUser(context, "raymunk", "raymunk!23", "Kris Raymundo", 4, 1);
//Group 5 OCSDO Angels
AddUser(context, "macalim", "macalim!23", "Lorreyn Joy Orbeta", 5, 1);
AddUser(context, "contrer", "contrer!23", "Rizelle Contreras", 5, 1);
AddUser(context, "medrani", "medrani!23", "Izza Medrano", 5, 1);
AddUser(context, "dalidka", "dalidka!23", "Maria Karla Dalid", 5, 1);
AddUser(context, "gabriee", "gabriee!23", "Jelynne Gabriel", 5, 1);
//Group 6 The Chronicles of Naina
AddUser(context, "pardoja ", "pardoja !23", "Jazel Pardo", 6, 1);
AddUser(context, "fernanp", "fernanp!23", "Paula Bianca Fernandez", 6, 1);
AddUser(context, "tarcenm ", "tarcenm ", "Michelle Tarcena", 6, 1);
//Group 7 *TBA
#endregion
}
public static void Seed(RaisinsDB context)
{
using (var db = ObjectProvider.CreateDB())
{
if (db.Roles.Count() == 0)
{
db.Roles.Add(new Role() { Name = "Administrator" });
db.Roles.Add(new Role() { Name = "Accountant" });
db.Roles.Add(new Role() { Name = "Manager" });
db.Roles.Add(new Role() { Name = "User" });
db.SaveChanges();
}
if (db.Activities.Count() == 0)
{
db.Activities.Add(new Activity()
{
Name = "Payment.Edit",
Roles = new List<Role>()
{
db.Roles.First(r => r.Name == "Administrator"),
db.Roles.First(r => r.Name == "User")
}
});
db.Activities.Add(new Activity()
{
Name = "Payment.Lock",
Roles = new List<Role>()
{
db.Roles.First(r => r.Name == "Administrator"),
db.Roles.First(r => r.Name == "Accountant"),
}
});
db.SaveChanges();
}
if (db.Beneficiaries.Count() == 0)
{
db.Beneficiaries.Add(new Beneficiary() { Description = "Globetrotters", Name = "Globetrotters" });
db.Beneficiaries.Add(new Beneficiary() { Description = "Juan", Name = "Juan" });
db.Beneficiaries.Add(new Beneficiary() { Description = "EMEA", Name = "EMEA" });
db.Beneficiaries.Add(new Beneficiary() { Description = "PALMERICAS", Name = "PALMERICAS" });
db.Beneficiaries.Add(new Beneficiary() { Description = "The SUSpects", Name = "The SUSpects" });
db.SaveChanges();
}
//if (db.Executives.Count() == 0)
//{
// db.Executives.Add(new Executive() { Name = "Dave Evans" });
// db.Executives.Add(new Executive() { Name = "Chuck Maahs" });
// db.Executives.Add(new Executive() { Name = "Kurt Blumberg" });
// db.SaveChanges();
//}
if (db.Currencies.Count() == 0)
{
db.Currencies.Add(new Currency() { CurrencyCode = "PHP", ExchangeRate = 1, Ratio = 50M });
db.Currencies.Add(new Currency() { CurrencyCode = "USD", ExchangeRate = 42, Ratio = 1M });
db.Currencies.Add(new Currency() { CurrencyCode = "AUD", ExchangeRate = 43, Ratio = 1M });
db.Currencies.Add(new Currency() { CurrencyCode = "SGD", ExchangeRate = 34, Ratio = 2M });
db.Currencies.Add(new Currency() { CurrencyCode = "HKD", ExchangeRate = 5, Ratio = 9M });
db.Currencies.Add(new Currency() { CurrencyCode = "EUR", ExchangeRate = 53, Ratio = 1M });
db.Currencies.Add(new Currency() { CurrencyCode = "GBP", ExchangeRate = 66, Ratio = 1M });
db.Currencies.Add(new Currency() { CurrencyCode = "NZD", ExchangeRate = 34, Ratio = 2M });
db.Currencies.Add(new Currency() { CurrencyCode = "MYR", ExchangeRate = 13, Ratio = 4M });
db.SaveChanges();
}
if (!Account.Exists("admin"))
{
//TODO: make this db based.
Account.CreateUser("admin", "P@ssw0rd!1",
new List<Role>()
{
db.Roles.First(r => r.Name == "Administrator")
},
new AccountProfile() { Name = "Administrator", IsLocal = false, Currencies = db.Currencies.ToList(), Beneficiaries = db.Beneficiaries.ToList() });
}
}
}
public RoleRepository(RaisinsDB raisinsDb)
{
_raisinsDb = raisinsDb;
}
