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