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