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