public IActionResult updateDisplay(updateDisplay createDisplay)
{
try
{
List <createDisplay> displayList = new List <createDisplay>();
if (createDisplay.displayId <= 0 || createDisplay.displayId == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter displayId" }));
}
int row = Data.Display.updateDisplay(createDisplay);
if (row > 0)
{
return(StatusCode((int)HttpStatusCode.OK, "Updated Successfully"));
}
else
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Error while Updating the Display" }));
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("updateDisplay", e.Message);
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message }));
}
}
public static int updateDisplay(updateDisplay createDisplay)
{
try
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@displayId", createDisplay.displayId));
parameters.Add(new SqlParameter("@name", createDisplay.name));
parameters.Add(new SqlParameter("@notes", createDisplay.notes));
parameters.Add(new SqlParameter("markerType", createDisplay.markerType));
parameters.Add(new SqlParameter("@isPrivate", createDisplay.isPrivate));
parameters.Add(new SqlParameter("@longitude", createDisplay.longitude));
parameters.Add(new SqlParameter("@latitude", createDisplay.latitude));
parameters.Add(new SqlParameter("@country", createDisplay.country));
parameters.Add(new SqlParameter("@state", createDisplay.state));
parameters.Add(new SqlParameter("@cityName", createDisplay.cityName));
parameters.Add(new SqlParameter("@address", createDisplay.address));
parameters.Add(new SqlParameter("@filePath", createDisplay.filePath));
parameters.Add(new SqlParameter("@markerUrl", createDisplay.markerUrl));
string ConnectionString = Common.GetConnectionString();
int rowsAffected = SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "spSaveDisplay", parameters.ToArray());
return(rowsAffected);
}
catch (Exception e)
{
throw e;
}
}
