public JsonResult CreatePoliClinic()
{
ClinicPoliResponse response = new ClinicPoliResponse();
ClinicPoliModel _model = new ClinicPoliModel();
if (Request.Form["ClinicID"] != null)
{
_model.ClinicID = Convert.ToInt64(Request.Form["ClinicID"].ToString());
}
if (Request.Form["Poli"] != null)
{
_model.PoliIDs = JsonConvert.DeserializeObject <List <int> >(Request.Form["Poli"]);
}
if (Session["UserLogon"] != null)
{
_model.Account = (AccountModel)Session["UserLogon"];
}
var request = new ClinicPoliRequest
{
Data = _model
};
new ClinicPoliValidator(_unitOfWork, _context).Validate(request, out response);
return(Json(new { Status = response.Status, Message = response.Message }, JsonRequestBehavior.AllowGet));
}
public ClinicPoliResponse CreateOrEdit(ClinicPoliRequest request)
{
ClinicPoliResponse response = new ClinicPoliResponse();
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var toberemove = _context.PoliClinics.Where(x => x.ClinicID == request.Data.ClinicID);
_context.PoliClinics.RemoveRange(toberemove);
_context.SaveChanges();
//insert new
foreach (int _polid in request.Data.PoliIDs)
{
var clinicPoli = new PoliClinic
{
ClinicID = request.Data.ClinicID,
PoliID = _polid,
RowStatus = 0,
CreatedBy = request.Data.Account.UserCode,
Createddate = DateTime.Now
};
_context.PoliClinics.Add(clinicPoli);
}
int resultAffected = _context.SaveChanges();
transaction.Commit();
response.Status = true;
response.Message = Messages.DataSaved;
}
catch (Exception ex)
{
transaction.Rollback();
response.Status = false;
response.Message = Messages.GeneralError;
ErrorLog(ClinicEnums.Module.MASTER_POLI_CLINIC, ClinicEnums.Action.DELETE.ToString(), request.Data.Account, ex);
}
}
return(response);
}
public ClinicPoliResponse GetListData(ClinicPoliRequest request)
{
var qry = _unitOfWork.PoliClinicRepository.Get(x => x.RowStatus == 0 && x.ClinicID == request.Data.ClinicID);
ClinicPoliModel _model = new ClinicPoliModel();
if (qry.Count > 0)
{
_model.ClinicID = qry.FirstOrDefault().ClinicID;
}
foreach (var item in qry)
{
_model.PoliIDs.Add(item.PoliID);
}
var response = new ClinicPoliResponse
{
Entity = _model
};
return(response);
}
public void Validate(ClinicPoliRequest request, out ClinicPoliResponse response)
{
response = new ClinicPoliResponse();
if (request.Data.ClinicID == 0)
{
errorFields.Add("Clinic");
}
if (request.Data.PoliIDs.Count == 0)
{
errorFields.Add("Poli");
}
if (errorFields.Any())
{
response.Status = false;
response.Message = string.Format(Messages.ValidationErrorFields, String.Join(",", errorFields));
}
if (response.Status)
{
response = new ClinicPoliHandler(_unitOfWork, _context).CreateOrEdit(request);
}
}
public ClinicPoliResponse GetPoliBasedOnOrClinic(ClinicPoliRequest request)
{
var _clinicId = _unitOfWork.ClinicRepository.GetById(request.Data.ClinicID) == null ? 0 : _unitOfWork.ClinicRepository.GetById(request.Data.ClinicID).ID;
List <ClinicPoliModel> lists = new List <ClinicPoliModel>();
dynamic qry = null;
var searchPredicate = PredicateBuilder.New <PoliClinic>(true);
searchPredicate = searchPredicate.And(x => x.ClinicID == _clinicId);
if (!String.IsNullOrEmpty(request.SearchValue) && !String.IsNullOrWhiteSpace(request.SearchValue))
{
searchPredicate = searchPredicate.And(p => p.Poli.Name.Contains(request.SearchValue) || p.Poli.Code.Contains(request.SearchValue));
}
if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
{
if (request.SortColumnDir == "asc")
{
switch (request.SortColumn.ToLower())
{
case "name":
qry = _unitOfWork.PoliClinicRepository.Get(searchPredicate, orderBy: q => q.OrderBy(x => x.Poli.Name));
break;
default:
qry = _unitOfWork.PoliClinicRepository.Get(searchPredicate, orderBy: q => q.OrderBy(x => x.ID));
break;
}
}
else
{
switch (request.SortColumn.ToLower())
{
case "name":
qry = _unitOfWork.PoliClinicRepository.Get(searchPredicate, orderBy: q => q.OrderByDescending(x => x.Poli.Name));
break;
default:
qry = _unitOfWork.PoliClinicRepository.Get(searchPredicate, orderBy: q => q.OrderByDescending(x => x.ID));
break;
}
}
}
else
{
qry = _unitOfWork.PoliClinicRepository.Get(searchPredicate, null);
}
foreach (var item in qry)
{
var prData = new ClinicPoliModel
{
Id = item.ID,
ClinicID = item.ClinicID,
PoliID = item.PoliID,
PoliName = item.Poli.Name,
ClinicName = item.Clinic.Name,
PoliCode = item.Poli.Code,
};
lists.Add(prData);
}
int totalRequest = lists.Count();
var data = lists.Skip(request.Skip).Take(request.PageSize).ToList();
var response = new ClinicPoliResponse
{
Draw = request.Draw,
RecordsFiltered = totalRequest,
RecordsTotal = totalRequest,
Data = data
};
return(response);
}
