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