public void Create(Ticket ticket) { ticket.TicketType = _context.Types.FirstOrDefault(t => t.Type == ticket.TicketType.Type); ticket.TicketStatus = _context.Statuses.FirstOrDefault(s => s.Status == ticket.TicketStatus.Status); ticket.TicketPriority = _context.Priorities.FirstOrDefault(p => p.Priority == ticket.TicketPriority.Priority); ticket.User = _context.Users.Where(u => u.Username.Equals(ticket.User.Username)).First(); ticket.CreateDate = DateTime.Now; _context.Tickets.Add(ticket); _context.SaveChanges(); }
public int SaveDoctor(Doctor aDoctor) { CMAContext db = new CMAContext(); db.Doctors.Add(aDoctor); int rowAffected = db.SaveChanges(); return(rowAffected); }
public int SaveSendMedicine(List <SendMedicine> sendMedicines) { CMAContext db = new CMAContext(); foreach (SendMedicine sendMedicine in sendMedicines) { db.SendMedicines.Add(sendMedicine); } int rowAffected = db.SaveChanges(); return(rowAffected); }
public int SaveTreatment(List <Treatment> treatments) { CMAContext db = new CMAContext(); foreach (Treatment treatment in treatments) { db.Treatments.Add(treatment); } int rowAffected = db.SaveChanges(); return(rowAffected); }
public bool SetDisease(Disease disease) { CMAContext db = new CMAContext(); db.Diseases.Add(disease); int result = db.SaveChanges(); if (result == 1) { return(true); } else { return(false); } }
public bool SetMedicine(Medicine medicine) { CMAContext db = new CMAContext(); db.Medicines.Add(medicine); int result = db.SaveChanges(); if (result == 1) { return(true); } else { return(false); } }
public bool SetCenter(Center aCenter) { CMAContext db = new CMAContext(); db.Centers.Add(aCenter); int result = db.SaveChanges(); if (result == 1) { return(true); } else { return(false); } }
public async Task Create(User user) { user.UserType = _context.UserTypes.FirstOrDefault(t => t.Type == user.UserType.Type); _context.Users.Add(user); _context.SaveChanges(); }