public Satis(TrulyObservableCollection <SatisUrun> c)
{
foreach (SatisUrun x in c)
{
SatilanUrunler.Add(x);
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
SatilanUrunler satilanurunler = await db.SatilanUrunler.FindAsync(id);
db.SatilanUrunler.Remove(satilanurunler);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
// GET: /SatilanUrunler/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SatilanUrunler satilanurunler = await db.SatilanUrunler.FindAsync(id);
if (satilanurunler == null)
{
return(HttpNotFound());
}
return(View(satilanurunler));
}
public async Task <ActionResult> Edit([Bind(Include = "SatilanUrun_id,SatilanUrun_adi,SatanPersonel,UrununGirisTarihi,UrununSatilisTarihi,UrunSatisFiyati,UrunTur_id,UrunStok_id,UrunToplamKar")] SatilanUrunler satilanurunler)
{
if (ModelState.IsValid)
{
db.Entry(satilanurunler).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.UrunTur_id = new SelectList(db.GenelUrunler, "Urun_id", "Urun_adi", satilanurunler.UrunTur_id);
ViewBag.UrunStok_id = new SelectList(db.StoktakiUrunler, "UrunStok_id", "UrunAdi", satilanurunler.UrunStok_id);
ViewBag.SatanPersonel = new SelectList(db.PersonelTable, "Personel_id", "Personel_adi", satilanurunler.SatanPersonel);
return(View(satilanurunler));
}
protected void btn_odeme_Click(object sender, EventArgs e)
{
kullaniciid = Convert.ToInt16(Session["ID"]);
UrunID = Convert.ToInt32(Request.QueryString["urunid"]);
pcompone_1453Entities3 bd = new pcompone_1453Entities3();
pcompone_1453Entities3 hhh = new pcompone_1453Entities3();
var sorgu = from i in bd.Kullanici
where (i.kullanici_id == kullaniciid)
select i;
if (sorgu.Count() != 0)
{
pcompone_1453Entities3 aa = new pcompone_1453Entities3();
SatilanUrunler saturun = new SatilanUrunler();
saturun.urunID = UrunID;
saturun.kullaniciID = kullaniciid;
saturun.datetime = DateTime.Now;
saturun.urunadedi = Convert.ToInt16(Session["adet"]);
saturun.toplamfiyat = Convert.ToInt16(Session["adet"]) * Convert.ToInt16(Session["fiyat"]);
aa.SatilanUrunler.AddObject(saturun);
aa.SaveChanges();
pcompone_1453Entities3 x = new pcompone_1453Entities3();
Urunler urun = (from i in x.Urunler
where (i.urun_id == UrunID)
select i).FirstOrDefault <Urunler>();
int adet = Convert.ToInt16(urun.StokAdedi);
int adetsayisi = adet - Convert.ToInt16(Session["adet"]);
urun.StokAdedi = adetsayisi;
x.SaveChanges();
Response.Redirect("odeme.aspx?urunid=" + UrunID + "");
}
else if (sorgu.Count() == 0)
{
pcompone_1453Entities3 db = new pcompone_1453Entities3();
Repeater1.DataSource = (from i in db.Urunler
where (i.urun_id == UrunID)
select i).ToList <Urunler>();
Repeater1.DataBind();
Response.Write("<script lang='JavaScript'> alert ('Ürünü Satın Alabilmeniz İçin Giriş Yapın veya Üye Olun');</script>");
}
}
// GET: /SatilanUrunler/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SatilanUrunler satilanurunler = await db.SatilanUrunler.FindAsync(id);
if (satilanurunler == null)
{
return(HttpNotFound());
}
ViewBag.UrunTur_id = new SelectList(db.GenelUrunler, "Urun_id", "Urun_adi", satilanurunler.UrunTur_id);
ViewBag.UrunStok_id = new SelectList(db.StoktakiUrunler, "UrunStok_id", "UrunAdi", satilanurunler.UrunStok_id);
ViewBag.SatanPersonel = new SelectList(db.PersonelTable, "Personel_id", "Personel_adi", satilanurunler.SatanPersonel);
return(View(satilanurunler));
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
kullaniciid = Convert.ToInt16(Session["ID"]);
int urunid = Convert.ToInt16(e.CommandArgument);
pcompone_1453Entities3 db = new pcompone_1453Entities3();
//int urunid = Convert.ToInt32(((LinkButton)e.Item.FindControl("lnkislem")).CommandName);
if (e.CommandName.ToString() == "btnislem")
{
SatilanUrunler sat = (from i in db.SatilanUrunler
where (i.urunID == urunid) && (i.kullaniciID == kullaniciid)
select i).FirstOrDefault <SatilanUrunler>();
db.SatilanUrunler.DeleteObject(sat);
db.SaveChanges();
doldur();
//Response.Write("satinalinan.aspx?kullaniciid=" + kullaniciid + "");
}
}
public async Task <ActionResult> Create([Bind(Include = "SatilanUrun_id,SatilanUrun_adi,SatanPersonel,UrununGirisTarihi,UrununSatilisTarihi,UrunSatisFiyati,UrunTur_id,UrunStok_id,UrunToplamKar,SatilanUrunAdet")] SatilanUrunler satilanurunler)
{
if (ModelState.IsValid)
{
if (satilanurunler.SatilanUrunAdet != null)
{
double satilanadet = satilanurunler.SatilanUrunAdet.Value;
var stok = db.StoktakiUrunler.Find(satilanurunler.UrunStok_id);
stok.UrunAdet = stok.UrunAdet - satilanadet;
await db.SaveChangesAsync();
}
satilanurunler.UrununSatilisTarihi = DateTime.Now;
db.SatilanUrunler.Add(satilanurunler);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.UrunTur_id = new SelectList(db.GenelUrunler, "Urun_id", "Urun_adi", satilanurunler.UrunTur_id);
ViewBag.UrunStok_id = new SelectList(db.StoktakiUrunler, "UrunStok_id", "UrunAdi", satilanurunler.UrunStok_id);
ViewBag.SatanPersonel = new SelectList(db.PersonelTable, "Personel_id", "Personel_adi", satilanurunler.SatanPersonel);
return(View(satilanurunler));
}
public void SatilanUrun(Urun urun)
{
SatilanUrunler.Add(urun);
}
