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; }