public ActionResult SaveProductGroup(Models.GroupProductModel data)
{
if (!ModelState.IsValid)
{
if (data.bciid == 0)
{
_db = new QSoft_WUEntities();
DAL.Groupproduct code = _db.Groupproduct.Where(p => p.grpcode == data.grpcode).FirstOrDefault();
if (code != null)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
else
{
System.Web.HttpContext.Current.Application.Lock();
_db = new QSoft_WUEntities();
_db.Groupproduct.Add(new DAL.Groupproduct
{
grpcode = data.grpcode,
grpname1 = data.grpname1,
grpname2 = data.grpname2,
ccode = data.ccode
});
_db.SaveChanges();
System.Web.HttpContext.Current.Application.UnLock();
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
}
if (ModelState.IsValid)
{
if (data.bciid != 0)
{
_db = new QSoft_WUEntities();
DAL.Groupproduct code = _db.Groupproduct.Where(p => p.grpcode == data.grpcode && p.bciid != data.bciid).FirstOrDefault();
if (code != null)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
else
{
DAL.Groupproduct edit = _db.Groupproduct.Where(p => p.bciid == data.bciid).FirstOrDefault();
edit.grpcode = data.grpcode;
edit.grpname1 = data.grpname1;
edit.grpname2 = data.grpname2;
edit.ccode = data.ccode;
_db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
}
return(View(data));
}
public ActionResult DeleteProductGroup(int bciid)
{
if (bciid != 0)
{
System.Web.HttpContext.Current.Application.Lock();
DAL.Groupproduct delete = _db.Groupproduct.Where(p => p.bciid == bciid).FirstOrDefault();
_db.Groupproduct.Remove(delete);
_db.SaveChanges();
System.Web.HttpContext.Current.Application.UnLock();
return(Json(true, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
