public BaseResponse <VisitDocRecords> SaveVisitDocRecData(VisitDocRecords request)
{
var response = new BaseResponse <VisitDocRecords>();
//List<LTC_VISITPRESCRIPTION> regQueData = unitOfWork.GetRepository<LTC_VISITPRESCRIPTION>().dbSet.Where(m => m.SEQNO == request.SeqNo).ToList();
//regQueData.ForEach(p => unitOfWork.GetRepository<LTC_VISITPRESCRIPTION>().Delete(p));
Mapper.CreateMap <VisitPrescription, LTC_VISITPRESCRIPTION>();
Mapper.CreateMap <LTC_VISITPRESCRIPTION, VisitPrescription>();
var cm = Mapper.CreateMap <VisitDocRecords, LTC_VISITDOCRECORDS>();
Mapper.CreateMap <LTC_VISITDOCRECORDS, VisitDocRecords>();
var reqQue = unitOfWork.GetRepository <LTC_VISITDOCRECORDS>().dbSet.Where(m => m.SEQNO == request.SeqNo).FirstOrDefault();
if (reqQue == null)
{
reqQue = Mapper.Map <LTC_VISITDOCRECORDS>(request);
unitOfWork.GetRepository <LTC_VISITDOCRECORDS>().Insert(reqQue);
}
else
{
Mapper.Map(request, reqQue);
unitOfWork.GetRepository <LTC_VISITDOCRECORDS>().Update(reqQue);
}
unitOfWork.Save();
Mapper.Map(reqQue, request);
response.Data = request;
return(response);
}
public IHttpActionResult Post(VisitDocRecords baseRequest)
{
baseRequest.OrgId = SecurityHelper.CurrentPrincipal.OrgId;
var response = service.SaveVisitDocRecData(baseRequest);
return(Ok(response));
}
public BaseResponse <IList <VisitDocRecords> > QueryVisitDocRecData(BaseRequest <VisitDocRecordsFilter> request)
{
var response = new BaseResponse <IList <VisitDocRecords> >();
var q = from vr in unitOfWork.GetRepository <LTC_VISITDOCRECORDS>().dbSet
join e1 in unitOfWork.GetRepository <LTC_EMPFILE>().dbSet on vr.RECORDBY equals e1.EMPNO into vr_e1
from vr_emp1 in vr_e1.DefaultIfEmpty()
join e2 in unitOfWork.GetRepository <LTC_VISITHOSPITAL>().dbSet on vr.VISITHOSP equals e2.HOSPNO into vr_e2
from vr_emp2 in vr_e2.DefaultIfEmpty()
join e3 in unitOfWork.GetRepository <LTC_VISITDEPT>().dbSet on vr.VISITDEPT equals e3.DEPTNO into vr_e3
from vr_emp3 in vr_e3.DefaultIfEmpty()
join e4 in unitOfWork.GetRepository <LTC_VISITDOCTOR>().dbSet on vr.VISITDOCTOR equals e4.DOCNO into vr_e4
from vr_emp4 in vr_e4.DefaultIfEmpty()
select new
{
visitDocRecords = vr,
RecordNameBy = vr_emp1.EMPNAME,
VisitHospName = vr_emp2.HOSPNAME,
VisitDeptName = vr_emp3.DEPTNAME,
VisitDoctorName = vr_emp4.DOCNAME
};
q = q.Where(m => m.visitDocRecords.FEENO == request.Data.FeeNo);
q = q.OrderByDescending(m => m.visitDocRecords.SEQNO);
response.RecordsCount = q.Count();
Action <IList> mapperResponse = (IList list) =>
{
response.Data = new List <VisitDocRecords>();
foreach (dynamic item in list)
{
VisitDocRecords newItem = Mapper.DynamicMap <VisitDocRecords>(item.visitDocRecords);
newItem.RecordNameBy = item.RecordNameBy;
newItem.VisitHospName = item.VisitHospName;
newItem.VisitDeptName = item.VisitDeptName;
newItem.VisitDoctorName = item.VisitDoctorName;
response.Data.Add(newItem);
}
};
if (request != null && request.PageSize > 0)
{
var list = q.Skip((request.CurrentPage - 1) * request.PageSize).Take(request.PageSize).ToList();
response.PagesCount = GetPagesCount(request.PageSize, response.RecordsCount);
mapperResponse(list);
}
else
{
var list = q.ToList();
mapperResponse(list);
}
return(response);
// var response = base.Query<LTC_VISITDOCRECORDS, VisitDocRecords>(request, (q) =>
//{
// q = q.Where(m => m.FEENO == request.Data.FeeNo);
// q = q.OrderByDescending(m => m.SEQNO);
// return q;
//});
// return response;
}
