public static List <EntityOgrenci> OgrenciDetay(int OgrenciID)
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand cmd = new SqlCommand("SELECT * FROM TBL_OGRENCILER WHERE OgrenciID = @p1", DBHelper.bgl);
cmd.Parameters.AddWithValue("@p1", OgrenciID);
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ogrenci = new EntityOgrenci();
ogrenci.OgrenciAd = dr["OgrenciAd"].ToString();
ogrenci.OgrenciSoyad = dr["OgrenciSoyad"].ToString();
ogrenci.OgrenciNumara = dr["OgrenciNumara"].ToString();
ogrenci.OgrenciMail = dr["OgrenciMail"].ToString();
ogrenci.OgrenciSifre = dr["OgrenciSifre"].ToString();
ogrenci.OgrenciFotograf = dr["OgrenciFotograf"].ToString();
ogrenci.OgrenciBakiye = Convert.ToDouble(dr["OgrenciBakiye"].ToString());
degerler.Add(ogrenci);
}
dr.Close();
return(degerler);
}
public static List <EntityOgrenci> OgrenciDetay(int id)
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut4 = new SqlCommand("Select * from Tbl_ogrenci where OgrId=@p1", Baglanti.bgl);
komut4.Parameters.AddWithValue("@p1", id);
if (komut4.Connection.State != ConnectionState.Open)
{
komut4.Connection.Open();
}
SqlDataReader oku1 = komut4.ExecuteReader();
while (oku1.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.Id = Convert.ToInt32(oku1["OgrId"].ToString());
ent.Ad = oku1["OgrAd"].ToString();
ent.Soyad = oku1["OgrSoyad"].ToString();
ent.Numara = oku1["OgrNumara"].ToString();
ent.Sifre = oku1["OgrSifre"].ToString();
ent.Fotograf = oku1["OgrFotograf"].ToString();
ent.Bakiye = Convert.ToDouble(oku1["OgrBakiye"].ToString());
degerler.Add(ent);
}
Baglanti.bgl.Close();
return(degerler);
}
public static List <EntityOgrenci> LISTELE()
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut = new SqlCommand("OgrenciListesi", SQLBaglantisi.baglanti);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.ID = Convert.ToInt32(dr["Id"]);
ent.AD = dr["Ad"].ToString();
ent.SOYAD = dr["Soyad"].ToString();
ent.FOTOGRAF = dr["Fotograf"].ToString();
ent.KULUPID = Convert.ToInt32(dr["KulupId"]);
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
protected void Page_Load(object sender, EventArgs e)
{
Baglanti.bgl.Close();
List <EntityOgrenci> ogrList = new List <EntityOgrenci>();
int x = Convert.ToInt32(Session["id"].ToString());
SqlCommand cmd = new SqlCommand("select * from tbl_ogrenci where ogrID like '%" + x + "%'", Baglanti.bgl);;
cmd.Parameters.AddWithValue("@id", ID);
Baglanti.bgl.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
var y = new EntityOgrenci
{
ogrenciID = Convert.ToInt32(dr[0].ToString()),
ogrenciAd = dr[1].ToString(),
ogrenciSoyad = dr[2].ToString(),
ogrenciNumara = dr[3].ToString(),
ogrenciMail = dr[4].ToString(),
ogrenciTelefon = dr[5].ToString(),
ogrenciSifre = dr[6].ToString(),
ogrenciDers = dr[7].ToString()
};
ogrList.Add(y);
}
Repeater1.DataSource = ogrList;
Repeater1.DataBind();
Baglanti.bgl.Close();
}
public static List <EntityOgrenci> OgrenciListesi()
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut = new SqlCommand("OGRENCILISTESI", SqlBaglantisi.baglanti);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.Ad = dr["AD"].ToString();
ent.Soyad = dr["SOYAD"].ToString();
ent.Fotograf = dr["FOTOGRAF"].ToString();
ent.Kulupid = Convert.ToInt16(dr["KULUPID"]);
ent.Id = Convert.ToInt16(dr["ID"]);
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityOgrenci> OgrGuncelle(int id)
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut = new SqlCommand("Select * From Tbl_Ogrenci where OgrId=@p1", Baglanti.bgl);
komut.Parameters.AddWithValue("@p1", id);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityOgrenci entityOgrenci = new EntityOgrenci
{
OgrAd = dr[1].ToString(),
OgrSoyad = dr[2].ToString(),
OgrNumara = dr[3].ToString(),
OgrFoto = dr[4].ToString(),
OgrSifre = dr[5].ToString(),
OgrBakiye = Convert.ToDouble(dr[6])
};
degerler.Add(entityOgrenci);
}
dr.Close();
return(degerler);
}
public static List <EntityOgrenci> GetAll()
{
List <EntityOgrenci> Ogrenciler = new List <EntityOgrenci>();
SqlCommand komut = new SqlCommand("OgrenciListesi", SqlBaglantisi.Baglanti);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ogr = new EntityOgrenci();
ogr.ID = Convert.ToInt16(dr["ID"]);
ogr.Ad = dr["Ad"].ToString();
ogr.Soyad = dr["Soyad"].ToString();
ogr.Fotograf = dr["Fotograf"].ToString();
ogr.KulupID = Convert.ToInt16(dr["KulupID"]);
Ogrenciler.Add(ogr);
}
dr.Close();
return(Ogrenciler);
}
//ogrenci listeleme işlemi
public static List <EntityOgrenci> OgrenciListesi()
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut2 = new SqlCommand("select * from Tblogrenci", Baglanti.bgl);
if (komut2.Connection.State != ConnectionState.Open)
{
komut2.Connection.Open();//eğer bağlantı kapalıysa bağlantıyı aç
}
SqlDataReader dr = komut2.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.Ogrid = Convert.ToInt32(dr["ogrid"].ToString());
ent.Ograd = dr["ograd"].ToString();
ent.Ogrsoyad = dr["ogrsoyad"].ToString();
ent.Ogrnumara = dr["ogrnumara"].ToString();
ent.Ogrsifre = dr["ogrsifre"].ToString();
ent.Ogrfotograf = dr["ogrfotograf"].ToString();
ent.Ogrbakiye = Convert.ToDouble(dr["ogrbakiye"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityOgrenci> Listele()
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut = new SqlCommand("sp_OgrenciListesi", SQLBaglanti.baglanti);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ogr = new EntityOgrenci();
ogr.OgrencilerID = Convert.ToInt32(dr["OgrencilerID"]);
ogr.Ad = dr["Ad"].ToString();
ogr.Soyad = dr["Soyad"].ToString();
ogr.Fotograf = dr["Fotograf"].ToString();
ogr.KulupID = Convert.ToInt32(dr["KulupID"]);
ogr.Mezun = Convert.ToInt32(dr["Mezun"]);
degerler.Add(ogr);
}
dr.Close();
return(degerler);
}
protected void Button1_Click(object sender, EventArgs e)
{
Baglanti.bgl.Close();
EntityOgrenci ent = new EntityOgrenci();
int son = Convert.ToInt32(txtUcret.Text) - Convert.ToInt32(txtOdenecek.Text);
ent.ogrenciBorc = Convert.ToString(son);
ent.ogrenciID = Convert.ToInt32(txtID.Text);
ent.ogrenciKalan = txtOdenecek.Text;
ent.ogrenciTime = "23/01/2021";
SqlCommand komut5 = new SqlCommand("Update tbl_Ogrenci Set ogrBORC=@p1, ogrKALAN=@p2 ,ogrTIME=@p3 where ogrID=@p4 ", Baglanti.bgl);
if (komut5.Connection.State != ConnectionState.Open)
{
komut5.Connection.Open();
}
komut5.Parameters.AddWithValue("@p2", ent.ogrenciKalan);
komut5.Parameters.AddWithValue("@p1", ent.ogrenciBorc);
komut5.Parameters.AddWithValue("@p3", ent.ogrenciTime);
komut5.Parameters.AddWithValue("@p4", ent.ogrenciID);
komut5.ExecuteNonQuery();
Baglanti.bgl.Close();
Response.Redirect("Ogrenciler.aspx");
}
public static List <EntityOgrenci> OgrenciDetay(int id)
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut4 = new SqlCommand("select * from TBLOGRENCI where OGRID=@p1", Baglanti.bgl);
komut4.Parameters.AddWithValue("@p1", id);
if (komut4.Connection.State != ConnectionState.Open)
{
komut4.Connection.Open();
}
SqlDataReader dr = komut4.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.Ad = dr["OGRAD"].ToString();
ent.Soyad = dr["OGRSOYAD"].ToString();
ent.Numara = dr["OGRNUMARA"].ToString();
ent.Fotograf = dr["OGRFOTO"].ToString();
ent.Sifre = dr["OGRSIFRE"].ToString();
ent.Bakiye = Convert.ToDouble(dr["OGRBAKIYE"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityOgrenci> OgrenciListesi()
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut2 = new SqlCommand("select * from TBLOGRENCI", Baglanti.bgl);
if (komut2.Connection.State != ConnectionState.Open)
{
komut2.Connection.Open();
}
SqlDataReader dr = komut2.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.Id = Convert.ToInt32(dr["OGRID"].ToString());
ent.Ad = dr["OGRAD"].ToString();
ent.Soyad = dr["OGRSOYAD"].ToString();
ent.Numara = dr["OGRNUMARA"].ToString();
ent.Fotograf = dr["OGRFOTO"].ToString();
ent.Sifre = dr["OGRSIFRE"].ToString();
ent.Bakiye = Convert.ToDouble(dr["OGRBAKIYE"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityOgrenci> OgrenciListesi()
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut2 = new SqlCommand("Select * from Tbl_Ogrenci", Baglanti.bgl);
if (komut2.Connection.State != ConnectionState.Open)
{
komut2.Connection.Open();
}
SqlDataReader dr = komut2.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.ID = Convert.ToInt32(dr["Ogrid"].ToString());
ent.AD = dr["OgrAd"].ToString();
ent.SOYAD = dr["OgrSoyad"].ToString();
ent.NUMARA = dr["OgrNumara"].ToString();
ent.FOTOGRAF = dr["OgrFotograf"].ToString();
ent.SIFRE = dr["OgrSifre"].ToString();
ent.BAKIYE = Convert.ToDouble(dr["OgrBakiye"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityOgrenci> OgrenciDetay(int id)
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut4 = new SqlCommand("Select * from Tbl_Ogrenci where ogrid=@p1", Baglanti.bgl);
komut4.Parameters.AddWithValue("@p1", id);
if (komut4.Connection.State != ConnectionState.Open)
{
komut4.Connection.Open();
}
SqlDataReader dr = komut4.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.AD = dr["OgrAd"].ToString();
ent.SOYAD = dr["OgrSoyad"].ToString();
ent.NUMARA = dr["OgrNumara"].ToString();
ent.FOTOGRAF = dr["OgrFotograf"].ToString();
ent.SIFRE = dr["OgrSifre"].ToString();
ent.BAKIYE = Convert.ToDouble(dr["OgrBakiye"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
//ogrenci güncelleme sayfasında listemele ve textboxların doldurulma işlemi
public static List <EntityOgrenci> OgrenciDetay(int id)
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut4 = new SqlCommand("select * from Tblogrenci where Ogrid=@p1", Baglanti.bgl);
komut4.Parameters.AddWithValue("@p1", id);
if (komut4.Connection.State != ConnectionState.Open)
{
komut4.Connection.Open();//eğer bağlantı kapalıysa bağlantıyı aç
}
SqlDataReader dr = komut4.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.Ograd = dr["ograd"].ToString();
ent.Ogrsoyad = dr["ogrsoyad"].ToString();
ent.Ogrnumara = dr["ogrnumara"].ToString();
ent.Ogrsifre = dr["ogrsifre"].ToString();
ent.Ogrfotograf = dr["ogrfotograf"].ToString();
ent.Ogrbakiye = Convert.ToDouble(dr["ogrbakiye"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
protected void Button1_Click(object sender, EventArgs e)
{
Baglanti.bgl.Close();
EntityOgrenci ent = new EntityOgrenci();
ent.ogrenciDers = DropDownList1.SelectedItem.Text;
ent.ogrenciID = Convert.ToInt32(TextBox2.Text);
ent.ogrenciBorc = DropDownList1.SelectedValue.ToString();
SqlCommand komut5 = new SqlCommand("Update tbl_Ogrenci Set ogrDers=@p1, ogrBORC=@p2 where ogrID=@p3 ", Baglanti.bgl);
if (komut5.Connection.State != ConnectionState.Open)
{
komut5.Connection.Open();
}
komut5.Parameters.AddWithValue("@p1", ent.ogrenciDers.ToString());
komut5.Parameters.AddWithValue("@p2", ent.ogrenciBorc);
komut5.Parameters.AddWithValue("@p3", ent.ogrenciID);
komut5.ExecuteNonQuery();
Baglanti.bgl.Close();
//TextBox1.Text = DropDownList1.SelectedValue.ToString();
//EntityBasvuruForm ent = new EntityBasvuruForm();
//ent.ogrenciID = int.Parse(TextBox1.Text);
//ent.dersID = int.Parse(DropDownList1.SelectedValue.ToString());
//BLL_Ders.TalepEkleBLL(ent);
}
public static List <EntityOgrenci> ogrenciDetay(int id)
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut4 = new SqlCommand("Select * from tbl_Ogrenci where ogrID=@p1", Baglanti.bgl);
komut4.Parameters.AddWithValue("@p1", id);
if (komut4.Connection.State != ConnectionState.Open)
{
komut4.Connection.Open();
}
SqlDataReader dr = komut4.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.ogrenciAd = dr["ogrAD"].ToString();
ent.ogrenciSoyad = dr["ogrSOYAD"].ToString();
ent.ogrenciNumara = dr["ogrNUMARA"].ToString();
ent.ogrenciMail = dr["ogrMAIL"].ToString();
ent.ogrenciTelefon = dr["ogrTELEFON"].ToString();
ent.ogrenciSifre = dr["ogrSIFRE"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityOgrenci> ogrenciListele()
{
List <EntityOgrenci> degerler = new List <EntityOgrenci>();
SqlCommand komut2 = new SqlCommand("Select * from tbl_Ogrenci", Baglanti.bgl);
if (komut2.Connection.State != ConnectionState.Open)
{
komut2.Connection.Open();
}
SqlDataReader dr = komut2.ExecuteReader();
while (dr.Read())
{
EntityOgrenci ent = new EntityOgrenci();
ent.ogrenciID = Convert.ToInt32(dr["ogrID"].ToString());
ent.ogrenciAd = dr["ogrAD"].ToString();
ent.ogrenciSoyad = dr["ogrSOYAD"].ToString();
ent.ogrenciNumara = dr["ogrNUMARA"].ToString();
ent.ogrenciMail = dr["ogrMAIL"].ToString();
ent.ogrenciTelefon = dr["ogrTELEFON"].ToString();
ent.ogrenciSifre = dr["ogrSIFRE"].ToString();
ent.ogrenciDers = dr["ogrDERS"].ToString();
ent.ogrenciBorc = dr["ogrBORC"].ToString();
ent.ogrenciKalan = dr["ogrKALAN"].ToString();
ent.ogrenciTime = dr["ogrTIME"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static int OgrenciEkleBusiness(EntityOgrenci parametre)
{//eğer boş değilse dataogrencşye git ve değerleri ekle-kontrol
if (parametre.Ograd != null && parametre.Ogrsoyad != null && parametre.Ogrnumara != null && parametre.Ogrsifre != null && parametre.Ogrfotograf != null)
{
return(DataOgrenci.OgrenciEkle(parametre));
}
return(-1);
}
public static bool Guncelle(EntityOgrenci deger)
{
if (deger.Ad != null && deger.Soyad != null && deger.KulupID > 0 && deger.Fotograf != null && deger.KulupID > 0 && deger.OgrencilerID > 0)
{
return(FacadeOgrenci.Guncelle(deger));
}
return(false);
}
public static int Ekle(EntityOgrenci deger)
{
if (deger.Ad != null && deger.Soyad != null && deger.KulupID > 0 && deger.Fotograf != null && deger.KulupID > 0)
{
return(FacadeOgrenci.Ekle(deger));
}
return(-1);
}
public static bool GUNCELLE(EntityOgrenci deger)
{
if (deger.ID > 0 && deger.AD != null && deger.SOYAD != null && deger.FOTOGRAF != null && deger.KULUPID > 0 && deger.KULUPID > 0)
{
return(FacadeOgrenci.GUNCELLE(deger));
}
return(false);
}
public static int EKLE(EntityOgrenci deger)
{
if (deger.AD != null && deger.SOYAD != null && deger.KULUPID > 0 && deger.FOTOGRAF != null && deger.KULUPID > 0)
{
return(FacadeOgrenci.EKLE(deger));
}
return(-1);
}
public static bool OgrenciGuncelleBLL(EntityOgrenci p)
{
if (p.Ad != null && p.Soyad != null && p.Numara != null && p.SIFRE != null && p.FOTO != null && p.Id > 0 && p.Ad != "" && p.Soyad != "" && p.FOTO != "" && p.Numara != "" && p.SIFRE != "")
{
return(DALOgrenci.OgrenciGuncelle(p));
}
return(false);
}
//ogrenci güncelleme işlemi
public static bool BusinessOgrenciGuncelle(EntityOgrenci p)
{
if (p.Ograd != null && p.Ograd != "" && p.Ogrsoyad != null && p.Ogrsoyad != "" && p.Ogrnumara != null && p.Ogrnumara != "" && p.Ogrsifre != null && p.Ogrsifre != "" && p.Ogrfotograf != null && p.Ogrfotograf != "")
{
return(DataOgrenci.OgrenciGuncelle(p));
}
return(false);
}
public static int OgrenciEkle(EntityOgrenci ogrenci)
{
if (ogrenci.OgrenciAd != null && ogrenci.OgrenciSoyad != null && ogrenci.OgrenciNumara != null && ogrenci.OgrenciMail != null && ogrenci.OgrenciSifre != null && ogrenci.OgrenciFotograf != null && ogrenci.OgrenciBakiye >= 0)
{
return(DALOgrenci.OgrenciEkle(ogrenci));
}
return(-1);
}
public static int OgrenciEkleBll(EntityOgrenci p)
{
if (p.Ad != null && p.Soyad != null && p.Numara != null && p.Sifre != null && p.Fotograf != null)
{
return(DALOgrenci.OgrenciEkle(p));
}
return(-1);
}
public static bool OgrenciGuncelleBll(EntityOgrenci p)
{
if (p.Ad != null && p.Soyad != null && p.Numara != null && p.Sifre != null && p.Fotograf != null && p.Id > 0)
{
return(DALOgrenci.OgrenciGuncelle(p));
}
return(false);
}
public static int OgrenciEkleBLL(EntityOgrenci p)
{
if (p.AD != null && p.SOYAD != null && p.NUMARA != null && p.SIFRE != null && p.FOTOGRAF != null)
{
return(DALOgrenci.OgrenciEkle(p));
}
return(-1);
}
public static int OgrenciEkleBLL(EntityOgrenci p)
{
if (p.Ad != null && p.Soyad != null && p.Numara != null && p.SIFRE != null && p.FOTO != null)
{
return(DALOgrenci.OgrenciEkle(p));
}
return(-1);
}
