public static List <T> JsonSourceList <T>(string JsonSource, string ddlType, string action)
{ // tempraryly
var myList = new CommonOperate <T>();
var parameter = new { Operate = "Json", Type = ddlType, Action = action };
return(myList.ListOfT(action, parameter));
}
public static T ValueOfT(string db, string SP, object parameter)
{
try
{
var myvalue = new CommonOperate <T>();
return(myvalue.ValueOfT(db, SP, parameter));
}
catch
{
throw;
}
}
public static List <T> ListOfT(string db, string SP, object parameter, string DapparCommandType)
{
try
{
var mylist = new CommonOperate <T>();
return(mylist.ListOfT(db, SP, parameter, DapparCommandType));
}
catch
{
throw;
}
}
public static T ValueOfT(string SP, object parameter, string DapparCommandType)
{
try
{
var myvalue = new CommonOperate <T>();
return(myvalue.ValueOfT(SP, parameter, DapparCommandType));
}
catch
{
throw;
}
}
public static String ValueOfString(string SP, object parameter)
{
try
{
var myvalue = new CommonOperate <string>();
return(myvalue.ValueOfT(SP, parameter));
}
catch
{
throw;
}
}
/// <summary>
///
/// </summary>
/// <param name="SP"> store procedure name and @parameters, for example dbo.tcdsb_LTO_PageGeneral_List @Operate,@Para1,@Para1,@Para2,@Para3</param>
/// <param name="parameter"> store procedure parameters data object. for example List2Item { Operate = "PostingRound", Para0 = "20192020", Para1 = "0529" }</param>
/// <returns> general list of T class type </returns>
public static List <T> ListOfT(string SP, object parameter)
{
try
{
var mylist = new CommonOperate <T>();
return(mylist.ListOfT(SP, parameter));
}
catch
{
throw;
}
}
public static List <T> CommonList <T>(string sp, object parameter)
{
try
{
string fsp = CheckParamerters(sp, parameter);
var myList = new CommonOperate <T>();
return(myList.ListOfT(fsp, parameter));
}
catch
{
throw;
}
}
public static T CommonValue <T>(string db, string sp, object parameter)
{
try
{
// string sp = GetSP(action, "GeneralValue");
var myValue = new CommonOperate <T>();
return(myValue.ValueOfT(db, sp, parameter));
}
catch (Exception ex)
{
string em = ex.StackTrace;
throw;
}
}
public static List <T> CommonList <T>(string db, string sp, object parameter)
{
try
{
// string sp = GetSP(action,"GeneralList");
var myList = new CommonOperate <T>();
return(myList.ListOfT(db, sp, parameter));
}
catch (Exception ex)
{
string em = ex.StackTrace;
throw;
}
}
public static List <T> CommonList <T>(string sp, object parameter)
{
try
{
string fsp = CheckParamerters(sp, parameter);
var myList = new CommonOperate <T>();
return(myList.ListOfT(fsp, parameter));
}
catch (Exception ex)
{
string em = ex.StackTrace;
throw;
}
}
public static List <T> CommonList <T>(string action, object parameter)
{
try
{
string sp = GetSP(action);
var myList = new CommonOperate <T>();
return(myList.ListOfT(sp, parameter));
// return CommonExecute<T>.ListOfT(sp, parameter);
}
catch (Exception ex)
{
string em = ex.StackTrace;
throw;
}
}
public static T CommonValue <T>(string action, object parameter)
{
try
{
string sp = GetSP(action);
var myValue = new CommonOperate <T>();
return(myValue.ValueOfT(_db, sp, parameter));
// return CommonExecute<T>.ValueOfT(sp, parameter);
}
catch (Exception ex)
{
string em = ex.StackTrace;
throw;
}
}