public async Task <IActionResult> Edit(int id, [Bind("Id,UserAccountId")] TableTask tableTask)
{
if (id != tableTask.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tableTask);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TableTaskExists(tableTask.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["UserAccountId"] = new SelectList(_context.UserAccounts, "Id", "Id", tableTask.UserAccountId);
return(View(tableTask));
}
public async Task <IActionResult> Create([Bind("Id,UserAccountId")] TableTask tableTask)
{
if (ModelState.IsValid)
{
_context.Add(tableTask);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["UserAccountId"] = new SelectList(_context.UserAccounts, "Id", "Id", tableTask.UserAccountId);
return(View(tableTask));
}
private UserAccount GetUser()
{
var userId = _userManager.GetUserId(User);
if (userId != null && userId.Length > 0)
{
UserAccount user;
var userAccounts = from u in _context.UserAccounts
select u;
userAccounts = userAccounts.Where(u => u.UserId.Equals(userId));
if (userAccounts.Any())
{
user = userAccounts.First();
}
else
{ // Create User & TableTask
user = new UserAccount {
UserId = userId
};
_context.Add(user);
_context.SaveChanges();
var tabletask = new TableTask
{
UserAccount = user,
UserAccountId = user.Id,
DailyTasks = new List <DailyTask>()
};
_context.Add(tabletask);
user.TableTask = tabletask;
user.TableTaskId = tabletask.Id;
_context.Update(user);
_context.SaveChanges();
}
return(user);
}
else
{
return(null);
}
}
private TableTask GetTable()
{
UserAccount u = GetUser();
if (u != null)
{
TableTask tt = _context.TableTasks.
Where(tt => tt.UserAccountId.Equals(u.Id)).First();
_context.Entry(tt).Collection(p => p.DailyTasks).Load();
return(tt);
}
else
{
return(null);
}
}
private void button_add_Click(object sender, EventArgs e)
{
List <TableTask> listGrid = new List <TableTask>();
using (DBConnect db = new DBConnect())
{
int hour = Int32.Parse(numericUpDown_hour.Value.ToString());
int minutes = Int32.Parse(numericUpDown_minunes.Value.ToString());
bool every_day = false;
if (checkBox1.Checked)
{
every_day = true;
}
DateTime date = DateTime.Now;
if (textBox_event.Text != String.Empty)
{
TableTask task = new TableTask()
{
Date = dateTime_Date.Value,
Time = new DateTime(date.Year, date.Month, date.Day, hour, minutes, 0),
Work = textBox_event.Text,
Information = textBox_inform.Text,
EveryDay = every_day
};
db.AllWork.Add(task);
db.SaveChanges();
}
else
{
MessageBox.Show("Введите событие: ");
}
foreach (var grid in db.AllWork)
{
listGrid.Add(grid);
}
}
MainForm.WriteDataGrid();
MainForm.ListGrid = listGrid;
this.Close();
}
