public ActionResult Countries()
{
using (var dc = new CoronaEntities())
{
return(PartialView(dc.Country.ToList()));
}
}
public ActionResult Markers()
{
using (var dc = new CoronaEntities())
{
return(PartialView(dc.Marker.ToList()));
}
}
public ActionResult ResendVerification(string EmailID)
{
//Verify Email ID
//Generate Reset password link
//Send Email
string message = "";
bool status = false;
using (CoronaEntities dc = new CoronaEntities())
{
var account = dc.User.Where(a => a.EmailID == EmailID).FirstOrDefault();
if (account != null)
{
//Send email for reset password
SendVerificationLinkEmail(account.EmailID, account.ActivationCode.ToString());
//This line I have added here to avoid confirm password not match issue, as we had added a confirm password property
//in cur model class in part 1
message = Resources.Language.ActivationLinkSent;
status = true;
}
else
{
message = Resources.Language.InvalidUser;
}
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View());
}
public ActionResult ForgotPassword(string EmailID)
{
//Verify Email ID
//Generate Reset password link
//Send Email
string message = "";
bool status = false;
using (CoronaEntities dc = new CoronaEntities())
{
var account = dc.User.Where(a => a.EmailID == EmailID).FirstOrDefault();
if (account != null)
{
//Send email for reset password
string resetCode = Guid.NewGuid().ToString();
SendVerificationLinkEmail(account.EmailID, resetCode, "ResetPassword");
account.ResetPasswordCode = resetCode;
//This line I have added here to avoid confirm password not match issue, as we had added a confirm password property
//in cur model class in part 1
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = Resources.Language.ResetPasswordSent;
status = true;
}
else
{
message = Resources.Language.InvalidUser;
}
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View());
}
public ActionResult ResetPassword(ResetPasswordModel model)
{
var message = "";
bool status = false;
if (ModelState.IsValid)
{
using (CoronaEntities dc = new CoronaEntities())
{
var user = dc.User.Where(a => a.ResetPasswordCode == model.ResetCode).FirstOrDefault();
if (user != null)
{
user.Password = Crypto.Hash(model.NewPassword);
user.ResetPasswordCode = "";
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = Resources.Language.NewPasswordUpdate;
status = true;
}
}
}
else
{
message = Resources.Language.InvalidRequest;
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View(model));
}
public ActionResult States(int CountryID)
{
using (var dc = new CoronaEntities())
{
return(PartialView(dc.State.Where(x => x.CountryID == CountryID).ToList()));
}
}
public bool IsEmailExist(string emailID)
{
using (CoronaEntities dc = new CoronaEntities())
{
var v = dc.User.Where(a => a.EmailID == emailID).FirstOrDefault();
return(v != null);
}
}
public ActionResult Registration([Bind(Exclude = "IsEmailVerified,ActivationCode")] User user)
{
bool Status = false;
string message = "";
//
// Model Validation
if (ModelState.IsValid)
{
#region Email is already Exist
var isExist = IsEmailExist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email already exist");
return(View(user));
}
#endregion
#region Generate Action Code
user.ActivationCode = Guid.NewGuid();
#endregion
#region Password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword);
#endregion
user.IsEmailVerified = false;
#region Save data to Database
using (CoronaEntities dc = new CoronaEntities())
{
dc.User.Add(user);
dc.SaveChanges();
#region Send Email to User
SendVerificationLinkEmail(user.EmailID, user.ActivationCode.ToString());
message = "Registration successfully done. Account activation link " +
" has beem sent to your email id:" + user.EmailID;
Status = true;
#endregion
}
#endregion
}
else
{
message = Resources.Language.InvalidRequest;
}
//
//
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
}
public ActionResult Edit(int RegisterID)
{
using (var dc = new CoronaEntities())
{
//Register reg = dc.Register.Where(x => x.RegisterID == RegisterID).FirstOrDefault();
Register reg = dc.Register.Find(RegisterID);
return(View(reg));
}
}
public ActionResult Cities(int StateID)
{
using (var dc = new CoronaEntities())
{
return(PartialView(dc.City.Where(x => x.StateID == StateID).OrderBy(x => x.City1).ToList()));
//var result = dc.City.Where(x => x.StateID == StateID).ToList();
//ViewBag.Ciudad = result;
//return PartialView(result);
}
}
public ActionResult Delete(int RegisterID)
{
using (var dc = new CoronaEntities())
{
Register reg = dc.Register.Find(RegisterID);
dc.Register.Remove(reg);
dc.SaveChanges();
return(RedirectToAction("Index"));
}
}
public int UserCountry()
{
using (var dc = new CoronaEntities())
{
var userCountry = 157;
if (System.Web.HttpContext.Current.User.Identity.Name.ToString() != string.Empty)
{
userCountry = dc.User.Where(x => x.EmailID == System.Web.HttpContext.Current.User.Identity.Name).FirstOrDefault().CountryID;
}
return(userCountry);
}
}
public ActionResult Index()
{
using (var dc = new CoronaEntities())
{
var user = 1;
if (System.Web.HttpContext.Current.User.Identity.Name.ToString() != string.Empty)
{
user = dc.User.Where(x => x.EmailID == System.Web.HttpContext.Current.User.Identity.Name).FirstOrDefault().UserID;
}
return(View(dc.Register.Where(x => x.UserID == user).ToList()));
}
}
public ActionResult Donations()
{
using (var dc = new CoronaEntities())
{
var FirstName = "Usuario";
if (System.Web.HttpContext.Current.User.Identity.Name.ToString() != string.Empty)
{
FirstName = dc.User.Where(x => x.EmailID == System.Web.HttpContext.Current.User.Identity.Name).FirstOrDefault().FirstName;
}
ViewBag.FirstName = FirstName;
return(View());
}
}
public JsonResult SearchByCity(int CityID)
{
using (var dc = new CoronaEntities())
{
var City = dc.City
.Where(x => x.CityID == CityID)
.Select(a => new
{
Lat = a.Lat,
Lon = a.Lon
}).ToList();
return(Json(City));
}
}
public ActionResult Login(UserLogin login, string ReturnUrl = "")
{
string message = "";
using (CoronaEntities dc = new CoronaEntities())
{
var v = dc.User.Where(a => a.EmailID == login.EmailID).FirstOrDefault();
if (v != null)
{
if (string.Compare(Crypto.Hash(login.Password), v.Password) == 0)
{
if (v.IsEmailVerified == true)
{
int timeout = login.RememberMe ? 525600 : 20; // 525600 min=year
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 (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
message = Resources.Language.VerifyEmail;
}
}
else
{
message = Resources.Language.InvalidPassword;
}
}
else
{
message = Resources.Language.InvalidUser;
}
}
ViewBag.Message = message;
return(View());
}
public JsonResult RegisterByCityMarker(int CityID, int MarkerID = 0)
{
using (var dc = new CoronaEntities())
{
if (MarkerID != 0)
{
var City = dc.V_RegByCity
.Where(x => x.CityID == CityID)
.Where(y => y.MarkerID == MarkerID)
.Select(a => new
{
RegisterID = a.RegisterID,
MarkerID = a.MarkerID,
Latlng = a.Latlng,
Message = a.Message,
Url = a.Url,
Lat = a.Lat,
Lon = a.Lon,
Address = a.Address,
FirstName = a.FirstName,
ImageHtml = a.ImageHtml,
Contact = a.Contact
}).ToList();
return(Json(City));
}
else
{
var City = dc.V_RegByCity
.Where(x => x.CityID == CityID)
.Select(a => new
{
RegisterID = a.RegisterID,
MarkerID = a.MarkerID,
Latlng = a.Latlng,
Message = a.Message,
Url = a.Url,
Lat = a.Lat,
Lon = a.Lon,
Address = a.Address,
FirstName = a.FirstName,
ImageHtml = a.ImageHtml,
Contact = a.Contact
}).ToList();
return(Json(City));
}
}
}
public ActionResult ResetPassword(string id)
{
//Verify the reset password link
//Find account associated with this link
//redirect to reset password page
using (CoronaEntities dc = new CoronaEntities())
{
var user = dc.User.Where(a => a.ResetPasswordCode == id).FirstOrDefault();
if (user != null)
{
ResetPasswordModel model = new ResetPasswordModel();
model.ResetCode = id;
return(View(model));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult Register(Register model)
{
if (!ModelState.IsValid)
{
return(View());
}
try
{
if (model.ImageFile != null)
{
string fileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName);
string extension = Path.GetExtension(model.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
model.ImagePath = "/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
model.ImageFile.SaveAs(fileName);
}
using (var dc = new CoronaEntities())
{
var user = 1;
if (System.Web.HttpContext.Current.User.Identity.Name.ToString() != string.Empty)
{
user = dc.User.Where(x => x.EmailID == System.Web.HttpContext.Current.User.Identity.Name).FirstOrDefault().UserID;
}
model.UserID = user;
model.CrtdDate = DateTime.Today;
model.Active = true;
dc.Register.Add(model);
dc.SaveChanges();
TempData["Message"] = "Success";
return(RedirectToAction("Search"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error al agregar el registro", ex);
return(View());
}
}
public ActionResult Edit(Register a)
{
try
{
//if (!ModelState.IsValid)
//{
// return View();
//}
using (var dc = new CoronaEntities())
{
Register reg = dc.Register.Find(a.RegisterID);
reg.Message = a.Message;
reg.Address = a.Address;
dc.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception)
{
throw;
}
}
public ActionResult VerifyAccount(string id)
{
bool Status = false;
using (CoronaEntities dc = new CoronaEntities())
{
dc.Configuration.ValidateOnSaveEnabled = false; //This line I have added here to avoid
//Confirm password does not match issue on save change
var v = dc.User.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault();
if (v != null)
{
v.IsEmailVerified = true;
dc.SaveChanges();
Status = true;
}
else
{
ViewBag.Message = Resources.Language.InvalidRequest;
}
}
ViewBag.Status = Status;
return(View());
}
