public EFTodoContext(DbContextOptions <EFTodoContext> options)
: base(options)
{
DBFacade = Database;
this.Database.EnsureCreated();
if (ToDoListItems.Count() == 0)
{
var ListItems = new List <ToDoListItem>
{
new ToDoListItem(0, "Open Visual Studio", true),
new ToDoListItem(1, "Create a new project", true),
new ToDoListItem(2, "Choose ASP.NET Core Web Application", true),
new ToDoListItem(3, "Name the project", true),
new ToDoListItem(4, "Choose .NET Core", true),
new ToDoListItem(5, "Choose ASP.NET Core 3.1", true),
new ToDoListItem(6, "Choose MVC Web Application", true),
new ToDoListItem(7, "Design a Todo List", true),
new ToDoListItem(8, "Implement a Todo List using scaffolding", true),
new ToDoListItem(9, "Add list items for testing and examples", true),
new ToDoListItem(10, "Test the new Todo List ", true),
new ToDoListItem(11, "Push the new Web Application to gitHub", true),
new ToDoListItem(12, "Get hired by Priority1", false)
};
ListItems.ForEach(s => this.ListItem.Add(s));
SaveChanges();
}
}
private void SaveItem_Click(object sender, RoutedEventArgs e)
{
ToDoListEntities dbEntities = new ToDoListEntities();
var selected = lvToDoListItem.SelectedItems.Cast <Object>().ToArray();
if (selected.Length == 0)
{
MessageBox.Show("Please select the row you want to update.", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
foreach (var item in selected)
{
ToDoListItems todo = dbEntities.ToDoListItems.Find(((ToDoList.Business.TodoListItems)item).ItemId);
if (((ToDoList.Business.TodoListItems)selected[0]).Status == true)
{
todo.Status = "1";
}
else
{
todo.Status = "0";
}
dbEntities.SaveChanges();
}
}
private void Save(object obj)
{
Helper.InvokeAction(() => {
DateTime now = Helper.DateParse(this.ToDoListItem.Deadline);
int id = this.ToDoListItem.Id;
var temp = service.FirstOrDefault(x => x.Id == id);
if (temp == null)
{
temp = new TodoListItem();
}
temp.Name = this.ToDoListItem.Name;
temp.Deadline = now;
temp.Status = this.ToDoListItem.Status;
temp.Description = this.ToDoListItem.Description;
temp.ToDoListId = _todoList.Id;
if (id == 0)
{
temp.CreateDate = DateTime.Now;
service.Add(temp);
}
service.SaveChanges();
ToDoListItems.Clear();
ToDoListItem = new ToDoListItemModel();
ToDoListItems.AddRange(GetAll(_todoList.Id));
});
}
private void Delete(object obj)
{
Helper.InvokeAction(() => {
System.Collections.IList items = (System.Collections.IList)obj;
var selectedItems = items.Cast <ToDoListItemModel>();
if (selectedItems.Count() == 0)
{
Helper.Error("Item not selected");
return;
}
int id = selectedItems.First().Id;
var temp = service.FirstOrDefault(x => x.Id == id);
if (temp == null)
{
Helper.Error("Item not found");
return;
}
service.Remove(temp);
service.SaveChanges();
ToDoListItems.Clear();
ToDoListItem = new ToDoListItemModel();
ToDoListItems.AddRange(GetAll(_todoList.Id));
});
}
public async Task Update_A_ToDoList_Item_that_Contains_One_character()
{
var data = new ToDoListItems
{
Id = "1",
Priority = "High",
Task = "a"
};
sut = await client.PutAsync(requestUri, new StringContent(JsonConvert.SerializeObject(data), Encoding.UTF8, "application/json"));
}
public async Task Invalid_Update_A_ToDoList_Item()
{
var data = new ToDoListItems
{
Id = "1",
Task = "tass",
Priority = "High"
};
sut = await client.PutAsync(requestUri, new StringContent(JsonConvert.SerializeObject(data), Encoding.UTF8, "application/json"));
}
public IActionResult PostToDoList([FromBody] ToDoListItems returnList)
{
metricsTracker.EventTracker("Event post successful");
if (returnList == null)
{
return(BadRequest());
}
toDoLisToDoRepository.InsertToDoList(returnList);
return(CreatedAtRoute("Get", returnList));
}
public void InsertToDoList(ToDoListItems toDoListItems)
{
var final = new ToDoListItems()
{
Id = toDoListItems.Id,
Priority = toDoListItems.Priority,
Status = toDoListItems.Status,
Task = toDoListItems.Task
};
ToDoListDataStore.Current.ToDoList.Add(final);
}
public async Task Add_Item_To_An_existing_List()
{
var data = new ToDoListItems
{
Id = "4",
Task = "added Via service Test",
Priority = "High",
Status = "Complete"
};
sut = await client.PutAsync(requestUri, new StringContent(JsonConvert.SerializeObject(data), Encoding.UTF8, "application/json"));
}
private void DeleteItem_Click(object sender, RoutedEventArgs e)
{
ToDoListEntities dbEntities = new ToDoListEntities();
var selected = lvToDoListItem.SelectedItems.Cast <Object>().ToArray();
foreach (var item in selected)
{
lvToDoListItem.Items.Remove(item);
ToDoListItems todo = dbEntities.ToDoListItems.Find(((ToDoList.Business.TodoListItems)item).ItemId);
todo.IsActive = "0";
dbEntities.SaveChanges();
}
}
public async Task SetUp()
{
var mockRepository = new Mock <IToDoRepository>();
var metricsMock = new Mock <IMetricsTrackerRepository>();
var todolist = new ToDoListItems
{
Id = "1",
Priority = "Priority",
Task = "Task"
};
mockRepository.Setup(x => x.GetById(It.Is <string>(i => i == "1".ToString()))).Returns(Task.FromResult(todolist));
mockRepository.Setup(x => x.UpdateToDoList(It.Is <string>(i => i == "1"), It.IsAny <PartialToDoItems>()));
sut = new ToDoListController(mockRepository.Object, metricsMock.Object);
}
public void WhenTheTaskDoesNotYetExist()
{
var todolist = new ToDoListItems
{
Id = "4",
Priority = "high",
Status = "Done",
Task = "do this test"
};
var todoMock = new Mock <IToDoRepository>();
var metricsMock = new Mock <IMetricsTrackerRepository>();
todoMock.Setup(x => x.InsertToDoList(todolist));
var controller = new ToDoListController(todoMock.Object, metricsMock.Object);
result = controller.PostToDoList(todolist);
}
public async Task Update_A_ToDoList_Item_that_Contains_250_character()
{
var data = new ToDoListItems
{
Id = "1",
Priority = "High",
Task = "jdhlkjagdjahglkjdgakjgdkj" +
"agdkjgakjgdkajgdkjgakdjga" +
"kgdkjagkjgadkjga" +
"kdjakjgdjdhlkjagdjahglkjdga" +
"kjgdkjagdkjgakjgdkajgdkjgak" +
"djgakgdkjagkjgadkjgakdjakjgdjdh" +
"lkjagdjahglkjdgakjgdkjagdkjgakjg" +
"dkajgdkjgakdjgakgdkjagkjgadkjgakdjakj" +
"gdakgdkjagkjgadkjgakdjakjgdsss"
};
sut = await client.PutAsync(requestUri, new StringContent(JsonConvert.SerializeObject(data), Encoding.UTF8, "application/json"));
}
public void AddToDoListItems(string _ListItemName, string _Descrption, DateTime _Deadline, int _listId)
{
try
{
using (ToDoListEntities dbEntities = new ToDoListEntities())
{
ToDoListItems todo = new ToDoListItems();
todo.ListItemName = _ListItemName.Trim();
todo.Description = _Descrption.Trim();
todo.Deadline = _Deadline;
todo.ListId = _listId;
todo.IsActive = "1";
dbEntities.ToDoListItems.Add(todo);
dbEntities.SaveChanges();
MessageBox.Show("Adding Success!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("Adding Failed!", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public async Task <Document> InsertToDoList(ToDoListItems toDoListItems)
{
return(await _client.CreateDocumentAsync(UriFactory.CreateDocumentCollectionUri("ToDoList", "Items"), toDoListItems));
}
