public ActionResult <Company> Add(Guid userId, [FromForm] CompanyForAddResource companyForAddDto)
{
_repo.Add(userId, companyForAddDto);
var data = _repo.GetList(userId);
return(Ok(new { data }));
}
public void Add(Guid userId, CompanyForAddResource companyForAddDto)
{
var Today = String.Format("{0:s}", DateTime.Now);
var companyId = Guid.NewGuid();
var SqlQuery = @"INSERT INTO companies (id, name, description, created_by, date_created)
VALUES (@companyId, @name, @description, @userId, @Today)";
Execute(SqlQuery, new
{
companyId,
companyForAddDto.name,
companyForAddDto.description,
userId,
Today
});
SqlQuery = @"INSERT INTO enrolment (user_id, company_id, is_active, date_added)
VALUES (@userId, @companyId, 1, @Today)";
Execute(SqlQuery, new
{
userId,
companyId,
Today
});
}
