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);
}
}
}
