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