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"));
}
