//private void CalculateCarriedForwardAmount()
        //{
        //    try
        //    {
        //        Entity.CarriedForwardExpense = Entity.Retailer_Share.GetValueOrDefault() >= 0 ? 0 : Math.Abs(Entity.Retailer_Share.GetValueOrDefault());
        //    }

        //    catch (Exception ex)
        //    {
        //        ExceptionManager.Publish(ex);
        //    }
        //}

        private void FetchLiquidation()
        {
            CommonLiquidationDataContext       objCommonLiquidation = new CommonLiquidationDataContext(CommonUtilities.ExchangeConnectionString);
            List <CommonCollectionLiquidation> details = objCommonLiquidation.GetLiquidationSummary(_BatchNo, null).ToList();

            foreach (var liquiddetail in details)
            {
                if (_entity != null)
                {
                    _entity.Liquidation_Date = liquiddetail.Liquidation_Date;
                    _entity.Retailer_Name    = liquiddetail.Retailer_Name;
                    _entity.Net                             = liquiddetail.Net;
                    _entity.Net_Percentage                  = liquiddetail.Net_Percentage;
                    _entity.Balance_Due                     = liquiddetail.Balance_Due;
                    _entity.Retailer                        = liquiddetail.Retailer;
                    _entity.Retailer_Negative_Net           = liquiddetail.Retailer_Negative_Net;
                    _entity.Tickets_Expected                = liquiddetail.Tickets_Expected;
                    _entity.Tickets_Paid                    = liquiddetail.Tickets_Paid;
                    _entity.Advance_To_Retailer             = liquiddetail.Advance_To_Retailer;
                    _entity.Retailer_Share                  = liquiddetail.Retailer_Share;
                    _entity.RetailerExpenseShareAmount      = liquiddetail.RetailerExpenseShareAmount;
                    _entity.FixedExpenseAmount              = liquiddetail.FixedExpenseAmount;
                    _entity.CarriedForwardExpense           = liquiddetail.CarriedForwardExpense;
                    _entity.PrevCarriedForwardExpense       = liquiddetail.PrevCarriedForwardExpense;
                    _entity.RetailerShareBeforeFixedExpense = liquiddetail.RetailerShareBeforeFixedExpense;
                }
                else
                {
                    _entity = liquiddetail;
                }
            }
        }
