protected override SolarNetwork Extract(ICursor cursor) => new SolarNetwork()
{
ID = cursor.GetInt(cursor.GetColumnIndex(ID)),
Name = cursor.GetString(cursor.GetColumnIndex(Name)),
Latitude = cursor.GetDouble(cursor.GetColumnIndex(Latitude)),
Longtitude = cursor.GetDouble(cursor.GetColumnIndex(Longtitude))
};
//Retrive All Details
public IList <InfoMedica> GetAllInfoMedica(string idPersonal)
{
SQLiteDatabase db = this.ReadableDatabase;
ICursor c = db.Query("InfoMedica", new string[] { "id", "idPersona", "identificacion", "peso", "altura", "presionArterial", "frecuenciaCardiaca", "detalle" }, "idPersona = " + idPersonal, null, null, null, null);
var infoMedica = new List <InfoMedica>();
while (c.MoveToNext())
{
infoMedica.Add(new InfoMedica {
id = c.GetInt(0),
idPersona = Int32.Parse(c.GetString(1)),
identificacion = c.GetString(2),
peso = c.GetDouble(3),
altura = c.GetDouble(4),
presionArterial = c.GetString(5),
frecuenciaCardiaca = c.GetString(6),
detalle = c.GetString(7)
});
}
c.Close();
db.Close();
return(infoMedica);
}
protected override Consumer Extract(ICursor cursor) => new Consumer()
{
ID = cursor.GetInt(cursor.GetColumnIndex(ID)),
NetworkID = cursor.GetInt(cursor.GetColumnIndex(NetworkID)),
Name = cursor.GetString(cursor.GetColumnIndex(Name)),
Icon = cursor.GetString(cursor.GetColumnIndex(Icon)),
EnergyConsumation = cursor.GetDouble(cursor.GetColumnIndex(EnergyConsumation)),
UsageHours = cursor.GetDouble(cursor.GetColumnIndex(UsageHours)),
Count = cursor.GetInt(cursor.GetColumnIndex(Count))
};
protected override Panel Extract(ICursor cursor) => new Panel()
{
ID = cursor.GetInt(cursor.GetColumnIndex(ID)),
NetworkID = cursor.GetInt(cursor.GetColumnIndex(NetworkID)),
ModuleType = (PanelModuleType)cursor.GetInt(cursor.GetColumnIndex(ModuleType)),
ArrayType = (PanelArrayType)cursor.GetInt(cursor.GetColumnIndex(ArrayType)),
TiltAngle = cursor.IsNull(cursor.GetColumnIndex(TiltAngle))
? null : new double?(cursor.GetDouble(cursor.GetColumnIndex(TiltAngle))),
SystemLosses = cursor.GetDouble(cursor.GetColumnIndex(SystemLosses)),
PowerRating = cursor.GetDouble(cursor.GetColumnIndex(PowerRating)),
Count = cursor.GetInt(cursor.GetColumnIndex(Count))
};
internal override void LoadCursor(ICursor cursor, MediaAssetQueryHelper helper)
{
base.LoadCursor(cursor, helper);
if (helper.DateTakenColumn > -1)
{
TakenDate = DateTimeOffset.FromUnixTimeMilliseconds(cursor.GetLong(helper.DateTakenColumn)).DateTime;
}
if (helper.WidthColumn > -1)
{
Width = cursor.GetInt(helper.WidthColumn);
}
if (helper.HeightColumn > -1)
{
Height = cursor.GetInt(helper.HeightColumn);
}
if (helper.LatitudeColumn > -1)
{
Latitude = cursor.GetDouble(helper.LatitudeColumn);
}
if (helper.LongitudeColumn > -1)
{
Longitude = cursor.GetDouble(helper.LongitudeColumn);
}
if (helper.OrientationColumn > -1)
{
switch (cursor.GetInt(helper.OrientationColumn))
{
case 90:
Orientation = MediaFileImageOrientation.Left;
break;
case 180:
Orientation = MediaFileImageOrientation.Down;
break;
case 270:
Orientation = MediaFileImageOrientation.Right;
break;
default:
Orientation = MediaFileImageOrientation.Up;
break;
}
}
}
/// <summary>
/// This is where we fill-in the views with the contents of the cursor.
/// </summary>
/// <param name="view">View.</param>
/// <param name="context">Context.</param>
/// <param name = "cursor"></param>
public override void BindView(View view, Context context, ICursor cursor)
{
// our view is pretty simple here --- just a text view
// we'll keep the UI functional with a simple (and slow!) binding.
var viewHolder = (ViewHolder)view.Tag;
int viewType = GetItemViewType(cursor.Position);
switch (viewType)
{
case ViewTypeToday:
{
// Get weather icon
viewHolder.IconView.SetImageResource(Utility.GetArtResourceForWeatherCondition(
cursor.GetInt(ForecastFragment.ColWeatherConditionId)));
break;
}
case ViewTypeFutureDay:
{
// Get weather icon
viewHolder.IconView.SetImageResource(Utility.GetIconResourceForWeatherCondition(
cursor.GetInt(ForecastFragment.ColWeatherConditionId)));
break;
}
}
// TODO Read date from cursor
var date = cursor.GetLong(ForecastFragment.ColWeatherDate);
viewHolder.DateView.Text = Utility.GetFriendlyDayString(context, date);
// TODO Read weather forecast from cursor
var description = cursor.GetString(ForecastFragment.ColWeatherDesc);
viewHolder.DescriptionView.Text = description;
// For accessibility, add a content description to the icon field
viewHolder.IconView.ContentDescription = description;
// Read high temperature from cursor
double high = cursor.GetDouble(ForecastFragment.ColWeatherMaxTemp);
viewHolder.HighTempView.Text = Utility.FormatTemperature(context, high);
// TODO Read low temperature from cursor
double low = cursor.GetDouble(ForecastFragment.ColWeatherMinTemp);
viewHolder.LowTempView.Text = Utility.FormatTemperature(context, low);
}
public List <Prato> listar()
{
List <Prato> lista = new List <Prato>();
String sql = "Select * from " + TABELA + " ORDER BY nome";
ICursor cursor = ReadableDatabase.RawQuery(sql, null);
try
{
while (cursor.MoveToNext())
{
Prato prat = new Prato();
prat.ID = cursor.GetLong(0);
prat.Nome = cursor.GetString(1);
prat.Valor = cursor.GetDouble(2);
lista.Add(prat);
}
}
catch (SQLException e)
{
Log.Error(TAG, e.Message);
}
finally
{
cursor.Close();
}
return(lista);
}
public List <LatLng> RetrieveMarkerList()
{
string[] columns =
{
MapMarkerContract.MarkerTable._ID,
MapMarkerContract.MarkerTable.COLUMN_NAME_LAT,
MapMarkerContract.MarkerTable.COLUMN_NAME_LONG
};
ICursor cursor = ReadableDatabase.Query(MapMarkerContract.MarkerTable.TABLE_NAME, columns, null, null, null, null, null);
List <LatLng> markerList = new List <LatLng>();
while (cursor.MoveToNext())
{
markerList.Add(new LatLng(cursor.GetDouble(cursor.GetColumnIndex(MapMarkerContract.MarkerTable.COLUMN_NAME_LAT)),
cursor.GetDouble(cursor.GetColumnIndex(MapMarkerContract.MarkerTable.COLUMN_NAME_LONG))));
}
return(markerList);
}
public override void BindView(View view, Context context, ICursor cursor)
{
view.FindViewById <TextView>(Resource.Id.note).Text = cursor.GetString(1);
view.FindViewById <TextView>(Resource.Id.date).Text = cursor.GetString(2);
ImageView i = view.FindViewById <ImageView> (Resource.Id.photo);
i.SetImageBitmap(Utils.GetPreview(cursor.GetString(3), PreviewWidth, PreviewHeigth));
double n = cursor.GetDouble(4);
view.FindViewById <TextView> (Resource.Id.location).Text = string.Format("{0}, {1}", cursor.GetDouble(4), cursor.GetDouble(5));
}
internal override void LoadCursor(ICursor cursor, MediaAssetQueryHelper helper)
{
base.LoadCursor(cursor, helper);
if (helper.DateTakenColumn > -1)
{
TakenDate = DateTimeOffset.FromUnixTimeMilliseconds(cursor.GetLong(helper.DateTakenColumn)).DateTime;
}
if (helper.WidthColumn > -1)
{
Width = cursor.GetInt(helper.WidthColumn);
}
if (helper.HeightColumn > -1)
{
Height = cursor.GetInt(helper.HeightColumn);
}
if (helper.LatitudeColumn > -1)
{
Latitude = cursor.GetDouble(helper.LatitudeColumn);
}
if (helper.LongitudeColumn > -1)
{
Longitude = cursor.GetDouble(helper.LongitudeColumn);
}
if (helper.DurationColumn > -1)
{
Duration = TimeSpan.FromMilliseconds(cursor.GetLong(helper.DurationColumn));
}
if (helper.ArtistColumn > -1)
{
Artist = cursor.GetString(helper.ArtistColumn);
}
}
public string LookForSms(DateTime ahora)
{
bool receiveSms = false;
string codigo = "";
Android.Net.Uri inboxURI = Android.Net.Uri.Parse("content://sms/inbox");
// Esperar sms
while (!receiveSms)
{
if (ahora.AddMinutes(2) < DateTime.UtcNow)
{
receiveSms = true;
codigo = "Ha habido un error";
break;
}
ContentResolver cr = this.ContentResolver;
ICursor cursor = cr.Query(inboxURI, null, null, null, null);
cursor.MoveToFirst();
double date = cursor.GetDouble(cursor.GetColumnIndex("date"));
var time = (new DateTime(1970, 1, 1)).AddMilliseconds(date);
if (cursor != null && cursor.Count > 0)
{
string address = cursor.GetString(cursor.GetColumnIndex("address"));
string body = cursor.GetString(cursor.GetColumnIndex("body"));
if (!string.IsNullOrEmpty(address) && !string.IsNullOrEmpty(body) && time >= ahora)
{
if (address.ToUpper().Contains("SMS") || address.ToUpper().Contains("TELEGRAM"))
{
if (body.Contains("Telegram code"))
{
codigo = body.Split(' ')[2];
receiveSms = true;
code.Text = codigo;
}
}
}
}
}
return(codigo);
}
/*
This is ported from FetchWeatherTask --- but now we go straight from the cursor to the
string.
*/
private String convertCursorRowToUXFormat(ICursor cursor)
{
// get row indices for our cursor
String highAndLow = formatHighLows (
cursor.GetDouble (COL_WEATHER_MAX_TEMP),
cursor.GetDouble (COL_WEATHER_MIN_TEMP));
return Utility.formatDate (cursor.GetLong (COL_WEATHER_DATE)) +
" - " + cursor.GetString (COL_WEATHER_DESC) +
" - " + highAndLow;
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.AutoUpdateLayout);
progressBar = FindViewById <ProgressBar>(Resource.Id.progressBar1);
textView1 = FindViewById <TextView>(Resource.Id.textView1);
progressBar.Max = 100;
textView1.Text = "0 %";
FileDelete();
var manager = DownloadManager.FromContext(this);
//var manager = (DownloadManager)GetSystemService(Context.DownloadService);
var url = new System.Uri(string.Format(@"{0}{1}", GlobalSetting.Instance.MOBILEEndpoint.ToString(), string.Format("{0}{1}{2}", "/", Application.Context.PackageName, ".apk")));
var request = new DownloadManager.Request(Android.Net.Uri.Parse(url.ToString()));
request.SetMimeType("application/vnd.android.package-archive");
request.SetTitle("App Download");
request.SetDescription("File Downloading...");
request.SetAllowedNetworkTypes(DownloadNetwork.Wifi | DownloadNetwork.Mobile);
request.SetNotificationVisibility(DownloadVisibility.Visible);
request.SetAllowedOverMetered(true); //모바일 네트쿼크
request.SetAllowedOverRoaming(true); //로밍
Java.IO.File path = this.GetExternalFilesDir(Android.OS.Environment.DirectoryDownloads);
request.SetDestinationUri(Android.Net.Uri.FromFile(new Java.IO.File(path, string.Format("{0}{1}", Application.Context.PackageName, ".apk"))));
downloadId = manager.Enqueue(request);
Task.Run(() =>
{
for (; ;)
{
var query = new DownloadManager.Query();
query.SetFilterById(downloadId);
ICursor cursor = manager.InvokeQuery(query);
if (cursor.MoveToFirst())
{
var soFar = cursor.GetDouble(cursor.GetColumnIndex(DownloadManager.ColumnBytesDownloadedSoFar));
var total = cursor.GetDouble(cursor.GetColumnIndex(DownloadManager.ColumnTotalSizeBytes));
RunOnUiThread(() =>
{
progressBar.SetProgress(System.Convert.ToInt32(soFar / total * 100), true);
textView1.Text = string.Format("{0} %", Convert.ToInt32(soFar / total * 100));
});
System.Console.WriteLine(soFar.ToString());
if (soFar.Equals(total))
{
break;
}
}
Thread.Sleep(500);
}
});
}
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)
{
View myView = inflater.Inflate(Resource.Layout.storeMenu, container, false);
listView = myView.FindViewById <ListView>(Resource.Id.myListBooks);
mySearch = myView.FindViewById <SearchView>(Resource.Id.searchID);
myDB = new DBHelperClass(myContext);
ICursor myresult = myDB.getAllBooks();
while (myresult.MoveToNext())
{
myBooksList.Add(new BookObject(myresult.GetInt(myresult.GetColumnIndexOrThrow("book_id")), myresult.GetString(myresult.GetColumnIndexOrThrow("book_name")), myresult.GetString(myresult.GetColumnIndexOrThrow("book_author")), myresult.GetInt(myresult.GetColumnIndexOrThrow("book_image")), myresult.GetDouble(myresult.GetColumnIndexOrThrow("book_rate"))));
}
/* myBooksList.Add(new BookObject(101,"Book 1", "Amith", Resource.Drawable.RomeoandJuliet, 3.5));
* myBooksList.Add(new BookObject(102, "Book 2", "Prasanna", Resource.Drawable.RomeoandJuliet, 4.5));
* myBooksList.Add(new BookObject(103, "Book 3", "Shriya", Resource.Drawable.RomeoandJuliet, 2));
* myBooksList.Add(new BookObject(104, "Book 4", "Raul", Resource.Drawable.RomeoandJuliet, 2.5));
* myBooksList.Add(new BookObject(105, "Book 5", "girish", Resource.Drawable.RomeoandJuliet, 3));*/
MyCustomAdapter myAdapter = new MyCustomAdapter(myContext, myBooksList);
listView.Adapter = myAdapter;
listView.ItemClick += List1_ItemClick;
mySearch.QueryTextChange += searchUsers;
return(myView);
}
/*
This is where we fill-in the views with the contents of the cursor.
*/
public override void BindView(View view, Context context, ICursor cursor)
{
// Read weather icon ID from cursor
int weatherId = cursor.GetInt (ForecastFragment.COL_WEATHER_CONDITION_ID);
// Use placeholder image for now
if (GetItemViewType (cursor.Position) == 0) {
MainViewHolder.iconView.SetImageResource (getArtResourceForWeatherCondition (weatherId));
} else {
MainViewHolder.iconView.SetImageResource (getIconResourceForWeatherCondition (weatherId));
}
// TODO Read date from cursor
long date = cursor.GetLong (ForecastFragment.COL_WEATHER_DATE);
MainViewHolder.dateView.Text = Utility.getFriendlyDayString (context, date);
// TODO Read weather forecast from cursor
string forecast = cursor.GetString (ForecastFragment.COL_WEATHER_DESC);
MainViewHolder.descriptionView.Text = forecast;
// Read user preference for metric or imperial temperature units
bool isMetric = Utility.isMetric (context);
// Read high temperature from cursor
double high = cursor.GetDouble (ForecastFragment.COL_WEATHER_MAX_TEMP);
MainViewHolder.highTempView.Text = Utility.formatTemperature (context, high, isMetric);
// TODO Read low temperature from cursor
double low = cursor.GetDouble (ForecastFragment.COL_WEATHER_MIN_TEMP);
MainViewHolder.lowTempView.Text = Utility.formatTemperature (context, low, isMetric);
}
protected override List <CalendarDatum> GetCalendarEventsAsync()
{
List <CalendarDatum> calendarDatums = new List <CalendarDatum>();
string[] eventProperties =
{
CalendarContract.Events.InterfaceConsts.Id,
CalendarContract.Events.InterfaceConsts.Title,
CalendarContract.Events.InterfaceConsts.Dtstart,
CalendarContract.Events.InterfaceConsts.Dtend,
CalendarContract.Events.InterfaceConsts.Duration,
CalendarContract.Events.InterfaceConsts.Description,
CalendarContract.Events.InterfaceConsts.EventLocation,
CalendarContract.Events.InterfaceConsts.Organizer,
CalendarContract.Events.InterfaceConsts.IsOrganizer,
};
DateTimeOffset epoch = DateTimeOffset.FromUnixTimeMilliseconds(0);
long last = ((DateTimeOffset)LastPollTime).ToUnixTimeMilliseconds();
long now = Java.Lang.JavaSystem.CurrentTimeMillis();
ICursor cursor = Application.Context.ContentResolver.Query(CalendarContract.Events.ContentUri, eventProperties, $"{CalendarContract.Events.InterfaceConsts.Dtstart} > ? AND {CalendarContract.Events.InterfaceConsts.Dtstart} <= ?", new string[] { last.ToString(), now.ToString() }, CalendarContract.Events.InterfaceConsts.Dtstart + " DESC");
Dictionary <string, int> columns = eventProperties.ToDictionary(x => x, x => cursor.GetColumnIndex(x));
while (cursor.MoveToNext())
{
CalendarDatum calendarDatum = new CalendarDatum(cursor.GetString(columns[CalendarContract.Events.InterfaceConsts.Id]), cursor.GetString(columns[CalendarContract.Events.InterfaceConsts.Title]), epoch.AddMilliseconds(cursor.GetLong(columns[CalendarContract.Events.InterfaceConsts.Dtstart])), epoch.AddMilliseconds(cursor.GetLong(columns[CalendarContract.Events.InterfaceConsts.Dtend])), cursor.GetDouble(columns[CalendarContract.Events.InterfaceConsts.Duration]), cursor.GetString(columns[CalendarContract.Events.InterfaceConsts.Description]), cursor.GetString(columns[CalendarContract.Events.InterfaceConsts.EventLocation]), cursor.GetString(columns[CalendarContract.Events.InterfaceConsts.Organizer]), cursor.GetInt(columns[CalendarContract.Events.InterfaceConsts.IsOrganizer]) == 1, DateTimeOffset.UtcNow);
calendarDatums.Add(calendarDatum);
}
return(calendarDatums);
}
public Dictionary <string, MapDownloadResource> getAvailableMapsForACertainType(params string[] mapType)
{
StringBuilder query =
new StringBuilder("SELECT ").Append(CODE).Append(", ").Append(PARENT_CODE).Append(", ").Append(REGION).Append(", ")
.Append(NAMES).Append(", ").Append(SKM_FILE_PATH).Append(", " +
"").Append(ZIP_FILE_PATH).Append(", ")
.Append(TXG_FILE_PATH).Append(", ").Append(TXG_FILE_SIZE).Append(", ")
.Append(SKM_AND_ZIP_FILES_SIZE).Append(", ").Append(SKM_FILE_SIZE).Append(", " +
"").Append(UNZIPPED_FILE_SIZE)
.Append(", ").Append(BOUNDING_BOX_LATITUDE_MAX).Append(", ").Append(BOUNDING_BOX_LATITUDE_MIN)
.Append(", ").Append(BOUNDING_BOX_LONGITUDE_MAX).Append(", ").Append(BOUNDING_BOX_LONGITUDE_MIN)
.Append(", ").Append(SUBTYPE).Append(", ").Append(STATE).Append(", " +
"").Append(NO_DOWNLOADED_BYTES)
.Append(", ").Append(FLAG_ID).Append(", ").Append(DOWNLOAD_PATH).Append(" FROM ").Append
(MAPS_TABLE);
if (mapType != null && mapType.Length > 0)
{
query.Append(" WHERE ").Append(SUBTYPE).Append("=?");
for (int i = 1; i < mapType.Length; i++)
{
query.Append(" or ").Append(SUBTYPE).Append("=?");
}
}
ICursor resultCursor = resourcesDAO.getDatabase().RawQuery(query.ToString(), mapType);
if ((resultCursor != null) && (resultCursor.Count > 0))
{
Dictionary <String, MapDownloadResource> maps = new Dictionary <String, MapDownloadResource>();
MapDownloadResource currentMap;
try
{
resultCursor.MoveToFirst();
while (!resultCursor.IsAfterLast)
{
currentMap = new MapDownloadResource();
currentMap.Code = (resultCursor.GetString(0));
currentMap.ParentCode = (resultCursor.GetString(1));
currentMap.setNames(resultCursor.GetString(3));
currentMap.setSkmFilePath(resultCursor.GetString(4));
currentMap.setZipFilePath(resultCursor.GetString(5));
currentMap.setTXGFilePath(resultCursor.GetString(6));
currentMap.setTXGFileSize(resultCursor.GetInt(7));
currentMap.setSkmAndZipFilesSize(resultCursor.GetInt(8));
currentMap.setSkmFileSize(resultCursor.GetInt(9));
currentMap.setUnzippedFileSize(resultCursor.GetInt(10));
currentMap.setBbLatMax(resultCursor.GetDouble(11));
currentMap.setBbLatMin(resultCursor.GetDouble(12));
currentMap.setBbLongMax(resultCursor.GetDouble(13));
currentMap.setBbLongMin(resultCursor.GetDouble(14));
currentMap.setSubType(resultCursor.GetString(15));
currentMap.DownloadState = (sbyte)resultCursor.GetInt(16);
currentMap.NoDownloadedBytes = (resultCursor.GetInt(17));
currentMap.FlagId = (resultCursor.GetInt(18));
currentMap.DownloadPath = (resultCursor.GetString(19));
maps.Add(currentMap.Code, currentMap);
resultCursor.MoveToNext();
}
}
finally
{
resultCursor.Close();
}
return(maps);
}
else
{
if (resultCursor != null)
{
resultCursor.Close();
}
return(null);
}
}
public override double GetDouble(int column)
{
return(_queueCursor.GetDouble(column));
}