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