public static List <Stores> ToList(BLL.Activity v)
{
List <Stores> list = new List <Stores>();
while (!v.EOF)
{
Stores t = new Stores();
if (!v.IsColumnNull("ID"))
{
t.ID = v.ID;
}
if (!v.IsColumnNull("HospitalID"))
{
t.HospitalID = v.HospitalID;
}
if (!v.IsColumnNull("StoreName"))
{
t.StoreName = v.StoreName;
}
if (!v.IsColumnNull("UsesMovingAverage"))
{
t.UsesMovingAverage = v.UsesMovingAverage;
}
list.Add(t);
v.MoveNext();
}
return(list);
}
protected override ICollection <ActivityGroup> GetData()
{
ICollection <Domain.ActivityGroup> activities = new Collection <Domain.ActivityGroup>();
var dbActivities = new BLL.Activity();
dbActivities.LoadAll();
while (!dbActivities.EOF)
{
activities.Add(new ActivityGroup {
Activity = new Activity {
ActivityID = dbActivities.ID, Name = dbActivities.FullActivityName
}, IsDeliveryNote = true
});
activities.Add(new ActivityGroup {
Activity = new Activity {
ActivityID = dbActivities.ID, Name = dbActivities.FullActivityName
}, IsDeliveryNote = false
});
dbActivities.MoveNext();
}
return(activities);
}
public static BLL.Models.StockAvailabilityStatistics GetStockAvailabilityStats(int month, int year)
{
var commodityType= new CommodityType();
commodityType.LoadAll();
var activity = new BLL.Activity();
activity.LoadByMode(Mode.Constants.HEALTH_PROGRAM);
var overstocked = 0;
var nearEOP = 0;
var belowEOP = 0;
var stockedOut = 0;
var normal = 0;
while(!commodityType.EOF)
{
activity.Rewind();
while(!activity.EOF)
{
DataTable tbl = GetSohForAllItems(activity.ID,
commodityType.ID, year, month);
overstocked += (from y in tbl.AsEnumerable() where y["Status"].ToString() == "Over Stocked" select y).Count();
nearEOP += (from y in tbl.AsEnumerable() where y["Status"].ToString() == "Near EOP" select y).Count();
belowEOP += (from y in tbl.AsEnumerable() where y["Status"].ToString() == "Below EOP" select y).Count();
stockedOut += (from y in tbl.AsEnumerable() where y["Status"].ToString() == "Stock Out" select y).Count();
normal += (from y in tbl.AsEnumerable() where y["Status"].ToString() == "Normal" select y).Count();
activity.MoveNext();
}
commodityType.MoveNext();
}
var statistics = new StockAvailabilityStatistics(overstocked, normal, nearEOP, belowEOP, stockedOut);
return statistics;
}