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