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