protected void Button1_Click(object sender, EventArgs e)
{
ENTITYDEPARTMAN ent = new ENTITYDEPARTMAN();
ent.Departmanad = TextBox1.Text;
BLLDEPARTMAN.DEPARTMANEKLE(ent);
}
public static int DEPARTMANEKLE(ENTITYDEPARTMAN DEGER)
{
if (DEGER.Departmanad != null && DEGER.Departmanad != " ")
{
return(DALDEPARTMAN.DEPARTMANEKLE(DEGER));
}
return(-1);
}
public static int DEPARTMANEKLE(ENTITYDEPARTMAN DEGER)
{
SqlCommand komut = new SqlCommand("insert into TBLDEPARTMAN (DEPARTMANAD) VALUES (@P1)", SQLBAGLANTISI.bgl);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
komut.Parameters.AddWithValue("@P1", DEGER.Departmanad);
return(komut.ExecuteNonQuery());
}
public static List <ENTITYDEPARTMAN> DEPARTMANLISTESI()
{
List <ENTITYDEPARTMAN> degerler = new List <ENTITYDEPARTMAN>();
SqlCommand komut = new SqlCommand("Select * from tbldepartman", SQLBAGLANTISI.bgl);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
ENTITYDEPARTMAN ent = new ENTITYDEPARTMAN();
ent.Departmanid = Convert.ToByte(dr["DEPARTMANID"]);
ent.Departmanad = dr["DEPARTMANAD"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
