Пример #1
0
        public decimal GetExchangeRate(string currencyCode)
        {
            int     officeId     = CurrentSession.GetOfficeId();
            decimal exchangeRate = Transaction.GetExchangeRate(officeId, currencyCode);

            return(exchangeRate);
        }
Пример #2
0
        public long Save(long tranId, DateTime valueDate, int storeId, string partyCode, int priceTypeId, string referenceNumber, string data, string statementReference, string attachmentsJSON)
        {
            if (!StockTransaction.IsValidStockTransactionByTransactionMasterId(tranId))
            {
                throw new InvalidOperationException(Resources.Warnings.InvalidStockTransaction);
            }

            if (!StockTransaction.IsValidPartyByTransactionMasterId(tranId, partyCode))
            {
                throw new InvalidOperationException(Resources.Warnings.InvalidParty);
            }

            Collection <StockDetail> details = CollectionHelper.GetStockMasterDetailCollection(data, storeId);

            if (!this.ValidateDetails(details, tranId))
            {
                return(0);
            }

            Collection <Attachment> attachments = CollectionHelper.GetAttachmentCollection(attachmentsJSON);

            int  officeId = CurrentSession.GetOfficeId();
            int  userId   = CurrentSession.GetUserId();
            long loginId  = CurrentSession.GetLogOnId();

            return(Data.Transactions.Return.PostTransaction(tranId, valueDate, officeId, userId, loginId, storeId, partyCode, priceTypeId, referenceNumber, statementReference, details, attachments));
        }
Пример #3
0
        public override void OnControlLoad(object sender, EventArgs e)
        {
            string   accountNumber = this.Page.Request["AccountNumber"];
            DateTime from          = Conversion.TryCastDate(this.Page.Request["From"]);
            DateTime to            = Conversion.TryCastDate(this.Page.Request["To"]);

            int userId   = CurrentSession.GetUserId();
            int officeId = CurrentSession.GetOfficeId();


            Collection <KeyValuePair <string, object> > parameter1 = new Collection <KeyValuePair <string, object> >();

            parameter1.Add(new KeyValuePair <string, object>("@OfficeId", officeId.ToString(CultureInfo.InvariantCulture)));
            parameter1.Add(new KeyValuePair <string, object>("@AccountNumber", accountNumber));

            Collection <KeyValuePair <string, object> > parameter2 = new Collection <KeyValuePair <string, object> >();

            parameter2.Add(new KeyValuePair <string, object>("@From", from));
            parameter2.Add(new KeyValuePair <string, object>("@To", to));
            parameter2.Add(new KeyValuePair <string, object>("@UserId", userId.ToString(CultureInfo.InvariantCulture)));
            parameter2.Add(new KeyValuePair <string, object>("@AccountNumber", accountNumber));
            parameter2.Add(new KeyValuePair <string, object>("@OfficeId", officeId.ToString(CultureInfo.InvariantCulture)));

            using (Report report = new Report())
            {
                report.AddParameterToCollection(parameter1);
                report.AddParameterToCollection(parameter2);
                report.RunningTotalText = Titles.RunningTotal;
                report.ResourceAssembly = Assembly.GetAssembly(typeof(GLAdviceReport));
                report.Path             = "~/Modules/Finance/Reports/Source/Transactions.AccountStatement.xml";
                report.AutoInitialize   = true;

                this.Placeholder1.Controls.Add(report);
            }
        }
Пример #4
0
        private static ApplicationDateModel GetApplicationDates()
        {
            int officeId = CurrentSession.GetOfficeId();
            Collection <ApplicationDateModel> applicationDates = ApplicationStateHelper.GetApplicationDates();
            bool persist = false;

            if (applicationDates == null || applicationDates.Count.Equals(0))
            {
                applicationDates = Data.Frequency.GetApplicationDates();
                persist          = true;
            }
            else
            {
                for (int i = 0; i < applicationDates.Count; i++)
                {
                    if (applicationDates[i].NewDayStarted)
                    {
                        int modelOfficeId = applicationDates[i].OfficeId;

                        applicationDates.Remove(applicationDates[i]);
                        applicationDates.Add(Data.Frequency.GetApplicationDates(modelOfficeId));
                        persist = true;
                    }
                }
            }

            if (persist)
            {
                ApplicationStateHelper.SetApplicationDates(applicationDates);
            }

            return(applicationDates.FirstOrDefault(c => c.OfficeId.Equals(officeId)));
        }
