public void Update(WbsDictionary wbsDictionary)
{
var sql = @"UPDATE [dbo].[WbsDictionaries]
SET [WbsDictionaryTitle] = @WbsDictionaryTitle,
[CreatedBy] = @CreatedBy,
[CreatedOn] = @CreatedOn
WHERE WbsDictionaryGuid=@WbsDictionaryGuid";
_context.Connection.Execute(sql, wbsDictionary);
}
public void Add(WbsDictionary wbsDictionary)
{
var sql = @"INSERT INTO [WbsDictionaries]
([ProjectNumber]
,[WbsNumber]
,[WbsDictionaryTitle]
,[CreatedBy]
,[CreatedOn])
VALUES
(@ProjectNumber,
@WbsNumber,
@wbsDictionaryTitle,
@CreatedBy,
@CreatedOn)";
_context.Connection.Execute(sql, wbsDictionary);
}
public IActionResult Add([FromBody] WbsDictionaryViewModel model)
{
try
{
var wbsDictionary = new WbsDictionary
{
ProjectNumber = model.ProjectNumber,
CreatedBy = GetUserGuid(),
WbsNumber = model.WbsNumber,
WbsDictionaryTitle = model.WbsDictionaryTitle,
CreatedOn = DateTime.Now
};
_wbsDictionaryService.Add(wbsDictionary);
return(Json(new { status = true }));
}
catch (Exception ex)
{
ModelState.Clear();
ModelState.AddModelError("", ex.Message);
return(BadRequestFormatter.BadRequest(this, ex));
}
}
public void Update(WbsDictionary wbsDictionary)
{
_wbsDictionaryRepository.Update(wbsDictionary);
}
public void Add(WbsDictionary wbsDictionary)
{
_wbsDictionaryRepository.Add(wbsDictionary);
}
