public static GridEntity <T> GenericDataSource(GridOptions options, string query, string orderBy, string condition)
{
var _connection = new CommonConnection();
StringBuilder gridQuery;
StringBuilder totalQuery;
GetGridPagingQuery(options, query, orderBy, condition, out gridQuery, out totalQuery, _connection.DatabaseType);
DataTable dataTable = _connection.GetDataTable(gridQuery.ToString());
int totalCount = Convert.ToInt32(_connection.ExecuteScalar(totalQuery.ToString()));
var dataList = (List <T>)GenericListGenerator.GetList <T>(dataTable);
var result = new GridResult <T>().Data(dataList, totalCount);
return(result);
}
public static GridEntity <T> GetGenericGridData_5(GridOptions gridOption, string ProcName, string CallType, string orderby, string param1 = "", string param2 = "", string param3 = "", string param4 = "", string param5 = "")
{
try
{
gridOption.take = gridOption.skip + gridOption.take;
var filterby = "";
if (gridOption.filter != null)
{
filterby = gridOption != null ? GridQueryBuilder <T> .FilterCondition(gridOption.filter) : "";
}
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
cmd = new SqlCommand(ProcName, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CallType", CallType));
cmd.Parameters.Add(new SqlParameter("@skip", gridOption.skip));
cmd.Parameters.Add(new SqlParameter("@take ", gridOption.take));
cmd.Parameters.Add(new SqlParameter("@filter", filterby));
cmd.Parameters.Add(new SqlParameter("@orderby", orderby.Trim()));
cmd.Parameters.Add(new SqlParameter("@param1", param1));
cmd.Parameters.Add(new SqlParameter("@param2", param2));
cmd.Parameters.Add(new SqlParameter("@param3", param3));
cmd.Parameters.Add(new SqlParameter("@param4", param4));
cmd.Parameters.Add(new SqlParameter("@param5", param5));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
dbConn.Close();
dt = ds.Tables[1];
totalCount = Convert.ToInt32(ds.Tables[0].Rows[0]["TotalCount"]);
var dataList = (List <T>)GenericListGenerator.GetList <T>(dt).ToList();
var result = new GridResult <T>().Data(dataList, totalCount);
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List <T> Select_Generic_Data_List <T>(string procedureName, string callName, string parm1 = "", string parm2 = "", string parm3 = "", string parm4 = "", string parm5 = "", string parm6 = "", string parm7 = "", string parm8 = "", string parm9 = "", string parm10 = "")
{
try
{
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
cmd = new SqlCommand(procedureName, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CallType", callName));
cmd.Parameters.Add(new SqlParameter("@Desc1", parm1));
cmd.Parameters.Add(new SqlParameter("@Desc2", parm2));
cmd.Parameters.Add(new SqlParameter("@Desc3", parm3));
cmd.Parameters.Add(new SqlParameter("@Desc4", parm4));
cmd.Parameters.Add(new SqlParameter("@Desc5", parm5));
cmd.Parameters.Add(new SqlParameter("@Desc6", parm6));
cmd.Parameters.Add(new SqlParameter("@Desc7", parm7));
cmd.Parameters.Add(new SqlParameter("@Desc8", parm8));
cmd.Parameters.Add(new SqlParameter("@Desc9", parm9));
cmd.Parameters.Add(new SqlParameter("@Desc10", parm10));
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
dbConn.Close();
dt = ds.Tables[0];
var dataList = new List <T>();
if (dt.Rows.Count > 0)
{
dataList = (List <T>)GenericListGenerator.GetList <T>(dt);
}
return(dataList);
}
catch
{
return(null);
}
}
public static List <T> GenericDataSource(string query)
{
var connection = new CommonConnection();
try
{
DataTable dataTable = connection.GetDataTable(query);
var objData = (List <T>)GenericListGenerator.GetList <T>(dataTable);
if (objData.Count == 0)
{
return(new List <T>());
}
return(objData);
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
