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