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