public List <dashbordManager> GetMounthlyRecord()
{
dashbordManager objProduct = new dashbordManager();
List <dashbordManager> lmp = new List <dashbordManager>();
DataTable dt = new DataTable();
dt = objProduct.GetMounthlyRecord();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
dashbordManager PMS = new dashbordManager();
PMS.Years = Convert.ToInt32(dr["Years"].ToString());
PMS.Months = Convert.ToInt32(dr["Months"].ToString());
PMS.Sales = Convert.ToDecimal(dr["Sales"].ToString());
lmp.Add(PMS);
}
}
return(lmp);
}
public void DashboardData()
{
dashbordManager objdash = new dashbordManager();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
ds = objdash.getDeshboardRecords();
if (ds.Tables.Count > 0)
{
#region Life Time Sales
if (ds.Tables[0].Rows.Count > 0)
{
lblLifeTimeSale.Text = ds.Tables[0].Rows[0]["AllOverSeles"].ToString();
}
else
{
lblLifeTimeSale.Text = "0.00";
}
#endregion
#region Todays Sales
if (ds.Tables[1].Rows.Count > 0)
{
lblTodaysSales.Text = ds.Tables[1].Rows[0]["TodaysOrderSales"].ToString();
}
else
{
lblTodaysSales.Text = "0";
}
#endregion
#region Todays Order
if (ds.Tables[2].Rows.Count > 0)
{
lbltodaysOrder.Text = ds.Tables[2].Rows[0]["TodaysOrderCount"].ToString();
}
else
{
lbltodaysOrder.Text = "0";
}
#endregion
#region New Customer
if (ds.Tables[3].Rows.Count > 0)
{
gvNewCustomer.DataSource = ds.Tables[3];
gvNewCustomer.DataBind();
}
else
{
gvNewCustomer.DataSource = dt;
gvNewCustomer.DataBind();
}
#endregion
#region Recent Order
if (ds.Tables[4].Rows.Count > 0)
{
gvRecentOrder.DataSource = ds.Tables[4];
gvRecentOrder.DataBind();
}
else
{
gvRecentOrder.DataSource = dt;
gvRecentOrder.DataBind();
}
#endregion
#region Product Performance
if (ds.Tables[5].Rows.Count > 0)
{
gvProductPerformance.DataSource = ds.Tables[5];
gvProductPerformance.DataBind();
}
else
{
gvProductPerformance.DataSource = dt;
gvProductPerformance.DataBind();
}
#endregion
}
}
catch (Exception ex)
{
throw ex;
}
finally { ds.Dispose(); objdash = null; }
}
