/// <summary> /// Constructor for ClsSimpleDataSet object with the supplied DataSet /// Creates a new ClsSimpleDataSet with data populated from the dataset /// </summary> /// <param name="Ds"> /// The data set to be used /// </param> public SimpleDataSet(DataSet Ds) { foreach (DataTable Dt in Ds.Tables) { SimpleDataTable Sdt = new SimpleDataTable(Dt); this.mList_DataTable.Add(Sdt); } }
public String Load_TableDetails(Do_Constants.Str_Request_Session Request_Session, Do_Constants.Str_Request_Load Request_Load) { SimpleDataTable Rv = new SimpleDataTable(); Interface_DataAccess Da = Do_Methods.CreateDataAccess(); try { if (Do_Methods.Convert_String(Request_Load.ConnectionString) == "") { Da.Connect(); } else { Da.Connect(Request_Load.ConnectionString); } Rv = new SimpleDataTable(Da.Load_TableDetails(Request_Load.ObjectName, Request_Load.Key, Request_Load.Condition, Request_Load.ForeignKeys)); } catch (Exception Ex) { this.ErrorHandler(Ex, "WcfService.Method: Load_TableDetails"); } finally { Da.Close(); } return Rv.Serialize(); }
public String List_Empty(Do_Constants.Str_Request_Session Request_Session, Do_Constants.Str_Request_List Request_List) { SimpleDataTable Rv = new SimpleDataTable(); Interface_DataAccess Da = Do_Methods.CreateDataAccess(); try { if (Do_Methods.Convert_String(Request_List.ConnectionString) == "") { Da.Connect(); } else { Da.Connect(Request_List.ConnectionString); } DataTable Dt = Da.List_Empty(Request_List.ObjectName); Rv = new SimpleDataTable(Dt); } catch (Exception Ex) { this.ErrorHandler(Ex, "WcfService.Method: List_Empty"); } finally { Da.Close(); } return Rv.Serialize(); }
public String Load(Do_Constants.Str_Request_Session Request_Session, Do_Constants.Str_Request_Load Request_Load) { SimpleDataRow Rv = new SimpleDataRow(); Interface_DataAccess Da = Do_Methods.CreateDataAccess(); try { if (Do_Methods.Convert_String(Request_Load.ConnectionString) == "") { Da.Connect(); } else { Da.Connect(Request_Load.ConnectionString); } DataRow Dr = Da.Load(Request_Load.ObjectName, Request_Load.ObjectKeys, Request_Load.Key); SimpleDataTable Sds = new SimpleDataTable(Dr.Table.Clone()); Rv = Sds.NewRow(Dr); } catch (Exception Ex) { this.ErrorHandler(Ex, "WcfService.Method: Load"); } finally { Da.Close(); } return Rv.Serialize(); }
public String GetQuery(Do_Constants.Str_Request_Session Request_Session, Do_Constants.Str_Request_GetQuery Request_GetQuery) { SimpleDataTable Rv = new SimpleDataTable(); Interface_DataAccess Da = Do_Methods.CreateDataAccess(); try { if (Do_Methods.Convert_String(Request_GetQuery.ConnectionString) == "") { Da.Connect(); } else { Da.Connect(Request_GetQuery.ConnectionString); } DataTable Dt = null; if (Do_Methods.Convert_String(Request_GetQuery.Condition_String) != "") { Dt = Da.GetQuery( Request_GetQuery.ObjectName , Request_GetQuery.Fields , Request_GetQuery.Condition_String , Request_GetQuery.Sort); Rv = new SimpleDataTable(Dt); } else { Dt = Da.GetQuery( Request_GetQuery.ObjectName , Request_GetQuery.Fields , Request_GetQuery.Condition , Request_GetQuery.Sort , Request_GetQuery.Top , Request_GetQuery.Page); Rv = new SimpleDataTable(Dt); } } catch (Exception Ex) { this.ErrorHandler(Ex, "WcfService.Method: GetQuery"); } finally { Da.Close(); } return Rv.Serialize(); }