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