public FunderModel Post([FromBody] FunderModel funder)
{
Response.StatusCode = 201;
string result = FunderService.CreateFunder(funder, dbConn);
funder.Id = Convert.ToInt32(result);
return(funder);
}
public Funders Funder(FunderModel model)
{
return(new Funders
{
Name = model.Name,
Partners = null
});
}
public static string CreateFunder(FunderModel funder, string connstring)
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@Name", funder.Name);
spParams.Add("@Address1", funder.Address1);
spParams.Add("@Address2", funder.Address2);
spParams.Add("@Address3", funder.Address3);
spParams.Add("@Town", funder.Town);
spParams.Add("@County", funder.County);
spParams.Add("@PostCode", funder.PostCode);
spParams.Add("@Tel", funder.Tel);
spParams.Add("@MainContact", funder.MainContact);
spParams.Add("@Amount", funder.Amount);
return(DBAccess.ExecuteSQLScalar(connstring, "CALL usp_InsertFunder(@Name, @Address1, @Address2, @Address3, @Town, @County, @PostCode, @Tel, @MainContact, @Amount)", spParams));
}
public static string UpdateFunder(FunderModel funder, string connstring)
{
try
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@Id", funder.Id);
spParams.Add("@Name", funder.Name);
spParams.Add("@Address1", funder.Address1);
spParams.Add("@Address2", funder.Address2);
spParams.Add("@Address3", funder.Address3);
spParams.Add("@Town", funder.Town);
spParams.Add("@County", funder.County);
spParams.Add("@PostCode", funder.PostCode);
spParams.Add("@Tel", funder.Tel);
spParams.Add("@MainContact", funder.MainContact);
spParams.Add("@Amount", funder.Amount);
return(DBAccess.ExecuteSQLNonQuery(connstring, "CALL usp_UpdateFunder(@Id, @Name, @Address1, @Address2, @Address3, @Town, @County, @PostCode, @Tel, @MainContact, @Amount)", spParams));
}
catch (Exception)
{
return("An error occurred");
}
}
public string UpdateFunder([FromRoute] int id, [FromBody] FunderModel funder)
{
return(FunderService.UpdateFunder(funder, dbConn));
}
