public async Task <HomeTask> UpdateTask(HomeTask task) { _context.Update(task); await _context.SaveChangesAsync(); return(task); }
public void DeleteHomeTask(int homeTaskId) { HomeTask st = GetHomeTaskById(homeTaskId); context.HomeTask.Remove(st); SaveChanges(); }
public async Task <HomeTask> AddTask(HomeTask task) { _context.HomeTasks.Add(task); await _context.SaveChangesAsync(); return(task); }
public IActionResult Edit(int id) { HomeTask homeTask = repository.GetHomeTaskById(id); ViewData["Action"] = "Edit"; return(View("Create", homeTask)); }
public IActionResult Edit(HomeTask homeTaskParameter) { if (!ModelState.IsValid) { ViewData["Action"] = "Edit"; return(View(homeTaskParameter)); } var homeTask = this.context.HomeTask.Include(c => c.Course).SingleOrDefault(h => h.Id == homeTaskParameter.Id); homeTask.Title = homeTaskParameter.Title; homeTask.Number = homeTaskParameter.Number; homeTask.Description = homeTaskParameter.Description; homeTask.Date = homeTaskParameter.Date; var routeValueDictionary = new RouteValueDictionary(); this.context.Update(homeTask); context.SaveChanges(); routeValueDictionary.Add("id", homeTask.Course.Id); return(RedirectToAction("HomeTasks", "HomeTask", routeValueDictionary)); }
public List <HomeTask> GetAllHomeTasks(bool loadAllDependencies = true) { using (SqlConnection connection = GetConnection()) { SqlCommand sqlCommand = new SqlCommand( "select Id, Date, Title, Description, Number, CourseId from HomeTask", connection); List <HomeTask> homeTasks = new List <HomeTask>(); using (var reader = sqlCommand.ExecuteReader()) { while (reader.Read()) { HomeTask homeTask = new HomeTask(); homeTask.Id = reader.GetInt32(0); homeTask.Date = reader.GetDateTime(1); homeTask.Title = reader.GetString(2); homeTask.Description = reader.GetString(3); homeTask.Number = reader.GetInt16(4); homeTask.Course = GetCourse(reader.GetInt32(5)); if (loadAllDependencies) { homeTask.HomeTaskAssessments = this.GetHomeTaskAssessmentsByHomeTaskId(homeTask.Id); } homeTasks.Add(homeTask); } } return(homeTasks); } }
public HomeTask GetHomeTaskById(int id, bool loadAllDependencies = true) { using (SqlConnection connection = GetConnection()) { SqlCommand sqlCommand = new SqlCommand( $@" SELECT [Id] ,[Title] ,[Date] ,[Description] ,[Number] ,[CourseId] FROM [dbo].[HomeTask] WHERE [Id] = {id}", connection); using (var reader = sqlCommand.ExecuteReader()) { reader.Read(); HomeTask homeTask = new HomeTask(); homeTask.Id = reader.GetInt32(0); homeTask.Title = reader.GetString(1); homeTask.Date = reader.GetDateTime(2); homeTask.Description = reader.GetString(3); homeTask.Number = reader.GetInt16(4); int courseId = reader.GetInt32(5); if (loadAllDependencies) { homeTask.HomeTaskAssessments = GetHomeTaskAssessmentsByHomeTaskId(homeTask.Id); homeTask.Course = GetCourse(courseId); } return(homeTask); } } }
public virtual void CreateHomeTask(HomeTask homeTask, int courseId) { var course = courseRepository.GetById(courseId); homeTask.Course = course; this.homeTaskRepository.Create(homeTask); }
public static async Task <int> UpdateHomeTaskAsync(SqlConnection connection, HomeTask hometask) { var updateCommand = new SqlCommand("UPDATE Hometasks SET Name = @name," + "Description = @description, TaskDate = @taskDate, SerialNumber = @serialNumber," + "CourseID = courseID WHERE HomeTaskID = @hometaskID", connection); updateCommand.Parameters.AddWithValue("@hometaskID", hometask.HomeTaskID); updateCommand.Parameters.AddWithValue("@name", hometask.Name); updateCommand.Parameters.AddWithValue("@description", hometask.Description); updateCommand.Parameters.AddWithValue("@taskDate", hometask.TaskDate); updateCommand.Parameters.AddWithValue("@serialNumber", hometask.SerialNumber); updateCommand.Parameters.AddWithValue("@courseID", hometask.CourseID); try { var numberOfAffectedRows = await updateCommand.ExecuteNonQueryAsync(); return(numberOfAffectedRows); } catch (SqlException) { throw new Exception("There isn't course with such course ID in database "); } catch (Exception) { throw new Exception("Error: something went wrong"); } }
private List <HomeTask> GetHomeTasksByCourseId(int courseId) { List <HomeTask> homeTasks = new List <HomeTask>(); using (SqlConnection connection = GetConnection()) { SqlCommand sqlCommand = new SqlCommand( $@" SELECT [Id] ,[Title] ,[Date] ,[Description] ,[Number] FROM [dbo].[HomeTask] WHERE [CourseId] = {courseId}", connection); using (var reader = sqlCommand.ExecuteReader()) { while (reader.Read()) { HomeTask homeTask = new HomeTask(); homeTask.Id = reader.GetInt32(0); homeTask.Title = reader.GetString(1); homeTask.Date = reader.GetDateTime(2); homeTask.Description = reader.GetString(3); homeTask.Number = reader.GetInt16(4); homeTasks.Add(homeTask); } } } return(homeTasks); }
public async Task <IActionResult> Put(int hometaskID, [FromBody] Dictionary <string, string> hometask) { if (Validation.IsAnyInputObjectDataNotSpecified(new List <object> { hometaskID, hometask.ContainsKey("Name") ? hometask["Name"] : null, hometask.ContainsKey("Description") ? hometask["Description"] : null, hometask.ContainsKey("TaskDate") ? hometask["TaskDate"] : null, hometask.ContainsKey("SerialNumber") ? hometask["SerialNumber"] : null, hometask.ContainsKey("CourseID") ? hometask["CourseID"] : null })) { return(BadRequest("Error: all hometask input data must be specified")); } hometask["Name"] = hometask["Name"].Trim(); hometask["Description"] = hometask["Description"].Trim(); hometask["TaskDate"] = hometask["TaskDate"].Trim(); hometask["SerialNumber"] = hometask["SerialNumber"].Trim(); hometask["CourseID"] = hometask["CourseID"].Trim(); if (!Validation.ValidateDateTimeAndGetParsed(hometask["TaskDate"], out DateTime resultTaskDate)) { return(BadRequest("Error: task date is incorrect")); } if (!Validation.ValidateIntAndGetParsed(hometask["SerialNumber"], out int resultSerialNumber) || resultSerialNumber < 0) { return(BadRequest("Error: serial number is incorrect")); } if (!Validation.ValidateIntAndGetParsed(hometask["CourseID"], out int resultCourseID)) { return(BadRequest("Error: course ID is incorrect")); } var resultHometask = new HomeTask { HomeTaskID = hometaskID, Name = hometask["Name"], Description = hometask["Description"], TaskDate = resultTaskDate, SerialNumber = resultSerialNumber, CourseID = resultCourseID }; using (var connection = new SqlConnection(Configuration.GetConnectionString("DefaultConnection"))) { try { connection.Open(); await HometasksRepository.UpdateHomeTaskAsync(connection, resultHometask); } catch (Exception ex) { return(BadRequest(ex.Message)); } } return(NoContent()); }
public IActionResult Create(int id) //click onlink { HomeTask homeTask = new HomeTask(); ViewBag.Action = nameof(Create); ViewBag.Id = id; return(View("UpdateHomeTask", homeTask)); }
public IActionResult Create(int courseId) { ViewData["Action"] = "Create"; ViewData["CourseId"] = courseId; var model = new HomeTask(); return(View("Edit", model)); }
public IActionResult Create(int courseId) { ViewData["Action"] = "Create"; ViewData["CourseId"] = courseId; var assessmentStudent = new HomeTask(); return(View("Create", assessmentStudent)); }
public void CheckHmtMethodAdd() { double need = 10; HomeTask hmt = new HomeTask(0); hmt.AddPrice(10); Assert.AreEqual(need, hmt.GetWrk()); }
public void UpdateHomeTask(HomeTask homeTask) { using (AcademyContext academyDb = new AcademyContext(options)) { academyDb.HomeTask.Update(homeTask); academyDb.SaveChanges(); } }
public void CheckWrkMethodSubstract() { double need = 0; HomeTask hmt = new HomeTask(10); hmt.SubtractNumFromWrk(10); Assert.AreEqual(need, hmt.GetWrk()); }
public void UpdateHomeTask(HomeTask homeTask) { using (var context = new StudyContext()) { context.HomeTasks.Update(homeTask); context.SaveChanges(); } }
public virtual HomeTask CreateHomeTask(HomeTask homeTask) { //Todo think if it is needed to retrieve course var course = _courseRepository.GetById(homeTask.CourseId); homeTask.Course = course; return(_homeTaskRepository.Create(homeTask)); }
public IActionResult Create(int Id) { ViewData["Action"] = "Create"; ViewData["CourseId"] = Id; var homeTask = new HomeTask(); return(View("Edit", homeTask)); }
public IActionResult Edit([FromForm] HomeTask homeTaskParameter) { var homeTask = this._repository.GetHomeTaskById(homeTaskParameter.Id); var routeValueDictionary = new RouteValueDictionary(); routeValueDictionary.Add("id", homeTask.Course.Id); this._repository.UpdateHomeTask(homeTaskParameter); return(RedirectToAction("Edit", "Course", routeValueDictionary)); }
private ValidationResponse <HomeTask> ValidateHomeTask(HomeTask homeTask) { if (homeTask == null) { return(new ValidationResponse <HomeTask>("homeTask", "HomeTask cannot be null")); } return(new ValidationResponse <HomeTask>(homeTask)); }
public virtual bool DeleteHomeTask(HomeTask homeTask) { if (academyRepository == null) { return(false); } academyRepository.DeleteHomeTask(homeTask); return(true); }
public void DeleteHomeTask(int id) { using (AcademyContext academyDb = new AcademyContext(options)) { HomeTask homeTask = GetHomeTask(id); DeleteHomeTask(homeTask); academyDb.SaveChanges(); } }
public IActionResult Edit([FromRoute] int id) { HomeTask homeTask = hometaskService.GetHomeTask(id); if (homeTask == null) { return(NotFound()); } return(View(homeTask)); }
public IActionResult Edit([FromRoute] int id) { HomeTask homeTask = repository.GetHomeTaskById(id); if (homeTask == null) { return(NotFound()); } return(View(homeTask)); }
public HomeTask GetHomeTaskById(int id) { HomeTask result = new HomeTask(); using (var context = new StudyContext()) { result = context.HomeTasks.Find(id); } return(result); }
public virtual HomeTask GetHomeTask(int id) { if (academyRepository == null) { return(null); } HomeTask homeTask = academyRepository.GetHomeTask(id); return(homeTask); }
private static void ImportHomeTaskAssesments(HomeTask homeTask, IEnumerable <XElement> homeTaskAssessmentElements) { foreach (var homeTaskAssessmentElement in homeTaskAssessmentElements) { HomeTaskAssessment homeTaskAssessment = new HomeTaskAssessment(); homeTaskAssessment.Id = int.Parse(homeTaskAssessmentElement.Element("Id").Value); homeTaskAssessment.IsComplete = bool.Parse(homeTaskAssessmentElement.Element("IsComplete").Value); homeTaskAssessment.Date = DateTime.Parse(homeTaskAssessmentElement.Element("Date").Value); homeTask.HomeTaskAssessments.Add(homeTaskAssessment); } }
public IActionResult Edit(int id) { HomeTask homeTask = this.homeTaskService.GetHomeTaskById(id); if (homeTask == null) { return(this.NotFound()); } ViewData["Action"] = "Edit"; return(View(homeTask)); }