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