public static List <ComboBoxItem> GetEmployeeList()
{
List <ComboBoxItem> items = new List <ComboBoxItem>();
ComboBoxItem cbItem = new ComboBoxItem();
cbItem = new ComboBoxItem();
cbItem.strValue = "Show All";
cbItem.key = "Show All Employees";
items.Add(cbItem);
string sql = "SELECT EmployeeID,FullName FROM Employee WHERE EmployeeID IN (SELECT empID FROM vw_ChangeLog) ORDER BY FullName ";
using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr))
{
System.Data.SqlClient.SqlDataReader dr = dg.GetDataReader(sql);
while (dr.Read())
{
cbItem = new ComboBoxItem();
cbItem.strValue = dr[0].ToString();
cbItem.key = dr[1].ToString();
items.Add(cbItem);
}
dg.KillReader(dr);
}
return(items);
}
public virtual T CreateModel(string sql, string connStr = "")
{
var results = new List <T>();
if (connStr == string.Empty)
{
connStr = CommonProcs.WCompanyConnStr;
}
using (clsDataGetter dg = new clsDataGetter(connStr))
{
SqlDataReader reader = dg.GetDataReader(sql);
var NotMapped = new List <String>();
var props = typeof(T).GetProperties().Where(x => Attribute.IsDefined(x, typeof(NotMappedAttribute)));
foreach (var prop in props)
{
NotMapped.Add(prop.Name);
}
if (reader == null || reader.HasRows == false)
{
return(default(T));
}
while (reader.Read())
{
var item = Activator.CreateInstance <T>();
foreach (var property in typeof(T).GetProperties())
{
if (!NotMapped.Contains(property.Name))
{
try
{
if (!reader.IsDBNull(reader.GetOrdinal(property.Name)))
{
Type convertTo = Nullable.GetUnderlyingType(property.PropertyType) ?? property.PropertyType;
property.SetValue(item, Convert.ChangeType(reader[property.Name], convertTo), null);
}
else
{
if (property.PropertyType.Name == "String")
{
property.SetValue(item, "");
}
}
}
catch
{
}
}
}
results.Add(item);
}
dg.KillReader(reader);
}
return(results[0]);
}