public ActionResult UpdateStatus(string status, int id, string note)
{
SameSoftWeb.Models.SameSoftwareWebEntities db = new SameSoftWeb.Models.SameSoftwareWebEntities();
var p = db.tblProblems.Where(a => a.Problem_ID == id).FirstOrDefault();
if (p != null)
{
p.Status = status;
p.Solution_Note = note;
db.SaveChanges();
}
return(RedirectToAction("Details", "Issues", new { id = id }));
}
public ActionResult mylogin(string username, string password)
{
bool success = false;
bool err = false;
bool blocked = false;
try
{
// var db = new WebAirLine.Models.Shabele_Airline_Data_NewEntities();
var db = new SameSoftWeb.Models.SameSoftwareWebEntities();
//UTF8Encoding encoder = new UTF8Encoding();
//MD6CryptoServiceProvider hasher = new MD6CryptoServiceProvider();
//string hash = System.Convert.ToBase64String(hasher.ComputeHash(encoder.GetBytes(password)));
int?tmp = db.tblUsers.Where(a => a.UserName == username && a.Password == password).Select(a => a.UserID).FirstOrDefault();
if (tmp != null)
{
var resUser = (from user in db.tblUsers where user.UserID == tmp select user).First();
// if (resUser.Status.ToString().ToLower().Contains("active") == false)
// {
// return Json("failed", JsonRequestBehavior.AllowGet);
// return Json("Login Failed ; this User is Blocked !", JsonRequestBehavior.AllowGet);
// }
Session["UserID"] = resUser.UserID;
Session["UserName"] = resUser.UserName;
Session["Role"] = resUser.Role;
Session["FullName"] = resUser.FullName;
//Session["UserAgent_ID"] = db.Sp_Get_Agent_id_by_UserID(resUser.UserID).FirstOrDefault();
//Session["Login_Name"] = resUser.Login_Name;
//// Get User Access MENUS
//List<int> menu_acc = new List<int>();
//List<WebAirLine.Models.Get_User_Menu_By_UserID_Result_mnc> collection;
//collection = db.Get_User_Menu_By_UserID(resUser.UserID).ToList();
//for (int r = 0; r < collection.Count; r++)
//{
// menu_acc.Add(collection[r].MENUID);
//}
//Session["menu_acc"] = "---";
//Session["menu_acc"] = menu_acc;
// END OF GET USER ACCESS MENUS
//
//var agentinfo = SiteMethods.GetAgentInfoByAgentUserId((int)Session["UserID"]);
//if (agentinfo != null)
//{
// Session["Login_Name"] = agentinfo.Agent_Name;
// Session["Agent_Name"] = agentinfo.Agent_Name;
// Session["UserAgent_ID"] = agentinfo.Agent_id;
//}
//else
//{
// Session["Login_Name"] = "NA";
// Session["UserAgent_ID"] = db.Sp_Get_Agent_id_by_UserID(resUser.UserID).FirstOrDefault();
//}
////
success = true;
if (resUser.Role == "Customer")
{
Session["AppID"] = resUser.App_ID;
Session["customer_id"] = resUser.Customer_ID;
Session["Customer_Name"] = db.tblCustomers.Where(a => a.CustomerID == resUser.Customer_ID).Select(a => a.Customer_Name).FirstOrDefault();
return(Json("Customer/Index", JsonRequestBehavior.AllowGet));
}
else if (resUser.Role == "Admin")
{
return(RedirectToAction("Index", "Admin"));
//return Json("Admin/Index", JsonRequestBehavior.AllowGet);
}
else
{
return(RedirectToAction("Index", "Admin"));
//return Json("Admin/Index", JsonRequestBehavior.AllowGet);
// return Json("Staff/Index", JsonRequestBehavior.AllowGet);
}
}
}
catch (Exception e)
{
ModelState.AddModelError("", "Database error. " + e.Message);
err = true;
}
if (!success)
{
Session["UserID"] = null;
Session["Role"] = null;
Session["UserName"] = null;
Session["FullName"] = null;
if (err)
{
return(RedirectToAction("Login", "Users", new { msg = "Invalid UserName Or Password" }));
//return Json("failed", JsonRequestBehavior.AllowGet);
}
else
{
{
return(RedirectToAction("Login", "Users", new { msg = "Invalid UserName Or Password" }));
//return Json("failed", JsonRequestBehavior.AllowGet);
// return Json("Login Failed. check user & Password", JsonRequestBehavior.AllowGet);
}
}
}
//ViewBag.msg = "Invalid UserName Or Password";
return(RedirectToAction("Login", "Users", new { msg = "Invalid UserName Or Password" }));
// return Json("failed", JsonRequestBehavior.AllowGet);
}
