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