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