public static int Exec_Scalar(string query, DynamicParameters dbA, CS_Type cs)
{
try
{
using (IDbConnection db = new SqlConnection(GetCS(cs)))
{
return(db.ExecuteScalar <int>(query, dbA));
}
}
catch (Exception ex)
{
new ErrorLog(ex, query);
return(-1);
}
}
public static List <T> Get_Data <T>(string query, DynamicParameters dbA, CS_Type cs)
{
try
{
using (IDbConnection db = new SqlConnection(GetCS(cs)))
{
return((List <T>)db.Query <T>(query, dbA));
}
}
catch (Exception ex)
{
new ErrorLog(ex, query);
return(null);
}
}
public static string GetCS(CS_Type cs)
{
return(ConfigurationManager.ConnectionStrings[cs.ToString()].ConnectionString);
}
