// The id parameter should match the DataKeyNames value set on the control // or be decorated with a value provider attribute, e.g. [QueryString]int id protected void EnterNewPass_Click(object sender, EventArgs e) { IQueryable <User> user = _db.Users; var new_user = user.SingleOrDefault(u => u.UserName == forgotEmail.Text); if (!string.IsNullOrEmpty(forgotEmail.Text) && new_user != null) { string pass = new Encryptions().EncryptPassword(forgotPass.Text); string repass = new Encryptions().EncryptPassword(forgotRepass.Text); if (pass == repass) { AddUser(ref new_user, ref repass); _db.SaveChanges(); new_user = _db.Users.SingleOrDefault(u => u.UserName == forgotEmail.Text && u.Password == repass); Session["Id"] = new_user.UserId; Session["Username"] = new_user.UserName; Session["Password"] = new_user.Password; Session["Name"] = new_user.Name; Session["Lastname"] = new_user.LastName; Session["Position"] = _db.Positions.SingleOrDefault(p => p.PositionID == new_user.PositionID).PositionName; Session["Login"] = "******"; Response.Redirect("/Default.aspx"); } else { forgotRepasstxt.Text = "Password does not match!"; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "emailNotExist", "emailNotExist()", true); } }
protected void alertSubmit_Click(object sender, EventArgs e) { var groupid = Request.QueryString["group_id"]; if (int.TryParse(groupid, out int g_id)) { _db.AlertValues.SingleOrDefault(a => a.GroupID == g_id).Value = alertTxt.Text; _db.SaveChanges(); } }
public SensorAlert PostAlert(string sensorname, string threshval, string alertval) { SensorAlert alert = new SensorAlert(); //change thai year to us year Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); alert.SensorName = sensorname; alert.AlertThresholdVal = threshval; alert.AlertVal = alertval; alert.AlertDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); _db.SensorAlerts.Add(alert); _db.SaveChanges(); return(alert); }
protected void Edit_Click(object sender, EventArgs e) { string edit_id = Request.QueryString["edit_id"]; if (!string.IsNullOrEmpty(edit_id) && int.TryParse(edit_id, out eid)) { var user = _db.Users.SingleOrDefault(u => u.UserId == eid); user.Name = EditFn.Text; user.LastName = EditLn.Text; user.UserName = EditEm.Text; user.Password = EditPass.Text; user.Password = EditRepass.Text; Session["Username"] = EditEm.Text; Session["Password"] = EditPass.Text; Session["Name"] = EditFn.Text; Session["Lastname"] = EditLn.Text; _db.SaveChanges(); } }
protected void Register_Click(object sender, EventArgs e) { CpDashboardContext context = new CpDashboardContext(); string reg_pass = new Encryptions().EncryptPassword(RegisterPass.Text); string reg_repass = new Encryptions().EncryptPassword(RegisterRepass.Text); if (reg_pass == reg_repass) { //singleordefault can only return to var var query = context.Users.SingleOrDefault(q => q.UserName == RegisterEm.Text); if (query == null) { context.Users.Add(InsertUser(RegisterFn.Text, RegisterLn.Text, RegisterEm.Text, reg_repass)); context.SaveChanges(); query = context.Users.SingleOrDefault(u => u.UserName == RegisterEm.Text); Session["Id"] = query.UserId; Session["Username"] = query.UserName; Session["Password"] = query.Password; Session["Name"] = query.Name; Session["Lastname"] = query.LastName; Session["Position"] = context.Positions.SingleOrDefault(p => p.PositionID == query.PositionID).PositionName; Session["Login"] = "******"; Response.Redirect("~/Default.aspx"); } else { LabelEm.Text = "Email already Exist!!"; } } else { LabelPass.Text = "Your password is not match!!"; } }
protected void Group_Click(object sender, EventArgs e) { _db.SensorGroups.Add(GetGroup(groupName.Text, groupDes.Text)); _db.SaveChanges(); Response.Redirect("/AddSensor.aspx"); }