public static DataTable CalisanCek(string kullaniciID)
{
string kod = "Select * From tblKullanicilar Where KullaniciID=@kullaniciID";
string[] veri = { kullaniciID };
string[] parametre = { "@kullaniciID" };
return(VT.ExecuteReader(kod, veri, parametre));
}
public static DataTable DepartmanCek(string departmanID)
{
string kod = "Select * From tblDepartmanlar Where DepartmanID=@departmanID";
string[] veri = { departmanID };
string[] parametre = { "@departmanID" };
return(VT.ExecuteReader(kod, veri, parametre));
}
public static DataTable KullaniciGiris(string eposta, string sifre)
{
string kod = "Select * From tblKullanicilar Where EPosta=@eposta and Sifre=@sifre";
string[] veri = { eposta, sifre };
string[] parametre = { "@eposta", "@sifre" };
return(VT.ExecuteReader(kod, veri, parametre));
}
public static DataTable CagriCek(string cagriID)
{
string kod = @"SELECT tblCagrilar.*, tblKullanicilar.KullaniciAdi, tblCagriSurec.Ad
FROM (tblCagrilar INNER JOIN tblKullanicilar ON tblCagrilar.AcanKisi = tblKullanicilar.KullaniciID) INNER JOIN tblCagriSurec ON tblCagrilar.Durumu = tblCagriSurec.CagriSurecID Where CagriID=@cagriID";
string[] veri = { cagriID };
string[] parametre = { "@cagriID" };
return(VT.ExecuteReader(kod, veri, parametre));
}
public static DataTable Asama()
{
return(VT.ExecuteReader("Select * From tblCagriSurec"));
}
public static DataTable Yetkiler()
{
return(VT.ExecuteReader("Select * From tblYetki"));
}
public static DataTable Calisanlar()
{
string kod = @"SELECT tblKullanicilar.*, tblDepartmanlar.DepartmanAdi FROM tblKullanicilar INNER JOIN tblDepartmanlar ON tblKullanicilar.DepartmanID = tblDepartmanlar.DepartmanID";
return(VT.ExecuteReader(kod));
}
public static DataTable KullaniciCek(string kullaniciID)
{
string kod = "Select * From tblKullanicilar Where KullaniciID=" + kullaniciID;
return(VT.ExecuteReader(kod));
}
public static DataTable CagriListeleUye(string calisanID)
{
string[] veri = { calisanID };
string[] parametre = { "@calisanID" };
return(VT.ExecuteReader(@"SELECT tblCagrilar.*, tblKullanicilar.KullaniciAdi, tblCagriSurec.Ad From (tblCagrilar INNER JOIN tblKullanicilar ON tblCagrilar.AcanKisi = tblKullanicilar.KullaniciID) INNER JOIN tblCagriSurec ON tblCagrilar.Durumu = tblCagriSurec.CagriSurecID WHERE AcanKisi=@calisanID", veri, parametre));
}
public static DataTable Cagrilar()
{
return(VT.ExecuteReader(@"SELECT tblCagrilar.*, tblKullanicilar.KullaniciAdi, tblCagriSurec.Ad
FROM (tblCagrilar INNER JOIN tblKullanicilar ON tblCagrilar.AcanKisi = tblKullanicilar.KullaniciID) INNER JOIN tblCagriSurec ON tblCagrilar.Durumu = tblCagriSurec.CagriSurecID"));
}
public static DataTable Departmanlar()
{
return(VT.ExecuteReader("Select * From tblDepartmanlar"));
}