public TransactionItem(Transaction tran)
{
Amount = tran.Amount;
Description = tran.Description;
CreatedDate = tran.CreatedDate;
IsStartAmount = tran.StartTransaction;
}
public ActionResult Create(Transaction transaction)
{
if (ModelState.IsValid)
{
transaction.AccountID = 1;
db.Transactions.Add(transaction);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(transaction);
}
public JsonResult AddTransaction(Transaction transaction)
{
if (transaction.ID == 0)
{
db.Transactions.Add(transaction);
}
else
{
db.Entry(transaction).State = EntityState.Modified;
}
db.SaveChanges();
return Json(transaction);
}
public ViewResult Add(int id)
{
Recurring recur = db.Recurrings.Find(id);
if (recur != null)
{
Transaction tran = new Transaction();
int daydiff = recur.StartDate.Day - DateTime.Now.Day;
tran.CreatedDate = DateTime.Now.AddDays(daydiff);
tran.Description = recur.Description;
tran.Amount = recur.Amount;
return View("Create", tran);
}
return View("Create");
}
public void AddRecurringItemsToTransaction()
{
List<int> ids = (from a in db.Users
orderby a.AccountID
select a.AccountID).Distinct().ToList();
foreach (var accountId in ids)
{
List<Recurring> allRecurring = db.Recurrings.Where(r => r.AccountID == accountId).ToList();
if (allRecurring != null)
{
int daysbetweenrecuring = 14;
foreach (var r in allRecurring)
{
if (r.RecurWeekly)
daysbetweenrecuring = 7;
Transaction startTransaction = db.Transactions.Where(t => t.StartTransaction).FirstOrDefault();
DateTime maxDate = DateTime.Now;
DateTime now = r.StartDate.Date;
while (now <= maxDate)
{
if (r.RecurMontly)
{
DateTime recurDate = DateTime.Parse(String.Format("{0}/{1}/{2}", now.Month, r.StartDate.Day, now.Year));
if (now.Date == recurDate)
{
List<Transaction> transactions = db.Transactions.Where(x => x.CreatedDate == now && x.Description == r.Description).ToList();
if (transactions == null || transactions.Count == 0)
{
Transaction tran = new Transaction();
tran.Amount = r.Amount;
tran.CreatedDate = recurDate;
tran.Description = r.Description;
tran.AccountID = accountId;
db.Transactions.Add(tran);
db.SaveChanges();
}
}
now = now.AddMonths(1);
}
else
{
List<Transaction> transactions = db.Transactions.Where(x => x.CreatedDate == now && x.Description == r.Description).ToList();
if (transactions == null || transactions.Count == 0)
{
Transaction tran = new Transaction();
tran.Amount = r.Amount;
tran.CreatedDate = now.Date;
tran.Description = r.Description;
tran.AccountID = accountId;
db.Transactions.Add(tran);
db.SaveChanges();
}
now = now.AddDays(daysbetweenrecuring);
}
}
}
}
}
}
public ActionResult Edit(Transaction transaction)
{
if (ModelState.IsValid)
{
transaction.AccountID = 1;
db.Entry(transaction).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(transaction);
}
