public static Sampel GetSampel(int Id) { Sampel Sampel = new Sampel(); try { using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { Sampel = (from a in dc.GetDataSampel(Id) select new Sampel { Id = a.Id, PasienId = a.PasienId.Value.ToString(), TanggalAmbilSampel = GetDateStringFromDate(a.Tanggal_ambil_sampel), JenisSpesimen = a.Jenis_spesimen, JenisPemeriksaanLab = a.Jenis_pemeriksaan_lab, TanggalKirimSampel = GetDateStringFromDate(a.Tanggal_kirim_sampel), TanggalKeluarRS = GetDateStringFromDate(a.Tanggal_keluar_rs), Kondisi = a.Kondisi }).SingleOrDefault(); if (Sampel == null) { Sampel = new Sampel(); } } } catch (Exception e) { throw new Exception(e.Message); } return(Sampel); }
public PinereDataModel() { DataAirline = new DataAirline(); Pasien = new Pasien(); KKP = new KKP(); Sampel = new Sampel(); Litbang = new Litbang(); }
public static Boolean SaveDataSampel(PinereDataContext dc, string User, Sampel sm, int PasienId) { try { dc.InsertDataSampel(sm.Id, PasienId, GetDateFromStringDate(sm.TanggalAmbilSampel), sm.JenisSpesimen, sm.JenisPemeriksaanLab, GetDateFromStringDate(sm.TanggalKirimSampel), DateTime.Now, User, GetDateFromStringDate(sm.TanggalKeluarRS), sm.Kondisi); return(true); } catch (Exception e) { throw new Exception(e.Message); } }