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); }