public ActionResult DeleteConfirmed(int id)
{
AspNetClass aspNetClass = db.AspNetClasses.Find(id);
db.AspNetClasses.Remove(aspNetClass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,ClassName,TeacherID")] AspNetClass aspNetClass)
{
if (ModelState.IsValid)
{
db.Entry(aspNetClass).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Name", aspNetClass.TeacherID);
return(View(aspNetClass));
}
public ActionResult Create([Bind(Include = "Id,ClassName,TeacherID")] AspNetClass aspNetClass)
{
if (ModelState.IsValid)
{
db.AspNetClasses.Add(aspNetClass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(x => x.AspNetRoles.Select(y => y.Name).Contains("Teacher")), "Id", "Name", aspNetClass.TeacherID);
return(View(aspNetClass));
}
// GET: AspNetClass/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetClass aspNetClass = db.AspNetClasses.Find(id);
if (aspNetClass == null)
{
return(HttpNotFound());
}
return(View(aspNetClass));
}
public ActionResult ClassfromFile(AspNetClass aspNetClass)
{
var dbTransaction = db.Database.BeginTransaction();
try
{
HttpPostedFileBase file = Request.Files["classes"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
}
var studentList = new List <RegisterViewModel>();
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
var Class = new AspNetClass();
string teacherName = workSheet.Cells[rowIterator, 2].Value.ToString();
var Teacher = (from users in db.AspNetUsers
where users.UserName == teacherName
select users).First();
Class.ClassName = workSheet.Cells[rowIterator, 1].Value.ToString();
Class.Class = workSheet.Cells[rowIterator, 3].Value.ToString();
Class.Section = workSheet.Cells[rowIterator, 4].Value.ToString();
if (Class.Section == "-")
{
Class.Section = "";
}
Class.TeacherID = Teacher.Id;
Class.SessionID = db.AspNetSessions.Where(x => x.Status == "Active").FirstOrDefault().Id;
db.AspNetClasses.Add(Class);
db.SaveChanges();
}
}
dbTransaction.Commit();
return(RedirectToAction("Index"));
}
catch (Exception) { dbTransaction.Dispose(); }
// ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Name", aspNetClass.TeacherID);
return(RedirectToAction("Create", aspNetClass));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
AspNetClass aspNetClass = db.AspNetClasses.Find(id);
db.AspNetClasses.Remove(aspNetClass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.Error = "This Class has subjects and students in it. It Can't be deleted";
return(View("Delete", db.AspNetClasses.Find(id)));
}
}
// GET: AspNetClass/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetClass aspNetClass = db.AspNetClasses.Find(id);
if (aspNetClass == null)
{
return(HttpNotFound());
}
ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Name", aspNetClass.TeacherID);
return(View(aspNetClass));
}
// GET: AspNetClass/Details/5
public ActionResult Details(int id)
{
//if (id == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
AspNetClass aspNetClass = db.AspNetClasses.Where(x => x.Id == id).Select(x => x).FirstOrDefault();
if (aspNetClass == null)
{
return(HttpNotFound());
}
ViewBag.Class = new SelectList(Classes, "option", "value", aspNetClass.Class);
ViewBag.Section = new SelectList(Sections, "option", "value", aspNetClass.Section);
ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Name", aspNetClass.TeacherID);
return(View(aspNetClass));
}
public ActionResult Edit([Bind(Include = "Id,ClassName,Class,Section,TeacherID")] AspNetClass aspNetClass)
{
if (ModelState.IsValid)
{
db.Entry(aspNetClass).State = EntityState.Modified;
var sublist = db.AspNetSubjects.Where(x => x.ClassID == aspNetClass.Id).Select(x => x.Id).ToList();
foreach (var item in sublist)
{
var sub = db.AspNetSubjects.Where(x => x.Id == item).FirstOrDefault();
sub.TeacherID = aspNetClass.TeacherID;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Class = new SelectList(Classes, "option", "value", aspNetClass.Class);
ViewBag.Section = new SelectList(Sections, "option", "value", aspNetClass.Section);
ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Name", aspNetClass.TeacherID);
return(View(aspNetClass));
}
public ActionResult Create([Bind(Include = "Id,ClassName,Class,Section,TeacherID")] AspNetClass aspNetClass)
{
aspNetClass.SessionID = SessionID;
var transactionObj = db.Database.BeginTransaction();
try
{
if (ModelState.IsValid)
{
db.AspNetClasses.Add(aspNetClass);
db.SaveChanges();
}
transactionObj.Commit();
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
var UserNameLog = User.Identity.Name;
AspNetUser userObjLog = db.AspNetUsers.First(x => x.UserName == UserNameLog);
string UserIDLog = userObjLog.Id;
AspNetUser ClassTeacherLog = db.AspNetUsers.First(x => x.Id == aspNetClass.TeacherID);
string ClassTeacherNameLog = ClassTeacherLog.Name;
string user = db.AspNetUsers.Where(x => x.Id == aspNetClass.TeacherID).Select(x => x.Name).FirstOrDefault();
var logMessage = "A new Class Added, Name: " + aspNetClass.ClassName + ", Class Teacher: " + ClassTeacherNameLog + ", Teacher Name: " + user;
var LogControllerObj = new AspNetLogsController();
LogControllerObj.CreateLogSave(logMessage, UserIDLog);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
return(RedirectToAction("Index"));
}
catch (Exception)
{
transactionObj.Dispose();
}
ViewBag.Class = new SelectList(Classes, "option", "value");
ViewBag.Section = new SelectList(Sections, "option", "value");
ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(x => x.AspNetRoles.Select(y => y.Name).Contains("Teacher")), "Id", "UserName", aspNetClass.TeacherID);
return(View(aspNetClass));
}
public ActionResult Create([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status,Total_Fee")] AspNetSession aspNetSession)
{
var TransactionObj = db.Database.BeginTransaction();
if (ModelState.IsValid)
{
aspNetSession.SessionEndDate = Convert.ToDateTime(Request.Form["SessionEndDate"]);
aspNetSession.SessionStartDate = Convert.ToDateTime(Request.Form["SessionStartDate"]);
aspNetSession.Total_Fee = aspNetSession.Total_Fee;
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);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
AspNetClass Class = new AspNetClass();
var CurrentSession = db.AspNetSessions.OrderByDescending(x => x.Id).FirstOrDefault();
Class.ClassName = CurrentSession.SessionName;
Class.Class = CurrentSession.SessionName;
Class.SessionID = CurrentSession.Id;
db.AspNetClasses.Add(Class);
db.SaveChanges();
//Create Subjects to New Session
var AllSubjectsofTestSession = db.AspNetSubjects.Where(x => x.ClassID == 1).ToList();
List <subjects_mapping> list = new List <subjects_mapping>();
foreach (AspNetSubject Subject in AllSubjectsofTestSession)
{
subjects_mapping sub = new subjects_mapping();
sub.oldId = Subject.Id;
sub.name = Subject.SubjectName;
AspNetSubject NewSubjectForSession = new AspNetSubject();
NewSubjectForSession = Subject;
NewSubjectForSession.ClassID = Class.Id;
NewSubjectForSession.TeacherID = null;
db.AspNetSubjects.Add(NewSubjectForSession);
db.SaveChanges();
sub.newId = NewSubjectForSession.Id;
list.Add(sub);
}
var AllTeacherSubjects = db.AspNetTeacherSubjects.Where(x => x.AspNetSubject.ClassID == 1).ToList();
foreach (var item in AllTeacherSubjects)
{
foreach (var item1 in list)
{
if (item1.oldId == item.SubjectID)
{
AspNetTeacherSubject TS = new AspNetTeacherSubject();
TS.SubjectID = item1.newId;
TS.TeacherID = item.TeacherID;
db.AspNetTeacherSubjects.Add(TS);
break;
}
}
}
db.SaveChanges();
var UserIDs = (from teacher in db.AspNetUsers.Where(x => x.Status != "False")
join t2 in db.AspNetUsers_Session
on teacher.Id equals t2.UserID
join t3 in db.AspNetEmployees
on teacher.Id equals t3.UserId
where teacher.AspNetRoles.Select(y => y.Name).Contains("Teacher") && t2.AspNetSession.AspNetClasses.Any(x => x.Id == 1) /*&& db.AspNetChapters.Any(x=>x.Id==id)*/
select new
{
TeacherId = teacher.Id,
EmployeeId = t3.Id,
}).ToList();
foreach (var Id in UserIDs)
{
string IdString = Id.TeacherId.ToString();
AspNetUsers_Session UserSession = new AspNetUsers_Session();
UserSession.SessionID = aspNetSession.Id;
UserSession.UserID = IdString;
db.AspNetUsers_Session.Add(UserSession);
db.SaveChanges();
}
foreach (var Id in UserIDs)
{
Aspnet_Employee_Session EmployeeSession = new Aspnet_Employee_Session();
EmployeeSession.Emp_Id = Id.EmployeeId;
EmployeeSession.Session_Id = aspNetSession.Id;
db.Aspnet_Employee_Session.Add(EmployeeSession);
db.SaveChanges();
}
return(RedirectToAction("Indexs"));
}