Пример #5
0
        public static IEnumerable <Entities.Core.Menu> GetRootMenuCollection(string path)
        {
            int    userId   = CurrentSession.GetUserId();
            int    officeId = CurrentSession.GetOfficeId();
            string culture  = CurrentSession.GetCulture().TwoLetterISOLanguageName;

            return(Factory.Get <Entities.Core.Menu>("SELECT * FROM policy.get_menu(@0, @1, @2) WHERE parent_menu_id=core.get_root_parent_menu_id(@3) ORDER BY menu_id;", userId, officeId, culture, path));
        }
Пример #6
0
        public void Reject(long tranId, string reason)
        {
            int       officeId             = CurrentSession.GetOfficeId();
            int       userId               = CurrentSession.GetUserId();
            long      loginId              = CurrentSession.GetLogOnId();
            const int verificationStatusId = -3;

            Transaction.Verify(tranId, officeId, userId, loginId, verificationStatusId, reason);
        }
        public override void OnControlLoad(object sender, EventArgs e)
        {
            int officeId = CurrentSession.GetOfficeId();

            this.TitleLiteral.Text = Resources.Titles.SalesByMonthInThousands;

            //this.SalesByMonthGridView.Attributes.Add("style", "display:none;");
            this.SalesByMonthGridView.DataSource = Data.Reports.SalesByMonth.GetSalesByOffice(officeId);
            this.SalesByMonthGridView.DataBind();
        }
Пример #8
0
        public static IEnumerable <Entities.Core.Menu> GetMenuCollection(string path, short level)
        {
            string relativePath = path;
            int    userId       = CurrentSession.GetUserId();
            int    officeId     = CurrentSession.GetOfficeId();
            string culture      = CurrentSession.GetCulture().TwoLetterISOLanguageName;


            return(Factory.Get <Entities.Core.Menu>("SELECT * FROM policy.get_menu(@0, @1, @2) WHERE parent_menu_id=(SELECT menu_id FROM core.menus WHERE url=@3) AND level=@4 ORDER BY menu_id;", userId, officeId, culture, relativePath, level));
        }
        private long PostTransaction(string partyCode, string currencyCode, decimal amount, decimal debitExchangeRate, decimal creditExchangeRate, string referenceNumber, string statementReference, int costCenterId, int cashRepositoryId, DateTime?postedDate, int bankAccountId, string bankInstrumentCode, string bankTransactionCode)
        {
            int  userId   = CurrentSession.GetUserId();
            int  officeId = CurrentSession.GetOfficeId();
            long loginId  = CurrentSession.GetLogOnId();

            long transactionMasterID = Data.Transactions.Receipt.PostTransaction(userId, officeId, loginId, partyCode, currencyCode, amount, debitExchangeRate, creditExchangeRate, referenceNumber, statementReference, costCenterId, cashRepositoryId, postedDate, bankAccountId, bankInstrumentCode, bankTransactionCode);

            return(transactionMasterID);
        }
Пример #10
0
        public static long Add(string book, DateTime valueDate, string partyCode, int priceTypeId, Collection <StockDetail> details, string referenceNumber, string statementReference, Collection <long> transactionIdCollection, Collection <Attachment> attachments)
        {
            StockMaster stockMaster = new StockMaster();

            stockMaster.PartyCode   = partyCode;
            stockMaster.PriceTypeId = priceTypeId;

            long nonGlStockMasterId = NonGlStockTransaction.Add(book, valueDate, CurrentSession.GetOfficeId(), CurrentSession.GetUserId(), CurrentSession.GetLogOnId(), referenceNumber, statementReference, stockMaster, details, transactionIdCollection, attachments);

            return(nonGlStockMasterId);
        }
        private void BindGrid()
        {
            DateTime date     = Conversion.TryCastDate(this.dateTextBox.Text);
            int      factor   = Conversion.TryCastInteger(this.factorInputText.Value);
            int      officeId = CurrentSession.GetOfficeId();

            using (DataTable table = Data.Reports.RetainedEarnings.GetRetainedEarningStatementDataTable(date, officeId, factor))
            {
                this.grid.DataSource = table;
                this.grid.DataBind();
            }
        }
