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