public string GetuserID(string username) { using (nlbdataEntities _Context = new nlbdataEntities()) { //var userRoles = (from user in _Context.NBA_SYS_Users // join roleMapping in _Context.NBA_Role // on user.NBA_Role equals roleMapping.ROLE_ID // join role in _Context.NBA_Role // on roleMapping.RoleId equals role.ROLE_ID // where user.Username == username // select role.RoleName).ToArray(); //var userRoles = (from user in _Context.NBA_SYS_Users // where user.email == username // select user.surname // ); ////var userRoles = _Context.NBA_SYS_Users.Where(x => x.email == username).Select(n => n.ROLE_ID ); var userRoles = _Context.NBA_SYS_Users.Where(x => x.email == username).Select(n => n.SYS_USER_ID).Take(1).SingleOrDefault(); ; return(userRoles.ToString()); } }
public ActionResult VerifyAccount(string id) { bool Status = false; using (nlbdataEntities dc = new nlbdataEntities()) { dc.Configuration.ValidateOnSaveEnabled = false; var v = dc.NBA_SYS_Users.Where(a => a.sys_VerificationCode == new Guid(id)).FirstOrDefault(); if (v != null) { v.sys_IsEmailVerified = true; dc.SaveChanges(); Status = true; } else { ViewBag.Message = "Invalid Request"; } } ViewBag.Status = Status; return(View()); }
public ActionResult Save(int id) { using (nlbdataEntities dc = new nlbdataEntities()) { var v = dc.NBA_Agwy.Where(a => a.AGWY_ID == id).FirstOrDefault(); return(View(v)); } }
public ActionResult GetGirls() { using (nlbdataEntities dc = new nlbdataEntities()) { var pr = dc.NBA_Agwy.OrderBy(a => a.name).ToList(); return(Json(new { data = pr }, JsonRequestBehavior.AllowGet)); } }
public bool IsEmailExist(string emailID) { using (nlbdataEntities dc = new nlbdataEntities()) { var v = dc.NBA_SYS_Users.Where(a => a.email == emailID).FirstOrDefault(); return(v != null); } }
public ActionResult Delete(int id) { using (nlbdataEntities dc = new nlbdataEntities()) { var v = dc.NBA_Agwy.Where(a => a.AGWY_ID == id).FirstOrDefault(); if (v != null) { return(View(v)); } else { return(HttpNotFound()); } } }
public ActionResult DeleteEmployee(int id) { bool status = false; using (nlbdataEntities dc = new nlbdataEntities()) { var v = dc.NBA_Agwy.Where(a => a.AGWY_ID == id).FirstOrDefault(); if (v != null) { dc.NBA_Agwy.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Save(NBA_Agwy emp) { bool status = false; if (ModelState.IsValid) { using (nlbdataEntities dc = new nlbdataEntities()) { if (emp.AGWY_ID > 0) { //Edit var v = dc.NBA_Agwy.Where(a => a.AGWY_ID == emp.AGWY_ID).FirstOrDefault(); if (v != null) { v.name = emp.name; v.surname = emp.surname; v.known_as = emp.known_as; v.gender = emp.gender; v.age = emp.age; v.type_of_identification = emp.type_of_identification; v.idno = emp.idno; v.dateOfbirth = emp.dateOfbirth; v.town_village_address = emp.town_village_address; v.maiden_name = emp.maiden_name; v.street_name = emp.street_name; v.town_village = emp.town_village; v.uic = emp.uic; } } else { //Save dc.NBA_Agwy.Add(emp); } dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Registration([Bind(Exclude = "sys_IsEmailVerified,sys_VerificationCode")] NBA_SYS_Users user) { bool Status = false; string message = ""; // // Model Validation if (ModelState.IsValid) { #region //Email is already Exist var isExist = IsEmailExist(user.email); if (isExist) { ModelState.AddModelError("EmailExist", "Email already exist"); return(View(user)); } #endregion #region Generate Activation Code user.sys_VerificationCode = Guid.NewGuid(); #endregion #region Password Hashing user.password = Crypto.Hash(user.password); user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword); // #endregion user.sys_IsEmailVerified = false; #region Save to Database using (nlbdataEntities dc = new nlbdataEntities()) { dc.NBA_SYS_Users.Add(user); dc.SaveChanges(); //Send Email to User SendVerificationLinkEmail(user.email, user.sys_VerificationCode.ToString()); message = "Registration successfully done. Account activation link " + " has been sent to your email id:" + user.email; Status = true; } #endregion } else { message = "Invalid Request"; } ViewBag.Message = message; ViewBag.Status = Status; return(View(user)); }
public ActionResult Login(UserLogin login, string ReturnUrl = "") { if (Session["uname"] != null) { return(RedirectToAction("index", "home", new { email = Session["uname"].ToString() })); } string message = ""; using (nlbdataEntities dc = new nlbdataEntities()) { var v = dc.NBA_SYS_Users.Where(a => a.email == login.email).FirstOrDefault(); if (v != null) { if (!v.sys_IsEmailVerified) { ViewBag.Message = "Please verify your email first"; return(View()); } if (string.Compare(Crypto.Hash(login.password), v.password) == 0) { Session["UseriD"] = GetuserID(login.email); int timeout = login.RememberMe ? 525600 : 20; // 525600 min = 1 year var ticket = new FormsAuthenticationTicket(login.email, login.RememberMe, timeout); string encrypted = FormsAuthentication.Encrypt(ticket); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted); cookie.Expires = DateTime.Now.AddMinutes(timeout); cookie.HttpOnly = true; Response.Cookies.Add(cookie); if (Url.IsLocalUrl(ReturnUrl)) { return(Redirect(ReturnUrl)); } // if (dc.NBA_Role.ToString()=="PGT") string role = GetRolesForUser(login.email); if (role == "4") { Session["uname"] = login.email; return(RedirectToAction("Index", "NBA_ManageBeneficiaries")); // return ("ManageGirls"); } else { return(RedirectToAction("Index", "Home")); } } else { ViewBag.message = "Invalid credential provided"; } } else { ViewBag.message = "Invalid credential provided"; } } ViewBag.Message = message; return(View()); }
//public ActionResult Create([Bind(Include = "AGWY_ID,name,surname,known_as,gender,race,type_of_identification,idno,dateOfbirth,place_of_birth,maiden_name,address,town_village,uic,email,phone_number,alternative_number,alternative_number_relationship,attended_school,name_of_school,higest_grade_passed,currrent_occupation,approval_flag,concent_flag,mimetype,imagedata,home_language,reg_date,last_updated,last_login,status,ID,SEMESTER_ID,SYS_USER_ID,DOCUMENT_ID,Core_ID,messageInquiry,EntryPoint_ID,HighSchoolQuizz_ID,RISK_ID")] NBA_Agwy nBA_Agwy) public ActionResult Create(NBA_Agwy nBA_Agwy) { if (ModelState.IsValid) { var db = new nlbdataEntities(); string uuic = nBA_Agwy.name.Substring(0, 4) + nBA_Agwy.surname.Substring(0, 4) + nBA_Agwy.dateOfbirth.ToString().Substring(0, 8); //r dbuic = db.NBA_Agwy.Where(x => x.uic.Substring(0, 15) == uuic).Select( n1 => n1.uic).FirstOrDefault(); //ar uic = db.NBA_Agwy.Where(x => x.uic.Substring(0, 15) == uuic).Select(n1 => n1.uic).FirstOrDefault(); //r uic1=(from var in db.NBA_Agwy where var.uic == nBA_Agwy.uic).select var.uic; //uic1.FirstOrDefault(); //tring dbui1 = dbuic.ToString(); var uiccount = db.NBA_Agwy.Where(x => x.uic.Substring(0, 16) == uuic).Select(n3 => n3.uic).Count(); int uiccounting = uiccount; NBA_Agwy n = new NBA_Agwy(); { n.name = nBA_Agwy.name; n.surname = nBA_Agwy.surname; n.known_as = nBA_Agwy.known_as; n.gender = nBA_Agwy.gender; n.age = nBA_Agwy.age; n.type_of_identification = nBA_Agwy.type_of_identification; n.idno = nBA_Agwy.idno; n.reg_date = DateTime.Today; int useridsession = Convert.ToInt32(Session["UseriD"]); n.SYS_USER_ID = useridsession; n.house_number = nBA_Agwy.house_number; n.street_name = nBA_Agwy.street_name; n.town_village_address = nBA_Agwy.town_village_address; n.describe_living = nBA_Agwy.describe_living; n.dateOfbirth = nBA_Agwy.dateOfbirth; n.maiden_name = nBA_Agwy.maiden_name; n.name_of_school = nBA_Agwy.name_of_school; n.alternative_number = nBA_Agwy.alternative_number; n.alternative_number_relationship = nBA_Agwy.alternative_number_relationship; n.attended_school = nBA_Agwy.attended_school; n.currrent_occupation = nBA_Agwy.currrent_occupation; n.email = nBA_Agwy.email; n.EntryPoint_ID = nBA_Agwy.EntryPoint_ID; n.higest_grade_passed = nBA_Agwy.higest_grade_passed; n.HighSchoolQuizz_ID = nBA_Agwy.HighSchoolQuizz_ID; n.known_as = nBA_Agwy.known_as; n.messageInquiry = nBA_Agwy.messageInquiry; n.NBA_Grade = nBA_Agwy.NBA_Grade; n.NBA_Identification = nBA_Agwy.NBA_Identification; n.ID = nBA_Agwy.ID; n.town_village = nBA_Agwy.town_village; n.NBA_Occupation = nBA_Agwy.NBA_Occupation; if (uiccounting > 1 || uiccounting == 1) { if (uiccounting < 9) { n.uic = nBA_Agwy.name.Substring(0, 4) + nBA_Agwy.surname.Substring(0, 4) + nBA_Agwy.dateOfbirth.ToString().Substring(0, 8) + "0" + (1 + uiccount).ToString(); } else { n.uic = nBA_Agwy.name.Substring(0, 4) + nBA_Agwy.surname.Substring(0, 4) + nBA_Agwy.dateOfbirth.ToString().Substring(0, 8) + (1 + uiccount).ToString(); } } else { n.uic = nBA_Agwy.name.Substring(0, 4) + nBA_Agwy.surname.Substring(0, 4) + nBA_Agwy.dateOfbirth.ToString().Substring(0, 8) + "00"; } } db.NBA_Agwy.Add(n); db.SaveChanges(); return(RedirectToAction("Index")); ////db.NBA_Agwy.Add(nBA_Agwy); ////db.SaveChanges(); ////return RedirectToAction("Index"); } ViewBag.Core_ID = new SelectList(db.NBA_Core, "CORE_ID", "description", nBA_Agwy.Core_ID); ViewBag.DOCUMENT_ID = new SelectList(db.NBA_Documents, "DOCUMENT_ID", "doc_name", nBA_Agwy.DOCUMENT_ID); ViewBag.EntryPoint_ID = new SelectList(db.NBA_Entry_Points, "ENTRY_ID", "description", nBA_Agwy.EntryPoint_ID); ViewBag.gender = new SelectList(db.NBA_Gender, "GenderID", "GenderType", nBA_Agwy.gender); ViewBag.higest_grade_passed = new SelectList(db.NBA_Grade, "Grade_ID", "Description", nBA_Agwy.higest_grade_passed); ViewBag.HighSchoolQuizz_ID = new SelectList(db.NBA_HighSchoolQuizz, "HighSchoolQuiz_ID", "Description", nBA_Agwy.HighSchoolQuizz_ID); ViewBag.type_of_identification = new SelectList(db.NBA_Identification, "Identification_ID", "Description", nBA_Agwy.type_of_identification); ViewBag.messageInquiry = new SelectList(db.NBA_MessageID, "MessageID", "Description", nBA_Agwy.messageInquiry); ViewBag.currrent_occupation = new SelectList(db.NBA_Occupation, "Occupation_ID", "Description", nBA_Agwy.currrent_occupation); ViewBag.RISK_ID = new SelectList(db.NBA_RiskAssessment, "RISK_ID", "risk_description", nBA_Agwy.RISK_ID); ViewBag.SEMESTER_ID = new SelectList(db.NBA_SemesterMaintenance, "SEMESTER_ID", "semester_name", nBA_Agwy.SEMESTER_ID); ViewBag.ID = new SelectList(db.NBA_PR, "ID", "PR_SR_ID", nBA_Agwy.ID); return(View(nBA_Agwy)); }