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