public ActionResult Edit([Bind(Include = "tbGroupId,GroupName,Description,IsDisable")] tbGroup tbGroup)
{
if (ModelState.IsValid)
{
db.Entry(tbGroup).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View("__Cms/Groups/Edit", tbGroup));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbGroup tbGroup = db.tbGroups.Find(id);
if (tbGroup == null)
{
return(HttpNotFound());
}
return(View("__Cms/Groups/Delete", tbGroup));
}
public string Put([FromBody] tbGroup group)
{
try
{
tbGroup tbGroup = _db.tbGroup.Where(b => b.GroupID == group.GroupID).First();
tbGroup.GroupName = group.GroupName;
tbGroup.Power = group.Power;
_db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
public ActionResult Create([Bind(Include = "tbGroupId,GroupName,Description,IsDisable")] tbGroup tbGroup)
{
if (ModelState.IsValid)
{
tbGroup tbGroupCheck = db.tbGroups.Where(p => p.GroupName == tbGroup.GroupName).FirstOrDefault();
if (tbGroupCheck != null)
{
ModelState.AddModelError("GroupNameValid", "Tên nhóm '" + tbGroup.GroupName + "' đã tồn tại!!!");
return(View("__Cms/Groups/Create", tbGroup));
}
db.tbGroups.Add(tbGroup);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View("__Cms/Groups/Create", tbGroup));
}
public ActionResult ViewMember(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbGroup tbGroup = db.tbGroups.Find(id);
if (tbGroup == null)
{
return(HttpNotFound());
}
ViewBag.tbGroup = tbGroup;
List <tbUserInGroup> tbUserInGroup = new List <ModelsAdmin.tbUserInGroup>();
db.tbUsers.ToList().ForEach(x => tbUserInGroup.Add(new tbUserInGroup(x, id.Value)));
return(View("__Cms/Groups/ViewMember", tbUserInGroup));
}
public string Delete([FromBody] string value)
{
try
{
//var tmp = from a in _db.ProductInfoes
// join b in _db.Records
// on a.ProductNo equals b.ProductNo
// where a.ProductNo == "dddd"
// select new { a.ProductNo, a.Unit, b.WorkDate, b.UserId };
tbGroup tbGroup = _db.tbGroup.Where(b => b.GroupID == value).First();
_db.tbGroup.Remove(tbGroup);
_db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
public string Post([FromBody] tbGroup group)
{
try
{
tbGroup tbGroup = _db.tbGroup.Where(x => x.GroupID == group.GroupID).FirstOrDefault();
if (tbGroup != null)
{
return("已存在此群組ID!!");
}
_db.tbGroup.Add(group);
_db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
