public static void SetStempel(int?Pid)
{
//int? status = 0;
//switch (Pid)
//{
// case 0:
// status = 1;
// break;
// case 1:
// status = 0;
// break;
// default:
// break;
//}
TR_SQL_Commands.CallStoredProcedure("Update_Stamp_ByPId",
new List <object>()
{
Pid
},
new List <string>()
{
"Pid"
});
}
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 ClientSession(string _Kurzzeichen, string _Session)
{
TR_SQL_Commands.CallStoredProcedure("Insert_Session",
new List <object>()
{
_Kurzzeichen,
_Session
},
new List <string>()
{
"Kurzzeichen",
"SessionName"
});
}
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());
}
