private static void GetCommand(SqlCommand command1, List<Task> taskListFalse)
{
using (SqlDataReader dr = command1.ExecuteReader())
{
while (dr.Read())
{
Task newItem = new Task();
newItem.id = dr.GetInt32(0);
newItem.name = dr.GetString(1);
newItem.text = dr.GetString(2);
newItem.TaskBegin = dr.GetDateTime(3);
newItem.TaskEnd = dr.GetDateTime(4);
newItem.TaskAdded = dr.GetDateTime(5);
//newItem.done = Convert.ToBoolean(dr.GetByte(6));
//newItem.delete = Convert.ToBoolean(dr.GetByte(7));
newItem.done = dr.GetBoolean(6);
newItem.delete = dr.GetBoolean(7);
//newItem.done = dr.GetByte(6);
//newItem.delete = dr.GetByte(7);
taskListFalse.Add(newItem);
}
}
}
public ActionResult Add(Task task)
{
if (String.IsNullOrEmpty(task.name))
ModelState.AddModelError("Name", "Введите свое name");
if (String.IsNullOrEmpty(task.text))
ModelState.AddModelError("Text", "Введите свое text");
if (ModelState.IsValid)
{
MyDBDataContext db = new MyDBDataContext();
MyTable125 item = new MyTable125
{
name = task.name,
text = task.text,
TaskAdded = DateTime.Now,
TaskBegin = task.TaskBegin,
TaskEnd = task.TaskEnd,
delete = false
};
//item.done = !flagDone;
db.MyTable125.InsertOnSubmit(item);
db.SubmitChanges();
return RedirectPermanent("/Home/Index");
}
else
// Обнаружена ошибка проверки достоверности
return RedirectPermanent("/Home/Index");
return RedirectPermanent("/Home/Index");
//return View();
}
public ActionResult ShowDD(Task model)
{
return View();
}