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