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 long PUT([FromBody] FCRow FCB)
{
/*
* Inserts new fordon controll based on posted data
*/
//Check if entered data are OK
FCRow FCT = ProtectDatabaseFC(FCB);
//If everything is OK proceed
if (FCT.Check && Login.CheckLogging(FCB.User))
{
//Insert FC in table
string CS = ConfigurationManager.ConnectionStrings["Fordonskontroll"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
string updateQuarry = "update Kontrolldatum set Kontrolltyp = @Kontrolltyp, FromDate = @FromDate, ToDate = @ToDate where id = @ID";
SqlCommand cmd = new SqlCommand(updateQuarry, con);
SqlParameter paramTyp = new SqlParameter("@Kontrolltyp", FCT.Typ);
cmd.Parameters.Add(paramTyp);
SqlParameter paramFrom = new SqlParameter("@FromDate", FCT.From);
cmd.Parameters.Add(paramFrom);
SqlParameter paramTo = new SqlParameter("@ToDate", FCT.To);
cmd.Parameters.Add(paramTo);
SqlParameter paramID = new SqlParameter("@ID", FCT.ID);
cmd.Parameters.Add(paramID);
con.Open();
cmd.ExecuteNonQuery();
return(FCT.ID);
}
}
else
{
return(0);
}
}
private FCRow ProtectDatabaseFC(FCRow fcr)
{
return(fcr);
}
