public int AddUpdateFormat2Detail(int tID, Format2 det)
{
IMRDataContext context = new IMRDataContext();
PDFDetail pdfDetails = null;
bool addNew = false;
if (context.PDFDetails.Where(fdet => fdet.TreatmentID == tID).Any())
{
pdfDetails = context.PDFDetails.Single(fdet => fdet.TreatmentID == tID);
}
if (pdfDetails == null)
{
addNew = true;
pdfDetails = new PDFDetail();
}
pdfDetails.ClinicalCaseSummary = det.ClinicalCaseSummary;
pdfDetails.DocumentsReviewed = det.DocumentsReviewed;
pdfDetails.HowIMRDetermination = det.HowIMRDetermination;
pdfDetails.IMRIssuesRationales = det.IMRIssuesRationales;
pdfDetails.URDenialDate = det.URDenialDate;
pdfDetails.TreatmentID = tID;
if (addNew)
{
context.PDFDetails.InsertOnSubmit(pdfDetails);
}
context.SubmitChanges();
context.Connection.Close();
context.Dispose();
context = null;
return(0);
}
public void LoadData(int tID)
{
_treatmentID = tID;
DBHelper helper = new DBHelper();
Treatment treat = helper.GetTreatment(_treatmentID);
PDFDetail det = helper.GetPDFDetail(_treatmentID);
if ((treat != null) && (det != null))
{
txtCaseNumber.Text = treat.CaseNumber;
if (det.URDenialDate.HasValue)
{
txtURDenial.Text = det.URDenialDate.Value.ToString("MM/dd/yyyy");
}
if (det.DateAssigned.HasValue)
{
txtDateAssigned.Text = det.DateAssigned.Value.ToString("MM/dd/yyyy");
}
txtState.Text = det.StateofLicensure;
txtCertifications.Text = det.Certifications;
txtHowIMRDetermination.Text = det.HowIMRDetermination;
txtClinicalCaseSummary.Text = det.ClinicalCaseSummary;
txtIMRIssues.Text = det.IMRIssuesRationales;
txtDiagnosis.Text = det.Diagnosis;
txtAge.Text = det.Age.ToString();
txtGender.Text = det.Gender;
}
else
{
MessageBoxEx.Show("Could not load Data");
}
}
public void LoadData(int tID)
{
_treatmentID = tID;
DBHelper helper = new DBHelper();
Treatment treat = helper.GetTreatment(_treatmentID);
PDFDetail det = helper.GetPDFDetail(_treatmentID);
if ((treat != null) && (det != null))
{
txtCaseNumber.Text = treat.CaseNumber;
txtIMRIssues.Text = det.IMRIssuesRationales;
txtIssueAtDispute.Text = det.IssueAtDispute;
txtCaseSummary.Text = det.ClinicalCaseSummary;
txtDiagnosis.Text = det.Diagnosis;
txtDocumentsReviewed.Text = det.DocumentsReviewed;
txtGuidelines.Text = det.TreatmentGuidelines;
txtReviewerQualification.Text = det.ReviewerQualifications;
txtAge.Text = det.Age.ToString();
txtGender.Text = det.Gender;
}
else
{
DevComponents.DotNetBar.MessageBoxEx.Show("Could not load Data");
}
}
public void LoadData(int tID)
{
_treatmentID = tID;
DBHelper helper = new DBHelper();
Treatment treat = helper.GetTreatment(_treatmentID);
PDFDetail det = helper.GetPDFDetail(_treatmentID);
if ((treat != null) && (det != null))
{
txtCaseNumber.Text = treat.CaseNumber;
if (det.URDenialDate.HasValue)
{
txtURDenial.Text = det.URDenialDate.Value.ToString("MM/dd/yyyy");
}
txtHowIMRDetermination.Text = det.HowIMRDetermination;
txtClinicalCaseSummary.Text = det.ClinicalCaseSummary;
txtIMRIssues.Text = det.IMRIssuesRationales;
txtDocumentsReviewed.Text = det.DocumentsReviewed;
}
else
{
MessageBoxEx.Show("Could not load Data");
}
}
public int AddUpdateFormat1Detail(int tID, Format1 det)
{
IMRDataContext context = new IMRDataContext();
PDFDetail pdfDetails = null;
bool addNew = false;
if (context.PDFDetails.Where(fdet => fdet.TreatmentID == tID).Any())
{
pdfDetails = context.PDFDetails.Single(fdet => fdet.TreatmentID == tID);
}
if (pdfDetails == null)
{
addNew = true;
pdfDetails = new PDFDetail();
}
pdfDetails.Age = det.Age;
pdfDetails.Certifications = det.Certifications;
pdfDetails.ClinicalCaseSummary = det.ClinicalCaseSummary;
pdfDetails.DateAssigned = det.DateAssigned;
pdfDetails.Diagnosis = det.Diagnosis;
pdfDetails.Gender = det.Gender;
pdfDetails.HowIMRDetermination = det.HowIMRDetermination;
pdfDetails.IMRIssuesRationales = det.IMRIssuesRationales;
pdfDetails.StateofLicensure = det.StateOfLincesure;
pdfDetails.URDenialDate = det.URDenialDate;
pdfDetails.TreatmentID = tID;
if (addNew)
{
context.PDFDetails.InsertOnSubmit(pdfDetails);
}
context.SubmitChanges();
context.Connection.Close();
context.Dispose();
context = null;
return(0);
}
public int AddUpdateFormat3Detail(int tID, Format3 det)
{
IMRDataContext context = new IMRDataContext();
PDFDetail pdfDetails = null;
bool addNew = false;
if (context.PDFDetails.Where(fdet => fdet.TreatmentID == tID).Any())
{
pdfDetails = context.PDFDetails.Single(fdet => fdet.TreatmentID == tID);
}
if (pdfDetails == null)
{
addNew = true;
pdfDetails = new PDFDetail();
}
pdfDetails.ClinicalCaseSummary = det.CaseSummary;
pdfDetails.Age = det.Age;
pdfDetails.DocumentsReviewed = det.DocumentsReviewed;
pdfDetails.Diagnosis = det.Diagnosis;
pdfDetails.Gender = det.Gender;
pdfDetails.IssueAtDispute = det.IssueAtDispute;
pdfDetails.IMRIssuesRationales = det.Rationales;
pdfDetails.ReviewerQualifications = det.ReviewerQualifications;
pdfDetails.TreatmentGuidelines = det.TreatmentGuidelines;
pdfDetails.TreatmentID = tID;
if (addNew)
{
context.PDFDetails.InsertOnSubmit(pdfDetails);
}
context.SubmitChanges();
context.Connection.Close();
context.Dispose();
context = null;
return(0);
}