void ListView_Click(object sender, AdapterView.ItemClickEventArgs e)
{
ItemStock itm = adapter[e.Position]; // listData.ElementAt (e.Position);
var intent = new Intent(this, typeof(StockEntry));
intent.PutExtra("icode", itm.ICode);
intent.PutExtra("trxdate", itm.DateTrx.ToString("dd-MM-yyyy"));
StartActivity(intent);
}
private void SetViewDelegate(View view, object clsobj)
{
ItemStock item = (ItemStock)clsobj;
view.FindViewById <TextView> (Resource.Id.date).Text = item.DateTrx.ToString("dd-MM-yyyy");
view.FindViewById <TextView> (Resource.Id.icodedesc).Text = item.IDesc;
view.FindViewById <TextView> (Resource.Id.icode).Text = item.ICode;
view.FindViewById <TextView> (Resource.Id.qtyrec).Text = item.QtyGR.ToString();
view.FindViewById <TextView> (Resource.Id.qtyactual).Text = item.QtyAct.ToString();
view.FindViewById <TextView> (Resource.Id.qtysales).Text = item.QtySales.ToString();
view.FindViewById <TextView> (Resource.Id.qtybrf).Text = item.QtyBrf.ToString();
view.FindViewById <TextView> (Resource.Id.qtyrtn).Text = item.QtyRtr.ToString();
view.FindViewById <TextView> (Resource.Id.qtycrf).Text = item.QtyCrf.ToString();
}
private void InsertItemGRIntoDb(List<ItemGR> list)
{
string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH;
string userid = ((GlobalvarsApp)CallingActivity.Application).USERID_CODE;
DateTime today = new DateTime(DateTime.Today.Year,DateTime.Today.Month,DateTime.Today.Day,00,00,00);
DateTime tempdate = today.AddDays (-4);
using (var db = new SQLite.SQLiteConnection (pathToDatabase)) {
//var list2 = db.Table<Item>().ToList<Item>();
var itemcode= db.Table<Item>().ToList();
var stock= db.Table<ItemStock>().Where(x=>x.DateTrx>tempdate).OrderByDescending(x=>x.DateTrx).ToList();
string desc = "";
foreach (ItemGR item in list) {
desc = "";
var founditm = itemcode.Where (x => x.ICode == item.ICode).ToList ();
if (founditm.Count > 0)
desc = founditm [0].IDesc.Trim();
var found = stock.Where (x => x.ICode == item.ICode && x.DateTrx == item.TrxDate).ToList ();
if (found.Count > 0) {
found [0].QtyGR = item.Qty;
found [0].IDesc = desc;
db.Update (found[0]);
} else {
ItemStock itm = new ItemStock ();
itm.ICode = item.ICode;
itm.IDesc = desc;
itm.DateTrx = item.TrxDate;
itm.QtyGR = item.Qty;
itm.QtyAct = 0;
itm.QtyBrf = 0;
itm.QtyCrf = 0;
itm.QtyRtr = 0;
itm.QtySales = 0;
itm.StdUom = item.UOM;
itm.Wh = item.WH;
db.Insert (itm);
}
}
for ( int i=0;i<3;i++)
{
int nday = i * -1;
tempdate =today.AddDays (nday);
var stock2= db.Table<ItemStock>().Where(x=>x.DateTrx==tempdate).ToList();
foreach (var itmc in itemcode) {
var found =stock2.Where(x=>x.DateTrx==tempdate&&x.ICode==itmc.ICode).ToList();
if (found.Count == 0) {
ItemStock itm = new ItemStock ();
itm.ICode = itmc.ICode;
itm.IDesc = itmc.IDesc;
itm.DateTrx = tempdate;
itm.QtyGR = 0;
itm.QtyAct = 0;
itm.QtyBrf = 0;
itm.QtyCrf = 0;
itm.QtyRtr = 0;
itm.QtySales = 0;
itm.StdUom = itmc.StdUom;
itm.Wh = userid;
db.Insert (itm);
}
}
}
}
string dmsg = CallingActivity.Resources.GetString (Resource.String.msg_successdownitems);
dmsg = dmsg.Replace ("nn", list.Count.ToString ());
Downloadhandle.Invoke(CallingActivity,list.Count,dmsg);
}
private void InsertItemGRIntoDb(List <ItemGR> list)
{
string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH;
string userid = ((GlobalvarsApp)CallingActivity.Application).USERID_CODE;
DateTime today = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, 00, 00, 00);
DateTime tempdate = today.AddDays(-4);
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
//var list2 = db.Table<Item>().ToList<Item>();
var itemcode = db.Table <Item>().ToList();
var stock = db.Table <ItemStock>().Where(x => x.DateTrx > tempdate).OrderByDescending(x => x.DateTrx).ToList();
string desc = "";
foreach (ItemGR item in list)
{
desc = "";
var founditm = itemcode.Where(x => x.ICode == item.ICode).ToList();
if (founditm.Count > 0)
{
desc = founditm [0].IDesc.Trim();
}
var found = stock.Where(x => x.ICode == item.ICode && x.DateTrx == item.TrxDate).ToList();
if (found.Count > 0)
{
found [0].QtyGR = item.Qty;
found [0].IDesc = desc;
db.Update(found[0]);
}
else
{
ItemStock itm = new ItemStock();
itm.ICode = item.ICode;
itm.IDesc = desc;
itm.DateTrx = item.TrxDate;
itm.QtyGR = item.Qty;
itm.QtyAct = 0;
itm.QtyBrf = 0;
itm.QtyCrf = 0;
itm.QtyRtr = 0;
itm.QtySales = 0;
itm.StdUom = item.UOM;
itm.Wh = item.WH;
db.Insert(itm);
}
}
for (int i = 0; i < 3; i++)
{
int nday = i * -1;
tempdate = today.AddDays(nday);
var stock2 = db.Table <ItemStock>().Where(x => x.DateTrx == tempdate).ToList();
foreach (var itmc in itemcode)
{
var found = stock2.Where(x => x.DateTrx == tempdate && x.ICode == itmc.ICode).ToList();
if (found.Count == 0)
{
ItemStock itm = new ItemStock();
itm.ICode = itmc.ICode;
itm.IDesc = itmc.IDesc;
itm.DateTrx = tempdate;
itm.QtyGR = 0;
itm.QtyAct = 0;
itm.QtyBrf = 0;
itm.QtyCrf = 0;
itm.QtyRtr = 0;
itm.QtySales = 0;
itm.StdUom = itmc.StdUom;
itm.Wh = userid;
db.Insert(itm);
}
}
}
}
string dmsg = CallingActivity.Resources.GetString(Resource.String.msg_successdownitems);
dmsg = dmsg.Replace("nn", list.Count.ToString());
Downloadhandle.Invoke(CallingActivity, list.Count, dmsg);
}