public ActionResult DeleteAccount(string id)
{
try
{
var toDeleteProfile = new UserProfile {
UserID = id
};
var toDeleteUser = new AspNetUser {
Id = id
};
db.Configuration.AutoDetectChangesEnabled = false;
db.UserProfiles.Remove(toDeleteProfile);
db.AspNetUsers.Remove(toDeleteUser);
db.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.Message);
}
finally
{
db.Configuration.AutoDetectChangesEnabled = true;
}
return(RedirectToAction("Accounts"));
}
public ActionResult Index(WebSetting model)
{
var dbSetting = db.WebSettings.FirstOrDefault();
var tempPeriod = db.ValidationPeriods.Where(e => e.PeriodID.Equals(model.PeriodID)).FirstOrDefault();
var period = db.ValidationPeriods.Where(e => e.AcademicYearStart.Equals(tempPeriod.AcademicYearStart) && e.AcademicYearEnd.Equals(tempPeriod.AcademicYearEnd) && e.Term.Equals(model.ValidationPeriod.Term)).FirstOrDefault();
if (period == null)
{
TempData["MessageType"] = "warning";
TempData["Message"] = "Validation Period is not found";
return(RedirectToAction("Index"));
}
dbSetting.ValidationPeriod = period;
dbSetting.ValidationOpen = model.ValidationOpen;
db.SaveChanges();
ViewBag.MessageType = "success";
ViewBag.Message = "Successfully changed website settings";
ViewBag.Periods = db.ValidationPeriods.ToList();
return(View(db.WebSettings.FirstOrDefault()));
}
public static bool AddMessage(lipatdbEntities db, string message, string id)
{
if (message.Equals(""))
{
return(false);
}
AspNetUser user = db.AspNetUsers.Where(e => e.Id.Equals(id)).FirstOrDefault();
AdminAuditLog log = new AdminAuditLog()
{
DateTime = DateTime.Now,
Event = message,
UserID = user.Id,
};
db.AdminAuditLogs.Add(log);
db.SaveChanges();
return(true);
}
public ActionResult Submit(ValidationRequest request)
{
string id = User.Identity.GetUserId();
//db.ValidationRequests.Where(e => e.RequestID.Equals(request.RequestID)).FirstOrDefault().AdminID = id;
//db.ValidationRequests.Where(e => e.RequestID.Equals(request.RequestID)).FirstOrDefault().AspNetUser1 = db.AspNetUsers.Where(e => e.Id.Equals(id)).FirstOrDefault();
//db.ValidationRequests.Where(e => e.RequestID.Equals(request.RequestID)).FirstOrDefault().DateEvaluated = DateTime.Now;
//db.ValidationRequests.Where(e => e.RequestID.Equals(request.RequestID)).FirstOrDefault().StatusID = request.StatusID;
//db.ValidationRequests.Where(e => e.RequestID.Equals(request.RequestID)).FirstOrDefault().Remarks = request.Remarks;
request.AdminID = id;
request.AspNetUser1 = db.AspNetUsers.Where(e => e.Id.Equals(id)).FirstOrDefault();
request.DateEvaluated = DateTime.Now;
request.ValidationStatu = db.ValidationStatus.Where(e => e.StatusID == request.RequestID).FirstOrDefault();
db.Entry(request).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void UploadStudentRequest(ValidationRequest requestModel)
{
dbObject.ValidationRequests.Add(requestModel);
dbObject.SaveChanges();
}
// A N N O U N C E M E N T S \\
public void UploadAnnouncement(Announcement announcementModel)
{
dbObject.Announcements.Add(announcementModel);
dbObject.SaveChanges();
}