Пример #12
0
        public Collection <ListItem> GetCashRepositories()
        {
            Collection <ListItem> values = new Collection <ListItem>();

            int officeId = CurrentSession.GetOfficeId();

            foreach (CashRepository cashRepository in CashRepositories.GetCashRepositories(officeId))
            {
                values.Add(new ListItem(cashRepository.CashRepositoryName, cashRepository.CashRepositoryId.ToString(CultureInfo.InvariantCulture)));
            }
            return(values);
        }
Пример #13
0
        private void BindGrid()
        {
            DateTime from   = Conversion.TryCastDate(this.fromDateTextBox.Text);
            DateTime to     = Conversion.TryCastDate(this.toDateTextBox.Text);
            decimal  factor = Conversion.TryCastDecimal(this.factorInputText.Value);

            int userId   = CurrentSession.GetUserId();
            int officeId = CurrentSession.GetOfficeId();

            this.cashflowStatementGridView.DataSource = Data.Reports.CashFlow.GetDirectCashFlowStatement(from, to, userId, officeId, factor);
            this.cashflowStatementGridView.DataBind();
        }
Пример #14
0
        private void BindGridView()
        {
            DateTime from          = Conversion.TryCastDate(this.fromDateTextBox.Text);
            DateTime to            = Conversion.TryCastDate(this.toDateTextBox.Text);
            int      userId        = CurrentSession.GetUserId();
            string   accountNumber = this.accountNumberInputText.Value;
            int      officeId      = CurrentSession.GetOfficeId();

            this.statementGridView.DataSource = Data.Reports.AccountStatement.GetAccountStatement(from, to, userId, accountNumber, officeId);
            this.statementGridView.DataBound += this.StatementGridViewDataBound;
            this.statementGridView.DataBind();
        }
Пример #15
0
        public Collection <ListItem> GetSalesTaxes(string tranBook)
        {
            int officeId = CurrentSession.GetOfficeId();

            Collection <ListItem> values = new Collection <ListItem>();

            foreach (Net.Entities.Core.SalesTax salesTax in SalesTax.GetSalesTaxes(tranBook, officeId))
            {
                values.Add(new ListItem(salesTax.SalesTaxCode, salesTax.SalesTaxId.ToString(CultureInfo.InvariantCulture)));
            }

            return(values);
        }
Пример #16
0
        public bool Save(Collection <Data.Models.Reorder> details)
        {
            if (details == null)
            {
                throw new ArgumentNullException("details");
            }

            long loginId  = CurrentSession.GetLogOnId();
            int  userId   = CurrentSession.GetUserId();
            int  officeId = CurrentSession.GetOfficeId();

            return(Data.Transactions.Reorder.Save(loginId, userId, officeId, details));
        }
Пример #17
0
        public static IEnumerable <Entities.Core.Menu> GetMenuCollection(int parentMenuId, short level)
        {
            int    userId   = CurrentSession.GetUserId();
            int    officeId = CurrentSession.GetOfficeId();
            string culture  = CurrentSession.GetCulture().TwoLetterISOLanguageName;

            if (parentMenuId > 0)
            {
                return(Factory.Get <Entities.Core.Menu>("SELECT * FROM policy.get_menu(@0, @1, @2) WHERE parent_menu_id=@3 AND level=@4 ORDER BY menu_id;", userId, officeId, culture, parentMenuId, level));
            }

            return(Factory.Get <Entities.Core.Menu>("SELECT * FROM policy.get_menu(@0, @1, @2) WHERE parent_menu_id is null ORDER BY menu_id;", userId, officeId, culture));
        }
        public override void OnControlLoad(object sender, EventArgs e)
        {
            this.CreateHeader(this.Placeholder1);

            if (Data.OpeningInventory.Exists(CurrentSession.GetOfficeId()))
            {
                this.CreateMessage(this.Placeholder1);
                return;
            }

            this.CreateGridView(this.Placeholder1);
            this.CreateSaveButton(this.Placeholder1);
        }
