List <GeoLocationModel> GetData()
{
DateTime sdate = DateTime.Today;
DateTime edate;
if (txtdate.Text != "")
{
sdate = Utility.ConvertToDate(txtdate.Text);
}
edate = sdate.AddDays(1);
List <GeoLocationModel> list = new System.Collections.Generic.List <GeoLocationModel>();
using (var db = new SQLite.SQLiteConnection(pathToDatabase, true))
{
var geos = db.Table <GeoLocation> ().Where(x => x.Date >= sdate && x.Date <= edate).OrderBy(x => x.Date).ToList();
foreach (var geo in geos)
{
GeoLocationModel m = new GeoLocationModel();
m.Altitude = geo.Altitude;
m.Date = geo.Date.ToString("dd-MM-yy hh:mm tt");
m.lat = geo.lat;
m.lng = geo.lng;
m.Desc = geo.Date.ToString("dd-MM-yy hh:mm tt");
list.Add(m);
}
}
return(list);
}
private void LoadData()
{
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
DateTime invdate = Utility.ConvertToDate(trxdate.Text);
DateTime tmr = invdate.AddDays(1);
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
Spinner spinner2 = FindViewById <Spinner> (Resource.Id.newinv_type);
TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no);
TextView custname = FindViewById <TextView> (Resource.Id.newinv_custname);
EditText custpo = FindViewById <EditText> (Resource.Id.newinv_po);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_remark);
trxdate.Text = soInfo.sodate.ToString("dd-MM-yyyy");
var found1 = icodes.Where(x => x.IndexOf(soInfo.custcode + " | ") > -1).ToList();
var found2 = icodes2.Where(x => x.IndexOf(soInfo.billTo + " | ") > -1).ToList();
if (found1.Count > 0)
{
int pos = dataAdapter.GetPosition(found1[0]);
spinner.SetSelection(pos);
}
if (found2.Count > 0)
{
int pos = dataAdapter2.GetPosition(found2[0]);
spinnerBill.SetSelection(pos);
}
txtinvno.Text = soInfo.sono;
custpo.Text = soInfo.custpono;
remark.Text = soInfo.remark;
}
void SaveData()
{
DateTime date = Utility.ConvertToDate(TRXDATE);
using (var db = new SQLite.SQLiteConnection(pathToDatabase))
{
var list = db.Table <ItemStock> ().Where(x => x.ICode == ICODE && x.DateTrx == date).ToList();
if (list.Count > 0)
{
list [0].QtyAct = Convert2NumTool <double> .ConvertVal(qtyAct.Text);
list [0].QtyRtr = Convert2NumTool <double> .ConvertVal(qtyRtn.Text);
list [0].QtyCrf = Convert2NumTool <double> .ConvertVal(qtyCrf.Text);
list [0].QtyBrf = Convert2NumTool <double> .ConvertVal(qtyBrf.Text);
list [0].QtyBal = Convert2NumTool <double> .ConvertVal(qtySales.Text);
db.Update(list [0]);
}
}
Toast.MakeText(this, Resources.GetString(Resource.String.msg_successsave), ToastLength.Long).Show();
base.OnBackPressed();
}
private void LoadData()
{
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
DateTime invdate = Utility.ConvertToDate(trxdate.Text);
DateTime tmr = invdate.AddDays(1);
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
//Spinner spinner2 = FindViewById<Spinner> (Resource.Id.newinv_type);
TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_remark);
EditText txtcustname = FindViewById <EditText> (Resource.Id.newinv_custname);
trxdate.Text = invInfo.invdate.ToString("dd-MM-yyyy");
if (invInfo.custcode == "COD" || invInfo.custcode == "CASH")
{
spinner.SetSelection(CashPos);
}
else
{
int pos1 = dataAdapter.GetPosition(invInfo.custcode + " | " + invInfo.description);
spinner.SetSelection(pos1);
}
int pos2 = TRXTYPE == "CASH" ? 0 : 1;
//int pos2= dataAdapter2.GetPosition (invInfo.trxtype);
spinnerType.SetSelection(pos2);
remark.Text = invInfo.remark;
txtinvno.Text = invInfo.invno;
txtcustname.Text = invInfo.description;
}
void CreateNewInv()
{
DateTime invdate = Utility.ConvertToDate(txtInvDate.Text);
DateTime tmr = invdate.AddDays(1);
AdNumDate adNum; // = DataHelper.GetNumDate (pathToDatabase, invdate);
apara = DataHelper.GetAdPara(pathToDatabase);
string[] prefixs = apara.Prefix.Trim().ToUpper().Split(new char[] { '|' });
string prefix = "";
adNum = DataHelper.GetNumDate(pathToDatabase, invdate, "INV");
if (prefixs.Length > 1)
{
prefix = prefixs [0];
}
else
{
prefix = prefixs [0];
}
invno = "";
int runno = adNum.RunNo + 1;
int currentRunNo = DataHelper.GetLastInvRunNo(pathToDatabase, invdate, "INVOICE");
if (currentRunNo >= runno)
{
runno = currentRunNo + 1;
}
invno = prefix + invdate.ToString("yyMM") + runno.ToString().PadLeft(4, '0');
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
inv = new Invoice();
inv.invno = invno;
inv.invdate = invdate;
inv.trxtype = "INVOICE";
inv.created = DateTime.Now;
inv.amount = 0;
inv.isUploaded = false;
inv.remark = "";
db.Insert(inv);
adNum.RunNo = runno;
if (adNum.ID >= 0)
{
db.Update(adNum);
}
else
{
db.Insert(adNum);
}
}
txtInvNo.Text = inv.invno;
txtInvDate.Text = inv.invdate.ToString("dd-MM-yyyy");
txtInvMode.Text = "NEW";
IsSave = false;
IsFirePaid = false;
IsFirePaidOnly = false;
EnableControLs(true, true, false, true, false);
}
public void PerformEvent(object sender, EventParam e)
{
switch (e.EventID)
{
case 2020:
sdate = Utility.ConvertToDate(e.Param ["DATE1"].ToString());
edate = Utility.ConvertToDate(e.Param ["DATE2"].ToString());
break;
}
}
private bool SaveSO()
{
bool lSave = false;
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
if (!Utility.IsValidDateString(trxdate.Text))
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show();
return(false);
}
DateTime sodate = Utility.ConvertToDate(trxdate.Text);
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no);
TextView custname = FindViewById <TextView> (Resource.Id.newinv_custname);
EditText custpo = FindViewById <EditText> (Resource.Id.newinv_po);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_remark);
if (spinner.SelectedItem == null)
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show();
spinner.RequestFocus();
return(lSave);
}
string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' });
if (codes.Length == 0)
{
return(lSave);
}
string[] codes2 = spinnerBill.SelectedItem.ToString().Split(new char[] { '|' });
string billTo = "";
if (codes.Length > 0)
{
billTo = codes2 [0].Trim();
}
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
soInfo.sodate = sodate;
soInfo.trxtype = "SO";
soInfo.created = DateTime.Now;
soInfo.billTo = billTo;
soInfo.remark = remark.Text.ToUpper();
soInfo.custpono = custpo.Text.ToUpper();
soInfo.custcode = codes [0].Trim();
soInfo.description = codes [1].Trim();
soInfo.isUploaded = false;
db.Update(soInfo);
lSave = true;
}
return(lSave);
}
void CreateCashBill()
{
if (!Utility.IsValidDateString(txtInvDate.Text))
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show();
return;
}
DateTime invdate = Utility.ConvertToDate(txtInvDate.Text);
ValidateInvDate(invdate);
}
private bool SaveInvoice()
{
bool lSave = false;
Invoice inv = new Invoice();
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
if (!Utility.IsValidDateString(trxdate.Text))
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show();
return(lSave);
}
DateTime invdate = Utility.ConvertToDate(trxdate.Text);
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
//Spinner spinner2 = FindViewById<Spinner> (Resource.Id.newinv_type);
TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no);
EditText txtcustname = FindViewById <EditText> (Resource.Id.newinv_custname);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_remark);
if (spinner.SelectedItem == null)
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show();
spinner.RequestFocus();
return(lSave);
}
string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' });
if (codes.Length == 0)
{
return(lSave);
}
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
invInfo.invdate = invdate;
invInfo.trxtype = TRXTYPE; //spinner2.SelectedItem.ToString ();
invInfo.created = DateTime.Now;
invInfo.description = codes [1].Trim();
invInfo.remark = remark.Text.ToUpper();
//inv.amount = 0;
invInfo.custcode = codes [0].Trim();
invInfo.isUploaded = false;
if (codes [0].Trim() == "COD" || codes [0].Trim() == "CASH")
{
inv.description = txtcustname.Text.ToUpper();
}
db.Update(invInfo);
lSave = true;
}
return(lSave);
}
private bool SaveCN()
{
bool IsSave = false;
CNNote inv = new CNNote();
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
if (!Utility.IsValidDateString(trxdate.Text))
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show();
return(IsSave);
}
DateTime invdate = Utility.ConvertToDate(trxdate.Text);
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_custname);
TextView cninvno = FindViewById <TextView> (Resource.Id.newcninv_no);
if (spinner.SelectedItem == null)
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show();
spinner.RequestFocus();
return(IsSave);
}
string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' });
if (codes.Length == 0)
{
return(IsSave);
}
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
cnInfo.invdate = invdate;
cnInfo.created = DateTime.Now;
cnInfo.description = codes [1].Trim();
cnInfo.custcode = codes [0].Trim();
cnInfo.invno = cninvno.Text;
cnInfo.remark = remark.Text.ToUpper();
cnInfo.trxtype = "";
if (!string.IsNullOrEmpty(cnInfo.invno))
{
Invoice invInfo = DataHelper.GetInvoice(pathToDatabase, cnInfo.invno);
if (invInfo != null)
{
cnInfo.trxtype = invInfo.trxtype;
}
}
db.Update(cnInfo);
IsSave = true;
}
return(IsSave);
}
private bool SaveDO()
{
bool lSave = false;
DelOrder dorder = new DelOrder();
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
if (!Utility.IsValidDateString(trxdate.Text))
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show();
return(lSave);
}
DateTime dodate = Utility.ConvertToDate(trxdate.Text);
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
Spinner spinner2 = FindViewById <Spinner> (Resource.Id.newinv_type);
TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_custname);
if (spinner.SelectedItem == null)
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show();
spinner.RequestFocus();
return(lSave);
}
string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' });
if (codes.Length == 0)
{
return(lSave);
}
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
doInfo.dodate = dodate;
doInfo.description = codes [1].Trim();
doInfo.remark = remark.Text;
doInfo.term = spinner2.SelectedItem.ToString();
doInfo.amount = 0;
doInfo.custcode = codes [0].Trim();
db.Update(doInfo);
lSave = true;
}
return(lSave);
}
private void LoadData()
{
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
DateTime invdate = Utility.ConvertToDate(trxdate.Text);
DateTime tmr = invdate.AddDays(1);
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
Spinner spinner2 = FindViewById <Spinner> (Resource.Id.newinv_type);
TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_custname);
trxdate.Text = doInfo.dodate.ToString("dd-MM-yyyy");
int pos1 = dataAdapter.GetPosition(doInfo.custcode + " | " + doInfo.description);
int pos2 = dataAdapter2.GetPosition(doInfo.trxtype);
spinner.SetSelection(pos1);
spinner2.SetSelection(pos2);
remark.Text = doInfo.remark;
txtinvno.Text = doInfo.dono;
}
private void LoadData()
{
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
DateTime invdate = Utility.ConvertToDate(trxdate.Text);
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_custname);
TextView cninvno = FindViewById <TextView> (Resource.Id.newcninv_no);
TextView cnno = FindViewById <TextView> (Resource.Id.newinv_no);
trxdate.Text = cnInfo.invdate.ToString("dd-MM-yyyy");
int pos1 = dataAdapter.GetPosition(cnInfo.custcode + " | " + cnInfo.description);
spinner.SetSelection(pos1);
remark.Text = cnInfo.remark;
cninvno.Text = cnInfo.invno;
cnno.Text = cnInfo.cnno;
if (!string.IsNullOrEmpty(cnInfo.invno))
{
spinner.Enabled = false;
Button butFind = FindViewById <Button> (Resource.Id.newinv_bfind);
butFind.Enabled = false;
}
}
void ButPrint_Click(object sender, EventArgs e)
{
EditText frd = FindViewById <EditText> (Resource.Id.trxdatefr);
EditText tod = FindViewById <EditText> (Resource.Id.trxdateto);
DateTime?sdate = null;
DateTime?edate = null;
if (frd.Text != "")
{
sdate = Utility.ConvertToDate(frd.Text);
}
else
{
sdate = DateTime.Today;
}
// if (tod.Text != "") {
// edate =Utility.ConvertToDate (tod.Text);
// }
// if (edate == null)
// edate = sdate;
PrintInvSumm(sdate.Value, sdate.Value);
}
private void CreateNewDO()
{
DelOrder dorder = new DelOrder();
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
if (!Utility.IsValidDateString(trxdate.Text))
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show();
return;
}
DateTime dodate = Utility.ConvertToDate(trxdate.Text);
DateTime tmr = dodate.AddDays(1);
AdNumDate adNum = DataHelper.GetNumDate(pathToDatabase, dodate, "DO");
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
Spinner spinner2 = FindViewById <Spinner> (Resource.Id.newinv_type);
TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_custname);
//EditText custpo = FindViewById<EditText> (Resource.Id.newinv_po);
//EditText remark = FindViewById<EditText> (Resource.Id.newinv_remark);
string prefix = apara.DOPrefix.Trim().ToUpper();
if (spinner.SelectedItem == null)
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show();
spinner.RequestFocus();
return;
}
string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' });
if (codes.Length == 0)
{
return;
}
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
string dono = "";
int runno = adNum.RunNo + 1;
int currentRunNo = DataHelper.GetLastDORunNo(pathToDatabase, dodate);
if (currentRunNo >= runno)
{
runno = currentRunNo + 1;
}
dono = prefix + dodate.ToString("yyMM") + runno.ToString().PadLeft(4, '0');
txtinvno.Text = dono;
dorder.dodate = dodate;
dorder.trxtype = "DO";
dorder.created = DateTime.Now;
dorder.dono = dono;
dorder.description = codes [1].Trim();
dorder.remark = remark.Text;
dorder.term = spinner2.SelectedItem.ToString();
dorder.amount = 0;
dorder.custcode = codes [0].Trim();
dorder.isUploaded = false;
txtinvno.Text = dono;
db.Insert(dorder);
adNum.RunNo = runno;
if (adNum.ID >= 0)
{
db.Update(adNum);
}
else
{
db.Insert(adNum);
}
}
ShowItemEntry(dorder, codes);
}
void LoadData()
{
ItemStock stk;
DateTime date = Utility.ConvertToDate(TRXDATE);
using (var db = new SQLite.SQLiteConnection(pathToDatabase))
{
var list = db.Table <ItemStock> ().Where(x => x.ICode == ICODE && x.DateTrx == date).ToList();
if (list.Count > 0)
{
txtIDesc.Text = list [0].IDesc;
txtICode.Text = list [0].ICode;
txtDate.Text = TRXDATE;
if (list [0].QtyAct > 0)
{
qtyAct.Text = list [0].QtyAct.ToString();
}
else
{
qtyAct.Text = "";
}
qtyGr.Text = list [0].QtyGR.ToString();
if (list [0].QtyRtr > 0)
{
qtyRtn.Text = list [0].QtyRtr.ToString();
}
else
{
qtyRtn.Text = "";
}
if (list [0].QtyCrf > 0)
{
qtyCrf.Text = list [0].QtyCrf.ToString();
}
else
{
qtyCrf.Text = "";
}
if (list [0].QtyBrf > 0)
{
qtyBrf.Text = list [0].QtyBrf.ToString();
}
else
{
qtyBrf.Text = "";
}
if (list [0].QtyBal > 0)
{
qtySales.Text = list [0].QtyBal.ToString();
}
else
{
qtySales.Text = "";
}
}
// var listinv =db.Table<Invoice> ().Where (x =>x.invdate == date).ToList();
// var list2 = db.Table<InvoiceDtls> ().ToList<InvoiceDtls> ();
//
// double ttlsales = 0;
// foreach (Invoice inv in listinv) {
// ttlsales = ttlsales + list2.Where (x => x.invno == inv.invno && x.icode == ICODE).Sum (x => x.qty);
// }
//
// qtySales.Text = ttlsales.ToString ();
}
}
private void CreateNewCN()
{
CNNote inv = new CNNote ();
EditText trxdate = FindViewById<EditText> (Resource.Id.newinv_date);
if (!Utility.IsValidDateString (trxdate.Text)) {
Toast.MakeText (this,Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show ();
return;
}
DateTime invdate = Utility.ConvertToDate (trxdate.Text);
DateTime tmr = invdate.AddDays (1);
AdNumDate adNum= DataHelper.GetNumDate (pathToDatabase, invdate,"CN");
Spinner spinner = FindViewById<Spinner> (Resource.Id.newinv_custcode);
TextView txtinvno =FindViewById<TextView> (Resource.Id.newinv_no);
EditText remark = FindViewById<EditText> (Resource.Id.newinv_custname);
TextView cninvno = FindViewById<TextView> (Resource.Id.newcninv_no);
string prefix = apara.CNPrefix.Trim ().ToUpper ();
if (spinner.SelectedItem == null) {
Toast.MakeText (this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show ();
spinner.RequestFocus ();
return;
}
string[] codes = spinner.SelectedItem.ToString().Split (new char[]{ '|' });
if (codes.Length == 0)
return;
Invoice invInfo = DataHelper.GetInvoice (pathToDatabase, cninvno.Text);
using (var db = new SQLite.SQLiteConnection (pathToDatabase)) {
string invno = "";
int runno = adNum.RunNo + 1;
int currentRunNo =DataHelper.GetLastCNRunNo (pathToDatabase, invdate);
if (currentRunNo >= runno)
runno = currentRunNo + 1;
if (invInfo != null) {
//string[] prefixs = apara.Prefix.Trim ().ToUpper ().Split(new char[]{'|'});
if (invInfo.trxtype == "CASH") {
invno =prefix+ invdate.ToString ("yyMM") + runno.ToString ().PadLeft (4, '0')+"(CS)";
}else invno =prefix+ invdate.ToString ("yyMM") + runno.ToString ().PadLeft (4, '0')+"(INV)";
}else invno =prefix + invdate.ToString("yyMM") + runno.ToString().PadLeft (4, '0')+"(INV)";;
txtinvno.Text= invno;
inv.invdate = invdate;
inv.trxtype = "";
inv.created = DateTime.Now;
inv.cnno = invno;
inv.description = codes [1].Trim ();
inv.amount = 0;
inv.custcode = codes [0].Trim ();
inv.isUploaded = false;
inv.remark = remark.Text.ToUpper();
inv.invno = cninvno.Text;
if (invInfo != null) {
inv.trxtype = invInfo.trxtype;
} else {
Trader trd= DataHelper.GetTrader (pathToDatabase, inv.custcode);
if (trd != null) {
string paycode =trd.PayCode.ToUpper ().Trim ();
inv.trxtype = paycode;
if (paycode.Contains ("CASH") || paycode.Contains ("COD")) {
inv.trxtype = "CASH";
}
}
}
db.Insert (inv);
adNum.RunNo = runno;
if (adNum.ID >= 0)
db.Update (adNum);
else
db.Insert (adNum);
}
ShowItemEntry (inv, codes);
}
private void CreateNewInvoice()
{
Invoice inv = new Invoice();
EditText trxdate = FindViewById <EditText> (Resource.Id.newinv_date);
if (!Utility.IsValidDateString(trxdate.Text))
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invaliddate), ToastLength.Long).Show();
return;
}
DateTime invdate = Utility.ConvertToDate(trxdate.Text);
DateTime tmr = invdate.AddDays(1);
AdNumDate adNum; // = DataHelper.GetNumDate (pathToDatabase, invdate);
Spinner spinner = FindViewById <Spinner> (Resource.Id.newinv_custcode);
Spinner spinner2 = FindViewById <Spinner> (Resource.Id.newinv_type);
TextView txtinvno = FindViewById <TextView> (Resource.Id.newinv_no);
EditText remark = FindViewById <EditText> (Resource.Id.newinv_remark);
EditText custname = FindViewById <EditText> (Resource.Id.newinv_custname);
string[] prefixs = apara.Prefix.Trim().ToUpper().Split(new char[] { '|' });
string prefix = "";
string trxtype = spinner2.SelectedItem.ToString();
// if (trxtype == "CASH") {
// adNum = DataHelper.GetNumDate (pathToDatabase, invdate, "CS");
// if (prefixs.Length > 1) {
// prefix = prefixs [1];
// }else prefix = prefixs [0];
// } else {
adNum = DataHelper.GetNumDate(pathToDatabase, invdate, "INV");
prefix = prefixs [0];
//}
if (spinner.SelectedItem == null)
{
Toast.MakeText(this, Resources.GetString(Resource.String.msg_invalidcust), ToastLength.Long).Show();
spinner.RequestFocus();
return;
}
string[] codes = spinner.SelectedItem.ToString().Split(new char[] { '|' });
if (codes.Length == 0)
{
return;
}
using (var db = new SQLite.SQLiteConnection(pathToDatabase)) {
string invno = "";
int runno = adNum.RunNo + 1;
int currentRunNo = DataHelper.GetLastInvRunNo(pathToDatabase, invdate, spinner2.SelectedItem.ToString());
if (currentRunNo >= runno)
{
runno = currentRunNo + 1;
}
invno = prefix + invdate.ToString("yyMM") + runno.ToString().PadLeft(4, '0');
txtinvno.Text = invno;
inv.invdate = invdate;
inv.trxtype = "INVOICE"; //spinner2.SelectedItem.ToString ();
inv.created = DateTime.Now;
inv.invno = invno;
inv.description = codes [1].Trim(); //custname.Text;
inv.amount = 0;
inv.custcode = codes [0].Trim();
inv.isUploaded = false;
inv.remark = remark.Text.ToUpper();
if (codes [0].Trim() == "COD" || codes [0].Trim() == "CASH")
{
inv.description = custname.Text.ToUpper();
}
txtinvno.Text = invno;
db.Insert(inv);
adNum.RunNo = runno;
if (adNum.ID >= 0)
{
db.Update(adNum);
}
else
{
db.Insert(adNum);
}
}
ShowItemEntry(inv, codes);
}
