protected void Page_Init(object sender, EventArgs e)
{
mm = (MinMaster)Master;
factories = (List <IColumnFieldFactory>)Application["ColumnFieldFactories"];
int panelId = Int32.Parse(Page.RouteData.Values["panelId"] as string);
actPanel = mm.SysDriver.Panels[panelId];
DataColumnCollection cols = mm.Stats.ColumnTypes[actPanel.tableName];
// the field types - default and special subsets allowed for special data types - i.e. a foereign key cannot be edited via nothing but
// a FKFiels
string[] fieldTypes = new string[] { FieldTypes.ShortText.ToString(), FieldTypes.Bool.ToString(),
FieldTypes.Date.ToString(), FieldTypes.DateTime.ToString(), FieldTypes.Text.ToString() };
string[] EnumType = new string[] { FieldTypes.Enum.ToString() };
string[] FKtype = new string[] { FieldTypes.FK.ToString() };
string[] mappingType = new string[] { FieldTypes.M2NMapping.ToString() };
string[] validationRules = Enum.GetNames(typeof(ValidationRules));
//possible bugpoing (see repo)
// a FKField can be only required - let referential integrity take care of the rest
string[] requiredRule = new string[] { Enum.GetName(typeof(ValidationRules), ValidationRules.Required) };
FKs = mm.Stats.FKs[actPanel.tableName];
mappings = new List <M2NMapping>();
mappings = mm.Stats.Mappings[actPanel.tableName];
panelName.Text = actPanel.panelName;
// create a datarow for each column, specifiing...
foreach (DataColumn col in cols) // std. fields (incl. FKs)
{
IColumnField cf = (IColumnField)actPanel.fields.Find(x => x is IColumnField && ((IColumnField)x).ColumnName == col.ColumnName);
TableRow r = new TableRow();
r.ID = col.ColumnName;
//...the name,...
TableCell nameCell = new TableCell();
Label nameLabel = new Label();
nameLabel.Text = col.ColumnName;
nameCell.Controls.Add(nameLabel);
r.Cells.Add(nameCell);
//...whether the column will be accessible to editation at all,...
TableCell presentCell = new TableCell();
CheckBox present = new CheckBox();
present.Checked = cf != null;
presentCell.Controls.Add(present);
r.Cells.Add(presentCell);
FK fk = FKs.Find(x => x.myColumn == col.ColumnName);
if (cf != null && cf is FKField)
{
fk = ((FKField)cf).FK;
}
//...the FieldType,...
TableCell typeCell = new TableCell();
DropDownList dl = new DropDownList();
Dictionary <int, string> typeOptions = new Dictionary <int, string>();
int current = -1;
for (int i = 0; i < factories.Count; i++)
{
if (factories[i].CanHandle(col))
{
typeOptions.Add(i, factories[i].UIName);
}
if (cf != null && cf.GetType() == (factories[i].ProductionType))
{
current = typeOptions.Count - 1;
}
}
dl.DataSource = typeOptions;
dl.DataValueField = "Key";
dl.DataTextField = "Value";
dl.DataBind();
dl.SelectedIndex = current;
typeCell.Controls.Add(dl);
r.Cells.Add(typeCell);
//...what column of the referred table to display in the dropdown
TableCell FKDisplayCell = new TableCell();
// set default value if the field was originally present in the editation form
if (fk != null)
{
DropDownList fkddl = new DropDownList();
fkddl.DataSource = mm.Stats.ColumnsToDisplay[fk.refTable];
fkddl.DataBind();
if (cf != null)
{
fkddl.SelectedIndex = fkddl.Items.IndexOf(fkddl.Items.FindByValue(((FKField)cf).FK.displayColumn));
}
FKDisplayCell.Controls.Add(fkddl);
}
r.Cells.Add(FKDisplayCell);
//PBPR
//...the validation rules...
TableCell validCell = new TableCell();
CheckBox requiredCb = new CheckBox();
Label requiredlabel = new Label();
requiredlabel.Text = "required ";
CheckBox uniCheck = new CheckBox();
Label uniLabel = new Label();
uniLabel.Text = "unique";
if (cf != null)
{
requiredCb.Checked = cf.Required;
uniCheck.Checked = cf.Unique;
}
if (!(cf is CheckBoxField))
{
validCell.Controls.Add(requiredlabel);
validCell.Controls.Add(requiredCb);
validCell.Controls.Add(uniLabel);
validCell.Controls.Add(uniCheck);
}
r.Cells.Add(validCell);
//...and the caption
TableCell captionCell = new TableCell();
TextBox caption = new TextBox();
captionCell.Controls.Add(caption);
r.Cells.Add(captionCell);
if (cf != null)
{
caption.Text = cf.Caption;
}
// index 6
tbl.Rows.Add(r);
}
// mappings will get a similiar table, but some collumns (like validation) will just be left empty
foreach (M2NMapping mapping in mappings)
{
M2NMappingField f = actPanel.fields.Find(
x => x is M2NMappingField && ((M2NMappingField)x).Mapping.myColumn == mapping.myColumn) as M2NMappingField;
TableRow r = new TableRow();
TableCell nameCell = new TableCell();
Label nameLabel = new Label();
nameLabel.Text = mapping.myTable + " to " + mapping.refTable + " via " + mapping.mapTable;
nameCell.Controls.Add(nameLabel);
r.Cells.Add(nameCell);
TableCell presentCell = new TableCell();
CheckBox present = new CheckBox();
present.Checked = f != null;
presentCell.Controls.Add(present);
r.Cells.Add(presentCell);
TableCell typeCell = new TableCell();
DropDownList dl = new DropDownList();
dl.DataSource = mappingType;
dl.DataBind();
typeCell.Controls.Add(dl);
r.Cells.Add(typeCell);
TableCell displayCell = new TableCell();
DropDownList displayDrop = new DropDownList();
displayDrop.DataSource = mm.Stats.ColumnsToDisplay[mapping.refTable];
displayDrop.DataBind();
if (f != null)
{
displayDrop.SelectedIndex = displayDrop.Items.IndexOf(displayDrop.Items.FindByValue(f.Mapping.displayColumn));
}
displayCell.Controls.Add(displayDrop);
r.Cells.Add(displayCell);
TableCell validCell = new TableCell(); // leave it empty
r.Cells.Add(validCell);
TableCell captionCell = new TableCell();
TextBox caption = new TextBox();
captionCell.Controls.Add(caption);
r.Cells.Add(captionCell);
if (f != null)
{
caption.Text = f.Caption;
}
mappingsTbl.Rows.Add(r);
}
// what can be done with the panel
string[] actionTypes = new string[] { UserAction.Insert.ToString(),
UserAction.Update.ToString(),
UserAction.Delete.ToString() }; // controls
List <string> activeActions = (from _min.Models.Control control in actPanel.controls
select Enum.GetName(typeof(UserAction), control.action)).ToList <string>();
actions.SetOptions(new List <string>(actionTypes));
actions.SetIncludedOptions(activeActions);
backButton.PostBackUrl = backButton.GetRouteUrl("ArchitectShowRoute", new { projectName = mm.ProjectName });
}
protected void SaveButton_Click(object sender, EventArgs e)
{
// extract the data for fields from the table
List <IField> fields = new List <IField>();
int i = 1;
Dictionary <DataColumn, Dictionary <string, object> > customs = new Dictionary <DataColumn, Dictionary <string, object> >();
foreach (DataColumn col in mm.Stats.ColumnTypes[actPanel.tableName])
{ // standard fields
TableRow r = tbl.Rows[i++];
if (!((CheckBox)r.Cells[1].Controls[0]).Checked)
{
continue;
}
// label, present, type, valid, caption
IColumnFieldFactory factory = factories[Int32.Parse(((DropDownList)r.Cells[2].Controls[0]).SelectedValue)];
// cell 3 is there for FK display column dropList
bool required = false;
bool unique = false;
if (r.Cells[4].Controls.Count == 4)
{
CheckBox reqChb = (CheckBox)r.Cells[4].Controls[1];
CheckBox uniChb = (CheckBox)r.Cells[4].Controls[3];
required = reqChb.Checked;
unique = uniChb.Checked;
}
string caption = ((TextBox)r.Cells[5].Controls[0]).Text;
if (caption == "")
{
caption = null;
}
if (factory is ICustomizableColumnFieldFactory)
{
customs[col] = new Dictionary <string, object>();
customs[col]["factory"] = factory.Clone(); // so that each field gets its factory even if there more custom fields of the same type
customs[col]["required"] = required;
customs[col]["unique"] = unique;
customs[col]["caption"] = caption;
continue;
}
IField newField;
//PBPR
// react to the changes to the displaycolumn for the FK
if (col.ExtendedProperties.Contains("FK"))
{
FK colFK = (FK)(col.ExtendedProperties["FK"]);
colFK.displayColumn = ((DropDownList)(r.Cells[3].Controls[0])).SelectedValue;
col.ExtendedProperties["FK"] = colFK;
}
newField = factory.Create(col);
newField.Caption = caption;
newField.Required = required;
if (newField is IColumnField)
{
((IColumnField)newField).Unique = unique;
}
fields.Add(newField);
}
i = 1;
foreach (M2NMapping mapping in mappings)
{ // mappings
TableRow r = mappingsTbl.Rows[i++];
// label, present, type (mappingType), valid (req?), caption
if (!((CheckBox)r.Cells[1].Controls[0]).Checked)
{
continue;
}
// must be mappingType...
List <ValidationRules> rules = new List <ValidationRules>();
// no validation for a mapping
mapping.displayColumn = ((DropDownList)(r.Cells[3].Controls[0])).SelectedValue;
string caption = ((TextBox)r.Cells[5].Controls[0]).Text;
M2NMappingField m2nf = new M2NMappingField(mapping, caption);
fields.Add(m2nf);
}
// crate a control for each checked action
List <_min.Models.Control> controls = new List <_min.Models.Control>(); // controls
bool valid = true;
List <string> errorMsgs = new List <string>();
if (actions.RetrieveStringData().Count == 0)
{
valid = false;
errorMsgs.Add("Choose at least one action for the panel, please.");
}
foreach (string actionString in actions.RetrieveStringData())
{
_min.Models.Control c = new _min.Models.Control(0, actionString,
(UserAction)Enum.Parse(typeof(UserAction), actionString));
c.targetPanel = actPanel.controls[0].targetPanel;
c.targetPanelId = actPanel.controls[0].targetPanelId; // a miserable way to find out the target panel...really
controls.Add(c);
}
MPanel resPanel = new MPanel(actPanel.tableName, actPanel.panelId, PanelTypes.Editable, new List <MPanel>(),
fields, controls, actPanel.PKColNames, null, actPanel.parent);
resPanel.panelName = panelName.Text;
valid = valid && mm.Architect.checkPanelProposal(resPanel, out errorMsgs, customs);
// validate the Panel using Architect`s validator - don`t edit PKs, unique columns must have the constraint, must contain all collumns except Nullable
// and AI and more rules
validationResult.Items.Clear();
if (valid)
{
if (customs.Count == 0)
{
validationResult.Items.Add(new ListItem("Valid"));
actPanel = resPanel;
mm.SysDriver.BeginTransaction();
mm.SysDriver.UpdatePanel(actPanel);
Session.Clear();
mm.SysDriver.IncreaseVersionNumber();
mm.SysDriver.CommitTransaction();
validationResult.Items.Add(new ListItem("Saved"));
Response.Redirect(Page.Request.RawUrl);
}
else
{
Session["interPanel"] = resPanel;
Session["customs"] = customs;
Response.RedirectToRoute("ArchitectEditEditableCustomRoute", new { projectName = CE.project.Name, panelId = actPanel.panelId });
// for the sake of unity (and SysDriver)
}
}
else
{
foreach (string s in errorMsgs)
{
validationResult.Items.Add(new ListItem(s));
}
}
}
