private void AddAccountWithProfile(RaisinsContext _context, string userName, string password, string name, string title, string beneficiary) { if (!_context.Accounts.Any(a => a.UserName == userName)) { var role = _context.Roles.FirstOrDefault(r => r.Name == title); var salt = GetSalt(); var assigned = _context.Beneficiaries.FirstOrDefault(b => b.Name == beneficiary); List <Beneficiary> list = new List <Beneficiary>(); list.Add(assigned); Account account = new Account { UserName = userName, Salt = salt, Password = GetHash(password, salt), RoleID = role.RoleID, Profile = new AccountProfile { Name = name, Beneficiaries = list, IsLocal = true } }; _context.Accounts.Add(account); _context.SaveChanges(); } }
public void Seed(RaisinsContext context) { AddPayment(context, "payment1", 1000.5M, 1, 1, 1, "International", "Cash"); //1 AddPayment(context, "payment2", 2000.25M, 2, 1, 1, "Local", "PayPal"); //2 AddPayment(context, "payment3", 1500, 2, 1, 1, "International", "Bank Deposit"); //3 context.SaveChanges(); }
public void Seed(RaisinsContext context) { foreach (var seeder in Seeders) { seeder.Seed(context); } }
private void AddPayment(RaisinsContext context, string name, decimal amount, int beneficiaryID, int currencyID, int createdByID, string sourceName, string typeName) { if (!context.Payments.Any(c => c.Name == name)) { //context.Payments.Add(new Payment() //{ // Name = name, // Amount = amount, // BeneficiaryID = beneficiaryID, // CurrencyID = currencyID, // CreatedByID = createdByID //}); var source = context.Sources.FirstOrDefault(x => x.Source.ToLower() == sourceName.ToLower()); var type = context.Types.FirstOrDefault(x => x.Type.ToLower() == typeName.ToLower()); if (source == null) { throw new InvalidDataSeedException("Source not found!" + source); } if (type == null) { throw new InvalidDataSeedException("Type not found!" + type); } context.Payments.Add(new Payment() { Name = name, Amount = amount, BeneficiaryID = beneficiaryID, CurrencyID = currencyID, CreatedByID = createdByID, CreatedDate = DateTime.Now, PaymentDate = DateTime.Now, PaymentSourceID = source.PaymentSourceID, PaymentTypeID = type.PaymentTypeID }); //Payment payment = new Payment //{ // Name = name, // Amount = amount, // BeneficiaryID = beneficiaryID, // CurrencyID = currencyID, // CreatedByID = createdByID, // CreatedDate = DateTime.Now, // PaymentDate = DateTime.Now //}; //context.Payments.Add(payment); //context.SaveChanges(); } }
public void Seed(RaisinsContext context) { _context = context; AddAccount("Super", "1234", "Super", "super"); AddAccount("eugene", "1234", "Super Admin", "superadmin"); AddAccount("superuser", "1234", "Super User", "superuser"); //AddAccountWithProfile(context, "Super", "1234", "Super", "super", "Funny Is The New Pogi"); }
public void Seed(RaisinsContext context) { AddCurrency(context, "PHP", 1.0M, 50.0M); //1 AddCurrency(context, "USD", 44.0M, 1.0M); //2 AddCurrency(context, "AUD", 39.0M, 1.0M); //3 AddCurrency(context, "GBP", 71.0M, 1.0M); //4 AddCurrency(context, "HKD", 5.0M, 9.0M); //5 AddCurrency(context, "SGD", 34.0M, 2.0M); //6 AddCurrency(context, "EUR", 56.0M, 1.0M); //7 }
public void Seed(RaisinsContext context) { AddBeneficiary(context, "QaiTS", " NAV QA/TS "); //1 AddBeneficiary(context, "MANILEÑOS", "NAV Res Dev"); //2 AddBeneficiary(context, "The TimeJumpers", "NAV Product/Taleris"); //3 AddBeneficiary(context, "Funny Is The New Pogi", "NAV SS/PMO/Disney"); //4 AddBeneficiary(context, "OCSDO Angels", "SUS OC SDO , PMO, SS"); //5 AddBeneficiary(context, "The Chronicles of Naina", "SUS PM/NonRes/Res/BusinessGroups"); //6 AddBeneficiary(context, "*Group TBA*", "SUS IT/Installs/PMO/PerfMon/Security/BusOps"); //7 }
private void Addsource( RaisinsContext context, string source) { if (!context.Sources.Any(c => c.Source == source)) { context.Sources.Add(new PaymentSource() { Source = source }); } }
private void AddType( RaisinsContext context, string type) { if (!context.Types.Any(c => c.Type == type)) { context.Types.Add(new PaymentType() { Type = type }); } }
public void Seed(RaisinsContext context) { _context = context; AddRole("Administrator", "payments_lock;payments_unlock;payments_create_new;payments_view_summary"); AddRole("Accountant", "payments_view_summary"); AddRole("Manager", "payments_lock;payments_unlock;payments_create_new;payments_view_summary"); AddRole("User", "payments_create_new"); AddRole("SuperAccountant", "payments_view_list_all"); AddRole("SuperAdmininstrator", "beneficiaries_view;beneficiaries_create;beneficiaries_update;"); AddRole("SuperUser", "accounts_create;accounts_edit;acounts_view"); }
public void Seed(RaisinsContext context) { AddPayment(context, "payment1", 1000.5M, 1, 1, 1); //1 AddPayment(context, "payment2", 2000.25M, 2, 1, 1); //2 AddPayment(context, "payment3", 1500, 2, 1, 1); //3 AddPayment(context, "payment4", 1000, 2, 1, 1); //4 AddPayment(context, "payment5", 1050, 3, 1, 1); //5 AddPayment(context, "payment6", 1000.10M, 3, 1, 2); //6 AddPayment(context, "payment7", 1010, 3, 1, 2); //7 AddPayment(context, "payment8", 1000, 4, 1, 2); //8 AddPayment(context, "payment9", 1000, 5, 1, 2); //9 AddPayment(context, "payment10", 500, 6, 1, 3); //10 }
public void Seed(RaisinsContext context) { AddAccount(context, "marielle", "1234", "Marielle Lapidario", "Administrator"); AddAccount(context, "natraj", "1234", "Natraj Rajput", "Accountant"); AddAccount(context, "clarisse", "1234", "Clarisse Cheng", "Manager"); AddAccount(context, "danica", "1234", "Danica Sevilla", "User"); AddAccountWithProfile(context, "patricia", "1234", "patricia Honrado", "Accountant", "QaiTS"); AddAccountWithProfile(context, "gina", "1234", "Gina Co", "Accountant", "MANILEÑOS"); AddAccountWithProfile(context, "josiah", "1234", "Josiah Barretto", "Accountant", "The Chronicles of Naina"); AddAccount(context, "geraldine", "1234", "Geraldine Atayan", "SuperAccountant"); AddAccount(context, "edward", "1234", "Edward Cullen", "SuperAdmininstrator"); AddAccount(context, "jessica", "1234", "Jessica Sanches", "SuperUser"); }
private static void AddBeneficiary( RaisinsContext context, string name, string description) { if (!context.Beneficiaries.Any(b => b.Name == name)) { context.Beneficiaries.Add(new Beneficiary() { Name = name, Description = description }); } }
private void AddCurrency( RaisinsContext context, string name, decimal exchangeRate, decimal ratio) { if (!context.Currencies.Any(c => c.CurrencyCode == name)) { context.Currencies.Add(new Currency() { CurrencyCode = name, ExchangeRate = exchangeRate, Ratio = ratio }); } }
public void Seed(RaisinsContext context) { _context = context; AddRole("super", "payments_lock;payments_unlock;payments_create_new;payments_view_summary;" + "payments_create_new;" + "payments_view_list_all;payments_publish;" + "beneficiaries_view;beneficiaries_create;beneficiaries_update;" + "accounts_create;accounts_edit;accounts_view;" + "roles_view;roles_edit;roles_create"); AddRole("admin", "payments_lock;payments_unlock;payments_create_new;payments_view_summary"); AddRole("accountant", "payments_view_summary"); AddRole("manager", "payments_lock;payments_unlock;payments_create_new;payments_view_summary"); AddRole("user", "payments_create_new"); AddRole("superaccountant", "payments_view_list_all"); AddRole("superadmin", "beneficiaries_view;beneficiaries_create;beneficiaries_update"); AddRole("superuser", "accounts_create;accounts_edit;accounts_view"); }
private void AddPayment(RaisinsContext context, string name, decimal amount, int beneficiaryID, int currencyID, int createdByID) { if (!context.Payments.Any(c => c.Name == name)) { context.Payments.Add(new Payment() { Name = name, Amount = amount, BeneficiaryID = beneficiaryID, CurrencyID = currencyID, CreatedByID = createdByID }); } }
private void AddAccount(RaisinsContext _context, string userName, string password, string name, string title) { if (!_context.Accounts.Any(a => a.UserName == userName)) { var role = _context.Roles.FirstOrDefault(r => r.Name == title); var salt = GetSalt(); Account account = new Account { UserName = userName, Salt = salt, Password = GetHash(password, salt), RoleID = role.RoleID, Profile = new AccountProfile { Name = name } }; _context.Accounts.Add(account); _context.SaveChanges(); } }
public void Seed(RaisinsContext context) { Addsource(context, "Local"); Addsource(context, "International"); Addsource(context, "External"); }
public PaymentSourceRepository(RaisinsContext context) { _context = context; }
public TicketRepository(RaisinsContext context) { _context = context; }
public RoleForAccountRepository(RaisinsContext context) { _context = context; }
public ProfileRepository(RaisinsContext context) { _context = context; }
public void Seed(RaisinsContext context) { AddType(context, "Cash"); AddType(context, "Bank Deposit"); AddType(context, "PayPal"); }
public BeneficiaryForPaymentRepository(RaisinsContext context) { _context = context; }
public CurrencyRepository(RaisinsContext context) { _context = context; }
public BeneficiaryForTicketRepository(RaisinsContext context) { _context = context; }
public RoleRepository(RaisinsContext context) { _context = context; }
public MailQueueRepository(RaisinsContext context) { _context = context; }
public BeneficiaryRepository(RaisinsContext context) { _context = context; }