internal Trader GetCustomer(string custcode,MyModel model,string pathToDatabase)
{
Trader cust = new Trader ();
Trader comp = DataHelper.GetTrader (pathToDatabase, custcode);
string tel = string.IsNullOrEmpty (comp.Tel) ? " " : comp.Tel.Trim ();
string fax = string.IsNullOrEmpty (comp.Fax) ? " " : comp.Fax.Trim ();
string addr1 =string.IsNullOrEmpty (comp.Addr1) ? "" : comp.Addr1.Trim ();
string addr2 =string.IsNullOrEmpty (comp.Addr2) ? "" : comp.Addr2.Trim ();
string addr3 =string.IsNullOrEmpty (comp.Addr3) ? "" : comp.Addr3.Trim ();
string addr4 =string.IsNullOrEmpty (comp.Addr4) ? "" : comp.Addr4.Trim ();
string gst =string.IsNullOrEmpty (comp.gst) ? "" : comp.gst.Trim ();
cust = comp;
string test = "";
if (addr1!="")
test += comp.Addr1.Trim () + "\n";
if (addr2!="")
test += comp.Addr2.Trim () + "\n";
if (addr3!="")
test += comp.Addr3.Trim () + "\n";
if (addr4!="")
test += comp.Addr4.Trim () + "\n";
model.CustomerAddress = test;
return cust;
}
private void LoadData()
{
Trader trd = new Trader ();
using (var db = new SQLite.SQLiteConnection(pathToDatabase))
{
var list = db.Table<Trader>().Where(x=>x.CustCode==CUSTCODE).ToList<Trader>();
if (list.Count > 0) {
trd = list [0];
}
}
DisplayData (trd);
}
void DeleteCust(Trader item)
{
bool isDeleted = false;
using (var db = new SQLite.SQLiteConnection (pathToDatabase)) {
var list = db.Table<Trader> ().Where (x => x.CustCode == item.CustCode && x.CompCode == item.CompCode && x.BranchCode == item.BranchCode).ToList ();
if (list.Count > 0) {
if (list [0].IsLocal) {
db.Delete (list [0]);
isDeleted = true;
}
}
}
if (isDeleted) {
listData.Clear ();
populate (listData);
SetViewDlg viewdlg = SetViewDelegate;
listView.Adapter = new GenericListAdapter<Trader> (this, listData, Resource.Layout.ListCustDtlView, viewdlg);
}
}
private void spinnerCust_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spinner = (Spinner)sender;
string txt = spinner.GetItemAtPosition(e.Position).ToString();
string[] codes = txt.Split(new char[] { '|' });
if (codes.Length < 2)
{
return;
}
trd = trds.Where(x => x.CustCode == codes[0].Trim()).FirstOrDefault();
if (trd == null)
{
trd = new Trader();
}
txtcustname = trd.CustName.Trim();
}
private void DisplayData(Trader trd)
{
TextView code = FindViewById<TextView> (Resource.Id.txtcust_code);
TextView name = FindViewById<TextView> (Resource.Id.txtcust_name);
TextView addr1 = FindViewById<TextView> (Resource.Id.txtcust_addr1);
TextView addr2 = FindViewById<TextView> (Resource.Id.txtcust_addr2);
TextView addr3 = FindViewById<TextView> (Resource.Id.txtcust_addr3);
TextView addr4 = FindViewById<TextView> (Resource.Id.txtcust_addr4);
TextView tel = FindViewById<TextView> (Resource.Id.txtcust_tel);
TextView fax = FindViewById<TextView> (Resource.Id.txtcust_fax);
TextView gst= FindViewById<TextView> (Resource.Id.txtcust_gst);
code.Text = trd.CustCode;
name.Text = trd.CustName;
addr1.Text = trd.Addr1;
addr2.Text = trd.Addr2;
addr3.Text = trd.Addr3;
addr4.Text = trd.Addr4;
tel.Text = "TEL: "+trd.Tel;
fax.Text ="FAX: "+ trd.Fax;
gst.Text ="GST: "+ trd.gst;
}
public static double GetUnitPrice(Trader trd, Item prd)
{
double unitprice = 0;
if (trd == null)
{
unitprice = prd.Price;
return(unitprice);
}
if (trd.CustType.ToUpper() == "OTHER")
{
unitprice = prd.Price;
}
else if (trd.CustType.ToUpper() == "RETAIL")
{
unitprice = prd.RetailPrice;
}
else if (trd.CustType.ToUpper() == "VIP")
{
unitprice = prd.VIPPrice;
}
else if (trd.CustType.ToUpper() == "WHOLESALE")
{
unitprice = prd.WholeSalePrice;
}
else
{
unitprice = prd.Price;
}
//if only SellingPirce is set, take selling price.
if (unitprice == 0)
{
unitprice = prd.Price;
}
return(unitprice);
}
private void DisplayData(Trader trd)
{
TextView code = FindViewById <TextView> (Resource.Id.txtcust_code);
TextView name = FindViewById <TextView> (Resource.Id.txtcust_name);
TextView addr1 = FindViewById <TextView> (Resource.Id.txtcust_addr1);
TextView addr2 = FindViewById <TextView> (Resource.Id.txtcust_addr2);
TextView addr3 = FindViewById <TextView> (Resource.Id.txtcust_addr3);
TextView addr4 = FindViewById <TextView> (Resource.Id.txtcust_addr4);
TextView tel = FindViewById <TextView> (Resource.Id.txtcust_tel);
TextView fax = FindViewById <TextView> (Resource.Id.txtcust_fax);
TextView gst = FindViewById <TextView> (Resource.Id.txtcust_gst);
code.Text = trd.CustCode;
name.Text = trd.CustName;
addr1.Text = trd.Addr1;
addr2.Text = trd.Addr2;
addr3.Text = trd.Addr3;
addr4.Text = trd.Addr4;
tel.Text = "TEL: " + trd.Tel;
fax.Text = "FAX: " + trd.Fax;
gst.Text = "GST: " + trd.gst;
}
internal Trader GetCustomer(string custcode, MyModel model, string pathToDatabase)
{
Trader cust = new Trader();
Trader comp = DataHelper.GetTrader(pathToDatabase, custcode);
string tel = string.IsNullOrEmpty(comp.Tel) ? " " : comp.Tel.Trim();
string fax = string.IsNullOrEmpty(comp.Fax) ? " " : comp.Fax.Trim();
string addr1 = string.IsNullOrEmpty(comp.Addr1) ? "" : comp.Addr1.Trim();
string addr2 = string.IsNullOrEmpty(comp.Addr2) ? "" : comp.Addr2.Trim();
string addr3 = string.IsNullOrEmpty(comp.Addr3) ? "" : comp.Addr3.Trim();
string addr4 = string.IsNullOrEmpty(comp.Addr4) ? "" : comp.Addr4.Trim();
string gst = string.IsNullOrEmpty(comp.gst) ? "" : comp.gst.Trim();
cust = comp;
string test = "";
if (addr1 != "")
{
test += comp.Addr1.Trim() + "\n";
}
if (addr2 != "")
{
test += comp.Addr2.Trim() + "\n";
}
if (addr3 != "")
{
test += comp.Addr3.Trim() + "\n";
}
if (addr4 != "")
{
test += comp.Addr4.Trim() + "\n";
}
model.CustomerAddress = test;
return(cust);
}
public void PrintCustomerInv(ref string test, Invoice inv, string title = "CUSTOMER")
{
Trader comp = DataHelper.GetTrader(pathToDatabase, inv.custcode);
test += "------------------------------------------\n";
test += title + "\n";
string tel = string.IsNullOrEmpty(comp.Tel) ? " " : comp.Tel.Trim();
string fax = string.IsNullOrEmpty(comp.Fax) ? " " : comp.Fax.Trim();
string addr1 = string.IsNullOrEmpty(comp.Addr1) ? "" : comp.Addr1.Trim();
string addr2 = string.IsNullOrEmpty(comp.Addr2) ? "" : comp.Addr2.Trim();
string addr3 = string.IsNullOrEmpty(comp.Addr3) ? "" : comp.Addr3.Trim();
string addr4 = string.IsNullOrEmpty(comp.Addr4) ? "" : comp.Addr4.Trim();
string gst = string.IsNullOrEmpty(comp.gst) ? "" : comp.gst.Trim();
//PrintLongText (ref test, comp.CustName.Trim ());
PrintLongText(ref test, inv.description.ToUpper().Trim());
if (addr1 != "")
{
test += comp.Addr1.Trim() + "\n";
}
if (addr2 != "")
{
test += comp.Addr2.Trim() + "\n";
}
if (addr3 != "")
{
test += comp.Addr3.Trim() + "\n";
}
if (addr4 != "")
{
test += comp.Addr4.Trim() + "\n";
}
test += "TEL:" + tel + " FAX:" + fax + "\n";
test += "GST NO:" + gst + "\n";
test += "------------------------------------------\n";
}
private void DisplayData(Trader trd)
{
EditText code = FindViewById<EditText> (Resource.Id.txtcust_code);
EditText name = FindViewById<EditText> (Resource.Id.txtcust_name);
EditText addr1 = FindViewById<EditText> (Resource.Id.txtcust_addr1);
EditText addr2 = FindViewById<EditText> (Resource.Id.txtcust_addr2);
EditText addr3 = FindViewById<EditText> (Resource.Id.txtcust_addr3);
EditText addr4 = FindViewById<EditText> (Resource.Id.txtcust_addr4);
EditText tel = FindViewById<EditText> (Resource.Id.txtcust_tel);
EditText fax = FindViewById<EditText> (Resource.Id.txtcust_fax);
EditText gst= FindViewById<EditText> (Resource.Id.txtcust_gst);
EditText nric = FindViewById<EditText> (Resource.Id.txtcust_nric);
code.Text = trd.CustCode;
code.Enabled = false;
name.Text = trd.CustName;
addr1.Text = trd.Addr1;
addr2.Text = trd.Addr2;
addr3.Text = trd.Addr3;
addr4.Text = trd.Addr4;
tel.Text = trd.Tel;
fax.Text =trd.Fax;
gst.Text =trd.gst;
nric.Text = trd.NRIC;
}
public static double GetUnitPrice(Trader trd,Item prd)
{
double unitprice = 0;
if (trd == null) {
unitprice = prd.Price;
return unitprice;
}
if (trd.CustType.ToUpper () == "OTHER") {
unitprice = prd.Price;
} else if (trd.CustType.ToUpper () == "RETAIL") {
unitprice = prd.RetailPrice;
} else if (trd.CustType.ToUpper () == "VIP") {
unitprice = prd.VIPPrice;
} else if (trd.CustType.ToUpper () == "WHOLESALE") {
unitprice = prd.WholeSalePrice;
} else {
unitprice = prd.Price;
}
//if only SellingPirce is set, take selling price.
if (unitprice==0)
unitprice = prd.Price;
return unitprice;
}
void EditCust(Trader item)
{
var intent = new Intent (this, typeof(TraderActivity));
intent.PutExtra ("custcode", item.CustCode);
intent.PutExtra ("editmode", "edit");
StartActivity (intent);
}
private bool SaveTrader()
{
bool isSave = false;
try {
string comp = ((GlobalvarsApp)Application).COMPANY_CODE;
string brn = ((GlobalvarsApp)Application).BRANCH_CODE;
EditText code = FindViewById<EditText> (Resource.Id.txtcust_code);
EditText name = FindViewById<EditText> (Resource.Id.txtcust_name);
EditText addr1 = FindViewById<EditText> (Resource.Id.txtcust_addr1);
EditText addr2 = FindViewById<EditText> (Resource.Id.txtcust_addr2);
EditText addr3 = FindViewById<EditText> (Resource.Id.txtcust_addr3);
EditText addr4 = FindViewById<EditText> (Resource.Id.txtcust_addr4);
EditText tel = FindViewById<EditText> (Resource.Id.txtcust_tel);
EditText fax = FindViewById<EditText> (Resource.Id.txtcust_fax);
EditText gst = FindViewById<EditText> (Resource.Id.txtcust_gst);
EditText nric = FindViewById<EditText> (Resource.Id.txtcust_nric);
if (string.IsNullOrEmpty(code.Text))
{
Toast.MakeText (this,"Customer Code is blank...", ToastLength.Long).Show ();
return isSave;
}
if (string.IsNullOrEmpty(name.Text))
{
Toast.MakeText (this,"Customer Name is blank...", ToastLength.Long).Show ();
return isSave;
}
Trader trd = new Trader ();
trd.CustCode = code.Text.ToUpper ();
trd.Addr1 = addr1.Text.ToUpper ();
trd.Addr2 = addr2.Text.ToUpper ();
trd.Addr3 = addr3.Text.ToUpper ();
trd.Addr4 = addr4.Text.ToUpper ();
trd.CustName = name.Text.ToUpper ();
trd.Fax = fax.Text.ToUpper ();
trd.Tel = tel.Text.ToUpper ();
trd.gst = gst.Text.ToUpper ();
trd.CompCode= comp;
trd.BranchCode= brn;
trd.NRIC= nric.Text.ToUpper();
using (var db = new SQLite.SQLiteConnection (pathToDatabase)) {
var list = db.Table<Trader> ().Where (x => x.CustCode == code.Text && x.CompCode == comp && x.BranchCode == brn).ToList ();
if (list.Count > 0) {
trd.PayCode = list [0].PayCode;
trd.IsLocal = list [0].IsLocal;
db.Update (trd);
} else {
trd.PayCode = "CASH";
trd.IsLocal = true;
db.Insert (trd);
}
isSave = true;
}
} catch (Exception ex) {
}
return isSave;
}
private bool IsValidCustTo(Trader trd)
{
return(trd.CustType.ToUpper() != "BILLTO");
}
private void InsertCustomerIntoDb(List<Customer> list)
{
string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH;
using (var db = new SQLite.SQLiteConnection(pathToDatabase))
{
//var list2 = db.Table<Trader>().ToList<Trader>();
db.DeleteAll<Trader> ();// (list2);
foreach (Customer item in list) {
Trader itm = new Trader ();
itm.CustCode = item.CustomerCode;
itm.CustName = item.CustomerName;
itm.Addr1 = item.Addr1;
itm.Addr2 = item.Addr2;
itm.Addr3 = item.Addr3;
itm.Addr4 = item.Addr4;
itm.Tel = item.Tel;
itm.Fax = item.Fax;
itm.gst = item.Gst;
itm.PayCode = item.PayCode;
db.Insert (itm);
// if (list2.Where (x => x.CustCode == itm.CustCode).ToList ().Count () == 0) {
// db.Insert (itm);
// } else {
// db.Update (itm);
// }
}
}
if (_downloadAll) {
FireEvent (EventID.LOGIN_DOWNCOMPLETE);
DownloadAllhandle.Invoke(CallingActivity,list.Count,"Successfully downloaded "+list.Count.ToString()+" customer(s).");
}else Downloadhandle.Invoke(CallingActivity,list.Count,"Successfully downloaded "+list.Count.ToString()+" customer(s).");
}
private void InsertCustomerIntoDb(List<Customer> list)
{
string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH;
using (var db = new SQLite.SQLiteConnection(pathToDatabase))
{
//var list2 = db.Table<Trader>().ToList<Trader>();
db.DeleteAll<Trader> ();// (list2);
foreach (Customer item in list) {
Trader itm = new Trader ();
itm.CustCode = item.CustomerCode;
itm.CustName = item.CustomerName;
itm.Addr1 = item.Addr1;
itm.Addr2 = item.Addr2;
itm.Addr3 = item.Addr3;
itm.Addr4 = item.Addr4;
itm.Tel = item.Tel;
itm.Fax = item.Fax;
itm.gst = item.Gst;
itm.PayCode = item.PayCode;
itm.CustType = item.CustType;
itm.AgentCode = item.ExtraInfo;
db.Insert (itm);
// if (list2.Where (x => x.CustCode == itm.CustCode).ToList ().Count () == 0) {
// db.Insert (itm);
// } else {
// db.Update (itm);
// }
}
}
string dmsg = CallingActivity.Resources.GetString (Resource.String.msg_successdowncusts);
dmsg = dmsg.Replace ("nn", list.Count.ToString ());
if (_downloadAll) {
FireEvent (EventID.LOGIN_DOWNCOMPLETE);
DownloadAllhandle.Invoke(CallingActivity,list.Count,dmsg);
}else Downloadhandle.Invoke(CallingActivity,list.Count,dmsg);
}
private void InsertCustomerIntoDb(List<Customer> list)
{
string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH;
string comp =((GlobalvarsApp)CallingActivity.Application).COMPANY_CODE;
string brn =((GlobalvarsApp)CallingActivity.Application).BRANCH_CODE;
using (var db = new SQLite.SQLiteConnection(pathToDatabase))
{
db.DeleteAll<Trader> ("Delete from Trader where IsLocal =0 and CompCode='"+comp+"' and BranchCode='"+brn+"'" );
foreach (Customer item in list) {
Trader itm = new Trader ();
itm.CustCode = item.CustomerCode;
itm.CustName = item.CustomerName;
itm.Addr1 = item.Addr1;
itm.Addr2 = item.Addr2;
itm.Addr3 = item.Addr3;
itm.Addr4 = item.Addr4;
itm.Tel = item.Tel;
itm.Fax = item.Fax;
itm.gst = item.Gst;
itm.PayCode = item.PayCode;
itm.BranchCode = brn;
itm.CompCode = comp;
itm.IsLocal = false;
db.Insert (itm);
}
}
if (_downloadAll) {
FireEvent (EventID.LOGIN_DOWNCOMPLETE);
DownloadAllhandle.Invoke(CallingActivity,list.Count,"Successfully downloaded "+list.Count.ToString()+" customer(s).");
}else Downloadhandle.Invoke(CallingActivity,list.Count,"Successfully downloaded "+list.Count.ToString()+" customer(s).");
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate (bundle);
if (!((GlobalvarsApp)this.Application).ISLOGON) {
Finish ();
}
SetTitle (Resource.String.title_soitementry);
EventManagerFacade.Instance.GetEventManager().AddListener(this);
pathToDatabase = ((GlobalvarsApp)this.Application).DATABASE_PATH;
rights = Utility.GetAccessRights (pathToDatabase);
SALEORDERNO = Intent.GetStringExtra ("invoiceno") ?? "AUTO";
ITEMUID = Intent.GetStringExtra ("itemuid") ?? "AUTO";
EDITMODE = Intent.GetStringExtra ("editmode") ?? "AUTO";
CUSTOMER= Intent.GetStringExtra ("customer") ?? "AUTO";
CUSTCODE= Intent.GetStringExtra ("custcode") ?? "AUTO";
trd = DataHelper.GetTrader (pathToDatabase, CUSTCODE);
// Create your application here
SetContentView (Resource.Layout.SOEntry);
spinner = FindViewById<Spinner> (Resource.Id.txtcode);
EditText qty = FindViewById<EditText> (Resource.Id.txtqty);
EditText price = FindViewById<EditText> (Resource.Id.txtprice);
TextView txtInvNo = FindViewById<TextView> (Resource.Id.txtInvnp);
TextView txtcust = FindViewById<TextView> (Resource.Id.txtInvcust);
Button butFind = FindViewById<Button> (Resource.Id.newinv_bfind);
txtInvNo.Text = SALEORDERNO;
txtcust.Text = CUSTOMER;
Button but = FindViewById<Button> (Resource.Id.Save);
Button but2 = FindViewById<Button> (Resource.Id.Cancel);
spinner.ItemSelected += new EventHandler<AdapterView.ItemSelectedEventArgs> (spinner_ItemSelected);
but.Click += butSaveClick;
but2.Click += butCancelClick;
butFind.Click+= (object sender, EventArgs e) => {
ShowItemLookUp();
};
qty.EditorAction += HandleEditorAction;
qty.AfterTextChanged+= Qty_AfterTextChanged;
price.Enabled = rights.SOEditUPrice;
//price.EditorAction += HandleEditorAction;
//SqliteConnection.CreateFile(pathToDatabase);
using (var db = new SQLite.SQLiteConnection(pathToDatabase))
{
items = db.Table<Item> ().ToList<Item> ();
}
List<string> icodes = new List<string> ();
// foreach (Item item in items) {
// icodes.Add (item.ICode+" | "+item.IDesc);
// }
foreach (Item item in items) {
//icodes.Add (item.ICode+" | "+item.IDesc);
if (item.IDesc.Length > 40) {
icodes.Add (item.ICode + " | " + item.IDesc.Substring(0,40)+"...");
}else icodes.Add (item.ICode + " | " + item.IDesc);
}
dataAdapter = new ArrayAdapter<String>(this,Resource.Layout.spinner_item, icodes);
// Drop down layout style - list view with radio button
dataAdapter.SetDropDownViewResource(Android.Resource.Layout.SimpleSpinnerDropDownItem);
// attaching data adapter to spinner
spinner.Adapter =dataAdapter;
if (EDITMODE == "EDIT") {
FIRSTLOAD="1";
LoadData (SALEORDERNO, ITEMUID);
}
}
private void spinnerCust_ItemSelected(object sender, AdapterView.ItemSelectedEventArgs e)
{
Spinner spinner = (Spinner)sender;
string txt = spinner.GetItemAtPosition (e.Position).ToString();
string[] codes = txt.Split (new char[]{ '|' });
if (codes.Length <2)
return;
trd =trds.Where (x => x.CustCode ==codes[0].Trim()).FirstOrDefault ();
if (trd == null) {
trd = new Trader ();
}
txtcustname = trd.CustName.Trim ();
}
private void CreateNewCN()
{
CNNote inv = new CNNote ();
EditText trxdate = FindViewById<EditText> (Resource.Id.newinv_date);
if (!Utility.IsValidDateString (trxdate.Text)) {
Toast.MakeText (this,Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show ();
return;
}
DateTime invdate = Utility.ConvertToDate (trxdate.Text);
DateTime tmr = invdate.AddDays (1);
AdNumDate adNum= DataHelper.GetNumDate (pathToDatabase, invdate,"CN");
Spinner spinner = FindViewById<Spinner> (Resource.Id.newinv_custcode);
TextView txtinvno =FindViewById<TextView> (Resource.Id.newinv_no);
EditText remark = FindViewById<EditText> (Resource.Id.newinv_custname);
TextView cninvno = FindViewById<TextView> (Resource.Id.newcninv_no);
string prefix = apara.CNPrefix.Trim ().ToUpper ();
if (spinner.SelectedItem == null) {
Toast.MakeText (this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show ();
spinner.RequestFocus ();
return;
}
string[] codes = spinner.SelectedItem.ToString().Split (new char[]{ '|' });
if (codes.Length == 0)
return;
Invoice invInfo = DataHelper.GetInvoice (pathToDatabase, cninvno.Text);
using (var db = new SQLite.SQLiteConnection (pathToDatabase)) {
string invno = "";
int runno = adNum.RunNo + 1;
int currentRunNo =DataHelper.GetLastCNRunNo (pathToDatabase, invdate);
if (currentRunNo >= runno)
runno = currentRunNo + 1;
if (invInfo != null) {
//string[] prefixs = apara.Prefix.Trim ().ToUpper ().Split(new char[]{'|'});
if (invInfo.trxtype == "CASH") {
invno =prefix+ invdate.ToString ("yyMM") + runno.ToString ().PadLeft (4, '0')+"(CS)";
}else invno =prefix+ invdate.ToString ("yyMM") + runno.ToString ().PadLeft (4, '0')+"(INV)";
}else invno =prefix + invdate.ToString("yyMM") + runno.ToString().PadLeft (4, '0')+"(INV)";;
txtinvno.Text= invno;
inv.invdate = invdate;
inv.trxtype = "";
inv.created = DateTime.Now;
inv.cnno = invno;
inv.description = codes [1].Trim ();
inv.amount = 0;
inv.custcode = codes [0].Trim ();
inv.isUploaded = false;
inv.remark = remark.Text.ToUpper();
inv.invno = cninvno.Text;
if (invInfo != null) {
inv.trxtype = invInfo.trxtype;
} else {
Trader trd= DataHelper.GetTrader (pathToDatabase, inv.custcode);
if (trd != null) {
string paycode =trd.PayCode.ToUpper ().Trim ();
inv.trxtype = paycode;
if (paycode.Contains ("CASH") || paycode.Contains ("COD")) {
inv.trxtype = "CASH";
}
}
}
db.Insert (inv);
adNum.RunNo = runno;
if (adNum.ID >= 0)
db.Update (adNum);
else
db.Insert (adNum);
}
ShowItemEntry (inv, codes);
}
void GetData()
{
trd = DataHelper.GetTrader (pathToDatabase, CUSTCODE);
invoice = DataHelper.GetInvoice(pathToDatabase, invno);
using (var db = new SQLite.SQLiteConnection (pathToDatabase)) {
items = db.Table<Item> ().ToList<Item> ();
}
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
if (!((GlobalvarsApp)this.Application).ISLOGON)
{
Finish();
}
TRXTYPE = Intent.GetStringExtra("trxtype") ?? "CASH";
INVOICENO = Intent.GetStringExtra("invoiceno") ?? "AUTO";
ITEMUID = Intent.GetStringExtra("itemuid") ?? "AUTO";
EDITMODE = Intent.GetStringExtra("editmode") ?? "AUTO";
CUSTOMER = Intent.GetStringExtra("customer") ?? "AUTO";
CUSTCODE = Intent.GetStringExtra("custcode") ?? "AUTO";
if (TRXTYPE == "CASH")
{
SetTitle(Resource.String.title_cashitementry);
}
else
{
SetTitle(Resource.String.title_invitementry);
}
EventManagerFacade.Instance.GetEventManager().AddListener(this);
pathToDatabase = ((GlobalvarsApp)this.Application).DATABASE_PATH;
rights = Utility.GetAccessRights(pathToDatabase);
trd = DataHelper.GetTrader(pathToDatabase, CUSTCODE);
// Create your application here
SetContentView(Resource.Layout.Entry);
spinner = FindViewById <Spinner> (Resource.Id.txtcode);
EditText qty = FindViewById <EditText> (Resource.Id.txtqty);
EditText price = FindViewById <EditText> (Resource.Id.txtprice);
TextView txtInvNo = FindViewById <TextView> (Resource.Id.txtInvnp);
TextView txtcust = FindViewById <TextView> (Resource.Id.txtInvcust);
Button butFind = FindViewById <Button> (Resource.Id.newinv_bfind);
EditText txtbarcode = FindViewById <EditText> (Resource.Id.txtbarcode);
txtInvNo.Text = INVOICENO;
txtcust.Text = CUSTOMER;
Button but = FindViewById <Button> (Resource.Id.Save);
Button but2 = FindViewById <Button> (Resource.Id.Cancel);
spinner.ItemSelected += new EventHandler <AdapterView.ItemSelectedEventArgs> (spinner_ItemSelected);
but.Click += butSaveClick;
but2.Click += butCancelClick;
butFind.Click += (object sender, EventArgs e) => {
ShowItemLookUp();
};
qty.EditorAction += HandleEditorAction;
qty.AfterTextChanged += Qty_AfterTextChanged;
price.Enabled = rights.InvEditUPrice;
txtbarcode.SetOnKeyListener(this);
//SqliteConnection.CreateFile(pathToDatabase);
using (var db = new SQLite.SQLiteConnection(pathToDatabase))
{
items = db.Table <Item> ().ToList <Item> ();
}
List <string> icodes = new List <string> ();
foreach (Item item in items)
{
//icodes.Add (item.ICode+" | "+item.IDesc);
if (item.IDesc.Length > 40)
{
icodes.Add(item.ICode + " | " + item.IDesc.Substring(0, 40) + "...");
}
else
{
icodes.Add(item.ICode + " | " + item.IDesc);
}
}
dataAdapter = new ArrayAdapter <String>(this, Resource.Layout.spinner_item, icodes);
// Drop down layout style - list view with radio button
//dataAdapter.SetDropDownViewResource(Android.Resource.Layout.SimpleSpinnerDropDownItem);
dataAdapter.SetDropDownViewResource(Resource.Layout.SimpleSpinnerDropDownItemEx);
// attaching data adapter to spinner
spinner.Adapter = dataAdapter;
if (EDITMODE == "EDIT")
{
FIRSTLOAD = "1";
LoadData(INVOICENO, ITEMUID);
}
}
private bool IsValidCustTo(Trader trd)
{
return trd.CustType.ToUpper () != "BILLTO";
}
