ASP.NET

feelblue87 wrote:

Request Method: GET

feelblue87 wrote:

C#

string SQLCommand = "UPDATE [dbo].[M_EMP_MASTER] ";
SQLCommand = SQLCommand + "SET ";
SQLCommand = SQLCommand + "[EMP_GENDER] = '" + TempValue + "' ";
SQLCommand = SQLCommand + "WHERE [EMP_CODE] = '" + _EmpCode + "'";

[HttpPut]
[Route("api/PutEmployeeGenderEmpCode/{_EmpCode}")]
public void PutEmployeeGenderEmpCode(string _EmpCode)
{
    const string SQLCommand = "UPDATE [dbo].[M_EMP_MASTER] SET [EMP_GENDER] = @EmpGender WHERE [EMP_CODE] = @EmpCode";
    
    string TempValue = "1";
    
    using (var conn = new SqlConnection(ConnectionString))
    using (var cmd2 = new SqlCommand(SQLCommand, conn))
    {
        cmd2.Parameters.AddWithValue("@EmpGender", TempValue);
        cmd2.Parameters.AddWithValue("@EmpCode", _EmpCode);
        
        CheckConnectionStatus(conn);
        
        conn.Open();
        cmd2.ExecuteNonQuery();
    }
}

[Route("[controller]")]
[ApiController]
public class MyController : ControllerBase
{
    [HttpGet("{id:int}")] // GET /MyController/1
    public ActionResult<Actuator> GetAValue(int id)
    {
        ...
    }
}

[Produces("application/json")]
[Route("api/[controller]")]
[ApiController]
public class MyController : ControllerBase
{
  [HttpGet("GetWarehousesKv/{vendorId}")]
  public async Task<List<KeyValue>> GetWarehousesKv(string vendorId)
  {
     return await myRepository.GetWarehousesKv(vendorId);<br />
  }
}

MadDashCoder wrote:

I did not mention MVC or Web Form