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