public string addBDPhysician(Physician Physician) { try { var Query = _contextDatabase.BDPhysicians.Where(a => a.PhysicianID == Physician.PhysicianID).FirstOrDefault(); if (Query != null) { Query.PhysicianName = Physician.PhysicianName; _contextDatabase.SaveChanges(); return("تم الحفظ بنجاح"); } else { BDPhysician _bDPhysician = new BDPhysician(); _bDPhysician.PhysicianName = Physician.PhysicianName; _contextDatabase.BDPhysicians.Add(_bDPhysician); _contextDatabase.SaveChanges(); return("تم الحفظ بنجاح"); } } catch (Exception ex) { return("Erorr on save"); throw; } }
public BDVisitPrice VisitPriceSaveChange(BDVisitPrice _bDVisitPrice) { try { // BDVisitPrice operation add & edit var dbVisitPrice = _contextDatabase.BDVisitPrices.SingleOrDefault(s => s.VisitPriceID == _bDVisitPrice.VisitPriceID); if (dbVisitPrice != null) { // Update BDVisitPrice _contextDatabase.Entry(dbVisitPrice).CurrentValues.SetValues(_bDVisitPrice); _contextDatabase.BDVisitPrices.Attach(dbVisitPrice); _contextDatabase.SaveChanges(); return(dbVisitPrice); } else { // Insert BDVisitPrice into the database _contextDatabase.BDVisitPrices.Add(_bDVisitPrice); _contextDatabase.SaveChanges(); return(_bDVisitPrice); } } catch (Exception ex) { throw; } return(null); }
public string addBDVisitType(VisitType _visitType) { try { var Query = _contextDatabase.BDVisitTypes.Where(a => a.VisitTypeID == _visitType.VisitTypeID).FirstOrDefault(); if (Query != null) { Query.VisitTypeName = _visitType.VisitTypeName; _contextDatabase.SaveChanges(); return("Added sucsessfully"); } else { BDVisitType _bDVisitType = new BDVisitType(); _bDVisitType.VisitTypeName = _visitType.VisitTypeName; _contextDatabase.BDVisitTypes.Add(_bDVisitType); _contextDatabase.SaveChanges(); return("Edited succesfuy"); } } catch (Exception ex) { return("Erorr on add"); throw; } }
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 BDPhysicianSalary PhysicianSalarySaveChange(BDPhysicianSalary _bDPhysicianSalary) { try { // BDPhysicianSalary operation add & edit var dbPhysicianSalary = _contextDatabase.BDPhysicianSalaries.SingleOrDefault(s => s.PhysicianPriceID == _bDPhysicianSalary.PhysicianPriceID); if (dbPhysicianSalary != null) { // Update BDPhysicianSalary _contextDatabase.Entry(dbPhysicianSalary).CurrentValues.SetValues(_bDPhysicianSalary); _contextDatabase.BDPhysicianSalaries.Attach(dbPhysicianSalary); _contextDatabase.SaveChanges(); return(dbPhysicianSalary); } else { // Insert BDPhysicianSalary into the database _contextDatabase.BDPhysicianSalaries.Add(_bDPhysicianSalary); _contextDatabase.SaveChanges(); return(_bDPhysicianSalary); } } catch (Exception ex) { throw; } return(null); }
public string addACPatient(ACPatient patient) { try { var Query = _contextDatabase.ACPatients.Where(a => a.PatientID == patient.PatientID).FirstOrDefault(); if (Query != null) { Query.PatientName = patient.PatientName; Query.DOB = patient.DOB; Query.Phone = patient.Phone; Query.Mobile = patient.Mobile; Query.Address = patient.Address; Query.Notes = patient.Notes; _contextDatabase.SaveChanges(); return("تم الحفظ بنجاح"); } else { ACPatient _bDPatient = new ACPatient(); _bDPatient.PatientName = patient.PatientName; _bDPatient.DOB = patient.DOB; _bDPatient.Phone = patient.Phone; _bDPatient.Mobile = patient.Mobile; _bDPatient.Address = patient.Address; _bDPatient.Notes = patient.Notes; _contextDatabase.ACPatients.Add(_bDPatient); _contextDatabase.SaveChanges(); return("تم الحفظ بنجاح"); } } catch (Exception ex) { return("Erorr on save"); throw; } }