//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; } } }
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(); }