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