public IActionResult createDisplay(createDisplay createDisplay)
{
try
{
List <createDisplay> displayList = new List <createDisplay>();
if (createDisplay.name == "" || createDisplay.name == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter Name" }));
}
else if (createDisplay.markerType == "" || createDisplay.markerType == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter markerType" }));
}
else if (createDisplay.createdBy <= 0 || createDisplay.createdBy == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter createdBy" }));
}
DataSet ds = Data.Display.createDisplay(createDisplay);
string Response = ds.Tables[0].Rows[0]["SuccessMessage"].ToString();
if (Response == "Success")
{
string displayId = ds.Tables[1].Rows[0]["displayId"].ToString();
return(StatusCode((int)HttpStatusCode.OK, new { displayId, message = "Display Created successfully" }));
}
else
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Error while creating the Display" }));
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("createDisplay", e.Message);
if (e.Message.Contains("UQ__tblDispl__E0DD8006C302141D") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Display already created" }));
}
else
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message }));
}
}
}
public static DataSet createDisplay(createDisplay createDisplay)
{
try
{
List <SqlParameter> parameters = new List <SqlParameter>();
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("@createdBy", createDisplay.createdBy));
parameters.Add(new SqlParameter("@markerUrl", createDisplay.markerUrl));
parameters.Add(new SqlParameter("@action", "add"));
string ConnectionString = Common.GetConnectionString();
using (DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spSaveDisplay", parameters.ToArray()))
{
return(ds);
}
}
catch (Exception e)
{
throw e;
}
}
