public ActionResult GetResultData(string search, string airline, string nomorPenerbangan, string kotaAsal, string kotaTujuan, string waktuBerangkat, string penumpangSakit) { var dc = new PinereDataContext(PinereConstant.PinereConnectionString); List <SearchResult> ResultList = new List <SearchResult>(); try { if (search == "True") { var Result = (from a in dc.GetDataAirlineList() select a); if (!airline.IsNullOrEmpty()) { Result = Result.Where(o => o.Nama_Airline.Value.ToString() == airline); } if (!nomorPenerbangan.IsNullOrEmpty()) { Result = Result.Where(o => o.Nomor_Penerbangan.Contains(nomorPenerbangan)); } if (!kotaAsal.IsNullOrEmpty()) { Result = Result.Where(o => o.Kota_Asal == kotaAsal); } if (!kotaTujuan.IsNullOrEmpty()) { Result = Result.Where(o => o.Kota_Tujuan == kotaTujuan); } if (!waktuBerangkat.IsNullOrEmpty()) { Result = Result.Where(o => DataRepository.GetDateStringFromDate(o.Waktu_Berangkat) == waktuBerangkat); } if (!penumpangSakit.IsNullOrEmpty()) { Result = Result.Where(o => o.Penumpang_Sakit.Value.ToString() == penumpangSakit); } Result = Result.OrderByDescending(o => o.CreatedDate); ResultList = (from a in Result select new SearchResult { NamaAirline = a.Nama_Airline_Dis, NomorPenerbangan = a.Nomor_Penerbangan, WaktuBerangkat = DataRepository.GetDateStringFromDate(a.Waktu_Berangkat), KotaAsal = a.Kota_Asal_Dis, KotaTujuan = a.Kota_Tujuan_Dis, PenumpangSakit = a.Penumpang_Sakit_Dis, ActionEdit = Url.Action("Edit", new { @DataAirlineId = a.ID }) }).ToList(); } } catch (Exception e) { throw new Exception(e.Message); } return(Json(new { iTotalRecords = ResultList.Count(), iTotalDisplayRecords = ResultList.Count(), aaData = ResultList }, JsonRequestBehavior.AllowGet)); }
public ActionResult Tracking() { ViewBag.Title = "Data Airline History"; string responsibleId = string.Empty; string responsibleName = string.Empty; using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { var resp = dc.GetResponsibleByUserName(User.Identity.Name, "airline").SingleOrDefault(); if (!User.IsInRole("admin")) { if (resp != null) { responsibleId = resp.Id.Value.ToString(); responsibleName = resp.Name; } } } ViewBag.ResponsibleId = responsibleId; ViewBag.ResponsibleName = responsibleName; SearchParameter model = new SearchParameter(); return(View("Tracking", model)); }
public static List <PetugasAirline> GetPetugasAirline(int Id) { List <PetugasAirline> PetugasAirline = new List <PetugasAirline>(); try { using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { PetugasAirline = (from a in dc.GetPetugasAirline(Id) select new PetugasAirline { No = a.NO.Value, Id = a.ID, IdDataAirline = a.Id_Data_Airline.Value.ToString(), Nama = a.Nama, NomorPegawai = a.Nomor_Pegawai, WargaNegara = a.Warga_Negara, Passport = a.Passport, Kelamin = a.Kelamin, }).ToList(); } } catch (Exception e) { throw new Exception(e.Message); } return(PetugasAirline); }
public ActionResult GetResultData() { var dc = new PinereDataContext(PinereConstant.PinereConnectionString); List <SearchResult> ResultList = new List <SearchResult>(); try { var Result = (from a in dc.GetPasienListForLitbang() select a); Result = Result.OrderByDescending(o => o.KKPId); ResultList = (from a in Result select new SearchResult { NamaAirline = a.NamaAirline, NomorPenerbangan = a.NomorPenerbangan, NamaPasien = a.NamaPasien, TanggalLahir = DataRepository.GetDateStringFromDate(a.TanggalLahir), HasilDiagnosa = a.Diagnosa, RujukRS = a.Rujuk_RS_Dis, LitbangFlag = a.Litbang_Flag.ToString(), ActionEdit = Url.Action("Input", new { @KKPId = a.KKPId }) }).ToList(); } catch (Exception e) { throw new Exception(e.Message); } return(Json(new { iTotalRecords = ResultList.Count(), iTotalDisplayRecords = ResultList.Count(), aaData = ResultList }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetResultData() { var dc = new PinereDataContext(PinereConstant.PinereConnectionString); List <SearchResult> ResultList = new List <SearchResult>(); try { var Result = (from a in dc.GetDataAirlineForKKP() select a); Result = Result.OrderByDescending(o => o.CreatedDate); ResultList = (from a in Result select new SearchResult { NamaAirline = a.Nama_Airline_Dis, NomorPenerbangan = a.Nomor_Penerbangan, WaktuBerangkat = DataRepository.GetDateStringFromDate(a.Waktu_Berangkat), KotaAsal = a.Kota_Asal_Dis, KotaTujuan = a.Kota_Tujuan_Dis, PenumpangSakit = a.Penumpang_Sakit_Dis, KKPFlag = a.KKP_Flag.Value.ToString(), ActionEdit = Url.Action("Input", new { @DataAirlineId = a.ID }) }).ToList(); } catch (Exception e) { throw new Exception(e.Message); } return(Json(new { iTotalRecords = ResultList.Count(), iTotalDisplayRecords = ResultList.Count(), aaData = ResultList }, JsonRequestBehavior.AllowGet)); }
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 static Litbang GetLitbang(int Id) { Litbang Litbang = new Litbang(); try { using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { Litbang = (from a in dc.GetDataLitbang(Id) select new Litbang { Id = a.Id, PasienId = a.PasienId.Value.ToString(), TanggalPeriksaLab = GetDateStringFromDate(a.Tanggal_periksa_lab), HasilLab = a.Hasil_lab, Keterangan = a.Keterangan, Attachment = a.Attachment, TanggalTerimaSampel = GetDateStringFromDate(a.Tanggal_terima_sampel) }).SingleOrDefault(); if (Litbang == null) { Litbang = new Litbang(); } } } catch (Exception e) { throw new Exception(e.Message); } return(Litbang); }
public ActionResult Submit(PinereDataModel Model) { string errorMessage = string.Empty; string UserName = User.Identity.Name; try { var dc = new PinereDataContext(PinereConstant.PinereConnectionString); try { dc.Connection.Open(); dc.Transaction = dc.Connection.BeginTransaction(); dc.ObjectTrackingEnabled = true; DataRepository.SaveDataSampel(dc, UserName, Model.Sampel, Model.Pasien.Id); DataRepository.UpdateRSFlag(dc, Model.KKP.Id); dc.Transaction.Commit(); } catch (Exception e) { dc.Transaction.Rollback(); throw new Exception(e.Message); } SendEmail.SendMail("*****@*****.**", "[Pinere] Data Pasien Baru", "Ini adalah system notifikasi dari PINERE System.<br> Silahkan login dan buka di PINERE System.<br><br> Terimakasih<br>PinereSystem."); } catch (Exception e) { return((ActionResult)this.RedirectToAction("Error", "Information", new { @Message = e.Message })); } return((ActionResult)this.RedirectToAction("Submitted", "Information", new { @MainId = "" })); }
public ActionResult Submit(PinereDataModel Model) { string errorMessage = string.Empty; string UserName = User.Identity.Name; string DataAirlineId = string.Empty; string AttachmentPath = string.Empty; string AttachmentDir = string.Empty; string FileName = string.Empty; try { var dc = new PinereDataContext(PinereConstant.PinereConnectionString); try { dc.Connection.Open(); dc.Transaction = dc.Connection.BeginTransaction(); dc.ObjectTrackingEnabled = true; DataRepository.SaveDataAirline(dc, UserName, Model.DataAirline, out DataAirlineId); DataRepository.SavePetugasAirline(dc, int.Parse(DataAirlineId), UserName, Model.DataAirline.PetugasAirlineCollection.PetugasAirline); dc.Transaction.Commit(); AttachmentPath = string.Format("{0}/{1}", PinereConstant.AttachmentUrl, DataAirlineId); AttachmentDir = Server.MapPath(AttachmentPath); if (!Directory.Exists(AttachmentDir)) { Directory.CreateDirectory(AttachmentDir); } foreach (string file in Request.Files) { HttpPostedFileBase hpf = Request.Files[file] as HttpPostedFileBase; if (hpf.ContentLength == 0) { continue; } FileName = Path.GetFileName(hpf.FileName); AttachmentDir = AttachmentDir + "\\" + FileName; hpf.SaveAs(AttachmentDir); } } catch (Exception e) { dc.Transaction.Rollback(); throw new Exception(e.Message); } if (Model.DataAirline.PenumpangSakit == "1") { SendEmail.SendMail("*****@*****.**", "[Pinere] Data Airline Baru", "Ini adalah system notifikasi dari PINERE System.<br> Silahkan login dan buka di PINERE System.<br><br> Terimakasih<br>PinereSystem."); } } catch (Exception e) { return((ActionResult)this.RedirectToAction("Error", "Information", new { @Message = e.Message })); } return((ActionResult)this.RedirectToAction("Submitted", "Information", new { @MainId = DataAirlineId })); }
public ActionResult GetResultDataPasien(string search, string airline, string nomorPenerbangan, string namaPasien, string tanggalLahir, string rujukRS) { var dc = new PinereDataContext(PinereConstant.PinereConnectionString); List <SearchResult> ResultList = new List <SearchResult>(); try { if (search == "True") { var Result = (from a in dc.GetPasienList() select a); if (!airline.IsNullOrEmpty()) { Result = Result.Where(o => o.AirlineId.Value.ToString() == airline); } if (!nomorPenerbangan.IsNullOrEmpty()) { Result = Result.Where(o => o.NomorPenerbangan.Contains(nomorPenerbangan)); } if (!namaPasien.IsNullOrEmpty()) { Result = Result.Where(o => o.NamaPasien.Contains(namaPasien)); } if (!tanggalLahir.IsNullOrEmpty()) { Result = Result.Where(o => DataRepository.GetDateStringFromDate(o.TanggalLahir) == tanggalLahir); } if (!rujukRS.IsNullOrEmpty()) { Result = Result.Where(o => o.Rujuk_RS.ToString() == rujukRS); } Result = Result.OrderByDescending(o => o.KKPId); ResultList = (from a in Result select new SearchResult { NamaAirline = a.NamaAirline, NomorPenerbangan = a.NomorPenerbangan, NamaPasien = a.NamaPasien, TanggalLahir = DataRepository.GetDateStringFromDate(a.TanggalLahir), HasilDiagnosa = a.Diagnosa, RujukRS = a.Rujuk_RS_Dis, ActionEdit = Url.Action("Edit", new { @KKPId = a.KKPId }) }).ToList(); } } catch (Exception e) { throw new Exception(e.Message); } return(Json(new { iTotalRecords = ResultList.Count(), iTotalDisplayRecords = ResultList.Count(), aaData = ResultList }, JsonRequestBehavior.AllowGet)); }
public static Boolean SaveDataLitbang(PinereDataContext dc, string User, Litbang lb, int PasienId) { try { dc.InsertDataLitbang(lb.Id, PasienId, GetDateFromStringDate(lb.TanggalPeriksaLab), lb.HasilLab, lb.Keterangan, lb.Attachment, DateTime.Now, User, GetDateFromStringDate(lb.TanggalTerimaSampel)); return(true); } catch (Exception e) { throw new Exception(e.Message); } }
public static Boolean UpdateKKPFlag(PinereDataContext dc, int DataAirlineId) { try { dc.UpdateDataAirlineForKKP(DataAirlineId); return(true); } catch (Exception e) { throw new Exception(e.Message); } }
public static Boolean UpdateRSFlag(PinereDataContext dc, int KKPId) { try { dc.UpdateRSFlag(KKPId); return(true); } catch (Exception e) { throw new Exception(e.Message); } }
public static Boolean UpdateLitbangFlag(PinereDataContext dc, int SampelId) { try { dc.UpdateLitbangFlag(SampelId); return(true); } catch (Exception e) { throw new Exception(e.Message); } }
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); } }
public ActionResult GetResultData() { string responsibleId = string.Empty; string responsibleName = string.Empty; using (var dca = new PinereDataContext(PinereConstant.PinereConnectionString)) { var resp = dca.GetResponsibleByUserName(User.Identity.Name, "rs").SingleOrDefault(); if (!User.IsInRole("admin")) { if (resp != null) { responsibleId = resp.Id.Value.ToString(); responsibleName = resp.Name; } } } var dc = new PinereDataContext(PinereConstant.PinereConnectionString); List <SearchResult> ResultList = new List <SearchResult>(); try { var Result = (from a in dc.GetPasienListForRS(int.Parse(responsibleId)) select a); Result = Result.OrderByDescending(o => o.KKPId); ResultList = (from a in Result select new SearchResult { NamaAirline = a.NamaAirline, NomorPenerbangan = a.NomorPenerbangan, NamaPasien = a.NamaPasien, TanggalLahir = DataRepository.GetDateStringFromDate(a.TanggalLahir), HasilDiagnosa = a.Diagnosa, RujukRS = a.Rujuk_RS_Dis, RSFlag = a.RS_Flag.ToString(), NamaRS = a.NamaRS, ActionEdit = Url.Action("Input", new { @KKPId = a.KKPId }) }).ToList(); } catch (Exception e) { throw new Exception(e.Message); } return(Json(new { iTotalRecords = ResultList.Count(), iTotalDisplayRecords = ResultList.Count(), aaData = ResultList }, JsonRequestBehavior.AllowGet)); }
public ActionResult Submit(PinereDataModel Model) { string errorMessage = string.Empty; string UserName = User.Identity.Name; string PasienId = string.Empty; string DataAirlineId = Model.Pasien.DataAirlineId; try { var dc = new PinereDataContext(PinereConstant.PinereConnectionString); try { dc.Connection.Open(); dc.Transaction = dc.Connection.BeginTransaction(); dc.ObjectTrackingEnabled = true; DataRepository.SavePasien(dc, UserName, int.Parse(Model.Pasien.DataAirlineId), Model.Pasien, out PasienId); DataRepository.SaveDataKKP(dc, UserName, Model.KKP, int.Parse(PasienId)); DataRepository.UpdateKKPFlag(dc, int.Parse(DataAirlineId)); dc.Transaction.Commit(); } catch (Exception e) { dc.Transaction.Rollback(); throw new Exception(e.Message); } if (Model.KKP.RujukRS == "1" && (Model.KKP.HasilDiagnosa == "01EBL" || Model.KKP.HasilDiagnosa == "02MRS")) { string email = string.Empty; using (var dca = new PinereDataContext(PinereConstant.PinereConnectionString)) { var resp = dca.GetEmailByNameAndResp(User.Identity.Name, Model.KKP.IdRS, "rs").SingleOrDefault(); if (resp != null) { email = resp.Email; } } if (!email.IsNullOrEmpty()) { SendEmail.SendMail(email, "[Pinere] Data Pasien Baru", "Ini adalah system notifikasi dari PINERE System.<br> Silahkan login dan buka di PINERE System.<br><br> Terimakasih<br>PinereSystem."); } } } catch (Exception e) { return((ActionResult)this.RedirectToAction("Error", "Information", new { @Message = e.Message })); } return((ActionResult)this.RedirectToAction("SubmitKKP", "Information", new { @MainId = DataAirlineId })); }
public static Boolean SaveDataKKP(PinereDataContext dc, string User, KKP kp, int PasienId) { try { dc.InsertKKP(kp.Id, PasienId, decimal.Parse(kp.Suhu), decimal.Parse(kp.TekananDarah1), decimal.Parse(kp.TekananDarah2), int.Parse(kp.Pernapasan), int.Parse(kp.Nadi), kp.TandaGejala, kp.VisitLiberia, kp.VisitGuinea, kp.VisitSierra, kp.VisitMali, kp.VisitKongo, kp.VisitPerancis, kp.VisitItalia, kp.VisitJordania, kp.VisitQatar, kp.VisitArab, kp.VisitTunisia, kp.VisitInggris, kp.VisitUEA, kp.VisitOther, kp.VisitOtherText, GetDateFromStringDate(kp.DurasiStart), GetDateFromStringDate(kp.DurasiEnd), kp.TujuanPerjalanan, kp.TujuanPerjalananOther, kp.RiwayatPaparan, kp.HasilDiagnosa, kp.HasilDiagnosaOther, kp.RujukRS, kp.IdRS, kp.SuratRujukan, kp.TingkatRisiko, kp.PemeriksaanFisik, kp.TindakanMedis, kp.PemeriksaanLab, kp.HasilLab, kp.Pengobatan, kp.KriteriaResiko, kp.TindakanResiko); return(true); } catch (Exception e) { throw new Exception(e.Message); } }
public static Boolean SavePasien(PinereDataContext dc, string User, int DataAirlineId, Pasien ps, out string PasienId) { PasienId = string.Empty; try { var Pasien = (from a in dc.InsertPasien(ps.Id, DataAirlineId, ps.Nama, GetDateFromStringDate(ps.TanggalLahir), ps.Kelamin, ps.Pekerjaan, ps.Passport, ps.KTP, ps.Alamat, ps.NamaAirline, ps.NomorPenerbangan, ps.NomorTelpon, DateTime.Now, User) select a).SingleOrDefault(); PasienId = Pasien.PasienId.ToString(); return(true); } catch (Exception e) { throw new Exception(e.Message); } }
public static Boolean SaveDataAirline(PinereDataContext dc, string User, DataAirline ai, out string DataAirlineId) { DataAirlineId = string.Empty; try { var DataAirline = (from a in dc.InsertDataAirline(ai.Id, int.Parse(ai.NamaAirline), ai.NomorPenerbangan, GetDateFromStringDate(ai.WaktuBerangkat), ai.KotaAsal, ai.KotaTujuan, int.Parse(ai.JumlahPenumpang), int.Parse(ai.PenumpangSakit), ai.FormGendec, DateTime.Now, User, ai.NamaPetugas, ai.NomorPetugas, int.Parse(ai.JumlahSakit)) select a).SingleOrDefault(); DataAirlineId = DataAirline.DataAirlineId.ToString(); return(true); } catch (Exception e) { throw new Exception(e.Message); } }
public static Boolean SavePetugasAirline(PinereDataContext dc, int DataAirlineId, string User, PetugasAirline[] pa) { try { dc.DeletePetugasAirline(DataAirlineId); for (int i = 0; i < pa.Count(); i++) { dc.InsertPetugasAirline(pa[i].Id, DataAirlineId, pa[i].Nama, pa[i].NomorPegawai, pa[i].WargaNegara, pa[i].Passport, pa[i].Kelamin, DateTime.Now, User); } return(true); } catch (Exception e) { throw new Exception(e.Message); } }
public static DataAirline GetDataAirline(int Id) { DataAirline DataAirline = new DataAirline(); try { using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { DataAirline = (from a in dc.GetDataAirline(Id) select new DataAirline { Id = a.ID, NamaAirline = a.Nama_Airline.Value.ToString(), NamaAirlineDis = a.Nama_Airline_Dis, NomorPenerbangan = a.Nomor_Penerbangan, WaktuBerangkat = GetDateStringFromDate(a.Waktu_Berangkat), KotaAsal = a.Kota_Asal, KotaAsalDis = a.Kota_Asal_Dis, KotaTujuan = a.Kota_Tujuan, KotaTujuanDis = a.Kota_Tujuan_Dis, JumlahPenumpang = a.Jumlah_Penumpang.Value.ToString(), PenumpangSakit = a.Penumpang_Sakit.Value.ToString(), PenumpangSakitDis = a.Penumpang_Sakit_Dis, FormGendec = a.Form_Gendec, CreatedBy = a.CreatedBy, CreatedDate = GetDateStringFromDate(a.CreatedDate), UpdatedBy = a.UpdatedBy, UpdatedDate = GetDateStringFromDate(a.UpdatedDate), NamaPetugas = a.Nama_Petugas, NomorPetugas = a.Nomor_Petugas, JumlahSakit = a.Jumlah_Sakit.Value.ToString() }).SingleOrDefault(); if (DataAirline == null) { DataAirline = new DataAirline(); } } } catch (Exception e) { throw new Exception(e.Message); } return(DataAirline); }
protected void Application_PostAuthenticateRequest(Object sender, EventArgs e) { if (FormsAuthentication.CookiesSupported == true) { if (Request.Cookies[FormsAuthentication.FormsCookieName] != null) { try { string username = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name; string roles = string.Empty; using (PinereDataContext entities = new PinereDataContext(PinereConstant.PinereConnectionString)) { //User user = entities.tbl_users.SingleOrDefault(u => u.username == username); tbl_user tbl_user = entities.tbl_users.SingleOrDefault(u => u.username == username); User user = null; if (tbl_user != null) { user = new Models.User { UserId = tbl_user.user_id, Username = tbl_user.username, Role = tbl_user.role, Password = tbl_user.password, LongName = tbl_user.long_name, Email = tbl_user.email }; } else { user = new User(); } roles = user.Role; } HttpContext.Current.User = new System.Security.Principal.GenericPrincipal( new System.Security.Principal.GenericIdentity(username, "Forms"), roles.Split(';')); } catch (Exception) { //somehting went wrong } } } }
public ActionResult Login(User model, string returnUrl) { if (ModelState.IsValid) { using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { string username = model.Username; string password = model.Password; bool userVaid = dc.tbl_users.Any(user => user.username == username && user.password == password); if (userVaid) { FormsAuthentication.SetAuthCookie(username, false); //if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\")) //{ // return Redirect(returnUrl); //} //else //{ var role = (from a in dc.tbl_users where a.username == username && a.password == password select a.role).SingleOrDefault(); if (role == "rs") { return(RedirectToAction("Index", "RS")); } else { return(RedirectToAction("Index", "Home")); } //} } else { ModelState.AddModelError("", "Username dan password tidak cocok, silahkan ulangi lagi."); } } } return(View(model)); }
public static string GetTindakanBasedOnResiko(string Category, string Resiko) { string tindakan = string.Empty; try { using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { var res = dc.GetTindakanBasedOnResiko(Category, Resiko).SingleOrDefault(); if (res != null) { tindakan = res.tindakan; } } return(tindakan); } catch (Exception e) { throw new Exception(e.Message); } }
public static int GetTotalDataForLitbang() { int total = 0; try { using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { var totalQ = dc.GetTotalDataPasienForLitbang().SingleOrDefault(); if (totalQ != null) { total = totalQ.Total.Value; } } return(total); } catch (Exception e) { throw new Exception(e.Message); } }
public ActionResult Index() { string responsibleId = string.Empty; string responsibleName = string.Empty; using (var dca = new PinereDataContext(PinereConstant.PinereConnectionString)) { var resp = dca.GetResponsibleByUserName(User.Identity.Name, "rs").SingleOrDefault(); if (!User.IsInRole("admin")) { if (resp != null) { responsibleId = resp.Id.Value.ToString(); responsibleName = resp.Name; } } } ViewBag.RSData = DataRepository.GetTotalDataForRS(int.Parse(responsibleId)); return(View()); }
public ActionResult Input(int KKPId) { @ViewBag.Title = "Input Data Pasien RS"; PinereDataModel model = this.GetPinnedModel <PinereDataModel>(true); model = new PinereDataModel(); try { string responsibleId = string.Empty; string responsibleName = string.Empty; using (var dca = new PinereDataContext(PinereConstant.PinereConnectionString)) { var resp = dca.GetResponsibleByUserName(User.Identity.Name, "rs").SingleOrDefault(); if (!User.IsInRole("admin")) { if (resp != null) { responsibleId = resp.Id.Value.ToString(); responsibleName = resp.Name; } } } ViewBag.RSData = DataRepository.GetTotalDataForRS(int.Parse(responsibleId)); model.KKP = DataRepository.GetDataKKP(KKPId); model.Pasien = DataRepository.GetPasien(int.Parse(model.KKP.PasienId)); model.DataAirline = DataRepository.GetDataAirline(int.Parse(model.Pasien.DataAirlineId)); model.Sampel = DataRepository.GetSampel(int.Parse(model.KKP.PasienId)); model.Litbang = DataRepository.GetLitbang(int.Parse(model.KKP.PasienId)); } catch (Exception e) { throw new Exception(e.Message); } return(View("Input", model)); }
public static Boolean IsAuthorizedUser(string UserId, string Password) { string errorMessage = string.Empty; Boolean isAuthorized = false; try { using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { int isAuthorizedTemp = (from a in dc.IsAuthorizedUser(UserId, Password) select a.IsAuthorized.Value).SingleOrDefault(); if (isAuthorizedTemp == 1) { isAuthorized = true; } return(isAuthorized); } } catch (Exception e) { return(isAuthorized); } }
public static List <RS> GetRS() { List <RS> RSList = new List <RS>(); try { using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString)) { RSList = (from a in dc.GetRS() select new RS { Id = a.Id.ToString(), Nama = a.Nama, Alamat = a.Alamat }).ToList(); } } catch (Exception e) { throw new Exception(e.Message); } return(RSList); }