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