public async Task <IActionResult> PlanningOfficeDeleteByIdAsync(int id)
{
var req = new PlanningOfficeDeleteByIdRequest
{
Id = id,
CurrentUser = User.CurrentUserName()
};
var result = await _planningOfficeManager.DeletePlanningOfficeByIdAsync(req);
return(Ok(result));
}
public async Task <PlanningOfficeDeleteByIdResponse> DeletePlanningOfficeByIdAsync(PlanningOfficeDeleteByIdRequest req)
{
req.UpdatedDate = DateTime.Today;
return(await _repos.DeletePlanningOfficeByIdAsync(req));
}
public async Task <PlanningOfficeDeleteByIdResponse> DeletePlanningOfficeByIdAsync(PlanningOfficeDeleteByIdRequest req)
{
using (var conn = new SqlConnection(_connectionSettings.DefaultConnection))
{
var result = new PlanningOfficeDeleteByIdResponse();
const string storeproc = @"[dbo].[uspPlanningOfficesDelete_New]";
await conn.OpenAsync();
var dynParm = new
{
ID = req.Id,
LastUpdatedBy = req.CurrentUser,
LastModifiedDate = req.UpdatedDate
};
await conn.ExecuteAsync(storeproc, dynParm, null, null, CommandType.StoredProcedure);
return(result);
}
}
