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