Example #1
0
 public PrintESCPSBase()
 {
     pathToDatabase = ((GlobalvarsApp)Application.Context).DATABASE_PATH;
     USERID = ((GlobalvarsApp)Application.Context).USERID_CODE;
     apara =  DataHelper.GetAdPara (pathToDatabase);
     compInfo =DataHelper.GetCompany(pathToDatabase);
 }
Example #2
0
        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;
        }
Example #3
0
 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;
 }
Example #4
0
        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);
        }
Example #5
0
        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);
            }
        }
Example #7
0
 //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");
 }
Example #8
0
        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);
                }
            }
        }
Example #9
0
        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);
        }
Example #10
0
        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);
            }
        }
Example #11
0
        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);
                }
            }
        }
Example #12
0
        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);
                }
            }
        }
Example #13
0
        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);
                }
            }
        }
Example #14
0
        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);
            }
        }
Example #15
0
        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);
                }
            }
        }
Example #16
0
        /// <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;
        }
Example #17
0
        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);
        }
Example #18
0
 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;
 }
Example #19
0
        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);
        }
Example #20
0
        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);
        }