private void ScanUPC()
{
tblBoxDetail boxdetails = new tblBoxDetail();
string oqty, rqty;
if (Convert.ToInt32(txtScanUPC.Text.Length) > 1)
{
if (txtScanUPC.Text.Substring(Convert.ToInt32(txtScanUPC.Text.Length) - 1, 1) == "\n")
{
var scanItem = ItemRepository.GetPTLUPC(Intent.GetStringExtra("move_doc"), txtScanUPC.Text);
if (scanItem != null)
{
oqty = scanItem.oqty;
rqty = scanItem.rqty;
string stat = "0";
if (Convert.ToInt32(rqty) + 1 == Convert.ToInt32(oqty))
{
stat = "1";
}
PTLDetails.id = scanItem.id;
PTLDetails.move_doc = scanItem.move_doc;
PTLDetails.upc = scanItem.upc;
PTLDetails.sku = scanItem.sku;
PTLDetails.dept = scanItem.dept;
PTLDetails.style = scanItem.style;
PTLDetails.descr = scanItem.descr;
PTLDetails.oqty = oqty;
PTLDetails.rqty = Convert.ToString(Convert.ToInt32(rqty) + 1);
PTLDetails.status = stat;
ItemRepository.UpdatePTLListDetail(PTLDetails);
var boxdetail = ItemRepository.ChkBoxDetailUPC(txtBoxCode.Text, txtTlno.Text, scanItem.upc);
if (boxdetail != null)
{
boxdetails.id = boxdetail.id;
boxdetails.box_code = txtBoxCode.Text;
boxdetails.move_doc = txtTlno.Text;
boxdetails.upc = scanItem.upc;
boxdetails.rqty = Convert.ToString(Convert.ToInt32(boxdetail.rqty) + 1);
ItemRepository.UpdateBoxDetail(boxdetails);
}
else
{
ItemRepository.AddBoxDetail(txtBoxCode.Text, txtTlno.Text, scanItem.upc, "1");
}
refreshItems();
}
else
{
var builder = new AlertDialog.Builder(this);
builder.SetTitle("Debenhams");
builder.SetMessage("You've scan UPC not in Picking List.");
builder.SetPositiveButton("OK", delegate { builder.Dispose(); });
builder.Show();
}
}
}
}
public static long UpdateBoxDetail(tblBoxDetail item)
{
using (var database = WMSDatabase.NewConnection())
{
database.Update(item);
return(item.id);
}
}
private void btnqty_Clicked(object sender, EventArgs e)
{
tblBoxDetail boxdetails = new tblBoxDetail();
if (Convert.ToInt32(txtRqty.Text) >= 1)
{
var boxdetail = ItemRepository.ChkBoxDetailUPC(txtBoxNo.Text, Intent.GetStringExtra("move_doc"), txtUPC.Text);
int upccount = 0;
if (boxdetail != null)
{
upccount = Convert.ToInt32(boxdetail.rqty);
}
if (upccount > 0)
{
txtRqty.Text = Convert.ToString(Convert.ToInt32(txtRqty.Text) - 1);
string stat = "0";
if (Convert.ToInt32(txtRqty.Text) == Convert.ToInt32(Intent.GetStringExtra("oqty")))
{
stat = "1";
}
PTLDetails.id = Convert.ToInt32(Intent.GetStringExtra("id"));
PTLDetails.move_doc = Intent.GetStringExtra("move_doc").ToString();
PTLDetails.upc = Intent.GetStringExtra("upc").ToString();
PTLDetails.sku = Intent.GetStringExtra("sku").ToString();
PTLDetails.dept = Intent.GetStringExtra("dept").ToString();
PTLDetails.style = Intent.GetStringExtra("style").ToString();
PTLDetails.descr = Intent.GetStringExtra("descr").ToString();
PTLDetails.oqty = Intent.GetStringExtra("oqty").ToString();
PTLDetails.rqty = txtRqty.Text;
PTLDetails.status = stat;
ItemRepository.UpdatePTLListDetail(PTLDetails);
boxdetails.id = boxdetail.id;
boxdetails.box_code = boxdetail.box_code;
boxdetails.move_doc = boxdetail.move_doc;
boxdetails.upc = boxdetail.upc;
boxdetails.rqty = Convert.ToString(Convert.ToInt32(boxdetail.rqty) - 1);
ItemRepository.UpdateBoxDetail(boxdetails);
}
else
{
var builder = new AlertDialog.Builder(this);
builder.SetTitle("Debenhams");
builder.SetMessage("Unable to continue..\nThere are no UPC (" + txtUPC.Text + ")\nIn the selected Box (" + txtBoxNo.Text + ")..");
builder.SetPositiveButton("OK", delegate { builder.Dispose(); });
builder.Show();
}
}
}