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