public ActionResult Create([Bind(Include = "SubCode,DeptId, SubName,Sem,Elective")] Subject subject)
{
if (ModelState.IsValid)
{
if (!User.IsInRole("Admin"))
{
subject.DeptId = (string)TempData.Peek("Department");
}
db.Subjects.Add(subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DeptId = new SelectList(db.DEPTs, "DeptId", "DeptName", subject.DeptId);
SelectListItem yesItem = new SelectListItem
{
Text = "Yes",
Value = "1"
};
SelectListItem noItem = new SelectListItem
{
Text = "No",
Value = "0"
};
List <SelectListItem> electiveSelectList = new List <SelectListItem>();
electiveSelectList.Add(yesItem);
electiveSelectList.Add(noItem);
ViewBag.Elective = new SelectList(electiveSelectList, "Value", "Text", subject.Elective);
return(View(subject));
}
public ActionResult Create([Bind(Include = "TID,DeptId,TeacherName,Designation,E_mail,password")] Teacher teacher)
{
if (ModelState.IsValid)
{
int numberOfTeachers = db.Teachers.Where(x => x.DeptId == teacher.DeptId).ToList().Count;
teacher.TID = teacher.DeptId.Trim() + "" + (numberOfTeachers + 1);
db.Teachers.Add(teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DeptId = new SelectList(db.DEPTs, "DeptId", "DeptName", teacher.DeptId);
ViewBag.Designation = new SelectList(new List <SelectListItem>
{
new SelectListItem {
Text = "HoD", Value = "Hod"
},
new SelectListItem {
Text = "Professor", Value = "Professor"
},
new SelectListItem {
Text = "Associate Professor", Value = "Associate Professor"
},
new SelectListItem {
Text = "Assistant Professor", Value = "Assistant Professor"
}
}, "Value", "Text", teacher.Designation);
return(View(teacher));
}
public ActionResult ADD()
{
var a = (IndexVM)TempData["list"];
foreach (var i in a.ListofIndex)
{
i.SubCombId = Generate_SubcombId(i.Sem);
try
{
i.count = db.SubCombs.OrderByDescending(x => x.Count).Select(l => l.Count).First() + 1;
}
catch (Exception)
{
i.count = 1;
}
SubComb add1 = new SubComb();
add1.DeptId = i.Deptlist;
var b = db.Subjects.Find(i.subcode);
if (b.Elective == 0)
{
add1.Elective = false;
}
else
{
add1.Elective = true;
}
add1.Count = i.count;
add1.CombId = i.SubCombId;
add1.TID = i.TID;
add1.SubCode = i.subcode;
add1.Sem = i.Sem;
add1.Section = i.sec;
add1.CGPA = null;
add1.Percentile = null;
add1.ClassesHeld = 0;
db.SubCombs.Add(add1);
db.SaveChanges();
}
return(View());
}
// GET: Admin
public ActionResult Generate()
{
if (User.IsInRole("Admin"))
{
List <STUDENT> students = db.STUDENTs.ToList();
foreach (var student in students)
{
if (student.Password == null)
{
student.Section = student.Section.Trim();
student.Password = Membership.GeneratePassword(6, 1);
db.STUDENTs.Attach(student);
db.Entry(student).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("FilterStudent", "Admin"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public void CreateRolesAndUsers()
{
ApplicationDbContext context = new ApplicationDbContext();
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
if (!roleManager.RoleExists("Clerk"))
{
var role = new IdentityRole();
role.Name = "Clerk";
roleManager.Create(role);
}
if (!roleManager.RoleExists("Hod"))
{
var role = new IdentityRole();
role.Name = "Hod";
roleManager.Create(role);
}
if (!roleManager.RoleExists("Admin"))
{
var role = new IdentityRole();
role.Name = "Admin";
roleManager.Create(role);
}
RNSITEntities db = new RNSITEntities();
List <DEPT> departmentList = db.DEPTs.ToList();
foreach (var department in departmentList)
{
var userName = department.DeptId.ToLower().Trim() + "@rnsit.ac.in";
if (UserManager.FindByEmail(userName) == null)
{
var user = new ApplicationUser();
user.UserName = userName;
user.Email = userName;
string userPWD = "P@ssw0rd@" + department.DeptId.ToLower().Trim();
var chkUser = UserManager.Create(user, userPWD);
if (chkUser.Succeeded)
{
UserManager.AddToRole(user.Id, "Clerk");
}
department.Password = userPWD;
userName = department.DeptId.ToLower().Trim() + "@hod.rnsit.ac.in";
user = new ApplicationUser();
user.UserName = userName;
user.Email = userName;
userPWD = "P@ssw0rd@" + department.DeptId.ToLower().Trim();
chkUser = UserManager.Create(user, userPWD);
if (chkUser.Succeeded)
{
UserManager.AddToRole(user.Id, "Hod");
}
department.HodPassword = userPWD;
db.DEPTs.Attach(department);
db.Entry(department).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
public ActionResult BulkUpload(HttpPostedFileBase postedFile)
{
string filePath = string.Empty;
List <StudentError> errorList = new List <StudentError>();
if (postedFile != null)
{
string path = Server.MapPath("~/Uploads/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
filePath = path + Path.GetFileName(postedFile.FileName) + DateTime.Now.Ticks;
string extension = Path.GetExtension(postedFile.FileName);
postedFile.SaveAs(filePath);
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(filePath);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
for (int i = 2; i <= rowCount; i++)
{
string Usn = xlRange.Cells[i, 1].Value2.ToString();
string Name = xlRange.Cells[i, 2].Value2.ToString();
int Sem = int.Parse(xlRange.Cells[i, 3].Value2.ToString());
string Section = xlRange.Cells[i, 4].Value2.ToString();
string department = (string)TempData.Peek("Department");
STUDENT student = new STUDENT
{
DeptID = department,
Section = Section.Trim(),
Sem = Sem,
NAME = Name,
USN = Usn
};
try
{
db.STUDENTs.Add(student);
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
StudentError error = new StudentError();
error.Usn = Usn;
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
error.Errors.Add(new Error
{
AttributeName = ve.PropertyName,
ErrorMessage = ve.ErrorMessage
});
}
}
errorList.Add(error);
}
catch (DbUpdateException d)
{
StudentError error = new StudentError();
error.Usn = Usn;
error.Errors.Add(new Error
{
AttributeName = "Usn",
ErrorMessage = "Usn is already taken"
});
errorList.Add(error);
}
}
}
return(View("StudentErrors", errorList));
}
public ActionResult BulkUpload(HttpPostedFileBase postedFile)
{
string filePath = string.Empty;
List <ElectiveError> errorList = new List <ElectiveError>();
if (postedFile != null)
{
string path = Server.MapPath("~/Uploads/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
filePath = path + Path.GetFileName(postedFile.FileName) + DateTime.Now.Ticks;
string extension = Path.GetExtension(postedFile.FileName);
postedFile.SaveAs(filePath);
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(filePath);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
for (int i = 2; i <= rowCount; i++)
{
string Usn = xlRange.Cells[i, 1].Value2.ToString();
string SubjectCode = xlRange.Cells[i, 2].Value2.ToString();
NewElectivesTable table = new NewElectivesTable
{
SubCode = SubjectCode,
USN = Usn
};
try
{
db.NewElectivesTables.Add(table);
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
ElectiveError error = new ElectiveError();
error.Usn = Usn;
error.SubjectCode = SubjectCode;
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
error.Errors.Add(new Error
{
AttributeName = ve.PropertyName,
ErrorMessage = ve.ErrorMessage
});
}
}
errorList.Add(error);
}
catch (DbUpdateException d)
{
ElectiveError error = new ElectiveError();
error.Usn = Usn;
error.SubjectCode = SubjectCode;
error.Errors.Add(new Error
{
AttributeName = "",
ErrorMessage = "Invalid Combination"
});
errorList.Add(error);
}
}
}
return(View("ElectivesError", errorList));
}