public int Get()
{
using (iLeapRepoEntities entities = new iLeapRepoEntities())
{
var WO = entities.TAKAFUL_MDL_MaintenanceWorkOrder
.SqlQuery("select * from dbo.TAKAFUL_MDL_MaintenanceWorkOrder")
.ToList <TAKAFUL_MDL_MaintenanceWorkOrder>();
return(WO.ToList().Count);
}
}
public IEnumerable <WOStatus> Get()
{
using (iLeapRepoEntities entities = new iLeapRepoEntities())
{
int test = 0;
//var WO = entities.Database
// .SqlQuery<WOStatus>("select Status, count(*) as NWO from TAKAFUL_MDL_MaintenanceWorkOrder group by Status");
var res = from MWO in entities.TAKAFUL_MDL_MaintenanceWorkOrder
group MWO by MWO.Status into g
select new
{
Status = g.Key,
NWO = g.Count()
};
//var res = from WOL in entities.TAKAFUL_MDL_MainenanceWorkOrderList
// join tl in entities.TAKAFUL_MDL_Maintaintechnicianslist
// on WOL.TechnicianNameList_Value equals tl.Id.ToString()
// group WOL by WOL.TechnicianNameList into newGroup
// select new
// {
// TechnicianName = newGroup.Key,
// NumberOfWorkOrders = newGroup.Count()
// };
List <WOStatus> WOStatus = new List <WOStatus>();
foreach (var two in res)
{
WOStatus t = new WOStatus();
t.Status = two.Status;
t.NWO = two.NWO;
WOStatus.Add(t);
}
return(WOStatus);
}
//List<List<int>> listofLists = new List<List<int>>();
//List<int> bars = new List<int>
//{
// 55, 25, 100
//};
//listofLists.Add(bars);
//return listofLists;
}
// GET: api/Values
//[Produces("application/json")]
public IEnumerable<TechnicianWO> Get()
{
using (iLeapRepoEntities entities = new iLeapRepoEntities())
{
int test = 0;
var WO = entities.Database
.SqlQuery<TechnicianWO>("select wol.TechnicianNameList, count(*) as NWO from TAKAFUL_MDL_MainenanceWorkOrderList wol join TAKAFUL_MDL_Maintaintechnicianslist tl on wol.TechnicianNameList_Value = CAST(tl.Id as nvarchar) group by wol.TechnicianNameList");
//var res = from WOL in entities.TAKAFUL_MDL_MainenanceWorkOrderList
// join tl in entities.TAKAFUL_MDL_Maintaintechnicianslist
// on WOL.TechnicianNameList_Value equals tl.Id.ToString()
// group WOL by WOL.TechnicianNameList into newGroup
// select new
// {
// TechnicianName = newGroup.Key,
// NumberOfWorkOrders = newGroup.Count()
// };
List < TechnicianWO > twoList = new List<TechnicianWO>();
foreach (TechnicianWO two in WO)
{
TechnicianWO t = new TechnicianWO();
t.TechnicianNameList = two.TechnicianNameList;
t.NWO = two.NWO;
twoList.Add(t);
}
return twoList;
}
//List<int> bars = new List<int>
//{
// 45,
// 37,
// 60,
// 70
//};
//return bars;
}
public IEnumerable <WOPriority> Get()
{
using (iLeapRepoEntities entities = new iLeapRepoEntities())
{
int test;
test = 0;
var res = from MWO in entities.TAKAFUL_MDL_MaintenanceWorkOrder
group MWO by new
{
MWO.MainCategory,
MWO.Priority
} into g
select new
{
aMainCatergory = g.Key.MainCategory,
aPriority = g.Key.Priority,
aPC = g.Count()
};
//var res = from WOL in entities.TAKAFUL_MDL_MainenanceWorkOrderList
// join tl in entities.TAKAFUL_MDL_Maintaintechnicianslist
// on WOL.TechnicianNameList_Value equals tl.Id.ToString()
// group WOL by WOL.TechnicianNameList into newGroup
// select new
// {
// TechnicianName = newGroup.Key,
// NumberOfWorkOrders = newGroup.Count()
// };
List <WOPriority> WOPriorities = new List <WOPriority>();
foreach (var wop in res)
{
WOPriority p = new WOPriority();
p.MainCategory = wop.aMainCatergory;
p.Priority = wop.aPriority;
p.PC = wop.aPC;
WOPriorities.Add(p);
}
return(WOPriorities);
}
//List<StackedData> sdList = new List<StackedData>();
//StackedData sd = new StackedData();
//sd.data = new List<int>();
//int[] marks = new int[7] { 150, 59, 80, 100, 56, 55, 40 };
//sd.data = marks.OfType<int>().ToList();
//sd.label = "Priority Test";
//sd.Stack = "a";
//sdList.Add(sd);
//StackedData sd2 = new StackedData();
//sd2.data = new List<int>();
//int[] marks2 = new int[7] { 28, 48, 40, 19, 86, 27, 90 };
//sd2.data = marks2.OfType<int>().ToList();
//sd2.label = "Priority Medium";
//sd2.Stack = "a";
//sdList.Add(sd2);
//StackedData sd3 = new StackedData();
//sd3.data = new List<int>();
//int[] marks3 = new int[7] { 28, 48, 40, 19, 86, 27, 90 };
//sd3.data = marks3.OfType<int>().ToList();
//sd3.label = "Priority High";
//sd3.Stack = "a";
//sdList.Add(sd3);
//StackedData sd4 = new StackedData();
//sd4.data = new List<int>();
//int[] marks4 = new int[7] { 28, 58, 50, 59, 66, 87, 90 };
//sd4.data = marks4.OfType<int>().ToList();
//sd4.label = "Priority Highest";
//sd4.Stack = "a";
//sdList.Add(sd4);
//return sdList;
}
