public bool AddNewReservation(Reservasion _reservation)
{
try
{
TRANVisit tr = new TRANVisit();
tr.PatientID = _reservation.PatientID;
tr.PhysicianID = _reservation.PhysicianID;
tr.VisitTypeID = _reservation.VisitTypeID;
tr.VisitDate = _reservation.VisitDate;
tr.TimeFrom = _reservation.TimeFrom;
tr.TimeTo = _reservation.TimeTo;
tr.VisitsCount = _reservation.VisitsCount;
tr.VisitPrice = _reservation.VisitPrice;
tr.PhysicianSalary = _reservation.PhysicianSalary;
tr.Paiedprice = _reservation.PaiedPrice;
tr.RestPrice = _reservation.RestPrice;
tr.TotalVisitPrice = _reservation.TotalVisitPrice;
tr.Notes = _reservation.Notes;
_contextDatabase.TRANVisits.Add(tr);
_contextDatabase.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool EditReservation(Reservasion _reservation)
{
try
{
TRANVisit tr = _contextDatabase.TRANVisits.Where(a => a.VisitID == _reservation.VisitID).SingleOrDefault();
tr.PatientID = _reservation.PatientID;
tr.PhysicianID = _reservation.PhysicianID;
tr.VisitTypeID = _reservation.VisitTypeID;
tr.VisitDate = _reservation.VisitDate;
tr.TimeFrom = _reservation.TimeFrom;
tr.TimeTo = _reservation.TimeTo;
tr.VisitsCount = _reservation.VisitsCount;
tr.VisitPrice = _reservation.VisitPrice;
tr.PhysicianSalary = _reservation.PhysicianSalary;
tr.Paiedprice = _reservation.PaiedPrice;
tr.RestPrice = _reservation.RestPrice;
tr.TotalVisitPrice = _reservation.TotalVisitPrice;
tr.Notes = _reservation.Notes;
_contextDatabase.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public Reservasion GetReservationByVisitID(int _visitID)
{
try
{
TRANVisit _tranVisit = _contextDatabase.TRANVisits.Where(a => a.VisitID == _visitID).SingleOrDefault();
this.VisitID = _tranVisit.VisitID;
this.PatientID = _tranVisit.PatientID;
this.PhysicianID = _tranVisit.PhysicianID;
this.PhysicianSalary = _tranVisit.PhysicianSalary;
this.VisitTypeID = _tranVisit.VisitTypeID;
this.VisitDate = _tranVisit.VisitDate;
this.VisitPrice = _tranVisit.VisitPrice + _tranVisit.PhysicianSalary;
this.TotalVisitPrice = _tranVisit.TotalVisitPrice;
this.VisitsCount = _tranVisit.VisitsCount;
this.TimeFrom = _tranVisit.TimeFrom;
this.TimeTo = _tranVisit.TimeTo;
this.Notes = _tranVisit.Notes;
this.PaiedPrice = _tranVisit.Paiedprice;
this.RestPrice = _tranVisit.RestPrice;
return(this);
}
catch (Exception)
{
return(null);
}
}
