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