public IActionResult Update([Bind("Id,Name,Sponsor,Type,Status,StartDate,EndDate,Description,Cost,Interested")]
PlanUpload plan)
{
if (ModelState.IsValid)
{
_planRepository.Update(plan);
return(Ok());
}
return(BadRequest());
}
public IActionResult Insert(
[Bind("Name,Sponsor,Type,Status,StartDate,EndDate,Description,Cost,Interested")]
PlanUpload plan)
{
if (ModelState.IsValid)
{
var result = _planRepository.Insert(plan);
var lastType = result ? _planRepository.GetLastInserted() : null;
var uri = Url.Action("Get", new { id = lastType.Id });
return(Created(uri, lastType));
}
return(BadRequest());
}
public bool Update(PlanUpload item)
{
using (IDbConnection db = new SqlConnection(ConnectionString))
{
if (db.State == ConnectionState.Closed)
{
db.Open();
}
DateTime?start = validConvertDate(item.StartDate);
DateTime?end = validConvertDate(item.EndDate);
string SQL = @"UPDATE plans SET
name = @Name,
id_user = @IdSponsor,
id_type = @IdTypePlan,
id_status = @IdStatus,
description = @Description,
cost = @Cost,
start_date = @StartDate,
end_date = @EndDate
WHERE id = @Id";
int result = db.Execute(SQL, new
{
Name = item.Name,
IdSponsor = item.Sponsor,
IdStatus = item.Status,
IdTypePlan = item.Type,
Description = item.Description,
Cost = item.Cost,
StartDate = start,
EndDate = end,
Id = item.Id
});
if (!String.IsNullOrEmpty(item.Interested))
{
result += AlterInterested(item.Interested, item.Id);
}
return(result > 0);
}
}
public bool Insert(PlanUpload item)
{
using (IDbConnection db = new SqlConnection(ConnectionString))
{
if (db.State == ConnectionState.Closed)
{
db.Open();
}
var results = db.Execute("sp_insert_plans", new
{
Name = item.Name,
IdSponsor = item.Sponsor,
IdType = item.Type,
IdStatus = item.Status,
InterestedUser = item.Interested,
Description = item.Description,
Costs = item.Cost,
StartDate = validConvertDate(item.StartDate),
EndDate = validConvertDate(item.EndDate)
}, commandType: CommandType.StoredProcedure);
return(results > 0);
}
}