public string generateAdminID() { using (smsEntities data = new smsEntities()) { var oldID = (from admin in data.admin orderby admin.id descending select admin.adminid).Take(1).FirstOrDefault();//.ToString(); //Debug.WriteLine(oldID); string toBreak = oldID.ToString(); string[] idList = toBreak.Split('-');//20-0000-01 //foreach (string id in idList) //{ Debug.WriteLine(id); } string id1 = idList[0]; //Debug.WriteLine(id1); string id2 = idList[1]; //Debug.WriteLine(id2); string id3 = idList[2]; //Debug.WriteLine(id3); int idInc = Convert.ToInt32(id2); idInc = idInc + 1; id2 = idInc.ToString("D" + 4); string newID = id1 + "-" + id2 + "-" + id3; return(newID); } }
public bool NameExistsAdmin(string adminname) { using (smsEntities data = new smsEntities()) { var name = data.admin.Where(a => a.adminname == adminname).FirstOrDefault(); return(name != null); } }
public bool NameExistsStudent(string studentname) { using (smsEntities data = new smsEntities()) { var name = data.student.Where(s => s.studentname == studentname).FirstOrDefault(); return(name != null); } }
public ActionResult CreateSuperAdmin([Bind(Exclude = "id")] superadmin superadmin) { if ((string)Session["user"] != null) { bool Status = false; string message = ""; superadmin.superadminid = generateSuperID();//"20-0005-01"; if (ModelState.IsValid) { var nameExistsSuper = NameExistsSuper(superadmin.superadminname); if (nameExistsSuper) { ModelState.AddModelError("NameExistSuper", "Super Admin name already exists"); return(View(superadmin)); } superadmin.superadminpassword = Crypto.Hash(superadmin.superadminpassword); superadmin.superadminconfirmpassword = Crypto.Hash(superadmin.superadminconfirmpassword); using (smsEntities data = new smsEntities()) { data.superadmin.Add(superadmin); data.SaveChanges(); message = " Super Admin Account " + superadmin.superadminname + " with ID = " + superadmin.superadminid + " has been created."; Status = true; } } else { message = "Invalid Request"; } ViewBag.Message = message; ViewBag.Status = Status; return(View(superadmin)); } return(RedirectToAction("Login", "User")); }
public ActionResult CreateAdmin([Bind(Exclude = "id")] admin admin) { bool Status = false; string message = ""; admin.adminid = generateAdminID();//"20-0005-01"; if (ModelState.IsValid) { var nameExistAdmin = NameExistsAdmin(admin.adminname); if (nameExistAdmin) { ModelState.AddModelError("NameExistAdmin", "Admin name already exists"); return(View(admin)); } admin.adminpassword = Crypto.Hash(admin.adminpassword); admin.adminconfirmpassword = Crypto.Hash(admin.adminconfirmpassword); using (smsEntities data = new smsEntities()) { data.admin.Add(admin); data.SaveChanges(); message = "Admin Account " + admin.adminname + " with ID = " + admin.adminid + " has been created."; Status = true; } } else { message = "Invalid Request"; } ViewBag.Message = message; ViewBag.Status = Status; return(View(admin)); }
public ActionResult UploadFile(HttpPostedFileBase file, uploadnote uploadnote, @class classid, section section, teacher teacher) { if ((string)Session["user"] != null) { smsEntities data = new smsEntities(); try { if (file.ContentLength > 0) { string FileName = Path.GetFileName(file.FileName); string path = Path.Combine(Server.MapPath("~/UploadedFiles"), FileName); file.SaveAs(path); } ViewBag.Message = "File Uploaded Successfully!!"; return(View()); } catch { ViewBag.Message = "File upload failed!!"; return(View()); } } return(RedirectToAction("Login", "User")); }
public ActionResult Login(Login login) { string inputID = checkUserID(login.Userid); string hashpassword = Crypto.Hash(login.Password); using (smsEntities data = new smsEntities()) { if (inputID == "01") { var u = data.superadmin.Where(a => a.superadminpassword == hashpassword).FirstOrDefault(); if (u != null) { if (string.Compare(Crypto.Hash(login.Password), u.superadminpassword) == 0) { Session["user"] = u.superadminid; return(RedirectToAction("SuperIndex", "SuperAdmin")); } } } else if (inputID == "02") { var u = data.admin.Where(a => a.adminpassword == hashpassword).FirstOrDefault(); if (u != null) { if (string.Compare(Crypto.Hash(login.Password), u.adminpassword) == 0) { Session["user"] = u.adminid; return(RedirectToAction("AdminIndex", "Admin")); } } } else if (inputID == "03") { var u = data.teacher.Where(a => a.teacherpassword == hashpassword).FirstOrDefault(); if (u != null) { if (string.Compare(Crypto.Hash(login.Password), u.teacherpassword) == 0) { Session["user"] = u.teacherid; return(RedirectToAction("TeacherIndex", "Teacher")); } } } else if (inputID == "04") { var u = data.student.Where(a => a.studentpassword == hashpassword).FirstOrDefault(); if (u != null) { if (string.Compare(Crypto.Hash(login.Password), u.studentpassword) == 0) { Session["user"] = u.studentid; return(RedirectToAction("StudentIndex", "Student")); } } } else { ViewBag.Message = "Invalid credential!!"; } return(View()); } }