// POST api/<controller> public string Post([FromBody] createStudent value) { _conn = new SqlConnection("Data Source=.;Initial Catalog=Store;Integrated Security=True"); var query = "insert into student (f_name, m_name, l_name, address, birthdate, score) values(@f_name, @m_name, @l_name, @address, @birthDate, @score)"; SqlCommand insertCommand = new SqlCommand(query, _conn); insertCommand.Parameters.AddWithValue("@f_name", value.f_name); insertCommand.Parameters.AddWithValue("@m_name", value.m_name); insertCommand.Parameters.AddWithValue("@l_name", value.l_name); insertCommand.Parameters.AddWithValue("@address", value.address); insertCommand.Parameters.AddWithValue("@birthdate", value.birthDate); insertCommand.Parameters.AddWithValue("@score", value.score); _conn.Open(); int result = insertCommand.ExecuteNonQuery(); if (result > 0) { return("true"); } else { return("false"); } }
// PUT api/<controller>/5 public string Put(int id, [FromBody] createStudent value) { conn = new SqlConnection("data source=DESKTOP-3CTJ57L\\SQLEXPRESS; Initial catalog=SampleDB; user id=sa; password=orangejuice;"); var query = "Update Student set Id=@Id,FullName=@FullName,Course=@Course,ContactNumber=@ContactNumber where Id=" + id; SqlCommand insertCommand = new SqlCommand(query, conn); insertCommand.Parameters.AddWithValue("@Id", value.Id); insertCommand.Parameters.AddWithValue("@FullName", value.FullName); insertCommand.Parameters.AddWithValue("@Course", value.Course); insertCommand.Parameters.AddWithValue("@ContactNumber", value.ContactNumber); conn.Open(); int result = insertCommand.ExecuteNonQuery(); if (result > 0) { return("True"); } else { return("False"); } }
// POST api/<controller> public string Post([FromBody] createStudent value) { conn = new SqlConnection("data source=DESKTOP-3CTJ57L\\SQLEXPRESS; Initial catalog=SampleDB; user id=sa; password=orangejuice;"); var query = "insert into Student(Id,FullName,Course,ContactNumber) values(@Id,@FullName,@Course,@ContactNumber)"; SqlCommand insertCommand = new SqlCommand(query, conn); insertCommand.Parameters.AddWithValue("@Id", value.Id); insertCommand.Parameters.AddWithValue("@FullName", value.FullName); insertCommand.Parameters.AddWithValue("@Course", value.Course); insertCommand.Parameters.AddWithValue("@ContactNumber", value.ContactNumber); conn.Open(); int result = insertCommand.ExecuteNonQuery(); if (result > 0) { return("Inserted "); } else { return("Not Inserted"); } }