public async Task <IActionResult> Edit(string action, string member_code, string course_code, DateTime course_begin, int course_day) { var cdate = course_begin.AddDays(course_day - 1); try { if (action.Equals("add")) { var c = new project_daily_checklist(); c.member_code = member_code; c.course_code = course_code; c.course_date = cdate; c.x_status = "Y"; _context.Add(c); } else if (action.Equals("del")) { var c = _context.project_daily_checklist.SingleOrDefault(d => (d.member_code == member_code) && (d.course_code == course_code) && (d.course_date == cdate)); _context.Remove(c); } await _context.SaveChangesAsync(); } catch (Exception) { return(Json(new { result = "fail" })); } return(Json(new { result = "success" })); }
public async Task <IActionResult> Unregister(string cid, string courseId) { project_course c = _context.project_course.SingleOrDefault(cc => cc.id == new Guid(courseId)); member m = _context.member.SingleOrDefault(mm => mm.cid_card == cid); var cr = await _context.project_course_register.SingleOrDefaultAsync(crr => crr.course_code == c.course_code && crr.member_code == m.member_code); if (cr != null) { if (cr.course_grade != 0) { return(Json(new { result = "pass", cid = cid })); } else { _context.Remove(cr); await _context.SaveChangesAsync(); return(Json(new { result = "success", cid = cid })); } } else { return(Json(new { result = "fail", cid = cid })); } }
public IActionResult Edit(string memberId, string productId, string mem_productId) { var m = _context.member.SingleOrDefault(mb => mb.id == new Guid(memberId)); var pd = _context.product.SingleOrDefault(pr => pr.id == new Guid(productId)); var mproCheck = _context.mem_product.Where(mpr => (mpr.member_code == m.member_code) && (mpr.product_code == pd.product_code)).Count(); if (mproCheck == 0) { mem_product mp = new mem_product(); mp.member_code = m.member_code; mp.product_code = pd.product_code; mp.x_status = "Y"; _context.Add(mp); var mpro = _context.mem_product.SingleOrDefault(mpr => (mpr.member_code == m.member_code) && (mpr.id == new Guid(mem_productId))); var recno = mpro.rec_no; _context.Remove(mpro); _context.SaveChanges(); var mpro2 = _context.mem_product.SingleOrDefault(mpr => (mpr.member_code == m.member_code) && (mpr.product_code == pd.product_code)); mpro2.rec_no = recno; _context.Update(mpro2); _context.SaveChanges(); return(Json(new { result = "success" })); } else { return(Json(new { result = "duplicate" })); } }
public IActionResult DeleteVideo(string albumCode, string imageCode) { pic_image pi = _context.pic_image.SingleOrDefault(p => p.image_code == imageCode); _context.Remove(pi); _context.SaveChanges(); var uploads = Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_album").Value); uploads = Path.Combine(uploads, albumCode); uploads = Path.Combine(uploads, imageCode); System.IO.File.Delete(uploads); return(Json(new { result = "success", imageCode = imageCode })); }