public int Post(Models.POS.ModelPOSTransCreate mPOS)
        {
            Models.POS.DataPOSTransCreateTableAdapters.OLPL_Apps_POS_TransTableAdapter tbConnection = new Models.POS.DataPOSTransCreateTableAdapters.OLPL_Apps_POS_TransTableAdapter();
            DataPOSTransCreate.OLPL_Apps_POS_TransDataTable tbResults = new DataPOSTransCreate.OLPL_Apps_POS_TransDataTable();
            tbConnection.Fill(tbResults);
            int transID = int.Parse(tbResults.Rows[0].ItemArray[0].ToString())+1;

            tbConnection.InsertQuery(transID, mPOS.compName, mPOS.operatorID.ToUpper(), mPOS.userID, DateTime.Now, mPOS.stationType,mPOS.strData);
            return transID;
        }
        public string Get()
        {
            string ret1 = "";
            bool test = true;
            Models.POS.DataPOSTransCreateTableAdapters.OLPL_Apps_POS_TransTableAdapter tbConnection = new Models.POS.DataPOSTransCreateTableAdapters.OLPL_Apps_POS_TransTableAdapter();
            DataPOSTransCreate.OLPL_Apps_POS_TransDataTable tbResults = new DataPOSTransCreate.OLPL_Apps_POS_TransDataTable();
            tbConnection.FillBy(tbResults);
            foreach(Models.POS.DataPOSTransCreate.OLPL_Apps_POS_TransRow row in tbResults)
            {
                if (test)
                {
                    test = true;
                    if (!row.strData.Contains("Operator ID"))
                    {
                        modelPOS mPOS = new modelPOS();
                        mPOS.stationType = "Workstation";
                        #region NonCashManagementTrans
                        string[] stringSeparators = new string[] { "Original bi" };

                        string[] dataStr1 = row.strData.Split(stringSeparators, StringSplitOptions.None);
                        mPOS.transID = row.transID;
                        foreach (string str1 in dataStr1)
                        {
                            if (str1.Contains("Payment date:"))
                            {
                                string[] intStr = str1.Split('|');
                                foreach (string str2 in intStr)
                                {
                                    //MessageBox.Show(str.Replace("Payment date: ", ""));
                                    if (str2.Contains("Payment date:")) { mPOS.paymentDate = DateTime.Parse(str2.Replace("Payment date: ", "")); }
                                }
                            }
                            else
                            {
                                modelPOS mPOS1 = mPOS;
                                mPOS1.transType = "Sale";
                                mPOS1.quantity = 1;
                                bool nextLine = false;
                                bool change = false;
                                bool exceptionData = false;
                                string[] intStr = str1.Split('|');
                                if (row.strData.Contains("Remaining balance:")) { exceptionData = true; }
                                //MessageBox.Show(exceptionData.ToString());
                                foreach (string str2 in intStr)
                                {
                                    if (str2.Contains("ll: $")) { mPOS1.totalBill = Decimal.Parse(str2.Replace("ll: $", "")); }
                                    if (str2.Contains("Author:")) { mPOS1.author = str2.Replace("Author: ", ""); }
                                    if (str2.Contains("Change:")) { mPOS1.change = Decimal.Parse(str2.Replace("Change: $", "")); change = true; }
                                    if (str2.Contains("Call number:")) { mPOS1.callnumber = str2.Replace("Call number: ", ""); }
                                    if (str2.Contains("Title:")) { mPOS1.title = str2.Replace("Title: ", ""); }
                                    if (str2.Contains("Item ID:")) { mPOS1.itemID = str2.Replace("Item ID: ", ""); }
                                    if (nextLine && !String.IsNullOrEmpty(str2) && !exceptionData)
                                    {
                                        string[] intStr1 = str2.Split(' ');
                                        mPOS1.type = intStr1[0];
                                        mPOS1.amtCol = Decimal.Parse(intStr1[1]);
                                        nextLine = false;
                                    }
                                    if (str2.Contains("Payment status:")) { mPOS1.status = str2.Replace("Payment status: ", ""); nextLine = true; }
                                    if (!change) { mPOS1.change = Decimal.Parse("0.00"); }
                                    if (str2.Contains("Bill reason:")) { mPOS1.reason = str2.Replace("Bill reason: ", ""); }
                                    if (str2.Contains("Original tax:")) { mPOS1.tax = Decimal.Parse(str2.Replace("Original tax: $", "")); }
                                    if (exceptionData && str2.Contains("Payment type:")) { mPOS1.type = (str2.Replace("Payment type: ", "")); }
                                    if (exceptionData && str2.Contains("Amount paid:")) { mPOS1.amtCol = Decimal.Parse(str2.Replace("Amount paid: $", "")); }
                                }
                                mPOS1.amtDrawer = mPOS1.amtCol - mPOS1.change;
                                controlPOS.postItemType(mPOS1);
                                controlPOS.postPayment(mPOS1);
                                controlPOS.closeTrans(mPOS);
                            }
                        }
                        #endregion
                    }
                    else
                    {

                    }
                }

            }
            return ret1;
        }