public void BindRelevantHistory()
{
using (ComplaintsTabLinq.ComplaintsTabDataContext db = new ComplaintsTabLinq.ComplaintsTabDataContext())
{
var obj = db.TbL_Complaints_Relevants.Where(i => i.Cmpid == comid).SingleOrDefault();
if (obj != null)
{
txtRelevantHistory.Text = obj.RelevantArea.ToString();
hfd_relev.Value = obj.RelevantHistoryID.ToString();
}
}
}
public void BindComplaintSummary()
{
using (ComplaintsTabLinq.ComplaintsTabDataContext db = new ComplaintsTabLinq.ComplaintsTabDataContext())
{
var obj = db.TbL_Complaints_Summaries.Where(i => i.Cmpid ==Convert.ToInt16( comid)).SingleOrDefault();
if (obj != null)
{
btndocs.Visible = true;
txtcomplaint.Text = obj.SummaryArea.ToString();
hfd_sumcomp.Value = obj.SummaryComplaintID.ToString();
}
}
}
public void BindinvestigativeViolations()
{
using (ComplaintsTabLinq.ComplaintsTabDataContext db = new ComplaintsTabLinq.ComplaintsTabDataContext())
{
var obj = db.TbL_Complaints_Conclusions.Where(i => i.Cmpid == Convert.ToInt16(comid)).SingleOrDefault();
if (obj != null)
{
txtinvconclusion.Text = obj.ConclusionArea.ToString();
hfd_concl.Value = obj.ConclusionID.ToString();
ddlVoilations.SelectedValue = obj.ConclusionViolationID;
}
}
}
public void Bindinvestigations()
{
using (ComplaintsTabLinq.ComplaintsTabDataContext db = new ComplaintsTabLinq.ComplaintsTabDataContext())
{
var obj = db.TbL_Complaints_Investigatiors.Where(i => i.Cmp_Id ==Convert.ToInt16( comid)).SingleOrDefault();
if (obj != null)
{
txtinvestigation.Text = obj.InvestigationComments.ToString();
hfd_invid.Value = obj.Cmp_Investigation_Id.ToString();
if(obj.IsDrugDivisionChart.ToString()=="True")
{
chkDrugDiversion.Checked = true;
}
else
{
chkDrugDiversion.Checked = false;
}
if (obj.IsPrescriptionProfileChart.ToString() == "True")
{
chkPriscriptionprofile.Checked = true;
}
else
{
chkPriscriptionprofile.Checked = false;
}
}
}
}