private void btnLogIn_Click(object sender, EventArgs e) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { userAdmin user = admin.Where(x => x.user.ToUpper() == txtusername.Text.ToUpper()).FirstOrDefault(); if (user != null && user.password == txtpassword.Text) { trn_patient_doctor_approve docApprove = cdc.trn_patient_doctor_approves .Where(x => x.tpr_id == _tpr_id) .FirstOrDefault(); docApprove.tpda_status = "CBB"; docApprove.tpda_process_by = user.user; docApprove.tpda_process_date = DateTime.Now; cdc.SubmitChanges(); loginSuccess = true; this.Close(); } else { label3.Visible = true; } } } catch { MessageBox.Show("เกิดความผิดพลาด กรุณาลองอีกครั้ง", "Fail."); } }
public string SaveDraft(int tpr_id, string reason) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { trn_patient_doctor_approve patientDoctorApprove = cdc.trn_patient_doctor_approves .Where(x => x.tpr_id == tpr_id) .FirstOrDefault(); if (patientDoctorApprove != null) { patientDoctorApprove.tpda_reject_reason = reason; cdc.SubmitChanges(); return("Save Draft Completed."); } else { return(""); } } } catch (Exception ex) { return(ex.Message); } }
public bool? CallBackToBook(int tpr_id, string username) { try { DateTime dateNow = DateTime.Now; using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { trn_patient_regi patientRegis = cdc.trn_patient_regis .Where(x => x.tpr_id == tpr_id) .FirstOrDefault(); trn_patient_doctor_approve doctorApprove = patientRegis.trn_patient_doctor_approve; if (doctorApprove.tpda_status == "API") { return null; } doctorApprove.tpda_status = "CBB"; doctorApprove.tpda_process_by = username; doctorApprove.tpda_process_date = dateNow; cdc.SubmitChanges(); return true; } } catch { } return false; }
public string GetReason(int tpr_id) { try { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { trn_patient_doctor_approve patientDoctorApprove = cdc.trn_patient_doctor_approves .Where(x => x.tpr_id == tpr_id) .FirstOrDefault(); if (patientDoctorApprove != null) { return(patientDoctorApprove.tpda_reject_reason); } else { return(""); } } } catch (Exception ex) { return(ex.Message); } }
public bool? SendToDoctorApprove(int tpr_id, string rptCode, string username) { try { DateTime dateNow = DateTime.Now; List<string> bookColorRptCode = new List<string> { "BK306", "BK307" }; List<string> bookRptCode = new List<string> { "BK301", "BK304" }; List<string> bookOnePageRptCode = new List<string> { "BK302", "BK303" }; if (bookColorRptCode.Contains(rptCode) || bookRptCode.Contains(rptCode) || bookOnePageRptCode.Contains(rptCode)) { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { trn_patient_regi patientRegis = cdc.trn_patient_regis .Where(x => x.tpr_id == tpr_id) .FirstOrDefault(); trn_patient_doctor_approve doctorApprove = patientRegis.trn_patient_doctor_approve; if (doctorApprove != null && doctorApprove.tpda_status != "CBB" && doctorApprove.tpda_status != "NAP") { return false; } if (doctorApprove == null) { doctorApprove = new trn_patient_doctor_approve(); doctorApprove.tpr_id = tpr_id; cdc.trn_patient_doctor_approves.InsertOnSubmit(doctorApprove); } doctorApprove.tpda_rpt_code = rptCode; doctorApprove.tpda_status = "WFA"; doctorApprove.tpda_path_image = tpr_id.ToString("0000000000"); doctorApprove.tpda_process_by = username; doctorApprove.tpda_process_date = dateNow; cdc.SubmitChanges(); return true; //old //ReportDocument rpt = GetReportDocumentCls.getRptDoc(rptCode); //if (rpt != null) //{ // GetReportDocumentCls.SetDBLogonForReport(rpt); // rpt.SetParameterValue("@tpr_id", tpr_id); // string pdfPath = HttpContext.Current.Request.MapPath(@".\PdfTemp\"); // string pdfFileName = tpr_id.ToString("0000000000") + DateTime.Now.ToString("ssmmHHyyyyMMdd") + ".pdf"; // rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, pdfPath + pdfFileName); // string BookImgForApprove = GetDBConfigCls.GetConfig("BookImgForApprove"); // Directory.CreateDirectory(BookImgForApprove + tpr_id.ToString("0000000000")); // foreach (var file in Directory.GetFiles(BookImgForApprove + tpr_id.ToString("0000000000"))) // { // File.Delete(file); // } // PdfToJpg(Path.GetFullPath(pdfPath + pdfFileName), BookImgForApprove + tpr_id.ToString("0000000000")); // rpt.Dispose(); // File.Delete(Path.GetFullPath(pdfPath + pdfFileName)); // if (doctorApprove == null) // { // doctorApprove = new trn_patient_doctor_approve(); // doctorApprove.tpr_id = tpr_id; // cdc.trn_patient_doctor_approves.InsertOnSubmit(doctorApprove); // } // doctorApprove.tpda_status = "WFA"; // doctorApprove.tpda_path_image = tpr_id.ToString("0000000000"); // doctorApprove.tpda_process_by = username; // doctorApprove.tpda_process_date = dateNow; // cdc.SubmitChanges(); // if (patientRegis.tpr_req_inorout_doctor == "UT") // { // } // return true; //} } } return null; } catch (Exception ex) { globalCls.MessageError("approve", "approve", ex.Message); return false; } }