protected void kaydet_Click(object sender, EventArgs e)
{
EntityDepartman ekle = new EntityDepartman();
ekle.DepartmanAd = TextBox1.Text;
BLLDepartman.BLLDepartmanEkle(ekle);
}
protected void Button1_Click(object sender, EventArgs e)
{
EntityDepartman ent = new EntityDepartman();
ent.Departmanad = TextBox1.Text;
BLLDepartman.BLLDepartmanEkle(ent);
}
public static int BLLDepartmanEkle(EntityDepartman p)
{
if (p.Departmanad != "")
{
return(DALDepartman.DepartmanEkle(p));
}
return(-1);
}
public static int DepartmanEkle(EntityDepartman departmanDeger)
{
SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceDepartman.InsertDepartmanSorgu, Baglanti.connection);
command.Parameters.AddWithValue(ResourceDepartman.Parameter, departmanDeger.DepartmanAd);
return(command.ExecuteNonQuery());
}
public static int BLLDepartmanEkle(EntityDepartman departman)
{
if (departman.DepartmanAd != null && departman.DepartmanAd != " ")
{
return(DALDepartman.DepartmanEkle(departman));
}
return(-1);
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
EntityDepartman entityDepartman = new EntityDepartman();
entityDepartman.DepartmanAd = txtDepartmanAd.Text;
int sonuc = BLLDepartman.BLLDepartmanEkle(entityDepartman);
MyPresentationExtensions.ShowErrorMessageOrRedirect(sonuc, ResourceDepartman.DepartmanlarSayfasi, ResourceDepartman.DepartmanEkleError);
}
public static int BLLDepartmanGuncelle(EntityDepartman entityDepartman)
{
if (entityDepartman.DepartmanAd != "")
{
return(DALDepartman.DepartmanGuncelle(entityDepartman));
}
return(-1);
}
protected void Page_Load(object sender, EventArgs e)
{
EntityDepartman entityDepartman = BLLDepartman.BLLDepartmanGetirById(Convert.ToByte(Request.QueryString["id"]));
if (Page.IsPostBack == false)
{
txtDepartmanId.Text = entityDepartman.DepartmanId.ToString();
txtDepartmanAd.Text = entityDepartman.DepartmanAd;
}
}
public static int DepartmanEkle(EntityDepartman p)
{
SqlCommand komut1 = new SqlCommand("insert into TBLDEPARTMAN (DEPARTMANAD) Values (@p1)", Baglanti.bgl);
if (komut1.Connection.State != ConnectionState.Open)
{
komut1.Connection.Open();
}
komut1.Parameters.AddWithValue("@p1", p.Departmanad);
return(komut1.ExecuteNonQuery());
}
public static int DepartmanEkle(EntityDepartman departman)
{
SqlCommand ekle = new SqlCommand("insert into TBLDEPARTMAN (DEPARTMANAD) values (@departmanad)", Baglanti.baglanti);
if (ekle.Connection.State != ConnectionState.Open)
{
ekle.Connection.Open();
}
ekle.Parameters.AddWithValue("@departmanad", departman.DepartmanAd);
return(ekle.ExecuteNonQuery());
}
public static EntityDepartman DepartmanGetirById(byte?id)
{
EntityDepartman entityDepartman = new EntityDepartman();
SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceDepartman.SelectDepartmanByIdSorgu, Baglanti.connection);
command.Parameters.AddWithValue(ResourceDepartman.IdParameter, id);
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
entityDepartman.DepartmanId = Convert.ToByte(dr[ResourceDepartman.DEPARTMANID]);
entityDepartman.DepartmanAd = dr[ResourceDepartman.DEPARTMANAD].ToString();
}
dr.Close();
return(entityDepartman);
}
public static List <EntityDepartman> DepartmanListesi()
{
List <EntityDepartman> degerler = new List <EntityDepartman>();
SqlCommand komut = new SqlCommand("SELECT *FROM TBLDEPARTMAN", Baglanti.bgl);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityDepartman ent = new EntityDepartman();
ent.Departmanid = byte.Parse(dr["DEPARTMANID"].ToString());
ent.Departmanad = dr["DEPARTMANAD"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
