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