public LoginInfo CheckLogin() { LoginInfo li = new LoginInfo(); string sql = ""; List <SqlParameter> sPar = new List <SqlParameter>(); using (DataManager dMan = new DataManager()) { sql = "SELECT * FROM USR WHERE USRNM=@USRNM And PWD=@PWD"; sPar.Add(new SqlParameter("USRNM", _userId)); //sPar.Add(new SqlParameter("UserPwd", _userPwd)); sPar.Add(new SqlParameter("PWD", CryptionHelper.Encrypt(_userPwd, "tb"))); DataTable dt = dMan.ExecuteDataTable(sql, sPar); if (dt.Rows.Count == 0) { //Kullanıcı Yok Demek return(null); } li.UserId = dt.Rows[0]["ID"].ToString(); li.UserName = dt.Rows[0]["USRNM"].ToString(); li.UserEmail = dt.Rows[0]["EMAIL"].ToString(); } return(li); }
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()); }
/// <summary> /// 解密 /// </summary> /// <param name="connstr"></param> /// <returns></returns> public static string DBStringDecrypt(string connstr) { return(CryptionHelper.AESDecrypt(connstr, DBSecretKey, DBIv)); }
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")); } }
public ActionResult UserAdd(string txtUSRNM, string txtFULNM, string txtPWD, string txtEMAIL, string txtCARDNO, string txtCVC, string txtSTKDAY, string txtSTKMONTH, HttpPostedFileBase file) { string filefo = ""; using (DataVw dMan = new DataVw()) { dsUser = dMan.ExecuteView_S("USR", "*", "", "", ""); } if (txtUSRNM.ToString() == "" || txtFULNM.ToString() == "" || txtPWD.ToString() == "" || txtEMAIL.ToString() == "" || txtCARDNO.ToString() == "" || txtCVC.ToString() == "" || txtSTKDAY.ToString() == "" || txtSTKMONTH.ToString() == "") { Session["useraddsuccess"] = false; ViewBag.addmessage = "Eksik veri girişi! Tüm Alanları Doldurunuz."; return(Redirect("/Account/Register")); } else { if (file != null) { string pic = System.IO.Path.GetFileName(file.FileName); string path = System.IO.Path.Combine(Server.MapPath("~/images/avatar"), pic); string pathd = "~/images/avatar/" + pic; // file is uploaded file.SaveAs(path); filefo = pathd; using (MemoryStream ms = new MemoryStream()) { file.InputStream.CopyTo(ms); byte[] array = ms.GetBuffer(); } } DataRow newrow = dsUser.Tables[0].NewRow(); newrow["ID"] = Guid.NewGuid(); newrow["USRNM"] = txtUSRNM; newrow["PWD"] = CryptionHelper.Encrypt(txtPWD, "tb"); newrow["FULNM"] = txtFULNM; newrow["EMAIL"] = txtEMAIL; newrow["IS_ADMIN"] = 1; newrow["IS_SYSADM"] = 0; if (filefo == "") { newrow["AVATAR"] = "~/images/avatar/nullavatar.jpg"; } else { newrow["AVATAR"] = filefo; } newrow["AVATAR"] = filefo; newrow["CARDNO"] = txtCARDNO; newrow["CVC"] = txtCVC; newrow["STKDAY"] = txtSTKDAY; newrow["STKMONTH"] = txtSTKMONTH; newrow["EDATE"] = DateTime.Now; //newrow["EUSRID"] = null; newrow["UDATE"] = DateTime.Now; //newrow["UUSRID"] = null; newrow["NOTE"] = "En Son Kayıt İşlemi Gerçekleştirdi."; AgentGc data = new AgentGc(); string veri = data.DataAdded("USR", newrow, dsUser.Tables[0]); Session["useraddsuccess"] = true; ViewBag.addmessageinfo = veri; return(Redirect("/Account/Login")); } }
public ActionResult SelectUserInfoChange(string txtUSRNM, string txtFULNM, string txtPWD, string txtEMAIL, string txtCARDNO, string txtCVC, string txtSTKDAY, string txtSTKMONTH, HttpPostedFileBase file, System.Web.Mvc.FormCollection collection) { DataSet dsUser = new DataSet(); string USRID = collection.AllKeys[8].ToString(); string filefo = ""; using (DataVw dMan = new DataVw()) { dsUser = dMan.ExecuteView_S("USR", "*", USRID, "", "ID = "); } //if (txtUSRNM.ToString() == "" || txtFULNM.ToString() == "" || txtPWD.ToString() == "" || txtEMAIL.ToString() == "" || txtCARDNO.ToString() == "" || txtCVC.ToString() == "" || txtSTKDAY.ToString() == "" || txtSTKMONTH.ToString() == "") //{ // return Content("<script language='javascript' type='text/javascript'>alert('Eksik veri girişi! Tüm Alanları Doldurunuz.');</script>"); ////Alert Mesajı Göndermek için. // //ViewBag.addmessage = "Eksik veri girişi! Tüm Alanları Doldurunuz."; // //return Redirect("/Account/Manage"); //} //else //{ if (file != null) { string pic = System.IO.Path.GetFileName(file.FileName); string path = System.IO.Path.Combine(Server.MapPath("~/images/avatar"), pic); string pathd = "~/images/avatar/" + pic; // file is uploaded file.SaveAs(path); filefo = pathd; using (MemoryStream ms = new MemoryStream()) { file.InputStream.CopyTo(ms); byte[] array = ms.GetBuffer(); } } DataRow newrow = dsUser.Tables[0].Rows[0]; newrow["ID"] = USRID; newrow["USRNM"] = txtUSRNM; newrow["FULNM"] = txtFULNM; newrow["EMAIL"] = txtEMAIL; newrow["PWD"] = CryptionHelper.Encrypt(txtPWD, "tb"); newrow["IS_ADMIN"] = 1; newrow["IS_SYSADM"] = 0; newrow["IS_HR"] = 0; newrow["CHNG_PWD"] = 0; if (filefo == "") { //newrow["AVATAR"] = "~/images/avatar/nullavatar.jpg"; newrow["AVATAR"] = newrow["AVATAR"]; } else { newrow["AVATAR"] = filefo; } if (!Convert.ToBoolean(Session["IS_SYSADM"])) { newrow["CARDNO"] = txtCARDNO; newrow["CVC"] = txtCVC; newrow["STKDAY"] = txtSTKDAY; newrow["STKMONTH"] = txtSTKMONTH; } //newrow["EDATE"] = DateTime.Now; //newrow["EUSRID"] = null; newrow["UDATE"] = DateTime.Now; //newrow["UUSRID"] = null; newrow["NOTE"] = "En Son Güncelleme İşlemi Gerçekleştirdi."; AgentGc data = new AgentGc(); string veri = data.DataModified("USR", newrow, dsUser.Tables[0]); //return Content("<script language='javascript' type='text/javascript'>alert('" + veri + "');</script>"); //ViewBag.addmessageinfo = veri; return(Redirect("/Account/Manage")); //} //return Redirect("/Account/Manage"); }
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")); } }
// // 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()); }