private List<RFIDPassMediaReissueStage> GetRFIDPassMediaReissueStageByStatus(Enums.OrderStatus status)
{
int batchSize = int.Parse(ConfigurationManager.AppSettings["BatchSize"].ToString());
List<RFIDPassMediaReissueStage> orders = new List<RFIDPassMediaReissueStage>();
Console.WriteLine(string.Format("BEGIN Get RFIDPassMediaReissueStage data from SQL Server"));
Console.WriteLine();
using (var context = new RTPContext())
{
orders = context.RFIDPassMediaReissueStages.SqlQuery("SELECT TOP " + batchSize.ToString() + " * FROM RFIDPassMediaReissueStage WHERE StatusID = " + status.GetHashCode().ToString()).ToList<RFIDPassMediaReissueStage>();
}
Console.WriteLine(string.Format("END Get RFIDPassMediaReissueStage data from SQL Server"));
Console.WriteLine();
return orders;
}
