private void btnSearch_Click(object sender, EventArgs e)
{
ExpenseTransactionBL bl = new ExpenseTransactionBL();
string searchText = ddlDebitType.Text;
var lstExpenseTran = new List <ExpenseTransactionDTO>();
if (ddlDebitType.Text == "BOTH")
{
lstExpenseTran = bl.GetExpenseTransaction().Where(et => Convert.ToDateTime(Convert.ToDateTime(et.ExpenseDate).ToShortDateString()) >= Convert.ToDateTime(dtStartDate.Text) && Convert.ToDateTime(Convert.ToDateTime(et.ExpenseDate).ToShortDateString()) <= Convert.ToDateTime(dtEndDate.Text)).ToList();
dgExpenseTransaction.DataSource = lstExpenseTran;
}
else
{
lstExpenseTran = bl.GetExpenseTransaction().Where(et => Convert.ToDateTime(Convert.ToDateTime(et.ExpenseDate).ToShortDateString()) >= Convert.ToDateTime(dtStartDate.Text) && Convert.ToDateTime(Convert.ToDateTime(et.ExpenseDate).ToShortDateString()) <= Convert.ToDateTime(dtEndDate.Text))
.Where(
efu => efu.DebitType.ToUpper().Contains(ddlDebitType.Text.ToUpper())
).ToList();
dgExpenseTransaction.DataSource = lstExpenseTran;
}
if (ddlType.Text != "" && ddlType.Text != "BOTH")
{
lstExpenseTran = lstExpenseTran.Where(efu => efu.Type.ToUpper().Contains(ddlType.Text.ToUpper())).ToList();
dgExpenseTransaction.DataSource = lstExpenseTran;
}
}
private void LoadDefaultValues()
{
ExpenseTransactionBL bl = new ExpenseTransactionBL();
var lstExpenseTran = bl.GetExpenseTransaction().Where(et => Convert.ToDateTime(Convert.ToDateTime(et.ExpenseDate).ToShortDateString()) >= Convert.ToDateTime(dtStartDate.Text) && Convert.ToDateTime(Convert.ToDateTime(et.ExpenseDate).ToShortDateString()) <= Convert.ToDateTime(dtEndDate.Text)).ToList();
dgExpenseTransaction.DataSource = lstExpenseTran;
}
private void PopulateValues()
{
ExpenseTransactionBL bl = new ExpenseTransactionBL();
var etr = bl.GetExpenseTransaction().FirstOrDefault(et => et.ExpenseTransactionID == _expenseTransactionID);
ComboboxItem item = new ComboboxItem();
item.Text = etr.ExpenseDescription;
item.Value = etr.ExpenseID;
ddlExpenses.Text = item.Text;
ddlDebitType.Text = "";
ddlDebitType.SelectedText = etr.DebitType;
txtAmount.Text = etr.Amount.ToString();
txtComments.Text = etr.Comments;
dtExpDate.Text = etr.ExpenseDate.ToShortDateString();
ddlType.Text = "";
ddlType.SelectedText = etr.Type;
}
