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