public static string UpdateProjectOfficer(ProjectOfficerModel projectofficer, string connstring)
{
try
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@Id", projectofficer.Id);
spParams.Add("@FirstName", projectofficer.FirstName);
spParams.Add("@LastName", projectofficer.LastName);
spParams.Add("@Tel", projectofficer.Tel);
spParams.Add("@Mobile", projectofficer.Mobile);
spParams.Add("@Address1", projectofficer.Address1);
spParams.Add("@Address2", projectofficer.Address2);
spParams.Add("@Address3", projectofficer.Address3);
spParams.Add("@Town", projectofficer.Town);
spParams.Add("@County", projectofficer.County);
spParams.Add("@PostCode", projectofficer.PostCode);
spParams.Add("@Info", projectofficer.Info);
spParams.Add("@Email", projectofficer.Email);
return(DBAccess.ExecuteSQLNonQuery(connstring, "CALL usp_UpdateProjectOfficer(@Id, @FirstName, @LastName, @Tel, @Mobile, @Address1, @Address2, @Address3, @Town, @County, @PostCode, @Info, @Email)", spParams));
}
catch (Exception)
{
return("An error occurred");
}
}
public ProjectOfficerModel Post([FromBody] ProjectOfficerModel projectofficer)
{
Response.StatusCode = 201;
string result = ProjectOfficerService.CreateProjectOfficer(projectofficer, dbConn);
projectofficer.Id = Convert.ToInt32(result);
return(projectofficer);
}
public static string CreateProjectOfficer(ProjectOfficerModel projectofficer, string connstring)
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@FirstName", projectofficer.FirstName);
spParams.Add("@LastName", projectofficer.LastName);
spParams.Add("@Tel", projectofficer.Tel);
spParams.Add("@Mobile", projectofficer.Mobile);
spParams.Add("@Address1", projectofficer.Address1);
spParams.Add("@Address2", projectofficer.Address2);
spParams.Add("@Address3", projectofficer.Address3);
spParams.Add("@Town", projectofficer.Town);
spParams.Add("@County", projectofficer.County);
spParams.Add("@PostCode", projectofficer.PostCode);
spParams.Add("@Info", projectofficer.Info);
spParams.Add("@Email", projectofficer.Email);
return(DBAccess.ExecuteSQLScalar(connstring, "CALL usp_InsertProjectOfficer(@FirstName, @LastName, @Tel, @Mobile, @Address1, @Address2, @Address3, @Town, @County, @PostCode, @Info, @Email)", spParams));
}
public string UpdateProjectOfficer([FromRoute] int id, [FromBody] ProjectOfficerModel projectofficer)
{
return(ProjectOfficerService.UpdateProjectOfficer(projectofficer, dbConn));
}
