public bool Update(List <LabTesting> labTesting)
{
var repo = RepositoryHelper.GetRepository <ILabTestingRepository>(UnitOfWork);
try
{
var ids = labTesting.Select(x => x.LabTestingId).ToList();
var labtest = repo.GetLabTestingByListId(ids);
foreach (var item in labTesting)
{
var curentLabTest = labtest.SingleOrDefault(x => x.LabTestingId == item.LabTestingId);
curentLabTest.MachineSlot = item.MachineSlot;
curentLabTest.Status = item.Status;
repo.Update(curentLabTest);
}
var result = UnitOfWork.SaveChanges();
if (result.Any())
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public bool DeleteAll(List <LabTestingIndex> labTesting)
{
var repo = RepositoryHelper.GetRepository <ILabTestingIndexRepository>(UnitOfWork);
try
{
var ids = labTesting.Select(x => x.LabtTestingIndexId).ToList();
var labtest = repo.GetLabTestingIndexByListId(ids);
foreach (var item in labTesting)
{
var curentLabTest = labtest.SingleOrDefault(x => x.LabtTestingIndexId == item.LabtTestingIndexId);
curentLabTest.IsDeleted = true;
repo.Delete(curentLabTest);
}
var result = UnitOfWork.SaveChanges();
if (result.Any())
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public bool Update(Patient patientdto)
{
var repo = RepositoryHelper.GetRepository <IPatientRepository>(UnitOfWork);
try
{
var patient = repo.GetSimpleById(patientdto.PatientId);
//var account = patient.Account;
patient.PatientCode = patientdto.PatientCode;
patient.FullName = patientdto.FullName;
patient.Gender = patientdto.Gender;
patient.PhoneNumber = patientdto.PhoneNumber;
patient.HomeAddress = patientdto.HomeAddress;
patient.CompanyAddress = patientdto.CompanyAddress;
patient.AccountId = patientdto.AccountId;
patient.Age = patientdto.Age;
repo.Update(patient);
var result = UnitOfWork.SaveChanges();
if (result.Any())
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public bool Update(Employee employeedto)
{
// int id, string status, string fullname, string gender, DateTime? dateOfBirth, string phone, string address, DateTime? dateStart, string Role
var repo = RepositoryHelper.GetRepository <IEmployeeRepository>(UnitOfWork);
try
{
var employee = repo.GetSimpleById(employeedto.EmployeeId);
var account = employee.Account;
employee.Status = employeedto.Status;
employee.FullName = employeedto.FullName;
employee.Gender = employeedto.Gender;
employee.DateOfBirth = employeedto.DateOfBirth;
employee.PhoneNumber = employeedto.PhoneNumber;
employee.HomeAddress = employeedto.HomeAddress;
employee.StartDate = employeedto.StartDate;
account.Role = employeedto.Account.Role;
employee.AccountId = employee.AccountId;
account.AvatarUrl = employeedto.Account.AvatarUrl;
account.Email = employeedto.Account.Email;
repo.Update(employee);
var result = UnitOfWork.SaveChanges();
if (result.Any())
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public bool AddExportPaper(ExportPaper exportPaper)
{
var exportPaperRepo = RepositoryHelper.GetRepository <IExportPaperRepository>(UnitOfWork);
var exportPaperDetailRepo = RepositoryHelper.GetRepository <IExportPaperDetailRepository>(UnitOfWork);
var supplyRepo = RepositoryHelper.GetRepository <ISupplyRepository>(UnitOfWork);
var allSupply = supplyRepo.GetAll();
using (var transaction = UnitOfWork.BeginTransaction())
{
try
{
var exportPerDto = new ExportPaper();
exportPerDto.CreateDate = DateTime.Now;
exportPerDto.ExportPaperCode = exportPaper.ExportPaperCode;
exportPerDto.Note = exportPaper.Note;
exportPerDto.IsDeleted = false;
exportPerDto.Status = exportPaper.Status;
exportPaperRepo.Create(exportPerDto);
var dbValresults = UnitOfWork.SaveChanges();
if (dbValresults.Any())
{
transaction.Rollback();
return(false);
}
foreach (var item in exportPaper.ExportPaperDetails)
{
var currentSupply = allSupply.SingleOrDefault(x => x.SuppliesId == item.SuppliesId);
currentSupply.Quantity -= item.Quantity;
var exportPaperDetail = new ExportPaperDetail()
{
ExportPaperId = exportPerDto.ExportPaperId,
Quantity = item.Quantity,
Unit = item.Unit,
Note = item.Note,
SuppliesId = item.SuppliesId
};
exportPaperDetailRepo.Create(exportPaperDetail);
}
dbValresults = UnitOfWork.SaveChanges();
if (dbValresults.Any())
{
transaction.Rollback();
return(false);
}
transaction.Commit();
return(true);
}
catch (Exception ex)
{
transaction.Rollback();
return(true);
}
}
}
public bool AddLabTest(LabTest labTest)
{
var repo = RepositoryHelper.GetRepository <ILabTestRepository>(UnitOfWork);
try
{
repo.Create(labTest);
UnitOfWork.SaveChanges();
}
catch (Exception) { return(false); }
return(true);
}
public bool AddSupply(Supply supply)
{
var repo = RepositoryHelper.GetRepository <ISupplyRepository>(UnitOfWork);
//repo.Create(supply);
//var saveResult = UnitOfWork.SaveChanges();
try
{
repo.Create(supply);
UnitOfWork.SaveChanges();
}
catch (Exception) { return(false); }
return(true);
}
public bool Delete(int id)
{
var repo = RepositoryHelper.GetRepository<ISampleGroupRepository>(UnitOfWork);
try
{
var sample = repo.GetById(id);
sample.IsDeleted = true;
repo.Update(sample);
UnitOfWork.SaveChanges();
}
catch (Exception)
{
return false;
}
return true;
}
public bool DeleteFeedback(int id)
{
var repo = RepositoryHelper.GetRepository <IFeedbackRepository>(UnitOfWork);
try
{
var feedback = repo.GetById(id);
feedback.IsDeleted = true;
repo.Update(feedback);
UnitOfWork.SaveChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
public Account checkLogin(string phoneNumber, string password)
{
var repo = RepositoryHelper.GetRepository <IAccountRepository>(this.UnitOfWork);
Account account = repo.GetByPhoneNumberIncludeRoleEmployeePatient(phoneNumber);
if (account != null && account.Password.Trim().Equals(password.Trim()))
{
return(account);
}
return(null);
}/**/
public bool ChangeIsGot(int sampleGettingId)
{
try
{
var sgRepo = RepositoryHelper.GetRepository <ISampleGettingRepository>(UnitOfWork);
var labRepo = RepositoryHelper.GetRepository <ILabTestingRepository>(UnitOfWork);
var sampleGetting = sgRepo.GetFirst(p => p.SampleGettingId == sampleGettingId);
sampleGetting.IsGot = true;
sampleGetting.Status = "NURSEDONE";
sgRepo.Update(sampleGetting);
var labs = labRepo.GetAll().Where(x => x.SampleGettingId == sampleGettingId);
foreach (var lab in labs)
{
lab.Status = "WAITING";
lab.IsDeleted = false;
labRepo.Update(lab);
}
UnitOfWork.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
//get patient
public List <PatientGetByDateTestingDto> GetAllPatientByDateTesting(string search, DateTime date)
{
var appRepo = RepositoryHelper.GetRepository <IAppointmentRepository>(UnitOfWork);
var paRepo = RepositoryHelper.GetRepository <IPatientRepository>(UnitOfWork);
var sgRepo = RepositoryHelper.GetRepository <ISampleGettingRepository>(UnitOfWork);
var spRepo = this.RepositoryHelper.GetRepository <ISampleRepository>(this.UnitOfWork);
var apps = appRepo.GetAll().Where(p => p.IsDeleted != true && p.IsOnline == true);
var pas = paRepo.GetAll().Where(p => p.IsDeleted != true);
var sgs = sgRepo.GetAll().Where(p => p.GettingDate == date && p.IsDeleted != true &&
p.Status != "NURSEDONE" && p.Status != "DOCTORDONE");
var sps = spRepo.GetAll().Where(p => p.IsDeleted != true);
//app + patient (1)
var appPas = pas.Join(apps, p => p.PatientId, c => c.PatientId, (p, c) => new
{
pa = p,
app = c
});
//sample + sampleGetting (2)
var spSgs = sgs.Join(sps, p => p.SampleId, c => c.SampleId, (p, c) => new
{
sg = p,
sp = c
});
var count = 1;
var result = appPas.Join(spSgs, p => p.app.AppointmentId,
c => c.sg.AppointmentId, (p, c) => new PatientGetByDateTestingDto
{
OrderNumber = count++,
PatientName = p.pa.FullName,
PatientID = p.pa.PatientId,
Phone = p.pa.PhoneNumber,
DateOfBirth = p.pa.DateOfBirth != null ? p.pa.DateOfBirth.Value.ToShortDateString() : "",
Address = p.pa.HomeAddress,
//IdentityCardNumber = p.pa.IdentityCardNumber
IsPaid = c.sg.IsPaid
}).GroupBy(a => a.PatientID).Select(g => g.First()).ToList();
result = result.Where(p => p.PatientName.ToString().ToLower().Contains(search.ToLower()) ||
p.Phone.ToString().Contains(search)).ToList();
return(result);
}
//ten ten
public bool ChangeIsPaid(int sampleGettingId)
{
try
{
var sgRepo = RepositoryHelper.GetRepository <ISampleGettingRepository>(UnitOfWork);
var appRepo = RepositoryHelper.GetRepository <IAppointmentRepository>(UnitOfWork);
var sampleGetting = sgRepo.GetFirst(p => p.SampleGettingId == sampleGettingId);
sampleGetting.IsGot = false;
sampleGetting.IsPaid = true;
sampleGetting.Status = "WAITING";
sgRepo.Update(sampleGetting);
var app = appRepo.GetById(sampleGetting.AppointmentId);
app.Status = "RECEPTDONE";
appRepo.Update(app);
UnitOfWork.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
