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 async Task <IActionResult> Edit(string id, [Bind("product_code,member_code,grow_area,id,rowversion,x_log,x_note,x_status")] mem_product mem_product) { if (id != mem_product.product_code) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(mem_product); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!mem_productExists(mem_product.product_code)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(mem_product)); }
public IActionResult Create(string memberId, string productId) { var m = _context.member.SingleOrDefault(mb => mb.id == new Guid(memberId)); var mpro = _context.mem_product.Where(mpr => (mpr.member_code == m.member_code) && (mpr.id == new Guid(productId))).Count(); if (mpro == 0) { var pd = _context.product.SingleOrDefault(pdt => pdt.id == new Guid(productId)); var pgrp = _context.product_group.SingleOrDefault(pg => pg.product_group_code == pd.product_group_code); var ptyp = _context.product_type.SingleOrDefault(pt => (pt.product_type_code == pd.product_type_code) && (pt.product_group_code == pd.product_group_code)); 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); _context.SaveChanges(); //var mpCount = _context.mem_product.Where(mj => (mj.member_code == m.member_code)).Count(); var mpMax = _context.mem_product.Where(mj => (mj.member_code == m.member_code)).Max(mj => mj.rec_no); return(Json(new { result = "success", rec_no = mpMax, mem_product_id = mp.id, product_group_desc = pgrp.product_group_desc, product_type_desc = ptyp.product_type_desc, product_desc = pd.product_desc })); } else { return(Json(new { result = "duplicate" })); } }
public async Task <IActionResult> Create([Bind("product_code,member_code,grow_area,id,rowversion,x_log,x_note,x_status")] mem_product mem_product) { if (ModelState.IsValid) { _context.Add(mem_product); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(mem_product)); }