public List <ViewCasePool> DoctorCaseData(int uid)
{
try
{
List <ViewCasePool> CpList = new List <ViewCasePool>();
EF_Database ctx = new EF_Database();
int did = (from i in ctx.Doctors where i.UserId == uid select i.DOCTOR_ID).FirstOrDefault();
var res = from i in ctx.CasePools where i.DoctorId == did select i;
foreach (var obj in res)
{
ViewCasePool vcp = new ViewCasePool();
vcp.CaseId = obj.CASE_ID;
vcp.AccepterId = obj.AccepterId.HasValue ? obj.AccepterId.Value.ToString() : "NA";
vcp.DoctorId = obj.DoctorId.HasValue ? obj.DoctorId.Value.ToString() : "NA"; //ternary Operator
vcp.DonorId = obj.DonorId; //modified Code /*.HasValue ? obj.DonorId.Value.ToString() : "NA";*/
vcp.Organs = obj.ORGANS != null ? obj.ORGANS : "NA";
vcp.Status = obj.STATUS;
CpList.Add(vcp);
}
return(CpList);
}
catch (Exception e)
{
throw new Exception("Error");
}
}
public List <ViewCasePool> RetriveCaseData()
{
try
{
List <ViewCasePool> CpList = new List <ViewCasePool>();
EF_Database ctx = new EF_Database();
var res = from i in ctx.CasePools select i;
foreach (var obj in res)
{
ViewCasePool vcp = new ViewCasePool();
vcp.CaseId = obj.CASE_ID;
vcp.AccepterId = obj.AccepterId.HasValue ? obj.AccepterId.Value.ToString() : "NA";
vcp.DoctorId = obj.DoctorId.HasValue ? obj.DoctorId.Value.ToString() : "NA"; //ternary Operator
vcp.DonorId = obj.DonorId; //modified Code /*.HasValue ? obj.DonorId.Value.ToString() : "NA";*/
vcp.Organs = obj.ORGANS != null ? obj.ORGANS : "NA";
vcp.Status = obj.STATUS;
CpList.Add(vcp);
}
return(CpList);
}
catch (Exception e)
{
throw new Exception("Error");
}
}