public void ShowDataInGrid()
{
decimal preMonthCollectionAmount = 0;
int nowMonth = DateTime.Now.Month;
int nowYear = DateTime.Now.Year;
// Find previous year and month
var today = DateTime.Today;
var month = new DateTime(today.Year, today.Month, 1);
var first = month.AddMonths(-1);
var last = month.AddDays(-1);
int preMonth = first.Month;
int preYear = first.Year;
try
{
string OCode = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
List <MarketingWorkOrderTransaction> aMarketingWorkOrderTransaction = aWorkOrderTransactionBLL.GetAllCurrentMonthTransactionDetails(preMonth, preYear, OCode);
if (aMarketingWorkOrderTransaction.Count > 0)
{
TransactionGridView.DataSource = aMarketingWorkOrderTransaction;
TransactionGridView.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void reloadTable()
{
transactionDataSet = transactionController.viewAllTransactions();
TransactionGridView.DataSource = transactionDataSet;
TransactionGridView.DataBind();
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (TransactionGridView.GetFocusedRow() is Transactions item)
{
BillingStatementViewModel billingStatementViewModel = new BillingStatementViewModel()
{
TransactionId = item.Id
};
var billing = new UnitOfWork().BillingsRepo.Find(x => x.TransactionId == item.Id);
billing.AmountInWord = "**" + StringExtensions.NumberToWords(billing.Amount.ToString("##.##00")) + "**";
billing.BillingStatementViewModels =
new List <BillingStatementViewModel>()
{
billingStatementViewModel
};
frmReportViewer frmReportViewer = new frmReportViewer(new rptOfficialReceipt()
{
DataSource = new List <Billings>()
{
billing
}
});
frmReportViewer.ShowDialog();
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ShowDataInGrid()
{
decimal preMonthCollectionAmount = 0;
int nowMonth = DateTime.Now.Month;
int nowYear = DateTime.Now.Year;
try
{
string OCode = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
List <MarketingWorkOrderTransaction> aMarketingWorkOrderTransaction = aWorkOrderTransactionBLL.GetAllCurrentMonthTransactionDetails(nowMonth, nowYear, OCode);
if (aMarketingWorkOrderTransaction.Count > 0)
{
TransactionGridView.DataSource = aMarketingWorkOrderTransaction;
TransactionGridView.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["name"] == null)
{
Response.Redirect("login.aspx");
}
else
{
TransactionGridView.DataSource = TransactionController.generateTransactionData((int)Session["userId"], (int)Session["roleId"]);
TransactionGridView.DataBind();
if ((int)Session["roleId"] == 2)
{
viewTransactionReportBtn.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
TransactionController transactionController = new TransactionController();
if (Session["CurrentAccount"] != null)
{
Account account = (Account)Session["CurrentAccount"];
DataTable transactionDataTable = transactionController.viewTransaction(account.Id.ToString());
TransactionGridView.DataSource = transactionDataTable;
TransactionGridView.DataBind();
}
else
{
ErrorLabel.Text = "You need to be registered in order to see this feature.";
}
TransactionGridView.Font.Size = 14;
}
public void ShowDataInGrid()
{
int workOrderId = Convert.ToInt32(HiddwnFieldWorkOrderId.Value);
try
{
string OCode = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode);
List <MRK_Transaction> aMRK_Transaction = aWorkOrderTransactionBLL.GetAllTransactionDetails(workOrderId, OCode);
if (aMRK_Transaction.Count > 0)
{
TransactionGridView.DataSource = aMRK_Transaction;
TransactionGridView.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void BindGridView()
{
Collection <MixERP.Net.Common.Models.Transactions.JournalDetailsModel> table = this.GetTable();
TransactionGridView.DataSource = table;
TransactionGridView.DataBind();
if (table.Count > 0)
{
decimal debit = 0;
decimal credit = 0;
foreach (MixERP.Net.Common.Models.Transactions.JournalDetailsModel row in table)
{
debit += row.Debit;
credit += row.Credit;
}
DebitTotalTextBox.Text = debit.ToString("G29", System.Threading.Thread.CurrentThread.CurrentCulture);
CreditTotalTextBox.Text = credit.ToString("G29", System.Threading.Thread.CurrentThread.CurrentCulture);
}
}
protected void TransactionGridView_PageIndexChanging(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
{
TransactionGridView.PageIndex = e.NewPageIndex;
TransactionGridView.DataBind();
}
