public IEnumerable <SalesUserIdAndName> GetAllSalesUsers()
{
List <SalesUserIdAndName> users = new List <SalesUserIdAndName>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("SalesUserIdAndName", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SalesUserIdAndName currentRow = new SalesUserIdAndName();
currentRow.UserId = dr["UserId"].ToString();
currentRow.UserName = dr["UserName"].ToString();
users.Add(currentRow);
}
}
}
return(users);
}
public IEnumerable <SalesUserIdAndName> GetAllSalesUsers()
{
List <SalesUserIdAndName> result = new List <SalesUserIdAndName>();
foreach (var user in _Users)
{
SalesUserIdAndName currentRow = new SalesUserIdAndName();
if (user.Role == "Sales")
{
currentRow.UserId = user.UserId;
currentRow.UserName = user.FirstName + " " + user.LastName;
}
result.Add(currentRow);
}
return(result);
}
