protected void ButtonCreateNew_Click(object sender, EventArgs e)
{
if (TextCreateNew.Text.Trim() == string.Empty)
{
return;
}
var table = _dal.GetInvestigations();
int maId;
if (table.Rows.Count == 0)
{
maId = 0;
}
else
{
maId = (int)table.Compute("max(" + table.investigation_idColumn.ColumnName + ")", string.Empty);
}
maId++;
table.AddinvestigationRow(maId, TextCreateNew.Text.Trim());
_dal.Save(table);
PopulateInvestigations();
_investigationId = maId;
DropInvestigations.SelectedValue = maId.ToString();
ButtonLoad_Click(sender, e);
}
private void PopulateInvestigations()
{
var dalInv = new InvestigationManager();
DropInvestigations.Items.Clear();
var table = dalInv.GetInvestigations();
DropInvestigations.DataSource = table;
DropInvestigations.DataTextField = table.investigation_titleColumn.ColumnName;
DropInvestigations.DataValueField = table.investigation_idColumn.ColumnName;
DropInvestigations.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
var dal = new InvestigationManager();
var table = dal.GetInvestigations();
DropInvestigations.DataSource = table;
DropInvestigations.DataTextField = table.investigation_titleColumn.ColumnName;
DropInvestigations.DataValueField = table.investigation_idColumn.ColumnName;
DropInvestigations.DataBind();
}
private void PopulateInvestigations()
{
DropInvestigations.Items.Clear();
var table = _dal.GetInvestigations();
if (table.FindByinvestigation_id(0) == null)
{
table.AddinvestigationRow(0, "(all)");
}
DropInvestigations.DataSource = table;
DropInvestigations.DataTextField = table.investigation_titleColumn.ColumnName;
DropInvestigations.DataValueField = table.investigation_idColumn.ColumnName;
DropInvestigations.DataBind();
DropInvestigations.SelectedValue = "0";
}
