public ActionResult Changepassword(FormCollection collection)
{
//tb_login lg = new tb_login();
string user = Session["username"].ToString();
string type = Session["type"].ToString();
ViewBag.type = type;
string paswd = Session["password"].ToString();
string pass = collection["oldpass"];
tb_log login = db.tb_log.Where(i => i.username == user && i.password == paswd).FirstOrDefault();
tb_agent agent = db.tb_agent.Where(i => i.username == user && i.password == paswd).FirstOrDefault();
if (login.password == pass && agent.password == pass)
{
login.password = collection["newpass"];
agent.password = collection["newpass"];
int i = db.SaveChanges();
if (i > 0)
{
ViewBag.msg = "Password updated Successfully";
}
else
{
ViewBag.msg = "Something went wrong";
}
}
else
{
ViewBag.msg = "Wrong Current password";
}
return(View());
}
public ActionResult Register(FormCollection collection)
{
// TODO: Add insert logic here
tb_reg ins = new tb_reg();
ins.name = collection["name"];
ins.phone_no = collection["phone"];
ins.gmail = collection["mail"];
ins.username = collection["username"];
ins.password = collection["password"];
ins.confirmpassword = collection["confirmpassword"];
//ins.usertype = collection["usertype"];
ins.usertype = "User";
if (db.tb_reg.Any(x => x.username == ins.username))
{
ViewBag.f = "Username Already Exist";
}
else
{
tb_log inse = new tb_log();
inse.username = collection["username"];
inse.password = collection["password"];
inse.usertype = "User";
db.tb_reg.Add(ins);
db.tb_log.Add(inse);
db.SaveChanges();
MailMessage MyMailMessage = new MailMessage();
MyMailMessage.From = new MailAddress("*****@*****.**");
MyMailMessage.To.Add(collection["mail"]);
MyMailMessage.Subject = "Membership request";
MyMailMessage.Body = "Your request has been approved..Your username is : " + collection["username"] + "Your password is: " + collection["password"];
MyMailMessage.IsBodyHtml = true;
SmtpClient SMTPServer = new SmtpClient("smtp.gmail.com");
SMTPServer.Port = 587;
SMTPServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "!123456789");
SMTPServer.EnableSsl = true;
try
{
SMTPServer.Send(MyMailMessage);
//FormView1.DataBind();
//Literal1.Text = "Verification Code Sent to the mail ";
//Response.Redirect("Thankyou.aspx");
}
catch (Exception ex)
{
//Literal1.Text = "Sorry! pls check the entered email ";
}
return(RedirectToAction("Login", "reg"));
}
return(View());
}
public ActionResult Agentreg(FormCollection collection)
{
Random rand = new Random();
var password = rand.Next().ToString();
var getrandomkey = "AGN" + password.Substring(0, 5);
tb_agent Addagent = new tb_agent();
Addagent.agent_name = collection["name"];
Addagent.phone_no = collection["phone"];
Addagent.gmail = collection["mail"];
Addagent.username = collection["username"];
Addagent.password = getrandomkey;
if (db.tb_reg.Any(x => x.username == Addagent.username))
{
ViewBag.f = "Username Already Exist";
}
else
{
tb_log inse = new tb_log();
inse.username = collection["username"];
inse.password = getrandomkey;
inse.usertype = "Agent";
db.tb_agent.Add(Addagent);
db.tb_log.Add(inse);
db.SaveChanges();
ViewBag.s = "success";
}
MailMessage MyMailMessage = new MailMessage();
MyMailMessage.From = new MailAddress("*****@*****.**");
MyMailMessage.To.Add(collection["mail"]);
MyMailMessage.Subject = "Membership request";
MyMailMessage.Body = "Your request has been approved..Your username is : " + collection["username"] + "Your password is: " + getrandomkey;
MyMailMessage.IsBodyHtml = true;
SmtpClient SMTPServer = new SmtpClient("smtp.gmail.com");
SMTPServer.Port = 587;
SMTPServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "!123456789");
SMTPServer.EnableSsl = true;
try
{
SMTPServer.Send(MyMailMessage);
//FormView1.DataBind();
//Literal1.Text = "Verification Code Sent to the mail ";
//Response.Redirect("Thankyou.aspx");
}
catch (Exception ex)
{
//Literal1.Text = "Sorry! pls check the entered email ";
}
return(View());
}
public ActionResult Changeforgotpassword(FormCollection collection)
{
string newpassword = collection["newpass"];
string verify = collection["verifypass"];
string user = Session["username"].ToString();
string type = Session["type"].ToString();
tb_log login = db.tb_log.Where(i => i.username == user && i.code == verify).FirstOrDefault();
if (login.usertype == "User")
{
tb_reg userd = db.tb_reg.Where(i => i.username == user && i.usertype == type).FirstOrDefault();
if (login.code == verify && userd.username == user)
{
login.password = collection["newpass"];
userd.password = collection["newpass"];
int i = db.SaveChanges();
if (i > 0)
{
ViewBag.msg = "Password updated Successfully";
}
else
{
ViewBag.msg = "Something went wrong";
}
}
else
{
ViewBag.msg = "Wrong Current password";
}
}
else if (login.usertype == "Agent")
{
tb_agent agentc = db.tb_agent.Where(i => i.username == user).FirstOrDefault();
if (login.code == verify && agentc.username == user)
{
login.password = collection["newpass"];
agentc.password = collection["newpass"];
int i = db.SaveChanges();
if (i > 0)
{
ViewBag.msg = "Password updated Successfully";
}
else
{
ViewBag.msg = "Something went wrong";
}
}
else
{
ViewBag.msg = "Wrong Current password";
}
}
return(View());
}
public static Boolean IsUserLoggedIn(HttpSessionStateBase Session, HttpRequestBase Request)
{
if (Session.Count > 0)
{
if (Session["username"] != null)
{
String user = Session["username"].ToString();
db_SafeSpotEntities6 db = new db_SafeSpotEntities6();
tb_log account = db.tb_log.Where(j => j.username == user).FirstOrDefault();
return(true);
}
else
{
return(false);
}
}
else
{
try
{
HttpCookie CookieLogin = (HttpCookie)Request.Cookies["CookieLogin"];
if (CookieLogin != null)
{
if (CookieLogin.Values.Count > 0)
{
String user = CookieLogin.Values[0];
Session["username"] = user;
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
catch { return(false); }
}
}
public static void Add(string result)
{
try
{
using (var ec = new TestProjectEntities1())
{
var log = new tb_log
{
date = DateTime.Now,
result = result,
};
ec.tb_log.Add(log);
EntityConnector.SaveChanges(ec);
}
}
catch (Exception ex)
{
//add saving to text file
}
}
public static void BatchInsertTest()
{
List <tb_log> logs = new List <tb_log>();
for (int i = 0; i < 100000; i++)
{
tb_log lgAdd = new tb_log()
{
info = $"批量新增测试{i}",
methodname = "TestJob1111",
mqpath = "This is TestJob1111",
mqpathid = 1,
createtime = DateTime.Now,
updatetime = DateTime.Now
};
logs.Add(lgAdd);
}
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
BatchInsert(logs);
stopwatch.Stop();
Console.WriteLine("耗时：" + stopwatch.ElapsedMilliseconds);
}
public ActionResult Forgotpassword1(FormCollection collection)
{
string username = collection["username"];
string mail = collection["mail"];
string type = collection["type"].ToString();
Random rand = new Random();
var password = rand.Next().ToString();
var getrandomkey = password.Substring(0, 5);
var lgn = db.tb_log.Where(ob => (ob.username == username) && (ob.usertype == type)).FirstOrDefault();
string userid = lgn.username;
if (lgn != null)
{
if (lgn.usertype == ("User"))
{
Session["username"] = lgn.username;
Session["type"] = lgn.usertype;
userid = lgn.username;
var useraccount = db.tb_reg.Where(i => i.gmail == mail && i.usertype == type && i.username == username).FirstOrDefault();
if (useraccount != null)
{
//nametype(username, type);
tb_log login = db.tb_log.Where(i => i.username == username && i.usertype == type).FirstOrDefault();
//}
if (login != null)
{
login.code = getrandomkey;
db.tb_log.Add(login);
int i = db.SaveChanges();
if (i > 0)
{
ViewBag.s = "Verification Code has been send to your registered mail id";
}
else
{
ViewBag.f = "Something went wrong";
}
}
else
{
ViewBag.f = "Username or type not match";
}
}
else
{
ViewBag.f = "Username or Mail not match";
}
}
else if (lgn.usertype == ("Agent"))
{
Session["username"] = lgn.username;
Session["type"] = lgn.usertype;
userid = lgn.username;
var agentaccount = db.tb_agent.Where(i => i.gmail == mail).FirstOrDefault();
if (agentaccount != null)
{
tb_log login = db.tb_log.Where(i => i.username == username && i.usertype == type).FirstOrDefault();
if (login != null)
{
login.code = getrandomkey;
db.tb_log.Add(login);
int j = db.SaveChanges();
if (j > 0)
{
ViewBag.s = "Verification Code has been send to your registered mail id";
}
else
{
ViewBag.f = "Something went wrong";
}
}
}
}
}
MailMessage MyMailMessage = new MailMessage();
MyMailMessage.From = new MailAddress("*****@*****.**");
MyMailMessage.To.Add(collection["mail"]);
MyMailMessage.Subject = "Membership request";
MyMailMessage.Body = "Your request has been approved..Your Verification Code is:" + getrandomkey;
MyMailMessage.IsBodyHtml = true;
SmtpClient SMTPServer = new SmtpClient("smtp.gmail.com");
SMTPServer.Port = 587;
SMTPServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "!123456789");
SMTPServer.EnableSsl = true;
try
{
SMTPServer.Send(MyMailMessage);
//FormView1.DataBind();
//Literal1.Text = "Verification Code Sent to the mail ";
//Response.Redirect("Thankyou.aspx");
}
catch (Exception ex)
{
//Literal1.Text = "Sorry! pls check the entered email ";
}
return(RedirectToAction("Changeforgotpassword", "reg", new { userid = userid }));
//return View();
}
