public IActionResult HastaneListesi() { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); return(Json(dbConnection.Query("SELECT * FROM hastane"))); } }
public IActionResult Sil(ReceteTuru item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); dbConnection.Execute("delete from public.Kategori where Id = @Id ", item); } return(Json(new { basarili = true })); } catch (System.Exception) { return(Json(new { basarisiz = true })); } }
public IActionResult Sil(Musteri item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); dbConnection.Execute("delete from public.musteri where Id = @TcKimlikNo ", item); } return(Json(new { basarili = true })); } catch (System.Exception) { return(Json(new { basarisiz = true })); } }
public IActionResult Sil(DirekSatisIlaclari item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); dbConnection.Execute("delete from public.direksatisilaclari where Id = @Id ", item); } return(Json(new { basarili = true })); } catch (System.Exception) { return(Json(new { basarisiz = true })); } }
public IActionResult listesi() { try { dynamic liste; using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); liste = dbConnection.Query("select s.Id, s.tutar, s.tarih, s.musteriid, m.adi musteriadi from public.satis s join public.musteri m on s.musteriid = m.tckimlikno"); } return(Json(new { basarili = true, liste })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult listesi() { try { dynamic liste; using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); liste = dbConnection.Query("select * from public.Kategori"); } return(Json(new { basarili = true, liste })); } catch (System.Exception) { return(Json(new { basarisiz = true })); } }
public IActionResult listesi() { try { dynamic liste; using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); liste = dbConnection.Query("select dsi.Id, dsi.ilacid, dsi.adet from public.direksatisilaclari dsi join public.ilac i on dsi.ilacid = i.id"); } return(Json(new { basarili = true, liste })); } catch (System.Exception) { return(Json(new { basarisiz = true })); } }
public IActionResult listesi() { try { dynamic liste; using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); liste = dbConnection.Query("select f.Id, f.tutar, f.tarih, f.depoid, d.adi depoadi from public.fatura f join public.depo d on f.depoid = d.id"); } return(Json(new { basarili = true, liste })); } catch (System.Exception) { return(Json(new { basarisiz = true })); } }
public IActionResult listesi() { try { dynamic liste; using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); liste = dbConnection.Query("select d.Id, d.Adi, d.soyadi, d.tahsis, d.hastaneid, h.adi hastaneadi from public.doktor d join public.hastane h on d.hastaneid = h.id"); } return(Json(new { basarili = true, liste })); } catch (System.Exception) { return(Json(new { basarisiz = true })); } }
public IActionResult listesi() { try { dynamic liste; using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); liste = dbConnection.Query(@"select ri.Id, ri.receteid, ri.ilacid, ri.adet, i.adi from public.receteilaclari ri join public.ilac i on ri.ilacid = i.id"); } return(Json(new { basarili = true, liste })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult listesi() { try { dynamic liste; using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); liste = dbConnection.Query(@"select i.Id,i.adi, i.fiyat, i.firma, i.kategoriid,i.faturaid, k.adi kategoriadi,f.tutar faturaid from public.ilac i join public.kategori k on i.kategoriid = k.id join public.fatura f on i.faturaid = f.id"); } return(Json(new { basarili = true, liste })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kontrol(Eczaci item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); item = dbConnection.QueryFirst <Eczaci>("select * from public.eczaci where tc = @tc and sifre = @sifre", item); HttpContext.Session.SetInt32("Id", item.Id); HttpContext.Session.SetString("Adi", item.Adi); } return(RedirectToAction("Index", "Home")); } catch (System.Exception ex) { HttpContext.Session.SetString("LoginError", "true"); return(RedirectToAction("Index")); } }
public IActionResult listesi() { try { dynamic liste; using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); liste = dbConnection.Query(@"select r.Id,r.turid, r.hastaneid, r.doktorid, r.musteriid,r.tutar,r.tarih, rt.adi ReceteTuruadi,d.adi doktorid from public.recete r join public.receteturu rt on r.turid = rt.id join public.hastane h on r.hastaneid = h.id join public.musteri m on r.musteriid = m.tckimlikno join public.doktor d on r.doktorid = d.id"); } return(Json(new { basarili = true, liste })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kaydet(ReceteIlaclari item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); if (item.Id == 0) { dbConnection.Execute("insert into public.ReceteIlaclari (receteid, ilacid, adet) values(@receteid, @ilacid,@adet)", item); } else { dbConnection.Execute("update public.ReceteIlaclari set receteid = @receteid, ilacid = @ilacid, adet=@adet where Id = @Id", item); } } return(Json(new { basarili = true })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kaydet(Ilac item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); if (item.Id == 0) { dbConnection.Execute("insert into public.ilac (adi, kategoriid,faturaid,firma,fiyat ) values(@adi, @kategoriid,@faturaid,@firma,@fiyat)", item); } else { dbConnection.Execute("update public.ilac set adi = @adi, kategoriid = @kategoriid, faturaid=@faturaid,firma = @firma,fiyat=@fiyat where Id = @Id", item); } } return(Json(new { basarili = true })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kaydet(ReceteTuru item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); if (item.Id == 0) { dbConnection.Execute("insert into public.Kategori (adi) values(@adi)", item); } else { dbConnection.Execute("update public.Kategori set adi = @adi where Id = @Id", item); } } return(Json(new { basarili = true })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kaydet(Recete item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); if (item.Id == 0) { dbConnection.Execute("insert into public.recete (turid, hastaneid,doktorid,musteriid,tutar,tarih ) values(@turid, @hastaneid,@doktorid,@musteriid,@tutar,@tarih)", item); } else { dbConnection.Execute("update public.recete set turid = @turid, hastaneid = @hastaneid, doktorid =@doktorid,musteriid = @musteriid,tutar=@tutarid,tarih=@tarihid where Id = @Id", item); } } return(Json(new { basarili = true })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kaydet(Fatura item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); if (item.Id == 0) { dbConnection.Execute("insert into public.fatura (tutar, depoid,tarih ) values(@tutar, @depoid,@tarih)", item); } else { dbConnection.Execute("update public.fatura set tutar = @tutar, tarih = @tarih, depoid=@depoid where Id = @Id", item); } } return(Json(new { basarili = true })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kaydet(Eczane item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); if (item.Id == 0) { dbConnection.Execute("insert into public.eczane (adi, adres,telefon) values(@adi, @adres,@telefon)", item); } else { dbConnection.Execute("update public.eczane set adi = @adi, adres = @adres, telefon=@telefon where Id = @Id", item); } } return(Json(new { basarili = true })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kaydet(Eczaci item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); if (item.Id == 0) { dbConnection.Execute("insert into public.eczaci (adi,soyadi, telefon,sifre,tc,eczaneid) values(@adi,@soyadi, @telefon, @sifre ,@tc,@eczaneid)", item); } else { dbConnection.Execute("update public.eczaci set adi = @adi, soyadi=@soyadi,sifre=@sifre, telefon=@telefon,tc=@tc,eczaneid=@eczaneid where Id = @Id", item); } } return(Json(new { basarili = true })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kaydet(Doktor item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); if (item.Id == 0) { dbConnection.Execute("insert into public.doktor (adi, hastaneid,soyadi,tahsis) values(@adi, @hastaneid,@soyadi,@tahsis)", item); } else { dbConnection.Execute("update public.doktor set adi = @adi, soyadi = @soyadi, hastaneid=@hastaneid,tahsis=@tahsis where Id = @Id", item); } } return(Json(new { basarili = true })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }
public IActionResult Kaydet(Musteri item) { try { using (var dbConnection = DatabaseBaglanti.Connection()) { dbConnection.Open(); if (item.Id == 0) { dbConnection.Execute("insert into public.musteri (adi,soyadi, adres, tckimlikno) values(@adi,@soyadi , @adres, @tckimlikno)", item); } else { dbConnection.Execute("update public.musteri set adi = @adi , tckimlikno=@tckimlikno , adres = @adres , soyadi=@soyadi where Id = @TcKimlikNo", item); } } return(Json(new { basarili = true })); } catch (System.Exception ex) { return(Json(new { basarisiz = true })); } }