public static List <EmployeeRole> GetAccountRoleListLimited()
{
List <EmployeeRole> list = new List <EmployeeRole>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetAccountRoleListLimited";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
EmployeeRole employeeRole = new EmployeeRole();
employeeRole.Description = dataReader["Description"].ToString();
list.Add(employeeRole);
}
}
return(list);
}
public static List <EmployeeRole> GetRoleListByFilter(string searchValue)
{
List <EmployeeRole> list = new List <EmployeeRole>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetRoleListByFilter";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@SearchValue", DbType.String, searchValue);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
EmployeeRole employeeRole = new EmployeeRole();
employeeRole.Description = dataReader["Description"].ToString();
list.Add(employeeRole);
}
}
return(list);
}
public static List <EmployeeRole> GetEmployeeRoleListByEmployeeId(int employeeId)
{
List <EmployeeRole> list = new List <EmployeeRole>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetEmployeeRoleListByEmployeeId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
EmployeeRole employeeRole = new EmployeeRole();
employeeRole.EmployeeRoleId = Convert.ToInt32(dataReader["EmployeeRoleId"]);
employeeRole.EmployeeId = Convert.ToInt32(dataReader["EmployeeId"]);
employeeRole.Description = dataReader["RoleName"].ToString();
list.Add(employeeRole);
}
}
return(list);
}