private bool SaveSO() { bool lSave = false; 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(false); } DateTime sodate = Utility.ConvertToDate(trxdate.Text); Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode); TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no); TextView custname = FindViewById <TextView> (Resource.Id.newinv_custname); EditText custpo = FindViewById <EditText> (Resource.Id.newinv_po); EditText remark = FindViewById <EditText> (Resource.Id.newinv_remark); if (spinner.SelectedItem == null) { Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show(); spinner.RequestFocus(); return(lSave); } string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' }); if (codes.Length == 0) { return(lSave); } string[] codes2 = spinnerBill.SelectedItem.ToString().Split(new char[] { '|' }); string billTo = ""; if (codes.Length > 0) { billTo = codes2 [0].Trim(); } using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { soInfo.sodate = sodate; soInfo.trxtype = "SO"; soInfo.created = DateTime.Now; soInfo.billTo = billTo; soInfo.remark = remark.Text.ToUpper(); soInfo.custpono = custpo.Text.ToUpper(); soInfo.custcode = codes [0].Trim(); soInfo.description = codes [1].Trim(); soInfo.isUploaded = false; db.Update(soInfo); lSave = true; } return(lSave); }
void CreateCashBill() { if (!Utility.IsValidDateString(txtInvDate.Text)) { Toast.MakeText(this, Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show(); return; } DateTime invdate = Utility.ConvertToDate(txtInvDate.Text); ValidateInvDate(invdate); }
private bool SaveInvoice() { bool lSave = false; Invoice inv = new Invoice(); 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(lSave); } DateTime invdate = Utility.ConvertToDate(trxdate.Text); Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode); //Spinner spinner2 = FindViewById<Spinner> (Resource.Id.newinv_type); TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no); EditText txtcustname = FindViewById <EditText> (Resource.Id.newinv_custname); EditText remark = FindViewById <EditText> (Resource.Id.newinv_remark); if (spinner.SelectedItem == null) { Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show(); spinner.RequestFocus(); return(lSave); } string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' }); if (codes.Length == 0) { return(lSave); } using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { invInfo.invdate = invdate; invInfo.trxtype = TRXTYPE; //spinner2.SelectedItem.ToString (); invInfo.created = DateTime.Now; invInfo.description = codes [1].Trim(); invInfo.remark = remark.Text.ToUpper(); //inv.amount = 0; invInfo.custcode = codes [0].Trim(); invInfo.isUploaded = false; if (codes [0].Trim() == "COD" || codes [0].Trim() == "CASH") { inv.description = txtcustname.Text.ToUpper(); } db.Update(invInfo); lSave = true; } return(lSave); }
private bool SaveCN() { bool IsSave = false; 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(IsSave); } DateTime invdate = Utility.ConvertToDate(trxdate.Text); Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode); EditText remark = FindViewById <EditText> (Resource.Id.newinv_custname); TextView cninvno = FindViewById <TextView> (Resource.Id.newcninv_no); if (spinner.SelectedItem == null) { Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show(); spinner.RequestFocus(); return(IsSave); } string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' }); if (codes.Length == 0) { return(IsSave); } using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { cnInfo.invdate = invdate; cnInfo.created = DateTime.Now; cnInfo.description = codes [1].Trim(); cnInfo.custcode = codes [0].Trim(); cnInfo.invno = cninvno.Text; cnInfo.remark = remark.Text.ToUpper(); cnInfo.trxtype = ""; if (!string.IsNullOrEmpty(cnInfo.invno)) { Invoice invInfo = DataHelper.GetInvoice(pathToDatabase, cnInfo.invno); if (invInfo != null) { cnInfo.trxtype = invInfo.trxtype; } } db.Update(cnInfo); IsSave = true; } return(IsSave); }
private bool SaveDO() { bool lSave = false; DelOrder dorder = new DelOrder(); 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(lSave); } DateTime dodate = Utility.ConvertToDate(trxdate.Text); Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode); Spinner spinner2 = FindViewById <Spinner> (Resource.Id.newinv_type); TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no); EditText remark = FindViewById <EditText> (Resource.Id.newinv_custname); if (spinner.SelectedItem == null) { Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show(); spinner.RequestFocus(); return(lSave); } string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' }); if (codes.Length == 0) { return(lSave); } using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { doInfo.dodate = dodate; doInfo.description = codes [1].Trim(); doInfo.remark = remark.Text; doInfo.term = spinner2.SelectedItem.ToString(); doInfo.amount = 0; doInfo.custcode = codes [0].Trim(); db.Update(doInfo); lSave = true; } return(lSave); }
private void CreateNewDO() { DelOrder dorder = new DelOrder(); 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 dodate = Utility.ConvertToDate(trxdate.Text); DateTime tmr = dodate.AddDays(1); AdNumDate adNum = DataHelper.GetNumDate(pathToDatabase, dodate, "DO"); Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode); Spinner spinner2 = FindViewById <Spinner> (Resource.Id.newinv_type); TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no); EditText remark = FindViewById <EditText> (Resource.Id.newinv_custname); //EditText custpo = FindViewById<EditText> (Resource.Id.newinv_po); //EditText remark = FindViewById<EditText> (Resource.Id.newinv_remark); string prefix = apara.DOPrefix.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; } using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { string dono = ""; int runno = adNum.RunNo + 1; int currentRunNo = DataHelper.GetLastDORunNo(pathToDatabase, dodate); if (currentRunNo >= runno) { runno = currentRunNo + 1; } dono = prefix + dodate.ToString("yyMM") + runno.ToString().PadLeft(4, '0'); txtinvno.Text = dono; dorder.dodate = dodate; dorder.trxtype = "DO"; dorder.created = DateTime.Now; dorder.dono = dono; dorder.description = codes [1].Trim(); dorder.remark = remark.Text; dorder.term = spinner2.SelectedItem.ToString(); dorder.amount = 0; dorder.custcode = codes [0].Trim(); dorder.isUploaded = false; txtinvno.Text = dono; db.Insert(dorder); adNum.RunNo = runno; if (adNum.ID >= 0) { db.Update(adNum); } else { db.Insert(adNum); } } ShowItemEntry(dorder, codes); }
private void CreateNewInvoice() { Invoice inv = new Invoice(); 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); Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode); Spinner spinner2 = FindViewById <Spinner> (Resource.Id.newinv_type); TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no); EditText remark = FindViewById <EditText> (Resource.Id.newinv_remark); EditText custname = FindViewById <EditText> (Resource.Id.newinv_custname); string[] prefixs = apara.Prefix.Trim().ToUpper().Split(new char[] { '|' }); string prefix = ""; string trxtype = spinner2.SelectedItem.ToString(); // if (trxtype == "CASH") { // adNum = DataHelper.GetNumDate (pathToDatabase, invdate, "CS"); // if (prefixs.Length > 1) { // prefix = prefixs [1]; // }else prefix = prefixs [0]; // } else { adNum = DataHelper.GetNumDate(pathToDatabase, invdate, "INV"); prefix = prefixs [0]; //} 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; } using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { string invno = ""; int runno = adNum.RunNo + 1; int currentRunNo = DataHelper.GetLastInvRunNo(pathToDatabase, invdate, spinner2.SelectedItem.ToString()); if (currentRunNo >= runno) { runno = currentRunNo + 1; } invno = prefix + invdate.ToString("yyMM") + runno.ToString().PadLeft(4, '0'); txtinvno.Text = invno; inv.invdate = invdate; inv.trxtype = "INVOICE"; //spinner2.SelectedItem.ToString (); inv.created = DateTime.Now; inv.invno = invno; inv.description = codes [1].Trim(); //custname.Text; inv.amount = 0; inv.custcode = codes [0].Trim(); inv.isUploaded = false; inv.remark = remark.Text.ToUpper(); if (codes [0].Trim() == "COD" || codes [0].Trim() == "CASH") { inv.description = custname.Text.ToUpper(); } txtinvno.Text = invno; db.Insert(inv); adNum.RunNo = runno; if (adNum.ID >= 0) { db.Update(adNum); } else { db.Insert(adNum); } } ShowItemEntry(inv, codes); }
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); }