private SellingCheque getSellingChequeForFilter()
{
SellingCheque sellingCheque = null;
try {
sellingCheque = new SellingCheque();
if (sellingChequeReport.datePicker_from.SelectedDate != null || sellingChequeReport.datePicker_to.SelectedDate != null)
{
if (sellingChequeReport.datePicker_from.SelectedDate != null && sellingChequeReport.datePicker_to.SelectedDate != null)
{
sellingCheque.PayableDate = sellingChequeReport.datePicker_from.SelectedValue;
sellingCheque.addDateCondition("date", "BETWEEN", sellingChequeReport.datePicker_from.SelectedValue.ToString("yyyy-MM-dd"), sellingChequeReport.datePicker_to.SelectedValue.ToString("yyyy-MM-dd"));
}
else if (sellingChequeReport.datePicker_from.SelectedDate != null)
{
sellingCheque.PayableDate = sellingChequeReport.datePicker_from.SelectedValue;
}
else
{
sellingCheque.PayableDate = sellingChequeReport.datePicker_to.SelectedValue;
}
}
sellingCheque.Status = Convert.ToInt32(sellingChequeReport.comboBox_status.SelectedValue);
sellingCheque.Status = sellingChequeReport.comboBox_status.Value;
} catch (Exception) {
}
return(sellingCheque);
}
internal void populateUpdateForm()
{
try {
int id = chequeManager.dataGrid.SelectedItemID;
if (chequeManager.radioButton_buying_filter.IsChecked == true)
{
BuyingCheque buyingCheque = paymentManagerImpl.getBuyingChequeById(id);
chequeManager.SelectedBuyingCheque = buyingCheque;
chequeManager.datePicker_issuedDate_update.SelectedDate = buyingCheque.IssuedDate;
chequeManager.datePicker_payableDate_update.SelectedDate = buyingCheque.PayableDate;
chequeManager.textBox_amount_update.DoubleValue = buyingCheque.Amount;
chequeManager.textBox_chequeNumber_update.Text = buyingCheque.ChequeNumber;
chequeManager.comboBox_bank_update.SelectedValue = buyingCheque.BankId;
chequeManager.textBox_notes_update.Text = buyingCheque.Notes;
chequeManager.comboBox_status_update.SelectedValue = buyingCheque.Status;
}
else
{
SellingCheque sellingCheque = paymentManagerImpl.getSellingChequeById(id);
chequeManager.SelectedSellingCheque = sellingCheque;
chequeManager.datePicker_issuedDate_update.SelectedDate = sellingCheque.IssuedDate;
chequeManager.datePicker_payableDate_update.SelectedDate = sellingCheque.PayableDate;
chequeManager.textBox_amount_update.DoubleValue = sellingCheque.Amount;
chequeManager.textBox_chequeNumber_update.Text = sellingCheque.ChequeNumber;
chequeManager.comboBox_bank_update.SelectedValue = sellingCheque.BankId;
chequeManager.textBox_notes_update.Text = sellingCheque.Notes;
chequeManager.comboBox_status_update.SelectedValue = sellingCheque.Status;
}
} catch (Exception) {
}
}
internal void setSellingChequeRreportRowsCount()
{
try {
SellingCheque sellingCheque = getSellingChequeForFilter();
sellingCheque.RowsCount = 1;
sellingCheque.LimitStart = sellingChequeReport.Pagination.LimitStart;
sellingCheque.LimitEnd = sellingChequeReport.Pagination.LimitCount;
List <SellingCheque> list = paymentManagerImpl.getSellingCheque(sellingCheque);
sellingChequeReport.Pagination.RowsCount = list[0].RowsCount;
} catch (Exception) {
}
}
internal void filterSellingCheque()
{
try {
SellingCheque sc = getSellingChequeForFilter();
sc.LimitStart = sellingChequeReport.Pagination.LimitStart;
sc.LimitEnd = sellingChequeReport.Pagination.LimitCount;
List <SellingCheque> list = paymentManagerImpl.getSellingCheque(sc);
sellingChequeReport.DataTable.Rows.Clear();
foreach (SellingCheque sellingCheque in list)
{
sellingChequeReport.DataTable.Rows.Add(sellingCheque.Id, bankManagerImpl.getBankById(sellingCheque.BankId).Name, sellingCheque.ChequeNumber,
sellingCheque.IssuedDate.ToString("yyyy-MM-dd"), sellingCheque.PayableDate.ToString("yyyy-MM-dd"),
sellingCheque.Amount.ToString("#,##0.00"), CommonMethods.getStatusForCheque(sellingCheque.Status));
}
} catch (Exception) {
}
}
internal bool updateCheque()
{
bool b = false;
try {
if (isValidateUpdateForm())
{
if (chequeManager.radioButton_buying_filter.IsChecked == true)
{
BuyingCheque buyingCheque = chequeManager.SelectedBuyingCheque;
buyingCheque.IssuedDate = Convert.ToDateTime(chequeManager.datePicker_issuedDate_update.SelectedDate);
buyingCheque.PayableDate = Convert.ToDateTime(chequeManager.datePicker_payableDate_update.SelectedDate);
buyingCheque.Amount = chequeManager.textBox_amount_update.DoubleValue;
buyingCheque.ChequeNumber = chequeManager.textBox_chequeNumber_update.Text;
buyingCheque.BankId = Convert.ToInt32(chequeManager.comboBox_bank_update.SelectedValue);
buyingCheque.Notes = chequeManager.textBox_notes_update.Text;
buyingCheque.Status = Convert.ToInt32(chequeManager.comboBox_status_update.SelectedValue);
CommonMethods.setCDMDForUpdate(buyingCheque);
paymentManagerImpl.updBuyingCheque(buyingCheque);
b = true;
}
else
{
SellingCheque sellingCheque = chequeManager.SelectedSellingCheque;
sellingCheque.IssuedDate = Convert.ToDateTime(chequeManager.datePicker_issuedDate_update.SelectedDate);
sellingCheque.PayableDate = Convert.ToDateTime(chequeManager.datePicker_payableDate_update.SelectedDate);
sellingCheque.Amount = chequeManager.textBox_amount_update.DoubleValue;
sellingCheque.ChequeNumber = chequeManager.textBox_chequeNumber_update.Text;
sellingCheque.BankId = Convert.ToInt32(chequeManager.comboBox_bank_update.SelectedValue);
sellingCheque.Notes = chequeManager.textBox_notes_update.Text;
sellingCheque.Status = Convert.ToInt32(chequeManager.comboBox_status_update.SelectedValue);
CommonMethods.setCDMDForUpdate(sellingCheque);
paymentManagerImpl.updSellingCheque(sellingCheque);
b = true;
}
}
} catch (Exception) {
}
return(b);
}
private SellingCheque getSellingChequeForFilter()
{
SellingCheque sellingCheque = new SellingCheque();
try {
if (chequeManager.datePicker_issuedDate_filter.SelectedDate != null)
{
sellingCheque.IssuedDate = Convert.ToDateTime(chequeManager.datePicker_issuedDate_filter.SelectedDate);
}
if (chequeManager.datePicker_payable_filter.SelectedDate != null)
{
sellingCheque.PayableDate = Convert.ToDateTime(chequeManager.datePicker_payable_filter.SelectedDate);
}
sellingCheque.Amount = chequeManager.textBox_amount_filter.DoubleValue > 0 ? chequeManager.textBox_amount_filter.DoubleValue : -1;
sellingCheque.ChequeNumber = chequeManager.textBox_chequeNumber_filter.Text + "%";
sellingCheque.BankId = Convert.ToInt32(chequeManager.comboBox_bank_filter.SelectedValue);
sellingCheque.Notes = "%" + chequeManager.textBox_notes_filter.Text + "%";
sellingCheque.Status = Convert.ToInt32(chequeManager.comboBox_status_filter.SelectedValue);
} catch (Exception) {
}
return(sellingCheque);
}
internal void setRowsCount()
{
try {
if (chequeManager.radioButton_buying_filter.IsChecked == true)
{
BuyingCheque buyingCheque = getBuyingChequeForFilter();
buyingCheque.RowsCount = 1;
buyingCheque.LimitStart = chequeManager.Pagination.LimitStart;
buyingCheque.LimitEnd = chequeManager.Pagination.LimitCount;
chequeManager.Pagination.RowsCount = paymentManagerImpl.getBuyingCheque(buyingCheque)[0].RowsCount;
}
else
{
SellingCheque sellingCheque = getSellingChequeForFilter();
sellingCheque.RowsCount = 1;
sellingCheque.LimitStart = chequeManager.Pagination.LimitStart;
sellingCheque.LimitEnd = chequeManager.Pagination.LimitCount;
chequeManager.Pagination.RowsCount = paymentManagerImpl.getSellingCheque(sellingCheque)[0].RowsCount;
}
} catch (Exception) {
}
}
internal void filter()
{
try {
if (chequeManager.radioButton_buying_filter.IsChecked == true)
{
BuyingCheque bc = getBuyingChequeForFilter();
bc.LimitStart = chequeManager.Pagination.LimitStart;
bc.LimitEnd = chequeManager.Pagination.LimitCount;
List <BuyingCheque> list = paymentManagerImpl.getBuyingCheque(bc);
chequeManager.DataTable.Rows.Clear();
foreach (BuyingCheque buyingCheque in list)
{
chequeManager.DataTable.Rows.Add(
buyingCheque.Id, bankManagerImpl.getBankById(buyingCheque.BankId).Name, buyingCheque.ChequeNumber,
buyingCheque.IssuedDate.ToString("yyyy-MM-dd"), buyingCheque.PayableDate.ToString("yyyy-MM-dd"),
buyingCheque.Amount.ToString("#,##0.00"), buyingCheque.Notes, CommonMethods.getStatusForCheque(buyingCheque.Status)
);
}
}
else
{
SellingCheque sc = getSellingChequeForFilter();
sc.LimitStart = chequeManager.Pagination.LimitStart;
sc.LimitEnd = chequeManager.Pagination.LimitCount;
List <SellingCheque> list = paymentManagerImpl.getSellingCheque(sc);
chequeManager.DataTable.Rows.Clear();
foreach (SellingCheque sellingCheque in list)
{
chequeManager.DataTable.Rows.Add(
sellingCheque.Id, bankManagerImpl.getBankById(sellingCheque.BankId).Name, sellingCheque.ChequeNumber,
sellingCheque.IssuedDate.ToString("yyyy-MM-dd"), sellingCheque.PayableDate.ToString("yyyy-MM-dd"),
sellingCheque.Amount.ToString("#,##0.00"), sellingCheque.Notes, CommonMethods.getStatusForCheque(sellingCheque.Status)
);
}
}
} catch (Exception) {
}
}