Exemplo n.º 2
0
        public CProfitShare(CommonLiquidationEntity entity, int iSiteID, int iBatchNo)
            : this(entity)
        {
            _objCommonLiquidation = entity;
            SiteId = iSiteID;

            string sSettingValue = string.Empty;
            CommonLiquidationDataContext objCommonLiquidation = new CommonLiquidationDataContext(BMC.Business.CashDeskOperator.CommonUtilities.ExchangeConnectionString);

            if (!Settings.ExpenseShare)
            {
                txtblkExpenseShareAmount.Visibility = Visibility.Collapsed;
                txtExpenseShareAmount.Visibility    = Visibility.Collapsed;
                txtblkExpenseShareGroup.Visibility  = Visibility.Collapsed;
                cboExpenseShareGroup.Visibility     = Visibility.Collapsed;
            }

            if (!Settings.WriteOffShare)
            {
                txtblkWriteOffExpense.Visibility = Visibility.Collapsed;
                txtWriteOffExpense.Visibility    = Visibility.Collapsed;
            }

            LoadProfitShareGroup();
            LoadExpenseShareGroup();
            LoadPayPeriods();
            LoadAmounts();
            EnableDisableControls();
        }
 public int CheckLiquidationPerformed(int BatchID, ref int?LiquidationPerformed)
 {
     try
     {
         CommonLiquidationDataContext commonLiquidationDataContext = new CommonLiquidationDataContext(CommonDataAccess.ExchangeConnectionString);
         return(commonLiquidationDataContext.CheckLiquidationPerformed(BatchID, ref LiquidationPerformed));
     }
     catch (Exception ex)
     {
         ExceptionManager.Publish(ex);
         return(0);
     }
 }
 public List <LiquidationDetailForReport> GetLiquidationDetailForReport(int?iBatchId, int?iReadId)
 {
     try
     {
         CommonLiquidationDataContext commonLiquidationDataContext = new CommonLiquidationDataContext(CommonDataAccess.ExchangeConnectionString);
         return(commonLiquidationDataContext.GetLiquidationDetailForReport(iBatchId, iReadId).ToList());
     }
     catch (Exception ex)
     {
         ExceptionManager.Publish(ex);
         return(new List <LiquidationDetailForReport>());
     }
 }
 public List <ReadLiquidationReportRecords> GetReadLiquidationReportRecords(int iNoOfRecords)
 {
     try
     {
         CommonLiquidationDataContext commonLiquidationDataContext = new CommonLiquidationDataContext(CommonDataAccess.ExchangeConnectionString);
         return(commonLiquidationDataContext.GetReadLiquidationReportRecords(null, iNoOfRecords).ToList());
     }
     catch (Exception ex)
     {
         ExceptionManager.Publish(ex);
         return(new List <ReadLiquidationReportRecords>());
     }
 }
 public int CheckLiquidationPerformed(int BatchID,ref int? LiquidationPerformed)
 {
     try
     {
         CommonLiquidationDataContext commonLiquidationDataContext = new CommonLiquidationDataContext(CommonDataAccess.ExchangeConnectionString);
         return commonLiquidationDataContext.CheckLiquidationPerformed(BatchID,ref LiquidationPerformed);
     }
     catch (Exception ex)
     {
         
          ExceptionManager.Publish(ex);
          return 0;
     }
 }
 public List<LiquidationDetailForReport> GetLiquidationDetailForReport(int? iBatchId, int? iReadId)
 {
     try
     {
         CommonLiquidationDataContext commonLiquidationDataContext = new CommonLiquidationDataContext(CommonDataAccess.ExchangeConnectionString);
         return commonLiquidationDataContext.GetLiquidationDetailForReport(iBatchId, iReadId).ToList();
     }
     catch (Exception ex)
     {
         ExceptionManager.Publish(ex);
         return new List<LiquidationDetailForReport>();
     }
 }
 public List<ReadLiquidationReportRecords> GetReadLiquidationReportRecords(int iNoOfRecords)
 {
     try
     {
         CommonLiquidationDataContext commonLiquidationDataContext = new CommonLiquidationDataContext(CommonDataAccess.ExchangeConnectionString);
         return commonLiquidationDataContext.GetReadLiquidationReportRecords(null, iNoOfRecords).ToList();
     }
     catch (Exception ex)
     {
         ExceptionManager.Publish(ex);
         return new List<ReadLiquidationReportRecords>();
     }
 }
        private void btnConfirm_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(txtAdvanceToRetailer.Text))
                {
                    MessageBox.ShowBox("MessageID370", BMC_Icon.Information);
                    return;
                }

                decimal dAdvanceToRetailer = 0.0M;
                if (!CheckForValidAdvanceToRetailValue(out dAdvanceToRetailer))
                {
                    MessageBox.ShowBox("MessageID434", BMC_Icon.Information);
                    return;
                }

                System.Windows.Forms.DialogResult dr = MessageBox.ShowBox("MessageID371", BMC_Icon.Question, BMC_Button.YesNo);

                if (dr.ToString() == "Yes")
                {
                    //Update advance retailer value
                    //UpdateAdvanceRetailer();

                    //Calculate the retailer negative net

                    //CalculateRetailerNegative();
                    //CalculateCarriedForwardAmount();

                    if (Entity.ProfitShareGroupId > 0)
                    {

                        //Sp call for profit share details
                        CommonLiquidationDataContext objCommonLiquidation = new CommonLiquidationDataContext(CommonUtilities.ExchangeConnectionString);
                        int LiquidationProfitShareResult = objCommonLiquidation.PerformLiquidationForProfitShare(null, 
                                                                                                                    _BatchNo, 
                                                                                                                    _entity.ProfitShareGroupId,
                                                                                                                    _entity.ExpenseShareGroupID,
                                                                                                                    _entity.ExpenseShareAmount,
                                                                                                                    _entity.WriteOffAmount,
                                                                                                                    _entity.PayPeriodId,
                                                                                                                    _entity.Gross,
                                                                                                                    _entity.Tickets_Expected,
                                                                                                                    _entity.Net_Percentage,
                                                                                                                    _entity.Retailer_Negative_Net,
                                                                                                                    _entity.Net_Percentage,
                                                                                                                    _entity.Tickets_Paid,
                                                                                                                    _entity.Advance_To_Retailer,
                                                                                                                    _entity.Retailer_Share,
                                                                                                                    _entity.Balance_Due,
                                                                                                                    _entity.Retailer,
                                                                                                                    _entity.RetailerShareBeforeFixedExpense,
                                                                                                                    _entity.CarriedForwardExpense,
                                                                                                                    _entity.RetailerExpenseShareAmount,
                                                                                                                    _entity.FixedExpenseAmount,
                                                                                                                    _entity.PrevCarriedForwardExpense);

                        //Report
                        MessageBox.ShowBox("MessageID488", BMC_Icon.Information);
                        //calling Audit Method
                        Audit(true,_BatchNo);
                        System.Windows.Forms.DialogResult res = MessageBox.ShowBox("MessageID491", BMC_Icon.Question, BMC_Button.YesNo);
                        if (res == System.Windows.Forms.DialogResult.Yes)
                        {
                            using (CReportViewer cReportViewer = new CReportViewer())
                            {
                                LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
                                cReportViewer.ShowLiquidationReportForRead(_BatchNo, null);
                                cReportViewer.ShowDialog();
                            }
                        }
                    }
                    else
                    {
                        MessageBox.ShowBox("MessageID490", BMC_Icon.Information);
                        return;
                    }
                    this.Close();
                }
            }
            catch (Exception ex)
            {
                ExceptionManager.Publish(ex);
            }

        }
        //private void CalculateCarriedForwardAmount()
        //{
        //    try
        //    {
        //        Entity.CarriedForwardExpense = Entity.Retailer_Share.GetValueOrDefault() >= 0 ? 0 : Math.Abs(Entity.Retailer_Share.GetValueOrDefault());
        //    }

        //    catch (Exception ex)
        //    {
        //        ExceptionManager.Publish(ex);
        //    }
        //}

        private void FetchLiquidation()
        {

            CommonLiquidationDataContext objCommonLiquidation = new CommonLiquidationDataContext(CommonUtilities.ExchangeConnectionString);
            List<CommonCollectionLiquidation> details = objCommonLiquidation.GetLiquidationSummary(_BatchNo, null).ToList();

            foreach (var liquiddetail in details)
            {
                if (_entity != null)
                {
                    _entity.Liquidation_Date = liquiddetail.Liquidation_Date;
                    _entity.Retailer_Name = liquiddetail.Retailer_Name;
                    _entity.Net = liquiddetail.Net;
                    _entity.Net_Percentage = liquiddetail.Net_Percentage;
                    _entity.Balance_Due = liquiddetail.Balance_Due;
                    _entity.Retailer = liquiddetail.Retailer;
                    _entity.Retailer_Negative_Net = liquiddetail.Retailer_Negative_Net;
                    _entity.Tickets_Expected = liquiddetail.Tickets_Expected;
                    _entity.Tickets_Paid = liquiddetail.Tickets_Paid;
                    _entity.Advance_To_Retailer = liquiddetail.Advance_To_Retailer;
                    _entity.Retailer_Share = liquiddetail.Retailer_Share;
                    _entity.RetailerExpenseShareAmount = liquiddetail.RetailerExpenseShareAmount;
                    _entity.FixedExpenseAmount = liquiddetail.FixedExpenseAmount;
                    _entity.CarriedForwardExpense = liquiddetail.CarriedForwardExpense;
                    _entity.PrevCarriedForwardExpense = liquiddetail.PrevCarriedForwardExpense;
                    _entity.RetailerShareBeforeFixedExpense = liquiddetail.RetailerShareBeforeFixedExpense;
                }
                else
                {
                    _entity = liquiddetail;
                }
            }
        }
        private void btnConfirm_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(txtAdvanceToRetailer.Text))
                {
                    MessageBox.ShowBox("MessageID370", BMC_Icon.Information);
                    return;
                }

                decimal dAdvanceToRetailer = 0.0M;
                if (!CheckForValidAdvanceToRetailValue(out dAdvanceToRetailer))
                {
                    MessageBox.ShowBox("MessageID434", BMC_Icon.Information);
                    return;
                }

                System.Windows.Forms.DialogResult dr = MessageBox.ShowBox("MessageID371", BMC_Icon.Question, BMC_Button.YesNo);

                if (dr.ToString() == "Yes")
                {
                    //Update advance retailer value
                    //UpdateAdvanceRetailer();

                    //Calculate the retailer negative net

                    //CalculateRetailerNegative();
                    //CalculateCarriedForwardAmount();

                    if (Entity.ProfitShareGroupId > 0)
                    {
                        //Sp call for profit share details
                        CommonLiquidationDataContext objCommonLiquidation = new CommonLiquidationDataContext(CommonUtilities.ExchangeConnectionString);
                        int LiquidationProfitShareResult = objCommonLiquidation.PerformLiquidationForProfitShare(null,
                                                                                                                 _BatchNo,
                                                                                                                 _entity.ProfitShareGroupId,
                                                                                                                 _entity.ExpenseShareGroupID,
                                                                                                                 _entity.ExpenseShareAmount,
                                                                                                                 _entity.WriteOffAmount,
                                                                                                                 _entity.PayPeriodId,
                                                                                                                 _entity.Gross,
                                                                                                                 _entity.Tickets_Expected,
                                                                                                                 _entity.Net_Percentage,
                                                                                                                 _entity.Retailer_Negative_Net,
                                                                                                                 _entity.Net_Percentage,
                                                                                                                 _entity.Tickets_Paid,
                                                                                                                 _entity.Advance_To_Retailer,
                                                                                                                 _entity.Retailer_Share,
                                                                                                                 _entity.Balance_Due,
                                                                                                                 _entity.Retailer,
                                                                                                                 _entity.RetailerShareBeforeFixedExpense,
                                                                                                                 _entity.CarriedForwardExpense,
                                                                                                                 _entity.RetailerExpenseShareAmount,
                                                                                                                 _entity.FixedExpenseAmount,
                                                                                                                 _entity.PrevCarriedForwardExpense);

                        //Report
                        MessageBox.ShowBox("MessageID488", BMC_Icon.Information);
                        //calling Audit Method
                        Audit(true, _BatchNo);
                        System.Windows.Forms.DialogResult res = MessageBox.ShowBox("MessageID491", BMC_Icon.Question, BMC_Button.YesNo);
                        if (res == System.Windows.Forms.DialogResult.Yes)
                        {
                            using (CReportViewer cReportViewer = new CReportViewer())
                            {
                                LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
                                cReportViewer.ShowLiquidationReportForRead(_BatchNo, null);
                                cReportViewer.ShowDialog();
                            }
                        }
                    }
                    else
                    {
                        MessageBox.ShowBox("MessageID490", BMC_Icon.Information);
                        return;
                    }
                    this.Close();
                }
            }
            catch (Exception ex)
            {
                ExceptionManager.Publish(ex);
            }
        }
        public CProfitShare(CommonLiquidationEntity entity, int iSiteID, int iBatchNo)
            : this(entity)
        {

            _objCommonLiquidation = entity;
            SiteId = iSiteID;

            string sSettingValue = string.Empty;
            CommonLiquidationDataContext objCommonLiquidation = new CommonLiquidationDataContext(BMC.Business.CashDeskOperator.CommonUtilities.ExchangeConnectionString);

            if (!Settings.ExpenseShare)
            {
                txtblkExpenseShareAmount.Visibility = Visibility.Collapsed;
                txtExpenseShareAmount.Visibility = Visibility.Collapsed;
                txtblkExpenseShareGroup.Visibility = Visibility.Collapsed;
                cboExpenseShareGroup.Visibility = Visibility.Collapsed;
            }

            if (!Settings.WriteOffShare)
            {
                txtblkWriteOffExpense.Visibility = Visibility.Collapsed;
                txtWriteOffExpense.Visibility = Visibility.Collapsed;
            }

            LoadProfitShareGroup();
            LoadExpenseShareGroup();
            LoadPayPeriods();
            LoadAmounts();
            EnableDisableControls();
        }