public ProjectPurchasedItemModel AddProjectPurchasedItem([FromBody] ProjectPurchasedItemModel project)
{
Response.StatusCode = 201;
string result = ProjectPurchasedItemService.AddProjectPurchasedItem(project, dbConn);
project.Id = Convert.ToInt32(result);
return(project);
}
public static string AddProjectPurchasedItem(ProjectPurchasedItemModel projectPurchasedItem, string connstring)
{
try
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@ProjectId", projectPurchasedItem.ProjectId);
spParams.Add("@PurchasedItem", projectPurchasedItem.PurchasedItem);
spParams.Add("@DatePurchased", projectPurchasedItem.DatePurchased);
spParams.Add("@ItemCost", projectPurchasedItem.ItemCost);
return(DBAccess.ExecuteSQLScalar(connstring, "CALL usp_AddPurchasedItemToProject(@ProjectId, @PurchasedItem, @DatePurchased, @ItemCost)", spParams));
}
catch (Exception)
{
return("An error occurred");
}
}
public string UpdateProjectPurchasedItem([FromRoute] int id, [FromBody] ProjectPurchasedItemModel project)
{
return(ProjectPurchasedItemService.UpdateProjectPurchasedItem(project, dbConn));
}
