public void Add(D.Role role) { EF.Role efRole = ConvertToEF(role); _context.Roles.Add(efRole); _context.SaveChanges(); }
//TODO: payment.CreatedByID = Account.GetCurrentUser().ID; before edit payment public void Edit(D.Payment payment) { EF.Payment efpayment = ConverToEFwithID(payment); var tempPayment = _context.Payments.Single(a => a.PaymentID == efpayment.PaymentID); tempPayment.PaymentID = efpayment.PaymentID; tempPayment.Name = efpayment.Name; tempPayment.Amount = efpayment.Amount; tempPayment.BeneficiaryID = efpayment.BeneficiaryID; tempPayment.CurrencyID = efpayment.CurrencyID; tempPayment.Locked = efpayment.Locked; tempPayment.Email = efpayment.Email; //tempPayment.CreatedDate = efpayment.CreatedDate; //tempPayment.PaymentDate = efpayment.PaymentDate; tempPayment.ModifiedDate = efpayment.ModifiedDate; tempPayment.PublishDate = efpayment.PublishDate; tempPayment.CreatedByID = efpayment.CreatedByID; tempPayment.ModifiedByID = efpayment.ModifiedByID; tempPayment.PaymentSourceID = efpayment.PaymentSourceID; tempPayment.PaymentTypeID = efpayment.PaymentTypeID; tempPayment.OptOut = efpayment.OptOut; _context.SaveChanges(); }
public void Edit(D.Account account, D.AccountProfile profile) { EF.Account efAccount = ConvertToEFwithID(account, profile); //START var tempAccount = _context.Accounts.Single(a => a.AccountID == efAccount.AccountID); tempAccount.RoleID = efAccount.RoleID; var tempProfile = _context.Profiles.Single(p => p.ProfileID == efAccount.ProfileID); //remove beneficary foreach (var ben in tempProfile.Beneficiaries.ToArray()) { if (!efAccount.Profile.Beneficiaries.Any(b => b.BeneficiaryID == ben.BeneficiaryID)) { tempProfile.Beneficiaries.Remove(ben); } } //add beneficary foreach (var ben in efAccount.Profile.Beneficiaries) { if (!tempProfile.Beneficiaries.Any(b => b.BeneficiaryID == ben.BeneficiaryID)) { tempProfile.Beneficiaries.Add(ben); } } _context.SaveChanges(); }
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(); }
private void AddRole(string name, string permissions) { if (!_context.Roles.Any(r => r.Name == name)) { _context.Roles.Add(new Role() { Name = name, Permissions = permissions }); } _context.SaveChanges(); }
private void Addsource( RaisinsContext context, string source) { if (!context.Sources.Any(c => c.Source == source)) { context.Sources.Add(new PaymentSource() { Source = source }); context.SaveChanges(); } }
private void AddType( RaisinsContext context, string type) { if (!context.Types.Any(c => c.Type == type)) { context.Types.Add(new PaymentType() { Type = type }); context.SaveChanges(); } }
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 Add(MailQueue mailQueue) { _context.MailQueues.Add(ConvertToEF((mailQueue))); _context.SaveChanges(); }
//TODO: payment.CreatedByID = Account.GetCurrentUser().ID; before edit payment public void Edit(D.Payment payment) { EF.Payment efpayment = ConverToEFwithID(payment); _context.Entry(efpayment).State = EntityState.Modified; _context.SaveChanges(); }
public void Add(D.Ticket ticket) { _context.Tickets.Add(ConvertToEF(ticket)); _context.SaveChanges(); }