private void SetViewDelegate(View view, object clsobj)
{
ItemPrices item = (ItemPrices)clsobj;
view.FindViewById <TextView> (Resource.Id.icode).Text = item.ICode;
view.FindViewById <TextView> (Resource.Id.itemdesc).Text = item.IDesc;
view.FindViewById <TextView> (Resource.Id.custcode).Text = item.CustCode;
view.FindViewById <TextView> (Resource.Id.custname).Text = item.CustName;
view.FindViewById <TextView> (Resource.Id.invdate).Text = item.InvDate.ToString("dd-MM-yyyy");
view.FindViewById <TextView> (Resource.Id.price).Text = item.Price.ToString("n3");
}
private void InsertItemPriceIntoDb(List <ItemLastPrice> list)
{
string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH;
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
//var list2 = db.Table<Item>().ToList<Item>();
db.DeleteAll <ItemPrices> ();
int id = 1;
foreach (ItemLastPrice item in list)
{
ItemPrices itm = new ItemPrices();
itm.ID = id;
itm.ICode = item.ICode;
itm.IDesc = item.IDesc;
itm.Price = item.Price;
itm.CustCode = item.CustCode;
itm.CustName = item.CustName;
itm.InvDate = item.InvDate;
if (string.IsNullOrEmpty(item.IClass))
{
itm.IClass = "";
}
else
{
itm.IClass = item.IClass;
}
db.Insert(itm);
id = id + 1;
}
}
string dmsg = CallingActivity.Resources.GetString(Resource.String.msg_successdownitems);
dmsg = dmsg.Replace("nn", list.Count.ToString());
Downloadhandle.Invoke(CallingActivity, list.Count, dmsg);
}
private void InsertItemPriceIntoDb(List<ItemLastPrice> list)
{
string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH;
using (var db = new SQLite.SQLiteConnection (pathToDatabase)) {
//var list2 = db.Table<Item>().ToList<Item>();
db.DeleteAll<ItemPrices> ();
int id = 1;
foreach (ItemLastPrice item in list) {
ItemPrices itm = new ItemPrices ();
itm.ID = id;
itm.ICode = item.ICode;
itm.IDesc = item.IDesc;
itm.Price = item.Price;
itm.CustCode = item.CustCode;
itm.CustName = item.CustName;
itm.InvDate = item.InvDate;
if (string.IsNullOrEmpty (item.IClass))
itm.IClass = "";
else
itm.IClass = item.IClass;
db.Insert (itm);
id = id + 1;
}
}
string dmsg = CallingActivity.Resources.GetString (Resource.String.msg_successdownitems);
dmsg = dmsg.Replace ("nn", list.Count.ToString ());
Downloadhandle.Invoke(CallingActivity,list.Count,dmsg);
}