public string PUT(tblTestEmployee emp) { try { DataTable table = new DataTable(); string query = @" UPDATE tblTestEmployee SET EmployeeName = '" + emp.EmployeeName + @"' ,Department = '" + emp.Department + @"' ,MailID = '" + emp.MailID + @"' ,DOJ = '" + emp.DOJ + @"' WHERE EmployeeID = " + emp.EmployeeID + @""; using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["EmployeeAppDB"].ConnectionString)) using (var cmd = new SqlCommand(query, con)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(table); } return("update Successfully"); } catch (Exception ex) { HttpResponseMessage httpResponseMessage = new HttpResponseMessage(HttpStatusCode.BadRequest); httpResponseMessage.Content = new StringContent(ex.Message); throw new HttpResponseException(httpResponseMessage); //return "update failed"; } }
public string POST(tblTestEmployee emp) { try { DataTable table = new DataTable(); string query = @" insert into tblTestEmployee (EmployeeName, Department, MailID, DOJ) values ( '" + emp.EmployeeName + "'," + "'" + emp.Department + "'," + "'" + emp.MailID + "'," + "'" + emp.DOJ + "')"; using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["EmployeeAppDB"].ConnectionString)) using (var cmd = new SqlCommand(query, con)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(table); } return("Employee Added Successfully"); } catch (Exception ex) { HttpResponseMessage httpResponseMessage = new HttpResponseMessage(HttpStatusCode.BadRequest); httpResponseMessage.Content = new StringContent(ex.Message); throw new HttpResponseException(httpResponseMessage); } }