public static List <entitypersonel> personellistesi()
{
List <entitypersonel> degerler = new List <entitypersonel>();
SqlCommand cmd = new SqlCommand("select * from tbl_personel", baglanti.bag);
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
entitypersonel ent = new entitypersonel();
ent.Id = int.Parse(dr[0].ToString());
ent.Ad = dr[1].ToString();
ent.Soyad = dr[2].ToString();
ent.Sehir = dr[3].ToString();
ent.Gorev = dr[4].ToString();
ent.Maas = short.Parse(dr[5].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
private void btn_sil_Click(object sender, EventArgs e)
{
entitypersonel ent = new entitypersonel();
ent.Id = int.Parse(txt_id.Text);
logicpersonel.llpersonelsil(ent.Id);
}
private void btn_ekle_Click(object sender, EventArgs e)
{
entitypersonel ent = new entitypersonel();
ent.Ad = txt_ad.Text;
ent.Soyad = txt_soyad.Text;
ent.Sehir = txt_sehir.Text;
ent.Gorev = txt_gorev.Text;
ent.Maas = short.Parse(txt_maas.Text);
logicpersonel.llpersonelekle(ent);
}
public static bool llpersonelguncelle(entitypersonel ent)
{
if (ent.Ad.Length >= 3 && ent.Ad != "" && ent.Maas >= 4500)
{
return(DALPersonel.personelguncelle(ent));
}
else
{
return(false);
}
}
public static int llpersonelekle(entitypersonel p)
{
if (p.Ad != "" && p.Soyad != "" && p.Maas >= 3500 && p.Ad.Length >= 3)
{
return(DALPersonel.personelekle(p));
}
else
{
return(-1);
}
}
public static int personelekle(entitypersonel p)
{
SqlCommand cmd2 = new SqlCommand("insert into tbl_personel (personel_ad,personel_soyad,personel_sehir,personel_gorev,personel_maas) values (@ad,@soyad,@sehir,@gorev,@maas)", baglanti.bag);
if (cmd2.Connection.State != ConnectionState.Open)
{
cmd2.Connection.Open();
}
cmd2.Parameters.AddWithValue("@ad", p.Ad);
cmd2.Parameters.AddWithValue("@soyad", p.Soyad);
cmd2.Parameters.AddWithValue("@sehir", p.Sehir);
cmd2.Parameters.AddWithValue("@gorev", p.Gorev);
cmd2.Parameters.AddWithValue("@maas", p.Maas);
return(cmd2.ExecuteNonQuery());
}
public static bool personelguncelle(entitypersonel ent)
{
SqlCommand cmd4 = new SqlCommand("update tbl_personel set personel_ad=@ad,personel_soyad=@soyad,personel_sehir=@sehir,personel_gorev=@gorev,personel_maas=@maas where personel_id=@id", baglanti.bag);
if (cmd4.Connection.State != ConnectionState.Open)
{
cmd4.Connection.Open();
}
cmd4.Parameters.AddWithValue("@ad", ent.Ad);
cmd4.Parameters.AddWithValue("@soyad", ent.Soyad);
cmd4.Parameters.AddWithValue("@sehir", ent.Sehir);
cmd4.Parameters.AddWithValue("@gorev", ent.Gorev);
cmd4.Parameters.AddWithValue("@maas", ent.Maas);
cmd4.Parameters.AddWithValue("@id", ent.Id);
return(cmd4.ExecuteNonQuery() > 0);
}
