public List <PreRegistrationModel> GetList()
{
using (EHMSEntities ent = new EHMSEntities())
{
List <PreRegistrationModel> model = new List <PreRegistrationModel>();
model = AutoMapper.Mapper.Map <IEnumerable <PreRegistration>, IEnumerable <PreRegistrationModel> >(ent.PreRegistrations).Where(x => x.PreregistrationPreferDetailsModel.PreferDate >= DateTime.Today).ToList();
foreach (var item in model)
{
var data = ent.PreRegistrationPreferDetails.Where(x => x.PreRegistrationID == item.PreRegistrationID).FirstOrDefault();
if (data != null)
{
var temp = from C in ent.SetupDepartments where C.DeptID == data.DepartmentID select C.DeptName;
PreRegistrationPreferDetailsModel m = new PreRegistrationPreferDetailsModel()
{
DoctorID = data.DoctorID,
DepartmentID = data.DepartmentID,
PreferDetailsID = data.PreferDetailsID
};
item.PreregistrationPreferDetailsModel = m;
}
}
return(model);
}
}
public ActionResult AddMoreDepartmentDoctors()
{
using (EHMSEntities ent = new EHMSEntities())
{
PreRegistrationPreferDetailsModel models = new PreRegistrationPreferDetailsModel();
return(PartialView("AddMoreDepartmentDoctors", models));
}
}
public PreRegistrationPreferDetailsModel GetListForPrintNext(int id)
{
using (EHMSEntities ent = new EHMSEntities())
{
PreRegistrationPreferDetailsModel models = new PreRegistrationPreferDetailsModel();
models = AutoMapper.Mapper.Map <IEnumerable <PreRegistrationPreferDetail>, IEnumerable <PreRegistrationPreferDetailsModel> >(ent.PreRegistrationPreferDetails).Where(x => x.PreRegistrationID == id).FirstOrDefault();
return(models);
}
}
public List <PreRegistrationModel> GetResult()
{
List <PreRegistrationModel> model = new List <PreRegistrationModel>();
PreRegistrationPreferDetailsModel models = new PreRegistrationPreferDetailsModel();
using (EHMSEntities ent = new EHMSEntities())
{
DateTime today = DateTime.Today;
var result = (from a in ent.PreRegistrations
join b in ent.PreRegistrationPreferDetails
on a.PreRegistrationID equals b.PreRegistrationID
where b.PreferDate.Equals(today) && a.Status == true
select new PreRegistrationModel
{
FirstName = a.FirstName,
MiddleName = a.MiddleName,
LastName = a.LastName,
RegistrationDate = a.RegistrationDate,
Sex = a.Sex,
MobileNumber = a.MobileNumber,
ContactName = a.ContactNumber,
AgeYear = (int)a.AgeYear,
Address = a.Address,
//ZoneId = a.ZoneId,
//DistrictID = a.DistrictID,
//vdcID = a.vdcID,
RegistrationMode = a.RegistrationMode,
DepartMentID = b.DepartmentID,
DoctorID = b.DoctorID,
PreferDate = b.PreferDate,
PreferTime = b.PreferTime,
PrefailID = b.PreferDetailsID,
PreRegistrationID = a.PreRegistrationID,
Email = a.Email
}).GroupBy(x => x.PreRegistrationID).Select(g => g.FirstOrDefault());
foreach (var item in result)
{
model.Add(item);
}
return(model);
}
}
public List <PreRegistrationModel> GetResults()
{
List <PreRegistrationModel> model = new List <PreRegistrationModel>();
PreRegistrationPreferDetailsModel models = new PreRegistrationPreferDetailsModel();
using (EHMSEntities ent = new EHMSEntities())
{
DateTime today = DateTime.Today;
var result = (from a in ent.PreRegistrations
join b in ent.PreRegistrationPreferDetails
on a.PreRegistrationID equals b.PreRegistrationID
join c in ent.SetupDepartments on b.DepartmentID equals c.DeptID
join d in ent.SetupDoctorMasters on b.DoctorID equals d.DoctorID
where b.PreferDate >= (today)
select new PreRegistrationModel
{
FirstName = a.FirstName + " " + (a.MiddleName + " " ?? string.Empty) + a.LastName,
RegistrationDate = a.RegistrationDate,
Sex = a.Sex,
MobileNumber = a.MobileNumber,
AgeYear = (int)a.AgeYear,
Address = a.Address,
RegistrationMode = a.RegistrationMode,
DepartmentName = c.DeptName,
DoctorName = d.FirstName + " " + (d.MiddleName + " " ?? string.Empty) + d.LastName,
PreferDate = b.PreferDate,
PreferTime = b.PreferTime,
PreRegistrationID = a.PreRegistrationID
}).ToList();
foreach (var item in result)
{
model.Add(item);
}
return(model);
}
}
