public Response SetNewService(ServicePost service)
{
var result = RunInsertJson(service.images);
if (result.valid)
{
var procedure = "sp_service_set";
using (var conn = new MySqlConnection(_connectionString))
{
try
{
conn.Open();
var param = new DynamicParameters();
param.Add("INname", service.name);
param.Add("INdescription", service.description);
param.Add("INcontent", service.content);
param.Add("INurl", service.url);
param.Add("INserviceTypeId", service.serviceTypeId);
var data = conn.QueryFirstOrDefault <Response>(procedure, param, commandType: System.Data.CommandType.StoredProcedure);
return(data);
}
catch (Exception ex)
{
throw;
}
}
}
else
{
return(null);
}
}
public ServicePostComment()
{
_svcPost = new ServicePost();
// Configurare AutoMapper
config = new MapperConfiguration(
cfg => {
cfg.CreateMap <Post, PostDTO>();
cfg.CreateMap <Comment, CommentDTO>();
});
iMapper = config.CreateMapper();
}
public IActionResult SetService([FromBody] ServicePost service)
{
if (!Request.Headers.ContainsKey("Authorization"))
{
return(Unauthorized());
}
var data = _alphahomeService.SetNewService(service);
if (data.valid)
{
return(new JsonResult(data));
}
return(BadRequest(data));
}
public IActionResult Post([FromBody] ServicePost service)
{
if (service == null)
{
return(new BadRequestObjectResult(service));
}
int insertedId = serviceRepository.AddNew(service);
if (insertedId >= 0)
{
return(new OkObjectResult(insertedId));
}
else
{
return(new BadRequestResult());
}
}
/// <summary>
/// Add a service
/// </summary>
/// <param name="service"></param>
/// <returns></returns>
public int AddNew(ServicePost service)
{
// First Check to make sure input values are valid
// rules:
// service.name != null
if (service.Name == null)
{
return(-1);
}
// name not > 50 or empty
if (service.Name.Length > 50 || service.Name == "")
{
return(-1);
}
// no duplicate values
if (GetByName(service.Name) != null)
{
return(-1);
}
using (IDbConnection dbConnection = Connection)
{
// insert new record into database with params & return inserted id
string sqlQueryAddNew = "INSERT INTO Service(Name) "
+ "OUTPUT INSERTED.ServiceId "
+ "VALUES(@Name);";
dbConnection.Open();
try
{
// insert record and return inserted id
return(dbConnection.Query <int>(sqlQueryAddNew, service).SingleOrDefault());
}
catch (Exception e)
{
throw e;
}
}
}
public PostController()
{
ServicePost = new ServicePost();
ServiceAdmUser = new ServiceAdmUser();
}
public Response SetNewService(ServicePost service)
{
return _alphahomeRepo.SetNewService(service);
}
public PostsController(ServicePost servicePost)
{
_servicePost = servicePost;
}