public string Put(string id, [FromBody] Talous tieto) { String commandText; commandText = "dbo.UpdateTalous"; SqlParameter par1 = new SqlParameter("@Aika", tieto.Aika); SqlParameter par2 = new SqlParameter("@Cus", tieto.Cus); SqlParameter par3 = new SqlParameter("@HevosId", tieto.HevosId); SqlParameter par4 = new SqlParameter("@Kohde", tieto.Kohde); SqlParameter par5 = new SqlParameter("@Liike", tieto.Liike); SqlParameter par6 = new SqlParameter("@Kustannus", tieto.Kustannus); SqlParameter par7 = new SqlParameter("@Selvennys", tieto.Selvennys); SqlParameter[] pars = new SqlParameter[] { par1, par2, par3, par4, par5, par6, par7 }; using (SqlConnection conn = new SqlConnection(DbCon.connectionString)) { using (SqlCommand cmd = new SqlCommand(commandText, conn)) { // There're three command types: StoredProcedure, Text, TableDirect. The TableDirect // type is only for OLE DB. cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddRange(pars); try { conn.Open(); int stat = cmd.ExecuteNonQuery(); return("Muutettu " + stat.ToString() + " rivi"); } catch (Exception exception) { return(exception.Message); } } } }
public Talous[] Get(string id) { Talous[] res = new Talous[503]; int hepo = 0; String commandText = ""; SqlParameter[] pars = new SqlParameter[6]; int k = 1; string[] osat = new string[6]; string[] osat1 = new string[6]; osat1 = id.Split(new char[] { '_' }, 2, StringSplitOptions.RemoveEmptyEntries); if (osat1[0] == "0") { osat = osat1[1].Split(new char[] { '_' }, 2, StringSplitOptions.None); commandText = "dbo.SelectKaikkiTalous"; SqlParameter par1 = new SqlParameter("@Cus", osat[0]); pars = new SqlParameter[] { par1 }; } if (osat1[0] == "1") { osat = osat1[1].Split(new char[] { '_' }, 2, StringSplitOptions.None); hepo = Convert.ToInt32(osat[1]); commandText = "dbo.SelectTalous"; SqlParameter par1 = new SqlParameter("@Cus", osat[0]); SqlParameter par2 = new SqlParameter("@HevosId", hepo); pars = new SqlParameter[] { par1, par2 }; } else if (osat1[0] == "2") { osat = osat1[1].Split(new char[] { '_' }, 2, StringSplitOptions.None); hepo = Convert.ToInt32(osat[1]); commandText = "dbo.SelectLastTalous"; SqlParameter par1 = new SqlParameter("@Cus", osat[0]); SqlParameter par2 = new SqlParameter("@HevosId", hepo); pars = new SqlParameter[] { par1, par2 }; } SqlConnection conn = new SqlConnection(DbCon.connectionString); // When the direction of parameter is set as Output, you can get the value after // executing the command. using (SqlCommand cmd = new SqlCommand(commandText, conn)) { cmd.Parameters.AddRange(pars); cmd.CommandType = CommandType.StoredProcedure; conn.Open(); // When using CommandBehavior.CloseConnection, the connection will be closed when the // IDataReader is closed. SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Talous tieto = new Talous { Id = (int)reader["Id"], Cus = (string)reader["Cus"], Aika = (DateTime)reader["Aika"], HevosId = (int)reader["HevosId"], Kohde = (string)reader["Kohde"], Liike = (string)reader["Liike"], Kustannus = (double)reader["Kustannus"], Selvennys = (string)reader["Selvennys"] }; res[k++] = tieto; if (k == 500) { break; } } Talous pituus = new Talous { Id = k - 1, Cus = "", Aika = DateTime.MinValue, HevosId = 0, Kohde = "", Liike = "", Kustannus = 0, Selvennys = "", }; res[0] = pituus; } else { Talous tieto = new Talous { Id = 0, HevosId = 0 }; res[0] = tieto; } Array.Resize <Talous>(ref res, k + 3); return(res); } }