public ActionResult Login(string id) { if (!String.IsNullOrEmpty(id)) { RedirectToAction("Index", "LeaveApprove"); } var viewModels = new LoginModel.MyViewModel { Memos = db.GetMemos(), Charts = db.GetCharts(), Newss = db.GetNews(), p2k3s = db.Getp2k3s() }; return(View(viewModels)); }
public ActionResult Login(KMI_INTRANET.Models.LoginModel.MyViewModel model) { if (ModelState.IsValid) { if (model.IsValid(model.UserName, model.Password)) { FormsAuthentication.SetAuthCookie(model.UserName, model.RememberMe); Session["USER"] = model.UserName; string connectionString = "Data Source=HRMSDEV;user id=PERSON;password=PERSON;Unicode=True;"; using (OracleConnection connection = new OracleConnection(connectionString)) { OracleCommand cmd = new OracleCommand(); cmd.CommandText = "select t.nickname from person.CTM_EMPLOYEE_MASTER_TAB t where t.emp_id='" + Session["USER"] + "'"; cmd.CommandType = CommandType.Text; cmd.Connection = connection; connection.Open(); using (OracleDataReader rdr = cmd.ExecuteReader()) { rdr.Read(); if (DBNull.Value.Equals(rdr.GetString(0))) { Session["fullname"] = "-"; } else { Session["fullname"] = rdr.GetString(0); } } connection.Close(); OracleCommand cmd1 = new OracleCommand(); cmd1.CommandText = "select t.LEV,t.autorized from person.KMIINTRANET_USER t where t.USERNAME='******'"; cmd1.CommandType = CommandType.Text; cmd1.Connection = connection; connection.Open(); using (OracleDataReader rdr1 = cmd1.ExecuteReader()) { rdr1.Read(); if (rdr1.GetString(0) == "") { Session["UserSecurity"] = "-"; } else { Session["UserSecurity"] = rdr1.GetString(0); } if (rdr1.GetString(0) == "USER") { Session["Autorized"] = ""; } else { Session["Autorized"] = rdr1.GetString(1); } } connection.Close(); //if (!String.IsNullOrEmpty(id)) //{ // string param1 = this.Request.QueryString["param.1"]; // string param2 = this.Request.QueryString["param.2"]; // Redirect(Url.Action("Index", "LeaveApprove") + "?id=" + id); //} //else //{ //return RedirectToAction("Index", "Home"); //} string returnUrl = Request.QueryString["ReturnUrl"]; if (!String.IsNullOrEmpty(returnUrl)) { return Redirect(returnUrl); } else { return RedirectToAction("Index", "Home"); } } } else { ModelState.AddModelError("", "The user name or password incorrect."); } } var viewModels = new LoginModel.MyViewModel { Memos = db.GetMemos(), Charts = db.GetCharts(), Newss = db.GetNews(), p2k3s = db.Getp2k3s() }; return View(viewModels); }
public ActionResult Login(string id) { if (!String.IsNullOrEmpty(id)) { RedirectToAction("Index", "LeaveApprove"); } var viewModels = new LoginModel.MyViewModel { Memos = db.GetMemos(), Charts = db.GetCharts(), Newss = db.GetNews(), p2k3s = db.Getp2k3s() }; return View(viewModels); }
public ActionResult Login(KMI_INTRANET.Models.LoginModel.MyViewModel model) { if (ModelState.IsValid) { if (model.IsValid(model.UserName, model.Password)) { FormsAuthentication.SetAuthCookie(model.UserName, model.RememberMe); Session["USER"] = model.UserName; string connectionString = "Data Source=HRMSDEV;user id=PERSON;password=PERSON;Unicode=True;"; using (OracleConnection connection = new OracleConnection(connectionString)) { OracleCommand cmd = new OracleCommand(); cmd.CommandText = "select t.nickname from person.CTM_EMPLOYEE_MASTER_TAB t where t.emp_id='" + Session["USER"] + "'"; cmd.CommandType = CommandType.Text; cmd.Connection = connection; connection.Open(); using (OracleDataReader rdr = cmd.ExecuteReader()) { rdr.Read(); if (DBNull.Value.Equals(rdr.GetString(0))) { Session["fullname"] = "-"; } else { Session["fullname"] = rdr.GetString(0); } } connection.Close(); OracleCommand cmd1 = new OracleCommand(); cmd1.CommandText = "select t.LEV,t.autorized from person.KMIINTRANET_USER t where t.USERNAME='******'"; cmd1.CommandType = CommandType.Text; cmd1.Connection = connection; connection.Open(); using (OracleDataReader rdr1 = cmd1.ExecuteReader()) { rdr1.Read(); if (rdr1.GetString(0) == "") { Session["UserSecurity"] = "-"; } else { Session["UserSecurity"] = rdr1.GetString(0); } if (rdr1.GetString(0) == "USER") { Session["Autorized"] = ""; } else { Session["Autorized"] = rdr1.GetString(1); } } connection.Close(); //if (!String.IsNullOrEmpty(id)) //{ // string param1 = this.Request.QueryString["param.1"]; // string param2 = this.Request.QueryString["param.2"]; // Redirect(Url.Action("Index", "LeaveApprove") + "?id=" + id); //} //else //{ //return RedirectToAction("Index", "Home"); //} string returnUrl = Request.QueryString["ReturnUrl"]; if (!String.IsNullOrEmpty(returnUrl)) { return(Redirect(returnUrl)); } else { return(RedirectToAction("Index", "Home")); } } } else { ModelState.AddModelError("", "The user name or password incorrect."); } } var viewModels = new LoginModel.MyViewModel { Memos = db.GetMemos(), Charts = db.GetCharts(), Newss = db.GetNews(), p2k3s = db.Getp2k3s() }; return(View(viewModels)); }