public async Task UpdateCategory(CategoryRequestDTO request)
{
var requestClient = JsonSerializer.Serialize <CategoryRequestDTO>(request);
HttpContent content = new StringContent(requestClient, Encoding.UTF8, "application/json");
var httpResponse = await _httpClient.PutAsync($"{_configure.Url}Category", content);
if (!httpResponse.IsSuccessStatusCode)
{
throw new Exception("Cannot retrieve tasks");
}
}
public IActionResult Save(CategoryRequestDTO request)
{
if (request.Id > 0)
{
_service.UpdateCategory(request);
}
else
{
_service.CreateCategory(request);
}
return(RedirectToAction("Index"));
}
public object UpdateCategory([FromBody] CategoryRequestDTO categoryData)
{
string token = Request.Headers.Authorization == null ? "" : Request.Headers.Authorization.ToString();
Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), JsonConvert.SerializeObject(categoryData), Level.INFO);
ResponseDTO Response = new ResponseDTO();
ErrorDTO ErrorResponse = new ErrorDTO();
CategoryDTO UserResponse = new CategoryDTO();
Response = CategoryBUS.AddOrUpdateCategory(categoryData);
return(Response);
}
public static ResponseDTO AddOrUpdateCategory(CategoryRequestDTO categoryData)
{
ErrorDTO ErrorResponse = new ErrorDTO();
ResponseDTO Response = new ResponseDTO();
SqlConnection con = connection.loadDB();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = categoryData.id == null ? "AddCategoryData" : "UpdateCategoryData";
if (categoryData.id != null)
{
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "ID";
param1.SqlDbType = SqlDbType.Int;
param1.Value = categoryData.id;
cmd.Parameters.Add(param1);
}
SqlParameter param6 = new SqlParameter();
param6.ParameterName = "Name";
param6.SqlDbType = SqlDbType.NVarChar;
param6.Value = categoryData.name != "" ? categoryData.name : "";
cmd.Parameters.Add(param6);
SqlParameter param2 = new SqlParameter();
param2.ParameterName = "Title";
param2.SqlDbType = SqlDbType.NVarChar;
param2.Value = categoryData.title != "" ? categoryData.title : "";
cmd.Parameters.Add(param2);
SqlParameter param3 = new SqlParameter();
param3.ParameterName = "Code";
param3.SqlDbType = SqlDbType.NVarChar;
param3.Value = categoryData.code != "" ? categoryData.code : "";
cmd.Parameters.Add(param3);
try
{
cmd.ExecuteNonQuery();
Response.Data = categoryData.id == null ? "CREATED" : "UPDATED";
}
catch (Exception ex)
{
ErrorResponse.Code = 400;
ErrorResponse.Message = ex.ToString();
Response.Error = ErrorResponse;
}
finally
{
con.Close();
}
return(Response);
}
