public IActionResult Post([FromBody] TSearch _data)
{
var data = _service.GetTableData(_data);
var teams = data[0];
var userId = _userManager.GetUserId(User);
var vms = new List <CheckTeamMemberVM>();
foreach (var team in teams)
{
var isMember = false;
foreach (var member in team.TeamMembers)
{
if (member.ApplicationUserId == userId)
{
isMember = true;
}
}
var vm = new CheckTeamMemberVM()
{
Team = team,
IsMember = isMember
};
vms.Add(vm);
}
var value = new { data = vms };
return(Ok(value));
}
public static ResultData LoadData(TSearch item)
{
ResultData r = new ResultData();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
List <ClassExecute.TDataOutput> lstDataT1 = new List <ClassExecute.TDataOutput>();
List <ClassExecute.TDataOutput> lstData = new List <ClassExecute.TDataOutput>();
int nFormID = 0;
var qForm = db.TEPI_Forms.FirstOrDefault(w => w.IDIndicator == item.nIndicator && w.OperationTypeID == item.nOperationType && w.FacilityID == item.nFacility && w.sYear == item.sYear);
if (qForm != null)
{
nFormID = qForm.FormID;
}
if (item.nIndicator == 10)
{
lstData = FunctionGetData.GetWasteDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 8)
{
lstData = FunctionGetData.GetMaterialDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 6)
{
lstData = FunctionGetData.GetIntensityDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 11)
{
lstData = FunctionGetData.GetWaterDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 1)
{
lstData = FunctionGetData.GetComplaintDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 2)
{
lstData = FunctionGetData.GetComplianceDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 3)
{
lstData = FunctionGetData.GetDataOutput(item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 4)
{
lstData = FunctionGetData.GetDataOutput(item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
lstDataOutputEmission(item.nIndicator, item.nOperationType, item.nFacility, item.sYear, r);
}
else if (item.nIndicator == 9)
{
lstData = FunctionGetData.GetDataOutput(item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
r.lstData = lstData;
r.sFormID = nFormID + "";
r.Status = SystemFunction.process_Success;
return(r);
}
//data table paging
public List <dynamic> GetTableData(TSearch _data)
{
List <dynamic> data = new List <dynamic>();
var id = _data.PageCount;
string nFilter = _data.NameFilter ?? "";
string tFilter = _data.TypeFilter ?? "";
string lFilter = _data.LeaderFilter ?? "";
data.Add(_repo.Query <Team>().Where(t => t.TeamName.Contains(nFilter) && t.PlayStyle.Contains(tFilter) && t.TeamLeader.Contains(lFilter)).Skip(5 * id).Take(5).Select(t => new
{
Id = t.Id,
TeamName = t.TeamName,
PlayStyle = t.PlayStyle,
TeamLeader = t.TeamLeader,
TeamMembers = t.TeamMembers //_repo.Query<TeamMembers>().Where(m => m.TeamId == t.Id).ToList()
}).ToList());
return(data);
}
private void BTodo_Click(object sender, EventArgs e)
{
string Search = TSearch.Text;
string s = "";
List <Pelicula> peliculas = Metodos.DeserializarPeliculas();
List <DirectorPelicula> DPS = Metodos.DeserializarDPS();
List <PeliculaActor> PAS = Metodos.DeserializarPAS();
List <PeliculaProductor> PPS = Metodos.DeserializarPPS();
List <EstudioPelicula> EPS = Metodos.DeserializarEPS();
if (Search.Length <= 2)
{
DialogResult msm;
msm = MessageBox.Show("Ingrese un Nombre valido");
TSearch.Clear();
Metodos.SerializarPeliculas(peliculas);
Metodos.SerializarDPS(DPS);
Metodos.SerializarPAS(PAS);
Metodos.SerializarPPS(PPS);
Metodos.SerializarEPS(EPS);
}
else
{
s += Metodo.BuscarPelicula(Search, s, peliculas, PAS);
s += Metodo.BuscarActor(Search, s, PAS);
s += Metodo.BuscarDirector(Search, s, DPS);
s += Metodo.BuscarProductor(Search, s, PPS);
s += Metodo.BuscarEstudio(Search, s, EPS);
DialogResult msm;
msm = MessageBox.Show(s, "hola");
TSearch.Clear();
Metodos.SerializarPeliculas(peliculas);
Metodos.SerializarDPS(DPS);
Metodos.SerializarPAS(PAS);
Metodos.SerializarPPS(PPS);
Metodos.SerializarEPS(EPS);
}
}
public IActionResult Get(TSearch _data)
{
return(Ok());
}
public IActionResult GetTableData([FromBody] TSearch _data)
{
return(Ok());
}
