public List<Personel> GetirTumPersonel() { string sorgu = "SELECT Id, Adi, Soyadi, EPosta, KullaniciAdi, SorumlusuId, PersonelTurId FROM Personel AS P WHERE P.AktifMi = 1"; provider.Command.Parameters.Clear(); DataTable sonuc = provider.GetDataTable(sorgu); List<Personel> personeller = new List<Personel>(); if (sonuc.Rows.Count > 0) { foreach (DataRow dr in sonuc.Rows) { Personel personel = new Personel(); personel.Id = (int)dr["Id"]; personel.Adi = dr["Adi"].ToString(); personel.Soyadi = dr["Soyadi"].ToString(); personel.EPosta = dr["EPosta"].ToString(); personel.KullaniciAdi = dr["KullaniciAdi"].ToString(); personel.SorumlusuId = (dr.IsNull("SorumlusuId") == true ? null : (int?)dr["SorumlusuId"]); personel.PersonelTurId = (byte)dr["PersonelTurId"]; personeller.Add(personel); } } return personeller; }
public Personel PersonelLogin(string kullaniciAdi, string sifre) { string sorgu = "SELECT Id, Adi, Soyadi, EPosta, KullaniciAdi, SorumlusuId, PersonelTurId FROM Personel AS P WHERE P.KullaniciAdi = @KullaniciAdi AND P.Sifre = @Sifre AND P.AktifMi = 1"; provider.Command.Parameters.Clear(); provider.Command.Parameters.AddWithValue("@KullaniciAdi", kullaniciAdi); provider.Command.Parameters.AddWithValue("@Sifre", sifre); DataTable sonuc = provider.GetDataTable(sorgu); Personel personel = null; if(sonuc.Rows.Count > 0) { DataRow dr = sonuc.Rows[0]; personel = new Personel(); personel.Id = (int)dr["Id"]; personel.Adi = dr["Adi"].ToString(); personel.Soyadi = dr["Soyadi"].ToString(); personel.EPosta = dr["EPosta"].ToString(); personel.KullaniciAdi = dr["KullaniciAdi"].ToString(); personel.SorumlusuId = (dr.IsNull("SorumlusuId") == true ? null : (int?)dr["SorumlusuId"]) ; personel.PersonelTurId = (byte)dr["PersonelTurId"]; } return personel; }