List <GeoLocationModel> GetData() { DateTime sdate = DateTime.Today; DateTime edate; if (txtdate.Text != "") { sdate = Utility.ConvertToDate(txtdate.Text); } edate = sdate.AddDays(1); List <GeoLocationModel> list = new System.Collections.Generic.List <GeoLocationModel>(); using (var db = new SQLite.SQLiteConnection(pathToDatabase, true)) { var geos = db.Table <GeoLocation> ().Where(x => x.Date >= sdate && x.Date <= edate).OrderBy(x => x.Date).ToList(); foreach (var geo in geos) { GeoLocationModel m = new GeoLocationModel(); m.Altitude = geo.Altitude; m.Date = geo.Date.ToString("dd-MM-yy hh:mm tt"); m.lat = geo.lat; m.lng = geo.lng; m.Desc = geo.Date.ToString("dd-MM-yy hh:mm tt"); list.Add(m); } } return(list); }
private void LoadData() { EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date); DateTime invdate = Utility.ConvertToDate(trxdate.Text); DateTime tmr = invdate.AddDays(1); Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode); Spinner spinner2 = FindViewById <Spinner> (Resource.Id.newinv_type); 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); trxdate.Text = soInfo.sodate.ToString("dd-MM-yyyy"); var found1 = icodes.Where(x => x.IndexOf(soInfo.custcode + " | ") > -1).ToList(); var found2 = icodes2.Where(x => x.IndexOf(soInfo.billTo + " | ") > -1).ToList(); if (found1.Count > 0) { int pos = dataAdapter.GetPosition(found1[0]); spinner.SetSelection(pos); } if (found2.Count > 0) { int pos = dataAdapter2.GetPosition(found2[0]); spinnerBill.SetSelection(pos); } txtinvno.Text = soInfo.sono; custpo.Text = soInfo.custpono; remark.Text = soInfo.remark; }
void SaveData() { DateTime date = Utility.ConvertToDate(TRXDATE); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list = db.Table <ItemStock> ().Where(x => x.ICode == ICODE && x.DateTrx == date).ToList(); if (list.Count > 0) { list [0].QtyAct = Convert2NumTool <double> .ConvertVal(qtyAct.Text); list [0].QtyRtr = Convert2NumTool <double> .ConvertVal(qtyRtn.Text); list [0].QtyCrf = Convert2NumTool <double> .ConvertVal(qtyCrf.Text); list [0].QtyBrf = Convert2NumTool <double> .ConvertVal(qtyBrf.Text); list [0].QtyBal = Convert2NumTool <double> .ConvertVal(qtySales.Text); db.Update(list [0]); } } Toast.MakeText(this, Resources.GetString(Resource.String.msg_successsave), ToastLength.Long).Show(); base.OnBackPressed(); }
private void LoadData() { EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date); DateTime invdate = Utility.ConvertToDate(trxdate.Text); DateTime tmr = invdate.AddDays(1); 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 txtcustname = FindViewById <EditText> (Resource.Id.newinv_custname); trxdate.Text = invInfo.invdate.ToString("dd-MM-yyyy"); if (invInfo.custcode == "COD" || invInfo.custcode == "CASH") { spinner.SetSelection(CashPos); } else { int pos1 = dataAdapter.GetPosition(invInfo.custcode + " | " + invInfo.description); spinner.SetSelection(pos1); } int pos2 = TRXTYPE == "CASH" ? 0 : 1; //int pos2= dataAdapter2.GetPosition (invInfo.trxtype); spinnerType.SetSelection(pos2); remark.Text = invInfo.remark; txtinvno.Text = invInfo.invno; txtcustname.Text = invInfo.description; }
void CreateNewInv() { DateTime invdate = Utility.ConvertToDate(txtInvDate.Text); DateTime tmr = invdate.AddDays(1); AdNumDate adNum; // = DataHelper.GetNumDate (pathToDatabase, invdate); apara = DataHelper.GetAdPara(pathToDatabase); string[] prefixs = apara.Prefix.Trim().ToUpper().Split(new char[] { '|' }); string prefix = ""; adNum = DataHelper.GetNumDate(pathToDatabase, invdate, "INV"); if (prefixs.Length > 1) { prefix = prefixs [0]; } else { prefix = prefixs [0]; } invno = ""; int runno = adNum.RunNo + 1; int currentRunNo = DataHelper.GetLastInvRunNo(pathToDatabase, invdate, "INVOICE"); if (currentRunNo >= runno) { runno = currentRunNo + 1; } invno = prefix + invdate.ToString("yyMM") + runno.ToString().PadLeft(4, '0'); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { inv = new Invoice(); inv.invno = invno; inv.invdate = invdate; inv.trxtype = "INVOICE"; inv.created = DateTime.Now; inv.amount = 0; inv.isUploaded = false; inv.remark = ""; db.Insert(inv); adNum.RunNo = runno; if (adNum.ID >= 0) { db.Update(adNum); } else { db.Insert(adNum); } } txtInvNo.Text = inv.invno; txtInvDate.Text = inv.invdate.ToString("dd-MM-yyyy"); txtInvMode.Text = "NEW"; IsSave = false; IsFirePaid = false; IsFirePaidOnly = false; EnableControLs(true, true, false, true, false); }
public void PerformEvent(object sender, EventParam e) { switch (e.EventID) { case 2020: sdate = Utility.ConvertToDate(e.Param ["DATE1"].ToString()); edate = Utility.ConvertToDate(e.Param ["DATE2"].ToString()); break; } }
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 LoadData() { EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date); DateTime invdate = Utility.ConvertToDate(trxdate.Text); DateTime tmr = invdate.AddDays(1); 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); trxdate.Text = doInfo.dodate.ToString("dd-MM-yyyy"); int pos1 = dataAdapter.GetPosition(doInfo.custcode + " | " + doInfo.description); int pos2 = dataAdapter2.GetPosition(doInfo.trxtype); spinner.SetSelection(pos1); spinner2.SetSelection(pos2); remark.Text = doInfo.remark; txtinvno.Text = doInfo.dono; }
private void LoadData() { EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date); 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); TextView cnno = FindViewById <TextView> (Resource.Id.newinv_no); trxdate.Text = cnInfo.invdate.ToString("dd-MM-yyyy"); int pos1 = dataAdapter.GetPosition(cnInfo.custcode + " | " + cnInfo.description); spinner.SetSelection(pos1); remark.Text = cnInfo.remark; cninvno.Text = cnInfo.invno; cnno.Text = cnInfo.cnno; if (!string.IsNullOrEmpty(cnInfo.invno)) { spinner.Enabled = false; Button butFind = FindViewById <Button> (Resource.Id.newinv_bfind); butFind.Enabled = false; } }
void ButPrint_Click(object sender, EventArgs e) { EditText frd = FindViewById <EditText> (Resource.Id.trxdatefr); EditText tod = FindViewById <EditText> (Resource.Id.trxdateto); DateTime?sdate = null; DateTime?edate = null; if (frd.Text != "") { sdate = Utility.ConvertToDate(frd.Text); } else { sdate = DateTime.Today; } // if (tod.Text != "") { // edate =Utility.ConvertToDate (tod.Text); // } // if (edate == null) // edate = sdate; PrintInvSumm(sdate.Value, sdate.Value); }
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); }
void LoadData() { ItemStock stk; DateTime date = Utility.ConvertToDate(TRXDATE); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list = db.Table <ItemStock> ().Where(x => x.ICode == ICODE && x.DateTrx == date).ToList(); if (list.Count > 0) { txtIDesc.Text = list [0].IDesc; txtICode.Text = list [0].ICode; txtDate.Text = TRXDATE; if (list [0].QtyAct > 0) { qtyAct.Text = list [0].QtyAct.ToString(); } else { qtyAct.Text = ""; } qtyGr.Text = list [0].QtyGR.ToString(); if (list [0].QtyRtr > 0) { qtyRtn.Text = list [0].QtyRtr.ToString(); } else { qtyRtn.Text = ""; } if (list [0].QtyCrf > 0) { qtyCrf.Text = list [0].QtyCrf.ToString(); } else { qtyCrf.Text = ""; } if (list [0].QtyBrf > 0) { qtyBrf.Text = list [0].QtyBrf.ToString(); } else { qtyBrf.Text = ""; } if (list [0].QtyBal > 0) { qtySales.Text = list [0].QtyBal.ToString(); } else { qtySales.Text = ""; } } // var listinv =db.Table<Invoice> ().Where (x =>x.invdate == date).ToList(); // var list2 = db.Table<InvoiceDtls> ().ToList<InvoiceDtls> (); // // double ttlsales = 0; // foreach (Invoice inv in listinv) { // ttlsales = ttlsales + list2.Where (x => x.invno == inv.invno && x.icode == ICODE).Sum (x => x.qty); // } // // qtySales.Text = ttlsales.ToString (); } }
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); }
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); }