public static int UrunGuncelle(EntityUrun entityUrun) { if (entityUrun.UrunAd != "" && entityUrun.UrunFiyat > 0 && entityUrun.UrunAdet >= 0) { return(DALUrun.UrunGuncelle(entityUrun)); } return(-1); }
public static int BLLUrunEkle(EntityUrun urun) { if (urun.UrunAd != null) { return(DALUrun.UrunEkle(urun)); } return(-1); }
protected void kaydet_Click(object sender, EventArgs e) { EntityUrun ekle = new EntityUrun(); ekle.UrunAd = TextBox1.Text; ekle.UrunAdet = Convert.ToInt32(TextBox2.Text); ekle.UrunFiyat = Convert.ToInt32(TextBox3.Text); BLLUrun.BLLUrunEkle(ekle); }
protected void Button1_Click(object sender, EventArgs e) { EntityUrun ent = new EntityUrun(); ent.Urunad = TextBox1.Text; ent.Urunadet = int.Parse(TextBox2.Text); ent.Urunfiyat = decimal.Parse(TextBox3.Text); BLLUrun.BLLUrunEkle(ent); }
public static int UrunEkle(EntityUrun urunDeger) { SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceUrun.InsertUrunSorgu, Baglanti.connection); command.Parameters.AddWithValue(ResourceUrun.Parameter1, urunDeger.UrunAd); command.Parameters.AddWithValue(ResourceUrun.Parameter2, urunDeger.UrunFiyat); command.Parameters.AddWithValue(ResourceUrun.Parameter3, urunDeger.UrunAdet); return(command.ExecuteNonQuery()); }
public static int UrunGuncelle(EntityUrun urunDeger) { SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceUrun.UpdateUrunSorgu, Baglanti.connection); command.Parameters.AddWithValue(ResourceUrun.IdParameter, urunDeger.UrunId); command.Parameters.AddWithValue(ResourceUrun.AdParam, urunDeger.UrunAd); command.Parameters.AddWithValue(ResourceUrun.FiyatParam, urunDeger.UrunFiyat); command.Parameters.AddWithValue(ResourceUrun.AdetParam, urunDeger.UrunAdet); return(command.ExecuteNonQuery()); }
public static int BLLUrunEkle(EntityUrun m) { if (m.Urunad != "" && m.Urunfiyat != 0 & m.Urunadet != 0) { return(DALUrun.UrunEkle(m)); } else { return(-1); } }
protected void Button1_Click(object sender, EventArgs e) { EntityUrun ent = new EntityUrun(); ent.Urunad = TextBox1.Text; ent.Urunfiyat = Convert.ToDecimal(TextBox2.Text); ent.Urunadet = Convert.ToInt32(TextBox3.Text); BLLUrun.BLLUrunEkle(ent); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Ürün Ekleme İşlemi Yapıldı')", true); Response.Redirect("Urunler.aspx"); }
public static int BLLUrunEkle(EntityUrun p) { if (p.Urunad != "" && p.Urunfiyat != 0 && p.Urunadet != 0 && p.Urunfiyat >= 1) { return(DALUrun.UrunEkle(p)); } else { return(-1); } }
protected void Page_Load(object sender, EventArgs e) { EntityUrun entityUrun = BLLUrun.UrunGetirById(Convert.ToByte(Request.QueryString["id"])); if (Page.IsPostBack == false) { txtUrunId.Text = entityUrun.UrunId.ToString(); txtUrunAd.Text = entityUrun.UrunAd; txtUrunFiyat.Text = entityUrun.UrunFiyat.ToString(); txtUrunAdet.Text = entityUrun.UrunAdet.ToString(); } }
protected void btnKaydet_Click(object sender, EventArgs e) { EntityUrun entityUrun = new EntityUrun(); entityUrun.UrunAd = txtUrunAd.Text; entityUrun.UrunFiyat = Convert.ToDecimal(txtUrunFiyat.Text); entityUrun.UrunAdet = Convert.ToInt32(txtUrunAdet.Text); int sonuc = BLLUrun.UrunEkle(entityUrun); MyPresentationExtensions.ShowErrorMessageOrRedirect(sonuc, ResourceUrun.UrunlerSayfasi, ResourceUrun.UrunEkleError); }
public static int UrunEkle(EntityUrun p) { SqlCommand komut3 = new SqlCommand("insert into TBLURUN(URUNAD,URUNFIYAT,URUNADET) values (@P1,@P2,@P3)", Baglanti.bgl); if (komut3.Connection.State != ConnectionState.Open) { komut3.Connection.Open(); } komut3.Parameters.AddWithValue("@P1", p.Urunad); komut3.Parameters.AddWithValue("@P2", p.Urunfiyat); komut3.Parameters.AddWithValue("@P3", p.Urunadet); return(komut3.ExecuteNonQuery()); }
public static int UrunEkle(EntityUrun urun) { SqlCommand ekle = new SqlCommand("insert into TBLURUN (URUNAD,URUNFIYAT,URUNADET) values (@AD,@FIYAT,@ADET)", Baglanti.baglanti); if (ekle.Connection.State != ConnectionState.Open) { ekle.Connection.Open(); } ekle.Parameters.AddWithValue("@AD", urun.UrunAd); ekle.Parameters.AddWithValue("@FIYAT", urun.UrunFiyat); ekle.Parameters.AddWithValue("@ADET", urun.UrunAdet); return(ekle.ExecuteNonQuery()); }
public static EntityUrun UrunGetirById(int?id) { EntityUrun entityUrun = new EntityUrun(); SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceUrun.SelectUrunByIdSorgu, Baglanti.connection); command.Parameters.AddWithValue(ResourceUrun.IdParameter, id); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { entityUrun.UrunId = Convert.ToInt32(dr[ResourceUrun.URUNID]); entityUrun.UrunAd = dr[ResourceUrun.URUNAD].ToString(); entityUrun.UrunFiyat = Convert.ToDecimal(dr[ResourceUrun.URUNFIYAT]); entityUrun.UrunAdet = Convert.ToInt32(dr[ResourceUrun.URUNADET]); } dr.Close(); return(entityUrun); }
public static List <EntityUrun> UrunListesi() { List <EntityUrun> degerler = new List <EntityUrun>(); SqlCommand komut = new SqlCommand("SELECT *FROM TBLURUN", Baglanti.bgl); if (komut.Connection.State != ConnectionState.Open) { komut.Connection.Open(); } SqlDataReader dr = komut.ExecuteReader(); while (dr.Read()) { EntityUrun ent = new EntityUrun(); ent.Urunid = byte.Parse(dr["URUNID"].ToString()); ent.Urunad = dr["URUNAD"].ToString(); ent.Urunfiyat = decimal.Parse(dr["URUNFIYAT"].ToString()); ent.Urunadet = int.Parse(dr["URUNADET"].ToString()); degerler.Add(ent); } dr.Close(); return(degerler); }