public void AddContributor(Contributor c)
{
using (var ctx = new EventDbDataContext(_connString))
{
ctx.Contributors.InsertOnSubmit(c);
ctx.SubmitChanges();
}
}
public void RemoveContribution(int contrId, int eventId)
{
using (var ctx = new EventDbDataContext(_connString))
{
ctx.Contributions.DeleteOnSubmit(ctx.Contributions.First(c => c.ContributorId == contrId && c.EventId == eventId));
ctx.SubmitChanges();
}
}
public void EditContributor(Contributor c)
{
using (var ctx = new EventDbDataContext(_connString))
{
ctx.Contributors.Attach(c);
ctx.Refresh(RefreshMode.KeepCurrentValues, c);
ctx.SubmitChanges();
}
}
public int Deposit(int id, int amount, DateTime date)
{
using (var ctx = new EventDbDataContext(_connString))
{
ctx.Deposits.InsertOnSubmit(new Deposit
{
ContributorId = id,
Date = date,
Amount = amount
});
ctx.SubmitChanges();
return(GetContributorBalance(id));
}
}
public void AddEventContribution(int contributorId, int eventId, int amount)
{
using (var ctx = new EventDbDataContext(_connString))
{
ctx.Contributions.InsertOnSubmit(new Contribution
{
ContributorId = contributorId,
EventId = eventId,
Date = DateTime.Now,
ContributionAmount = amount
});
ctx.SubmitChanges();
}
}
public void UpdateContributionAmount(int contributorId, int eventId, int amount)
{
using (var ctx = new EventDbDataContext(_connString))
{
var contr = new Contribution
{
ContributionAmount = amount,
EventId = eventId,
ContributorId = contributorId
};
ctx.Contributions.Attach(contr);
ctx.Refresh(RefreshMode.KeepCurrentValues, contr);
ctx.SubmitChanges();
}
}
public void AddEvent(Event ev)
{
if (ev.EventHost == null ||
ev.Date == null)
{
return;
}
using (var ctx = new EventDbDataContext(_connString))
{
ctx.Events.InsertOnSubmit(new Event
{
EventHost = ev.EventHost,
Date = ev.Date,
Total = 0
});
ctx.SubmitChanges();
}
}
