public static string SPName(List <CommonSP> cSP, string action, object parameter)
{
try
{
string sp = GetSPbyClassAndAction(cSP, action); // this is a OOP method
// string sp = GetSPbyClassAndAction(className, action);
return(CheckStoreProcedureParameters.GetParamerters(sp, parameter));
}
catch (Exception ex)
{ string em = ex.StackTrace;
return("SP nmae for " + action); }
}
public T ValueOfT(string sp, object parameter)
{
try
{
sp = CheckStoreProcedureParameters.GetParamerters(sp, parameter);
var result = MyDapper.EasyDataAccess <T> .ValueOfT(sp, parameter);
return(result);
}
catch (Exception ex)
{
var exm = ex.Message;
throw;
}
}
public List <T> ListOfT(string db, string sp, object parameter)
{
try
{
sp = CheckStoreProcedureParameters.GetParamerters(sp, parameter);
var list = MyDapper.EasyDataAccess <T> .ListOfT(db, sp, parameter);
return(list);
}
catch (Exception ex)
{
var exm = ex.Message;
return(null);
}
}
public string SPNameAndPara(string category, string action, object parameter)
{
var sp = SPNameAndPara(category, action);
return(CheckStoreProcedureParameters.GetParamerters(sp, parameter));
}
public static string SPName(string action, object parameter)
{
return(CheckStoreProcedureParameters.GetParamerters(action, parameter));
}
public static string CheckParamerters(string sp, object obj)
{
return(CheckStoreProcedureParameters.GetParamerters(sp, obj));
}