public Java.Lang.String getArrangmentLst(Java.Lang.String national, Java.Lang.String idTipo)
{
using (var db = FactoryConn.GetConn()) {
var n = bool.Parse(national.ToString());
var typ = int.Parse(idTipo.ToString());
List <ArrangementView> lstArrmntView = new List <ArrangementView> ();
var arras = db.Table <Arrangement> ().Where(ar => ar.IsNational == n &&
ar.Type == typ).OrderByDescending(ar => ar.Index).ToList();
foreach (Arrangement ar in arras)
{
ArrangementView arVnew = new ArrangementView();
arVnew.id = ar.Id;
arVnew.name = ar.Description;
arVnew.isDefault = ar.IsDefault;
if (arVnew.isDefault == true)
{
arVnew.selVal = true;
arVnew.description = "--";
}
else
{
arVnew.selVal = false;
}
arVnew.isExclusive = ar.IsExclusive;
lstArrmntView.Add(arVnew);
}
db.Close();
return(new Java.Lang.String(JsonConvert.SerializeObject(lstArrmntView)));
}
}
public List <ArrangementView> getArrangmentLst(Boolean?national, int?idTipo, int?idFormato)
{
List <ArrangementView> lstArrmntView = new List <ArrangementView> ();
using (var db = FactoryConn.GetConn()) {
var lstArrmnt = db.Table <Arrangement> ().Where(Arr => Arr.IsNational == national && Arr.Type == idTipo).ToList();
foreach (Arrangement arrmnt in lstArrmnt)
{
ArrangementView arrV = new ArrangementView();
arrV.id = arrmnt.Id;
arrV.name = arrmnt.Description;
arrV.isDefault = arrmnt.IsDefault;
if (arrV.isDefault == true)
{
arrV.selVal = true;
}
else
{
arrV.selVal = false;
}
arrV.isExclusive = arrmnt.IsExclusive;
var intermedia = db.Table <AssignedArrangement> ().Where(asar => asar.HearingFormat == idFormato &&
asar.Arrangement == arrV.id).FirstOrDefault();
if (intermedia != null && intermedia.Description != "")
{
arrV.description = intermedia.Description;
arrV.selVal = true;
}
else
{
arrV.description = "";
}
lstArrmntView.Add(arrV);
}
db.Close();
}
return(lstArrmntView);
}