public HttpResponseMessage CardsAMtd(HttpRequestMessage request, string valu)
{
appLog.InfoFormat("Calling the CardsAMtd() method by LandingPage");
HttpResponseMessage res = null;
//Get the culture property of the thread.
CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture;
//Create TextInfo object.
TextInfo textInfo = cultureInfo.TextInfo;
var newList = new List <DashboardMainCaptionListInfo>();
int latestyear = Convert.ToInt32(System.Web.HttpContext.Current.Session["latestyear"]);
int period = Convert.ToInt32(System.Web.HttpContext.Current.Session["currentperiod"]);
string miscode = Convert.ToString(System.Web.HttpContext.Current.Session["session_miscode"]);
string currentlyselectedmiscode = Convert.ToString(System.Web.HttpContext.Current.Session["session_currentlyselectedmiscode"]);
int level = Convert.ToInt32(System.Web.HttpContext.Current.Session["session_level"]);
int currentlyselectedlevel = Convert.ToInt32(System.Web.HttpContext.Current.Session["session_currentlyselectedlevel"]);
//if (currentlyselectedmiscode != "")
//{
// miscode = "";
// miscode = currentlyselectedmiscode;
// level = currentlyselectedlevel;
//}
appLog.InfoFormat("level: {0} received", level);
appLog.InfoFormat("miscode: {0} received", miscode);
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("proc_mpr_report_dashboard_by_caption_6", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "MisCode",
Value = miscode,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Period",
Value = period,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Year",
Value = latestyear,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Level",
Value = level,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "type",
Value = valu,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "TrendOrMonthly",
Value = "monthly",
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var pts = new DashboardMainCaptionListInfo();
pts.MainCaption = reader["MainCaption"] != DBNull.Value ? reader["MainCaption"].ToString() : "null";
pts.Amount = reader["Amount"] != DBNull.Value ? Convert.ToDouble(reader["Amount"].ToString()) : 0;
pts.Budget = reader["Budget"] != DBNull.Value ? Convert.ToDouble(reader["Budget"].ToString()) : 0;
pts.Period = reader["Period"] != DBNull.Value ? Convert.ToInt32(reader["Period"].ToString()) : 0;
newList.Add(pts);
}
con.Close();
} // using
res = request.CreateResponse <IEnumerable>(HttpStatusCode.OK, newList);
appLog.InfoFormat("about to return the result");
return(res);
}
//============================== trend for subcaption ends ===========================================================================
//==================== for cards starts ================================
public List <DashboardMainCaptionListInfo> DashboardCardMainCaptionMtd()
{
//Get the culture property of the thread.
CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture;
//Create TextInfo object.
TextInfo textInfo = cultureInfo.TextInfo;
var newList = new List <DashboardMainCaptionListInfo>();
//var latestmonthyear = (from a in entityContext.IncomeSetUpDailySet
// where a.Year == entityContext.IncomeSetUpDailySet.Max(x => x.Year)
// //select a);
// select new
// {
// Year = a.Year,
// CurrentPeriod = a.CurrentPeriod
// })
// .AsEnumerable().Select(x => new IncomeSetUpDaily
// {
// Year = x.Year,
// CurrentPeriod = x.CurrentPeriod
// })
// .ToList();
//var latestmonthyear = entityContext.IncomeSetUpDailySet.OrderByDescending(x => x.Year).Take(1);
//int latestyear = latestmonthyear.Select(x => x.Year).FirstOrDefault();
//int period = latestmonthyear.Max(x => x.CurrentPeriod);
int latestyear = Convert.ToInt32(System.Web.HttpContext.Current.Session["latestyear"]);
int period = Convert.ToInt32(System.Web.HttpContext.Current.Session["currentperiod"]);
string miscode = Convert.ToString(System.Web.HttpContext.Current.Session["session_miscode"]);
string currentlyselectedmiscode = Convert.ToString(System.Web.HttpContext.Current.Session["session_currentlyselectedmiscode"]);
int level = Convert.ToInt32(System.Web.HttpContext.Current.Session["session_level"]);
int currentlyselectedlevel = Convert.ToInt32(System.Web.HttpContext.Current.Session["session_currentlyselectedlevel"]);
if (currentlyselectedmiscode != "")
{
miscode = "";
miscode = currentlyselectedmiscode;
level = currentlyselectedlevel;
}
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("proc_mpr_report_ratios_2B", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "MisCode",
Value = miscode,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Period",
Value = period,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Year",
Value = latestyear,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Level",
Value = level,
});
//cmd.Parameters.Add(new SqlParameter
//{
// ParameterName = "TrendOrMonthly",
// Value = "monthly",
//});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var pts = new DashboardMainCaptionListInfo();
pts.MainCaption = reader["MainCaption"] != DBNull.Value ? reader["MainCaption"].ToString() : "null";
pts.Amount = reader["Amount"] != DBNull.Value ? Convert.ToDouble(reader["Amount"].ToString()) : 0;
pts.Budget = reader["Budget"] != DBNull.Value ? Convert.ToDouble(reader["Budget"].ToString()) : 0;
pts.Period = reader["Period"] != DBNull.Value ? Convert.ToInt32(reader["Period"].ToString()) : 0;
newList.Add(pts);
}
con.Close();
}
return(newList);
}
