public IActionResult AddProjectFunder([FromBody] ProjectFunderModel 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"));
}
int organizationId = 0;
var organizationIdVal = User.FindFirst(ClaimTypes.Country)?.Value;
if (!string.IsNullOrEmpty(organizationIdVal))
{
organizationId = Convert.ToInt32(organizationIdVal);
}
model.ProjectUrl = projectUrl;
var response = projectService.AddProjectFunder(model, organizationId, userId);
if (!response.Success)
{
return(BadRequest(response.Message));
}
return(Ok(response));
}
public ProjectFunderModel PostProjectFunder([FromBody] ProjectFunderModel projectFunder)
{
Response.StatusCode = 201;
string result = ProjectFunderService.AddProjectFunder(projectFunder, dbConn);
projectFunder.Id = Convert.ToInt32(result);
return(projectFunder);
}
public IActionResult RemoveFunder([FromBody] ProjectFunderModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var response = projectFunderService.RemoveFunder(model);
if (!response.Success)
{
return(BadRequest(response.Message));
}
return(Ok("1"));
}
public static string AddProjectFunder(ProjectFunderModel projectFunder, string connstring)
{
try
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@ProjectId", projectFunder.ProjectId);
spParams.Add("@FunderId", projectFunder.FunderId);
spParams.Add("@AmountFunded", projectFunder.AmountFunded);
return(DBAccess.ExecuteSQLScalar(connstring, "CALL usp_AddFunderToProject(@ProjectId, @FunderId, @AmountFunded)", spParams));
}
catch (Exception)
{
return("An error occurred");
}
}
public ActionResponse Add(ProjectFunderModel model)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
try
{
IMessageHelper mHelper = new MessageHelper();
var project = unitWork.ProjectRepository.GetByID(model.ProjectId);
if (project == null)
{
response.Success = false;
response.Message = mHelper.GetNotFound("Project");
return(response);
}
var funder = unitWork.OrganizationRepository.GetByID(model.FunderId);
if (funder == null)
{
response.Success = false;
response.Message = mHelper.GetNotFound("Organization/Funder");
return(response);
}
var newProjectFunder = unitWork.ProjectFundersRepository.Insert(new EFProjectFunders()
{
Project = project,
Funder = funder,
Amount = model.Amount,
Currency = model.Currency,
ExchangeRate = model.ExchangeRate
});
response.ReturnedId = newProjectFunder.FunderId;
unitWork.Save();
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
}
public ActionResponse RemoveFunder(ProjectFunderModel model)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
var projectFunder = unitWork.ProjectFundersRepository.Get(pf => pf.FunderId.Equals(model.FunderId) && pf.ProjectId.Equals(model.ProjectId));
if (projectFunder == null)
{
IMessageHelper mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetNotFound("Project Funder");
return(response);
}
unitWork.ProjectFundersRepository.Delete(projectFunder);
unitWork.Save();
response.Message = "1";
return(response);
}
}
public ActionResponse Add(ProjectFunderModel model)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
try
{
/*IMessageHelper mHelper = new MessageHelper();
* var project = unitWork.ProjectRepository.GetByID(model.ProjectId);
* if (project == null)
* {
* response.Success = false;
* response.Message = mHelper.GetNotFound("Project");
* return response;
* }
*
* var funder = unitWork.OrganizationRepository.GetByID(model.FunderId);
* if (funder == null)
* {
* response.Success = false;
* response.Message = mHelper.GetNotFound("Organization/Funder");
* return response;
* }
*
* var newProjectFunder = unitWork.ProjectFundersRepository.Insert(new EFProjectFunders()
* {
* Project = project,
* Funder = funder,
* });
* response.ReturnedId = newProjectFunder.FunderId;
* unitWork.Save();*/
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
}
