public ActionResult Admin() { DataSet dsUser = new DataSet(); string USRID = Session["USRIDv"].ToString(); using (DataVw dMan = new DataVw()) { dsUser = dMan.ExecuteView_S("USR", "*", USRID, "", "ID = "); } List <UserList> userList = new List <UserList>(); foreach (DataRow dr in dsUser.Tables[0].Rows) { userList.Add(new UserList { ID = (Guid)dr["ID"], USRNM = dr["USRNM"].ToString(), PWD = CryptionHelper.Decrypt(dr["PWD"].ToString(), "tb"), EMAIL = dr["EMAIL"].ToString(), FULNM = dr["FULNM"].ToString(), CARDNO = dr["CARDNO"].ToString(), CVC = dr["CVC"].ToString(), STKDAY = dr["STKDAY"].ToString(), STKMONTH = dr["STKMONTH"].ToString() }); } ViewBag.UserList = userList; return(View()); }
public ActionResult Control(string txtUsername, string txtPassword) { UserManager uMan = new UserManager(txtUsername, txtPassword); _li = uMan.CheckLogin(); using (DataVw dMan = new DataVw()) { dsUser = dMan.ExecuteView_S("USR", "*", txtUsername, "", "USRNM ="); dsLogError = dMan.ExecuteView_S("LOGERROR", "*", "", "", ""); } if (dsUser.Tables[0].Rows.Count > 0) { DataRow row = dsUser.Tables[0].Rows[0]; UserData = new User(); UserData.USRID = (Guid)row["ID"]; UserData.USRNM = Convert.ToString(row["USRNM"]); UserData.FULNM = Convert.ToString(row["FULNM"]); UserData.AVATAR = Convert.ToString(row["AVATAR"]); UserData.Email = Convert.ToString(row["EMAIL"]); UserData.IS_ADMIN = Convert.ToBoolean(row["IS_ADMIN"]); UserData.IS_SYSADM = Convert.ToBoolean(row["IS_SYSADM"]); UserData.IS_HR = Convert.ToBoolean(row["IS_HR"]); if (txtUsername.ToString() == row["USRNM"].ToString() && txtPassword.ToString() == CryptionHelper.Decrypt(row["PWD"].ToString(), "tb").ToString()) { Session["USRIDv"] = row["ID"].ToString(); Session["name"] = row["FULNM"].ToString(); Session["admin"] = true; Session["IsAuthenticated"] = true; Session["IS_SYSADM"] = row["IS_SYSADM"].ToString(); //await SignInAsync(user, model.RememberMe); if (row["IS_SYSADM"].ToString() == "True") { Session["loginRoles"] = true; Session["admin"] = true; if (row["AVATAR"].ToString() == "") { Session["avatarimg"] = "~/images/avatar/nullavatar.jpg"; } else { Session["avatarimg"] = row["AVATAR"].ToString(); } return(Redirect("/Home/Admin")); } else { Session["IsAuthenticated"] = true; Session["loginRoles"] = false; Session["admin"] = false; if (row["AVATAR"].ToString() == "") { Session["avatarimg"] = "~/images/avatar/nullavatar.jpg"; } else { Session["avatarimg"] = row["AVATAR"].ToString(); } } return(Redirect("/Home/Index")); } DataRow newrow = dsLogError.Tables[0].NewRow(); newrow["ID"] = Guid.NewGuid(); newrow["LOGINFO"] = "Kullanıcı adı : " + txtUsername + " " + "Parola : " + txtPassword; newrow["LOGIP"] = GetIp(); newrow["LOGDATE"] = DateTime.Now; newrow["EDATE"] = DateTime.Now; //newrow["EUSRID"] = null; newrow["UDATE"] = DateTime.Now; //newrow["UUSRID"] = null; newrow["NOTE"] = "Parolaya Bağlı Hatalı Giriş."; AgentGc data = new AgentGc(); string veri = data.DataAdded("LOGERROR", newrow, dsLogError.Tables[0]); Session["loginFailed"] = true; Session["IsAuthenticated"] = false; int loginErrorCount = Convert.ToInt32(Session["wrongpiece"]); Session["wrongpiece"] = loginErrorCount + 1; Session["wrongdate"] = DateTime.Now; //Session["IP"] = GetIp(); return(Redirect("/Account/Login")); } else { DataRow newrow = dsLogError.Tables[0].NewRow(); newrow["ID"] = Guid.NewGuid(); newrow["LOGINFO"] = "Kullanıcı adı : " + txtUsername + " " + "Parola : " + txtPassword; newrow["LOGIP"] = GetIp(); newrow["LOGDATE"] = DateTime.Now; newrow["EDATE"] = DateTime.Now; //newrow["EUSRID"] = null; newrow["UDATE"] = DateTime.Now; //newrow["UUSRID"] = null; newrow["NOTE"] = "Hatalı Giriş."; AgentGc data = new AgentGc(); string veri = data.DataAdded("LOGERROR", newrow, dsLogError.Tables[0]); Session["loginFailed"] = true; return(Redirect("/Account/Login")); } }
public ActionResult Control(string txtUsername, string txtPassword) { HomeController HomeCont = new HomeController(); UserManager uMan = new UserManager(txtUsername, txtPassword); _li = uMan.CheckLogin(); using (DataVw dMan = new DataVw()) { dsUser = dMan.ExecuteView_S("USR", "*", txtUsername, "", "USRNM ="); } if (dsUser.Tables[0].Rows.Count > 0) { DataRow row = dsUser.Tables[0].Rows[0]; if (txtUsername.ToString() == row["USRNM"].ToString() && txtPassword.ToString() == CryptionHelper.Decrypt(row["PWD"].ToString(), "tb").ToString()) { Session["USRSTATUS"] = row["IS_ADMIN"].ToString(); Session["USRSTATUSADM"] = row["IS_SYSADM"].ToString(); Session["USRIDv"] = row["ID"].ToString(); Session["name"] = row["FULNM"].ToString(); //Session["admin"] = true; //Session["loginError"] = true; Session["IsAuthenticated"] = true; Session["ADMIN"] = row["IS_SYSADM"].ToString(); if (row["IS_SYSADM"].ToString() == "True") { Session["IS_SYSADM"] = true; //Session["loginRoles"] = true; //Session["admin"] = true; if (row["AVATAR"].ToString() == "") { Session["avatarimg"] = "~/images/profil/nullavatar.jpg"; } else { Session["avatarimg"] = row["AVATAR"].ToString(); } return(Redirect("/Account/Admin")); } else { Session["IsAuthenticated"] = true; Session["loginRoles"] = false; Session["CUST"] = true; Session["IS_ADMIN"] = true; if (row["AVATAR"].ToString() == "") { Session["avatarimg"] = "~/images/profil/nullavatar.jpg"; } else { Session["avatarimg"] = row["AVATAR"].ToString(); } return(Redirect("/Account/Cust")); } } Session["loginError"] = true; Session["IsAuthenticated"] = false; //int loginErrorCount = Convert.ToInt32(Session["wrongpiece"]); //Session["wrongpiece"] = loginErrorCount + 1; //Session["wrongdate"] = DateTime.Now; //Session["IP"] = GetIp(); return(Redirect("/Account/Login")); } else { Session["loginError"] = true; return(Redirect("/Account/Login")); } }
// // GET: /Account/ public ActionResult Users() { using (DataVw dMan = new DataVw()) { dsUser = dMan.ExecuteView_S("USR", "*", "", "", ""); } List <AdmUserList> admuserList = new List <AdmUserList>(); foreach (DataRow dr in dsUser.Tables[0].Rows) { string IS_AC, IS_SYSADM, IS_ADMIN, IS_HR, CHNG_PWD; if (Convert.ToBoolean(dr["IS_AC"])) { IS_AC = "Evet"; } else { IS_AC = "Hayır"; } if (Convert.ToBoolean(dr["IS_SYSADM"])) { IS_SYSADM = "Evet"; } else { IS_SYSADM = "Hayır"; } if (Convert.ToBoolean(dr["IS_ADMIN"])) { IS_ADMIN = "Evet"; } else { IS_ADMIN = "Hayır"; } if (Convert.ToBoolean(dr["IS_HR"])) { IS_HR = "Evet"; } else { IS_HR = "Hayır"; } if (Convert.ToBoolean(dr["CHNG_PWD"])) { CHNG_PWD = "Evet"; } else { CHNG_PWD = "Hayır"; } admuserList.Add(new AdmUserList { ID = (Guid)dr["ID"], IS_AC = IS_AC, USRNM = dr["USRNM"].ToString(), PWD = CryptionHelper.Decrypt(dr["PWD"].ToString(), "tb"), FULNM = dr["FULNM"].ToString(), EMAIL = dr["EMAIL"].ToString(), IS_SYSADM = IS_SYSADM, IS_ADMIN = IS_ADMIN, IS_HR = IS_HR, CHNG_PWD = CHNG_PWD, AVATAR = dr["AVATAR"].ToString(), EDATE = (DateTime)dr["EDATE"], UDATE = (DateTime)dr["UDATE"], CARDNO = dr["CARDNO"].ToString(), CVC = dr["CVC"].ToString(), STKDAY = dr["STKDAY"].ToString(), STKMONTH = dr["STKMONTH"].ToString() }); } ViewBag.UserList = admuserList; return(View()); }