private bool AuthenticationSuccess() { List <object> par = new List <object>() { Login.Kurzzeichen }; List <string> col = new List <string>() { "Kz" }; DataTable dt = TR_SQL_Commands.ReturnStoredProcedureValue("Select_PData_ByKz", par, col); if (dt.Rows.Count != 0) { if (Crypto.EncryptString(dt.Rows[0]["UserPassword"].ToString()) == Login.Passwort) { HttpContext.Session.SetInt32("IsAdmin", (dt.Rows[0]["IsAdmin"].ToString() == "1") ? 1 : 0); HttpContext.Session.SetString("LayoutPage", (dt.Rows[0]["IsAdmin"].ToString() == "1") ? "~/Pages/Shared/_LayoutAdmin.cshtml" : "~/Pages/Shared/_Layout.cshtml"); HttpContext.Session.SetInt32("Pid", Convert.ToInt32((dt.Rows[0]["idPersonal"].ToString()))); HttpContext.Session.SetString("AnwStatusColor", ControllerZeit.GetStatusAnwesendheit(HttpContext.Session.GetInt32("Pid")) == 0 ? "red" : "green"); HttpContext.Session.SetString("AnwStatus", ControllerZeit.GetStatusAnwesendheit(HttpContext.Session.GetInt32("Pid")) == 0 ? "Abwesend" : "Anwesend"); return(true); } } return(false); }
public Stammdaten(int PId) { List <string> col = new List <string>() { "PId" }; List <object> par = new List <object>() { PId }; DataTable dt = TR_SQL_Commands.ReturnStoredProcedureValue("Select_Stammdaten_ByPId", par, col); this.PId = Convert.ToInt32(dt.Rows[0]["idPersonal"].ToString()); this.Kurzzeichen = dt.Rows[0]["Kurzzeichen"].ToString(); this.Vorname = dt.Rows[0]["Vorname"].ToString(); this.Nachname = dt.Rows[0]["Nachname"].ToString(); this.Abteilung = dt.Rows[0]["Abteilungsname"].ToString(); this.Telefonnummer = dt.Rows[0]["Telefonnummer"].ToString(); this.Anwesend = dt.Rows[0]["AnwesendStatus"].ToString() == "1" ? "Anwesend" : dt.Rows[0]["AnwesendStatus"].ToString() == "2" ? "Pause" : "Abwesend"; }
private void LoadUserData() { List <object> par = new List <object>() { Login.Kurzzeichen }; List <string> col = new List <string>() { "PKz" }; DataTable dt = TR_SQL_Commands.ReturnStoredProcedureValue("Select_LoginUser", par, col); Login.Vorname = dt.Rows[0]["Vorname"].ToString(); Login.Nachname = dt.Rows[0]["Nachname"].ToString(); Login.Telefonnummer = dt.Rows[0]["Telefonnummer"].ToString(); Login.IdPersonal = Convert.ToInt32(dt.Rows[0]["idPersonal"].ToString()); Login.IdAbteilung = Convert.ToInt32(dt.Rows[0]["idAbteilung"].ToString()); Login.AnwesendStatus = Convert.ToInt32(dt.Rows[0]["AnwesendStatus"].ToString()); }