public ListObatResponse ListAllObat(PharmacyRequest request)
{
List <FormExamineMedicineDetailModel> details = new List <FormExamineMedicineDetailModel>();
var _get_frmExId = _unitOfWork.FormExamineRepository.Get(x => x.FormMedicalID == request.Data.FormMedicalID).Select(x => x.ID).ToList();
var _hdr = _unitOfWork.FormExamineMedicineRepository.Get(x => _get_frmExId.Contains(x.FormExamineID ?? 0));
List <long> FrmExMedHdrIds = new List <long>();
FrmExMedHdrIds = _hdr.Select(x => x.ID).ToList();
var _detail = _unitOfWork.FormExamineMedicineDetailRepository.Get(x => FrmExMedHdrIds.Contains(x.FormExamineMedicineID ?? 0));
foreach (var item in _detail)
{
var temp = new FormExamineMedicineDetailModel
{
Id = item.ID,
ProductName = item.ProductName,
Qty = item.Qty,
Dosis = item.FormExamineMedicine.Dose,
RemarksUse = item.FormExamineMedicine.RemarkUse
};
details.Add(temp);
}
int totalRequest = details.Count();
var data = details.Skip(request.Skip).Take(request.PageSize).ToList();
var response = new ListObatResponse
{
Draw = request.Draw,
RecordsFiltered = totalRequest,
RecordsTotal = totalRequest,
Data = details,
};
return(response);
}
public PharmacyResponse UpdateStatusObat(PharmacyRequest request)
{
var response = new PharmacyResponse();
using (var transaction = _context.Database.BeginTransaction())
{
try
{
foreach (long _id in request.idSelectedobat)
{
var _existing = _context.FormExamineMedicineDetails.SingleOrDefault(x => x.ID == _id);
if (_existing != null)
{
_existing.Status = StatusAmbilObat.R.ToString();
_existing.ModifiedBy = request.Account.UserName;
_existing.ModifiedDate = DateTime.Now;
_existing.TanggalAmbilObat = DateTime.Now;
_context.SaveChanges();
}
}
transaction.Commit();
response.Status = true;
response.Message = Messages.DataHasBeenUpdated;
}
catch (Exception)
{
transaction.Rollback();
response.Status = false;
response.Message = Messages.GeneralError.ToString();
}
}
return(response);
}
public PharmacyResponse GetListPengambilanObat(PharmacyRequest request)
{
List <PrescriptionModel> lists = new List <PrescriptionModel>();
dynamic qry = null;
var searchPredicate = PredicateBuilder.New <FormExamineMedicineDetail>(true);
searchPredicate = searchPredicate.And(x => x.Status == null);
if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
{
if (request.SortColumnDir == "asc")
{
switch (request.SortColumn.ToLower())
{
case "formmedical":
qry = _unitOfWork.FormExamineMedicineDetailRepository.Get(searchPredicate, orderBy: q => q.OrderBy(x => x.FormExamineMedicine.FormExamine.FormMedicalID));
break;
default:
qry = _unitOfWork.FormExamineMedicineDetailRepository.Get(searchPredicate, orderBy: q => q.OrderBy(x => x.ID));
break;
}
}
else
{
switch (request.SortColumn.ToLower())
{
case "formmedical":
qry = _unitOfWork.FormExamineMedicineDetailRepository.Get(searchPredicate, orderBy: q => q.OrderByDescending(x => x.FormExamineMedicine.FormExamine.FormMedicalID));
break;
default:
qry = _unitOfWork.FormExamineMedicineDetailRepository.Get(searchPredicate, orderBy: q => q.OrderByDescending(x => x.ID));
break;
}
}
}
else
{
qry = _unitOfWork.FormExamineMedicineDetailRepository.Get(searchPredicate, null);
}
foreach (var item in qry)
{
var _ready = Mapper.Map <FormExamineMedicineDetail, PrescriptionModel>(item);
lists.Add(_ready);
}
lists = lists.GroupBy(x => x.FormMedicalID).Select(g => g.First()).ToList();
int totalRequest = lists.Count();
var data = lists.Skip(request.Skip).Take(request.PageSize).ToList();
var response = new PharmacyResponse
{
Draw = request.Draw,
RecordsFiltered = totalRequest,
RecordsTotal = totalRequest,
Data = data
};
return(response);
}
public PharmacyResponse CreateOrEdit(PharmacyRequest request)
{
PharmacyResponse response = new PharmacyResponse();
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var queue = _context.QueuePolis.FirstOrDefault(x => x.FormMedicalID == request.Data.FormMedicalID &&
x.PoliTo == (int)PoliEnum.Farmasi &&
x.RowStatus == 0);
// set as waiting
queue.Status = 1;
_context.SaveChanges();
#region :: INSERT To PRODUCT::
// unit & category ini sementara hardcode dulu, nantinya bakal dipilih dari screen farmasi
var _prdCatIdOral = _unitOfWork.ProductCategoryRepository.Get(x => x.Name.ToLower() == ORAL).FirstOrDefault() == null ? 0 : _unitOfWork.ProductCategoryRepository.Get(x => x.Name.ToLower() == ORAL).FirstOrDefault().ID;
var _prdCatIdRacikan = _unitOfWork.ProductCategoryRepository.Get(x => x.Name.ToLower() == CONCOCTION).FirstOrDefault() == null ? 0 : _unitOfWork.ProductCategoryRepository.Get(x => x.Name.ToLower() == CONCOCTION).FirstOrDefault().ID;
var _prdUnitId = _unitOfWork.ProductUnitRepository.Get(x => x.Name.ToLower() == PIECE).FirstOrDefault() == null ? 0 : _unitOfWork.ProductUnitRepository.Get(x => x.Name.ToLower() == PIECE).FirstOrDefault().ID;
foreach (var tobeInsert in request.Data.Medicines)
{
if (!String.IsNullOrEmpty(tobeInsert.Detail.ProcessType))
{
var entity = new Product
{
ClinicID = request.Account.ClinicID,
Name = tobeInsert.Detail.ProductName,
ProductCategoryID = tobeInsert.Detail.ProcessType.ToLower() == MedicineTypeEnum.REQUEST.ToString().ToLower() ? _prdCatIdOral : _prdCatIdRacikan,
ProductUnitID = _prdUnitId,
RetailPrice = 0,
RowStatus = 0,
CreatedBy = request.Account.UserName,
CreatedDate = DateTime.Now
};
_context.Products.Add(entity);
_context.SaveChanges();
tobeInsert.Detail.ProductID = entity.ID;
}
}
#endregion
#region :: FORM EXAMINE DETAIL::
var _getFrmExId = _unitOfWork.FormExamineRepository.Get(x => x.FormMedicalID == request.Data.FormMedicalID).FirstOrDefault().ID;
var idFormExamineMedicine = _unitOfWork.FormExamineMedicineRepository.Get(x => x.FormExamineID == _getFrmExId).Select(x => x.ID).ToList();
var existingMedDetail = _unitOfWork.FormExamineMedicineDetailRepository.Get(x => idFormExamineMedicine.Contains(x.FormExamineMedicineID ?? 0));
foreach (var tobedelete in existingMedDetail)
{
_context.FormExamineMedicineDetails.Remove(tobedelete);
_context.SaveChanges();
}
foreach (var tobeInsert in request.Data.Medicines)
{
var _idExMed = tobeInsert.Id;
var entity = Mapper.Map <FormExamineMedicineDetailModel, FormExamineMedicineDetail>(tobeInsert.Detail);
entity.FormExamineMedicineID = _idExMed;
entity.CreatedDate = DateTime.Now;
entity.CreatedBy = request.Account.UserName;
_context.FormExamineMedicineDetails.Add(entity);
_context.SaveChanges();
tobeInsert.Detail.Id = entity.ID;
}
#endregion
#region ::INSERT To Product In Gudang::
foreach (var tobeInsert in request.Data.Medicines)
{
var entity = new Klinik.Data.DataRepository.ProductInGudang();
if (!String.IsNullOrEmpty(tobeInsert.Detail.ProcessType))
{
if (tobeInsert.Detail.ProcessType.ToLower() == "racik")
{
entity = new Klinik.Data.DataRepository.ProductInGudang
{
stock = Convert.ToInt32(Math.Round(tobeInsert.Detail.Qty ?? 0)),
ProductId = (Int32)tobeInsert.Detail.Id,
CreatedBy = request.Account.UserName,
CreatedDate = DateTime.Now,
RowStatus = 0
};
}
if (tobeInsert.Detail.ProcessType.ToLower() == "request")
{
entity = new Klinik.Data.DataRepository.ProductInGudang
{
stock = 0,
ProductId = (Int32)tobeInsert.Detail.Id,
CreatedBy = request.Account.UserName,
CreatedDate = DateTime.Now,
RowStatus = 0
};
}
}
else
{
entity = new Klinik.Data.DataRepository.ProductInGudang
{
stock = -Convert.ToInt32(Math.Round(tobeInsert.Detail.Qty ?? 0)),
ProductId = tobeInsert.Detail.ProductID,
CreatedBy = request.Account.UserName,
CreatedDate = DateTime.Now,
RowStatus = 0
};
}
_context.ProductInGudangs.Add(entity);
_context.SaveChanges();
}
#endregion
#region ::INSERT INTO PRODUCT IN GUDANG FOR KOMPONEN::
List <KomponenObatRacikan> CollOfRacikanKomponen = new List <KomponenObatRacikan>();
CollOfRacikanKomponen = JsonConvert.DeserializeObject <List <KomponenObatRacikan> >(request.Data.ObatRacikanKomponens);
foreach (var itemDet in CollOfRacikanKomponen)
{
var _convAmt = Convert.ToDecimal(itemDet.Amount.Replace('.', ','));
var entDetil = new Klinik.Data.DataRepository.ProductInGudang
{
stock = -Convert.ToInt32(Math.Round(_convAmt)),
ProductId = itemDet.Id == null ? 0 : Convert.ToInt32(itemDet.Id),
CreatedBy = request.Account.UserName,
CreatedDate = DateTime.Now,
RowStatus = 0
};
_context.ProductInGudangs.Add(entDetil);
_context.SaveChanges();
}
#endregion
#region ::INSERT TO PR for new Medicine::
var _nullProcess = request.Data.Medicines.Where(x => x.Detail.ProcessType == null);
var newReqMed = request.Data.Medicines.Except(_nullProcess).Where(x => x.Detail.ProcessType.ToLower() == "request");
foreach (var itemPrhdr in newReqMed)
{
var entityPrHdr = new Persistence.PurchaseRequest
{
prnumber = $"PR-{DateTime.Now.ToString("yyyyMMddhhmmss")}",//will be changed with autogenerate PR No
prdate = DateTime.Now,
RowStatus = 0,
CreatedBy = request.Account.UserName,
CreatedDate = DateTime.Now
};
_context.PurchaseRequests.Add(entityPrHdr);
_context.SaveChanges();
var IdPrHdr = entityPrHdr.id;
//insert to PR detail
var entPRDetail = new PurchaseRequestDetail
{
PurchaseRequestId = IdPrHdr,
ProductId = itemPrhdr.Detail.ProductID ?? 0,
namabarang = itemPrhdr.Detail.ProductName,
qty = itemPrhdr.Detail.Qty,
qty_add = itemPrhdr.Detail.Qty,
reason_add = "REQUEST FROM PHARMACY",
CreatedBy = request.Account.UserName,
CreatedDate = DateTime.Now
};
_context.PurchaseRequestDetails.Add(entPRDetail);
_context.SaveChanges();
}
#endregion
transaction.Commit();
response.Status = true;
response.Message = Messages.PrescriptionProcessSuccess;
}
catch (Exception ex)
{
transaction.Rollback();
response.Status = false;
response.Message = Messages.GeneralError;
ErrorLog(ClinicEnums.Module.PHARMACY, Constants.Command.EDIT_FORM_EXAMINE_MEDICINE, request.Account, ex);
}
}
return(response);
}
public PharmacyResponse Validate(PharmacyRequest request)
{
bool isHavePrivilege = true;
PharmacyResponse response = new PharmacyResponse();
try
{
#region VALIDATE is any bigger than stock
foreach (var item in request.Data.Medicines)
{
if (((decimal)item.Detail.Qty > item.Stock) && string.IsNullOrEmpty(item.Detail.ProcessType))
{
response.Status = false;
response.Message = $"Qty order of item {item.Detail.ProductName} is out of stock";
break;
}
}
#endregion
#region VALIDATE for Komponen Racikan
List <KomponenObatRacikan> CollOfRacikanKomponen = new List <KomponenObatRacikan>();
CollOfRacikanKomponen = JsonConvert.DeserializeObject <List <KomponenObatRacikan> >(request.Data.ObatRacikanKomponens);
foreach (var item1 in CollOfRacikanKomponen)
{
var _convStock = Convert.ToDecimal(item1.Stock.Replace('.', ','));
var _convAmt = Convert.ToDecimal(item1.Amount.Replace('.', ','));
if (_convStock < _convAmt)
{
response.Status = false;
response.Message = $"Qty order of item {item1.Name} is out of stock";
break;
}
}
#endregion
#region ::VALIDATE IF Product Name different with resep::
foreach (var item in request.Data.Medicines)
{
if (!item.ProductName.Equals(item.Detail.ProductName) && item.Detail.ProcessType == null)
{
if (item.Detail.Note == null)
{
response.Status = false;
response.Message = $"Please fill reason if any different between prescript from Doctor. Prescript : {item.ProductName} Apoteker : {item.Detail.ProductName}";
break;
}
else if (String.IsNullOrWhiteSpace(item.Detail.Note))
{
response.Status = false;
response.Message = $"Please fill reason if any different between prescript from Doctor. Prescript : {item.ProductName} Apoteker : {item.Detail.ProductName}";
break;
}
}
}
#endregion
isHavePrivilege = IsHaveAuthorization(EDIT_PRIVILEGE_NAME, request.Account.Privileges.PrivilegeIDs);
if (!isHavePrivilege)
{
response.Status = false;
response.Message = Messages.UnauthorizedAccess;
}
}
catch (Exception ex)
{
response.Status = false;
response.Message = ex.Message;
}
if (response.Status)
{
response = new PharmacyHandler(_unitOfWork, _context).CreateOrEdit(request);
}
return(response);
}
