public async Task <IHttpActionResult> GetPlayerWithChildByGroupID(int GroupID)
{
List <int> GroupIDList = new List <int>();
GroupIDList.Add(GroupID);
PublicMethods.GetChildGroupIDs(GroupID, ref GroupIDList, db);
int[] groupIDs = GroupIDList.ToArray <int>();
var jsonList = (from pm in db.PlayerMaster
join gm in db.GroupMaster on pm.GroupID equals gm.GroupID into ProjectV
from pv in ProjectV.DefaultIfEmpty()
where groupIDs.Contains((int)pm.GroupID) && pm.UseFlag == true
select new { pm.PlayerID,
pm.PlayerName,
pm.PlayerAddress,
pm.Settings,
pm.OnlineFlag,
pm.ActiveFlag,
pm.Comments,
pm.UpdateDate,
pv.GroupName,
pv.GroupID }).ToList();
return(Json(jsonList));
}
public async Task <List <PlayListLinkData> > GetForcedPlayListByGroupID(int GroupID)
{
List <int> GroupIDList = new List <int>();
GroupIDList.Add(GroupID);
PublicMethods.GetParentGroupIDs(GroupID, ref GroupIDList, db);
int[] groupIDs = GroupIDList.ToArray <int>();
string groupIDsStr = string.Join(",", groupIDs.Select(i => i.ToString()).ToArray());
List <PlayListLinkData> pldList = (from plm in db.PlayListMaster
join gplt in db.GroupPlayListLinkTable on plm.PlayListID equals gplt.PlayListID
join gm in db.GroupMaster on plm.GroupID equals gm.GroupID into ProjectV
from pv in ProjectV.DefaultIfEmpty()
where groupIDs.Contains((int)gplt.GroupID) && plm.UseFlag == true
orderby gplt.GroupID == GroupID ? 2 : 1, groupIDsStr.IndexOf(gplt.GroupID.ToString()) descending, gplt.Index
select new PlayListLinkData
{
PlayListID = plm.PlayListID,
PlayListName = plm.PlayListName,
Settings = plm.Settings,
UpdateDate = (DateTime)plm.UpdateDate,
GroupID = (int)plm.GroupID,
GroupName = pv.GroupName,
BindGroupID = (int)gplt.GroupID
}).ToList();
return(pldList);
}
void Awake()
{
controls = gameManager.controls;
controls.UI.Submit.performed += ctx =>
{
if (inputField.isFocused)
{
string command = inputField.text.Replace(consoleHistory, "");
ProcessCommand(command);
}
};
}
void Start()
{
controls = gameManager.controls;
controls.Player.Jump.performed += ctx => jump = true;
controls.Player.Move.performed += ctx =>
{
horizontalMove = ctx.ReadValue <Vector2>().x *runSpeed;
animator.SetFloat("Speed", Mathf.Abs(horizontalMove));
};
controls.Player.Move.canceled += ctx =>
{
horizontalMove = 0;
animator.SetFloat("Speed", Mathf.Abs(horizontalMove));
};
}
public async Task <IHttpActionResult> GetFilesByFolderIDArray(string [] folderIDs)
{
var jsonList = (from fm in db.FileMaster
join gm in db.GroupMaster on fm.GroupID equals gm.GroupID into ProjectV
from pv in ProjectV.DefaultIfEmpty()
where folderIDs.Contains(fm.FolderID.ToString()) && fm.UseFlag == true
select new
{
fm.FolderID,
fm.FileName,
fm.FileID,
fm.FileExtension,
fm.FileType,
fm.FileUrl,
fm.FileThumbnailUrl,
fm.Comments,
pv.GroupName,
pv.GroupID
}).ToList();
return(Json(jsonList));
}
public async Task <List <PlayListLinkData> > GetOwnPlayListWithInheritByGroupID(int GroupID)
{
List <int> GroupIDList = new List <int>();
GroupIDList.Add(GroupID);
PublicMethods.GetParentGroupIDs(GroupID, ref GroupIDList, db);
int[] groupIDs = GroupIDList.ToArray <int>();
List <PlayListLinkData> pldList = (from plm in db.PlayListMaster
join gm in db.GroupMaster on plm.GroupID equals gm.GroupID into ProjectV
from pv in ProjectV.DefaultIfEmpty()
where groupIDs.Contains((int)plm.GroupID) && plm.UseFlag == true
select new PlayListLinkData
{
PlayListID = plm.PlayListID,
PlayListName = plm.PlayListName,
Settings = plm.Settings,
UpdateDate = (DateTime)plm.UpdateDate,
GroupID = (int)plm.GroupID,
GroupName = pv.GroupName
}).ToList();
return(pldList);
}
public async Task <IList <DataModel> > GetFolderJSTreeNodeWithInheritForcedByGroupID(int GroupID)
{
List <int> GroupIDList = new List <int>();
GroupIDList.Add(GroupID);
PublicMethods.GetParentGroupIDs(GroupID, ref GroupIDList, db);
int[] groupIDs = GroupIDList.ToArray <int>();
var jsonList = (from fm in db.FolderMaster
join gm in db.GroupMaster on fm.GroupID equals gm.GroupID into ProjectV
from pv in ProjectV.DefaultIfEmpty()
where groupIDs.Contains((int)fm.GroupID) && fm.UseFlag == true
select new
{
fm,
pv.GroupName,
pv.GroupID
}).ToList();
List <DataModel> jdmList = new List <DataModel>();
DataModel jdm;
StateForJsonModel sfjm = new StateForJsonModel();
sfjm.opened = false;
foreach (var item in jsonList)
{
jdm = new DataModel();
jdm.id = item.fm.FolderID.ToString();
jdm.text = item.fm.FolderName;
jdm.parent = item.fm.FolderParentID == null ? "#" : item.fm.FolderParentID.ToString();
jdm.state = sfjm;
jdm.li_attr = item;
jdmList.Add(jdm);
}
return(jdmList);
}
void Awake()
{
controls = new ProjectV();
}
