public ActionResult SysMedicalGroup_Destroy([DataSourceRequest] DataSourceRequest request, SysMedicalGroup sysMedicalGroup)
        {
            string sMGRowid = String.Empty;

            if (ModelState.IsValid)
            {
                var entity = new SysMedicalGroup
                {
                    MGRowid = sysMedicalGroup.MGRowid
                              //MGName = sysMedicalGroup.MGName,
                              //MGDescript = sysMedicalGroup.MGDescript,
                              //MGFont = sysMedicalGroup.MGFont
                };

                sMGRowid = sysMedicalGroup.MGRowid;

                var entitySysMedicalGroupHospital = db.SysMedicalGroupHospital.Where(x => x.MGRowid == sMGRowid);
                db.SysMedicalGroupHospital.RemoveRange(entitySysMedicalGroupHospital);
                db.SaveChanges();

                db.SysMedicalGroup.Attach(entity);
                db.SysMedicalGroup.Remove(entity);
                db.SaveChanges();
            }

            return(Json(new[] { sysMedicalGroup }.ToDataSourceResult(request, ModelState)));
        }
        public ActionResult SysMedicalGroup_Update([DataSourceRequest] DataSourceRequest request, SysMedicalGroup sysMedicalGroup)
        {
            if (ModelState.IsValid)
            {
                var entity = new SysMedicalGroup
                {
                    MGRowid    = sysMedicalGroup.MGRowid,
                    MGName     = sysMedicalGroup.MGName,
                    MGDescript = sysMedicalGroup.MGDescript,
                    MGFont     = sysMedicalGroup.MGFont
                };

                db.SysMedicalGroup.Attach(entity);
                db.Entry(entity).State = System.Data.Entity.EntityState.Modified;
                db.SaveChanges();
            }

            return(Json(new[] { sysMedicalGroup }.ToDataSourceResult(request, ModelState)));
        }
        public ActionResult SysMedicalGroup_Create(ViewModel_MedicalGroups sysMedicalGroups, string MGType)
        {
            if (sysMedicalGroups != null && ModelState.IsValid)
            {
                var target = new SysMedicalGroup();
                target.MGRowid    = Guid.NewGuid().ToString();
                target.MGName     = sysMedicalGroups.MGName;
                target.MGDescript = sysMedicalGroups.MGDescript;
                target.MGFont     = sysMedicalGroups.MGFont;
                target.MGType     = MGType;

                db.SysMedicalGroup.Add(target);
                db.SaveChanges();

                sysMedicalGroups.MGRowid = target.MGRowid;
            }

            return(Json(new[] { sysMedicalGroups }.ToDataSourceResult(new DataSourceRequest(), ModelState)));
        }