Exemplo n.º 1
0
        public ActionResult GetPatrolStatus([FromBody]  int ahwalId)
        {
            List <string>               count        = new List <string>();
            List <string>               chartLabel   = new List <string>();
            ChartViewModel              cvm          = new ChartViewModel();
            PostgresWrapper             pw           = new PostgresWrapper();
            Dictionary <string, object> keyValuePair = new Dictionary <string, object>();

            keyValuePair.Add("aid", ahwalId);
            DataSet pgDataSet = pw.ExecuteStoredProc(PatrolConstants.PGSQL_FETCHPATROLSTATUSBYAHWAL, keyValuePair);

            if (pgDataSet != null && pgDataSet.Tables.Count > 0)
            {
                foreach (DataRow dr in pgDataSet.Tables[0].Rows)
                {
                    chartLabel.Add(Convert.ToString(dr["name"]));
                    count.Add(Convert.ToString(dr["patrolstatuscount"]));
                }
            }
            cvm.chartlabel  = chartLabel.ToArray();
            cvm.chartsubdta = new List <ChartSubDataViewModel>();
            ChartSubDataViewModel csd = new ChartSubDataViewModel();

            csd.backgroundcolor = "";
            csd.data            = count.ToArray();
            csd.label           = "Status";
            cvm.chartsubdta.Add(csd);
            return(Ok(cvm));
        }
Exemplo n.º 2
0
        public string GetEmployeeStats([FromBody]  int ahwalId)
        {
            List <string> onDuty     = new List <string>();
            List <string> onLeave    = new List <string>();
            List <string> chartLabel = new List <string>();

            PostgresWrapper             pw           = new PostgresWrapper();
            Dictionary <string, object> keyValuePair = new Dictionary <string, object>();

            keyValuePair.Add("aid", ahwalId);
            DataSet pgDataSet = pw.ExecuteStoredProc(PatrolConstants.PGSQL_FETCHEMPLOYEESTATBYAHWAL, keyValuePair);

            if (pgDataSet != null && pgDataSet.Tables.Count > 0)
            {
                foreach (DataRow dr in pgDataSet.Tables[0].Rows)
                {
                    chartLabel.Add(Convert.ToString(dr["name"]));
                    onDuty.Add(Convert.ToString(dr["ONDUTY"]));
                    onLeave.Add(Convert.ToString(dr["ONLEAVE"]));
                }
            }
            ChartViewModel cvm = new ChartViewModel();

            cvm.chartlabel  = chartLabel.ToArray();
            cvm.chartsubdta = new List <ChartSubDataViewModel>();
            ChartSubDataViewModel csd = new ChartSubDataViewModel();

            csd.backgroundcolor = "";
            csd.data            = onDuty.ToArray();
            csd.label           = "On duty";
            cvm.chartsubdta.Add(csd);
            csd = new ChartSubDataViewModel();
            csd.backgroundcolor = "";
            csd.data            = onLeave.ToArray();
            csd.label           = "On leave";
            cvm.chartsubdta.Add(csd);
            return(JsonConvert.SerializeObject(cvm));
        }