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