public Desboard1Response GetMEIScores([FromBody] Meiscore meiscore)
        {
            Desboard1Response dashboardData = new Desboard1Response();

            try
            {
                Desboard1Response desboard1 = this._iDashboard1Services.GetMEIScores(meiscore);

                if (desboard1 != null)
                {
                    dashboardData.Result       = true;
                    dashboardData.Data         = desboard1.Data;
                    dashboardData.fields       = desboard1.fields;
                    dashboardData.colorCode    = desboard1.colorCode;
                    dashboardData.commentsList = desboard1.commentsList;
                    dashboardData.Message      = "Success";
                }
                else
                {
                    dashboardData.Result = false;
                }
            }
            catch (Exception ex)
            {
                throw;
            }

            return(dashboardData);
        }
예제 #2
0
        public Desboard1Response GetMEIScores(Meiscore meiscore)
        {
            DbConnection c = new DbConnection(_configuration);

            using (IDbConnection con = c.Connection)
            {
                con.Open();
                var param = new DynamicParameters();
                param.Add("@EMPID", meiscore.EMPID);
                param.Add("@CycleID", meiscore.CycleID);
                param.Add("@Role", meiscore.Role);
                param.Add("@DisplayName", meiscore.DisplayName);
                param.Add("@OrderBy", meiscore.OrderBy);
                Desboard1Response    desboard1Response = new Desboard1Response();
                List <DashboardData> castDeshboardData;
                List <colorCode>     colorCode     = new List <colorCode>();
                List <Fields>        fields        = new List <Fields>();
                List <commentsList>  commentsLists = new List <commentsList>();

                using (var qList = con.QueryMultiple("dbo.usp_Dashboard1Data", param, commandType: CommandType.StoredProcedure))
                {
                    castDeshboardData              = qList.Read <DashboardData>().AsList();
                    colorCode                      = qList.Read <colorCode>().AsList();
                    fields                         = qList.Read <Fields>().AsList();
                    commentsLists                  = qList.Read <commentsList>().AsList();
                    desboard1Response.Data         = castDeshboardData;
                    desboard1Response.colorCode    = colorCode;
                    desboard1Response.fields       = fields;
                    desboard1Response.commentsList = commentsLists;
                    //for(int i=0;i<fields.Count;i++)
                    //{
                    //    DashboardData dashboardData = new DashboardData()
                    //    {
                    //        dashboardData.Competative1 = fields[i].DisplayName;
                    //};
                    //}
                }

                return(desboard1Response);
            }
        }
 public Desboard1Response GetMEIScores(Meiscore meiscore)
 {
     return(this._dashboard1Repo.GetMEIScores(meiscore));
 }