public ActionResult AddDocument(DocumentViewModel doc)
{
string userId = User.Identity.GetUserId();
DB_Entities db = new DB_Entities();
var count = db.Documents.Where(x => x.UserId == userId && x.Title == doc.Title && x.InstituteId == doc.InstituteId).Count();
if (!(count > 0))
{
string filename = Path.GetFileNameWithoutExtension(doc.Image.FileName);
string ext = Path.GetExtension(doc.Image.FileName);
filename = filename + DateTime.Now.Millisecond.ToString();
filename = filename + ext;
string filetodb = "/Docs/" + filename;
filename = Path.Combine(Server.MapPath("~/Files/Docs/"), filename);
doc.Image.SaveAs(filename);
doc.Photo = filetodb;
Document document = new Document()
{
Title = doc.Title,
DateAdded = DateTime.Now,
Date = doc.Date,
UserId = userId,
InstituteId = doc.InstituteId,
Image = doc.Photo
};
db.Documents.Add(document);
db.SaveChanges();
Alerts.DocumentAdded = true;
return(RedirectToAction("Document", "DashBoard"));
}
Alerts.Exist = true;
return(RedirectToAction("ViewDocuments", "DashBoard"));
}
public ActionResult Create(ContactViewModel collection, int id)
{
try
{
DB_Entities db = new DB_Entities();
Contact con = new Contact()
{
ContactNumber = collection.ContactNumber,
PersonId = id,
Type = collection.Type,
};
db.Contacts.Add(con);
var person = db.People.Where(x => x.PersonId == collection.PersonId).First();
person.UpdateOn = DateTime.Now;
db.SaveChanges();
Alerts.alert = "contact_added";
return(Redirect(string.Format("~/Contact/PersonContacts/{0}", id.ToString())));
}
catch
{
Alerts.alert = "contact_failed_to_add";
return(Redirect(string.Format("~/Contact/PersonContacts/{0}", id.ToString())));
}
}
public ActionResult AddReciept(RecieptViewModel collection)
{
string userId = User.Identity.GetUserId();
DB_Entities db = new DB_Entities();
var count = db.Reciepts.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 = "/Reciepts/" + filename;
filename = Path.Combine(Server.MapPath("~/Files/Reciepts/"), filename);
collection.Image.SaveAs(filename);
collection.Photo = filetodb;
Reciept res = new Reciept()
{
Title = collection.Title,
InstituteId = collection.InstituteId,
Date = collection.Date,
DateAdded = DateTime.Now,
Image = collection.Photo,
Amount = collection.Amount,
UserId = userId
};
db.Reciepts.Add(res);
db.SaveChanges();
Alerts.RecieptAdded = true;
return(RedirectToAction("ViewReciepts", "DashBoard"));
}
Alerts.Exist = true;
return(RedirectToAction("AddReciept", "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 string GetInstituteName(int?id)
{
DB_Entities db = new DB_Entities();
var ins = db.Institutes.Where(x => x.Id == id).FirstOrDefault();
return(ins.Name);
}
// GET: Person/Details/5
public ActionResult Details(int id)
{
DB_Entities db = new DB_Entities();
var person = db.People.Where(x => x.PersonId == id);
List <Person> p = new List <Person>();
foreach (var i in person)
{
var pp = new Person()
{
FirstName = i.FirstName,
MiddleName = i.MiddleName,
LastName = i.LastName,
DateOfBirth = i.DateOfBirth,
EmailId = i.EmailId,
HomeAddress = i.HomeAddress,
ImagePath = i.ImagePath,
HomeCity = i.HomeCity,
};
p.Add(pp);
}
ViewData["f"] = p;
return(View());
}
public ActionResult Edit(int id, PersonViewModel collection)
{
try
{
DB_Entities db = new DB_Entities();
var person = db.People.Where(x => x.PersonId == id).First();
person.FirstName = collection.FirstName;
person.MiddleName = collection.MiddleName;
person.LastName = collection.LastName;
person.DateOfBirth = collection.DateOfBirth;
person.EmailId = collection.EmailId;
person.HomeAddress = collection.HomeAddress;
person.HomeCity = collection.HomeCity;
person.UpdateOn = DateTime.Now;
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 = "/Image/" + filename;
filename = Path.Combine(Server.MapPath("~/Image/"), filename);
collection.Image.SaveAs(filename);
person.ImagePath = filetodb;
person.UpdateOn = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// GET: Person
public ActionResult Index()
{
string id = User.Identity.GetUserId().ToString();
DB_Entities db = new DB_Entities();
List <Person> pvm = new List <Person>();
var pr = db.People.Where(x => x.AddedBy == id);
foreach (var i in pr)
{
Person p = new Person()
{
PersonId = i.PersonId,
FirstName = i.FirstName,
MiddleName = i.MiddleName,
LastName = i.LastName,
DateOfBirth = i.DateOfBirth,
AddedOn = i.AddedOn,
AddedBy = i.AddedBy,
HomeAddress = i.HomeAddress,
HomeCity = i.HomeCity,
ImagePath = i.ImagePath,
EmailId = i.EmailId
};
pvm.Add(p);
}
return(View(pr));
}
public ActionResult Login(Userlogin aUserlogin)
{
if (ModelState.IsValid)
{
using (DB_Entities db = new DB_Entities())
{
var obj =
db.Users.Where(
a => a.UserName.Equals(aUserlogin.userName) && a.Password.Equals(aUserlogin.Password))
.FirstOrDefault();
if (obj != null)
{
Session["UserID"] = obj.Id.ToString();
Session["UserName"] = obj.UserName.ToString();
Session["UserRole"] = obj.UserRole.ToString();
return(RedirectToAction("Index", "Home"));
}
else
{
// ViewBag.Message = "invalid user name or password";
ModelState.AddModelError("", "Invalid User Name or Password");
}
}
}
return(View(aUserlogin));
}
public ActionResult DeleteInstitude(int id)
{
DB_Entities db = new DB_Entities();
var ins = db.Institutes.Where(x => x.Id == id).FirstOrDefault();
var doc = db.Documents.Where(x => x.InstituteId == id).ToList <Document>();
var utl = db.Bills.Where(x => x.InstituteId == id).ToList <Bill>();
var rec = db.Reciepts.Where(x => x.InstituteId == id).ToList <Reciept>();
foreach (var i in doc)
{
db.Entry(i).State = System.Data.Entity.EntityState.Deleted;
}
foreach (var i in utl)
{
db.Entry(i).State = System.Data.Entity.EntityState.Deleted;
}
foreach (var i in rec)
{
db.Entry(i).State = System.Data.Entity.EntityState.Deleted;
}
db.SaveChanges();
db.Entry(ins).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
Alerts.InstitudeDeleted = true;
return(RedirectToAction("ViewInstitude", "DashBoard"));
}
/////update
///
public ActionResult Edit(int id, User vv)
{
using (var context = new DB_Entities())
{
var data = context.Users.Where(x => x.idUser == id).SingleOrDefault();
return(View(data));
}
}
// GET: DashBoard
public ActionResult Index()
{
List <DateTime> birthdaydays = BirthDays();
List <DateTime> lastSevenDays = LastSevenDays();
List <PersonViewModel> birthdayBoys = new List <PersonViewModel>();
DB_Entities db = new DB_Entities();
var persons = db.People;
foreach (var i in persons)
{
foreach (DateTime j in birthdaydays)
{
if (j.Day == Convert.ToDateTime(i.DateOfBirth).Day&& j.Month == Convert.ToDateTime(i.DateOfBirth).Month)
{
PersonViewModel p = new PersonViewModel()
{
FirstName = i.FirstName,
MiddleName = i.MiddleName,
LastName = i.LastName,
PersonId = i.PersonId,
EmailId = i.EmailId,
ImagePath = i.ImagePath,
};
birthdayBoys.Add(p);
}
}
}
List <Person> updatedPerson = new List <Person>();
foreach (var i in persons)
{
foreach (DateTime j in lastSevenDays)
{
if (j.Day == Convert.ToDateTime(i.UpdateOn).Day&& j.Month == Convert.ToDateTime(i.UpdateOn).Month)
{
Person p = new Person()
{
FirstName = i.FirstName,
MiddleName = i.MiddleName,
LastName = i.LastName,
PersonId = i.PersonId,
EmailId = i.EmailId,
ImagePath = i.ImagePath,
};
updatedPerson.Add(p);
}
}
}
Alerts.person = updatedPerson;
return(View(birthdayBoys));
}
/////////show members
///
public ActionResult Members(int id, DB_Entities mm)
{
string tempo = id.ToString();
var results = mm.Users.Where(x => x.REvent == tempo).ToList();
return(View(results));
}
public ActionResult AddReciept()
{
string userId = User.Identity.GetUserId();
DB_Entities db = new DB_Entities();
var institutes = db.Institutes.Where(x => x.UserId == userId).ToList <Institute>();
ViewData["institutes"] = institutes;
return(View());
}
public ActionResult EditInstitude(int id)
{
DB_Entities db = new DB_Entities();
var institude = db.Institutes.Where(x => x.Id == id).FirstOrDefault();
ViewData["institude_name"] = institude.Name;
ViewData["institude_id"] = institude.Id;
return(View());
}
public ActionResult info(DB_Entities mm)
{
string test = @Session["Email"].ToString();
var results = mm.Users.Where(x => x.Email == test).ToList();
// var results = mm.Users.ToList();
return(View(results));
}
public ActionResult DeleteBill(int?id)
{
DB_Entities db = new DB_Entities();
var bill = db.Bills.Where(x => x.Id == id).FirstOrDefault();
db.Entry(bill).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
Alerts.BillsDeleted = true;
return(RedirectToAction("ViewUtilityBills", "DashBoard"));
}
public ActionResult DeleteDocument(int id)
{
DB_Entities db = new DB_Entities();
var doc = db.Documents.Where(x => x.Id == id).FirstOrDefault();
db.Entry(doc).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
Alerts.DocumentDeleted = true;
return(RedirectToAction("ViewDocuments", "DashBoard"));
}
public ActionResult UpdateInstitude(InstituteViewModel ins, int id)
{
DB_Entities db = new DB_Entities();
var institite = db.Institutes.Where(x => x.Id == id).FirstOrDefault();
institite.Name = ins.Title;
db.SaveChanges();
Alerts.InstitudeUpdated = true;
return(RedirectToAction("ViewInstitude", "DashBoard"));
}
public ActionResult DeleteReciept(int?id)
{
DB_Entities db = new DB_Entities();
var reciept = db.Reciepts.Where(x => x.Id == id).FirstOrDefault();
db.Entry(reciept).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
Alerts.RecieptDeleted = true;
return(RedirectToAction("ViewReciepts", "DashBoard"));
}
public ActionResult Delete(int id)
{
DB_Entities db = new DB_Entities();
var toBeDeleted = (from ev in db.Moments where ev.id == id select ev).First();
db.Entry(toBeDeleted).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(new JsonResult {
Data = new Dictionary <string, object> {
{ "id", toBeDeleted.id }
}
});
}
public ActionResult Create(PersonViewModel collection)
{
try
{
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 = "/Image/" + filename;
filename = Path.Combine(Server.MapPath("~/Image/"), filename);
collection.Image.SaveAs(filename);
collection.ImagePath = filetodb;
Person pr = new Person()
{
FirstName = collection.FirstName,
MiddleName = collection.MiddleName,
LastName = collection.LastName,
DateOfBirth = collection.DateOfBirth,
HomeAddress = collection.HomeAddress,
HomeCity = collection.HomeCity,
EmailId = collection.EmailId,
AddedOn = DateTime.Now,
AddedBy = User.Identity.GetUserId(),
ImagePath = collection.ImagePath,
UpdateOn = DateTime.Now,
};
Contact con = new Contact()
{
ContactNumber = collection.Number,
Type = collection.type
};
using (DB_Entities db = new DB_Entities())
{
db.People.Add(pr);
db.Contacts.Add(con);
db.SaveChanges();
Alerts.alert = "person_added";
return(RedirectToAction("Index"));
}
}
catch
{
return(Content("Failed"));
}
}
public ActionResult numberOfContects(int id)
{
DB_Entities db = new DB_Entities();
var count = 0;
var contacts = db.Contacts.Where(x => x.PersonId == id);
foreach (var i in contacts)
{
count++;
}
return(Json(count, JsonRequestBehavior.AllowGet));
}
public IEnumerable <dynamic> All()
{
using (var ctx = new DB_Entities())
{
return(ctx.Images.Select(x => new
{
x.ID,
x.Url,
x.Name,
x.RequestCount,
Page = ((x.ID / pageSize) + 1),
}).ToList());
}
}
public ActionResult Resize(int id, string newStart, string newEnd)
{
DB_Entities db = new DB_Entities();
var toBeResized = (from ev in db.Moments where ev.id == id select ev).First();
toBeResized.starttime = Convert.ToDateTime(newStart);
toBeResized.endtime = Convert.ToDateTime(newEnd);
db.SaveChanges();
return(new JsonResult {
Data = new Dictionary <string, object> {
{ "id", toBeResized.id }
}
});
}
public ActionResult ViewDocument(int?id)
{
DB_Entities db = new DB_Entities();
var document = db.Documents.Where(x => x.Id == id).FirstOrDefault();
DocumentViewModel doc = new DocumentViewModel()
{
Title = document.Title,
InstituteName = GetInstituteName(document.InstituteId),
Date = Convert.ToDateTime(document.Date),
Photo = document.Image,
};
ViewData["document"] = doc;
return(View());
}
public List <loginModel> ProductData()
{
List <loginModel> objProduct = new List <loginModel>();
DB_Entities objDemoEntities = new DB_Entities();
var ProductItem = from data in objDemoEntities.tbl_AdminLogin select data;
foreach (var item in ProductItem)
{
objProduct.Add(new loginModel {
UsernName = item.UserName,
Password = item.PassWord
});
}
return(objProduct);
}
public async Task <IHttpActionResult> Create(ImagesModel model)
{
using (var ctx = new DB_Entities())
{
ctx.Images.AddRange(model.data.Select(x => new Image
{
Name = x.Name,
Url = x.Url,
}));
await ctx.SaveChangesAsync();
}
return(Ok());
}
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());
}
public ActionResult ViewReciept(int?id)
{
DB_Entities db = new DB_Entities();
var bill = db.Reciepts.Where(x => x.Id == id).FirstOrDefault();
RecieptViewModel reciept = new RecieptViewModel()
{
Title = bill.Title,
InstituteName = GetInstituteName(bill.InstituteId),
Amount = Convert.ToDouble(bill.Amount),
Date = Convert.ToDateTime(bill.Date),
Photo = bill.Image
};
ViewData["reciept"] = reciept;
return(View());
}
