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); } }