public List <EftKontTabOneTable> Efterkontrolltabone([FromBody] UserControllEftNar uc)
{
List <EftKontTabOneTable> ktList = new List <EftKontTabOneTable>();
//Connect and retrieve data
if (Login.CheckLogging(uc.user))
{
string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("Dashboard_EfterkontrollTable", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
EftKontTabOneTable kt = new EftKontTabOneTable();
kt.taxinrAA = rdr["taxinr"].ToString();
kt.antalejuppfylldakrav = rdr["antalejuppfylldakrav"].ToString();
kt.antalejuppfylldakravinomkort = rdr["antalejuppfylldakravinomkort"].ToString();
ktList.Add(kt);
}
}
}
return(ktList);
}
public List <KTMeddlemar> KTMFunc([FromBody] UserControllEftNar uc)
{
List <KTMeddlemar> ktmList = new List <KTMeddlemar>();
//Connect and retrieve data
if (Login.CheckLogging(uc.user))
{
string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("Dashboard_getAllPlannedControlls", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramA = new SqlParameter("@id", uc.idCall);
cmd.Parameters.Add(paramA);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
KTMeddlemar ktm = new KTMeddlemar();
ktm.id = Convert.ToInt32(rdr["id"]);
ktm.value = rdr["value"].ToString();
ktmList.Add(ktm);
}
}
}
return(ktmList);
}
public List <Efterkontroll> EKFunc([FromBody] UserControllEftNar uc)
{
List <Efterkontroll> ekList = new List <Efterkontroll>();
string izvor = "";
if (uc.izvor == "1")
{
izvor = "Dashboard_Efterkontroll";
}
else if (uc.izvor == "2")
{
izvor = "Dashboard_EfterkontrollFlygande";
}
//Connect and retrieve data
if (Login.CheckLogging(uc.user))
{
string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand(izvor, con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramA = new SqlParameter("@KontrollID", uc.idCall);
cmd.Parameters.Add(paramA);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Efterkontroll ek = new Efterkontroll();
ek.ingen = Convert.ToInt32(rdr["Ingen"]);
ek.senare = Convert.ToInt32(rdr["Senare"]);
ek.snarast = Convert.ToInt32(rdr["Snarast"]);
ekList.Add(ek);
}
}
}
return(ekList);
}
public List <Narvaro> NVFunc([FromBody] UserControllEftNar uc)
{
List <Narvaro> nvList = new List <Narvaro>();
string izvor = "";
if (uc.izvor == "1")
{
izvor = "Dashboard_Narvaro";
}
else if (uc.izvor == "2")
{
izvor = "Dashboard_NarvaroFlygande";
}
//Connect and retrieve data
if (Login.CheckLogging(uc.user))
{
string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand(izvor, con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramA = new SqlParameter("@KontrollID", uc.idCall);
cmd.Parameters.Add(paramA);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Narvaro nv = new Narvaro();
nv.andel = Convert.ToInt32(rdr["andel"]);
nv.narvaroTyp = rdr["narvaroTyp"].ToString();
nv.color = rdr["color"].ToString();
nvList.Add(nv);
}
}
}
return(nvList);
}
public List <KravPerYearBarChart> Post([FromBody] UserControllEftNar uc)
{
List <KravPerYearBarChart> kpybcList = new List <KravPerYearBarChart>();
string izvor = "";
if (uc.izvor == "1")
{
izvor = "Dashboard_KravPerYear";
}
else if (uc.izvor == "2")
{
izvor = "Dashboard_KravPerYearFlygande";
}
//Connect and retrieve data
if (Login.CheckLogging(uc.user))
{
string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand(izvor, con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
KravPerYearBarChart kpybc = new KravPerYearBarChart();
kpybc.andel = Convert.ToInt32(rdr["andel"]);
kpybc.datum = rdr["datum"].ToString();
kpybc.krav = rdr["krav"].ToString();
kpybcList.Add(kpybc);
}
}
}
return(kpybcList);
}