Пример #19
0
        private void BindGrid()
        {
            DateTime previousTerm = Conversion.TryCastDate(this.previousPeriodDateTextBox.Text);
            DateTime currentTerm  = Conversion.TryCastDate(this.currentPeriodDateTextBox.Text);
            int      factor       = Conversion.TryCastInteger(this.factorInputText.Value);
            int      userId       = CurrentSession.GetUserId();
            int      officeId     = CurrentSession.GetOfficeId();

            using (DataTable table = Data.Reports.BalanceSheet.GetBalanceSheet(previousTerm, currentTerm, userId, officeId, factor))
            {
                this.grid.DataSource = table;
                this.grid.DataBind();
            }
        }
        private void BindGrid()
        {
            DateTime from   = Conversion.TryCastDate(this.fromDateTextBox.Text);
            DateTime to     = Conversion.TryCastDate(this.toDateTextBox.Text);
            decimal  factor = Conversion.TryCastDecimal(this.factorInputText.Value);

            bool compact = this.ShowCompact();

            int userId   = CurrentSession.GetUserId();
            int officeId = CurrentSession.GetOfficeId();

            this.plAccountGridView.DataSource = Data.Reports.ProfitAndLossAccount.GetPLAccount(from, to, userId, officeId, compact, factor);
            this.plAccountGridView.DataBind();
        }
Пример #21
0
        public Collection <ListItem> GetStores()
        {
            int officeId = CurrentSession.GetOfficeId();
            Collection <ListItem> values = new Collection <ListItem>();

            IEnumerable <Store> stores = Stores.GetStores(officeId);

            foreach (Store store in stores)
            {
                values.Add(new ListItem(store.StoreName, store.StoreId.ToString(CultureInfo.InvariantCulture)));
            }

            return(values);
        }
Пример #22
0
        private void AddGridView()
        {
            int officeId = CurrentSession.GetOfficeId();

            using (GridView grid = new GridView())
            {
                grid.GridLines = GridLines.None;
                this.CreateColumns(grid);
                grid.DataSource          = Data.Transactions.Reorder.GetReorderView(officeId);
                grid.ID                  = "ReorderGrid";
                grid.AutoGenerateColumns = false;
                grid.DataBind();
                this.Placeholder1.Controls.Add(grid);
            }
        }
Пример #23
0
        public Collection <ListItem> GetCashRepositoriesByAccountNumber(string accountNumber)
        {
            Collection <ListItem> values = new Collection <ListItem>();

            if (AccountHelper.IsCashAccount(accountNumber))
            {
                int officeId = CurrentSession.GetOfficeId();
                foreach (CashRepository cashRepository in CashRepositories.GetCashRepositories(officeId))
                {
                    values.Add(new ListItem(cashRepository.CashRepositoryName, cashRepository.CashRepositoryCode));
                }
            }

            return(values);
        }
Пример #24
0
        public bool InitializeEODOperation()
        {
            if (!CurrentSession.IsAdmin())
            {
                return(false);
            }

            int userId   = CurrentSession.GetUserId();
            int officeId = CurrentSession.GetOfficeId();

            Data.EODOperation.Initialize(userId, officeId);

            this.ForceLogOff(officeId);

            return(true);
        }
Пример #25
0
        private void SuggestDateReload()
        {
            int officeId = CurrentSession.GetOfficeId();
            Collection <ApplicationDateModel> applicationDates = ApplicationStateHelper.GetApplicationDates();

            if (applicationDates != null)
            {
                ApplicationDateModel model = applicationDates.FirstOrDefault(c => c.OfficeId.Equals(officeId));
                if (model != null)
                {
                    applicationDates.Add(new ApplicationDateModel(model.OfficeId, model.Today, model.MonthStartDate, model.MonthEndDate, model.QuarterStartDate, model.QuarterEndDate, model.FiscalHalfStartDate, model.FiscalHalfEndDate, model.FiscalYearStartDate, model.FiscalYearEndDate, true));
                    applicationDates.Remove(model);

                    ApplicationStateHelper.SetApplicationDates(applicationDates);
                }
            }
        }
