public string Get(string Date, string Rcode = "ALL") { ManageDashboard manageDashboard = new ManageDashboard(); List <object> list = new List <object>(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); try { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@SrDate", Date)); sqlParameters.Add(new KeyValuePair <string, string>("@Rcode", Rcode)); ds = manageSQLConnection.GetDataSetValues("DashBordCBGraph", sqlParameters); if (ds.Tables.Count > 1) { string[] regionInfo = ds.Tables[1].Rows.OfType <DataRow>().Select(k => k[0].ToString()).ToArray(); #region Get's the Rice information string[] riceInfo = ds.Tables[2].Rows.OfType <DataRow>().Select(k => k[0].ToString()).ToArray(); list.Add(riceInfo); list.Add(regionInfo); foreach (var rice in riceInfo) { list.Add(manageDashboard.GetValueInArray(rice, ds.Tables[0], regionInfo)); } #endregion #region Get's the Dhall and oil information string[] dhallInfo = ds.Tables[4].Rows.OfType <DataRow>().Select(k => k[0].ToString()).ToArray(); foreach (var dhall in dhallInfo) { list.Add(manageDashboard.GetValueInArray(dhall, ds.Tables[3], regionInfo)); } #endregion #region Get's wheat and sugar information string[] wheatInfo = ds.Tables[6].Rows.OfType <DataRow>().Select(k => k[0].ToString()).ToArray(); foreach (var mywheat in wheatInfo) { list.Add(manageDashboard.GetValueInArray(mywheat, ds.Tables[5], regionInfo)); } #endregion } } finally { ds = null; } return(JsonConvert.SerializeObject(list)); }
public string Get() { ManageDashboard manageMasterDashboard = new ManageDashboard(); List <object> list = new List <object>(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); try { ds = manageSQLConnection.GetDataSetValues("GetMasterDashboardData"); list = manageMasterDashboard.MasterDashboardData(ds); return(JsonConvert.SerializeObject(list)); } finally { manageMasterDashboard = null; list = null; ds.Dispose(); } }