//Removed Task from table.
public IActionResult Remove_Task(int id)
{
string user_id_string = HttpContext.Session.GetString("User_ID");
int user_id;
if (user_id_string != null)
{
try
{
user_id = Convert.ToInt32(user_id_string);
}
catch
{
user_id = 0;
return(RedirectToAction("Index", "Home"));
}
var task = _context.ToDo_Task.Where(i => i.Task_ID == id).SingleOrDefault();
_context.Remove(task);
_context.SaveChangesAsync();
return(RedirectToAction("Add_Task", "Todo_Task"));
}
else
{
TempData["msg"] = _CLSR.GetScriptAlertPopUp("Warning", "You have not login yet.", "", "D");
return(RedirectToAction("Index", "Home"));
}
}
public IActionResult Login(string input_Email, string input_Password)
{
String cDate = _CLSR.GetDateNow("");
String cTime = _CLSR.GetTimeNow("");
var user = _context.User.Where(i => i.Email == input_Email).SingleOrDefault();
if (user != null)
{
//found user in db.
//check password.
if (input_Email.Equals(user.Email) && input_Password.Equals(user.Password))
{
HttpContext.Session.SetString("User_ID", user.User_ID.ToString());
user.Last_Login = cDate;
_context.Update(user);
_context.SaveChanges();
string user_id_string = HttpContext.Session.GetString("User_ID");
int user_id;
try
{
user_id = Convert.ToInt32(user_id_string);
}
catch
{
user_id = 0;
}
_CLSR.CheckTaskDueDate(user_id, 20);
ViewData["isLogIn"] = 1;
//TempData["msg"] = _CLSR.GetScriptAlertPopUp("Success", "Login Successfully!", "", "S");
return(RedirectToAction("Add_Task", "Todo_Task"));
}
else
{
TempData["msg"] = _CLSR.GetScriptAlertPopUp("Invalid", "Invalid Email or Password", "", "E");
return(RedirectToAction("Index", "Home"));
}
}
else
{
TempData["msg"] = _CLSR.GetScriptAlertPopUp("Invalid", "Invalid Email or Password", "", "E");
return(RedirectToAction("Index", "Home"));
}
}
public IActionResult ChangePassword(string Password, string Password2)
{
string user_id_string = HttpContext.Session.GetString("User_ID");
int user_id;
try
{
user_id = Convert.ToInt32(user_id_string);
}
catch
{
user_id = 0;
}
//เช็คจากฝั่ง Server ถ้า Password ไม่ตรงกัน
if (Password != Password2)
{
TempData["msg"] = _CLSR.GetScriptAlertPopUp("Error", "Please contact Administrator", "", "E");
return(RedirectToAction("ChangePassword", "Users"));
}
else
{
var user = _context.User.Where(i => i.User_ID == user_id).SingleOrDefault();
using (IDbContextTransaction dbTran = _context.Database.BeginTransaction())
{
String cDate = _CLSR.GetDateNow("");
String cTime = _CLSR.GetTimeNow("");
user.Password = _CLSR.EncryptSHA512(Password);
user.Last_Update = cDate;
_context.Update(user);
_context.SaveChanges();
//ถ้าบันทึกข้อมูลเสร็จ ให้ Commit เพื่อยืนยันการเซฟข้อมูล
dbTran.Commit();
//ถ้าไม่สำเร็จให้ RollBack();
//Temp Message เพื่อขึ้น Alert ป๊อปอัพแสดง
TempData["msg"] = _CLSR.GetScriptAlertPopUp("Success", "Password changed successfully.", "", "D");
return(RedirectToAction("Index", "Home"));
}
}
}
