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)); }