private void GirisButton_Click(object sender, EventArgs e) { try { baglanti.Open(); string sql1 = @"select *from login(:_username,:_password)"; NpgsqlCommand komut = new NpgsqlCommand(sql1, baglanti); komut.Parameters.AddWithValue("_username", kullaniciAdiTextBox.Text); komut.Parameters.AddWithValue("_password", sifreTextBox.Text); int result = (int)komut.ExecuteScalar(); baglanti.Close(); if (result == 1) { satis sts = new satis(); sts.ShowDialog(); } } catch (Exception) { MessageBox.Show("Hatali Giriş"); foreach (Control item in this.Controls) { if (item is TextBox) { item.Text = ""; } } } }
public satisGuncelleFormu(satis gSatis) { InitializeComponent(); comboBox1.SelectedIndex = gSatis.Musteriid; comboBox2.SelectedIndex = gSatis.Personelid; comboBox3.SelectedIndex = gSatis.Urunid; textBox1.Text = gSatis.Adet.ToString(); }
public ActionResult CreateSales(satis newSales) { var salesCustomer = dbstokEntities.musteriler.Where(x => x.MusteriId == newSales.musteriler.MusteriId).FirstOrDefault(); newSales.musteriler = salesCustomer; var salesProduct = dbstokEntities.urunler.Where(x => x.UrunId == newSales.urunler.UrunId).FirstOrDefault(); newSales.urunler = salesProduct; dbstokEntities.satis.Add(newSales); dbstokEntities.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Update(satis sales) { var salesCustomer = dbstokEntities.musteriler.Where(x => x.MusteriId == sales.musteriler.MusteriId).FirstOrDefault(); var salesProduct = dbstokEntities.urunler.Where(x => x.UrunId == sales.urunler.UrunId).FirstOrDefault(); var updateSales = dbstokEntities.satis.Find(sales.SatisId); updateSales.Musteri = salesCustomer.MusteriId; updateSales.Urun = salesProduct.UrunId; updateSales.Fiyat = sales.Fiyat; updateSales.Adet = sales.Adet; dbstokEntities.SaveChanges(); return(RedirectToAction("Index")); }
internal void satisKaydet(satis s) { (new MySqlCommand("INSERT INTO satıs (satisId,personelId,musteriId,tarih,urunId,satisAdet,tutar) VALUES ('" + s.SatisId + "','" + s.PersonelId + "','" + s.MusteriId + "','" + s.Tarih + "','" + s.UrunId + "','" + s.SatisAdet + "','" + s.Tutar + "')", (new dbBaglan()).baglantiGetir())).ExecuteNonQuery(); }
internal void satisGuncelle(satis satis) { (new MySqlCommand("update satisekle set idmusteri='" + satis.Musteriid + "',idpersonelekle='" + satis.Personelid + "',idurun='" + satis.Urunid + "',adet='" + satis.Adet + "' where idsatisekle=" + satis.Satisid, (new dbBaglanti()).baglantiGetir())).ExecuteNonQuery(); }
internal void satisSil(satis satis) { (new MySqlCommand("delete from satisekle where idsatisekle= " + satis.Satisid, (new dbBaglanti()).baglantiGetir())).ExecuteNonQuery(); }
internal void satisKaydet(satis satis) { (new MySqlCommand("insert into satisekle(idmusteri,idpersonelekle,idurun,adet)values('" + satis.Musteriid + "','" + satis.Personelid + "','" + satis.Urunid + "','" + satis.Adet + "')", (new dbBaglanti()).baglantiGetir())).ExecuteNonQuery(); }
public ActionResult addSatis([FromBody] satis satis) { _Apprepo.Add(satis); _Apprepo.SaveAll(); return(Ok(satis)); }