// GET: Admin/Dashboard/System
public ActionResult System()
{
var adminViewModel = new AdminViewModels();
var dBType = ConfigurationManager.AppSettings["Repository"];
adminViewModel.DbType = dBType;
var dbinfo = _systemBusiness.GetDataBaseStatus();
adminViewModel.DbOnline = dbinfo.Online;
adminViewModel.DbName = dbinfo.Name;
adminViewModel.DbServer = dbinfo.Server;
var emailSetting = _settingsBusiness.GetEmailSetting();
adminViewModel.SupportEmailAdress = emailSetting.SupportEmailAddress;
adminViewModel.SmtpServerAdress = emailSetting.SmtpServerAdress;
adminViewModel.SmtpServerPort = emailSetting.SmtpServerPort.ToString();
adminViewModel.SendEMailEnabled = emailSetting.SendEMailEnabled.ToString();
adminViewModel.EMailConfirmationEnabled = emailSetting.EMailConfirmationEnabled.ToString();
if (_influxDbAgent.IsEnabled)
{
adminViewModel.InfluxDbEnabled = _influxDbAgent.IsEnabled;
adminViewModel.InfluxDbOnline = _influxDbAgent.CanConnect();
adminViewModel.InfluxDbUrl = _influxDbAgent.GetSetting().Url;
adminViewModel.InfluxDbName = _influxDbAgent.GetSetting().DatabaseName;
adminViewModel.InfluxDbVersion = _influxDbAgent.GetDatabaseVersion();
}
return(View(adminViewModel));
}
// GET: Admin
public ActionResult Index()
{
var users = UserManager.Users.ToList();
var roles = new List <string>();
foreach (var user in users)
{
string str = "";
var userRoles = UserManager.GetRoles(user.Id);
foreach (var role in userRoles)
{
str = (str == "") ? str = role.ToString() : str + " - " + role.ToString();
}
roles.Add(str);
}
var model = new AdminViewModels
{
Users = users.ToList(),
Roles = roles.ToList(),
CountOfCategories = GetCategoriesSelectList().Count(),
CountOfProducts = repository.Products.Count(),
CountOfUsers = users.Count()
};
return(View(model));
}
public ActionResult IndexEvenement()
{
AdminViewModels vm = new AdminViewModels();
List <Event> maListe = eventService.FindAll();
vm.MaListe = maListe;
return(View(vm));
}
public ActionResult IndexThemes()
{
AdminViewModels vm = new AdminViewModels();
List <Theme> maListe = themeService.FindAll();
vm.ListTheme = maListe;
return(View(vm));
}
public ActionResult AjoutTheme(AdminViewModels pVm)
{
if (ModelState.IsValid)
{
themeService.Create(pVm.MonTheme);
}
return(RedirectToAction("IndexThemes"));
}
public ActionResult AjoutEvent(AdminViewModels pVm)
{
Event MonEvent = pVm.MonEvent;
if (pVm.IdThemeSelected != 0)
{
pVm.MonEvent.Theme = themeService.Get(pVm.IdThemeSelected);
}
if (MonEvent.Id == 0)
{
ModelState.Remove("MonEvent.Id");
}
else
{
MonEvent = eventService.Get(MonEvent.Id);
}
if (ModelState.IsValid)
{
HttpFileCollectionBase photos = Request.Files;
if (MonEvent.Images == null)
{
MonEvent.Images = new List <EventImage>();
}
for (int i = 0; i < photos.Count; i++)
{
HttpPostedFileBase photo = photos[i];
if (photo.ContentLength > 0)
{
string name = MonEvent.Name + "_" + photo.FileName;
string path = Server.MapPath("~") + "\\Images\\" + name;
photo.SaveAs(path);
EventImage image = new EventImage();
image.Name = name;
image.Path = "\\Images\\" + name;
MonEvent.Images.Add(image);
}
}
if (MonEvent.Id != 0)
{
eventService.Update(MonEvent);
}
else
{
eventService.Create(MonEvent);
}
}
else
{
return(RedirectToAction("AjouterEvenement", new { pID = pVm.MonEvent.Id }));
}
return(RedirectToAction("IndexEvenement"));
}
public ActionResult AdminHomePage(string username, string password, string admid, string checkedOut, string returned, string emailSent, string balanceUpdated)
{
booktrackingdbEntities db = new booktrackingdbEntities();
if (checkedOut == "yes")
{
TempData["confirm"] = "Book has been checked out successfully.";
}
if (returned == "yes")
{
TempData["confirm"] = "Book has been returned successfully.";
}
if (emailSent == "yes")
{
TempData["confirm"] = "Emails have been sent to students with late book orders.";
}
if (balanceUpdated == "yes")
{
TempData["confirm"] = "Balance has been updated on student account with late orders.";
}
if (admid != null)
{
int id = Convert.ToInt32(admid);
username = db.Admins.Where(x => x.AdminID == id).FirstOrDefault().email;
password = db.Admins.Where(x => x.AdminID == id).FirstOrDefault().password;
}
var model = new AdminViewModels();
model.AdminListing = db.Admins.Where(x => x.email == username && x.password == password).ToList();
if (model.AdminListing.Count() == 0)
{
return(RedirectToAction("AdminLogin", new { status = "login failed" }));
}
else
{
ViewBag.firstname = model.AdminListing.FirstOrDefault().FirstName;
ViewBag.lastname = model.AdminListing.FirstOrDefault().LastName;
ViewBag.email = model.AdminListing.FirstOrDefault().email;
ViewBag.adminid = model.AdminListing.FirstOrDefault().AdminID;
model.AdminID = model.AdminListing.FirstOrDefault().AdminID;
int id = ViewBag.adminid;
model.ApprovedListing = db.Orders.Where(x => x.Status == "Approved").ToList();
model.CheckedOutListing = db.Orders.Where(x => x.Status == "Checked Out").ToList();
model.StudentListing = db.Students.ToList();
model.BookListing = db.Books.ToList();
return(View(model));
}
}
public async Task <ActionResult> Index(AdminViewModels model, ManageMessageId?message = null)
{
ViewBag.StatusMessage = message == ManageMessageId.UserDeleted ?
" Konto użytkownika zostało pomyślnie usunięte." : message == ManageMessageId.UserUpdated ?
"Konto użytkownika zostało zaaktualizowane." : "";
ViewBag.ErrorMessage = message == ManageMessageId.Error ? "Błąd." : message == ManageMessageId.HighRankedUser ?
"Admin nie może zostać usunięty." : "";
await ShowUserDetails(model);
return(View());
}
public IActionResult AddMedication(int?id)
{
AVM = new AdminViewModels()
{
Medication = new Models.Medication()
};
if (id != null)
{
AVM.Medication = _unitofWork.Medication.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddPatient(int?id)
{
AVM = new AdminViewModels()
{
Patients = new Models.Patients()
};
if (id != null)
{
AVM.Patients = _unitofWork.Patients.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddRoom(int?id)
{
AVM = new AdminViewModels()
{
Room = new Models.Room()
};
if (id != null)
{
AVM.Room = _unitofWork.Room.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddProcedure(int?id)
{
AVM = new AdminViewModels()
{
Procedure = new Models.Procedure()
};
if (id != null)
{
AVM.Procedure = _unitofWork.Procedure.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddDoctor(int?id)
{
AVM = new AdminViewModels()
{
Doctors = new Models.Doctors()
};
if (id != null)
{
AVM.Doctors = _unitofWork.Doctors.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddNurse(int?id)
{
AVM = new AdminViewModels()
{
Nurses = new Models.Nurses()
};
if (id != null)
{
AVM.Nurses = _unitofWork.Nurses.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddDepartment(int?id)
{
AVM = new AdminViewModels()
{
Department = new Models.Department(),
DoctorsList = _unitofWork.Doctors.GetDropDownListForDoctors()
};
if (id != null)
{
AVM.Department = _unitofWork.Department.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public ActionResult AjouterEvenement(int pID = 0)
{
AdminViewModels vm = new AdminViewModels();
vm.Title = "Ajouter un évènement";
List <Theme> maListe = themeService.FindAll();
if (pID != 0)
{
vm.MonEvent = eventService.Get(pID); vm.Title = "Modification d'un évènement"; vm.IdThemeSelected = vm.MonEvent.Theme.Id;
}
vm.ListTheme = maListe;
return(View(vm));
}
public IActionResult AddOnCall(int?id)
{
AVM = new AdminViewModels()
{
OnCall = new Models.OnCall(),
RoomsList = _unitofWork.Room.GetDropDownListForRoom(),
NursesList = _unitofWork.Nurses.GetDropDownListForNurses()
};
if (id != null)
{
AVM.OnCall = _unitofWork.OnCall.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddAppointment(int?id)
{
AVM = new AdminViewModels()
{
Appointments = new Models.Appointments(),
DoctorsList = _unitofWork.Doctors.GetDropDownListForDoctors(),
PatientsList = _unitofWork.Patients.GetDropDownListForPatients()
};
if (id != null)
{
AVM.Appointments = _unitofWork.Appointments.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddTreatment(int?id)
{
AVM = new AdminViewModels()
{
Treatment = new Models.Treatment(),
DoctorsList = _unitofWork.Doctors.GetDropDownListForDoctors(),
ProceduresList = _unitofWork.Procedure.GetDropDownListForProcedure()
};
if (id != null)
{
AVM.Treatment = _unitofWork.Treatment.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddRoomUsage(int?id)
{
AVM = new AdminViewModels()
{
Usage = new Models.Usage(),
PatientsList = _unitofWork.Patients.GetDropDownListForPatients(),
RoomsList = _unitofWork.Room.GetDropDownListForRoom()
};
if (id != null)
{
AVM.Usage = _unitofWork.Usage.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public IActionResult AddPerscribtion(int?id)
{
AVM = new AdminViewModels()
{
Perscribtion = new Models.Perscribtion(),
DoctorsList = _unitofWork.Doctors.GetDropDownListForDoctors(),
PatientsList = _unitofWork.Patients.GetDropDownListForPatients(),
MedicationsList = _unitofWork.Medication.GetDropDownListForMedications()
};
if (id != null)
{
AVM.Perscribtion = _unitofWork.Perscribtion.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public async Task <ActionResult> ShowUserDetails(AdminViewModels model)
{
usrList.Clear();
IList <ApplicationUser> users = context.Users.ToList();
foreach (var user in users)
{
var roles = await UserManager.GetRolesAsync(user.Id);
model.UserName = user.UserName;
foreach (var role in roles)
{
model.RankName = role;
switch (role)
{
case "Admin":
model.RankId = "1";
break;
case "Teacher":
model.RankId = "2";
break;
case "Student":
model.RankId = "3";
break;
}
}
model.UserId = user.Id;
model.UserFullName = user.UserName;
usrList.Add(new AdminViewModels()
{
UserName = model.UserName,
RankName = model.RankName,
UserId = model.UserId,
RankId = model.RankId,
UserFullName = model.UserFullName
});
model.RankName = null;
}
return(PartialView("ShowUserDetails"));
}
public ActionResult Login(AdminViewModels model)
{
account account = new account();
account = db
.accounts
.SingleOrDefault
(
n => (n.account_username == model.Username.ToLower() &&
n.account_password == Utility.ComputeSha256Hash(model.Password))
);
if (account != null)
{
Session["admin"] = account;
return(RedirectToAction("Index", "Admin"));
}
ViewData["Error"] = "Đăng nhập thất bại";
return(View(model));
}
public IActionResult AddUndergoes(int?id)
{
AVM = new AdminViewModels()
{
Undergoes = new Models.Undergoes(),
DoctorsList = _unitofWork.Doctors.GetDropDownListForDoctors(),
PatientsList = _unitofWork.Patients.GetDropDownListForPatients(),
NursesList = _unitofWork.Patients.GetDropDownListForPatients(),
UsageList = _unitofWork.Usage.GetDropDownListForUsage(),
ProceduresList = _unitofWork.Procedure.GetDropDownListForProcedure()
};
if (id != null)
{
AVM.Undergoes = _unitofWork.Undergoes.Get(id.GetValueOrDefault());
}
return(View(AVM));
}
public ActionResult EditProductView(string id)
{
try
{
Product product = Product.ExecuteCreate(Int32.Parse(id));
IDNew = Int32.Parse(id);
ViewBag.Message = "Added " + product.Name;
ViewBag.Name = product.Name;
ViewBag.Description = product.Description;
ViewBag.Price = product.Price;
ViewBag.FileName = product.ImageName;
}
catch (ArgumentNullException n)
{
AdminViewModels models2 = AdminViewModels.GetInstanceOfObject();
return(View(models2));
}
AdminViewModels models = AdminViewModels.GetInstanceOfObject();
return(View(models));
}
// GET: Admin
public ActionResult Index()
{
if (Session["logUserID"] == null)
{
return(RedirectToAction("Logout", "Users"));
}
AdminViewModels model = new AdminViewModels();
model.logUser = db.Users.Find(Session["logUserID"]);
foreach (var item in db.Users)
{
if (item.user_type != 1)
{
model.empListName.Add(item.full_name);
model.monthAttend.Add(checkAttend(item, DateTime.Now.Month));
}
}
model.listDevice = db.Devices.ToList();
List <Attent> atList = db.Attents.OrderBy(t => t.attent_time).ToList();
atList = Enumerable.Reverse(atList).Take(5).ToList();
foreach (var item in atList)
{
AttendViewModel at = new AttendViewModel();
User us = db.Users.Find(item.attent_user);
at.user_id = item.attent_user;
at.fullname = us.full_name;
at.log_time = item.attent_time;
at.location = db.Devices.Find(item.attent_device).description;
model.listAttent.Add(at);
}
return(View(model));
}
public ActionResult EditProductView()
{
AdminViewModels models = AdminViewModels.GetInstanceOfObject();
return(View(models));
}
public async Task <IActionResult> Services(AdminViewModels model)
{
model.UserServices = await db.UserServices.Include(p => p.User).Include(p => p.PodService).Include(p => p.PodCity).ToListAsync();
return(View(model));
}
public ActionResult AdminView(string categoryField, string productField, string saveTableField)
{
AdminViewModels adminViewModels = AdminViewModels.GetInstanceOfObject();
if (categoryField != null)
{
adminViewModels.DestroyInstance();
adminViewModels = AdminViewModels.GetInstanceOfObject();
adminViewModels.GetCategoriesInProduct(Int32.Parse(categoryField));
ViewBag.typeOfModel = Constants.MODEL_CATEGORY;
typeOfModel = Constants.MODEL_CATEGORY;
listOfCategoryItemsUsed = adminViewModels.GetListOfCategoryItemsUsed();
return(View(adminViewModels));
}
else if (productField != null)
{
adminViewModels.DestroyInstance();
adminViewModels = AdminViewModels.GetInstanceOfObject();
adminViewModels.GetProduct(Int32.Parse(productField));
ViewBag.typeOfModel = Constants.MODEL_PRODUCT;
typeOfModel = Constants.MODEL_PRODUCT;
return(View(adminViewModels));
}
else if (saveTableField != null)
{
//TODO: save table stuff
DataTable dataTable = new DataTable();
if (typeOfModel == Constants.MODEL_CATEGORY)
{
typeOfModel = "";
dataTable.Columns.Add(Constants.CATEGORY_COLUMN, Type.GetType(Constants.DATA_TYPE_STRING));
dataTable.Columns.Add(Constants.UNITS_SOLD_COLUMN, Type.GetType(Constants.DATA_TYPE_STRING));
foreach (var item in adminViewModels.GetListOfCategoryItemsUsed())
{
DataRow dataRow = dataTable.NewRow();
dataRow[Constants.CATEGORY_COLUMN] = item.Value.Name;
dataRow[Constants.UNITS_SOLD_COLUMN] = item.Value.Status;
dataTable.Rows.Add(dataRow);
}
DataSet dataSet = new DataSet();
dataSet.Tables.Add(dataTable);
ConvertToExcel(dataTable);
}
else if (typeOfModel == Constants.MODEL_PRODUCT)
{
typeOfModel = "";
dataTable.Columns.Add(Constants.CATEGORY_COLUMN, Type.GetType(Constants.DATA_TYPE_STRING));
dataTable.Columns.Add(Constants.UNITS_SOLD_COLUMN, Type.GetType(Constants.DATA_TYPE_STRING));
foreach (var item in adminViewModels.GetListOfCategoryItemsUsed())
{
DataRow dataRow = dataTable.NewRow();
dataRow[Constants.CATEGORY_COLUMN] = item.Value.Name;
dataRow[Constants.UNITS_SOLD_COLUMN] = item.Value.Status;
dataTable.Rows.Add(dataRow);
}
DataSet dataSet = new DataSet();
dataSet.Tables.Add(dataTable);
ConvertToExcel(dataTable);
}
else
{
dataTable.Columns.Add(Constants.CATEGORY_COLUMN, Type.GetType(Constants.DATA_TYPE_STRING));
dataTable.Columns.Add(Constants.UNITS_SOLD_COLUMN, Type.GetType(Constants.DATA_TYPE_STRING));
foreach (var item in adminViewModels.GetListOfCategoryItems())
{
DataRow dataRow = dataTable.NewRow();
dataRow[Constants.CATEGORY_COLUMN] = item.Value.Name;
dataRow[Constants.UNITS_SOLD_COLUMN] = item.Value.Status;
dataTable.Rows.Add(dataRow);
}
DataSet dataSet = new DataSet();
dataSet.Tables.Add(dataTable);
ConvertToExcel(dataTable);
}
return(View(adminViewModels));
}
else
{
ViewBag.typeOfModel = Constants.CATEGORY_TYPE_NONE;
return(View(adminViewModels));
}
}
// GET: AdminView
public ActionResult AdminView()
{
AdminViewModels adminViewModels = AdminViewModels.GetInstanceOfObject();
return(View(adminViewModels));
}
