public ActionResponse Add(ProjectDocumentModel model)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
try
{
IMessageHelper mHelper;
var project = unitWork.ProjectRepository.GetByID(model.ProjectId);
if (project == null)
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetNotFound("Project");
return(response);
}
var newProjectDocument = unitWork.ProjectDocumentRepository.Insert(new EFProjectDocuments()
{
Project = project,
DocumentTitle = model.DocumentTitle,
DocumentUrl = model.DocumentUrl
});
response.ReturnedId = newProjectDocument.ProjectId;
unitWork.Save();
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
}
public IActionResult AddProjectDocument([FromBody] ProjectDocumentModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
string userIdVal = User.FindFirst(ClaimTypes.NameIdentifier)?.Value;
int userId = 0;
if (!string.IsNullOrEmpty(userIdVal))
{
userId = Convert.ToInt32(userIdVal);
}
if (userId == 0)
{
return(BadRequest("Unauthorized user access to api"));
}
var response = projectService.AddProjectDocument(model, userId);
if (!response.Success)
{
return(BadRequest(response.Message));
}
return(Ok(true));
}
public ProjectDocumentModel Post([FromBody] ProjectDocumentModel projectDoc)
{
Response.StatusCode = 201;
string result = ProjectDocumentService.AddProjectDocument(projectDoc, dbConn);
projectDoc.Id = Convert.ToInt32(result);
return(projectDoc);
}
public static string AddProjectDocument(ProjectDocumentModel projectDocument, string connstring)
{
try
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@ProjectId", projectDocument.ProjectId);
spParams.Add("@DocName", projectDocument.DocName);
spParams.Add("@FilePath", projectDocument.FilePath);
return(DBAccess.ExecuteSQLScalar(connstring, "CALL usp_AddDocumentToProject(@ProjectId, @DocName, @FilePath)", spParams));
}
catch (Exception)
{
return("An error occurred");
}
}
public ActionResponse Update(int id, ProjectDocumentModel model)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
var projectDocumentObj = unitWork.ProjectDocumentRepository.Get(f => f.Id.Equals(id));
if (projectDocumentObj == null)
{
IMessageHelper mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetNotFound("Project Document");
return(response);
}
projectDocumentObj.DocumentTitle = model.DocumentTitle;
projectDocumentObj.DocumentUrl = model.DocumentUrl;
unitWork.ProjectDocumentRepository.Update(projectDocumentObj);
unitWork.Save();
response.Message = "1";
return(response);
}
}
