private void InsertOrUpdateTransection(string tranid, string date, string no, string totalamount, string drledgerid, string crledgerid, string transectiontype, string Mode, string BankName, string ChequeNo, string ChequeDate)
        {
            string transectionid = tranid;

            if (mReceiptNoForEdit.ISNullOrWhiteSpace())
            {
                mquery = "Insert into Transection(TransectionID, Date, No, TransectionType, LedgerIdFrom, " +
                         "LedgerIdTo, Amount_Dr,Mode,BankName, ChequeNo, ChequeDate) values('" + transectionid + "','" +
                         date + "','" + no + "','" + transectiontype + "','" + drledgerid + "','" +
                         crledgerid + "'," + totalamount + "," + Mode + "," + BankName
                         + "," + ChequeNo + "," + ChequeDate + ")";
                mlistquery.Add(mquery);
                transectionid = Guid.NewGuid().ToString();
                mquery        = "Insert into Transection(TransectionID, Date, No, TransectionType, LedgerIdFrom, " +
                                "LedgerIdTo, Amount_Cr,Mode,BankName, ChequeNo, ChequeDate) values('" + transectionid + "','" +
                                date + "','" + no + "','" + transectiontype + "','" + crledgerid + "','" +
                                drledgerid + "'," + totalamount + "," + Mode + "," + BankName
                                + "," + ChequeNo + "," + ChequeDate + ")";
                mlistquery.Add(mquery);
            }
            else
            {
                TransectionTools.GetTransectionId(no, transectiontype);

                mquery = "Update Transection Set Date='" + date + "',LedgerIdFrom='" + drledgerid + "', " +
                         "LedgerIdTo='" + crledgerid + "', Amount_Dr=" + totalamount + ",Mode=" + Mode
                         + ",bankname=" + BankName + ",ChequeNo=" + ChequeNo + ",ChequeDate=" + ChequeDate + " where TransectionID='" + TransectionTools._mTransectionIdList[0] + "'";
                mlistquery.Add(mquery);

                mquery = "Update Transection Set Date='" + date + "',LedgerIdFrom='" + crledgerid + "', " +
                         "LedgerIdTo='" + drledgerid + "', Amount_Cr=" + totalamount + ",Mode=" + Mode
                         + ",bankname=" + BankName + ",ChequeNo=" + ChequeNo + ",ChequeDate=" + ChequeDate + " where TransectionID='" + TransectionTools._mTransectionIdList[1] + "'";
                mlistquery.Add(mquery);
            }
        }
        private void InsertOrUpdateTransection(string date, string no, double totalamount, string drledgerid, string crledgerid, string transectiontype, string chequeNo, string chequeDate, string transectionMode, string narration)
        {
            string transectionid = Guid.NewGuid().ToString();
            string query         = "";

            if (mSlNoEdit.ISNullOrWhiteSpace())
            {
                query = "Insert into Transection(TransectionID, Date, No, TransectionType, LedgerIdFrom, " +
                        "LedgerIdTo, Amount_Dr, Mode, ChequeNo, ChequeDate,Narration) values('" + transectionid + "','" +
                        date + "','" + no + "','" + transectiontype + "','" + drledgerid + "','" +
                        crledgerid + "'," + totalamount + ",'" + transectionMode + "','" + chequeNo + "','"
                        + chequeDate + "','" + narration + "')";
                mLstQuery.Add(query);
                transectionid = Guid.NewGuid().ToString();
                query         = "Insert into Transection(TransectionID, Date, No, TransectionType, LedgerIdFrom, " +
                                "LedgerIdTo, Amount_Cr, Mode, ChequeNo, ChequeDate,Narration) values('" + transectionid + "','" +
                                date + "','" + no + "','" + transectiontype + "','" + crledgerid + "','" +
                                drledgerid + "'," + totalamount + ",'" + transectionMode + "','" + chequeNo + "','" +
                                chequeDate + "','" + narration + "')";
                mLstQuery.Add(query);
            }
            else
            {
                TransectionTools.GetTransectionId(mSlNoEdit, transectiontype);
                query = "Update Transection Set Date='" + date + "',LedgerIdFrom='" + drledgerid + "', " +
                        "LedgerIdTo='" + crledgerid + "', Amount_Dr=" + totalamount + ",Mode='" + transectionMode + "',ChequeNo='" + chequeNo
                        + "',ChequeDate='" + chequeDate + "',Narration='" + narration +
                        "' where TransectionID='" + TransectionTools._mTransectionIdList[0] + "'";
                mLstQuery.Add(query);

                query = "Update Transection Set Date='" + date + "',LedgerIdFrom='" + crledgerid + "', " +
                        "LedgerIdTo='" + drledgerid + "', Amount_Cr=" + totalamount + ",Mode='" + transectionMode + "',ChequeNo='" + chequeNo
                        + "',ChequeDate='" + chequeDate + "',Narration='" + narration +
                        "' where TransectionID='" + TransectionTools._mTransectionIdList[1] + "'";
                mLstQuery.Add(query);
            }
        }