protected void btnRevenueSearch_Click(object sender, EventArgs e) { try { lblErrorOrganization.Visible = false; lblFromDateError.Visible = false; lblToDateError.Visible = false; string fromDate = txtFromDate.Text.ToString(); string toDate = txtToDate.Text.ToString(); //if (ddlOrganization.Enabled && ddlOrganization.SelectedIndex == 0) //{ // lblErrorOrganization.Text = "Please select organization"; // lblErrorOrganization.Visible = true; // return; //} if (string.IsNullOrEmpty(fromDate) && !string.IsNullOrEmpty(toDate)) { lblFromDateError.Text = "Please provide start date"; lblFromDateError.Visible = true; return; } if (!string.IsNullOrEmpty(fromDate) && string.IsNullOrEmpty(toDate)) { lblToDateError.Text = "Please provide end date"; lblToDateError.Visible = true; return; } if (!string.IsNullOrEmpty(fromDate) && !string.IsNullOrEmpty(toDate)) { hdnStartDate.Value = fromDate; hdnEndDate.Value = toDate; if (Convert.ToDateTime(fromDate) > Convert.ToDateTime(toDate)) { lblToDateError.Text = "Start date must be anterior to end date"; lblToDateError.Visible = true; return; } } DataSet ds = null; if (ddlState.SelectedIndex == 0) { ds = RevenuInventory.GetRevenueAdmin(0, 0, txtFromDate.Text == string.Empty ? DateTime.MinValue : Convert.ToDateTime(fromDate), txtToDate.Text == string.Empty ? DateTime.MinValue : Convert.ToDateTime(toDate), CountryIDByLanguageId); } else if (ddlState.SelectedIndex != 0 && ddlOrganization.SelectedIndex == 0) { ds = RevenuInventory.GetRevenueAdmin(Convert.ToInt32(ddlState.SelectedValue), 0, txtFromDate.Text == string.Empty ? DateTime.MinValue : Convert.ToDateTime(fromDate), txtToDate.Text == string.Empty ? DateTime.MinValue : Convert.ToDateTime(toDate), CountryIDByLanguageId); } else { ds = RevenuInventory.GetRevenueAdmin(Convert.ToInt32(ddlState.SelectedValue), Convert.ToInt32(ddlOrganization.SelectedValue), txtFromDate.Text == string.Empty ? DateTime.MinValue : Convert.ToDateTime(fromDate), txtToDate.Text == string.Empty ? DateTime.MinValue : Convert.ToDateTime(toDate), CountryIDByLanguageId); } gvRevenue.DataSource = ds; gvRevenue.DataBind(); } catch (Exception ex) { new SqlLog().InsertSqlLog(0, "ViewRevenue btnRevenueSearch_Click", ex); } }
private void LoadRevenue() { Utils.GetLookUpData <DropDownList>(ref ddlState, LookUps.GetStates, CountryIDByLanguageId); DataSet ds = RevenuInventory.GetRevenueAdmin(0, 0, DateTime.MinValue, DateTime.MinValue, CountryIDByLanguageId); gvRevenue.DataSource = ds; gvRevenue.DataBind(); }
private void GetRevenueInfo(int OrgID, int pageNo) { // string PeriodYear = (string)e.CommandArgument; //int count = 0; pageSize = 10; DataSet ds = null; ds = RevenuInventory.GetRevenueDetailsAdmin(pageNo, pageSize, out totalRows, OrgID, hdnStartDate.Value == string.Empty ? DateTime.MinValue : Convert.ToDateTime(hdnStartDate.Value), hdnEndDate.Value == string.Empty ? DateTime.MinValue : Convert.ToDateTime(hdnEndDate.Value)); TotalItemsR = totalRows; dvRevenueDetail.Visible = true; gvViewDetail.DataSource = ds; gvViewDetail.DataBind(); pgrRevenueDetails.DrawPager(pageNo, this.TotalItemsR, pageSize, MaxPagesToShow); if (gvRevenue.Rows.Count != 0) { LinkButton lnkBtn = (LinkButton)pgrRevenueDetails.FindControl("Button_" + pageNo.ToString()); if (lnkBtn != null) { lnkBtn.Font.Bold = true; } } }
protected void btnRevenueCancel_Click(object sender, EventArgs e) { //Response.Redirect("Revenue"); try { ddlState.SelectedIndex = 0; if (ddlOrganization.Enabled) { ddlOrganization.SelectedIndex = 0; ddlOrganization.Enabled = false; } lblFromDateError.Visible = false; lblToDateError.Visible = false; txtFromDate.Text = string.Empty; txtToDate.Text = string.Empty; gvRevenue.DataSource = RevenuInventory.GetRevenueAdmin(0, 0, DateTime.MinValue, DateTime.MinValue, CountryIDByLanguageId); gvRevenue.DataBind(); } catch (Exception ex) { new SqlLog().InsertSqlLog(0, "ViewRevenue btnRevenueCancel_Click", ex); } }
private void LoadCharts() { try { string pYear = "Year " + DateTime.Now.Year.ToString(); string pMoth = DateTime.Now.ToString("MMMM", CultureInfo.InvariantCulture); int[] Quarters = new int[] { 1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4 }; string pQuarter = "Quarter " + Quarters[DateTime.Now.Month - 1].ToString(); int pHalf = (DateTime.Now.Month - 1) / 6; DataSet dsYearly = RevenuInventory.GetRevenueByYear(UserOrganizationId, DateTime.Now.Year.ToString()); DataSet dsMonthly = RevenuInventory.GetRevenueByMonth(UserOrganizationId, pMoth, DateTime.Now.Year.ToString()); DataSet dsQuarterly = RevenuInventory.GetRevenueByQuarter(UserOrganizationId, pQuarter, DateTime.Now.Year.ToString()); DataSet dsBiannually = RevenuInventory.GetRevenueByHalfYear(UserOrganizationId, pHalf, DateTime.Now.Year.ToString()); if (dsYearly != null && dsYearly.Tables.Count > 0) { if (dsYearly.Tables[0].Rows.Count > 0) { lblYearlyRevenue.Text = dsYearly.Tables[0].Rows[0]["InvoiceAmount"].ToString(); if (string.IsNullOrEmpty(lblYearlyRevenue.Text)) { lblYearlyRevenue.Text = "0.00"; } } else { lblYearlyRevenue.Text = "0.00"; } } if (dsMonthly != null && dsMonthly.Tables.Count > 0) { if (dsMonthly.Tables[0].Rows.Count > 0) { lblMonthly.Text = dsMonthly.Tables[0].Rows[0]["InvoiceAmount"].ToString(); if (string.IsNullOrEmpty(lblMonthly.Text)) { lblMonthly.Text = "0.00"; } } else { lblMonthly.Text = "0.00"; } } if (dsQuarterly != null && dsQuarterly.Tables.Count > 0) { if (dsQuarterly.Tables[0].Rows.Count > 0) { lblQuarterly.Text = dsQuarterly.Tables[0].Rows[0]["InvoiceAmount"].ToString(); if (string.IsNullOrEmpty(lblQuarterly.Text)) { lblQuarterly.Text = "0.00"; } } else { lblQuarterly.Text = "0.00"; } } if (dsBiannually != null && dsBiannually.Tables.Count > 0) { if (dsBiannually.Tables[0].Rows.Count > 0) { lblHalfYearly.Text = dsBiannually.Tables[0].Rows[0]["InvoiceAmount"].ToString(); if (string.IsNullOrEmpty(lblHalfYearly.Text)) { lblHalfYearly.Text = "0.00"; } } else { lblHalfYearly.Text = "0.00"; } } } catch (Exception ex) { new SqlLog().InsertSqlLog(0, "ClientDashboard LoadCharts", ex); } }