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