Example #1
0
        public dsGeneral.dtPosJournalDataTable GetJournal(dhDBnames objDBNames, dhJournal objJournal)
        {
            dsGeneral ds       = new dsGeneral();
            DataSet   dsreturn = objDatabase.GetDataSet(objDBNames, objJournal, "xmlGetJournal", (DataSet)ds, "dtPosJournal");

            dsGeneral.dtPosJournalDataTable retdt = ((dsGeneral)dsreturn).dtPosJournal;
            return(retdt);
        }
Example #2
0
        public static DataSet InsertUpdateJournal(dhDBnames objDBNames, dhJournal objJournal, dhJournalDetail CRDetail, dhJournalDetail DRDetail)
        {
            try
            {
                DataSet var_ret;

                if (objblJournal == null)
                {
                    objblJournal = new blJournal();
                }
                var_ret = objblJournal.InsertUpdateJournal(objDBNames, objJournal, CRDetail, DRDetail);

                return(var_ret);
            }
            catch (Exception ex) { throw ex; }
        }
Example #3
0
        public DataSet InsertUpdateJournal(dhDBnames objDBNames, dhJournal objJournal, dhJournalDetail CRDetail, dhJournalDetail DRDetail)
        {
            DataSet ds;

            ds = objDALGeneral.InsertUpdateJournal(objDBNames, objJournal);



            if ((ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0))
            {
                int?ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ijournalid"].ToString());;
                //DateTime ddate = (DateTime)(ds.Tables[0].Rows[0]["ddate"]); ;
                if (objJournal.CRList != null)
                {
                    JournalDetailList ItemCollection = objJournal.CRList;
                    foreach (dhJournalDetail item in ItemCollection)
                    {
                        CRDetail.IJournalId       = ID;
                        CRDetail.IAccountID       = item.IAccountID;
                        CRDetail.FAmount          = item.FAmount;
                        CRDetail.IUpdate          = objJournal.IUpdate;
                        CRDetail.VTransactionType = "CR";
                        DataSet dsitem = InsertUpdateJournalDetail(objDBNames, CRDetail);
                    }
                }

                if (objJournal.DrList != null)
                {
                    JournalDetailList ItemCollection = objJournal.DrList;
                    foreach (dhJournalDetail item in ItemCollection)
                    {
                        DRDetail.IJournalId       = ID;
                        DRDetail.IAccountID       = item.IAccountID;
                        DRDetail.FAmount          = item.FAmount;
                        DRDetail.IUpdate          = objJournal.IUpdate;
                        DRDetail.VTransactionType = "DR";
                        DataSet dsitem = InsertUpdateJournalDetail(objDBNames, DRDetail);
                    }
                }
            }
            return(ds);


            //  return ds;
        }
Example #4
0
        //private DataSet InsertUpdateJournalItem(dhDBnames objDBNames, dhJournalDetail item)
        //{
        //    DataSet ds;
        //    ds = objDALGeneral.InsertUpdateJournalItem(objDBNames, item);
        //    return ds;
        //}

        public dsGeneral.dtPosJournalDataTable GetJournal(dhDBnames objDBNames, dhJournal objJournal)
        {
            dsGeneral.dtPosJournalDataTable dt = objDALGeneral.GetJournal(objDBNames, objJournal);
            return(dt);
        }
Example #5
0
        public static dsGeneral.dtPosJournalDataTable GetJournal(dhDBnames objDBNames, dhJournal objJournal)
        {
            try
            {
                dsGeneral.dtPosJournalDataTable var_ret;

                if (objblJournal == null)
                {
                    objblJournal = new blJournal();
                }
                var_ret = objblJournal.GetJournal(objDBNames, objJournal);

                return(var_ret);
            }
            catch (Exception ex) { throw ex; }
        }
Example #6
0
        public DataSet InsertUpdateJournal(dhDBnames objDBNames, dhJournal objJournal)
        {
            DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objJournal, "xmlInsertUpdateJournal");

            return(dsreturn);
        }