public ActionResult Help(UsuariosModel ousuariosmodel)
{
BOLogin oBOLogin = new BOLogin();
String token = oBOLogin.randomPassword();
using (Games_MarketEntities db = new Games_MarketEntities())
{
var oUsuario = db.usuarios.Where(d => d.email == ousuariosmodel.email).FirstOrDefault();
if (oUsuario != null)
{
oUsuario.token = token;
db.SaveChanges();
String Dominio = "https://*****:*****@gmail.com", ousuariosmodel.email, "Restaurar contraseña GamesMarket",
"<p>Hola " + ousuariosmodel.nombre + " haz click en el link de abajo para redirigirte a la pantalla de cambio de contraseña.</p><br>" +
"<a href='" + url + "'>Click para recuperar</a>");
BOMail oBOMail = new BOMail();
oBOMail.sendEmail(oMailMessage);
return(View("CorrectSend"));
}
else
{
ViewBag.error = "El correo no corresponde con ninguno registrado en la web. Revisa tus credenciales.";
}
}
return(View());
}
public int ResetPassword(BOLogin ob)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
var para = new DynamicParameters();
para.Add("@UserName", ob.UserName);
para.Add("@Password", ob.NewPassword);
para.Add("@Sptype", 2);
para.Add("@pOutPut", dbType: DbType.Int32, direction: ParameterDirection.Output);
if (ob.RoleId == 6)//Public
{
con.Execute("Usp_Applicantlogin", para, null, 0, CommandType.StoredProcedure);
}
// return con.Query<BOLogin>("Usp_Applicantlogin", para, null, true, 0, commandType: CommandType.StoredProcedure).ToList();
else
{
con.Execute("Usp_Userlogin", para, null, 0, CommandType.StoredProcedure);
}
//return con.Query<BOLogin>("Usp_Userlogin", para, null, true, 0, commandType: CommandType.StoredProcedure).ToList();
int MemID = para.Get <int>("@pOutPut");
return(MemID);
}
}
public ActionResult Register(UsuariosModel oregisterModel)
{
BOLogin oBOLogin = new BOLogin();
if (!ModelState.IsValid)
{
ViewBag.error = "Faltan campos por rellenar.";
return(View(oregisterModel));
}
if (oBOLogin.getUsuarioByEmail(oregisterModel.email) != null)
{
ViewBag.error = "El email ya ha sido registrado previamente";
return(View(oregisterModel));
}
if (oregisterModel.contrasena != oregisterModel.contrasena2)
{
ViewBag.error = "Las contraseñas no son iguales";
return(View(oregisterModel));
}
else
{
oBOLogin.addUser(oregisterModel);
return(RedirectToAction("../Login/Login"));
}
}
public ActionResult Login(UsuariosModel usuariosModel)
{
if (usuariosModel.email == null)
{
ViewBag.error = "Falta el correo electrónico";
return(View());
}
if (usuariosModel.contrasena == null)
{
ViewBag.error = "Falta la contraseña";
return(View());
}
BOLogin oBOLogin = new BOLogin();
if (oBOLogin.login(usuariosModel) != null)
{
usuariosModel = oBOLogin.login(usuariosModel);
Session["Log"] = usuariosModel.id_usuario;
Session["LogName"] = usuariosModel.nombre;
return(RedirectToAction("../Home/Home"));
}
else
{
ViewBag.error = "Email o contraseña incorrecta";
return(View());
}
}
public ActionResult delWish(int id)
{
BOLogin oBOLogin = new BOLogin();
usuarios user = oBOLogin.getUsuarioById((int)Session["Log"]);
BOLibrary oBOLibrary = new BOLibrary();
oBOLibrary.removeFromWish(user.id_usuario, id);
return(RedirectToAction("../Games/Game/" + id));
}
public ActionResult UserData()
{
BOLogin oBOLogin = new BOLogin();
usuarios usuario = oBOLogin.getUsuarioById((int)Session["Log"]);
UsuariosModel usuariosModel = new UsuariosModel();
usuariosModel.email = usuario.email;
usuariosModel.nombre = usuario.nombre;
usuariosModel.apellidos = usuario.apellidos;
return(View(usuariosModel));
}
public ActionResult buysLibrary()
{
if (Session["Log"] is null)
{
return(RedirectToAction("../Home/home"));
}
BOLogin oBOLogin = new BOLogin();
usuarios usuario = oBOLogin.getUsuarioById((int)Session["Log"]);
BOLibrary oBOLibrary = new BOLibrary();
List <BuysLibraryModel> listBuysLibraryModel = oBOLibrary.getBuysLibrary(usuario.id_usuario);
return(View(listBuysLibraryModel));
}
public ActionResult wishLibrary()
{
if (Session["Log"] is null)
{
return(RedirectToAction("../Login/Login"));
}
BOLogin oBOLogin = new BOLogin();
usuarios usuario = oBOLogin.getUsuarioById((int)Session["Log"]);
BOLibrary oBOLibrary = new BOLibrary();
List <JuegosModel> listaJuegos = oBOLibrary.getWishLibrary(usuario.id_usuario);
return(View(listaJuegos));
}
public ActionResult ChangePassword()
{
BOLogin std = new BOLogin();
if (UserSession.LoggedInUserRole == 6)
{
std.UserName = UserSession.LoggedInUserId.ToString();
}
else
{
std.UserName = UserSession.LoggedInUserName.ToString();
}
//std.TypeOfUser = UserSession.LoggedUserType;
std.RoleId = UserSession.LoggedInUserRole;
string salt = CreateSalt(5);
Session["salt"] = salt.ToString();
return(View(std));
}
public BOUser GetUser(BOLogin l)
{
var tmp = AwardDBEntities.Users.Select(u => new BOUser
{
Designation = u.Designation,
DOB = u.DOB,
DOJ = u.DOJ,
Email = u.Email,
Gender = u.Gender,
Image = u.Image,
IsActive = u.IsActive,
IsDisable = u.IsDisable,
Mobile = u.Mobile,
Name = u.Name,
Password = u.Password,
UserId = u.UserId,
UserRoles = u.UserRoles.Select(x => new BOUserRole
{
AwardId = x.AwardId,
RoleId = x.RoleId,
UserId = x.UserId,
IsDisable = x.IsDisable,
Role = new BORole
{
Role1 = x.Role.Role1,
RoleId = x.Role.RoleId,
IsDisable = x.Role.IsDisable
}
}).ToList(),
Applications = u.Applications.Select(a => new BOApplication {
AppId = a.AppId, AppliedDate = a.AppliedDate, Stage = a.Stage, AwdId = a.AwdId, UserId = a.UserId
}).ToList(),
}).Where(s => s.Email == l.Email && s.Password == l.Password).SingleOrDefault();
if (tmp != null)
{
return(tmp);
}
return(null);
}
public ActionResult ResetPassword(BOLogin ob)
{
ObjUserLogin = new UserLogin();
var Userdtl = ObjUserLogin.VerifyUser(ob.UserName, ob.RoleId).FirstOrDefault();
if (Userdtl != null)
//if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows.Count == 1)
{
string psw = Userdtl.Password;
ViewData["attempts"] = Userdtl.LoginAttempts;
string hashed_pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(psw.ToString().ToLower() + Session["salt"].ToString(), "md5");
// macth the both passwords
if (hashed_pwd.ToString().ToLower().Equals(ob.OldPassword.ToLower()))
{
//string PasswordPattern = @"^(?=.*[0-9])(?=.*[!@#$%^&*])[0-9a-zA-Z!@#$%^&*0-9]{10,}$";
//if (!Regex.IsMatch(ob.ConFirmPassword, PasswordPattern))
//{
// ViewBag.msg = "Please Be sure that you have fulfilled all the password policy.";
// //return Task.FromResult(IdentityResult.Failed(String.Format("The Password must have at least one numeric and one special character")));
//}
//else
//{
int i = ObjUserLogin.ResetPassword(ob);
if (i == 1)
{
ViewBag.msg = "Password Change successfully .... login with changed password !!";
//return Json(new { success = true, msg = "Password Change successfully....login with changed password !!" }, JsonRequestBehavior.AllowGet);
}
}
}
return(View(ob));
}
public ActionResult ChangePassword(BOLogin ob)
{
ObjUserLogin = new UserLogin();
var Userdtl = ObjUserLogin.VerifyUser(ob.UserName, ob.RoleId).FirstOrDefault();
if (Userdtl != null)
//if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows.Count == 1)
{
string psw = Userdtl.Password;
ViewData["attempts"] = Userdtl.LoginAttempts;
string hashed_pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(psw.ToString().ToLower() + Session["salt"].ToString(), "md5");
// macth the both passwords
if (hashed_pwd.ToString().ToLower().Equals(ob.OldPassword.ToLower()))
{
//int i = ObjUserLogin.InitChangePassword(ob);
//if (i == 1)
//{
// ViewBag.msg = "Password Change successfully .... login with changed password !!";
//}
}
}
return(View(ob));
}
public async System.Threading.Tasks.Task <ActionResult> Login(FormCollection FC)
{
BOLogin BL = new BOLogin();
BL.Email = FC ["Email"];
BL.Password = FC ["Password"];
try
{
var Response = await client.PostAsJsonAsync("Login", BL);
if (Response.IsSuccessStatusCode)
{
BOUser data = JsonConvert.DeserializeObject <BOUser>(Response.Content.ReadAsStringAsync().Result);
var d = data.UserRoles.Select(u => new BOUserRole
{
Role = new BORole
{
Role1 = u.Role.Role1,
RoleId = u.Role.RoleId,
IsDisable = u.Role.IsDisable
}
});
var b = d.Where(u => u.Role.Role1 == "Admin" && u.Role.IsDisable == false).Single();
if (b.IsDisable == false && b.Role.Role1 == "Admin")
{
Session ["UserName"] = data.Name;
Session ["UserEmail"] = FC ["Email"];
Session ["UserID"] = data.UserId;
return(RedirectToAction("Index", "Dashboard"));
}
}
}
catch (Exception e) { Console.WriteLine("Login Error: " + e.ToString()); }
return(RedirectToAction("Index", "Dashboard"));
}
public ActionResult Game(int?id, String comment)
{
//Control de errores
if (Session["Log"] == null)
{
return(RedirectToAction("/Login/Login"));
}
if (id == null)
{
return(RedirectToAction("../Games/Game/" + id));
}
juegos juego = new juegos();
using (var bd = new Games_MarketEntities())
{
juego = bd.juegos.Find(id);
}
if (juego == null || comment == "")
{
return(RedirectToAction("/Game"));
}
//Encuentra los datos del juego
BOJuegos oBOjuego = new BOJuegos();
JuegosModel juegosModel = oBOjuego.getJuegoById(id.Value);
//Encuentra los generos del juego
List <GenerosModel> oGenerosModel = oBOjuego.getGenerosById_juegosList(id.Value);
string generos = "";
foreach (var item in oGenerosModel)
{
generos += " " + @item.nombre;
}
ViewBag.generos = generos;
//Encuentra las capturas del juego
List <CapturasModel> listaCapturas = oBOjuego.getCapturasList(id.Value);
ViewData["capturas"] = listaCapturas;
//Añade el comentario
BOComentarios oBOComentarios = new BOComentarios();
if (comment != "")
{
oBOComentarios.post(id.Value, (int)Session["Log"], comment);
}
//Encuentra los comentarios
List <ComentariosModel> listaComentarios = oBOComentarios.getComments(id.Value);
ViewData["comentarios"] = listaComentarios;
if (listaComentarios.Count != 0)
{
ViewBag.checkComments = true;
}
//Comprueba si hay stock
BOClaves oBOClaves = new BOClaves();
ViewBag.stock = oBOClaves.checkStockClaveByid_juego(id.Value);
//Comprueba si el usuario lo tiene en lista de deseados
if (Session["Log"] != null)
{
BOLogin oBOLogin = new BOLogin();
usuarios usuario = oBOLogin.getUsuarioById((int)Session["Log"]);
BOLibrary oBOLibrary = new BOLibrary();
ViewBag.wish = oBOLibrary.checkWishList(usuario.id_usuario, id.Value);
}
return(View(juegosModel));
}
public ActionResult Login(BOLogin objdata)
{
objdata.RoleId = 6;
// Session["CAPTCHA"].ToString();
ObjUserLogin = new UserLogin();
if (Session["CAPTCHA"] != null)
{
if (Session["CAPTCHA"].ToString().ToLower().Equals(objdata.clientCaptcha.ToLower()))
{
var Userdtl = ObjUserLogin.VerifyUser(objdata.UserName, objdata.RoleId).FirstOrDefault();
if (Userdtl != null)
//if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows.Count == 1)
{
string psw = Userdtl.Password;
ViewData["attempts"] = Userdtl.LoginAttempts;
string hashed_pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(psw.ToString().ToLower() + Session["salt"].ToString(), "md5");
// macth the both passwords
if (hashed_pwd.ToString().ToLower().Equals(objdata.Password.ToLower()))
{
if (Convert.ToInt32(Userdtl.Userlock) == 0)
{
if (Convert.ToInt32(ViewData["attempts"]) <= 10)
{
Session["tbl_Session"] = Userdtl;
// Getting New Guid
string guid = Convert.ToString(Guid.NewGuid());
//Storing new Guid in Session
Session["AuthenticationToken"] = guid;
//Adding Cookie in Browser
Response.Cookies.Add(new HttpCookie("AuthenticationToken", guid));
// SecurityImp objsecurityimp = new SecurityImp();
//Session["__Token"] = objsecurityimp.GetMD5(objsecurityimp.GetRandomNo());
//var t = Session["__Token"];
//Response.Cookies.Add(new HttpCookie("__Token", Session["__Token"].ToString()));
////////////////////////////////////////////////////////////////////////////////////////////////
//string mac_name = System.Environment.MachineName.ToString();
// string mc_ip = Request.UserHostAddress.ToString();
// string mac_client = Request.UserHostName.ToString();
// string guid = Guid.NewGuid().ToString();
//string tokensession = mac_name + "~" + mc_ip + "~" + ds.Tables[0].Rows[0]["UserName"].ToString() + "~" + DateTime.Now + "~" + guid;
//
// Session["AuthToken"] = guid;
//HttpCookie authc = new HttpCookie("AuthToken", guid);
// authc.Expires = DateTime.Now.AddDays(1);
//Response.Cookies.Add(authc);
//Session["SessionToken"] = tokensession;
//HttpCookie sessc = new HttpCookie("SessionToken", tokensession);
//sessc.Expires = DateTime.Now.AddDays(1);
//Response.Cookies.Add(sessc);
////////////////////////////////////////////////////////////////////////////////////////////////
// int res = objbl.UserLastloginchange(objdata.UserName, PageName, IPAddress, tokensession);
//int res = DataAccessLayer.UserLastloginchange(objdata.UserName, PageName, IPAddress, tokensession);
//if (ds.Tables[0].Rows[0]["Last_Pwd_Change"].ToString()=="")
//{
if (String.IsNullOrEmpty(Userdtl.LastlPasswordChangeDate))
{
TempData["FisrtLogin"] = new BOLogin();
//return RedirectToAction("ResetPassword", "Login");
var redirectUrl = "/Login/ResetPassword";
return(Json(new { success = true, url = redirectUrl }, JsonRequestBehavior.AllowGet));
}
else
{
var redirectUrl = "/Home/Dashboard";
//UserDashBoard objDashData = new UserDashBoard();
//objDashData = objDash.GetPublishShops();
if (UserSession.LoggedInUserRole == 6)
{
return(Json(new{ success = true, url = redirectUrl }, JsonRequestBehavior.AllowGet));
}
//else if (UserSession.LoggedInUserRole == 3)
// return RedirectToAction("DistrictDashBoard", "DashBoard");
//else if (UserSession.LoggedInUserRole == 1)
// return RedirectToAction("AdminDashBoard", "DashBoard");
//else if (UserSession.LoggedInUserRole == 2)
// return RedirectToAction("AdminDashBoard", "DashBoard");
// return View("~/Views/Home/ApplicationDashBoard.cshtml", objDashData);
}
}
else
{
//Response.Write("<script>RefreshCaptcha();</script>");
//Response.Write("<script>alert('Your account is temporarily locked.Please try after some time');</script>");
//var redirectUrl = "/Login/ResetPassword";
return(Json(new { success = true, msg = "Your account is temporarily locked.Please try after some time" }, JsonRequestBehavior.AllowGet));
}
}
else
{
//txtUserName.Text = "";
//txtPassword.Text = "";
//Response.Write("<script>RefreshCaptcha();</script>");
//Response.Write("<script>alert('Your account is locked for Some Time');</script>");
return(Json(new { success = true, msg = "Your account is locked for Some Time" }, JsonRequestBehavior.AllowGet));
//lnkbtnforChangeCap_Click();
}
}
else
{
//ViewData["attempts"] = Convert.ToInt32(ViewData["attempts"]) + 1;
//Response.Write("<script>RefreshCaptcha();</script>");
//Response.Write("<script>alert('Invalid Username or Password');</script>");
var redirectUrl = "/Login/ResetPassword";
return(Json(new { success = true, url = redirectUrl }, JsonRequestBehavior.AllowGet));
//lnkbtnforChangeCap_Click();
}
}
else
{
//Response.Write("<script>RefreshCaptcha();</script>");
//Response.Write("<script>alert('Invalid Username or Password');</script>");
return(Json(new { success = true, msg = "Invalid Username or Password" }, JsonRequestBehavior.AllowGet));
// lnkbtnforChangeCap_Click();
}
}
else
{
// ViewBag.Captcha = "Invalid Captcha";
return(Json(new { success = true, msg = "Invalid Captcha" }, JsonRequestBehavior.AllowGet));
}
}
else
{
//ViewBag.Captcha = "Kindly fill the Captcha";
return(Json(new { success = true, msg = "Kindly fill the Captcha" }, JsonRequestBehavior.AllowGet));
}
return(View());
}
public ActionResult Buy(VentasModel oventasModel)
{
//Comprobaciones
BOClaves oBOClaves = new BOClaves();
BOJuegos oBOJuegos = new BOJuegos();
JuegosModel ojuegosModel = oBOJuegos.getJuegoById(oventasModel.id_juego);
if (oBOClaves.checkStockClaveByid_juego(oventasModel.id_juego) == false)
{
return(RedirectToAction("../Games/Game/" + oventasModel.id_juego));
}
if (oventasModel.tarj is null || oventasModel.tarj.Length != 16)
{
ViewBag.Error = "Número de la tarjeta erróneo.";
return(View(ojuegosModel));
}
if (oventasModel.tarj_mes is null || oventasModel.tarj_mes.Length != 2)
{
ViewBag.Error = "Número del mes de la tarjeta erróneo.";
return(View(ojuegosModel));
}
if (oventasModel.tarj_ano is null || oventasModel.tarj_ano.Length != 2)
{
ViewBag.Error = "Número del año de la tarjeta erróneo.";
return(View(ojuegosModel));
}
if (oventasModel.cod_seg is null || oventasModel.cod_seg.Length != 3)
{
ViewBag.Error = "Número del código de seguridad de la tarjeta erróneo.";
return(View(ojuegosModel));
}
if (Session["Log"] is null)
{
return(RedirectToAction("../Login/Login"));
}
//Iniciamos el proceso de compra.
BOLogin oBOLogin = new BOLogin();
usuarios ousuario = oBOLogin.getUsuarioById((int)Session["Log"]);
oventasModel.id_usuario = ousuario.id_usuario;
//Iniciamos el proceso de compra.
BOVentas oBOVentas = new BOVentas();
ventas oventa = oBOVentas.addVenta(oventasModel);
if (oventa.id_clave == 0)
{
ViewBag.Error = "Hemos tenido un problema durante el proceso de compra.";
return(View(ojuegosModel));
}
//Envia un email con el código comprado
claves oclaves = oBOClaves.getClaveByid_clave(oventa.id_clave);
MailMessage oMailMessage = new MailMessage("*****@*****.**", ousuario.email, "¡Gracias por comprar en GamesMarket!",
"<p>Hola " + ousuario.nombre + " " + ousuario.apellidos + "</p>" + "<p>La Key del juego " + ojuegosModel.nombre + " comprado el " + oventa.fecha_venta + " es: </p>" +
"<h2>" + oclaves.codigo + "</h2>" +
"<p>¡Gracias y esperamos que sigas comprando en GamesMarket!<p>" +
"<p>No olvides que puedes consultar la clave también iniciando sesión en nuestra web: www.GamesMarket.com </p>");
BOMail oBOMail = new BOMail();
oBOMail.sendEmail(oMailMessage);
return(RedirectToAction("../Buys/BuyCompleted"));
}
