public async Task <IActionResult> updateStatus([FromBody] ModelRequest dataRequest)
{
byte status = dataRequest.status;
long idLong = dataRequest.id;
try
{
using (var dbCtx = new VircaContext())
{
var data = await dbCtx.Virca_Orders_Video.Where(item => item.Id == idLong).SingleOrDefaultAsync();
if (data == null)
{
return(Json(new { success = false, msg = "id:" + idLong + ". " + NotFound() + data.ToString() }));
}
else
{
data.Status = status;
await dbCtx.SaveChangesAsync();
return(Json(new { success = true, msg = "" }));
}
}
}
catch (Exception ex)
{
//MvcApplication.getLogger().Error(ex, "AsyncController, updateStatus");
return(Json(new { success = false, msg = ex.Message }));
}
}
public IEnumerable <Virca_Orders_Video> IndexGetList(string order_id)
{
IEnumerable <Virca_Orders_Video> movies;
try
{
using (var context = new VircaContext())
{
if (order_id != "0")
{
movies = context.Virca_Orders_Video
.Where(item => item.No_account == order_id).ToList();
}
else
{
movies = context.Virca_Orders_Video.ToList();
}
ViewBag.TotalFound = "Videos found: " + movies.Count();
}
}
catch (Exception ex)
{
throw ex;
}
return(movies);
}
public async Task <IActionResult> updatePost([FromBody] ModelRequest dataRequest)
{
string comment = "";
comment = dataRequest.comment;
long idLong = dataRequest.id;
try
{
using (var dbCtx = new VircaContext())
{
var data = await dbCtx.Virca_Orders_Video.Where(item => item.Id == idLong).SingleOrDefaultAsync();
if (data == null)
{
return(Json(new { success = false, msg = NotFound() }));
}
else
{
data.Add_info = comment;
await dbCtx.SaveChangesAsync();
return(Json(new { success = true, msg = "" }));
}
}
}
catch (Exception ex)
{
//MvcApplication.getLogger().Error(ex, "AsyncController, updatePost");
return(Json(new { success = false, msg = ex.Message }));
}
}
public async Task <IActionResult> Upload(IFormFile file)
{
string order_num = HttpContext.Request?.Form["OrderNum"];
if (string.IsNullOrEmpty(order_num))
{
order_num = "0";
}
if (file == null || file.Length == 0)
{
return(Content("file not selected"));
}
try
{
if (file.Length > 0)
{
var path = Path.Combine(
Directory.GetCurrentDirectory(), "UploadedFiles",
file.GetFilename());
using (var stream = new FileStream(path, FileMode.Create))
{
await file.CopyToAsync(stream);
}
ViewBag.Message = "File Uploaded Successfully!!";
using (var dbCtx = new VircaContext())
{
var data = await dbCtx.Virca_Orders_Video
.Where(item => item.No_account == order_num && item.Filename == file.FileName)
.SingleOrDefaultAsync();
if (data != null) //if such record exists
{
dbCtx.Virca_Orders_Video.Remove(data);
await dbCtx.SaveChangesAsync();
}
var newItem = new Virca_Orders_Video();
newItem.No_account = order_num;
newItem.Filename = file.FileName;
newItem.Date_pub = DateTime.Now;
newItem.Status = 0;
newItem.Video_id = 0;
dbCtx.Entry(newItem).State = EntityState.Added;
await dbCtx.SaveChangesAsync();
}
}
else
{
ViewBag.Message = "File upload error.";
}
return(RedirectToAction("Upload"));
}
catch
{
ViewBag.Message = "File upload failed!!";
return(View());
}
}