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