public ActionResult EmailSend(int id) { bool status = false; string msg; string toemail; if (User.Identity.IsAuthenticated) { string username = User.Identity.Name; using (DroneDBEntities dbe = new DroneDBEntities()) { var v = dbe.Users.Where(a => a.UserID == id).FirstOrDefault(); try { var adminchk = dbe.Users.Where(a => a.EmailID == username).FirstOrDefault(); if (v != null && v.IsEmailVerified && adminchk.AdminType == true) { string secret = Convert.ToString(v.GlobalID); toemail = v.EmailID; if (!v.Visachk && !v.Nocchk) { string body; body = "your Visa and NoC"; sendUpdates(toemail, secret, body); } else if (!v.Visachk || !v.Nocchk) { string body; if (v.Nocchk) { body = "your Visa "; } else { body = "your NoC "; } sendUpdates(toemail, secret, body); } msg = "Successfully Send to " + toemail; status = true; } else { msg = "Invalid Send Request"; status = false; } } catch { msg = "This is not a verified Email Id"; status = false; } } ViewBag.Message = msg; } return(View()); }
public JsonResult GetStateById(int ID) { DroneDBEntities ds = new DroneDBEntities(); ds.Configuration.ProxyCreationEnabled = false; stateflag = false; return(Json(ds.states.Where(p => p.country_id == ID), JsonRequestBehavior.AllowGet)); }
public bool IsEmailExist(string emailID) { using (DroneDBEntities de = new DroneDBEntities()) { var EC = de.Users.Where(a => a.EmailID == emailID).FirstOrDefault(); return(EC != null);// if not equal to null means True } }
public ActionResult Save(int id) { using (DroneDBEntities dbe = new DroneDBEntities()) { var v = dbe.Users.Where(a => a.UserID == id).FirstOrDefault(); return(View(v)); } }
public ActionResult Registration() { DroneDBEntities drop = new DroneDBEntities(); ViewBag.SelectValue = new SelectList(drop.countries, "id", "name"); ViewBag.StateSelect = new SelectList(drop.states, "state_id", "name"); // ViewBag.StateSelect = ""; stateflag = true; return(View()); }
[HttpGet]//Get all Annocement public JsonResult GetAnnoucement() { bool status = false; using (DroneDBEntities dc = new DroneDBEntities()) { List <Annoucement> annouceList = dc.Annoucements.ToList <Annoucement>(); return(Json(annouceList, JsonRequestBehavior.AllowGet)); } }
// Login Post public async Task <ActionResult> Login(DroneMainAdmin.Models.UserLogin login, string ReturnUrl = "") { bool Status = false; string message = ""; using (DroneDBEntities dc = new DroneDBEntities()) { var v = dc.Users.Where(a => a.EmailID == login.EmailID).FirstOrDefault(); if (v != null) { if (string.Compare(Crypto.Hash(login.Password), v.Password) == 0) { int timeout = login.RememberMe ? 525600 : 20;// 525600 minute = 1 year here timeout time is 20 min var ticket = new FormsAuthenticationTicket(login.EmailID, 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 (v.AdminType && v.IsEmailVerified) { Status = true; // return message = "Successfully Login"; return(RedirectToAction("Index", "TeamList")); } else if (v.IsEmailVerified) { Status = true; message = "Successfully Login"; return(RedirectToAction("Index", "Home")); } else if (Url.IsLocalUrl(ReturnUrl)) { message = "Redirect To Home"; return(Redirect(ReturnUrl)); } } else { Status = false; message = "Invalid Credential Provided "; } } else { message = "Invalid Credential Provided "; } } ViewBag.Status = Status; ViewBag.Message = message; return(View()); }
public JsonResult GetTeams() { bool status = false; using (DroneDBEntities dc = new DroneDBEntities()) { List <User> userList = dc.Users.ToList <User>(); ViewBag.Message = "Data Loading.."; //var team = dc.Users.OrderBy(a => a.FirstName).ToList(); // return Json(new { success = status, messgae = userList }, JsonRequestBehavior.AllowGet); return(Json(userList, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit([Bind(Exclude = "ConfirmPassword")] DroneMainAdmin.Models.User user, int id) { DroneDBEntities drop = new DroneDBEntities(); if (User.Identity.IsAuthenticated) { string username = User.Identity.Name; var v = drop.Users.Where(a => a.UserID == id).FirstOrDefault(); try { var adminchk = drop.Users.Where(a => a.EmailID == username).FirstOrDefault(); if (v != null && adminchk.AdminType == true) { string selected = (from sub in drop.Users where sub.UserID == id select sub.CountryName).FirstOrDefault(); ViewBag.SelectValue = new SelectList(drop.countries, "name", "name", selected); string stateselect = (from sub in drop.Users where sub.UserID == id select sub.Provinance).FirstOrDefault(); ViewBag.StateSelect = new SelectList(drop.states, "name", "name", stateselect); ViewBag.DateSet = (from sub in drop.Users where sub.UserID == id select sub.DateOfBirth).FirstOrDefault(); user = dbe.Users.Find(id); } else { ViewBag.Message = "You are Not Authorize for View This Page"; return(RedirectToAction("Index")); } } catch (Exception ex) { ViewBag.Message = "You are Not Authorize for View This Page"; return(RedirectToAction("Index")); } } else { ViewBag.Message = "You are Not Authorize for View This Page"; return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult ForgetPassword(User user, string emailID, string activationcode, string oldpass) { bool Status = false; string message = ""; if (!ModelState.IsValid) { Random rnd = new Random(); #region //Email is already Exist Check var isExist = IsEmailExist(user.EmailID); if (isExist) { using (DroneDBEntities dc = new DroneDBEntities()) { dc.Configuration.ValidateOnSaveEnabled = false; var EC = dc.Users.Where(a => a.EmailID == emailID).FirstOrDefault(); if (EC != null) { try { EC.GlobalID = Guid.NewGuid(); dc.SaveChanges(); ForgetPassChange(EC.GlobalID.ToString()); message = "Forget Password Link has been successfully Sent To your Email Account Please Check Your Email Account: " + user.EmailID; Status = true; } catch (Exception ex) { } } else { message = "Invalid Request"; Status = false; } //Send Email to Users return(RedirectToAction("Login", "User")); } } } return(View()); }
public void EmailSwitch(string[] email) { using (DroneDBEntities dc = new DroneDBEntities()) { string[] ToList = dc.Users.Select(x => x.EmailID).ToArray(); string[] fromemailList = dc.CompainSets.Select(x => x.email).ToArray(); string[] passList = dc.CompainSets.Select(x => x.pass).ToArray(); int?[] PortList = dc.CompainSets.Select(x => x.Portno).ToArray(); string[] HostList = dc.CompainSets.Select(x => x.Hostname).ToArray(); int Toemailcount = ToList.Count(); int emailcount = fromemailList.Count(); for (int h = 0; h <= emailcount; h++) { for (int g = 0; g <= Toemailcount; g++) { var chkvi = dbe.Users.Where(x => x.EmailID == ToList[g].ToString()).FirstOrDefault(); if (!chkvi.Visachk && !chkvi.Nocchk) { sendUpdates(fromemailList[h].ToString(), ToList[g].ToString(), passList[h].ToString(), PortList[h].Value, HostList[h].ToString(), 1, 2); } else if (!chkvi.Visachk || !chkvi.Nocchk) { if (!chkvi.Visachk && chkvi.Nocchk) { int visa = 1; var getId = dbe.Users.Where(x => x.EmailID == ToList[g].ToString()).FirstOrDefault(); int noc = getId.UserID; sendUpdates(fromemailList[h].ToString(), ToList[g].ToString(), passList[h].ToString(), PortList[h].Value, HostList[h].ToString(), visa, noc); } else { int visa = 0; //int noc = 2; var getId = dbe.Users.Where(x => x.EmailID == ToList[g].ToString()).FirstOrDefault(); int noc = getId.UserID; sendUpdates(fromemailList[h].ToString(), ToList[g].ToString(), passList[h].ToString(), PortList[h].Value, HostList[h].ToString(), visa, noc); } } } } } }
public ActionResult AddOrEdit(int id = 0) { bool status = false; DroneDBEntities drop = new DroneDBEntities(); if (User.Identity.IsAuthenticated) { string username = User.Identity.Name; var v = drop.Users.Where(a => a.UserID == id).FirstOrDefault(); try { var adminchk = drop.Users.Where(a => a.EmailID == username).FirstOrDefault(); if (v == null && adminchk.AdminType == true) { if (id == 0) { ViewBag.SelectValue = new SelectList(drop.countries, "id", "name"); ViewBag.StateSelect = new SelectList(drop.states, "state_id", "name"); ViewBag.Status = true; ViewBag.Message = "Edit " + username + " detailes here"; return(View(new User())); } } else { ViewBag.Status = false; ViewBag.Message = username + " : you are not Authorize for upadate or edit of user Record"; return(Json(new { success = false, messgae = ViewBag.Message }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { ViewBag.Status = false; ViewBag.Message = username + " : you are not Authorize for upadate or edit of user Record"; } } return(View(User)); }
public ActionResult DeleteUser(int id) { bool status = false; if (User.Identity.IsAuthenticated) { string username = User.Identity.Name; using (DroneDBEntities dbe = new DroneDBEntities()) { var v = dbe.Users.Where(a => a.UserID == id).FirstOrDefault(); try { var adminchk = dbe.Users.Where(a => a.EmailID == username).FirstOrDefault(); if (v != null && adminchk.AdminType == true) { dbe.Users.Remove(v); dbe.SaveChanges(); status = true; ViewBag.Message = v.EmailID + " User Record Delete Successfully"; } else { status = false; ViewBag.Message = "You are Not Authorize for this request"; } } catch (Exception) { status = false; ViewBag.Message = "This is Invalid User Request"; return(RedirectToAction("TeamList")); } } } return(Json(new { success = status, messgae = ViewBag.Message }, JsonRequestBehavior.AllowGet)); }
public ActionResult ForgetPassChange(string id) { bool Status = false; string message = ""; try { using (DroneDBEntities dc = new DroneDBEntities()) { dc.Configuration.ValidateOnSaveEnabled = false; // Avoid Confirmation password does not match on save changes var v = dc.Users.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault(); if (v != null) { v.IsEmailVerified = true; var changepass = v.Password; v.Password = rnd.Next(0003000, 99999999).ToString(); v.ActivationCode = Guid.NewGuid(); dc.SaveChanges(); SendChangePassword(v.EmailID, v.ActivationCode.ToString(), ""); Status = true; message = "Succefully Change Your Password"; } else { message = "Invalid Request"; Status = false; } } } catch (Exception) { message = "Invalid Request"; Status = false; } ViewBag.Message = message; ViewBag.Status = Status; return(RedirectToAction("Login", "User")); }
public ActionResult ChangePass(DroneMainAdmin.Models.User user, string emailID, string activationcode, string oldpass, string id) { bool status = false; string message = ""; using (DroneDBEntities dc = new DroneDBEntities()) { dc.Configuration.ValidateOnSaveEnabled = false;// Avoid Confirmation password does not match on save changes try { var v = dc.Users.Where(a => a.GlobalID == new Guid(id)).FirstOrDefault(); if (v != null) { var changePass = user.Password; changePass = Crypto.Hash(user.Password); v.GlobalID = Guid.NewGuid(); v.Password = changePass; dc.SaveChanges(); status = true; message = "Your Account Password is changed and your password has been sent to your registered Email address.Please Check your email id for updated new password ."; SendChangePassword(v.EmailID, "", user.Password.ToString()); } else { message = "Invalid Request"; status = false; } } catch (Exception) { message = "Invalid Request"; status = false; } } ViewBag.Message = message; ViewBag.Status = status; return(View()); }
public ActionResult VerifyAccount(string id) { bool Status = false; string message = ""; try { using (DroneDBEntities dc = new DroneDBEntities()) { dc.Configuration.ValidateOnSaveEnabled = false; // Avoid Confirmation password does not match on save changes var v = dc.Users.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault(); if (v != null) { v.IsEmailVerified = true; v.ActivationCode = Guid.NewGuid(); dc.SaveChanges(); Status = true; message = "Succefully Verified Your Email account and your account is Activate Now"; } else { message = "Invalid Request"; Status = false; } } } catch (Exception) { message = "Invalid Request"; Status = false; } ViewBag.Message = message; ViewBag.Status = Status; return(View()); }
public ActionResult Registration([Bind(Exclude = "IsEmailVerified,ActivationCode,AdminType")] DroneMainAdmin.Models.User user) { bool Status = false; string message = ""; //Model Validation if (ModelState.IsValid) { #region //Email is already Exist Check var isExist = IsEmailExist(user.EmailID); if (isExist) { ModelState.AddModelError("EmailExist", "Email is already Exist"); return(View(user)); } // user.UserID = user.UserID; #endregion #region Generate Activation Code user.ActivationCode = Guid.NewGuid(); #endregion #region Password Hashing user.Password = Crypto.Hash(user.Password); user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword); DroneDBEntities drop = new DroneDBEntities(); int county = Convert.ToInt16(user.CountryName); int stat = Convert.ToInt16(user.Provinance); //int county= Convert.ToInt16(user.CountryName); var nam = drop.countries.Where(p => p.id == county).FirstOrDefault(); var sat = drop.states.Where(x => x.state_id == stat).FirstOrDefault(); user.CountryName = nam.name; user.Provinance = sat.name; user.IsEmailVerified = false; if (user.SubEmail) { user.SubEmail = true; } else { user.SubEmail = false; } if (user.TermsAccepted) { user.TermsAccepted = true; } else { user.TermsAccepted = false; } user.Provinance = user.Provinance; user.CountryName = user.CountryName; #endregion #region Save Data to Database using (DroneDBEntities dc = new DroneDBEntities()) { dc.Users.Add(user); try { dc.SaveChanges(); SendVerificationLinkEmail(user.EmailID, user.ActivationCode.ToString()); message = "Registration is successfully done. Account activation link " + " has been sent to your email id : " + user.EmailID; Status = true; } catch (DbEntityValidationException ex) { StringBuilder sb = new StringBuilder(); foreach (var eve in ex.EntityValidationErrors) { sb.AppendLine(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var ve in eve.ValidationErrors) { sb.AppendLine(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage)); } } message = "Error Message :" + ex; } //Send Email to Users return(RedirectToAction("Registration", "User")); } #endregion } else { message = "Invalid Request"; } ViewBag.Message = message; ViewBag.Status = Status; return(View(user)); }
public ActionResult Edit([Bind(Exclude = "ConfirmPassword")] DroneMainAdmin.Models.User user) { bool status = false; string message = ""; if (User.Identity.IsAuthenticated) { if (!ModelState.IsValid) { using (DroneDBEntities db = new DroneDBEntities()) { string username = User.Identity.Name; var v = dbe.Users.Where(a => a.UserID == user.UserID).FirstOrDefault(); try { var adminchk = dbe.Users.Where(a => a.EmailID == username).FirstOrDefault(); if (v != null && adminchk.AdminType == true) { db.Configuration.ValidateOnSaveEnabled = false; // Avoid Confirmation password does not match on save changes v.FirstName = user.FirstName; v.MiddleName = user.MiddleName; v.LastName = user.LastName; v.EmailID = user.EmailID; v.ContactNo = user.ContactNo; v.TeamName = user.TeamName; if (user.Password.Length <= 42) { v.Password = Crypto.Hash(user.Password); } // v.Password = user.Password; // v.ConfirmPassword = user.ConfirmPassword; // v.DateOfBirth = user.DateOfBirth; if (user.IsEmailVerified) { v.IsEmailVerified = true; } else { v.IsEmailVerified = false; } v.CountryName = user.CountryName; if (user.SubEmail) { v.SubEmail = true; } else { v.SubEmail = false; } v.Decscript = user.Decscript; if (user.AdminType == true) { v.AdminType = true; } else { v.AdminType = false; } try { // db.Users.Add(v); // db.Entry(user).State = System.Data.Entity.EntityState.Modified; db.Entry(v).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } catch (DbEntityValidationException ex) { StringBuilder sb = new StringBuilder(); foreach (var eve in ex.EntityValidationErrors) { sb.AppendLine(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var ve in eve.ValidationErrors) { sb.AppendLine(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage)); } } message = "Error Message :" + ex; } status = true; ViewBag.Message = "User Profile is Succesfully Updated"; } else { ViewBag.Message = "You are not Authorize for doing changes in User Record,\n for more contact administrator"; } } catch (Exception ex) { } } } } return(RedirectToAction("Index", "TeamList")); }