public JQueryDataTableResponse GetAll(string search, int?sortColumn, string sortOrder, int skip, int take, string sEcho)
{
int total, filtered;
List <Tag> tags = _tagDAL.GetAll(search, sortColumn, sortOrder, skip, take, DeleteFlag.Active, out total, out filtered);
IEnumerable <string[]> data = new List <string[]>();
if (tags != null)
{
int i = skip + 1;
data = from t in tags
let index = i++
select new[]
{
index.ToString(),
t.Content,
t.GrammarTags.Count.ToString(),
t.Id.ToString(),
t.Id.ToString(),
t.Id.ToString()
};
}
JQueryDataTableResponse response = new JQueryDataTableResponse()
{
sEcho = sEcho,
iTotalRecords = total,
iTotalDisplayRecords = filtered,
aaData = data
};
return(response);
}
public ActionResult LoadPlayersToAssociate(JQueryDataTableRequest jqueryTableRequest, string teamId, int count, int workerTypeId)
{
if (jqueryTableRequest != null)
{
TeamEngineDTO team = TeamEngineService.Instance.GetById(teamId);
List <string> externalIds = GetWorkersOnTeamCache();
externalIds.Add(team.MasterPlayerId);
List <WorkerDTO> workers = WorkerRepository.Instance.GetUserProfileByWorkerTypeIdExceptWhenOnListOfExternalIds(externalIds, workerTypeId, jqueryTableRequest.Page);
JQueryDataTableResponse response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = count,
RecordsFiltered = count,
Data = workers.Select(r => new string[] { r.ExternalId, r.Name, r.Email }).ToArray()
};
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
//
// GET: /Tag/IndexAjax
public ActionResult IndexAjax(JQueryDataTableRequest request)
{
JQueryDataTableResponse response = _tagBLL.GetAll(request.sSearch, request.iSortCol_0, request.sSortDir_0
, request.iDisplayStart, request.iDisplayLength, request.sEcho);
return(Json(response, JsonRequestBehavior.AllowGet));
}
public JQueryDataTableResponse GetAll(string search, int?sortColumn, string sortOrder, int skip, int take, string sEcho)
{
int total, filtered;
List <Grammar> grammars = _grammarDAL.GetAll(search, sortColumn, sortOrder, skip, take, DeleteFlag.Active, out total, out filtered);
IEnumerable <string[]> data = new List <string[]>();
if (grammars != null)
{
int i = skip + 1;
data = from g in grammars
let index = i++
select new[]
{
index.ToString(),
g.Content,
string.Join(", ", g.GrammarTags.Select(gm => gm.Tag.Content).ToArray()),
g.Id.ToString(),
g.Id.ToString(),
g.Id.ToString()
};
}
JQueryDataTableResponse response = new JQueryDataTableResponse()
{
sEcho = sEcho,
iTotalRecords = total,
iTotalDisplayRecords = filtered,
aaData = data
};
return(response);
}
public ActionResult SearchMetricResults(JQueryDataTableRequest jqueryTableRequest, string metricId, string episodeId, string teamId, string playerId)
{
if (jqueryTableRequest != null)
{
GetAllDTO all = new GetAllDTO();
if (playerId != "" && playerId != "empty")
{
RunEngineDTO run = RunEngineService.Instance.GetRunByPlayerAndTeamId(playerId, teamId);
all = RunMetricEngineService.Instance.findByRunIdAndMetricId(run.Id, metricId, jqueryTableRequest.Page);
}
else if (teamId != "" && teamId != "empty" && teamId != "null")
{
all = TeamEngineService.Instance.resultsByTeamIdAndMetricId(teamId, metricId, jqueryTableRequest.Page);
}
else
{
all = EpisodeEngineService.Instance.resultsByEpisodeIdAndMetricId(episodeId, metricId, jqueryTableRequest.Page);
}
List <WorkerDTO> workers = all.List == null ? new List <WorkerDTO>() : WorkerRepository.Instance.GetWorkerDTOByListExternalId(all.List.runMetric.Select(i => i.PlayerId).ToList());
GetAllDTO itens = ItemEngineService.Instance.GetByGameId(CurrentFirm.ExternalId, 0, 1000);
if (all.List != null)
{
foreach (RunMetricEngineDTO rm in all.List.runMetric)
{
DateTime dat = new DateTime(rm.Date);
string ds = dat.ToString("dd/MM/yyyy");
}
}
else
{
all.List = new GetAllDTO.Embedded();
all.List.runMetric = new List <RunMetricEngineDTO>();
}
JQueryDataTableResponse response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = (from runMetric in all.List.runMetric
join worker in workers on runMetric.PlayerId equals worker.ExternalId into runMetricWorker
from rmw in runMetricWorker.DefaultIfEmpty()
select new { Date = new DateTime(runMetric.Date), WorkerName = rmw != null ? rmw.Name : "Jogador excluído", Email = rmw != null ? rmw.Email : "", Result = runMetric.Points, RunMetricId = runMetric.Id, ItemName = itens.List == null ? "" : (itens.List.item.Where(q => q.Id == runMetric.ItemId).Select(x => x.Name)).FirstOrDefault() }).
Select(r => new string[] { r.Date.ToString("dd/MM/yyyy"), r.WorkerName, r.Email, r.ItemName, r.Result.ToString(), r.RunMetricId }).ToArray()
};
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult SearchPlayers(JQueryDataTableRequest jqueryTableRequest, string episodeId, string metricId)
{
GetAllDTO all;
if (jqueryTableRequest != null)
{
all = RunEngineService.Instance.ScoreByEpisodeIdAndMetricId(episodeId, metricId == "empty" ? "" : metricId, jqueryTableRequest.Page);
foreach (RunEngineDTO run in all.List.run)
{
try
{
run.LogoId = PlayerEngineService.Instance.GetById(run.PlayerId).LogoId;
}
catch (Exception e)
{
run.LogoId = 0;
}
}
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.run.Select(t => new string[] { jqueryTableRequest.Page.ToString(), t.PlayerName + ";" + t.LogoId + ";" + t.PlayerId + ";" + t.TeamId, t.TeamName, t.Score.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.run.Select(t => new string[] { jqueryTableRequest.Page.ToString(), t.PlayerName + ";" + t.LogoId + ";" + t.PlayerId + ";" + t.TeamId, t.TeamName, t.Score.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search()
{
LinqTable optHelper = new LinqTable();
var result = optHelper.BlogHelper();
result = result.Where(x => x.Categore == "成品展覽");
int totalLen = Convert.ToInt16(result.Count());
JQueryDataTableResponse <ArticleViewModel> jqDataTableRs = JQueryDataTableHelper <ArticleViewModel> .GetResponse(1, totalLen, totalLen, result.ToList());
return(Json(jqDataTableRs));
}
public ActionResult Search()
{
var Emp = EmployeePageService.GetAll();
var result = (from emp in Emp
select new Employee
{
Name = emp.Name,
Account = emp.Account
}).ToList();
int totalLen = Convert.ToInt16(result.Count());
JQueryDataTableResponse <Employee> jqDataTableRs = JQueryDataTableHelper <Employee> .GetResponse(1, totalLen, totalLen, result.ToList());
return(Json(jqDataTableRs));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string episodeId)
{
if (jqueryTableRequest != null)
{
List <string> externalIds = new List <string>();
GetAllDTO all = TeamEngineService.Instance.FindByEpisodeIdAndGameId(episodeId, CurrentFirm.ExternalId, jqueryTableRequest.Page);
externalIds.AddRange((from team in all.List.team where team.MasterPlayerId != null select team.MasterPlayerId).ToList());
List <WorkerDTO> sponsors = WorkerRepository.Instance.GetWorkerDTOByListExternalId(externalIds);
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.team.Select(t => new string[] { t.Nick + ";" + t.LogoId, (t.MasterPlayerId == null ? "Não há responsável por essa equipe." : sponsors.Find(w => w.ExternalId == t.MasterPlayerId) != null ? sponsors.Find(w => w.ExternalId == t.MasterPlayerId).Name : ""), t.Id }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.team.Select(t => new string[] { t.Nick + ";" + t.LogoId, (t.MasterPlayerId == null ? "Não há responsável por essa equipe." : sponsors.Find(w => w.ExternalId == t.MasterPlayerId) != null ? sponsors.Find(w => w.ExternalId == t.MasterPlayerId).Name : ""), t.Id }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult SearchWorkeTypesToAssociate(JQueryDataTableRequest jqueryTableRequest, string metricId, int NumberOfFunctionsToAssociate)
{
if (jqueryTableRequest != null)
{
string filter = "";
string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None);
filter = searchTerms[0];
List <WorkerTypeEntity> searchResult = null;
searchResult = WorkerTypeMetricRepository.Instance.GetAllToAssociate(metricId, CurrentFirm.ExternalId, jqueryTableRequest.Page, 10);
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = NumberOfFunctionsToAssociate,
RecordsFiltered = NumberOfFunctionsToAssociate,
Data = searchResult.Select(r => new string[] { r.Id.ToString(), r.TypeName }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = NumberOfFunctionsToAssociate,
RecordsFiltered = NumberOfFunctionsToAssociate,
Data = searchResult.Select(r => new string[] { r.Id.ToString(), r.TypeName }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string teamId)
{
if (jqueryTableRequest != null)
{
TeamEngineDTO team = TeamEngineService.Instance.GetById(teamId);
GetAllDTO all = RunEngineService.Instance.GetRunsByTeamId(teamId);
List <string> externalIds = all.List.run.Select(x => x.PlayerId).Where(q => q != team.MasterPlayerId).Skip(10 * jqueryTableRequest.Page).Take(10).ToList();
List <WorkerDTO> workers = WorkerRepository.Instance.GetDTOFromListExternalId(externalIds);
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.List.run.Count() - 1,
RecordsFiltered = all.List.run.Count() - 1,
Data = workers.Select(r => new string[] { r.Name + ";" + r.LogoId, r.Email, r.WorkerTypeName, r.ExternalId }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.List.run.Count() - 1,
RecordsFiltered = all.List.run.Count() - 1,
Data = workers.Select(r => new string[] { r.Name + ";" + r.LogoId, r.Email, r.WorkerTypeName, r.ExternalId }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(string Lang)
{
var blog = BloggerService.GetAll();
var articles = ArticleService.GetAll();
LinqTable optHelper = new LinqTable();
var result = optHelper.ArtHelper();
result = result.Where(x => x.Categore == "服務頁");
if (!String.IsNullOrEmpty(Lang))
{
result = result.Where(i => i.Id == int.Parse(Lang)).ToList();
}
int totalLen = Convert.ToInt16(result.Count());
JQueryDataTableResponse <ArticleViewModel> jqDataTableRs = JQueryDataTableHelper <ArticleViewModel> .GetResponse(1, totalLen, totalLen, result.ToList());
return(Json(jqDataTableRs));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest)
{
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
if (jqueryTableRequest != null)
{
string gameId = CurrentFirm.ExternalId;
List <ParamEntity> paramList = ParamRepository.Instance.GetAll(gameId, jqueryTableRequest.Page);
int count = ParamRepository.Instance.GetCountFromGame(gameId);
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = count,
RecordsFiltered = count,
Data = paramList.Select(r => new string[] { r.Name, r.Value, r.Description, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = count,
RecordsFiltered = count,
Data = paramList.Select(r => new string[] { r.Name, r.Value, r.Description, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult SearchPlayersFromTeam(JQueryDataTableRequest jqueryTableRequest, string teamId)
{
if (jqueryTableRequest != null)
{
List <string> allExternalWorkerIds = GetWorkersOnTeamCache();
List <string> externalIds = (from externalId in allExternalWorkerIds select externalId).Skip(jqueryTableRequest.Page * 10).Take(10).ToList();
List <WorkerDTO> workers = WorkerRepository.Instance.GetUserProfileByListOfExternalIds(externalIds);
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = allExternalWorkerIds.Count(),
RecordsFiltered = allExternalWorkerIds.Count(),
Data = workers.Select(r => new string[] { r.Name + ";" + r.LogoId.ToString(), r.Email, r.ExternalId }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = allExternalWorkerIds.Count(),
RecordsFiltered = allExternalWorkerIds.Count(),
Data = workers.Select(r => new string[] { r.Name + ";" + r.LogoId.ToString(), r.Email, r.ExternalId }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult searchWithID(JQueryDataTableRequest jqueryTableRequest)
{
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
if (jqueryTableRequest != null)
{
GetAllDTO all = EpisodeEngineService.Instance.GetByGameId(CurrentFirm.ExternalId, jqueryTableRequest.Page);
JQueryDataTableResponse response = null;
DateTime dateInit;
DateTime dateFinish;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.episode.Select(r => new string[] { r.Id, r.Name, (dateInit = new DateTime(r.initDate)).ToString("dd/MM/yyyy"), (dateFinish = new DateTime(r.finishDate)).ToString("dd/MM/yyyy"), r.XpReward.ToString(), r.Active == true ? "Sim" : "Não", r.sendEmail == true ? "Sim" : "Não", r.Id }).ToArray().ToArray() //.OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.episode.Select(r => new string[] { r.Id, r.Name, (dateInit = new DateTime(r.initDate)).ToString("dd/MM/yyyy"), (dateFinish = new DateTime(r.finishDate)).ToString("dd/MM/yyyy"), r.XpReward.ToString(), r.Active == true ? "Sim" : "Não", r.sendEmail == true ? "Sim" : "Não", r.Id }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest)
{
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
if (jqueryTableRequest != null)
{
GetAllDTO all = MetricEngineService.Instance.GetAllDTOByGame(CurrentFirm.ExternalId, jqueryTableRequest.Page);
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.metric.Select(r => new string[] { r.Icon + ";" + r.Name, r.Multiplier.ToString(), r.Id }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.metric.Select(r => new string[] { r.Icon + ";" + r.Name, r.Multiplier.ToString(), r.Id }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest)
{
int index = jqueryTableRequest.Page;
if (jqueryTableRequest != null)
{
var all = QuestionService.Instance.GetAllFromFirm(CurrentFirm.Id, jqueryTableRequest.Search, index, jqueryTableRequest.Length);
var total = QuestionService.Instance.GetCountFromFirm(CurrentFirm.Id, jqueryTableRequest.Search);
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = total,
RecordsFiltered = all.Count(),
Data = all.Select(r => new string[] { r.Id.ToString(), r.Question, r.status.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = total,
RecordsFiltered = all.Count(),
Data = all.Select(r => new string[] { r.Id.ToString(), r.Question, r.status.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string metricId, int numberOfFunctions)
{
if (jqueryTableRequest != null)
{
List <WorkerTypeMetricDTO> searchResult = null;
searchResult = WorkerTypeMetricRepository.Instance.GetAllDTOFromMetric(metricId, jqueryTableRequest.Page, 10);
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = numberOfFunctions,
RecordsFiltered = numberOfFunctions,
Data = searchResult.Select(r => new string[] { r.WorkerTypeName, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = numberOfFunctions,
RecordsFiltered = numberOfFunctions,
Data = searchResult.Select(r => new string[] { r.WorkerTypeName, r.Id.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search()
{
var a = DateTime.Now.ToString("yyyy-MM-dd");
var contact = ContactService.GetAll();
var result = (from b in contact
select new Contact
{
Id = b.Id,
Name = b.Name,
Phone = b.Phone,
Email = b.Email,
Service = b.Service,
Time = DBNull.Value.Equals(b.CreateTime) ? "" :ToYMD(b.CreateTime),
Memo = b.Memo
}).ToList();
int totalLen = Convert.ToInt16(result.Count());
JQueryDataTableResponse <Contact> jqDataTableRs = JQueryDataTableHelper <Contact> .GetResponse(1, totalLen, totalLen, result.ToList());
return(Json(jqDataTableRs));
}
public ActionResult SearchAssociate(JQueryDataTableRequest jqueryTableRequest, int id)
{
int index = jqueryTableRequest.Page;
if (jqueryTableRequest != null)
{
var association = QuestionAnswerService.Instance.GetByQuestion(id);
var all = new List <AnswersEntity>();
foreach (var item in association)
{
var entity = AnswerService.Instance.GetById(item.IdAnswer);
entity.IdAssociate = item.Id;
all.Add(entity);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsFiltered = all.Count(),
Data = all.Select(r => new string[] { r.Id.ToString(), r.Name, r.Answer, r.status.ToString(), r.IdAssociate.ToString() }).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult SearchAssociate(JQueryDataTableRequest jqueryTableRequest, int id)
{
int index = jqueryTableRequest.Page;
var listAssociated = QuizCampaignService.Instance.getByAssociated(id);
var episodeList = new List <EpisodeEngineDTO>();
foreach (var item in listAssociated)
{
var episode = EpisodeEngineService.Instance.GetById(item.IdCampaign);
episode.Id = item.Id.ToString();
episodeList.Add(episode);
}
DateTime dateInit;
DateTime dateFinish;
if (jqueryTableRequest != null)
{
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsFiltered = episodeList.Count(),
Data = episodeList.Select(r => new string[] { r.Id, r.Name, (dateInit = new DateTime(r.initDate)).ToString("dd/MM/yyyy"), (dateFinish = new DateTime(r.finishDate)).ToString("dd/MM/yyyy"), r.XpReward.ToString(), r.Active == true ? "Sim" : "Não", r.sendEmail == true ? "Sim" : "Não", r.Id }).ToArray().ToArray() //.OrderBy(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult SearchCheckIn(JQueryDataTableRequest jqueryTableRequest, string episodeId, string metricId, string teamId, string playerId)
{
if (jqueryTableRequest != null)
{
GetAllDTO all = new GetAllDTO();
List <RunEngineDTO> runners = new List <RunEngineDTO>();
if (playerId != "empty")
{
RunEngineDTO runner = RunEngineService.Instance.GetByEpisodeIdAndPlayerId(episodeId, playerId);
runners.Add(runner);
}
else if (teamId != "empty")
{
runners = GetRunsByTeamIdRecursive(teamId);
}
else
{
all = TeamEngineService.Instance.FindByEpisodeId(episodeId);
all.List.team = all.List.team.OrderBy(x => x.Nick).ToList();
List <string> subTeamsNull = all.List.team.Where(x => x.SubOfTeamId == null).Select(x => x.Id).ToList();
List <TeamEngineDTO> teams = new List <TeamEngineDTO>();
foreach (string subTeamNull in subTeamsNull)
{
teams.AddRange(OrganizeHierarchy(all.List.team, subTeamNull));
}
foreach (TeamEngineDTO team in teams)
{
runners.AddRange(GetRunsByTeamIdRecursive(team.Id));
}
}
MetricEngineDTO metric = MetricEngineService.Instance.GetById(metricId);
List <LocationDTO> locations = MetricEngineService.Instance.MapPointsByRunsAndMetric(runners, metric);
List <CheckInDTO> checkIns = new List <CheckInDTO>();
foreach (LocationDTO location in locations)
{
CheckInDTO ci = new CheckInDTO();
DateTime date = new DateTime(((location.Date - 10800000) * 10000) + 621355968000000000l);
ci.Date = date.ToString("dd'/'MM'/'yyyy HH':'mm':'ss");
PlayerEngineDTO player = PlayerEngineService.Instance.GetById(location.PlayerId);
ci.PlayerName = player.Nick;
ci.Description = location.Description ?? "Check-in";
ci.Place = location.Place;
checkIns.Add(ci);
}
JQueryDataTableResponse response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = locations.Count,
RecordsFiltered = locations.Count,
Data = checkIns.OrderByDescending(r => DateTime.Parse(r.Date)).Select(r => new string[] { r.Date, r.PlayerName, r.Description, r.Place }).ToArray()
};
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, int numberOfWorkers)
{
numberOfWorkers = WorkerRepository.Instance.GetCountFromFirm(CurrentFirm.Id);
if (jqueryTableRequest != null)
{
string filter = "";
string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None);
filter = searchTerms[0];
List <WorkerDTO> searchResult = null;
searchResult = WorkerRepository.Instance.GetAllFromFirm(CurrentFirm.Id, jqueryTableRequest.Page, 10);
var searchedQueryList = new List <WorkerDTO>();
searchedQueryList = searchResult;
if (!string.IsNullOrWhiteSpace(filter))
{
filter = filter.ToLowerInvariant().Trim();
var searchedQuery = from n in searchResult
where (n.Cpf != null && n.Cpf.ToLowerInvariant().Trim().Contains(filter)) ||
n.Name.ToLowerInvariant().Trim().Contains(filter) ||
n.Email.ToLowerInvariant().Trim().Contains(filter)
select n;
searchedQueryList = searchedQuery.ToList();
}
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = numberOfWorkers,
RecordsFiltered = numberOfWorkers,
Data = searchedQueryList.Select(r => new string[] { r.Name + ";" + r.LogoId.ToString(), r.Email, r.WorkerTypeName, r.IdWorker.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = numberOfWorkers,
RecordsFiltered = numberOfWorkers,
Data = searchedQueryList.Select(r => new string[] { r.Name + ";" + r.LogoId.ToString(), r.Email, r.WorkerTypeName, r.IdWorker.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest)
{
if (jqueryTableRequest != null)
{
string filter = "";
string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None);
filter = searchTerms[0];
List <VideoEntity> searchResult = null;
searchResult = VideoRepository.Instance.GetAllFromFirm(CurrentFirm.Id);
var searchedQueryList = new List <VideoEntity>();
searchedQueryList = searchResult;
if (!string.IsNullOrWhiteSpace(filter))
{
filter = filter.ToLowerInvariant().Trim();
var searchedQuery = from n in searchResult
where (n.VideoTitle.ToLowerInvariant().Trim().Contains(filter))
select n;
searchedQueryList = searchedQuery.ToList();
}
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = (jqueryTableRequest.Page + 1) * 10 - (10 - searchedQueryList.Count),
RecordsFiltered = (jqueryTableRequest.Page + 1) * 10 + 1,
Data = searchedQueryList.Select(r => new string[] { r.VideoTitle, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = (jqueryTableRequest.Page + 1) * 10 - (10 - searchedQueryList.Count),
RecordsFiltered = (jqueryTableRequest.Page + 1) * 10 + 1,
Data = searchedQueryList.Select(r => new string[] { r.VideoTitle, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string episodeId, string teamId)
{
GetAllDTO all;
if (jqueryTableRequest != null)
{
if (teamId != "empty")
{
all = RunEngineService.Instance.GetRunsByTeamId(teamId);
List <PlayerEngineDTO> players = (from run in all.List.run select PlayerEngineService.Instance.GetById(run.PlayerId)).ToList();
all.List.result = (from run in all.List.run
from player in players
where run.PlayerId == player.Id &&
player.Active == true
select new ResultEngineDTO
{
Id = player.Id,
Nick = player.Nick,
Score = run.Score,
LogoId = player.LogoId
}).ToList();
}
else
{
all = TeamEngineService.Instance.FindByEpisodeIdAndGameId(episodeId, CurrentFirm.ExternalId, jqueryTableRequest.Page, 1000);
all.List.result = (from team in all.List.team
select new ResultEngineDTO
{
Id = team.Id,
Nick = team.Nick,
Score = team.Score,
LogoId = team.LogoId
}).ToList();
}
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = 1, //all.PageInfo.totalElements,
RecordsFiltered = 1, //all.PageInfo.totalElements,
Data = all.List.result.OrderBy(t => t.Nick).Select(t => new string[] { t.Id, t.Nick }).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = 1, //all.PageInfo.totalElements,
RecordsFiltered = 1, //all.PageInfo.totalElements,
Data = all.List.result.OrderByDescending(t => t.Nick).Select(t => new string[] { t.Id, t.Nick }).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, int numberOfQuiz)
{
string episodeId = Request["episodeId"];
numberOfQuiz = EpisodeQuizEngineService.Instance.GetByEpisodeId(episodeId).List.quizSheet.Count;
if (jqueryTableRequest != null)
{
string filter = "";
string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None);
filter = searchTerms[0];
List <EpisodeQuizEngineDTO> searchResult = null;
searchResult = EpisodeQuizEngineService.Instance.GetByEpisodeId(episodeId).List.quizSheet;
var searchedQueryList = new List <EpisodeQuizEngineDTO>();
searchedQueryList = searchResult;
if (!string.IsNullOrWhiteSpace(filter))
{
filter = filter.ToLowerInvariant().Trim();
var searchedQuery = from n in searchResult
where (n.Title != null && n.Title.ToLowerInvariant().Trim().Contains(filter))
select n;
searchedQueryList = searchedQuery.ToList();
}
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = numberOfQuiz,
RecordsFiltered = numberOfQuiz,
Data = searchedQueryList.Select(r => new string[] { r.Title, r.Id.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = numberOfQuiz,
RecordsFiltered = numberOfQuiz,
Data = searchedQueryList.Select(r => new string[] { r.Title, r.Id.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string episodeId, string teamId, int workerTypeId = 0)
{
if (jqueryTableRequest != null)
{
if (Request["episodeId"] != null && !string.IsNullOrWhiteSpace(Request["episodeId"]) && !Request["episodeId"].Equals("undefined"))
{
episodeId = Request["episodeId"];
}
if (Request["teamId"] != null && !string.IsNullOrWhiteSpace(Request["teamId"]) && !Request["teamId"].Equals("undefined"))
{
teamId = Request["teamId"];
}
if (Request["workerTypeId"] != null && !string.IsNullOrWhiteSpace(Request["workerTypeId"]) && !Request["workerTypeId"].Equals("undefined"))
{
workerTypeId = int.Parse(Request["workerTypeId"]);
}
string filter = "";
string[] searchTerms = jqueryTableRequest.Search.Split(new string[] { "#;$#" }, StringSplitOptions.None);
filter = searchTerms[0];
List <RankingDTO> searchResult = null;
if (episodeId != null && !episodeId.Equals(""))
{
if (teamId != null && !teamId.Equals(""))
{
TeamEntity team = TeamRepository.Instance.GetByIdExterno(teamId);
WorkerTypeEntity workerType = WorkerTypeRepository.Instance.GetById(team.WorkerTypeId);
if (workerType.ProfileName.Equals(Profiles.LIDER))
{
List <RankingDTO> rankingDTOList = new List <RankingDTO>();
//List<PlayerRunEntity> playerRunList = PlayerRunRepository.Instance.GetByEpisodeAndTeam(episodeId.ToString(), teamId);
GetAllDTO runnersDTO = RunEngineService.Instance.GetRunsByTeamId(teamId);
// buscar lista de run ao inves da tabela
foreach (RunEngineDTO item in runnersDTO.List.run)
{
RankingDTO dto = new RankingDTO();
WorkerDTO worker = WorkerRepository.Instance.GetDTOById(item.PlayerId);
//run .get player ID
dto = EngineBIZ.GetGlobalScoreInEpisodeByEpisodeAndPlayer(episodeId.ToString(), worker.ExternalId);
dto.LogoId = worker.LogoId;
dto.PlayerId = worker.ExternalId;
dto.PlayerName = worker.Name;
dto.LogoId = worker.LogoId;
rankingDTOList.Add(dto);
}
searchResult = rankingDTOList;
}
else
{
List <RankingDTO> rankingDTOList = new List <RankingDTO>();
GetAllDTO runnersDTO = RunEngineService.Instance.GetRunsByTeamId(teamId);
foreach (RunEngineDTO item in runnersDTO.List.run)
{
RankingDTO dto = new RankingDTO();
WorkerDTO worker = WorkerRepository.Instance.GetDTOById(item.PlayerId);
dto = EngineBIZ.GetScoreByRun(item.Id);
dto.PlayerName = worker.Name;
dto.LogoId = worker.LogoId;
rankingDTOList.Add(dto);
}
searchResult = rankingDTOList;
}
}
else
{
List <EngineTeamDTO> teamsFromEngine = new List <EngineTeamDTO>();
List <TeamEntity> teams = new List <TeamEntity>();
teamsFromEngine.AddRange(EngineBIZ.GetTeamsByEpisode(episodeId.ToString()));
if (workerTypeId > 0)
{
foreach (EngineTeamDTO item in teamsFromEngine)
{
TeamEntity team = new TeamEntity();
team = TeamRepository.Instance.GetByIdExterno(item.IdExterno);
teams.Add(team);
}
var teamsVar = from n in teams
where n.WorkerTypeId == workerTypeId
select n;
teams = teamsVar.ToList();
}
else
{
foreach (EngineTeamDTO item in teamsFromEngine)
{
TeamEntity team = new TeamEntity();
team = TeamRepository.Instance.GetByIdExterno(item.IdExterno);
teams.Add(team);
}
}
List <RankingDTO> rankingDTOList = new List <RankingDTO>();
foreach (TeamEntity team in teams)
{
if (team != null)
{
WorkerTypeEntity workerType = WorkerTypeRepository.Instance.GetById(team.WorkerTypeId);
RankingDTO rankingDTO = new RankingDTO();
if (workerType.ProfileName.Equals(Profiles.LIDER))
{
WorkerEntity sponsor = WorkerRepository.Instance.GetById(team.SponsorId);
rankingDTO = EngineBIZ.GetGlobalScoreInEpisodeByEpisodeAndPlayer(episodeId.ToString(), sponsor.ExternalId);
rankingDTO.LogoId = team.LogoId;
rankingDTO.PlayerId = team.ExternalId;
rankingDTO.PlayerName = team.TeamName;
}
else
{
rankingDTO = EngineBIZ.GetTeamScoreByTeamId(team.ExternalId);
rankingDTO.LogoId = team.LogoId;
}
rankingDTOList.Add(rankingDTO);
}
}
searchResult = rankingDTOList;
}
}
else
{
searchResult = new List <RankingDTO>();
}
var searchedQueryList = new List <RankingDTO>();
searchedQueryList = searchResult;
if (!string.IsNullOrWhiteSpace(filter))
{
filter = filter.ToLowerInvariant().Trim();
var searchedQuery = from n in searchResult
where (n.PlayerName != null && n.PlayerName.ToLowerInvariant().Trim().Contains(filter))
orderby n.Score descending
select n;
searchedQueryList = searchedQuery.ToList();
}
else
{
var searchedQuery = from n in searchResult
orderby n.Score descending
select n;
searchedQueryList = searchedQuery.ToList();
}
int index = Int32.Parse(jqueryTableRequest.Order);
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = (jqueryTableRequest.Page + 1) * 10 - (10 - searchedQueryList.Count),
RecordsFiltered = (jqueryTableRequest.Page + 1) * 10 + 1,
Data = searchedQueryList.Select(r => new string[] { r.PlayerId != null ? r.PlayerId.ToString() : "", r.PlayerName + ";" + r.LogoId.ToString(), r.Score != null ? r.Score.Value.ToString() : 0.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = (jqueryTableRequest.Page + 1) * 10 - (10 - searchedQueryList.Count),
RecordsFiltered = (jqueryTableRequest.Page + 1) * 10 + 1,
Data = searchedQueryList.Select(r => new string[] { r.PlayerId != null ? r.PlayerId.ToString() : "", r.PlayerName + ";" + r.LogoId.ToString(), r.Score != null ? r.Score.Value.ToString() : 0.ToString() }).ToArray().OrderByDescending(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(JQueryDataTableRequest jqueryTableRequest, string episodeId, string teamId, string metricId)
{
GetAllDTO all;
if (metricId == "empty")
{
metricId = "";
}
if (jqueryTableRequest != null)
{
if (teamId != "empty")
{
all = RunEngineService.Instance.GetAllRunScore(teamId, metricId, jqueryTableRequest.Page);
List <PlayerEngineDTO> players = (from run in all.List.run select PlayerEngineService.Instance.GetById(run.PlayerId)).ToList();
all.List.result = (from run in all.List.run
from player in players
where run.PlayerId == player.Id
select new ResultEngineDTO
{
Id = player.Id,
Nick = player.Nick,
Score = run.Score,
LogoId = player.LogoId
}).ToList();
}
else if (episodeId != "null")
{
all = TeamEngineService.Instance.GetAllTeamScoreByEpisodeId(episodeId, metricId, jqueryTableRequest.Page);
all.List.result = (from team in all.List.team
select new ResultEngineDTO
{
Id = team.Id,
Nick = team.Nick,
Score = team.Score,
LogoId = team.LogoId
}).ToList();
}
else
{
all = new GetAllDTO();
all.List = new GetAllDTO.Embedded();
all.PageInfo = new GetAllDTO.Page();
all.List.result = new List <ResultEngineDTO>();
}
int index = 0;
if (jqueryTableRequest.Order != null)
{
index = Int32.Parse(jqueryTableRequest.Order);
}
JQueryDataTableResponse response = null;
if (jqueryTableRequest.Type == null || jqueryTableRequest.Type.Equals("asc"))
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.result.Select(t => new string[] { jqueryTableRequest.Page.ToString(), t.Nick + ";" + t.LogoId + ";" + t.Id, t.Score.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
else
{
response = new JQueryDataTableResponse()
{
Draw = jqueryTableRequest.Draw,
RecordsTotal = all.PageInfo.totalElements,
RecordsFiltered = all.PageInfo.totalElements,
Data = all.List.result.Select(t => new string[] { jqueryTableRequest.Page.ToString(), t.Nick + ";" + t.LogoId + ";" + t.Id, t.Score.ToString() }).ToArray().OrderBy(item => item[index]).ToArray()
};
}
return(new DataContractResult()
{
Data = response, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
