public ActionResult CreateRanking()
{
//Deze wordt ook voor Donut gebruikt
RankViewModel rankModel = TempData["rankModel"] as RankViewModel;
string naam = rankModel.Naam;
int aantal = rankModel.Aantal;
int interval = rankModel.interval;
//Zie dat je bent ingelogd
//TODO: redirect naar inlog pagina <--
ApplicationUser currUser = _userManager.FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
string userName = currUser.UserName;
Gebruiker user = _gebrManager.FindUser(userName);
// =============== Opslaan grafiek : opgesplitst om te debuggen =================== //
List <GraphData> graphDataList = _dataManager.GetRanking(aantal, interval, false);
DashItem newDashItem = _dashManager.CreateDashitem(true, "Rank", naam);
List <int> arrayPersoonId = _dataManager.ExtractListPersoonId(graphDataList);
List <Follow> follows = _dashManager.CreateFollow(newDashItem.DashItemId, arrayPersoonId);
DashItem dashItem = _dashManager.SetupDashItem(user, follows);
_dashManager.LinkGraphsToUser(graphDataList, dashItem.DashItemId);
// ================================================================================ //
_dashManager.SyncWithAdmins(user.GebruikerId, dashItem.DashItemId);
Dashbord dash = _dashManager.GetDashboardWithFollows(user);
return(View());
}
public JsonResult IncomeExpensesAnalysis4(string Id)
{
try
{
AdminDetails admObj = (AdminDetails)Session["UserDetails"];
Dashbord LST = new Dashbord();
LST = BL.ViewDashbord(admObj.HospitalId.ToString());
// var date = LST.d1lst[0].dates.ToShortDateString();
//for (int i = 0; i < LST.d5lst.Count; i++)
//{
// //LST.d1lst[i].date = LST.d1lst[i].dates.ToShortDateString();
// LST.d5lst[i].date = LST.d5lst[i].dates.ToString("ddd");
//}
for (int i = 0; i < LST.d5lst.Count; i++)
{
LST.d5lst[i].date = LST.d5lst[i].dates.ToString("ddd");
}
//var output = JsonConvert.SerializeObject(LST.d1lst); //(LST.d1lst, JsonRequestBehavior.AllowGet);
return(Json(LST.d5lst, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public Dashbord DashbordInitGraphs(int dashId)
{
InitNonExistingRepo();
Dashbord dashbord = repo.ReadDashbord(dashId);
//We halen vaste grafieken op (AdminGraphs) en koppelen deze aan de
//nieuw aangemaakte dashboard van de nieuwe gebruiker
IEnumerable <DashItem> dashItems = GetDashItems().Where(d => d.AdminGraph == true);
if (dashbord.TileZones == null)
{
dashbord.TileZones = new Collection <TileZone>();
}
foreach (DashItem item in dashItems)
{
TileZone tile = new TileZone()
{
DashItem = item,
Dashbord = dashbord
};
repo.AddTileZone(tile);
}
repo.UpdateDashboard(dashbord);
return(dashbord);
}
public DashItem SetupDashItem(Gebruiker user, Follow follow)
{
InitNonExistingRepo(true);
bool UoW = false;
repo.SetUnitofWork(UoW);
follow.DashItem.Follows = new Collection <Follow>
{
follow
};
Dashbord dashbord = GetDashboard(user);
TileZone tile = new TileZone()
{
Dashbord = dashbord,
DashItem = follow.DashItem
};
repo.AddTileZone(tile);
follow.DashItem.TileZones.Add(tile);
repo.UpdateFollow(follow);
//repo.UpdateDashItem(dashItem);
AddOneZonesOrder(dashbord);
uowManager.Save();
UoW = true;
repo.SetUnitofWork(UoW);
return(follow.DashItem);
}
public void updateTilezonesOrder(int dashId, string zonesOrder)
{
InitNonExistingRepo();
Dashbord dashbord = repo.ReadDashbordWithFollows(dashId);
dashbord.ZonesOrder = zonesOrder;
repo.UpdateDashboard(dashbord);
}
public ActionResult CreateCijfer(string automplete, int uren)
{
string naam = automplete;
//Persoon p = _dataManager.GetPersoon(naam);
ViewBag.naam = automplete;
//Zie dat je bent ingelogd
ApplicationUser currUser = _userManager.FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
string userName = currUser.UserName;
Gebruiker user = _gebrManager.FindUser(userName);
try
{
Persoon p = _dataManager.GetPersoon(naam);
// =============== Opslaan grafiek : opgesplitst om te debuggen =================== //
List <IP3_8IEN.BL.Domain.Dashboard.GraphData> graphDataList = _dataManager.GetNumberGraph(p, uren);
IP3_8IEN.BL.Domain.Dashboard.DashItem newDashItem = _dashManager.CreateDashitem(true, "Cijfer", naam);
IP3_8IEN.BL.Domain.Dashboard.Follow follow = _dashManager.CreateFollow(newDashItem.DashItemId, p.OnderwerpId);
IP3_8IEN.BL.Domain.Dashboard.DashItem dashItem = _dashManager.SetupDashItem(user, follow);
_dashManager.LinkGraphsToUser(graphDataList, dashItem.DashItemId);
// ================================================================================ //
_dashManager.SyncWithAdmins(user.GebruikerId, dashItem.DashItemId);
} catch { }
try
{
Organisatie o = _dataManager.GetOrganisaties().FirstOrDefault(org => org.Naam == naam);
// =============== Opslaan grafiek : opgesplitst om te debuggen =================== //
List <IP3_8IEN.BL.Domain.Dashboard.GraphData> graphDataList = _dataManager.GetNumberGraph(o, uren);
IP3_8IEN.BL.Domain.Dashboard.DashItem newDashItem = _dashManager.CreateDashitem(true, "Cijfer", naam);
IP3_8IEN.BL.Domain.Dashboard.Follow follow = _dashManager.CreateFollow(newDashItem.DashItemId, o.OnderwerpId);
IP3_8IEN.BL.Domain.Dashboard.DashItem dashItem = _dashManager.SetupDashItem(user, follow);
_dashManager.LinkGraphsToUser(graphDataList, dashItem.DashItemId);
// ================================================================================ //
_dashManager.SyncWithAdmins(user.GebruikerId, dashItem.DashItemId);
} catch { }
try
{
Thema t = _dataManager.GetThemas().FirstOrDefault(theme => theme.Naam == naam);
// =============== Opslaan grafiek : opgesplitst om te debuggen =================== //
List <GraphData> graphDataList = _dataManager.GetNumberGraph(t, uren);
DashItem newDashItem = _dashManager.CreateDashitem(true, "Cijfer", naam);
Follow follow = _dashManager.CreateFollow(newDashItem.DashItemId, t.OnderwerpId);
DashItem dashItem = _dashManager.SetupDashItem(user, follow);
_dashManager.LinkGraphsToUser(graphDataList, dashItem.DashItemId);
// ================================================================================ //
_dashManager.SyncWithAdmins(user.GebruikerId, dashItem.DashItemId);
}
catch { }
Dashbord dash = _dashManager.GetDashboardWithFollows(user);
return(View());
}
public void AddOneZonesOrder(Dashbord dashbord)
{
InitNonExistingRepo();
string zones = dashbord.ZonesOrder;
JArray orde = JArray.Parse(zones);
int volgendeZone = orde.Count();
orde.Add(volgendeZone);
zones = JsonConvert.SerializeObject(orde);
dashbord.ZonesOrder = zones;
repo.UpdateDashboard(dashbord);
}
public ActionResult ViewDashbord()
{
try
{
AdminDetails admObj = (AdminDetails)Session["UserDetails"];
Dashbord LST = new Dashbord();
LST = BL.ViewDashbord(admObj.HospitalId.ToString());
if (LST.Fedlst.Count > 0)
{
foreach (var item in LST.Fedlst)
{
item.MedicalExpertise = item.MedicalExpertise + ' ' + item.ListenGiveTime + ' ' + item.Compassionate + ' ' + item.BadBehevior;
item.MedicalExpertise = item.MedicalExpertise.TrimEnd(',');
item.MedicalExpertise = item.MedicalExpertise.TrimStart(',');
if (item.BadBehevior != null)
{
item.BadBehevior = item.BadBehevior.TrimEnd(',');
}
item.Dates = item.Date.ToString("dd/MM/yyyy");
}
}
int hospitalId;
// DateTime date = Convert.ToDateTime( Request["txtDate"].ToString());
hospitalId = admObj.HospitalId;
ModelState.Clear();
List <QueueDetails> LST1 = new List <QueueDetails>();
if (admObj.RoleId == "AHE")
{
int UserId = 99999;
LST1 = BL.GetFeatureAppoinmentList(hospitalId, UserId, "NNN");
}
if (admObj.RoleId == "ADM")
{
LST1 = BL.GetFeatureAppoinmentList(hospitalId, admObj.UserId, "NNN");
}
LST.Qlst = LST1;
return(View("Dashbord", LST));
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteOneZonesOrder(Dashbord dashbord)
{
InitNonExistingRepo();
string zones = dashbord.ZonesOrder;
JArray orde = JArray.Parse(zones);
int verwijder = orde.Count() - 1;
LinkedList <int> result = new LinkedList <int>();
foreach (int item in orde)
{
if (item != verwijder)
{
result.AddLast(item);
}
}
zones = JsonConvert.SerializeObject(result);
dashbord.ZonesOrder = zones;
repo.UpdateDashboard(dashbord);
}
public void InitializeTileZoneOrder(int DashbordId)
{
InitNonExistingRepo();
Dashbord dashbord = repo.ReadDashbordWithFollows(DashbordId);
dashbord.TileZones.Count();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("[0");
int i;
for (i = 1; i <= dashbord.TileZones.Count(); i++)
{
stringBuilder.Append(",");
stringBuilder.Append(i);
}
stringBuilder.Append("]");
dashbord.ZonesOrder = stringBuilder.ToString();
repo.UpdateDashboard(dashbord);
}
public ActionResult UserDashBoard()
{
//Dashbord van ingelogde gebruiker ophalen
//Hier zit voorlopig enkel update logica
try
{
ApplicationUser appUser = aMgr.FindById(User.Identity.GetUserId());
string userName = appUser.UserName;
Gebruiker user = gMgr.FindUser(userName);
Dashbord dashbord = dashMgr.GetDashboardWithFollows(user);
dashbord = dashMgr.UpdateDashboard(dashbord); // <-- zien dat elk DashItem up-to-date is
return(View(dashbord));
}
catch
{
return(View());
}
}
public Dashbord AddDashBord(string userId)
{
InitNonExistingRepo(true);
gebruikerMgr = new GebruikerManager(uowManager);
bool UoW = false;
repo.SetUnitofWork(UoW);
Dashbord dashbord = new Dashbord
{
//De te associëren gebruiker wordt opgehaald
User = gebruikerMgr.GetGebruikers().FirstOrDefault(u => u.GebruikerId == userId),
ZonesOrder = "[0,1,2,3,4,5,6,7,8,9]",
TileZones = new Collection <TileZone>()
};
repo.AddDashBord(dashbord);
uowManager.Save();
repo.SetUnitofWork(true);
return(dashbord);
}
public ActionResult UserDashBoardById(string name)
{
//Dashbord van ingelogde gebruiker ophalen
try
{
//ApplicationUser appUser = aMgr.FindById(User.Identity.GetUserId());
//string userName = appUser.UserName;
Gebruiker user = gMgr.FindUser(name);
Dashbord dashbord = dashMgr.GetDashboardWithFollows(user);
dashbord = dashMgr.UpdateDashboard(dashbord); // <-- zien dat elk DashItem minstens 3h up-to-date is
var list = JsonConvert.SerializeObject(dashbord, Formatting.None, new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(Content(list, "application/json"));
}
catch (Exception ex)
{
return(Json("error" + ex, JsonRequestBehavior.AllowGet));
}
}
public Dashbord UpdateDashboard(Dashbord dashbord)
{
InitNonExistingRepo(true);
dataMgr = new DataManager(uowManager);
repo.SetUnitofWork(false);
DateTime timeNow = DateTime.Now;
foreach (TileZone tileZone in dashbord.TileZones)
{
double hours = (timeNow - tileZone.DashItem.LastModified).TotalHours;
if (hours > 0.0001)
{
int i = 0;
//deze array verwijst naar de personen in GraphData
int[] onderwerpId = { 0, 0, 0, 0, 0 };
foreach (Follow follow in tileZone.DashItem.Follows)
{
onderwerpId[i] = follow.Onderwerp.OnderwerpId;
i++;
}
int aantalDagen = tileZone.DashItem.AantalDagen;
if (tileZone.DashItem.Type == "Line" && tileZone.DashItem.Town != "Vlaanderen")
{
try
{
GraphdataValues graphs = GetGraphData(onderwerpId[0], aantalDagen, tileZone.DashItem.Type, "Persoon");
int j = 0;
foreach (var graph in tileZone.DashItem.Graphdata)
{
graph.Label = graphs.labels[j];
graph.Value = graphs.values[j];
repo.UpdateGraphData(graph);
j++;
}
}
catch { }
try
{
//Organisatie organisatie = dataMgr.GetOrganisatie(onderwerpId[0]);
GraphdataValues graphs = GetGraphData(onderwerpId[0], aantalDagen, tileZone.DashItem.Type, "Organisatie");
int j = 0;
foreach (var graph in tileZone.DashItem.Graphdata)
{
graph.Label = graphs.labels[j];
graph.Value = graphs.values[j];
repo.UpdateGraphData(graph);
j++;
}
}
catch { }
try
{
//Thema thema = dataMgr.GetThema(onderwerpId[0]);
GraphdataValues graphs = GetGraphData(onderwerpId[0], aantalDagen, tileZone.DashItem.Type, "Thema");
int j = 0;
foreach (var graph in tileZone.DashItem.Graphdata)
{
graph.Label = graphs.labels[j];
graph.Value = graphs.values[j];
repo.UpdateGraphData(graph);
j++;
}
}
catch { }
uowManager.Save();
}
}
//LastModified updaten
tileZone.DashItem.LastModified = timeNow;
repo.UpdateTileZone(tileZone);
uowManager.Save();
}
repo.SetUnitofWork(true);
return(dashbord);
}
public void AddDashBord(Dashbord dashbord)
{
ctx.Dashbords.Add(dashbord);
ctx.SaveChanges();
}
public void UpdateDashboard(Dashbord dashbord)
{
ctx.Entry(dashbord).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
public Dashbord ViewDashbord(string HospitalId)
{
try
{
SqlParameter[] sqlparam;
sqlparam = new SqlParameter[2];
sqlparam[0] = new SqlParameter("@Flag", "1");
sqlparam[1] = new SqlParameter("@HospitalId", HospitalId);
DataSet ds = CommonFunction.GetDataSet("USP_GET_DashbordDetails", sqlparam, "");
Dashbord D = new Dashbord();
// week
List <Dashbord1> lst1 = new List <Dashbord1>();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Dashbord1 Model = new Dashbord1();
CommonFunction.ReflectSingleData(Model, dr);
lst1.Add(Model);
}
}
//month
List <Dashbord2> lst2 = new List <Dashbord2>();
if (ds != null && ds.Tables[1].Rows.Count > 0)
{
DataTable dt = ds.Tables[1];
foreach (DataRow dr in dt.Rows)
{
Dashbord2 Model = new Dashbord2();
CommonFunction.ReflectSingleData(Model, dr);
lst2.Add(Model);
}
}
List <InvoiceExpenses> lst3 = new List <InvoiceExpenses>();
if (ds != null && ds.Tables[2].Rows.Count > 0)
{
DataTable dt = ds.Tables[2];
foreach (DataRow dr in dt.Rows)
{
InvoiceExpenses Model = new InvoiceExpenses();
CommonFunction.ReflectSingleData(Model, dr);
lst3.Add(Model);
}
}
List <FeedbackDetails> lst4 = new List <FeedbackDetails>();
if (ds != null && ds.Tables[3].Rows.Count > 0)
{
DataTable dt = ds.Tables[3];
foreach (DataRow dr in dt.Rows)
{
FeedbackDetails Model = new FeedbackDetails();
CommonFunction.ReflectSingleData(Model, dr);
lst4.Add(Model);
}
}
List <Dashbord5> lst5 = new List <Dashbord5>();
if (ds != null && ds.Tables[4].Rows.Count > 0)
{
DataTable dt = ds.Tables[4];
foreach (DataRow dr in dt.Rows)
{
Dashbord5 Model = new Dashbord5();
CommonFunction.ReflectSingleData(Model, dr);
lst5.Add(Model);
}
}
// exp_Inv
///4/////
D.d1lst = lst1;
D.d2lst = lst2;
D.d3lst = lst3;
D.Fedlst = lst4;
D.d5lst = lst5;
return(D);
}
catch (Exception Ex)
{
throw Ex;
}
}
public ActionResult CreateGrafiekLine(string automplete, string automplete2)
{
string naam = automplete;
ViewBag.naam = automplete;
//Zie dat je bent ingelogd
//TODO: redirect naar inlog pagina <--
ApplicationUser currUser = _userManager.FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
string userName = currUser.UserName;
Gebruiker user = _gebrManager.FindUser(userName);
int nDagen = 10; // <-- voorlopig default
//////////////////////////////////////////////////////////////////
try
{
Persoon p = _dataManager.GetPersoon(naam);
// =============== Opslaan grafiek : opgesplitst om te debuggen =================== //
List <IP3_8IEN.BL.Domain.Dashboard.GraphData> graphDataList = _dataManager.GetTweetsPerDag(p, nDagen);
IP3_8IEN.BL.Domain.Dashboard.DashItem newDashItem = _dashManager.CreateDashitem(true, "Line", naam);
IP3_8IEN.BL.Domain.Dashboard.Follow follow = _dashManager.CreateFollow(newDashItem.DashItemId, p.OnderwerpId);
IP3_8IEN.BL.Domain.Dashboard.DashItem dashItem = _dashManager.SetupDashItem(user, follow);
_dashManager.LinkGraphsToUser(graphDataList, dashItem.DashItemId);
// ================================================================================ //
_dashManager.SyncWithAdmins(user.GebruikerId, dashItem.DashItemId);
}
catch { }
try
{
Organisatie o = _dataManager.GetOrganisaties().ToList().FirstOrDefault(org => org.Naam == naam);
List <IP3_8IEN.BL.Domain.Dashboard.GraphData> graphDataList;
IP3_8IEN.BL.Domain.Dashboard.DashItem newDashItem;
// =============== Opslaan grafiek : opgesplitst om te debuggen =================== //
if (automplete2 != null)
{
graphDataList = _dataManager.GetTweetsPerDag(o, automplete2, nDagen);
newDashItem = _dashManager.CreateDashitem(true, "Line", naam, automplete2);
}
else
{
graphDataList = _dataManager.GetTweetsPerDag(o, nDagen);
newDashItem = _dashManager.CreateDashitem(true, "Line", naam);
}
IP3_8IEN.BL.Domain.Dashboard.Follow follow = _dashManager.CreateFollow(newDashItem.DashItemId, o.OnderwerpId);
IP3_8IEN.BL.Domain.Dashboard.DashItem dashItem = _dashManager.SetupDashItem(user, follow);
_dashManager.LinkGraphsToUser(graphDataList, dashItem.DashItemId);
// ================================================================================ //
_dashManager.SyncWithAdmins(user.GebruikerId, dashItem.DashItemId);
}
catch { }
try
{
Thema thema = _dataManager.GetThemas().ToList().FirstOrDefault(t => t.Naam == naam);
List <GraphData> graphDataList = _dataManager.GetTweetsPerDag(thema, nDagen);
DashItem newDashItem = _dashManager.CreateDashitem(true, "Line", naam);
Follow follow = _dashManager.CreateFollow(newDashItem.DashItemId, thema.OnderwerpId);
DashItem dashItem = _dashManager.SetupDashItem(user, follow);
_dashManager.LinkGraphsToUser(graphDataList, dashItem.DashItemId);
// ================================================================================ //
_dashManager.SyncWithAdmins(user.GebruikerId, dashItem.DashItemId);
}
catch { }
////////////////////////////////////////////////////////////////
Dashbord dash = _dashManager.GetDashboardWithFollows(user);
return(View());
}
