public PrintESCPSBase() { pathToDatabase = ((GlobalvarsApp)Application.Context).DATABASE_PATH; USERID = ((GlobalvarsApp)Application.Context).USERID_CODE; apara = DataHelper.GetAdPara(pathToDatabase); compInfo = DataHelper.GetCompany(pathToDatabase); }
public void PrintCompHeader(ref string test) { //string pathToDatabase = ((GlobalvarsApp)Application.Context).DATABASE_PATH; CompanyInfo comp = DataHelper.GetCompany(pathToDatabase); if (comp == null) { return; } test = GetHeaderText(comp); }
internal virtual void PrintSummHeader(DateTime printdate1, DateTime printdate2, ref string text, bool isSamedate) { string USERID = ((GlobalvarsApp)Application.Context).USERID_CODE; var compinfo = DataHelper.GetCompany(((GlobalvarsApp)Application.Context).DATABASE_PATH); text += "------------------------------------------\n"; //text += compinfo.CompanyName.ToUpper () + "\n"; string[] names = compinfo.CompanyName.ToUpper().Split(new char[] { '|' }); if (names.Length > 1) { text += names [0] + "\n"; if ((names [1].Trim().Length + compinfo.RegNo.Trim().Length + 2) > 42) { //test += names [1].Trim () + "\n"; //test += "(" + comp.RegNo.Trim () + ")\n"; PrintLongText(ref text, names [1].Trim() + "(" + compinfo.RegNo.Trim() + ")"); } else { text += names [1].Trim() + "(" + compinfo.RegNo.Trim() + ")\n"; } } else { if ((compinfo.CompanyName.Trim().Length + compinfo.RegNo.Trim().Length + 2) > 42) { text += compinfo.CompanyName.Trim() + "\n"; text += "(" + compinfo.RegNo.Trim() + ")\n"; } else { text += compinfo.CompanyName.Trim() + "(" + compinfo.RegNo.Trim() + ")\n"; } } text += "USER ID : " + USERID + "\n"; text += "PRINT ON : " + DateTime.Now.ToString("dd-MM-yyyy hh:mm tt") + "\n"; if (isSamedate) { text += "DAILTY SUMMARY ON " + printdate1.ToString("yy-MM-yyyy") + "\n"; } else { text += "DAILTY SUMMARY ON " + printdate1.ToString("yy-MM-yyyy") + " - " + printdate2.ToString("yy-MM-yyyy") + "\n"; } text += "------------------------------------------\n"; text += "NO INVOICE NO TAX AMT AMOUNT\n"; text += "------------------------------------------\n"; // 123 123456789012345 1234567890 123456789012 }
void populate(List <SaleOrderDtls> list) { // var documents = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); // pathToDatabase = Path.Combine(documents, "db_adonet.db"); comp = DataHelper.GetCompany(pathToDatabase); //SqliteConnection.CreateFile(pathToDatabase); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list1 = db.Table <SaleOrder>().Where(x => x.sono == sono).ToList <SaleOrder>(); var list2 = db.Table <SaleOrderDtls>().Where(x => x.sono == sono).ToList <SaleOrderDtls>(); var list3 = db.Table <Trader>().Where(x => x.CustCode == CUSTCODE).ToList <Trader>(); double ttlamt = 0; double ttltax = 0; if (list3.Count > 0) { CUSTNAME = list3 [0].CustName; } foreach (var item in list2) { ttlamt = ttlamt + item.netamount; ttltax = ttltax + item.tax; list.Add(item); } if (list1.Count > 0) { list1 [0].amount = ttlamt; db.Update(list1 [0]); } SaleOrderDtls inv1 = new SaleOrderDtls(); inv1.icode = "TAX"; inv1.netamount = ttlamt; inv1.description = "TOTAL EXCL GST"; SaleOrderDtls inv2 = new SaleOrderDtls(); inv2.icode = "AMOUNT"; inv2.netamount = ttltax; inv2.description = "TOTAL 6% GST"; SaleOrderDtls inv3 = new SaleOrderDtls(); inv3.icode = "TAX"; inv3.netamount = ttlamt + ttltax; inv3.description = "TOTAL INCL GST"; list.Add(inv1); list.Add(inv2); list.Add(inv3); } }
void populate(List <Invoice> list) { using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list2 = db.Table <Invoice> () .Where(x => x.isUploaded == false && x.trxtype == "INVOICE") .OrderByDescending(x => x.invdate) .ThenByDescending(x => x.created) .ToList <Invoice> (); foreach (var item in list2) { list.Add(item); } } compinfo = DataHelper.GetCompany(pathToDatabase); }
void populate(List <SaleOrder> list) { using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list2 = db.Table <SaleOrder>() .Where(x => x.isUploaded == true) .OrderByDescending(x => x.sodate) .ThenByDescending(x => x.created) .ToList <SaleOrder>(); foreach (var item in list2) { list.Add(item); } } compinfo = DataHelper.GetCompany(pathToDatabase); }
void ClearPostedInv() { CompanyInfo para = DataHelper.GetCompany(pathToDatabase); if (!para.AllowClrTrxHis) { Toast.MakeText(this, Resources.GetString(Resource.String.msg_accessdenied), ToastLength.Long).Show(); return; } using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { db.DeleteAll <InvoiceDtls> (); db.DeleteAll <Invoice> (); db.DeleteAll <CNNoteDtls> (); db.DeleteAll <CNNote> (); Toast.MakeText(this, Resources.GetString(Resource.String.msg_trxclear), ToastLength.Long).Show(); } }
void ButAbt_Click(object sender, EventArgs e) { CompanyInfo comp = DataHelper.GetCompany(pathToDatabase); View messageView = LayoutInflater.Inflate(Resource.Layout.About, null, false); PackageInfo pInfo = PackageManager.GetPackageInfo(PackageName, 0); // When linking text, force to always use default color. This works // around a pressed color state bug. TextView textView = (TextView)messageView.FindViewById(Resource.Id.about_credits); TextView textDesc = (TextView)messageView.FindViewById(Resource.Id.about_descrip); TextView textVer = (TextView)messageView.FindViewById(Resource.Id.about_ver); //textDesc.Text = Html.FromHtml (Resources.GetString(Resource.String.app_descrip))..ToString(); textView.Text = "For inquiry, please contact " + comp.SupportContat; textVer.Text = "Build Version : " + pInfo.VersionName; AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.SetIcon(Resource.Drawable.Icon); builder.SetTitle(Resource.String.app_name); builder.SetView(messageView); builder.Create(); builder.Show(); }
void populate(List <DelOrderDtls> list) { // var documents = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); // pathToDatabase = Path.Combine(documents, "db_adonet.db"); comp = DataHelper.GetCompany(pathToDatabase); //SqliteConnection.CreateFile(pathToDatabase); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list1 = db.Table <DelOrder>().Where(x => x.dono == dono).ToList <DelOrder>(); var list2 = db.Table <DelOrderDtls>().Where(x => x.dono == dono).ToList <DelOrderDtls>(); var list3 = db.Table <Trader>().Where(x => x.CustCode == CUSTCODE).ToList <Trader>(); double ttlamt = 0; double ttltax = 0; if (list3.Count > 0) { CUSTNAME = list3 [0].CustName; } foreach (var item in list2) { ttlamt = ttlamt + item.qty; ttltax = ttltax + item.tax; list.Add(item); } if (list1.Count > 0) { list1 [0].amount = ttlamt; db.Update(list1 [0]); } DelOrderDtls inv2 = new DelOrderDtls(); inv2.icode = "TOTAL"; inv2.qty = ttlamt; list.Add(inv2); } }
void populate(List <InvoiceDtls> list) { comp = DataHelper.GetCompany(pathToDatabase); //SqliteConnection.CreateFile(pathToDatabase); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list1 = db.Table <Invoice>().Where(x => x.invno == invno).ToList <Invoice>(); var list2 = db.Table <InvoiceDtls>().Where(x => x.invno == invno).ToList <InvoiceDtls>(); var list3 = db.Table <Trader>().Where(x => x.CustCode == CUSTCODE).ToList <Trader>(); double ttlamt = 0; double ttltax = 0; if (list3.Count > 0) { CUSTNAME = list3 [0].CustName; } foreach (var item in list2) { ttlamt = ttlamt + item.netamount; ttltax = ttltax + item.tax; list.Add(item); } if (list1.Count > 0) { list1 [0].amount = ttlamt; db.Update(list1 [0]); } // InvoiceDtls inv1 = new InvoiceDtls (); // inv1.icode = "TAX"; // inv1.netamount = ttltax; // InvoiceDtls inv2 = new InvoiceDtls (); // inv2.icode = "AMOUNT"; // inv2.netamount = ttlamt; // // list.Add (inv1); // list.Add (inv2); double roundVal = 0; double ttlNet = Utility.AdjustToNear(ttlamt + ttltax, ref roundVal); InvoiceDtls inv1 = new InvoiceDtls(); inv1.icode = "TAX"; inv1.netamount = ttlamt; inv1.description = "TOTAL EXCL GST"; InvoiceDtls inv2 = new InvoiceDtls(); inv2.icode = "AMOUNT"; inv2.netamount = ttltax; inv2.description = "TOTAL 6% GST"; InvoiceDtls inv3 = new InvoiceDtls(); inv3.icode = "TAX"; inv3.netamount = ttlamt + ttltax; inv3.description = "TOTAL INCL GST"; InvoiceDtls inv4 = new InvoiceDtls(); inv4.icode = "AMOUNT"; inv4.netamount = roundVal; inv4.description = "ROUNDING ADJUST"; InvoiceDtls inv5 = new InvoiceDtls(); inv5.icode = "AMOUNT"; inv5.netamount = ttlNet; inv5.description = "NET TOTAL"; list.Add(inv1); list.Add(inv2); list.Add(inv3); if (TRXTYPE == "CASH") { list.Add(inv4); list.Add(inv5); } } }
void populate(List <CNNoteDtls> list) { //var documents = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); //pathToDatabase = Path.Combine(documents, "db_adonet.db"); comp = DataHelper.GetCompany(pathToDatabase); //SqliteConnection.CreateFile(pathToDatabase); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list1 = db.Table <CNNote>().Where(x => x.cnno == invno).ToList <CNNote>(); var list2 = db.Table <CNNoteDtls>().Where(x => x.cnno == invno).ToList <CNNoteDtls>(); var list3 = db.Table <Trader>().Where(x => x.CustCode == CUSTCODE).ToList <Trader>(); double ttlamt = 0; double ttltax = 0; if (list3.Count > 0) { CUSTNAME = list3 [0].CustName; } foreach (var item in list2) { ttlamt = ttlamt + item.netamount; ttltax = ttltax + item.tax; list.Add(item); } if (list1.Count > 0) { list1 [0].amount = ttlamt; db.Update(list1 [0]); } // CNNoteDtls inv1 = new CNNoteDtls (); // inv1.icode = "TAX"; // inv1.netamount = ttltax; // CNNoteDtls inv2 = new CNNoteDtls (); // inv2.icode = "AMOUNT"; // inv2.netamount = ttlamt; // // list.Add (inv1); // list.Add (inv2); double roundVal = 0; double ttlNet = Utility.AdjustToNear(ttlamt + ttltax, ref roundVal); CNNoteDtls inv1 = new CNNoteDtls(); inv1.icode = "TAX"; inv1.netamount = ttlamt; inv1.description = "TOTAL EXCL GST"; CNNoteDtls inv2 = new CNNoteDtls(); inv2.icode = "AMOUNT"; inv2.netamount = ttltax; inv2.description = "TOTAL 6% GST"; CNNoteDtls inv3 = new CNNoteDtls(); inv3.icode = "TAX"; inv3.netamount = ttlamt + ttltax; inv3.description = "TOTAL INCL GST"; CNNoteDtls inv4 = new CNNoteDtls(); inv4.icode = "AMOUNT"; inv4.netamount = roundVal; inv4.description = "ROUNDING ADJUST"; CNNoteDtls inv5 = new CNNoteDtls(); inv5.icode = "AMOUNT"; inv5.netamount = ttlNet; inv5.description = "NET TOTAL"; list.Add(inv1); list.Add(inv2); list.Add(inv3); if (invno.IndexOf("(CS)") > -1) { list.Add(inv4); list.Add(inv5); } } }