public GenericReply GetMenu(string name)
{
var reply = new GenericReply();
var menu = new Menu();
var menuItem1 = new Menu();
var menuItem2 = new Menu();
menuItem1.Text = "Text1";
menuItem1.Description = "Description1";
menuItem1.Type = "EditMaster";
menuItem1.Command = "CUSTOMER";
menuItem2.Text = "Text2";
menuItem2.Description = "Description2";
menuItem2.Type = "EditMaster";
menuItem2.Command = "SALDOC";
var list = new List <Menu>();
list.Add(menuItem1);
list.Add(menuItem2);
reply.data = list;
return(reply);
}
private GenericReply GetBrowserData()
{
GenericReply reply = new GenericReply();
var fields = new List <string>()
{
"ROOMS.ID",
"ROOMS.NAME",
"ROOMS.BUILDINGID",
"ROOMS.BUILDINGID_BUILDINGS_NAME",
"ROOMS.BUILDINGID_BUILDINGS_ADDRESS",
"ROOMS.ALTERNATEBUILDINGID",
"ROOMS.ALTERNATEBUILDINGID_BUILDINGS_NAME",
"ROOMS.ALTERNATEBUILDINGID_BUILDINGS_ADDRESS"
};
D.Models.Interfaces.NavigableDbContext navigableDbContext = new Models.Interfaces.NavigableDbContext(db);
D.Models.Interfaces.DatabaseGossiper databaseGossiper = new Models.Interfaces.DatabaseGossiper(navigableDbContext);
D.Models.Interfaces.QueryBuilder qb = new D.Models.Interfaces.QueryBuilder(databaseGossiper);
var q = qb.BuildBasicQuery(fields);
D.Models.Interfaces.DatabaseCommander dc = new Models.Interfaces.DatabaseCommander();
db.Database.SqlQuery <object>(q);
var o = dc.ExecuteSql(q);
reply.data = o;
return(reply);
}
public GenericReply GetViewerDesign()
{
var reply = new GenericReply();
var design = new ViewerDesign();
var field1 = new Field();
var field2 = new Field();
var formField1 = new FormField();
var formField2 = new FormField();
var formContainer1 = new FormContainer();
field1.name = "ROOMS.ID";
field1.type = "int";
field2.name = "ROOMS.NAME";
field2.type = "string";
formField1.name = "ROOMS.ID";
formField1.xtype = "s1textfield";
formField1.visible = true;
formField1.flex = 2;
formField2.name = "ROOMS.NAME";
formField2.xtype = "s1textfield";
formField2.visible = true;
formField2.flex = 5;
formContainer1.name = "";
formContainer1.xtype = "s1cont";
formContainer1.visible = true;
formContainer1.items = new List <IRenderable>()
{
formField1,
formField2
};
var model = new Model();
model.relationship = "OneToOne";
model.fields = new List <Field>()
{
field1,
field2
};
design.model = new Dictionary <string, Model>();
design.model.Add("ROOMS", model);
design.form = new List <IRenderable>()
{
formContainer1
};
reply.data = design;
return(reply);
}
public GenericReply GetListDesign()
{
var reply = new GenericReply();
var design = new ListDesign();
var field1 = new Field();
var field2 = new Field();
var field3 = new Field();
var field4 = new Field();
field1.name = "ROOMS.ID";
field1.type = "int";
field2.name = "ROOMS.NAME";
field2.type = "string";
field3.name = "ROOMS.BUILDINGID_BUILDINGS_NAME";
field3.type = "string";
field4.name = "ROOMS.BUILDINGID_BUILDINGS_ADDRESS";
field4.type = "string";
design.fields = new List <Field>()
{
field1,
field2,
field3,
field4
};
var column1 = new Column();
var column2 = new Column();
var column3 = new Column();
var column4 = new Column();
column1.dataIndex = "ROOMS.ID";
column1.header = "ROOMS.ID";
column2.dataIndex = "ROOMS.NAME";
column2.header = "ROOMS.NAME";
column3.dataIndex = "ROOMS.BUILDINGID_BUILDINGS_NAME";
column3.header = "ROOMS.BUILDINGID_BUILDINGS_NAME";
column4.dataIndex = "ROOMS.BUILDINGID_BUILDINGS_ADDRESS";
column4.header = "ROOMS.BUILDINGID_BUILDINGS_ADDRESS";
design.columns = new List <Column>()
{
column1,
column2,
column3,
column4
};
reply.data = design;
return(reply);
}
public GenericReply GetAccessRights()
{
var accessRightsReply = new AccessRightsReply();
var reply = new GenericReply();
reply.data = accessRightsReply;
return(reply);
}
private GenericReply GetViewerData()
{
// You can specify the Catalog, Schema, Table Name, Table Type to get
// the specified table(s).
// You can use four restrictions for Table, so you should create a 4 members array.
String[] tableRestrictions = new String[4];
// For the array, 0-member represents Catalog; 1-member represents Schema;
// 2-member represents Table Name; 3-member represents Table Type.
// Now we specify the Table Name of the table what we want to get schema information.
tableRestrictions[2] = "Rooms";
using (var conn = new System.Data.SqlClient.SqlConnection(@"Data Source=.\SQLEXPRESS; Initial Catalog=D;User Id=sa;password=prosvasis;"))
{
conn.Open();
try
{
System.Data.DataTable courseTableSchemaTable = conn.GetSchema("Tables", tableRestrictions);
System.Diagnostics.Debug.WriteLine("Schema Information of Course Tables:");
ShowDataTable(courseTableSchemaTable, 20);
System.Diagnostics.Debug.WriteLine("");
} catch (Exception x)
{
}
}
using (var conn = new System.Data.SqlClient.SqlConnection(@"Data Source=.\SQLEXPRESS; Initial Catalog=D;User Id=sa;password=prosvasis;"))
{
string[] restrictions = new string[4] {
null, null, "rooms", null
};
conn.Open();
try
{
var columnList = conn.GetSchema("Columns", restrictions).AsEnumerable().Select(s => s.Field <String>("Column_Name")).ToList();
}
catch (Exception exc)
{
}
}
GenericReply reply = new GenericReply();
var fields = new List <string>()
{
"ROOMS.ID",
"ROOMS.NAME",
"ROOMS.BUILDINGID",
"ROOMS.BUILDINGID_BUILDINGS_NAME",
"ROOMS.BUILDINGID_BUILDINGS_ADDRESS",
"ROOMS.ALTERNATEBUILDINGID",
"ROOMS.ALTERNATEBUILDINGID_BUILDINGS_NAME",
"ROOMS.ALTERNATEBUILDINGID_BUILDINGS_ADDRESS"
};
D.Models.Interfaces.NavigableDbContext navigableDbContext = new Models.Interfaces.NavigableDbContext(db);
D.Models.Interfaces.DatabaseGossiper databaseGossiper = new Models.Interfaces.DatabaseGossiper(navigableDbContext);
D.Models.Interfaces.QueryBuilder qb = new D.Models.Interfaces.QueryBuilder(databaseGossiper);
var q = qb.BuildBasicQuery(fields);
q = q + " where ROOMS.ID = 1";
D.Models.Interfaces.DatabaseCommander dc = new Models.Interfaces.DatabaseCommander();
var o = dc.ExecuteSql(q);
reply.data = o;
var data = new ViewerData();
data.Data = new Dictionary <string, List <Dictionary <string, object> > >();
data.Data.Add("ROOMS", new List <Dictionary <string, object> >()
{
new Dictionary <string, object>()
{
{
"ID",
"1"
},
{
"NAME",
"AAAAAAAA"
}
}
});
reply.data = data.Data;
return(reply);
}