Пример #26
0
        public static long Add(DateTime valueDate, int storeId, bool isCredit, int paymentTermId, string partyCode, int agentId, int priceTypeId, Collection <StockDetail> details, int shipperId, string shippingAddressCode, decimal shippingCharge, int costCenterId, string referenceNumber, string statementReference, Collection <Attachment> attachments, bool nonTaxable)
        {
            StockMaster stockMaster = new StockMaster();

            stockMaster.PartyCode           = partyCode;
            stockMaster.IsCredit            = isCredit;
            stockMaster.PaymentTermId       = paymentTermId;
            stockMaster.PriceTypeId         = priceTypeId;
            stockMaster.ShipperId           = shipperId;
            stockMaster.ShippingAddressCode = shippingAddressCode;
            stockMaster.ShippingCharge      = shippingCharge;
            stockMaster.SalespersonId       = agentId;
            stockMaster.StoreId             = storeId;

            long transactionMasterId = GlTransaction.Add("Sales.Direct", valueDate, CurrentSession.GetOfficeId(), CurrentSession.GetUserId(), CurrentSession.GetLogOnId(), costCenterId, referenceNumber, statementReference, stockMaster, details, attachments, nonTaxable);

            return(transactionMasterId);
        }
Пример #27
0
        private void BindGrid()
        {
            DateTime from   = Conversion.TryCastDate(this.fromDateTextBox.Text);
            DateTime to     = Conversion.TryCastDate(this.toDateTextBox.Text);
            decimal  factor = Conversion.TryCastDecimal(this.factorInputText.Value);

            bool compact    = this.ShowCompact();
            bool changeSide = this.ChangeSideWhenNegative();
            bool includeZeroBalanceAccounts = this.IncludeZeroBalanceAccounts();

            int userId   = CurrentSession.GetUserId();
            int officeId = CurrentSession.GetOfficeId();

            using (DataTable table = Data.Reports.TrialBalance.GetTrialBalance(from, to, userId, officeId, compact, factor, changeSide, includeZeroBalanceAccounts))
            {
                this.trialBalanceGridView.DataSource = table;
                this.trialBalanceGridView.DataBind();
            }
        }
Пример #28
0
        private void ForceLogOff()
        {
            int officeId = CurrentSession.GetOfficeId();
            Collection <ApplicationDateModel> applicationDates = ApplicationStateHelper.GetApplicationDates();

            if (applicationDates != null)
            {
                ApplicationDateModel model = applicationDates.FirstOrDefault(c => c.OfficeId.Equals(officeId));
                if (model != null)
                {
                    if (model.ForcedLogOffTimestamp != null)
                    {
                        if (model.ForcedLogOffTimestamp <= DateTime.Now && model.ForcedLogOffTimestamp >= CurrentSession.GetSignInTimestamp())
                        {
                            RequestLogOnPage();
                        }
                    }
                }
            }
        }
Пример #29
0
        private new void Initialize()
        {
            int officeId = CurrentSession.GetOfficeId();

            EODStatus status = Data.EODOperation.GetStatus(officeId);

            if (status != null)
            {
                this.ValueDateLiteral.Text = @"(" + status.ValueDate.ToShortDateString() + @")";

                if (status.Initialized)
                {
                    this.InitializeButton.Attributes.Add("class", "ui blue disabled button");
                    this.PerformEODButton.Attributes.Add("class", "ui red button");
                    return;
                }

                this.InitializeButton.Attributes.Add("class", "ui blue button");
                this.PerformEODButton.Attributes.Add("class", "ui red disabled button");
            }
        }
Пример #30
0
        public long Save(DateTime valueDate, string referenceNumber, string statementReference, List <StockAdjustmentDetail> models)
        {
            foreach (var model in models)
            {
                if (model.TransferType == TransactionType.Credit)
                {
                    decimal existingQuantity = Data.Helpers.Items.CountItemInStock(model.ItemCode, model.UnitName, model.StoreName);

                    if (existingQuantity < model.Quantity)
                    {
                        throw new MixERPException(string.Format(CultureInfo.CurrentCulture, Errors.InsufficientStockWarning, Conversion.TryCastInteger(existingQuantity), model.UnitName, model.ItemName));
                    }
                }
            }

            int  officeId = CurrentSession.GetOfficeId();
            int  userId   = CurrentSession.GetUserId();
            long loginId  = CurrentSession.GetLogOnId();

            return(Data.Transactions.StockAdjustment.Add(officeId, userId, loginId, valueDate, referenceNumber, statementReference, models.ToCollection()));
        }