public async Task <Models.Column> GetColumnById(int id) { var columnDb = await _databaseContext.Columns.FindAsync(id); var result = new Models.Column() { Id = columnDb.Id, Title = columnDb.Title, }; return(result); }
/// Cards public void AddCard(AddCard viewModel) { var board = dbContext.Boards.Include(b => b.Columns).SingleOrDefault(x => x.Id == viewModel.Id); // If there is no Column on the Board, create one var firstColumn = board.Columns.FirstOrDefault(); if (firstColumn == null) { firstColumn = new Models.Column { Title = "ToDo" }; board.Columns.Add(firstColumn); } firstColumn.Cards.Add(new Models.Card { Contents = viewModel.Contents }); dbContext.SaveChanges(); }
public void AddCard(AddCard viewModel) { var board = _dbContext.Boards .Include(b => b.Columns) .SingleOrDefault(x => x.Id == viewModel.Id); if (board != null) { var firstColumn = board.Columns.FirstOrDefault(); var secondColumn = board.Columns.FirstOrDefault(); var thirdColumn = board.Columns.FirstOrDefault(); if (firstColumn == null || secondColumn == null || thirdColumn == null) { firstColumn = new Models.Column { Title = "Todo" }; secondColumn = new Models.Column { Title = "Doing" }; thirdColumn = new Models.Column { Title = "Done" }; board.Columns.Add(firstColumn); board.Columns.Add(secondColumn); board.Columns.Add(thirdColumn); } firstColumn.Cards.Add(new Models.Card { Contents = viewModel.Contents }); } _dbContext.SaveChanges(); }
public static bool IsNString(this Models.Column column) => column?.DataType.IsNString() == true;
public static bool IdentityNone(this Models.Column obj) => obj?.Identity == IdentityTypeConstants.None;
public static bool IdentityDatabase(this Models.Column obj) => obj?.Identity == IdentityTypeConstants.Database;
public Task <int> AddColumn(Models.Column column) { throw new System.NotImplementedException(); }
protected void btnsave_Click(object sender, EventArgs e) { if (Request["type"] == "Edit") { long Id = Convert.ToInt64(Request["ID"]); var item = db.Find(Id); if (item != null) { item.Title = txtbt.Text; item.Orders = Convert.ToInt32(txtorders.Text); item.Type = ddltype.SelectedValue; item.PID = ddlflm.SelectedValue != "" ? Convert.ToInt64(ddlflm.SelectedValue) : 0; if (item.PID > 0) { var Pitem = db.Find(item.PID); item.GID = Pitem.GID == 0 ? Pitem.ID : Pitem.GID; } else { item.GID = 0; } if (db.Edit(item)) { Page.ClientScript.RegisterStartupScript(GetType(), "e1", "edOK();", true); } else { Page.ClientScript.RegisterStartupScript(GetType(), "e2", "layer.alert('修改失败');", true); } } else { //找不到数据就返回列表 Response.Redirect("LinksListPG.aspx"); } } else { Models.Column item = new Models.Column(); item.Title = txtbt.Text; item.Orders = Convert.ToInt32(txtorders.Text); item.Type = ddltype.SelectedValue; item.PID = ddlflm.SelectedValue != "" ? Convert.ToInt64(ddlflm.SelectedValue) : 0; if (item.PID > 0) { var Pitem = db.Find(item.PID); item.GID = Pitem.GID == 0 ? Pitem.ID : Pitem.GID; } else { item.GID = 0; } if (db.Add(item)) { Page.ClientScript.RegisterStartupScript(GetType(), "a1", "adOK()", true); } else { Page.ClientScript.RegisterStartupScript(GetType(), "a2", "layer.alert('添加失败');", true); } } }