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);
}
}
