public List <ViewIndex> showIndexProjet(List <Project> projects)
{
List <ViewIndex> viewIndexs = new List <ViewIndex>();
foreach (var item in projects)
{
ViewIndex view = new ViewIndex();
view.ProjectId = item.ProjectId;
view.ProjectFin = Convert.ToDateTime(item.ProjectFin);
view.ProjectDebut = Convert.ToDateTime(item.ProjectDebut);
view.ProjectName = item.ProjectName;
view.margeprojeter = ProjectManager.Getmarge(item.ProjectId);
view.margesoumis = ProjectManager.Getmarge(item.ProjectId);
view.Lastupdate = Convert.ToDateTime(ProjectManager.GetLastProjection(item.ProjectId).FuDate).ToShortDateString();
view.echeance = view.ProjectFin.ToShortDateString();
view.graph = ProjectManager.graphbar(item.ProjectId).dépense;
view.graphSoumis = ProjectManager.graphbar(item.ProjectId).soumission;
view.colorgraph = ProjectManager.graphbar(item.ProjectId).colordepense;
view.label = ProjectManager.nomdépense(item.ProjectId);
viewIndexs.Add(view);
}
return(viewIndexs);
}
public void OnSwitchView(ViewIndex index, ViewParam param = null, Action <BaseView> callback = null)
{
if (index == ViewIndex.None)
{
return;
}
if (currentView != null)
{
currentView.HideView(() =>
{
ViewIndex pre = currentView.viewIndex;
currentView.gameObject.SetActive(false);
currentView = dicView[index];
currentView.gameObject.SetActive(true);
currentView.ShowView(param, () => {
callback?.Invoke(currentView);
});
OnSwitchViewEvent?.Invoke(pre, currentView);
});
}
else
{
currentView = dicView[index];
currentView.gameObject.SetActive(true);
currentView.ShowView(param, () => {
callback?.Invoke(currentView);
});
OnSwitchViewEvent?.Invoke(ViewIndex.None, currentView);
}
}
Stage InitStage(ViewIndex index, IDataProvider dataProvider)
{
Stage stage;
switch (index)
{
case ViewIndex.First:
stage = new Stage(firstStageName);
stage.camera.backgroundColor = new Color32(5, 5, 5, 255);
stage.camera.name += "_1";
break;
case ViewIndex.Second:
stage = new Stage(secondStageName);
stage.camera.backgroundColor = new Color32(5, 5, 5, 255);
stage.camera.name += "_2";
break;
default:
throw new ArgumentException("Unknown ViewIndex: " + index);
}
dataProvider.FirstInitScene(stage.runtimeInterface);
m_CurrentDataProvider = dataProvider;
return(stage);
}
/// <summary>
/// Changes the camera mode for a view.
/// </summary>
/// <param name="viewIndex">index of the view.</param>
/// <param name="cameraMode">New camera mode.</param>
public void ChangeCameraModeForView(ViewIndex viewIndex, CameraMode cameraMode)
{
Debug.Assert(ActiveViews[(int)viewIndex] != null);
var view = ActiveViews[(int)viewIndex];
view.ChangeCameraModeForView(cameraMode);
}
public void UpdateSceneLighting(ViewIndex index, IDataProvider provider)
{
Stage stage = this[index];
Environment environment = m_Contexts.GetViewContent(index).environment;
provider.UpdateSky(stage.camera,
environment == null ? default : environment.sky,
stage.runtimeInterface);
}
public bool Equals(NarrationInformation other)
{
if (other == null)
{
return(false);
}
return(ViewIndex.Equals(other.ViewIndex) &&
MessageIndex.Equals(other.MessageIndex) &&
SubIndex.Equals(other.SubIndex));
}
public void SwitchView(ViewIndex e, ViewParam param = null, Action callBack = null)
{
if (currentView != null)
{
currentView.OnHide(() => {
ShowNewView(e, param, callBack);
});
}
else
{
ShowNewView(e, param, callBack);
}
}
public void SynchronizeCameraStates(ViewIndex baseCameraState)
{
switch (baseCameraState)
{
case ViewIndex.First:
m_Views[1].camera.SynchronizeFrom(m_Views[0].camera);
break;
case ViewIndex.Second:
m_Views[0].camera.SynchronizeFrom(m_Views[1].camera);
break;
default:
throw new System.ArgumentException("Unknow ViewIndex given in parameter.");
}
}
public void UpdateSceneObjects(ViewIndex index)
{
Stage stage = this[index];
stage.Clear();
var viewContent = m_Contexts.GetViewContent(index);
if (viewContent == null)
{
viewContent.viewedInstanceInPreview = null;
return;
}
if (viewContent.viewedObjectReference != null && !viewContent.viewedObjectReference.Equals(null))
{
viewContent.viewedInstanceInPreview = stage.InstantiateIntoStage(viewContent.viewedObjectReference);
}
}
private bool TryCreateView(
object source,
ViewIndex index,
ref View target,
AbsoluteLayoutFlags flags = AbsoluteLayoutFlags.All,
double height = 1)
{
if (Container?.Children == null || source == null)
{
return(false);
}
var loggableTarget = target;
InternalLogger.Debug(Tag, () => $"TryCreateView( source: {source}, index: {index}, target: {loggableTarget} )");
if (target != null)
{
Container.Children.Remove(target);
target.BindingContext = null;
}
target = source is DataTemplate dataTemplate
? (View)dataTemplate.CreateContent()
: (View)source;
target.IsVisible = false;
var bounds = AbsoluteLayout.GetLayoutBounds(target);
if (bounds.Width < 1 || bounds.Height < 1)
{
// Apply default bounds
AbsoluteLayout.SetLayoutBounds(target, new Rectangle(1, 1, 1, height));
AbsoluteLayout.SetLayoutFlags(target, flags);
}
Container.Children.Insert((int)index, target);
return(true);
}
Stage InitStage(ViewIndex index, IDataProvider dataProvider)
{
Stage stage;
switch (index)
{
case ViewIndex.First:
stage = new Stage(firstStageName);
stage.camera.backgroundColor = Compositer.firstViewGizmoColor;
break;
case ViewIndex.Second:
stage = new Stage(secondStageName);
stage.camera.backgroundColor = Compositer.secondViewGizmoColor;
break;
default:
throw new ArgumentException("Unknown ViewIndex: " + index);
}
dataProvider.FirstInit(stage.runtimeInterface);
return(stage);
}
public Stage this[ViewIndex index] => m_Stages[(int)index];
/// <summary>Get the hashcode of the Value.</summary>
public override int GetHashCode()
{
return(ViewIndex.GetHashCode()
^ MessageIndex.GetHashCode()
^ SubIndex.GetHashCode());
}
/// <summary>
/// Gets the ICameraController responsible for a particular view
/// for the current active camera mode.
/// </summary>
/// <param name="targetView">View index</param>
/// <returns>ICameraController or null if there is no implementation</returns>
public ICameraController ActiveCameraControllerForView(ViewIndex targetView)
{
return ActiveViews[(int)targetView] == null ? null : ActiveViews[(int) targetView].ActiveCameraControllerForView();
}
/// <summary>
/// Changes the camera mode for a view.
/// </summary>
/// <param name="viewIndex">index of the view.</param>
/// <param name="cameraMode">New camera mode.</param>
public void ChangeCameraModeForView(ViewIndex viewIndex, CameraMode cameraMode)
{
Debug.Assert(ActiveViews[(int)viewIndex] != null);
var view = ActiveViews[(int) viewIndex];
view.ChangeCameraModeForView(cameraMode);
}
public void SetCurrentViewIndex(ViewIndex viewIndex)
{
ViewIndexChanged.Invoke(this, (int)viewIndex);
}
public ViewContext GetViewContent(ViewIndex index) => m_Views[(int)index];
private void ShowNewView(ViewIndex e, ViewParam param = null, Action callBack = null)
{
currentView = dicView[e];
currentView.Setup(param, callBack);
}
public static List<UI.RequestBlade> GetRequestBlades(ViewIndex view, Search search)
{
//string userId = SnapSession.CurrentUser.LoginId;
//string condition = "";
//switch (view)
//{
// case ViewIndex.my_requests:
// condition = string.Format("(userId==\"{0}\"||submittedBy==\"{0}\")",userId);
// break;
// case ViewIndex.my_approvals:
//condition = string.Format("(workflowStatusEnum=={0}&&completedDate==null)||(workflowStatusEnum=={1})||(workflowStatusEnum=={2})||(workflowStatusEnum=={3}&&completedDate==null)||(workflowStatusEnum=={4}&&completedDate!=null)",
// (int)WorkflowState.Pending_Approval, (int)WorkflowState.Change_Requested, (int)WorkflowState.Approved, (int)WorkflowState.Not_Active, (int)WorkflowState.Closed_Denied);
// break;
// case ViewIndex.access_team:
// condition = "pkId>0";
// break;
// case ViewIndex.search:
// string primaryCondition = "";
// string contentsCondition = "";
// string rangeCondition = "";
// primaryCondition = string.Format("(userId==\"{0}\"||displayName==\"{0}\"||submittedBy==\"{0}\")", search.Primary);
// if (search.Contents != string.Empty)
// {
// }
// condition = primaryCondition + contentsCondition + rangeCondition;
// break;
//}
//return Database.GetRequests(condition, userId, view);
return Database.GetRequests(view, search);
}
public CameraState GetCameraState(ViewIndex index) => m_Cameras[(int)index];
public object Any(ViewIndex request)
{
return(Request.GetPageResult("/index"));
//equivalent to: return new PageResult(Request.GetPage("/index")).BindRequest(Request);
}
/// <summary>
/// Gets the ICameraController responsible for a particular view
/// for the current active camera mode.
/// </summary>
/// <param name="targetView">View index</param>
/// <returns>ICameraController or null if there is no implementation</returns>
public ICameraController ActiveCameraControllerForView(ViewIndex targetView)
{
return(ActiveViews[(int)targetView] == null ? null : ActiveViews[(int)targetView].ActiveCameraControllerForView());
}
public void UpdateSceneLighting(ViewIndex index, IDataProvider provider)
{
Stage stage = this[index];
provider.UpdateSky(stage.camera, m_Contexts.GetViewContent(index).environment?.sky.cubemap, stage.runtimeInterface);
}
public static List<UI.RequestBlade> GetRequests(ViewIndex view, UI.Search search)
{
return UI.GetRequestBlades(view, search);
}
public RenderTexture this[ViewIndex index, ShadowCompositionPass passIndex]
{
get => m_RTs[computeIndex(index, passIndex)];
public static List<UI.RequestBlade> GetRequests(ViewIndex view, UI.Search search)
{
try
{
string userId = SnapSession.CurrentUser.LoginId;
string condition = "";
var requestList = new List<UI.RequestBlade>();
DateTime closedDateLimit = new DateTime();
closedDateLimit = DateTime.Now.AddDays(-30);
string dateTime = closedDateLimit.Year + "," + closedDateLimit.Month + "," + closedDateLimit.Day;
string closedString = string.Format("statusEnum=={0}&&lastModifiedDate >= DateTime({1})", (int)RequestState.Closed, dateTime); ;
string openString = string.Format("statusEnum=={0}||statusEnum=={1}||statusEnum=={2}", (int)RequestState.Open, (int)RequestState.Pending, (int)RequestState.Change_Requested);
string requestCondition = string.Format("({0})||({1})",openString,closedString);
using (var db = new SNAPDatabaseDataContext())
{
switch (view)
{
case ViewIndex.my_approvals:
string groupNames = "";
foreach(string group in SnapSession.CurrentUser.MemberOf)
{
if (group != ""){groupNames += "userId==\"" + group + "\"||";}
}
groupNames = groupNames.Substring(0, groupNames.Length - 2);
string actorCondition = string.Format("(userId==\"{0}\"||({1}&&isGroup==true))",userId,groupNames);
List<int> workflowIds = (from r in db.SNAP_Requests.Where(requestCondition)
join w in db.SNAP_Workflows on r.pkId equals w.requestId
join ws in db.SNAP_Workflow_States on w.pkId equals ws.workflowId
join a in db.SNAP_Actors.Where(actorCondition) on w.actorId equals a.pkId
group ws by new { ws.workflowId } into grp
select grp.Max(s => s.pkId)).ToList();
var approvals = from r in db.SNAP_Requests
join w in db.SNAP_Workflows on r.pkId equals w.requestId
join ws in db.SNAP_Workflow_States on w.pkId equals ws.workflowId
where workflowIds.Contains(ws.pkId)
orderby r.lastModifiedDate descending
select new
{
DisplayName = r.userDisplayName,
RequestStatus = r.statusEnum,
LastModified = r.lastModifiedDate,
RequestId = r.pkId,
WorkflowStatus = ws.workflowStatusEnum
};
if (approvals != null)
{
foreach (var request in approvals)
{
UI.RequestBlade newRequest = new UI.RequestBlade();
newRequest.DisplayName = request.DisplayName.StripTitleFromUserName();
newRequest.RequestStatus = Convert.ToString((RequestState)Enum.Parse(typeof(RequestState), request.RequestStatus.ToString())).StripUnderscore();
newRequest.WorkflowStatus = request.WorkflowStatus.ToString();
newRequest.LastModified = WebUtilities.TestAndConvertDate(request.LastModified.ToString());
newRequest.RequestId = request.RequestId.ToString();
requestList.Add(newRequest);
}
}
break;
case ViewIndex.my_requests:
condition = string.Format("(userId==\"{0}\"||submittedBy==\"{0}\")", userId);
var requests = db.SNAP_Requests.
Where(condition + "&&(" + requestCondition + ")").
OrderByDescending(r => r.lastModifiedDate).ToList();
if (requests != null)
{
foreach (var request in requests)
{
UI.RequestBlade my_requests = new UI.RequestBlade();
my_requests.DisplayName = request.userDisplayName.StripTitleFromUserName();
my_requests.RequestStatus = Convert.ToString((RequestState)Enum.Parse(typeof(RequestState), request.statusEnum.ToString())).StripUnderscore();
my_requests.WorkflowStatus = String.Empty;
my_requests.LastModified = WebUtilities.TestAndConvertDate(request.lastModifiedDate.ToString());
my_requests.RequestId = request.pkId.ToString();
requestList.Add(my_requests);
}
}
break;
case ViewIndex.access_team:
var accessRequests = db.SNAP_Requests.
Where(requestCondition).
OrderByDescending(r => r.lastModifiedDate).ToList();
if (accessRequests != null)
{
foreach (var request in accessRequests)
{
UI.RequestBlade access_team = new UI.RequestBlade();
access_team.DisplayName = request.userDisplayName.StripTitleFromUserName();
access_team.RequestStatus = Convert.ToString((RequestState)Enum.Parse(typeof(RequestState), request.statusEnum.ToString())).StripUnderscore();
access_team.WorkflowStatus = String.Empty;
access_team.LastModified = WebUtilities.TestAndConvertDate(request.lastModifiedDate.ToString());
access_team.RequestId = request.pkId.ToString();
requestList.Add(access_team);
}
}
break;
case ViewIndex.search:
string primaryCondition = "";
string rangeCondition = "";
List<object> values = new List<object>();
int valCount = 0;
if (search.Primary != string.Empty)
{
primaryCondition = "(pkId.ToString()==@0 or userId==@0 or userDisplayName.Contains(@0) or submittedBy==@0)";
values.Add((object)search.Primary);
condition = primaryCondition;
}
if (search.RangeStart != string.Empty)
{
DateTime rangeStart = Convert.ToDateTime(search.RangeStart);
if (search.RangeEnd != string.Empty)
{
valCount = values.Count();
DateTime rangeEnd = Convert.ToDateTime(search.RangeEnd);
rangeCondition = "(createdDate>=@" + valCount.ToString() + " and createdDate<@" + (valCount + 1).ToString() + ")";
values.Add((object)rangeStart);
values.Add((object)rangeEnd.AddDays(1));
}
else
{
valCount = values.Count();
rangeCondition = "(createdDate>=@" + valCount.ToString() + ")";
values.Add((object)rangeStart);
}
if (condition != string.Empty) { condition += " and " + rangeCondition; }
else { condition = rangeCondition; }
}
if (condition == string.Empty)
{
condition = "pkid>@0";
values.Add(0);
}
object[] objs = values.ToArray();
var searchResults = db.SNAP_Requests.
Where(condition, objs).
OrderByDescending(r => r.lastModifiedDate).ToList();
if (searchResults != null)
{
foreach (var request in searchResults)
{
if (RequestContainsContents(search.Contents,request.pkId))
{
UI.RequestBlade search_request = new UI.RequestBlade();
search_request.DisplayName = request.userDisplayName.StripTitleFromUserName();
search_request.RequestStatus = Convert.ToString((RequestState)Enum.Parse(typeof(RequestState), request.statusEnum.ToString())).StripUnderscore();
search_request.WorkflowStatus = String.Empty;
search_request.LastModified = WebUtilities.TestAndConvertDate(request.lastModifiedDate.ToString());
search_request.RequestId = request.pkId.ToString();
requestList.Add(search_request);
}
}
}
break;
}
return requestList;
}
}
catch (Exception ex)
{
Logger.Error("GetRequests \r\nMessage: " + ex.Message + "\r\nStackTrace: " + ex.StackTrace);
return null;
}
}
