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); }