protected override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
if (!((GlobalvarsApp)this.Application).ISLOGON)
{
Finish();
}
SetTitle(Resource.String.title_payment);
SetContentView(Resource.Layout.Payment);
string samt = Intent.GetStringExtra("amount") ?? "0";
amount = Convert.ToDouble(samt);
txtAmt = FindViewById <EditText> (Resource.Id.payamt);
txtRound = FindViewById <EditText> (Resource.Id.payround);
txtTotal = FindViewById <EditText> (Resource.Id.paytotal);
txtCash = FindViewById <EditText> (Resource.Id.paycash);
txtChange = FindViewById <EditText> (Resource.Id.paychange);
txtAmt.Text = amount.ToString("n2");
double roundVal = 0;
double ttlAmt = Utility.AdjustToNear(amount, ref roundVal);
txtRound.Text = roundVal.ToString("n2");
txtTotal.Text = ttlAmt.ToString("n2");
txtCash.EditorAction += HandleEditorAction;
txtCash.AfterTextChanged += TxtCash_AfterTextChanged;
Button butInvBack = FindViewById <Button> (Resource.Id.payok);
butInvBack.Click += (object sender, EventArgs e) => {
base.OnBackPressed();
};
txtCash.RequestFocus();
}
public override Dialog OnCreateDialog(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
// Begin building a new dialog.
this.SetStyle(DialogFragmentStyle.Normal, Android.Resource.Style.ThemeDialog);
var builder = new AlertDialog.Builder(this.Activity);
//Get the layout inflater
var inflater = Activity.LayoutInflater;
var view = inflater.Inflate(Resource.Layout.Payment, null);
txtAmt = view.FindViewById <EditText> (Resource.Id.payamt);
if (txtAmt != null)
{
txtRound = view.FindViewById <EditText> (Resource.Id.payround);
txtTotal = view.FindViewById <EditText> (Resource.Id.paytotal);
txtCash = view.FindViewById <EditText> (Resource.Id.paycash);
txtChange = view.FindViewById <EditText> (Resource.Id.paychange);
Button butInvBack = view.FindViewById <Button> (Resource.Id.payok);
txtCust = view.FindViewById <EditText> (Resource.Id.newinv_custname);
txtRemark = view.FindViewById <EditText> (Resource.Id.newinv_remark);
txtInvno = view.FindViewById <EditText> (Resource.Id.newinvno);
txtRemark.Text = Remark;
txtInvno.Text = InvNo;
txtCust.Text = CustName;
txtAmt.Text = _amount.ToString("n2");
double roundVal = 0;
double ttlAmt = Utility.AdjustToNear(_amount, ref roundVal);
txtRound.Text = roundVal.ToString("n2");
txtTotal.Text = ttlAmt.ToString("n2");
txtCash.EditorAction += HandleEditorAction;
txtCash.AfterTextChanged += TxtCash_AfterTextChanged;
txtCash.Text = "";
butInvBack.Visibility = ViewStates.Gone;
builder.SetView(view);
builder.SetPositiveButton(Resources.GetString(Resource.String.button_paidprint), HandlePositiveButtonClick);
builder.SetNegativeButton(Resources.GetString(Resource.String.button_cancel), HandleNegativeButtonClick);
builder.SetNeutralButton(Resources.GetString(Resource.String.button_paid), HandlePaidOnlyButtonClick);
builder.SetCancelable(false);
txtCash.RequestFocus();
ShowKeyBoard(view);
}
var dialog = builder.Create();
//Now return the constructed dialog to the calling activity
WindowManagerLayoutParams wmlp = dialog.Window.Attributes;
wmlp.Gravity = GravityFlags.Top | GravityFlags.Center;
return(dialog);
}
void populate(List <InvoiceDtls> list)
{
list.Clear();
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
var list2 = db.Table <InvoiceDtls> ()
.Where(x => x.invno == inv.invno)
.OrderByDescending(x => x.ID)
.ToList <InvoiceDtls> ();
ttlamt = 0;
ttltax = 0;
foreach (var item in list2)
{
ttlamt = ttlamt + item.netamount;
ttltax = ttltax + item.tax;
list.Add(item);
}
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);
}
}
}
public void PrintTotalAjust(ref string test, double ttlAmt, double ttlTax)
{
double roundVal = 0;
double ttlRounAmt = Utility.AdjustToNear(ttlAmt + ttlTax, ref roundVal);
test += "------------------------------------------\n";
test += " TOTAL EXCL GST " + Math.Round(ttlAmt, 2).ToString("n2").PadLeft(12, ' ') + "\n";
test += " TOTAL TAX " + Math.Round(ttlTax, 2).ToString("n2").PadLeft(12, ' ') + "\n";
test += " TOTAL INCL GST " + Math.Round(ttlAmt + ttlTax, 2).ToString("n2").PadLeft(12, ' ') + "\n";
test += " ROUNDING ADJ " + Math.Round(roundVal, 2).ToString("n2").PadLeft(12, ' ') + "\n";
test += " TOTAL AMOUNT " + Math.Round(ttlRounAmt, 2).ToString("n2").PadLeft(12, ' ') + "\n";
test += "------------------------------------------\n";
}
public void PrintTotalAjust(ref string test, double cnttlAmt, double cnttlTax, double InvttlAmt, double invttlTax)
{
double roundVal = 0;
//double ttlCollect = (InvttlAmt + invttlTax) - (cnttlAmt + cnttlTax);
double ttlInv = Utility.AdjustToNear(InvttlAmt + invttlTax, ref roundVal);
double ttlCN = Utility.AdjustToNear(cnttlAmt + cnttlTax, ref roundVal);
double ttlCollect = ttlInv - ttlCN;
test += "------------------------------------------\n";
test += " TOTAL INVOICE AMOUNT : " + Math.Round(ttlInv, 2).ToString("n2").PadLeft(12, ' ') + "\n";
test += " TOTAL C/NOTE AMOUNT : " + Math.Round(ttlCN, 2).ToString("n2").PadLeft(12, ' ') + "\n";
test += " TOTAL COLLECT AMOUNT : " + Math.Round(ttlCollect, 2).ToString("n2").PadLeft(12, ' ') + "\n";
test += "------------------------------------------\n";
}
private string GetInvoiceSumm(DateTime printDate1, DateTime printDate2)
{
string text = "";
int count = 0;
double ttlAmtl = 0;
double ttlCN = 0;
double ttl = 0;
double rate = 0;
double roundVal = 0;
double GranInv = 0;
double GranCN = 0;
double GranCSInv = 0;
double GranCSCN = 0;
string cnno = "";
bool isSamedate = printDate1 == printDate2;
string pathToDatabase = ((GlobalvarsApp)Application.Context).DATABASE_PATH;
SQLiteConnection db = new SQLiteConnection(pathToDatabase);
PrintSummHeader(printDate1, printDate2, ref text);
var list = db.Table <Invoice>().ToList();
var cnlist = db.Table <CNNote>().ToList();
var grps = from p in list
where p.invdate >= printDate1 && p.invdate <= printDate2
group p by p.invdate into g
select new { key = g.Key, result = g.ToList() };
foreach (var grp in grps)
{
count = 1;
GranInv = 0;
GranCN = 0;
GranCSInv = 0;
GranCSCN = 0;
//"------------------------------------------\";
//12. 123456789012345678901234567890 12345567
//CN without Inv
var cnNoInvs = cnlist.Where(x => x.invdate == grp.key && x.invno == "");
if (!isSamedate)
{
text = text + grp.key.ToString("dd-MM-yyyy") + "\n";
text = text + "------------------------------------------\n";
}
foreach (var itm in grp.result)
{
ttlAmtl = itm.amount + itm.taxamt;
ttlCN = 0;
ttl = 0;
cnno = "";
//var cninv = cnlist.Where(x => x.invno == itm.invno && x.invdate == itm.invdate).FirstOrDefault();
var cninv = cnlist.Where(x => x.invno == itm.invno).FirstOrDefault();
if (cninv != null)
{
cnno = cninv.cnno;
ttlCN = cninv.amount + cninv.taxamt;
}
if (itm.trxtype == "CASH")
{
ttlAmtl = Utility.AdjustToNear(ttlAmtl, ref roundVal);
ttlCN = Utility.AdjustToNear(ttlCN, ref roundVal);
GranCSInv = GranCSInv + ttlAmtl;
GranCSCN = GranCSCN + ttlCN;
}
else
{
GranInv = GranInv + ttlAmtl;
GranCN = GranCN + ttlCN;
}
if (itm.description.Length > 30)
{
//12. 123456789012345678901234567890 12345567
text = text + count.ToString().PadRight(2, ' ') + ". " + itm.description.Substring(0, 30) + " " + itm.created.ToString("hh:mmtt") + "\n";
text = text + "".PadRight(4, ' ') + itm.description.Substring(30).Trim() + "\n";
}
else
{
text = text + count.ToString().PadRight(2, ' ') + ". " + itm.description.PadRight(30, ' ') + " " + itm.created.ToString("hh:mmtt") + "\n";
}
text = text + "INV AMT -" + itm.invno.PadRight(21, ' ') + ttlAmtl.ToString("n2").PadLeft(12, ' ') + "\n";
text = text + "CN AMT -" + cnno.PadRight(21, ' ') + ttlCN.ToString("n2").PadLeft(12, ' ') + "\n";
ttl = ttlAmtl - ttlCN;
if (ttlCN > 0)
{
rate = Math.Round((ttlCN / ttlAmtl) * 100, 2);
}
text = text + "TOTAL COLLECT AMOUNT -".PadRight(30, ' ') + ttl.ToString("n2").PadLeft(12, ' ') + "\n";
text = text + "RETURN RATE % -".PadRight(30, ' ') + rate.ToString("n2").PadLeft(12, ' ') + "\n\n";
count += 1;
}
foreach (var itm in cnNoInvs)
{
ttlAmtl = 0;
ttlCN = itm.amount + itm.taxamt;
ttl = 0;
cnno = "";
if (itm.trxtype == "CASH")
{
ttlCN = Utility.AdjustToNear(ttlCN, ref roundVal);
GranCSCN = GranCSCN + ttlCN;
}
else
{
GranCN = GranCN + ttlCN;
}
if (itm.description.Length > 30)
{
//12. 123456789012345678901234567890 12345567
text = text + count.ToString().PadRight(2, ' ') + ". " + itm.description.Substring(0, 30) + " " + itm.created.ToString("hh:mmtt") + "\n";
text = text + "".PadRight(4, ' ') + itm.description.Substring(30).Trim() + "\n";
}
else
{
text = text + count.ToString().PadRight(2, ' ') + ". " + itm.description.PadRight(30, ' ') + " " + itm.created.ToString("hh:mmtt") + "\n";
}
text = text + "INV AMT -" + itm.invno.PadRight(21, ' ') + ttlAmtl.ToString("n2").PadLeft(12, ' ') + "\n";
text = text + "CN AMT -" + itm.cnno.PadRight(21, ' ') + ttlCN.ToString("n2").PadLeft(12, ' ') + "\n";
ttl = ttlAmtl - ttlCN;
rate = 0;
text = text + "TOTAL COLLECT AMOUNT -".PadRight(30, ' ') + ttl.ToString("n2").PadLeft(12, ' ') + "\n";
text = text + "RETURN RATE % -".PadRight(30, ' ') + rate.ToString("n2").PadLeft(12, ' ') + "\n\n";
count += 1;
}
text = text + "\n";
text = text + "SALES SUMMARY\n\n";
text = text + "TOTAL INVOICE ".PadRight(30, ' ') + GranInv.ToString("n2").PadLeft(12, ' ') + "\n";
text = text + "TOTAL CN INVOICE".PadRight(30, ' ') + GranCN.ToString("n2").PadLeft(12, ' ') + "\n";
text = text + "TOTAL INVOICE COLLECT ".PadRight(30, ' ') + (GranInv - GranCN).ToString("n2").PadLeft(12, ' ') + "\n\n";
text = text + "TOTAL CASH ".PadRight(30, ' ') + GranCSInv.ToString("n2").PadLeft(12, ' ') + "\n";
text = text + "TOTAL CN CASH".PadRight(30, ' ') + GranCSCN.ToString("n2").PadLeft(12, ' ') + "\n";
text = text + "TOTAL CASH COLLECT ".PadRight(30, ' ') + (GranCSInv - GranCSCN).ToString("n2").PadLeft(12, ' ') + "\n\n";
}
text += "------------------------------------------\n";
text += "CASH COLLECTION :\n\n\n";
text += "(-)DIESEL EXP :\n\n\n";
text += "(-)OTHER EXP :\n\n\n";
text += "(=)NET COLLECTION :\n\n\n";
text += "(-)PAYMENT :\n\n\n";
text += "(=)SHORT :\n\n\n";
text += "PREPARED BY:\n\n\n\n\n";
text += "VERIFY BY :\n\n\n\n\n";
text += "------------------------------------------\n\n\n\n";
db.Close();
return(text);
}
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);
}
}
}
