public ActionResult DeleteConfirmed(int id)
{
AspNetTerm aspNetTerm = db.AspNetTerms.Find(id);
db.AspNetTerms.Remove(aspNetTerm);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,TermName,SessionID,TermStartDate,TermEndDate,Status")] AspNetTerm aspNetTerm)
{
if (ModelState.IsValid)
{
db.Entry(aspNetTerm).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SessionID = new SelectList(db.AspNetSessions, "Id", "SessionName", aspNetTerm.SessionID);
return(View(aspNetTerm));
}
// GET: AspNetTerm/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetTerm aspNetTerm = db.AspNetTerms.Find(id);
if (aspNetTerm == null)
{
return(HttpNotFound());
}
return(View(aspNetTerm));
}
// GET: AspNetTerm/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetTerm aspNetTerm = db.AspNetTerms.Find(id);
if (aspNetTerm == null)
{
return(HttpNotFound());
}
ViewBag.SessionID = new SelectList(db.AspNetSessions, "Id", "SessionName", aspNetTerm.SessionID);
return(View(aspNetTerm));
}
// GET: AspNetTerm/Details/5
public ActionResult Details(int id)
{
//var parent = db.AspNetParents.Where(x => x.AspNetUser.UserName == UserName).Select(x => x).FirstOrDefault();
//AspNetUser aspNetUser = db.AspNetUsers.Where(x => x.UserName == UserName).Select(x => x).FirstOrDefault();
AspNetTerm aspNetTerm = db.AspNetTerms.Where(x => x.Id == id).Select(x => x).FirstOrDefault();
if (aspNetTerm == null)
{
return(HttpNotFound());
}
ViewBag.SessionID = new SelectList(db.AspNetSessions, "Id", "SessionName", aspNetTerm.SessionID);
return(View(aspNetTerm));
}
public ActionResult Create([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status")] AspNetSession aspNetSession)
{
var TransactionObj = db.Database.BeginTransaction();
if (db.AspNetSessions.Where(x => x.Status == "Active").Count() == 0 || aspNetSession.Status == "InActive")
{
if (ModelState.IsValid)
{
aspNetSession.SessionEndDate = Convert.ToDateTime(Request.Form["SessionEndDate"]);
aspNetSession.SessionStartDate = Convert.ToDateTime(Request.Form["SessionStartDate"]);
db.AspNetSessions.Add(aspNetSession);
db.SaveChanges();
}
TransactionObj.Commit();
////////////////////////////////////////////////////////Term Add/////////////////////////////////////////////////////////////////
int length = 3;
for (int i = 0; i < length; i++)
{
AspNetTerm aspnetTerm = new AspNetTerm();
aspnetTerm.SessionID = aspNetSession.Id;
aspnetTerm.TermName = "Term " + (i + 1);
aspnetTerm.TermStartDate = DateTime.Now;
aspnetTerm.TermEndDate = DateTime.Now;
aspnetTerm.Status = "InActive";
db.AspNetTerms.Add(aspnetTerm);
db.SaveChanges();
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = a.Id;
var logMessage = "New Session Added, SessionName: " + aspNetSession.SessionName + ", SessionStartDate: " + aspNetSession.SessionStartDate + ", SessionEndDate: " + aspNetSession.SessionEndDate + ", Status: " + aspNetSession.Status;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
return(RedirectToAction("Indexs"));
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult Create([Bind(Include = "Id,TermName,SessionID,TermStartDate,TermEndDate,Status")] AspNetTerm aspNetTerm)
{
var TransactionObj = db.Database.BeginTransaction();
try
{
if (ModelState.IsValid)
{
var terms = db.AspNetTerms.Where(p => p.SessionID == aspNetTerm.SessionID).Count();
aspNetTerm.TermNo = terms + 1;
db.AspNetTerms.Add(aspNetTerm);
db.SaveChanges();
}
TransactionObj.Commit();
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = a.Id;
var logMessage = "New Term Added, TermName: " + aspNetTerm.TermName + ", TermStartDate: " + aspNetTerm.TermStartDate + ", TermEndDate: " + aspNetTerm.TermEndDate + ", Status: " + aspNetTerm.Status;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
return(RedirectToAction("Indexs"));
}
catch
{
TransactionObj.Dispose();
}
ViewBag.SessionID = new SelectList(db.AspNetSessions, "Id", "SessionName", aspNetTerm.SessionID);
return(RedirectToAction("Index"));
}
