internal String ManageCourses(bool CzyAdmin)
{
String query = "SELECT k.KursID AS [IDkursu], k.Typ AS [TypKursu], j.Nazwa AS [Jezyk], p.Nazwa AS [Poziom], u.Imie AS [ImieProwadzacego], u.Nazwisko AS [NazwiskoProwadzacego], u.\"E-mail\" AS [E-mail prowadzacego] FROM Kursy k JOIN Users u ON (u.UserID = k.IDprowadzacego) JOIN Jezyki j ON (j.JezykID = k.Jezyk) JOIN Poziomy p ON (p.PoziomID = k.Poziom);";
Courses[] cours = GetCoursesFromSQL(query, SQLConnector.GetSQLConnection());
String result = "<h2>Lista kursów w bazie:</h2><table>";
result += "<tr><td>ID kursu</td><td>Typ kursu</td><td>Język</td><td>Poziom</td><td>Imię Prowadzącego</td><td>Nazwisko Prowadzącego</td><td>E-mail Prowadzącego</td></tr>";
int i = 0;
while (i < cours.Length)
{
result += "<tr><td>" + cours[i].IDkursu + "</td><td>" + cours[i].TypKursu + "</td><td>" + cours[i].Jezyk + "</td><td>" + cours[i].Poziom + "</td><td>" + cours[i].ImieProwadzacego + "</td><td>" + cours[i].NazwiskoProwadzacego + "</td><td>" + cours[i].EmailProwadzacego + "</td>";
AdminRightsChecker rights = new AdminRightsChecker(Request.Cookies["user"], Session);
if (rights.CzySek())
{
result += "<td><a href=\"?content=ManageMaterials&ID=" + cours[i].IDkursu + "\">Zarządzaj materiałami do kursu</a></td><td><a href=\"?content=EditCourses&ID=" + cours[i].IDkursu + "\">edycja</a>" + "</td></tr>";
}
/*
* if (rights.CzyAdmin())
* {
* result += "<td><a href=\"?content=EditCourses&ID=" + cours[i].IDkursu + "\">edycja</a>" + "</td></tr>";
* }
*/
else
{
result += "</tr>";
}
i++;
}
result += "</table>";
// Dodaj nowy kurs:
if (CzyAdmin)
{
result += "<p><a href=\"?content=AddCourse\" class=\"blackHyperlink\">Dodaj nowy kurs</a></p>";
result += "<p><a href=\"?content=\">Powrót</a></p>";
}
return(result);
}
internal String editUser(int ID)
{
AdminRightsChecker userRights = new AdminRightsChecker(ID);
String result = "<form id=\"editUser\" name=\"editUser\" action=\"#\" method=\"post\"><ul>";
DataClassesDataContext d = new DataClassesDataContext();
var query = from u in d.Users where u.UserID == ID select u;
result += "<li class=\"PAMenuItems\">Login: <input name=\"login\" type=\"text\" value=\"" + query.First().Login + "\" /></li>";
result += "<li class=\"PAMenuItems\">Imię: <input name=\"imie\" type=\"text\" value=\"" + query.First().Imie + "\" /></li>";
result += "<li class=\"PAMenuItems\">Nazwisko: <input name=\"nazwisko\" type=\"text\" value=\"" + query.First().Nazwisko + "\" /></li>";
result += "<li class=\"PAMenuItems\">Numer telefonu: +<input name=\"numerPanstwa\" type=\"text\" value=\"" + query.First().PhoneCountryCode + "\" />(<input name=\"numerWojewodztwa\" type=\"text\" value=\"" + query.First().PhoneAreaCode + "\" />)<input name=\"numerTelefonu\" type=\"text\" value=\"" + query.First().PhoneNumber + "\" /></li>";
result += "<li class=\"PAMenuItems\">Adres:</li><li class=\"PAMenuItems\">Ulica: <input name=\"ulica\" type=\"text\" value=\"" + query.First().Street + "\" /><input name=\"numerDomu\" type=\"text\" value=\"" + query.First().StreetNumber + "\" />, mieszkania <input name=\"numerMieszkania\" type=\"text\" value=\"" + query.First().FlatNumber + "\" /></li>";
result += "<li class=\"PAMenuItems\">Kod pocztowy: <input name=\"kodPocztowy\" type=\"text\" value=\"" + query.First().PostCode + "\" /> Miasto: <input name=\"miasto\" type=\"text\" value=\"" + query.First().City + "\" /></li>";
result += "<li class=\"PAMenuItems\">Uprawnienia użytkownika: <select name=\"rights\"><option value=\"1\"";
if (userRights.CzyAdmin())
{
result += " selected=\"selected\"";
}
result += ">Administrator</option><option value=\"2\"";
if (!(userRights.CzyAdmin()) && (userRights.CzySek()))
{
result += " selected=\"selected\"";
}
result += ">Sekretariat</option><option value=\"3\"";
if (!(userRights.CzyAdmin()) && !(userRights.CzySek()))
{
result += " selected=\"selected\"";
}
result += ">Użytkownik</option></select></li>";
result += "<input name=\"id\" type=\"hidden\" value=\"" + query.First().UserID + "\" />";
result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"editUser\").submit();\" />";
result += "</ul></form>";
result += "<p><a href=\"?content=ShowUsers\">Powrót do listy użytkowników</a><br /><a href=\"?content=\">Powrót do panelu administracyjnego</a></p>";
d.Dispose();
return(result);
}
internal String ShowUsers()
{
AdminRightsChecker rights = new AdminRightsChecker(Request.Cookies["user"], Session);
String result = "<table><tr><td>Login</td><td>E-mail</td><td>Imie</td><td>Nazwisko</td><td>Numer kierunkowy (państwa)</td><td>Numer kierunkowy (województwo)</td><td>Numer telefonu</td><td>Ulica</td><td>Numer ulicy</td><td>Numer domu</td><td>Kod pocztowy</td><td>Miasto</td><td></td><td></td></tr>";
DataClassesDataContext d = new DataClassesDataContext();
List <Users> l = d.Users.ToList();
foreach (var k in l)
{
result += "<tr><td>" + k.Login + "</td><td>" + k.E_mail + "</td><td>" + k.Imie + "</td><td>" + k.Nazwisko + "</td><td>" + k.PhoneCountryCode + "</td><td>" + k.PhoneAreaCode + "</td><td>" + k.PhoneNumber + "</td><td>" + k.Street + "</td><td>" + k.StreetNumber + "</td><td>" + k.FlatNumber + "</td><td>" + k.PostCode + "</td><td>" + k.City + "</td>";
if (rights.CzyAdmin())
{
result += "<td><a href=\"?content=EditUsers&ID=" + k.UserID + "\">edycja</a></td><td><a href=\"?content=DeleteUsers&ID=" + k.UserID + "\">usuń</a></td></tr>";
}
else
{
result += "<td></td><td></td></tr>";
}
}
result += "</table>";
result += "<p><a href=\"?content=\">Powrót</a></p>";
d.Dispose();
return(result);
}
internal String editUser(int ID)
{
AdminRightsChecker userRights = new AdminRightsChecker(ID);
String result = "<form id=\"editUser\" name=\"editUser\" action=\"#\" method=\"post\"><ul>";
DataClassesDataContext d = new DataClassesDataContext();
var query = from u in d.Users where u.UserID == ID select u;
result += "<li class=\"PAMenuItems\">Login: <input name=\"login\" type=\"text\" value=\"" + query.First().Login + "\" /></li>";
result += "<li class=\"PAMenuItems\">Imię: <input name=\"imie\" type=\"text\" value=\"" + query.First().Imie + "\" /></li>";
result += "<li class=\"PAMenuItems\">Nazwisko: <input name=\"nazwisko\" type=\"text\" value=\"" + query.First().Nazwisko + "\" /></li>";
result += "<li class=\"PAMenuItems\">Numer telefonu: +<input name=\"numerPanstwa\" type=\"text\" value=\"" + query.First().PhoneCountryCode + "\" />(<input name=\"numerWojewodztwa\" type=\"text\" value=\"" + query.First().PhoneAreaCode + "\" />)<input name=\"numerTelefonu\" type=\"text\" value=\"" + query.First().PhoneNumber + "\" /></li>";
result += "<li class=\"PAMenuItems\">Adres:</li><li class=\"PAMenuItems\">Ulica: <input name=\"ulica\" type=\"text\" value=\"" + query.First().Street + "\" /><input name=\"numerDomu\" type=\"text\" value=\"" + query.First().StreetNumber + "\" />, mieszkania <input name=\"numerMieszkania\" type=\"text\" value=\"" + query.First().FlatNumber + "\" /></li>";
result += "<li class=\"PAMenuItems\">Kod pocztowy: <input name=\"kodPocztowy\" type=\"text\" value=\"" + query.First().PostCode + "\" /> Miasto: <input name=\"miasto\" type=\"text\" value=\"" + query.First().City + "\" /></li>";
result += "<li class=\"PAMenuItems\">Uprawnienia użytkownika: <select name=\"rights\"><option value=\"1\"";
if (userRights.CzyAdmin()) result += " selected=\"selected\"";
result += ">Administrator</option><option value=\"2\"";
if (!(userRights.CzyAdmin()) && (userRights.CzySek())) result += " selected=\"selected\"";
result += ">Sekretariat</option><option value=\"3\"";
if (!(userRights.CzyAdmin()) && !(userRights.CzySek())) result += " selected=\"selected\"";
result += ">Użytkownik</option></select></li>";
result += "<input name=\"id\" type=\"hidden\" value=\"" + query.First().UserID + "\" />";
result += "<input type=\"submit\" value=\"Zapisz\" onClick=\"document.getElementById(\"editUser\").submit();\" />";
result += "</ul></form>";
result += "<p><a href=\"?content=ShowUsers\">Powrót do listy użytkowników</a><br /><a href=\"?content=\">Powrót do panelu administracyjnego</a></p>";
d.Dispose();
return result;
}
internal String ShowUsers()
{
AdminRightsChecker rights = new AdminRightsChecker(Request.Cookies["user"], Session);
String result = "<table><tr><td>Login</td><td>E-mail</td><td>Imie</td><td>Nazwisko</td><td>Numer kierunkowy (państwa)</td><td>Numer kierunkowy (województwo)</td><td>Numer telefonu</td><td>Ulica</td><td>Numer ulicy</td><td>Numer domu</td><td>Kod pocztowy</td><td>Miasto</td><td></td><td></td></tr>";
DataClassesDataContext d = new DataClassesDataContext();
List<Users> l = d.Users.ToList();
foreach (var k in l)
{
result += "<tr><td>" + k.Login + "</td><td>" + k.E_mail + "</td><td>" + k.Imie + "</td><td>" + k.Nazwisko + "</td><td>" + k.PhoneCountryCode + "</td><td>" + k.PhoneAreaCode + "</td><td>" + k.PhoneNumber + "</td><td>" + k.Street + "</td><td>" + k.StreetNumber + "</td><td>" + k.FlatNumber + "</td><td>" + k.PostCode + "</td><td>" + k.City + "</td>";
if (rights.CzyAdmin())
{
result += "<td><a href=\"?content=EditUsers&ID=" + k.UserID + "\">edycja</a></td><td><a href=\"?content=DeleteUsers&ID=" + k.UserID + "\">usuń</a></td></tr>";
}
else
{
result += "<td></td><td></td></tr>";
}
}
result += "</table>";
result += "<p><a href=\"?content=\">Powrót</a></p>";
d.Dispose();
return result;
}
internal String ManageCourses(bool CzyAdmin)
{
String query = "SELECT k.KursID AS [IDkursu], k.Typ AS [TypKursu], j.Nazwa AS [Jezyk], p.Nazwa AS [Poziom], u.Imie AS [ImieProwadzacego], u.Nazwisko AS [NazwiskoProwadzacego], u.\"E-mail\" AS [E-mail prowadzacego] FROM Kursy k JOIN Users u ON (u.UserID = k.IDprowadzacego) JOIN Jezyki j ON (j.JezykID = k.Jezyk) JOIN Poziomy p ON (p.PoziomID = k.Poziom);";
Courses[] cours = GetCoursesFromSQL(query, SQLConnector.GetSQLConnection());
String result = "<h2>Lista kursów w bazie:</h2><table>";
result += "<tr><td>ID kursu</td><td>Typ kursu</td><td>Język</td><td>Poziom</td><td>Imię Prowadzącego</td><td>Nazwisko Prowadzącego</td><td>E-mail Prowadzącego</td></tr>";
int i = 0;
while (i < cours.Length)
{
result += "<tr><td>" + cours[i].IDkursu + "</td><td>" + cours[i].TypKursu + "</td><td>" + cours[i].Jezyk + "</td><td>" + cours[i].Poziom + "</td><td>" + cours[i].ImieProwadzacego + "</td><td>" + cours[i].NazwiskoProwadzacego + "</td><td>" + cours[i].EmailProwadzacego + "</td>";
AdminRightsChecker rights = new AdminRightsChecker(Request.Cookies["user"], Session);
if (rights.CzySek())
{
result += "<td><a href=\"?content=ManageMaterials&ID=" + cours[i].IDkursu + "\">Zarządzaj materiałami do kursu</a></td><td><a href=\"?content=EditCourses&ID=" + cours[i].IDkursu + "\">edycja</a>" + "</td></tr>";
}
/*
if (rights.CzyAdmin())
{
result += "<td><a href=\"?content=EditCourses&ID=" + cours[i].IDkursu + "\">edycja</a>" + "</td></tr>";
}
*/
else
{
result += "</tr>";
}
i++;
}
result += "</table>";
// Dodaj nowy kurs:
if (CzyAdmin)
{
result += "<p><a href=\"?content=AddCourse\" class=\"blackHyperlink\">Dodaj nowy kurs</a></p>";
result += "<p><a href=\"?content=\">Powrót</a></p>";
}
return result;
}
