protected void btnSearch_Click(object sender, EventArgs e) { try { InvoiceSearch searchInvoice = new InvoiceSearch(); searchInvoice.FromDateRep = dtpFromDate.Date; searchInvoice.ToDateRep = dtpToDate.Date; if (searchInvoice.ToDateRep < searchInvoice.FromDateRep) { return; } Session["SalesItemReportByRep"] = null; Session["SalesItemReportByRep"] = searchInvoice.SearchInvoicedItemsRepWise(); dxgvSalesByItems.DataSource = (DataSet)Session["SalesItemReportByRep"]; dxgvSalesByItems.DataBind(); dxgvSalesByItems.ExpandAll(); } catch (Exception ex) { ex.Data.Add("UILayerException", this.GetType().ToString() + Constant.Error_Seperator + "protected void btnSearch_Click(object sender, EventArgs e)"); if (Master.LoggedUser != null && Master.LoggedUser.UserName != null && Master.LoggedUser.UserName != string.Empty) { Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, Master.LoggedUser.UserName), false); } else { Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, "Annonimous"), false); } } }
private void FillSession() { try { InvoiceSearch search = new InvoiceSearch(); search.FromDateRep = dtpFromDate.Date; search.ToDateRep = dtpToDate.Date; if ((int)rblReportOption.SelectedItem.Value == 0) { Session["InvoiceReport"] = new InvoiceDAO().GetAllInvoicesAndDetailsForReporting(search); } else if ((int)rblReportOption.SelectedItem.Value == 1) { //load all active only Session["InvoiceReport"] = new InvoiceDAO().GetAllActiveInvoicesForReporting(search); } else if ((int)rblReportOption.SelectedItem.Value == 2) { //load all cancelled only Session["InvoiceReport"] = new InvoiceDAO().GetAllCancelledInvoicesForReporting(search); } else if ((int)rblReportOption.SelectedItem.Value == 3) { //load all pending payments only Session["InvoiceReport"] = new InvoiceDAO().GetAllPaymentDueInvoicesForReporting(search); } this.FilterDataByUserRole(); } catch (Exception ex) { throw ex; } }
public DataSet GetItemWiseSalesForReportingRepWise(InvoiceSearch invoiceSearch) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Invoice_Report_GetItemSalesByItemsRepWise); db.AddInParameter(dbCommand, "@dFromDate", DbType.DateTime, invoiceSearch.FromDateRep); db.AddInParameter(dbCommand, "@dToDate", DbType.DateTime, invoiceSearch.ToDateRep); return db.ExecuteDataSet(dbCommand); } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public DataSet GetItemWiseSalesForReportingRepWise(InvoiceSearch invoiceSearch)"); return null; throw ex; } }
public DataSet SearchInvoice(InvoiceSearch invoiceSearch) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand cmd = db.GetStoredProcCommand(Constant.SP_Invoice_Search); db.AddInParameter(cmd, "@sInvoiceNo", DbType.String, invoiceSearch.InvoiceNo); db.AddInParameter(cmd, "@sFromDate", DbType.String, invoiceSearch.FromDate); db.AddInParameter(cmd, "@sToDate", DbType.String, invoiceSearch.ToDate); db.AddInParameter(cmd, "@iBranchId", DbType.Int32, invoiceSearch.BranchId); db.AddInParameter(cmd, "@iCustomerID", DbType.Int32, invoiceSearch.CustomerID); db.AddInParameter(cmd, "@iDueOption", DbType.Int32, invoiceSearch.DueOption); db.AddInParameter(cmd, "@iIsPaid", DbType.Int32, invoiceSearch.IsPaid); ds = db.ExecuteDataSet(cmd); } catch (System.Exception ex) { ds = null; throw ex; } return ds; }
/// <summary> /// Get all payment due invoices /// </summary> /// <returns>Dataset with one table</returns> public DataSet GetAllPaymentDueInvoicesForReporting(InvoiceSearch invoiceSearch) { DataSet ds = null; try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Invoice_Report_GetAllPaymentDueInvoicesByDateRange); db.AddInParameter(dbCommand, "@dFromDate", DbType.DateTime, invoiceSearch.FromDateRep); db.AddInParameter(dbCommand, "@dToDate", DbType.DateTime, invoiceSearch.ToDateRep); ds = db.ExecuteDataSet(dbCommand); } catch (System.Exception ex) { ds = null; throw ex; } return ds; }