public List <FCRow> GUFC([FromBody] UserRowLog urLog) { /* * Returns list of all fordon controlls from Kontrolldatum table */ List <FCRow> fcList = new List <FCRow>(); if (Login.CheckLogging(urLog.User)) { string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("select *,case when (select top 1 KontrollID from KontrollTabell where Kontrolldatum = Kontrolldatum.id) is null then 1 else 0 end as del from Kontrolldatum where Kontrolltyp <> 3", con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { FCRow fc = new FCRow(); fc.ID = Convert.ToInt32(rdr["id"]); fc.Typ = rdr["Kontrolltyp"].ToString(); fc.From = Convert.ToDateTime(rdr["FromDate"]); fc.To = Convert.ToDateTime(rdr["ToDate"]); fc.Del = Convert.ToInt32(rdr["del"]); fcList.Add(fc); } } } return(fcList); }
public Boolean LGU([FromBody] UserRowLog urLog) { /* * Returns 0 or 1 based on if user is logged out */ if (Login.CheckLogging(urLog.User)) { string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("UPDATE del_Users SET del_LastLogin = '******' WHERE del_ID = " + urLog.User, con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); } } return(true); }
public List <KravRow> GKL([FromBody] UserRowLog ur) { /* * Returns list of all requirement from Krav table */ List <KravRow> krList = new List <KravRow>(); //Connect and retrieve data if (Login.CheckLogging(ur.User)) { string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("select * from KravTabell", con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { //Get row KravRow kt = new KravRow(); kt.id = Convert.ToInt64(rdr["KravID"]); kt.Krav = rdr["Krav"].ToString(); kt.Status = Convert.ToInt32(rdr["Status"]); kt.Efterkontroll = Convert.ToInt32(rdr["Efterkontroll"]); kt.ExkluderadeBilar = Convert.ToInt32(rdr["ExkluderadeBilar"]); //Translate reserved words in column "Krav" kt.Krav = kt.Krav.Replace("@s@", "select"); kt.Krav = kt.Krav.Replace("@d@", "drop"); kt.Krav = kt.Krav.Replace("@i@", "insert"); kt.Krav = kt.Krav.Replace("@n@", "'"); //Add row to the list krList.Add(kt); } } } return(krList); }
public List <UserRow> GUL([FromBody] UserRowLog urLog) { /* * Returns list of all users from user table */ List <UserRow> urList = new List <UserRow>(); if (Login.CheckLogging(urLog.User)) { string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("select * from del_Users", con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { UserRow ur = new UserRow(); ur.ID = Convert.ToInt32(rdr["del_ID"]); ur.User = rdr["del_User"].ToString(); ur.Level = rdr["del_Level"].ToString(); ur.User = ur.User.Replace("@s@", "select"); ur.User = ur.User.Replace("@d@", "drop"); ur.User = ur.User.Replace("@i@", "insert"); ur.User = ur.User.Replace("@n@", "'"); ur.Level = ur.Level.Replace("@s@", "select"); ur.Level = ur.Level.Replace("@d@", "drop"); ur.Level = ur.Level.Replace("@i@", "insert"); ur.Level = ur.Level.Replace("@n@", "'"); urList.Add(ur); } } } return(urList); }