public static QueryMasterListModel ConvertQueryMasterToListModel(QueryMaster qm)
{
QueryMasterListModel cm = new QueryMasterListModel();
cm.CustomerId = qm.CustomerId;
if (qm.Customer != null)
{
cm.CustomerName = ((qm.Customer.FirstName == null) ? "" : qm.Customer.FirstName)
+ " "
+ ((qm.Customer.LastName == null) ? "" : qm.Customer.LastName);
}
cm.QueryId = qm.QueryId;
cm.Title = qm.Title;
cm.Product = qm.Product;
cm.DeptId = qm.DeptId;
cm.DepartmentName = qm.Department.DeptName;
cm.Status = qm.Status;
cm.Message = qm.Message;
// Format Date
cm.QueryDate = qm.QueryDate;
cm.QueryDateStr = qm.QueryDate.ToString("MM/dd/yyyy");
cm.QueryAssigns = qm.QueryAssigns != null?
qm.QueryAssigns.Select(qa => new QueryAssignViewModel(qa)).ToList() :
null;
return(cm);
}
// Start Query
public async Task StartQueryAsync(QueryMaster query)
{
query.Status = QueryStatus.New;
await _context.QueryMasters.AddAsync(query);
await _context.SaveChangesAsync();
}
// Get Employee of who provided Solution to the provided queryID
public async Task <Employee> GetEmployeeProvidedSolutionForAsync(int queryId)
{
Employee employee = null;
// Get QueryMast of the queryId
QueryMaster qm = await _context.QueryMasters
.Include(a => a.QueryAssigns)
.Where(d => d.QueryId == queryId && d.Status == QueryStatus.Resolved)
.FirstOrDefaultAsync();
if (qm != null)
{
if (qm.QueryAssigns != null && (qm.QueryAssigns != null && qm.QueryAssigns.Count > 0))
{
// Get the latest QueryAssign
QueryAssign qa = qm.QueryAssigns.OrderByDescending(q => q.ResponseDate).FirstOrDefault();
if (qa != null)
{
// Retrieve Employee details
employee = _context.Employees.FirstOrDefault(e => e.EmployeeId == qa.EmployeeId);
}
qa = null;
}
}
qm = null;
return(employee);
}
public static List <ItemMaestro> getMaestroItems()
{
if (items == null)
{
items = QueryMaster.getMaestroItems();
}
return(items);
}
public static List <WeaponMaestro> findMaestroWeapon()
{
if (weapons == null)
{
weapons = QueryMaster.getMaestroWeapons();
}
return(weapons);
}
// Add New Query Master
public async Task <bool> AddNewQuery(QueryMaster queryMaster)
{
EntityEntry <QueryMaster> track = await _context.QueryMasters.AddAsync(queryMaster);
Console.WriteLine("QM ADDED : " + track.Entity.QueryId);
int x = await _context.SaveChangesAsync();
return(x > 0 ? true : false);
}
private static void savePlayerTemp(GameModel gameModel)
{
BinaryFormatter bf = new BinaryFormatter();
FileStream file = File.Create(Application.persistentDataPath + "/savedGames.gd");
bf.Serialize(file, gameModel);
game = gameModel;
file.Close();
QueryMaster.savePlayer(game.playerModel);
}
public async Task <bool> AddNewQueryAssign(int queryId, QueryAssign queryAssign)
{
EntityEntry <QueryAssign> track = await _context.QueryAssigns.AddAsync(queryAssign);
Console.WriteLine("QA ADDED : " + track.Entity.Id);
int x = await _context.SaveChangesAsync();
QueryMaster qm = await _context.QueryMasters.FindAsync(queryId);
qm.Status = QueryStatus.Resolved;
x = await _context.SaveChangesAsync();
return(x > 0 ? true : false);
}
public static void savePlayer()
{
try
{
getPlayerTemp().playerCore = QueryMaster.updatePlayer(PlayerFactory.getPlayerCore(getPlayerTemp()));
}
catch (Exception e)
{
UtilsPlayer.print("Error en la BBDD: updatePlayer -> " + e);
}
savePlayerTemp(playerTemplate);
}
public static CustomerIndexListingModel ConvertQueryMasterToListModel(QueryMaster qm)
{
CustomerIndexListingModel cm = new CustomerIndexListingModel();
cm.CustomerId = qm.CustomerId;
cm.QueryId = qm.QueryId;
cm.Title = qm.Title;
cm.Product = qm.Product;
cm.Status = qm.Status;
// Format Date
cm.QueryDate = qm.QueryDate.ToString("MM/dd/yyyy");
return(cm);
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
QueryMaster query = context.Query.Find(id);
context.Query.Remove(query);
context.SaveChanges();
// TODO: Add delete logic here
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public async Task <QueryMasterListModel> GetQueryDetailsAsync(int queryId)
{
if (!queryContext.ExistsQueryId(queryId))
{
return(null);
}
QueryMaster qm = await queryContext.GetQueryMaster(queryId);
QueryMasterListModel qlm = QueryMasterListModel.ConvertQueryMasterToListModel(qm);
// Get if query is Rated by Customer or not
qlm.isQuerySolutionRated = await queryContext.IsQueryRatedByCustomer(queryId);
return(qlm);
}
public async Task <QueryMaster> GetOnlyQuestionOfQueryMaster(int queryId)
{
QueryMaster qm = null; // = new QueryMaster();
// Check if queryId Exists
if (_context.QueryMasters.Any(q => q.QueryId == queryId))
{
qm = (await _context.QueryMasters
.Include(c => c.Customer)
.Include(p => p.Product)
.Include(d => d.Department)
.Where(q => q.QueryId == queryId)
.ToListAsync())
.FirstOrDefault();
}
return(qm);
}
private void Awake()
{
//Creamos el player
Vector3 posicionPlayer = new Vector3(-7f, -2.5f, 0f);
GameObject player = Instantiate(SaveLoad.Load(), posicionPlayer, new Quaternion());
//Creamos el enemy
GameObject enemy = QueryMaster.findRandomEnemy();
//Gestionamos los botones y asignamos el enemigo a ambos
player.GetComponent<PlayerController>().setFunctional(true);
player.GetComponent<PlayerController>().enemy = enemy;
enemy.GetComponent<PlayerController>().enemy = player;
gestionarBotones(player);
GameObject habButton = GameObject.Find("btVolver");
habButton.GetComponentInChildren<Button>().onClick.AddListener(habVolverOnClick);
}
public QueryMaster ConvertToQueryMaster()
{
QueryMaster qm = new QueryMaster();
qm.QueryId = this.QueryId;
qm.CustomerId = this.CustomerId;
qm.ProductId = this.ProductId;
qm.DeptId = this.DeptId;
qm.QueryDate = this.QueryDate;
qm.Status = this.Status;
qm.Product = this.Product;
qm.Title = this.Title;
qm.Message = this.Message;
qm.QueryAssigns = QueryAssignViewModel.ConverToQueryAssignList(QueryAssigns);
return(qm);
}
public ActionResult Edit(QueryMaster query)
{
try
{
if (ModelState.IsValid)
{
context.Entry(query).State = System.Data.Entity.EntityState.Modified;
// context.Query.Add(query);
context.SaveChanges();
}
// TODO: Add update logic here
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public async Task <IActionResult> PostNewQueryMaster(QueryMasterListModel queryVM)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
// CONVERT CustomerModel TO Customer
QueryMaster qm = queryVM.ConvertToQueryMaster();
bool added = await queryContext.AddNewQuery(qm);
if (added)
{
queryVM.QueryId = qm.QueryId;
return(CreatedAtAction("PostNewQueryMaster", new { queryId = qm.QueryId }, queryVM)); // new { queryId = qm.QueryId }, queryVM);
}
else
{
return(BadRequest("Server Error: Failed to add New Query"));
}
}
public async Task <IActionResult> GetQuerySolutionForQuery(int queryId = 0)
{
if (queryId < 1)
{
return(BadRequest("Invalid Query Id."));
}
if (!queryContext.ExistsQueryId(queryId))
{
return(NotFound("Query doesn't exists."));
}
// Get QueryMaster of specific Dept
QueryMaster queryMaster = await queryContext.GetQueryMaster(queryId);
if (queryMaster.QueryAssigns.Count == 0)
{
return(BadRequest("Query doesn't contain any Solution"));
}
QueryAssign qa = queryMaster.QueryAssigns.OrderByDescending(q => q.ResponseDate).FirstOrDefault();
if (qa != null)
{
EmployeeViewModel evm = new EmployeeViewModel()
{
EmployeeId = qa.EmployeeId,
FirstName = qa.Employee.FirstName,
LastName = qa.Employee.LastName
};
return(Ok(new QueryAssignViewModel(qa)));
}
else
{
return(NotFound("No Solution found for Query Id : " + queryId));
}
}
public static GameModel Load()
{
if (File.Exists(Application.persistentDataPath + "/savedGames.gd"))
{
try
{
BinaryFormatter bf = new BinaryFormatter();
FileStream file = File.Open(Application.persistentDataPath + "/savedGames.gd", FileMode.Open);
GameModel gameModel = (GameModel)bf.Deserialize(file);
file.Close();
file.Dispose();
game = gameModel;
if (game.playerModel == null)
{
PlayerModel playerModel = QueryMaster.LoadPlayer(SystemInfo.deviceUniqueIdentifier);
if (playerModel == null)
{
playerModel = new PlayerModel();
playerModel.deviceId = SystemInfo.deviceUniqueIdentifier;
//TODO: PEDIR NICKNAME
playerModel.name = "Nombre: " + SystemInfo.deviceUniqueIdentifier;
playerModel.maxScore = 0;
}
game.playerModel = playerModel;
savePlayerTemp(game);
}
}
catch (System.Exception)
{
//print("no ha ido bien lo de cargar");
game = new GameModel();
game.lifes = 10;
game.bombs = 2;
game.maxStage = 0;
PlayerModel playerModel = QueryMaster.LoadPlayer(SystemInfo.deviceUniqueIdentifier);
if (playerModel == null)
{
playerModel = new PlayerModel();
playerModel.deviceId = SystemInfo.deviceUniqueIdentifier;
//TODO: PEDIR NICKNAME
playerModel.name = "Nombre: " + SystemInfo.deviceUniqueIdentifier;
playerModel.maxScore = 0;
}
game.playerModel = playerModel;
savePlayerTemp(game);
throw;
}
}
else
{
game = new GameModel();
game.lifes = 10;
game.bombs = 2;
game.maxStage = 0;
PlayerModel playerModel = QueryMaster.LoadPlayer(SystemInfo.deviceUniqueIdentifier);
if (playerModel == null)
{
playerModel = new PlayerModel();
playerModel.deviceId = SystemInfo.deviceUniqueIdentifier;
//TODO: PEDIR NICKNAME
playerModel.name = "Nombre: " + SystemInfo.deviceUniqueIdentifier;
playerModel.maxScore = 0;
}
game.playerModel = playerModel;
savePlayerTemp(game);
}
return(game);
}
// GET: Default/Delete/5
public ActionResult Delete(int id)
{
QueryMaster query = context.Query.Find(id);
return(View(query));
}
public ActionResult AjaxAdd(string appid, string targetPage, string queryId)
{
string[] arr = Session["UserData"] as string[];
string userid = arr[0];
object _genericObject;
QueryDetails queryDetails;
QueryMaster queryMaster;
Comment comment;
switch (targetPage)
{
case "QueryCommentRaised":
queryDetails = new QueryDetails()
{
FileRefId = Guid.NewGuid().ToString(),
ERApplicationId = appid
};
QueryCommentViewModel QueryCommentRaised = new QueryCommentViewModel();
QueryCommentRaised.QueryDetails = queryDetails;
if (arr[2] == "coordinator")
{
ViewBag.ReciverList = ERAppActiveUsersContext.Collection().Where(x => x.ERApplicationId == appid && x.UserAccountId != userid)
.Select(d => new { ListItemKey = d.UserAccountId, ListItemValue = d.UserAccount.FirstName + " " + d.UserAccount.LastName + " (" + d.UserAccount.UserRole + ")" }).ToList();
}
else if (arr[2] == "Consultant Enhanced Recovery")
{
ViewBag.ReciverList = ERAppActiveUsersContext.Collection().Where(x => x.ERApplicationId == appid && x.UserAccountId != userid && x.UserAccount.UserRole == "coordinator")
.Select(d => new { ListItemKey = d.UserAccountId, ListItemValue = d.UserAccount.FirstName + " " + d.UserAccount.LastName + " (" + d.UserAccount.UserRole + ")" }).ToList();
}
else if (arr[2] == "operator")
{
ViewBag.ReciverList = ERAppActiveUsersContext.Collection().Where(x => x.ERApplicationId == appid && x.UserAccountId != userid && x.UserAccount.UserRole == "Consultant Enhanced Recovery")
.Select(d => new { ListItemKey = d.UserAccountId, ListItemValue = d.UserAccount.FirstName + " " + d.UserAccount.LastName + " (" + d.UserAccount.UserRole + ")" }).ToList();
}
else
{
ViewBag.ReciverList = ERAppActiveUsersContext.Collection().Where(x => x.ERApplicationId == appid && x.UserAccountId != userid && x.UserAccount.UserRole != "operator")
.Select(d => new { ListItemKey = d.UserAccount.Id, ListItemValue = d.UserAccount.FirstName + " " + d.UserAccount.LastName + " (" + d.UserAccount.UserRole + ")" }).ToList();
}
_genericObject = QueryCommentRaised;
break;
case "QueryCommentForward":
QueryCommentViewModel QueryCommentForward = new QueryCommentViewModel();
QueryDetails qd = QueryDetailsContext.Collection().Where(x => x.Id == queryId).FirstOrDefault();
queryDetails = new QueryDetails()
{
FileRefId = Guid.NewGuid().ToString(),
ERApplicationId = appid,
QueryParentId = qd.QueryParentId,
};
queryMaster = new QueryMaster()
{
Subject = QueryMasterContext.Collection().Where(d => d.Id == qd.QueryParentId).FirstOrDefault().Subject,
};
comment = new Comment()
{
Text = commentContext.Collection().Where(c => c.Id == qd.CommentRefId).FirstOrDefault().Text,
};
QueryCommentForward.QueryDetails = queryDetails;
QueryCommentForward.QueryMaster = queryMaster;
QueryCommentForward.Comment = comment;
QueryUser queryUser = QueryUserContext.Collection().Where(x => x.QueryId == qd.QueryParentId).FirstOrDefault();
if (arr[2] == "coordinator")
{
// QueryUserContext.Collection().Where(x=>x.QueryId==queryId)
var qmc = QueryMasterContext.Collection().Where(e => e.ERApplicationId == appid).ToList();
var query = from p in qmc
join q in qmc on p.Id equals q.QueryParentId
select new { pid = p.Id, qid = q.Id };
ViewBag.ReciverList = ERAppActiveUsersContext.Collection().Where(x => x.ERApplicationId == appid && x.UserAccountId != userid && x.UserAccountId != queryUser.RecieverId && x.UserAccountId != queryUser.SenderId)
.Select(d => new { ListItemKey = d.UserAccountId, ListItemValue = d.UserAccount.FirstName + " " + d.UserAccount.LastName + " (" + d.UserAccount.UserRole + ")" }).ToList();
}
else
{
ViewBag.ReciverList = ERAppActiveUsersContext.Collection().Where(x => x.ERApplicationId == appid && x.UserAccountId != userid && x.UserAccount.UserRole != "operator" && x.UserAccountId != queryUser.RecieverId && x.UserAccountId != queryUser.SenderId)
.Select(d => new { ListItemKey = d.UserAccount.Id, ListItemValue = d.UserAccount.FirstName + " " + d.UserAccount.LastName + " (" + d.UserAccount.UserRole + ")" }).ToList();
}
_genericObject = QueryCommentForward;
break;
case "QueryCommentReply":
QueryCommentViewModel QueryCommentReply = new QueryCommentViewModel();
queryDetails = new QueryDetails()
{
ERApplicationId = appid,
QueryParentId = QueryDetailsContext.Collection().Where(x => x.Id == queryId).Select(d => d.QueryParentId).FirstOrDefault().ToString(),
FileRefId = Guid.NewGuid().ToString()
};
QueryCommentReply.QueryDetails = queryDetails;
_genericObject = QueryCommentReply;
break;
case "QueryCommentResolved":
_genericObject = new QueryCommentViewModel();
break;
case "ForwardApplication":
ForwardAppViewModel forwardAppViewModel = new ForwardAppViewModel();
ForwardApplication forwardApplication = new ForwardApplication();
//if(arr[2]=="HoD")
if (arr[2] == UserRoleType.ConsultantEnhancedRecovery.GetDisplayName())
{
ViewBag.ReciverList = UserAccountContext.Collection().Where(x => (x.UserRole == UserRoleType.Coordinator.ToString()) && x.Id != userid)
.Select(d => new { ListItemKey = d.Id, ListItemValue = d.FirstName + " " + d.LastName + " (" + d.UserRole + ")" }).ToList();
}
else if (arr[2] == UserRoleType.Coordinator.ToString())
{
int CountForward = ForwardApplicationContext.Collection().Where(x => x.ERApplicationId == appid && x.Is_Active == true && x.Sender == userid && (x.FileStatus == FileStatus.ReviewAgain || x.FileStatus == FileStatus.Forward)).Count();
int CountRecommended = ForwardApplicationContext.Collection().Where(x => x.ERApplicationId == appid && x.Is_Active == true && x.Reciever == userid && x.FileStatus == FileStatus.Recommended).Count();
if (CountForward == CountRecommended && CountForward != 0 && CountRecommended != 0)
{
ViewBag.ReciverList = UserAccountContext.Collection().Where(x => x.UserRole == UserRoleType.DG.ToString() && x.Id != userid)
.Select(d => new { ListItemKey = d.Id, ListItemValue = d.FirstName + " " + d.LastName + " (" + d.UserRole + ")" }).ToList();
}
else
{
ViewBag.ReciverList = UserAccountContext.Collection().Where(x => (x.UserRole == UserRoleType.Hod.ToString() ||
x.UserRole == UserRoleType.Coordinator.ToString() || x.UserRole == UserRoleType.ADG.ToString()) && x.Id != userid)
.Select(d => new { ListItemKey = d.Id, ListItemValue = d.FirstName + " " + d.LastName + " (" + d.UserRole + ")" }).ToList();
}
}
else
{
ViewBag.ReciverList = UserAccountContext.Collection().Where(x => (x.UserRole == UserRoleType.Hod.ToString() ||
x.UserRole == UserRoleType.Coordinator.ToString() || x.UserRole == UserRoleType.ADG.ToString()) && x.Id != userid)
.Select(d => new { ListItemKey = d.Id, ListItemValue = d.FirstName + " " + d.LastName + " (" + d.UserRole + ")" }).ToList();
}
forwardApplication.FileRef = Guid.NewGuid().ToString();
forwardAppViewModel.ForwardApplication = forwardApplication;
_genericObject = forwardAppViewModel;
break;
case "UploadApprovalLetter":
UploadApprovalLetterViewModel uploadApprovalLetterViewModel = new UploadApprovalLetterViewModel();
ForwardApplication forwardApplication1 = new ForwardApplication()
{
FileRef = Guid.NewGuid().ToString(),
ERApplicationId = appid
};
uploadApprovalLetterViewModel.ForwardApplication = forwardApplication1;
_genericObject = uploadApprovalLetterViewModel;
break;
default:
_genericObject = null;
break;
}
if (null != _genericObject)
{
ViewBag.appid = appid;
return(View(targetPage, _genericObject));
}
else
{
return(Content("<div class=\"alert alert-danger\" role=\"alert\"> An Error has occured </div>"));
}
}
public ActionResult Create(FormCollection collection)
{
try
{
QueryMaster query = new QueryMaster();
query.QueryText = collection[1];
// TODO: Add insert logic here
query.customerid = Convert.ToInt32(collection[2]);
context.Query.Add(query);
context.SaveChanges();
Parser parser = new Parser();
List <Parser.outputstruct> tablelist = Parser.GetTableNamesFromQueryString(query.QueryText);
foreach (Parser.outputstruct n in tablelist)
{
TableList table = new TableList();
table.TableName = n.Table;
table.owner = n.Owner;
table.AliasName = n.Alias;
table.queryID = query.ID;
context.Tables.Add(table);
}
context.SaveChanges();
List <Parser.columnstruct> columnlist = Parser.FindColumns(query.QueryText);
foreach (Parser.columnstruct n in columnlist)
{
SelectColumns columns = new SelectColumns();
var tbl =
from c in context.Tables
where c.queryID == query.ID &&
(c.AliasName.Replace("[", "").Replace("]", "") == n.Alias || c.TableName.Replace("[", "").Replace("]", "") == n.Alias)
select c.TableName;
if (tbl.Count() > 0)
{
columns.QueryID = query.ID;
columns.TableName = tbl.First().ToString();
columns.ColumnName = n.Column;
context.columnlist.Add(columns);
}
}
context.SaveChanges();
List <Parser.wherestruct> whereclauseList = Parser.GetFilterCriteriaFromQueryString(query.QueryText, tablelist);
foreach (Parser.wherestruct n in whereclauseList)
{
WhereClause whereclauseClass = new WhereClause();
whereclauseClass.ColumnName = n.Column;
whereclauseClass.comparison_operator = n.comparison_operator;
whereclauseClass.comparison_value = n.comparison_value;
whereclauseClass.TableName = n.Table;
whereclauseClass.QueryID = query.ID;
whereclauseClass.function_string = n.function_string;
whereclauseClass.function_name = n.function_name;
context.whereclause.Add(whereclauseClass);
}
context.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View());
}
}
public void OnTokenReceived(object sender, Firebase.Messaging.TokenReceivedEventArgs token)
{
UnityEngine.Debug.Log("Received Registration Token: " + token.Token);
LoadSaveService.game.playerModel.token = token.Token;
QueryMaster.savePlayer(LoadSaveService.game.playerModel);
}