public static NgField2 GetField(string strMenu, string strForm, string strField, NgProject2 pr)
{
NgField2 res = new NgField2("");
foreach (var mn in pr.Menues)
{
if (mn.Name == strMenu)
{
foreach (var s in mn.Submenues)
{
if (s.Name == strForm)
{
foreach (var f in s.Model.Fields)
{
if (f.DisplayName == strField)
{
res = f;
return(res);
}
}
}
}
}
}
return(res);
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
level = e.Node.Level;
if (level == 0)
{
selectedMenuName = e.Node.Text;
var mn = CommonFunctions.GetMenu(selectedMenuName, pr);
selectedMenu = mn;
}
if (level == 1)
{
selectedFormName = e.Node.Text;
selectedMenuName = e.Node.Parent.Text;
Menues = pr.MenuesList;
var fr = CommonFunctions.GetForm(selectedMenuName, selectedFormName, pr);
selectedForm = fr;
fr.refF = this;
this.propertyGrid1.SelectedObject = fr;
}
if (level == 2)
{
selectedFormName = e.Node.Parent.Text;
selectedMenuName = e.Node.Parent.Parent.Text;
selectedFieldName = e.Node.Text;
var fl = CommonFunctions.GetField(selectedMenuName, selectedFormName, selectedFieldName, pr);
selectedField = fl;
fl.refF = this;
Tabs = selectedForm.TabNameList;
ComboService = pr.ComboServiceList;
RadioButtonService = pr.RadioButtonServiceList;
propertyGrid1.SelectedObject = fl;
}
}
public static NgField2 GetField(NgSubMenu2 ss, string name)
{
NgField2 xx = new NgField2();
try
{
xx = ss.Model.Fields.Single(x => x.OriginalName == name);
return(xx);
}
catch
{
return(null);
}
}
public static void CopyField(NgField2 f1, NgField2 dest)
{
dest.ComboBoxSource = f1.ComboBoxSource;
dest.ComboxBox = f1.ComboxBox;
dest.ControlType = f1.ControlType;
dest.DisplayName = f1.DisplayName;
dest.ErrorMessage = f1.ErrorMessage;
dest.IncludeInSearch = f1.IncludeInSearch;
dest.SearchCondition = f1.SearchCondition;
dest.Index = f1.Index;
dest.IsPrimaryKey = f1.IsPrimaryKey;
dest.IsValidationRequired = f1.IsValidationRequired;
dest.Length = f1.Length;
dest.NetType = f1.NetType;
dest.OriginalName = f1.OriginalName;
dest.RadioBoxSource = f1.RadioBoxSource;
dest.RadioButton = f1.RadioButton;
dest.refF = f1.refF;
dest.TabName = f1.TabName;
dest.TabsRequired = f1.TabsRequired;
dest.ToDisplayInControls = f1.ToDisplayInControls;
dest.ToDisplayInGrid = f1.ToDisplayInGrid;
dest.Type = f1.Type;
}
public override TypeConverter.StandardValuesCollection GetStandardValues(ITypeDescriptorContext context)
{
NgField2 refMyObject = context.Instance as NgField2;
return(new StandardValuesCollection(refMyObject.refF.Tabs));
}
public static NgProject2 ToNgProgect2(NgProject ng1)
{
NgProject2 ng = new NgProject2();
if (ng1.Name == null || ng1.Name.Trim().Length == 0)
{
ng.Name = "Tables";
}
else
{
ng.Name = ng1.Name;
}
ng.Name = ng1.Name;
ng.Path = ng1.Path;
ng.MenuesList.Clear();
ng.NetProject.DataBaseConnectionString = ng1.NetProject.DataBaseConnectionString;
foreach (var ss in ng1.RadiosList)
{
NgRadio ch = new NgRadio();
ch.Name = ss.Name;
foreach (var op in ss.Options)
{
NGOPT op1 = new NGOPT();
op1.Key = op.Key;
op1.Value = op.Value;
ch.Options.Add(op1);
}
ng.RadiosList.Add(ch);
}
foreach (var ss in ng1.CombosList)
{
NGCombo cb = new NGCombo();
cb.ServiceName = ss.ServiceName;
cb.IsFixed = ss.IsFixed;
cb.Name = ss.Name;
cb.Key = ss.Key;
cb.Value = ss.Value;
foreach (var op in ss.Options)
{
NGOPT op1 = new NGOPT();
op1.Key = op.Key;
op1.Value = op.Value;
cb.Options.Add(op1);
}
ng.CombosList.Add(cb);
}
foreach (string ss in ng1.MenuesList)
{
ng.MenuesList.Add(ss);
}
foreach (var mn1 in ng1.Menues)
{
NgMenu2 mn = new NgMenu2();
mn.Index = mn1.Index;
mn.Name = mn1.Name;
foreach (var s1 in mn1.Submenues)
{
NgSubMenu2 s = new NgSubMenu2();
foreach (var ts in s1.TabNameList)
{
s.TabNameList.Add(ts);
}
s.NetClassName = s1.NetClassName;
s.CreateThisForm = s1.CreateThisForm;
s.AllowAddNewFeature = s1.AllowAddNewFeature;
s.AllowEditFeature = s1.AllowEditFeature;
s.AllowMultiDelete = s1.AllowMultiDelete;
s.AllowDelete = s1.AllowDelete;
s.DeleteFormMessage = s1.DeleteFormMessage;
s.DeleteFormTitle = s1.DeleteFormTitle;
s.DisplayName = s1.DisplayName;
s.Index = s1.Index;
s.IsTabbed = s1.IsTabbed;
s.Menues = s1.Menues;
s.Name = s1.Name;
s.NumberOfRowsInPaging = s1.NumberOfRowsInPaging;
s.Tabs = ProcessTabs(s1);
NgFileProp2 m1 = new NgFileProp2();
m1.Name = s1.Model.Name;
foreach (var f1 in s1.Model.Fields)
{
NgField2 f = new NgField2();
f.IsIdentity = f1.IsIdentity;
f.DisplayName = f1.DisplayName;
f.ErrorMessage = f1.ErrorMessage;
f.IncludeInSearch = f1.IncludeInSearch;
f.SearchCondition = f1.SearchCondition;
f.Index = f1.Index;
f.IsValidationRequired = f1.IsValidationRequired;
f.OriginalName = f1.OriginalName;
f.TabName = f1.TabName;
f.TabsRequired = f1.TabsRequired;
f.ToDisplayInControls = f1.ToDisplayInControls;
f.ToDisplayInGrid = f1.ToDisplayInGrid;
f.Type = f1.Type;
f.Length = f1.Length;
f.NetType = f1.NetType;
f.ComboBoxSource = f1.ComboBoxSource;
f.RadioBoxSource = f1.RadioBoxSource;
f.ControlType = f1.ControlType;
f.IsPrimaryKey = f1.IsPrimaryKey;
m1.Fields.Add(f);
}
s.Model = m1;
mn.Submenues.Add(s);
}
ng.Menues.Add(mn);
}
return(ng);
}
public static NgSubMenu2 AttachSubMenu(NgTable t)
{
var sIndex = 0;
var fIndex = 0;
var tabIndex = 0;
var tabStr = "";
fIndex = 0;
NgSubMenu2 s = new NgSubMenu2(t.Name);
var cCount = t.Columns.Count;
if (cCount > 10)
{
s.IsTabbed = true;
}
s.CreateThisForm = true;
s.NumberOfRowsInPaging = 20;
s.AllowAddNewFeature = true;
s.AllowEditFeature = true;
s.AllowMultiDelete = true;
s.AllowDelete = true;
s.DeleteFormMessage = "Are you sure you want to delete this row?";
s.DeleteFormTitle = "Delete";
s.DisplayName = s.Name;
s.Menues = "Menu";
s.NetClassName = s.Name;
foreach (var c in t.Columns)
{
if (s.IsTabbed == true)
{
if (fIndex % 10 == 0)
{
tabIndex++;
tabStr = "Tab " + tabIndex.ToString();
s.Tabs.Add(tabStr);
}
}
NgField2 f = new NgField2();
if (s.IsTabbed == true)
{
f.TabName = tabStr;
}
if (!CommonFunctions.IsDuplicateFileds(s, c.Name))
{
fIndex++;
f.Index = fIndex;
f.DisplayName = c.Name;
f.OriginalName = c.Name;
f.Type = c.DataType;
f.Length = c.Length;
f.IsIdentity = c.IsAuto;
f.IsPrimaryKey = c.IsPrimary;
f.NetType = CommonFunctions.GetNetDataType(f.Type);
if (f.IsIdentity)
{
f.ToDisplayInControls = false;
}
if (f.NetType == "DateTime")
{
f.ControlType = ControlType.DatePicker;
}
else
{
f.ControlType = ControlType.TextBox;
}
if (c.IsNullable == false)
{
f.IsValidationRequired = true;
f.ErrorMessage = "Please enter the " + f.DisplayName;
}
if (c.IsAuto == true)
{
f.ToDisplayInControls = false;
}
else
{
f.ToDisplayInControls = true;
}
if (fIndex > 8)
{
f.ToDisplayInGrid = false;
}
else
{
f.ToDisplayInGrid = true;
}
s.Model.Fields.Add(f);
}
}
sIndex++;
s.Index = sIndex;
return(s);
}
private void toolStripMenuItem3_Click(object sender, EventArgs e)
{
var pr3 = new NgProject2();
var constr = CommonFunctions.GetFromReg(Constants.CONNECTIONSTRING);
if (constr != "")
{
var NewTables = DB.FetchDBSchema(constr);
var pr2 = new NgProject2();
NgMenu2 mn = new NgMenu2("Tables");
mn.Name = "Tables";
pr2 = SetTreeView1(mn, NewTables);
pr3.RadiosList = pr.RadiosList;
pr3.CombosList = pr.CombosList;
pr3.NetProject.DataBaseConnectionString = pr.NetProject.DataBaseConnectionString;
foreach (var xx in pr2.Menues)
{
var mn1 = new NgMenu2();
mn1.Name = Constants.MENUNAME;
mn1.Index = xx.Index;
foreach (var yy in xx.Submenues)
{
var sub1 = new NgSubMenu2();
var sub = CommonFunctions.GetSubMenu(pr, yy.Name);
if (sub != null)
{
CommonFunctions.CopySubMenu(sub, sub1);
var cf = 0;
foreach (var zz in yy.Model.Fields)
{
cf++;
var zz1 = CommonFunctions.GetField(sub, zz.OriginalName);
if (zz1 != null)
{
zz1.Length = zz.Length;
sub1.Model.Fields.Add(zz1);
}
else
{
sub1.Model.Fields.Add(zz);
}
}
mn1.Submenues.Add(sub1);
}
else
{
CommonFunctions.CopySubMenu(yy, sub1);
foreach (var zz in yy.Model.Fields)
{
var zz1 = new NgField2();
CommonFunctions.CopyField(zz, zz1);
zz1.Length = zz.Length;
sub1.Model.Fields.Add(zz1);
}
mn1.Submenues.Add(sub1);
}
}
pr3.Menues.Add(mn1);
}
}
pr = pr3;
SetTreeView();
MessageBox.Show("Done");
}
