public List <ddvalues> GetProductsDtlsForDD() { List <ddvalues> lstData = new List <ddvalues>(); try { using (IDbConnection connection = dbObj.CreateOpenConnection()) { using (IDbCommand command = dbObj.CreateCommand( "SELECT ProductId,Name FROM Product ORDER BY ProductId", connection)) { using (IDataReader reader = command.ExecuteReader()) { var srno = 0; while (reader.Read()) { srno++; var product = new ddvalues { key = reader["ProductId"] == DBNull.Value ? 0 : (int)reader["ProductId"], value = reader["Name"] == DBNull.Value ? "" : (string)reader["Name"], }; lstData.Add(product); } reader.Dispose(); } command.Dispose(); } connection.Dispose(); } } catch (Exception) { } return(lstData); }
public List <ddvalues> GetAttributesByCatID(int id) { List <ddvalues> lstData = new List <ddvalues>(); try { using (IDbConnection connection = dbObj.CreateOpenConnection()) { string query = "select AttributeId, AttributeName from ProductAttributeLookup where ProductCategoryId = " + id + " order by AttributeId"; using (IDbCommand command = dbObj.CreateCommand(query, connection)) { using (IDataReader reader = command.ExecuteReader()) { var srno = 0; while (reader.Read()) { srno++; var product = new ddvalues { key = reader["AttributeId"] == DBNull.Value ? 0 : (int)reader["AttributeId"], value = reader["AttributeName"] == DBNull.Value ? "" : (string)reader["AttributeName"], }; lstData.Add(product); } reader.Dispose(); } command.Dispose(); } connection.Dispose(); } } catch (Exception) { } return(lstData); }