public async Task <IActionResult> GetSchedule([FromRoute] int id) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var schedule = await _context.Schedules.SingleOrDefaultAsync(m => m.Id == id); if (schedule == null) { return(NotFound()); } ScheduleDTO scheduleDTO = new ScheduleDTO { Id = schedule.Id, DoctorId = schedule.DoctorId, DoctorName = _context.Doctors.Where(d => d.Id == schedule.DoctorId).SingleOrDefault().Name, PatientId = schedule.PatientId, PatientName = _context.Patients.Where(d => d.Id == schedule.PatientId).SingleOrDefault().Name, Date = schedule.Date.ToString("yyyy-MM-dd"), Time = schedule.Date.ToShortTimeString() }; return(Ok(scheduleDTO)); }
public static void sendEmail(ScheduleDTO schedule) { SmtpClient client = new SmtpClient(); client.Port = 587; client.Host = "smtp.gmail.com"; client.EnableSsl = true; client.Timeout = 1000000; client.DeliveryMethod = SmtpDeliveryMethod.Network; client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "diniracheli909"); try { var q = DAL.UserDal.GetUsers().FirstOrDefault(i => i.userId == schedule.StudentId); var q2 = DAL.UserDal.GetUsers().FirstOrDefault(i => i.userId == schedule.TeacherId); MailMessage mm = new MailMessage("*****@*****.**", q.email, "ביטול שיעור" + schedule.Subject, ""); mm.Body = " הי " + q.firstName + ' ' + q.lastName + " \n" + " שיעור " + schedule.Subject + " של המורה " + q2.firstName + ' ' + q2.lastName + " בתאריך " + schedule.Date + " בשעה " + schedule.starTtime + " התבטל!!!!!! " + "\n" + "<a href='http://localhost:4200/חיפוש'> לקביעת שיעור אחר</a>"; mm.BodyEncoding = UTF8Encoding.UTF8; // mm. = MailFormat.Html; mm.IsBodyHtml = true; mm.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure; client.Send(mm); } catch (Exception e) { } }
public DateTime GetDisbursementDate(int LoanMasterId) { ScheduleDTO obj = new ScheduleDTO(); obj = _groupLoanDisbursementService.GetDisbusementDate(LoanMasterId); return(Convert.ToDateTime(obj.DisbursementDate)); }
public Response <ScheduleDTO> AddVacations(ScheduleDTO obj) { try { using (VDEntities entities = new VDEntities()) { foreach (var clinic in obj.Clinics) { var dbSchedules = entities.Schedules.Where(x => x.Child.ClinicID == clinic.ID && x.Date >= obj.FromDate && x.Date <= obj.ToDate).ToList(); foreach (Schedule schedule in dbSchedules) { schedule.Date = obj.ToDate.AddDays(1); entities.SaveChanges(); } } return(new Response <ScheduleDTO>(true, "Vacations are considered and appointments are moved to " + obj.ToDate.AddDays(1).ToString("dd-MM-yyy") + " date.", null)); } } catch (Exception e) { return(new Response <ScheduleDTO>(false, GetMessageFromExceptionObject(e), null)); } }
public Guid Add(ScheduleDTO scheduleDTO) { try { if (scheduleDTO != null) { Schedule schedule = new Schedule { IdFlight = scheduleDTO.FlightID, IdFlightState = scheduleDTO.FlightStateID, DepartureDT = scheduleDTO.DepartureDT, ArrivalDT = scheduleDTO.ArrivalDT, Comment = scheduleDTO.Comment }; _airplaneContext.Schedules.Add(schedule); _airplaneContext.SaveChanges(); return(schedule.Id); } else { throw new AirportServiceException("Couldn't add schedule. Provided data was invalid."); } } catch (DbUpdateException ex) { throw new AirportServiceException("Couldn't add schedule. Provided data was invalid."); } }
public ActionResult CreateSchedule(ScheduleDTO scheduleDTO) { //TODO: // 1) Check any conflict with broadcast shifts //First populate with all Rostered shifts //IEnumerable<ShiftDTO> shifts = null; //using (HttpClientWrapper httpClient = new HttpClientWrapper(Session)) //{ // Task<String> response = httpClient.GetStringAsync("api/EmployeeRosterAPI?startDate=" + HttpUtility.UrlEncode(scheduleDTO.S.StartDateTime.AddDays(1).ToShortDateString()) + "&endDate=" + HttpUtility.UrlEncode(range.EndDateTime.AddDays(1).ToShortDateString())); // shifts = JsonConvert.DeserializeObjectAsync<IEnumerable<ShiftDTO>>(response.Result).Result; //} // 2) check any conflict with recurring shifts if (ModelState.IsValid) { using (HttpClientWrapper httpClient = new HttpClientWrapper(Session)) httpClient.PostAsJsonAsync("/api/ScheduleAPI", scheduleDTO).Result.EnsureSuccessStatusCode(); return(RedirectToAction("IndexSchedule"));//, new { id = employeedto.BusinessId }); } LoadViewBag(); return(PartialView(scheduleDTO)); }
public Response <ScheduleDTO> Update(ScheduleDTO scheduleDTO) { try { using (VDEntities entities = new VDEntities()) { var dbSchedule = entities.Schedules.Where(c => c.ID == scheduleDTO.ID).FirstOrDefault(); var dbBrandInventory = entities.BrandInventories.Where(b => b.BrandID == scheduleDTO.BrandId && b.DoctorID == scheduleDTO.DoctorID).FirstOrDefault(); if (dbBrandInventory != null && dbBrandInventory.Count > 0) { if (scheduleDTO.GivenDate.Date == DateTime.UtcNow.AddHours(5).Date) { dbBrandInventory.Count--; } } dbSchedule.BrandId = scheduleDTO.BrandId; dbSchedule.Weight = scheduleDTO.Weight; dbSchedule.Height = scheduleDTO.Height; dbSchedule.Circle = scheduleDTO.Circle; dbSchedule.IsDone = scheduleDTO.IsDone; dbSchedule.GivenDate = scheduleDTO.GivenDate; ChangeDueDatesOfInjectedSchedule(scheduleDTO, entities, dbSchedule); entities.SaveChanges(); return(new Response <ScheduleDTO>(true, "schedule updated successfully.", null)); } } catch (Exception e) { return(new Response <ScheduleDTO>(false, GetMessageFromExceptionObject(e), null)); } }
public ScheduleDTO GetByID(int?id) { try { ScheduleDTO schedule = new ScheduleDTO(); using (MySqlConnection conn = _con.GetConnection()) { //join statement for scheduleDetails conn.Open(); MySqlCommand cmd = new MySqlCommand("SELECT ScheduleID,DivisionID,ScheduleName FROM schedule WHERE ScheduleID = ?id", conn); cmd.Parameters.AddWithValue("id", id); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { schedule.ScheduleID = reader[0] as int? ?? default; schedule.DivisionID = reader[1] as int? ?? default; schedule.ScheduleName = reader[2] as string ?? default; } } //get scheduleDetails schedule.ScheduleDetailsList = GetScheduleDetails(id, conn); } return(schedule); } catch (Exception ex) { throw new ContextErrorException(ex); } }
public int Update(ScheduleDTO dto) { var entity = ModelMapper.Mapper.Map <Schedule>(dto); entity.EntityState = EntityState.Modified; return(_scheduleRepository.Save(entity)); }
//Update public int?Update(ScheduleDTO entity) { try { using (MySqlConnection conn = _con.GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("UPDATE schedule SET DivisionID = ?DivisionID, ScheduleName = ?ScheduleName WHERE ScheduleID = ?id", conn); //where id is cmd.Parameters.AddWithValue("id", entity.ScheduleID); //values cmd.Parameters.AddWithValue("DivisionID", entity.DivisionID ?? (object)DBNull.Value); cmd.Parameters.AddWithValue("TeamID", entity.ScheduleName ?? (object)DBNull.Value); //execute command int rowsAffected = cmd.ExecuteNonQuery(); //should return if a row is affected or not //update scheduleDetails UpdateScheduleDetails(entity, conn); //get all then compare and delete the ones that are not in the list anymore then update all the rest. //easier to just drop details and then insert new ones?! return(rowsAffected); } } catch (Exception ex) { throw new ContextErrorException(ex); } }
//Create public int?Add(ScheduleDTO entity) { try { using (MySqlConnection conn = _con.GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("INSERT INTO schedule (ScheduleID,DivisionID,ScheduleName) VALUES(?ScheduleID,?DivisionID,?ScheduleName)", conn); //values cmd.Parameters.AddWithValue("ScheduleID", entity.ScheduleID ?? (object)DBNull.Value); cmd.Parameters.AddWithValue("DivisionID", entity.DivisionID ?? (object)DBNull.Value); cmd.Parameters.AddWithValue("ScheduleName", entity.ScheduleName ?? (object)DBNull.Value); //execute command int rowsAffected = cmd.ExecuteNonQuery(); //should return if a row is affected or not //add multiple scheduleDetails AddScheduleDetails(entity.ScheduleDetailsList, conn); return(rowsAffected); } } catch (Exception ex) { throw new ContextErrorException(ex); } }
public void GetOrderDetail(string orderID) { OrderDAO orderDao = new OrderDAO(); ScheduleDAO scheduleDAO = new ScheduleDAO(); MovieDAO movieDAO = new MovieDAO(); OrderDTO order = orderDao.CheckOrder(orderID); if (order != null) { ScheduleDTO schedule = scheduleDAO.GetScheduleByID(order.ScheduleID); string movieTitle = movieDAO.GetMovieTitle(schedule.MovieID); this.orderDetail.Visible = true; this.lblOrderID.Text = order.OrderID; this.invalidCode.Visible = false; this.lbMovieName.Text = movieTitle; this.lbDate.Text = schedule.ScheduleDate.ToShortDateString(); this.lbTime.Text = schedule.ScheduleDate.ToShortTimeString(); this.lbRoom.Text = schedule.RoomID.ToString(); this.lbPrice.Text = (schedule.PriceOfTicket * (order.ListOfSeat).Count) + ""; string seat = ""; foreach (string s in order.ListOfSeat) { seat += (s + " "); } this.lbSeat.Text = seat; } else { this.invalidCode.CssClass = "error_message_show"; this.orderDetail.Visible = false; } }
public List <ValidationResult> Validate(ScheduleDTO schedule) { List <ValidationResult> errors = new List <ValidationResult>(); if (schedule.ProjectWorkId == 0) { errors.Add(new ValidationResult("Не указан идентификатор участия в проекте", new List <string>() { "ProjectWorkId" })); } if (schedule.ScheduleDayId == 0) { errors.Add(new ValidationResult("Не указан идентификатор дня недели", new List <string>() { "ScheduleDayId" })); } if (schedule.ScheduleDayId != 0 && (schedule.ScheduleDayId > 6 || schedule.ScheduleDayId < 1)) { errors.Add(new ValidationResult("День не существует", new List <string>() { "ScheduleDayId" })); } return(errors); }
public void EditAnyway(ScheduleDTO entity) { Schedule schedule = Database.Schedules.Find(x => x.Id == entity.Id).FirstOrDefault(); if (schedule == null) { throw new ArgumentNullException(); } schedule.DoctorId = Database.Doctors.Find(x => x.Id == entity.DoctorId).FirstOrDefault().Id; schedule.Date = entity.Date; schedule.Time = entity.Time; if (schedule.PatientId == 0) { var list = Database.Schedules.Find(x => x.DoctorId == schedule.DoctorId && TimeParsing(entity.Time).Contains(x.Time)); foreach (var el in list) { Database.Schedules.Delete(el.Id); } } Database.Schedules.Update(schedule); Database.Save(); }
//Nssf table Body details private void AddNSSFTableBodyDetails(ScheduleDTO det, Table statementInfoTable) { Cell A = new Cell(new Phrase(det.EmpNo, tcFont)); A.HorizontalAlignment = Cell.ALIGN_LEFT; statementInfoTable.AddCell(A); Cell C = new Cell(new Phrase(det.EmpName, tcFont)); C.HorizontalAlignment = Cell.ALIGN_LEFT; statementInfoTable.AddCell(C); Cell E = new Cell(new Phrase(det.Amount.ToString("#,##0"), tcFont)); E.HorizontalAlignment = Cell.ALIGN_RIGHT; statementInfoTable.AddCell(E); Cell D = new Cell(new Phrase(det.EmpNSSFContrib.ToString("#,##0"), tcFont)); D.HorizontalAlignment = Cell.ALIGN_RIGHT; statementInfoTable.AddCell(D); Cell F = new Cell(new Phrase(det.TotalContribs.ToString("#,##0"), tcFont)); F.HorizontalAlignment = Cell.ALIGN_RIGHT; statementInfoTable.AddCell(F); }
public void UpdatingSchedule_ReturnsNewSchedule() { // Arrange var old = new ScheduleDTO("old", "xyz", "abc"); var newName = "def"; var newCompany = "ghi"; var newId = "jkl"; var newSchedDto = new ScheduleDTO(newName, newId, newCompany); var newSched = new Schedule(newId, newCompany, newName); // Mock the interface and implementation _mockHandler.Setup(x => x.Update(It.IsAny <ScheduleDTO>())).Returns(newSchedDto); // Act var actual = _schedCol.Update(newSched); // Assert // Asserting that the value is actually updated and is not the old schedule Assert.AreEqual(newSched.Name, actual.Name); Assert.AreNotEqual(old.Name, actual.Name); Assert.AreEqual(newSched.CompanyId, actual.CompanyId); Assert.AreNotEqual(old.CompanyId, actual.CompanyId); Assert.AreEqual(newSched.ScheduleId, actual.ScheduleId); Assert.AreNotEqual(old.ScheduleId, actual.ScheduleId); }
public ActionResult EditSchedule(ScheduleDTO scheduleDTO) { //if (scheduleDTO.StartTime < DateTime.Now.AddHours(-1) //Ensure entry is a valid start date and finish date // || scheduleDTO.FinishTime < scheduleDTO.StartTime) // ModelState.AddModelError(String.Empty, "Start time must be after current time and before the finish time"); if (ModelState.IsValid) { using (HttpClientWrapper httpClient = new HttpClientWrapper(Session)) { var responseMessage = httpClient.PutAsJsonAsync("api/ScheduleAPI/" + scheduleDTO.Id.ToString(), scheduleDTO).Result; if (responseMessage.IsSuccessStatusCode) { return(RedirectToAction("IndexSchedule")); } else { //If and error occurred add details to model error. var error = JsonConvert.DeserializeObject <System.Web.Http.HttpError>(responseMessage.Content.ReadAsStringAsync().Result); ModelState.AddModelError(String.Empty, error.Message); } } } LoadViewBag(); return(PartialView(scheduleDTO)); }
public void GetShiftsFromSchedule_ReturnsProperList() { // Arrange var sched = new ScheduleDTO("hello", "test", "company"); var shift1 = new ShiftDTO("1", "test", "user", DateTime.Now, 1, 2); var shift2 = new ShiftDTO("2", "test", "user", DateTime.Now, 1, 2); var shift3 = new ShiftDTO("3", "test", "user", DateTime.Now, 1, 2); var shift4 = new ShiftDTO("4", "test", "user", DateTime.Now, 1, 2); var dtos = new List <ShiftDTO>() { shift1, shift2, shift3, shift4 }; // Mock the interface and implementation var mock = new Mock <IScheduleHandler>(); _mockHandler.Setup(x => x.GetShiftsFromSchedule("test")).Returns(dtos); // Act // I am using sched.scheduleId to check if it actually gets the id properly var actual = _schedCol.GetShiftsFromSchedule(sched.ScheduleId); // Assert for (int i = 0; i < actual.Count; i++) { Assert.AreEqual(dtos[i].ScheduleId, actual[i].ScheduleId); Assert.AreEqual(dtos[i].ShiftId, actual[i].ShiftId); Assert.AreEqual(dtos[i].UserId, actual[i].UserId); Assert.AreEqual(dtos[i].ShiftDate, actual[i].ShiftDate); Assert.AreEqual(dtos[i].StartTime, actual[i].StartTime); Assert.AreEqual(dtos[i].EndTime, actual[i].EndTime); } }
public void CreateScheduleTest() { ScheduleServise scheduleServise = new ScheduleServise(uow, new Map <Schedule, ScheduleDTO>(), new Map <ScheduleDay, ScheduleDayDTO>()); EmployeeService employeeService = new EmployeeService(uow, new Map <Employee, EmployeeDTO>()); ProjectService projectService = new ProjectService(uow, new Map <Project, ProjectDTO>()); ProjectWorkService projectWorkService = new ProjectWorkService(uow, new Map <ProjectWork, ProjectWorkDTO>()); EmployeeDTO employee = new EmployeeDTO { EmployeeName = "Екатерина", EmployeeSurname = "Антонович", EmployeePatronymic = "Алексеевна", RoleId = 3, Email = "*****@*****.**", }; var employeeOnWork = employeeService.CreateEmployee(employee); var em = employeeService.GetEmployeeById(employeeOnWork.Id); ProjectDTO project = new ProjectDTO { ProjectName = "проект 1", ProjectDescription = "проект номер один", ProjectStartDate = new DateTimeOffset(2021, 10, 6, 10, 15, 35, new TimeSpan(3, 0, 0)), ProjectEndDate = new DateTimeOffset(2021, 10, 21, 10, 15, 35, new TimeSpan(3, 0, 0)) }; var proj = projectService.CreateProject(project); var pr = projectService.GetProjectById(proj.Id); ProjectWorkDTO projectWork = new ProjectWorkDTO { EmployeeId = em.Id, ProjectId = pr.Id, ProjectRoleId = 3 }; var pWork = projectWorkService.CreateProjectWork(projectWork); var prw = projectWorkService.GetProjectWorkById(pWork.Id); ScheduleDTO schedule = new ScheduleDTO { ProjectWorkId = prw.Id, ScheduleDayId = 1 }; var sch = scheduleServise.CreateSchedule(schedule); ScheduleDTO actual = scheduleServise.GetScheduleById(sch.Id); ScheduleDTO expected = new ScheduleDTO { Id = actual.Id, ProjectWorkId = prw.Id, ScheduleDayId = 1 }; Assert.IsTrue(actual.Id == expected.Id && actual.ProjectWorkId == expected.ProjectWorkId && actual.ScheduleDayId == expected.ScheduleDayId); scheduleServise.DeleteScheduleById(actual.Id); projectWorkService.DeleteProjectWorkById(prw.Id); employeeService.DeleteEmployeeById(em.Id); projectService.DeleteProjectById(pr.Id); }
public void GetAll_ReturnsList() { // Arrange // Setting up the expected dto list ScheduleDTO dto1 = new ScheduleDTO("1", "1", "1"); ScheduleDTO dto2 = new ScheduleDTO("2", "2", "2"); ScheduleDTO dto3 = new ScheduleDTO("3", "3", "3"); List <ScheduleDTO> dtos = new List <ScheduleDTO>() { dto1, dto2, dto3 }; // Mocking the repo and implementation _mockHandler.Setup(x => x.GetAll()).Returns(dtos); // Act var actual = _schedCol.GetAll(); // Assert for (int i = 0; i < dtos.Count; i++) { Assert.AreEqual(dtos[i].Name, actual[i].Name); Assert.AreEqual(dtos[i].CompanyId, actual[i].CompanyId); } }
public Response <ScheduleDTO> BulkReschedule(ScheduleDTO scheduleDTO, [FromUri] bool ignoreMaxAgeRule = false, [FromUri] bool ignoreMinAgeFromDOB = false, [FromUri] bool ignoreMinGapFromPreviousDose = false) { try { using (VDEntities entities = new VDEntities()) { var dbSchedule = entities.Schedules.Where(x => x.ID == scheduleDTO.ID).FirstOrDefault(); var dbSchedules = entities.Schedules.Where(x => x.Date == dbSchedule.Date && x.ChildId == dbSchedule.ChildId && x.IsDone == false ).ToList(); foreach (var schedule in dbSchedules) { ChangeDueDatesOfSchedule(scheduleDTO, entities, schedule, "bulk", ignoreMaxAgeRule, ignoreMinAgeFromDOB, ignoreMinGapFromPreviousDose); } return(new Response <ScheduleDTO>(true, "schedule updated successfully.", null)); } } catch (Exception e) { return(new Response <ScheduleDTO>(false, GetMessageFromExceptionObject(e), null)); } }
// POST api/calendarapi public HttpResponseMessage Post([FromBody] ScheduleDTO scheduleDTO) { if (ModelState.IsValid) { var recurringCalendarEvent = MapperFacade.MapperConfiguration.Map <ScheduleDTO, Schedule>(scheduleDTO); //recurringCalendarEvent.Id = Guid.NewGuid(); //Assign new ID on save. //Ensure unsupported options are not created if (scheduleDTO.Frequency != 0 && scheduleDTO.Frequency != 1 && scheduleDTO.Frequency != 2) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.ExpectationFailed, "Frequency not supported. Must be once off (0), Daily (1) or Weekly(2)")); } //Lookup Business and attach, so that no updates or inserts are performed on BusinessType lookup table recurringCalendarEvent.UserProfile = db.UserProfiles.Single(u => u.Email == User.Identity.Name); if (recurringCalendarEvent.UserProfile == null) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Userprofile is null")); } try { db.Schedules.Add(recurringCalendarEvent); db.SaveChanges(); } catch (Exception ex) { var mes = ex.Message; } return(Request.CreateResponse(HttpStatusCode.Created)); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } }
public Response <List <ScheduleDTO> > GetVaccineBrands(ScheduleDTO scheduleDto) { try { using (VDEntities entities = new VDEntities()) { var dbSchedule = entities.Schedules.Where(x => x.Date == scheduleDto.Date && x.ChildId == scheduleDto.ChildId).ToList(); List <ScheduleDTO> scheduleDTOs = new List <ScheduleDTO>(); foreach (var schedule in dbSchedule) { ScheduleDTO scheduleDTO = new ScheduleDTO(); var dbBrands = schedule.Dose.Vaccine.Brands.ToList(); List <BrandDTO> brandDTOs = Mapper.Map <List <BrandDTO> >(dbBrands); scheduleDTO.Dose = Mapper.Map <DoseDTO>(schedule.Dose); scheduleDTO.ID = schedule.ID; scheduleDTO.Brands = brandDTOs; scheduleDTO.Date = schedule.Date; scheduleDTO.IsDone = schedule.IsDone; scheduleDTOs.Add(scheduleDTO); } return(new Response <List <ScheduleDTO> >(true, null, scheduleDTOs)); } } catch (Exception e) { return(new Response <List <ScheduleDTO> >(false, GetMessageFromExceptionObject(e), null)); } }
public void FindOpenRestaurantsByDate_Should_Return_New_List_When_Any_Resto_Is_Open() { //Arrange var mock = new Mock <IRestoRepository>(); var schedules = new List <ScheduleDTO>(); var schedule = new ScheduleDTO { TimeOpen = DateTime.Now, TimeClosed = DateTime.Now.AddHours(3), DayOfWeek = (int)DateTime.Now.DayOfWeek }; schedules.Add(schedule); mock.Setup(x => x.GetAll()).Returns(new List <RestoDTO>() { new RestoDTO { City = "Bruxelles", Id = 1, Name = "R1", Schedules = new List <ScheduleDTO>() }, new RestoDTO { City = "Bruxelles", Id = 2, Name = "R2", Schedules = new List <ScheduleDTO>() }, new RestoDTO { City = "Liege", Id = 3, Name = "R3", Schedules = new List <ScheduleDTO>() }, }); RestaurantUC target = new RestaurantUC(mock.Object); //Act var result = target.FindOpenRestaurantsByDate(schedule.TimeOpen).ToList(); //Assert Assert.AreEqual(result.Count, 0); }
public void Edit(ScheduleDTO scheduleDTO) { try { if (scheduleDTO != null) { var schedule = _airplaneContext.Schedules.FirstOrDefault(c => c.Id == scheduleDTO.ID); if (schedule != null) { schedule.IdFlight = scheduleDTO.FlightID; schedule.IdFlightState = scheduleDTO.FlightStateID; schedule.DepartureDT = scheduleDTO.DepartureDT; schedule.ArrivalDT = scheduleDTO.ArrivalDT; schedule.Comment = scheduleDTO.Comment; _airplaneContext.SaveChanges(); } else { throw new AirportServiceException("Couldn't edit schedule. Provided schedule doesn't exist."); } } else { throw new AirportServiceException("Couldn't edit schedule. Provided data was invalid."); } } catch (DbUpdateException ex) { throw new AirportServiceException("Couldn't edit schedule. Provided data was invalid."); } }
public bool Save(ScheduleDTO scheduleDTO) { if (scheduleDTO.ID == 0) { scheduleDTO.ID = MockDatabase.UniqueID; MockDatabase.UniqueID++; MockDatabase.Schedules.Add(scheduleDTO); } else { var schedule = MockDatabase.Schedules.FirstOrDefault(s => s.ID == scheduleDTO.ID); if (schedule == null) { return(false); } schedule.Title = scheduleDTO.Title; schedule.Frequency = scheduleDTO.Frequency; schedule.DaysOfWeek = scheduleDTO.DaysOfWeek; schedule.WeeklyInterval = scheduleDTO.WeeklyInterval; schedule.MonthlyInterval = scheduleDTO.MonthlyInterval; schedule.NumberOfOccurrences = scheduleDTO.NumberOfOccurrences; schedule.StartDate = scheduleDTO.StartDate; schedule.EndDate = scheduleDTO.EndDate; schedule.StartTime = scheduleDTO.StartTime; schedule.EndTime = scheduleDTO.EndTime; } return(true); }
public IActionResult UpdatePatient(int id, [FromBody] ScheduleDTO sched) { if (sched == null) { return(BadRequest()); } if (sched.MRN == string.Empty) { ModelState.AddModelError("MRN", "Medical record number can not be empty"); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var patToUpdate = _scheduleRepository.GetScheduleByKey(sched.Key); if (patToUpdate == null) { return(NotFound()); } _scheduleRepository.Update(sched); return(NoContent()); //success }
private void LoadDataFromQueryRequest(string scheduleID, int roomID) { ScheduleDTO sDTO = sDAO.GetScheduleDTO((List <ScheduleDTO>)Session["ScheduleList"], scheduleID); string movieID = sDTO.MovieID; string movieTitle = mDAO.getMovieDTOByMovieID((List <MovieDTO>)Session["MovieList"], movieID).MovieTitle; EnableSelect(); roomTitle.Text = "Room " + roomID; dlMovieList.SelectedValue = movieTitle; dlScheduleID.Items.Clear(); dlScheduleList.Items.Clear(); dlScheduleList.Items.Add("--Select a schedule--"); List <ScheduleDTO> scheduleList = sDAO.getSpecificMovieSchedule((List <ScheduleDTO>)Session["ScheduleList"], movieID); LoadScheduleToDropDownList(scheduleList); dlScheduleList.Enabled = true; dlScheduleList.SelectedValue = sDTO.ScheduleDate + " at Room No. " + sDTO.RoomID; dlTicketNum.Items.Clear(); List <string> bookedSeatList = odDAO.GetAllSeats(scheduleID); int bookedSeat; if (bookedSeatList == null) { bookedSeat = 0; } else { bookedSeat = bookedSeatList.Count; } int remainingSeat = rDAO.getRoom((List <RoomDTO>)Session["RoomList"], roomID).NumberOfSeat - bookedSeat; if (remainingSeat >= 10) { LoadAvailableSeat(10); } else { LoadAvailableSeat(remainingSeat); } dlTicketNum.Enabled = true; lblPriceTicket.Text = "Per Ticket costs " + sDTO.PriceOfTicket + " $"; lblPriceTicket.Visible = true; lblTicketNoti.Visible = true; Session["SelectionAvailable"] = 1; Session["SelectedSeats"] = new List <string>(); Session["CurrentPage"] = "BookTicketPage.aspx"; Session["CurrentSelectdlMovie"] = dlMovieList.SelectedValue; Session["CurrentSelectdlSchedule"] = sDTO.ScheduleID; UpdateTicketMessage(); List <Button> seaList = loadSeatList(); MarkBookedSeats(bookedSeatList, seaList); }
private void btnAddTimeInterval_Click_1(object sender, EventArgs e) { try { using (var controller = this.iFactory.GetController <ManageScheduleHandler>()) { DataGridViewRow row = dgvDateInterval.CurrentRow; ScheduleDTO dateInterval = dgvDateInterval.GetItem(row.Index); ScheduleEntryDTO timeInterval = new ScheduleEntryDTO(); IAddModifyViewForm ventana = new AgregarModificarIntervaloTiempo(this.iFactory); ventana.Add((IDTO)timeInterval); DialogResult resultado = ventana.ShowForm(); if (resultado == DialogResult.OK) { dateInterval.ActiveHours.Add(timeInterval); } } } catch { throw; } //TODO revisar esto }
public ScheduleDTO GetSchedule(int pId) { ScheduleDTO lResult = new ScheduleDTO(); iUoW.BeginTransaction(); try { lResult = Mapper.Map <Schedule, ScheduleDTO>(iServ.Read(pId)); } finally { iUoW.Rollback(); } return(lResult); //TODO esto lo comenté y no lo borré por el tema del helper, por las dudas // Schedule lTemp; // lTemp = serv.Read(pId); // //lResult = MapperHelper.Map<Schedule, ScheduleDTO>(lTemp, lResult); // lResult = Mapper.Map<Schedule, ScheduleDTO>(lTemp); //// lResult = MapperHelper.Map<Schedule,ScheduleDTO>(lTemp,lResult); // return lResult; }