public ActionResult AddBill(UtilityBillsModelView collection)
{
string userId = User.Identity.GetUserId();
DB_Entities db = new DB_Entities();
var count = db.Bills.Where(x => x.UserId == userId && x.Title == collection.Title && x.InstituteId == collection.InstituteId).Count();
if (!(count > 0))
{
string filename = Path.GetFileNameWithoutExtension(collection.Image.FileName);
string ext = Path.GetExtension(collection.Image.FileName);
filename = filename + DateTime.Now.Millisecond.ToString();
filename = filename + ext;
string filetodb = "/Bills/" + filename;
filename = Path.Combine(Server.MapPath("~/Files/Bills/"), filename);
collection.Image.SaveAs(filename);
collection.Photo = filetodb;
Bill ub = new Bill()
{
Title = collection.Title,
InstituteId = collection.InstituteId,
Date = collection.Date,
DateAdded = DateTime.Now,
Image = collection.Photo,
Amount = collection.Amount,
UserId = userId
};
db.Bills.Add(ub);
db.SaveChanges();
Alerts.BillsAdded = true;
return(RedirectToAction("ViewUtilityBills", "DashBoard"));
}
Alerts.Exist = true;
return(RedirectToAction("AddBill", "DashBoard"));
}
public ActionResult ViewUtilityBills(DateViewModel date)
{
List <double> amountlist = new List <double>();
DB_Entities db = new DB_Entities();
string userId = User.Identity.GetUserId();
var bills = db.Bills.Where(x => x.UserId == userId).Where(y => y.Date > date.startDate && y.Date < date.endDate).ToList <Bill>();
List <UtilityBillsModelView> billsview = new List <UtilityBillsModelView>();
foreach (var i in bills as List <Bill> )
{
UtilityBillsModelView ub = new UtilityBillsModelView()
{
Id = i.Id,
InstituteName = GetInstituteName(i.InstituteId),
Title = i.Title,
Amount = Convert.ToDouble(i.Amount),
Photo = i.Image,
Date = Convert.ToDateTime(i.Date)
};
billsview.Add(ub);
amountlist.Add(Convert.ToDouble(i.Amount));
}
ViewData["totalamount"] = amountlist.Sum();
ViewData["bills"] = billsview;
return(View());
}
public ActionResult ViewBill(int?id)
{
DB_Entities db = new DB_Entities();
var bill = db.Bills.Where(x => x.Id == id).FirstOrDefault();
UtilityBillsModelView Bill = new UtilityBillsModelView()
{
Title = bill.Title,
InstituteName = GetInstituteName(bill.InstituteId),
Amount = Convert.ToDouble(bill.Amount),
Date = Convert.ToDateTime(bill.Date),
Photo = bill.Image
};
ViewData["bill"] = Bill;
return(View());
}