public PrintESCPSBase() { pathToDatabase = ((GlobalvarsApp)Application.Context).DATABASE_PATH; USERID = ((GlobalvarsApp)Application.Context).USERID_CODE; apara = DataHelper.GetAdPara (pathToDatabase); compInfo =DataHelper.GetCompany(pathToDatabase); }
protected override void OnCreate(Bundle bundle) { base.OnCreate (bundle); if (!((GlobalvarsApp)this.Application).ISLOGON) { Finish (); } SetContentView (Resource.Layout.ListCustViewEx); // Create your application here pathToDatabase = ((GlobalvarsApp)this.Application).DATABASE_PATH; compCode =((GlobalvarsApp)Application).COMPANY_CODE; branchCode =((GlobalvarsApp)Application).BRANCH_CODE; compinfo = DataHelper.GetCompany (pathToDatabase,compCode,branchCode); populate (listData); listView = FindViewById<ListView> (Resource.Id.CustList); Button butInvBack= FindViewById<Button> (Resource.Id.butCustBack); Button butInvAdd= FindViewById<Button> (Resource.Id.butCustAdd); txtSearch= FindViewById<EditText > (Resource.Id.txtSearch); butInvBack.Click += (object sender, EventArgs e) => { base.OnBackPressed(); }; butInvAdd.Click+= (object sender, EventArgs e) => { NewLocalCust(); }; listView.ItemClick+= ListView_ItemClick; ; listView.ItemLongClick+= ListView_ItemLongClick; //istView.Adapter = new CusotmCustomerListAdapter(this, listData); viewdlg = SetViewDelegate; adapter = new GenericListAdapter<Trader> (this, listData, Resource.Layout.ListCustDtlView, viewdlg); listView.Adapter = adapter; txtSearch.TextChanged+= TxtSearch_TextChanged; }
string GetHeaderText(CompanyInfo comp) { string test=""; 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.GSTNo) ? "" : comp.GSTNo.Trim (); string compname = comp.CompanyName.Trim (); string[] names = compname.Split (new char[] { '|' }); if (names.Length > 1) { test += names [0] + "\n"; if ((names [1].Trim ().Length + comp.RegNo.Trim ().Length + 2) > 42) { //test += names [1].Trim () + "\n"; //test += "(" + comp.RegNo.Trim () + ")\n"; PrintLongText (ref test, names [1].Trim () + "(" + comp.RegNo.Trim () + ")"); } else { test += names [1].Trim () + "(" + comp.RegNo.Trim () + ")\n"; } } else { if ((comp.CompanyName.Trim ().Length + comp.RegNo.Trim ().Length + 2) > 42) { test += comp.CompanyName.Trim () + "\n"; test += "(" + comp.RegNo.Trim () + ")\n"; } else { test += comp.CompanyName.Trim () + "(" + comp.RegNo.Trim () + ")\n"; } } 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"; return test; }
public void PrintCustomerHeader(ref string test,string custCode) { //string pathToDatabase = ((GlobalvarsApp)Application.Context).DATABASE_PATH; Trader trd =DataHelper.GetTrader(pathToDatabase,custCode); CompanyInfo comp = new CompanyInfo (); comp.Addr1 = trd.Addr1; comp.Addr2 = trd.Addr2; comp.Addr3 = trd.Addr3; comp.Addr4 = trd.Addr4; comp.CompanyName = trd.CustName; comp.Fax = trd.Fax; comp.Tel = trd.Tel; comp.GSTNo = trd.gst; comp.RegNo = trd.CustCode; test = GetHeaderText (comp); }
void populate(List<SaleOrderDtls> list) { comp = DataHelper.GetCompany (pathToDatabase); //SqliteConnection.CreateFile(pathToDatabase); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list1 = db.Table<SaleOrder>().Where(x=>x.sono==invno).ToList<SaleOrder>(); var list2 = db.Table<SaleOrderDtls>().Where(x=>x.sono==invno).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<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); } }
//StringBuilder errmsg = new StringBuilder (); public PrintInvHelper(string adpathToDatabase,string userid) { pathToDatabase = adpathToDatabase; USERID = userid; apara = DataHelper.GetAdPara (pathToDatabase); compinfo =DataHelper.GetCompany(pathToDatabase); sdcard = Path.Combine (Android.OS.Environment.ExternalStorageDirectory.Path, "erpdata\\log.txt"); }
public static void InsertCompProfIntoDb(CompanyProfile pro,string pathToDatabase) { using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list2 = db.Table<CompanyInfo>().ToList<CompanyInfo>(); var list3 = db.Table<AdPara>().ToList<AdPara>(); var list4 = db.Table<AdNumDate> ().Where (x => x.Year == DateTime.Now.Year && x.Month == DateTime.Now.Month).ToList<AdNumDate> (); CompanyInfo cprof = null; if (list2.Count > 0) { cprof = list2 [0]; } else { cprof = new CompanyInfo (); } cprof.Addr1 = pro.Addr1; cprof.Addr2= pro.Addr2; cprof.Addr3 = pro.Addr3; cprof.Addr4 = pro.Addr4; cprof.CompanyName = pro.CompanyName; cprof.Fax = pro.Fax; cprof.GSTNo = pro.GSTNo; cprof.HomeCurr = pro.HomeCurr; cprof.IsInclusive = pro.IsInclusive; cprof.RegNo = pro.RegNo; cprof.SalesTaxDec = pro.SalesTaxDec; cprof.AllowDelete = pro.AllowDelete; cprof.AllowEdit = pro.AllowEdit; cprof.WCFUrl = pro.WCFUrl; cprof.SupportContat = pro.SupportContat; cprof.ShowTime = pro.ShowPrintTime; cprof.AllowClrTrxHis = pro.AllowClrTrxHis; cprof.NotEditAfterPrint = pro.NoEditAfterPrint; cprof.Tel = pro.Tel; if (list2.Count==0) db.Insert (cprof); else db.Update (cprof); AdPara apara=null; if (list3.Count == 0) { apara= new AdPara (); } else { apara = list3 [0]; } apara.Prefix = pro.Prefix; apara.RunNo = pro.RunNo; apara.Warehouse = pro.WareHouse; //new added V2 apara.CNPrefix = pro.CNPrefix; apara.CNRunNo = pro.CNRunNo; apara.DOPrefix = pro.DOPrefix; apara.DORunNo = pro.DORunNo; apara.SOPrefix = pro.SOPrefix; apara.SORunNo = pro.SORunNo; if (list3.Count == 0) { apara.ReceiptTitle = "TAX INVOICE"; db.Insert (apara); } else { db.Update (apara); } AdNumDate info = null; if (list4.Count == 0) { info = new AdNumDate (); info.Year = DateTime.Now.Year; info.Month = DateTime.Now.Month; info.RunNo = pro.RunNo; info.TrxType = "INV"; db.Insert (info); } } }
void populate(List<Invoice> list) { using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list2 = db.Table<Invoice>() .Where(x=>x.trxtype==TRXTYPE&& x.isUploaded==true&&x.invdate>=sdate&&x.invdate<=edate) .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<DelOrderDtls> list) { comp = DataHelper.GetCompany (pathToDatabase,compCode,branchCode); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list1 = db.Table<DelOrder>().Where(x=>x.dono==dono&&x.CompCode==compCode&&x.BranchCode==branchCode).ToList<DelOrder>(); var list2 = db.Table<DelOrderDtls>().Where(x=>x.dono==dono&&x.CompCode==compCode&&x.BranchCode==branchCode).ToList<DelOrderDtls>(); var list3 = db.Table<Trader>().Where(x=>x.CustCode==CUSTCODE&&x.CompCode==compCode&&x.BranchCode==branchCode).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<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); } } }
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); } } }
void populate(List <InvoiceDtls> list) { comp = DataHelper.GetCompany(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 (trd != null) { CUSTNAME = trd.CustName; } foreach (var item in list2) { ttlamt = ttlamt + item.netamount; ttltax = ttltax + item.tax; list.Add(item); } if (invoice != null) { invoice.amount = ttlamt; db.Update(invoice); } // 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<InvoiceDtls> list) { comp = DataHelper.GetCompany (pathToDatabase,compCode,branchCode); //SqliteConnection.CreateFile(pathToDatabase); using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list1 = db.Table<Invoice>().Where(x=>x.invno==invno&&x.CompCode==compCode&&x.BranchCode==branchCode).ToList<Invoice>(); var list2 = db.Table<InvoiceDtls>().Where(x=>x.invno==invno&&x.CompCode==compCode&&x.BranchCode==branchCode).ToList<InvoiceDtls>(); var list3 = db.Table<Trader>().Where(x=>x.CustCode==CUSTCODE&&x.CompCode==compCode&&x.BranchCode==branchCode).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); } }
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); } } }
/// <summary> /// Gets the access rights. /// </summary> /// <returns>The access rights.</returns> /// <param name="pathToDatabase">Path to database.</param> public static AccessRights GetAccessRights(string pathToDatabase) { CompanyInfo info = new CompanyInfo(); using (var db = new SQLite.SQLiteConnection (pathToDatabase)) { info = db.Table<CompanyInfo> ().FirstOrDefault (); } // string rights = info.WCFUrl; // AccessRights right = new AccessRights(); // Type rtype = right.GetType(); // // AccessRightField rightdesc = new AccessRightField(); // Type ftype = rightdesc.GetType(); // string[] keys = rights.Split(new char[] { ',' }); // foreach (string key in keys) // { // FieldInfo finfo = ftype.GetField(key); // if (finfo != null) // { // string fname= finfo.GetValue(rightdesc).ToString(); // PropertyInfo pinfo = rtype.GetProperty(fname); // if (pinfo != null) // { // pinfo.SetValue(right, true); // } // } // } if (info == null) { info = new CompanyInfo (); info.WCFUrl = ""; } return GetAccessRightsByString (info.WCFUrl); //return right; }
void populate(List<CNNote> list) { using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list2 = db.Table<CNNote> ().Where (x => x.isUploaded == true && x.CompCode == compCode && x.BranchCode == branchCode &&x.invdate>=sdate&&x.invdate<=edate) .OrderByDescending (x => x.cnno) .ToList<CNNote>(); foreach(var item in list2) { list.Add(item); } } compinfo = DataHelper.GetCompany (pathToDatabase,compCode,branchCode); }
private string GetCompAddress(CompanyInfo comp) { string tel = string.IsNullOrEmpty (compInfo.Tel) ? " " : compInfo.Tel.Trim (); string fax = string.IsNullOrEmpty (compInfo.Fax) ? " " : compInfo.Fax.Trim (); string addr1 = string.IsNullOrEmpty (compInfo.Addr1) ? "" : compInfo.Addr1.Trim (); string addr2 = string.IsNullOrEmpty (compInfo.Addr2) ? "" : compInfo.Addr2.Trim (); string addr3 = string.IsNullOrEmpty (compInfo.Addr3) ? "" : compInfo.Addr3.Trim (); string addr4 = string.IsNullOrEmpty (compInfo.Addr4) ? "" : compInfo.Addr4.Trim (); string gst = string.IsNullOrEmpty (compInfo.GSTNo) ? "" : compInfo.GSTNo.Trim (); string compname = compInfo.CompanyName.Trim (); string address = ""; if (!string.IsNullOrEmpty (addr1)) { address = address + compInfo.Addr1 + "\r"; line +=1; } if (!string.IsNullOrEmpty (addr2)) { address = address + compInfo.Addr2 + "\r"; line +=1; } if (!string.IsNullOrEmpty (addr3)) { address = address + compInfo.Addr3 + "\r";line +=1; } if (!string.IsNullOrEmpty (addr4)) { address = address + compInfo.Addr4 + "\r";line +=1; } address = address + "TEL: " + compInfo.Tel + " FAX: " + compInfo.Fax+"\r"; line +=1; address = address + "GST NO :" + gst + "\r";line +=1; return address; }
void populate(List<SaleOrder> list) { using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list2 = db.Table<SaleOrder>() .Where(x=>x.isUploaded==false) .OrderByDescending (x => x.sodate) .ThenByDescending (x => x.created) .ToList<SaleOrder>(); foreach(var item in list2) { list.Add(item); } } compinfo = DataHelper.GetCompany (pathToDatabase); }
string GetHeaderText(CompanyInfo comp) { string test = ""; 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.GSTNo) ? "" : comp.GSTNo.Trim(); string compname = comp.CompanyName.Trim(); string[] names = compname.Split(new char[] { '|' }); if (names.Length > 1) { test += names [0] + "\n"; if ((names [1].Trim().Length + comp.RegNo.Trim().Length + 2) > 42) { //test += names [1].Trim () + "\n"; //test += "(" + comp.RegNo.Trim () + ")\n"; PrintLongText(ref test, names [1].Trim() + "(" + comp.RegNo.Trim() + ")"); } else { test += names [1].Trim() + "(" + comp.RegNo.Trim() + ")\n"; } } else { if ((comp.CompanyName.Trim().Length + comp.RegNo.Trim().Length + 2) > 42) { test += comp.CompanyName.Trim() + "\n"; test += "(" + comp.RegNo.Trim() + ")\n"; } else { test += comp.CompanyName.Trim() + "(" + comp.RegNo.Trim() + ")\n"; } } 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"; return(test); }