public HttpResponseMessage Post([Bind(Exclude = "Id")][FromBody] OpportunityTechnology entity)
{
try
{
if (ModelState.IsValid)
{
OpportunityTechnologyRepository rep = new OpportunityTechnologyRepository();
Validate repValid = rep.ValidateInsert(entity);
if (repValid.IsValid)
{
rep.Insert(entity);
return(Request.CreateResponse(HttpStatusCode.OK, "Operação efetuada com sucesso!"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, repValid.Message));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public DataTable GetExist(OpportunityTechnology entity)
{
string query = "SELECT Id, Weight, IdOpportunity, IdTechnology FROM " + TableName + " WHERE IdOpportunity = " + entity.IdOpportunity + " AND IdTechnology = " + entity.IdTechnology;
if (entity.Id > 0)
{
query = "SELECT Id, Weight, IdOpportunity, IdTechnology FROM " + TableName + " WHERE Id <> " + entity.Id + " AND IdOpportunity = " + entity.IdOpportunity + " AND IdTechnology = " + entity.IdTechnology;
}
return(ExecuteSelect(query));
}
public Validate ValidateInsert(OpportunityTechnology entity)
{
Validate valid = new Validate();
if (entity.IdOpportunity > 0 && entity.IdTechnology > 0)
{
DataTable dt = GetExist(entity);
valid.IsValid = !(dt.Rows.Count > 0);
valid.Message = !valid.IsValid ? "Já existe um item para a mesma vaga e mesma tecnologia." : "Item não encontrado";
}
return(valid);
}
public void Update(OpportunityTechnology entity)
{
string query = "UPDATE " + TableName + " SET Weight = " + entity.Weight + ", IdOpportunity = " + entity.IdOpportunity + ", IdTechnology = " + entity.IdTechnology + " WHERE Id = " + entity.Id;
ExecuteCommand(query);
}
public void Insert(OpportunityTechnology entity)
{
string query = "INSERT INTO " + TableName + " (Weight, IdOpportunity, IdTechnology) VALUES (" + entity.Weight + ", " + entity.IdOpportunity + ", " + entity.IdTechnology + ")";
ExecuteCommand(query);
}
