The value ‘Capturetest1.png’ is not valid for Imagedata.
The value ‘Capturetest2.png’ is not valid for Imagesol.
Not able to Insert Image data for two images
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Create([Bind("Sno,No,Topic,QuestionTitle,Opt1,Opt2,Opt3,Opt4,Answer,Time,Correct,Solution,Imagedata,Imagesol")] Question question, IFormFile imagedata, IFormFile imagesol)
{
if (imagedata != null)
{
if (imagedata.Length > 0)
{
using (var target = new MemoryStream())
{
imagedata.CopyTo(target);
question.Imagedata = target.ToArray();
}
}
}
if (imagesol != null)
{
if (imagesol.Length > 0)
{
using (var target = new MemoryStream())
{
imagesol.CopyTo(target);
question.Imagesol = target.ToArray();
}
}
}
if (ModelState.IsValid)
{
_context.Add(question);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(question);
}
@model Quizcrud.Models.Question
@{
ViewData["Title"] = "Create";
}
<h1>Create</h1>
<h4>Question</h4>
<hr />
<div class="row">
<div class="col-md-4">
<form asp-action="Create">
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<div class="form-group">
<label asp-for="No" class="control-label"></label>
<input asp-for="No" class="form-control" />
<span asp-validation-for="No" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Topic" class="control-label"></label>
<input asp-for="Topic" class="form-control" />
<span asp-validation-for="Topic" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="QuestionTitle" class="control-label"></label>
<input asp-for="QuestionTitle" class="form-control" />
<span asp-validation-for="QuestionTitle" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Opt1" class="control-label"></label>
<input asp-for="Opt1" class="form-control" />
<span asp-validation-for="Opt1" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Opt2" class="control-label"></label>
<input asp-for="Opt2" class="form-control" />
<span asp-validation-for="Opt2" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Opt3" class="control-label"></label>
<input asp-for="Opt3" class="form-control" />
<span asp-validation-for="Opt3" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Opt4" class="control-label"></label>
<input asp-for="Opt4" class="form-control" />
<span asp-validation-for="Opt4" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Answer" class="control-label"></label>
<input asp-for="Answer" class="form-control" />
<span asp-validation-for="Answer" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Time" class="control-label"></label>
<input asp-for="Time" class="form-control" />
<span asp-validation-for="Time" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Correct" class="control-label"></label>
<input asp-for="Correct" class="form-control" />
<span asp-validation-for="Correct" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Solution" class="control-label"></label>
<input asp-for="Solution" class="form-control" />
<span asp-validation-for="Solution" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Imagedata" class="control-label"></label>
<input name="imagedata" type="file" class="form-control" />
<span asp-validation-for="Imagedata" class="text-danger"></span>
</div>
<div class="form-group">
<label asp-for="Imagesol" class="control-label"></label>
<input name="imagesol" type="file" class="form-control" />
<span asp-validation-for="Imagesol" class="text-danger"></span>
</div>
<div class="form-group">
<input type="submit" value="Create" class="btn btn-primary" />
</div>
</form>
</div>
</div>
<div>
<a asp-action="Index">Back to List</a>
</div>
CREATE TABLE public.”Questions” (
“SNo” int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1 NO CYCLE),
“No” int4 NOT NULL,
“Topic” varchar(500) NULL,
“QuestionTitle” varchar(500) NULL,
“Opt1” varchar(50) NULL,
“Opt2” varchar(50) NULL,
“Opt3” varchar(50) NULL,
“Opt4” varchar(50) NULL,
“Answer” varchar(50) NULL,
“Time” int4 NULL,
“Correct” int4 NULL,
solution varchar(500) NULL,
imagedata bytea NULL,
imagesol bytea NULL,
CONSTRAINT pk_n1 PRIMARY KEY (“SNo”)
);
user id :[email protected]
password:test@1234
hERE IS GITHUB
https://github.com/KalyanAllam/Quizcrud
3