public bool Add(UserInfoModel model) { bool result = false; try { using (var context = new db_cmaEntities()) { tb_user dbmodel = new tb_user() { Email = model.Email, Password = model.Password, RealName = model.RealName, Telphone = model.Telphone, Username = model.Username, State = model.State, }; context.tb_user.Add(dbmodel); context.SaveChanges(); //dbmodel = context.tb_user.Where(n => n.Id == dbmodel.Id).FirstOrDefault(); if (model.RoleList.Count > 0) { dbmodel.tb_role.Clear(); dbmodel.tb_role = context.tb_role.Where(n => model.RoleList.Contains(n.Id)).ToList(); } result = context.SaveChanges() > 0; } } catch (Exception ex) { throw; } return(result); }
public bool Add(RoleModel model) { var temp = false; using (var context = new db_cmaEntities()) { //DOBase<tb_role> tRole = new DOBase<tb_role>(context); //tRole.Add(GetModel(model)); tb_role dbmodel = new tb_role() { Name = model.Name, Description = model.Description }; context.tb_role.Add(dbmodel); context.SaveChanges(); if (model.ActionList.Count() > 0) { dbmodel.tb_action.Clear(); dbmodel.tb_action = context.tb_action.Where(n => model.ActionList.Contains(n.Id)).ToList(); } //context.Configuration.ValidateOnSaveEnabled = false; temp = context.SaveChanges() > 0 ? true : false; //context.Configuration.ValidateOnSaveEnabled = true; } return(temp); }
public bool Delete(long id) { bool result = false; try { using (var context = new db_cmaEntities()) { var dbmodel = context.tb_monitoritem.First(u => u.Id == id); if (dbmodel != null) { context.tb_monitoritem.Remove(dbmodel); result = context.SaveChanges() > 0; } else { return(true);//已删除 } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(result); }
public bool Delete(long id) { bool result = false; try { using (var context = new db_cmaEntities()) { var dbmodel = context.tb_user.First(u => u.Id == id); if (dbmodel.State != 1) { dbmodel.State = 1; context.Configuration.ValidateOnSaveEnabled = false; result = context.SaveChanges() > 0; context.Configuration.ValidateOnSaveEnabled = true; } else { return(true);//已删除 } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(result); }
public bool RestPassword(UserInfoModel model) { using (var context = new db_cmaEntities()) { var dbmodel = context.tb_user.Where(u => u.Id == model.Id).FirstOrDefault(); if (dbmodel == null) { } dbmodel.Password = model.Password; return(context.SaveChanges() > 0); } }
public bool Add(CollectorDBModel model) { bool result = false; using (var context = new db_cmaEntities()) { context.tb_collector.Add(new tb_collector() { Host = model.Host, Note = model.Note }); result = context.SaveChanges() > 0 ? true : false; } return(result); }
public bool Edit(MonitorItemDBModel model) { bool result = false; using (var context = new db_cmaEntities()) { var tbItem = context.tb_monitoritem.Where(n => n.Id == model.Id).FirstOrDefault(); tbItem.Host = model.Host; //tbItem.ItemType = (int)model.ItemType; tbItem.Name = model.Name; tbItem.Note = model.Note; tbItem.Paramter = model.Paramter; tbItem.CollectorHost = model.CollectorHost; context.SaveChanges(); result = true; } return(result); }
public bool Add(MonitorItemDBModel model) { bool result = false; using (var context = new db_cmaEntities()) { context.tb_monitoritem.Add(new tb_monitoritem() { Host = model.Host, ItemType = (int)model.ItemType, Name = model.Name, Note = model.Note, CollectorHost = model.CollectorHost, Paramter = model.Paramter }); context.SaveChanges(); result = true; } return(result); }
public bool Edit(RoleModel model) { bool result = false; using (var context = new db_cmaEntities()) { var dbModel = context.tb_role.First(n => n.Id == model.Id); dbModel.Name = model.Name; dbModel.cFree = model.cFree; dbModel.Description = model.Description; if (model.ActionList.Count() > 0) { dbModel.tb_action.Clear(); dbModel.tb_action = context.tb_action.Where(n => model.ActionList.Contains(n.Id)).ToList(); } context.Configuration.ValidateOnSaveEnabled = false; context.SaveChanges(); context.Configuration.ValidateOnSaveEnabled = true; result = true; } return(result); }
public bool Edit(UserInfoModel model) { bool result = false; using (var context = new db_cmaEntities()) { var dbModel = context.tb_user.First(n => n.Id == model.Id); dbModel.Email = model.Email; dbModel.RealName = model.RealName; dbModel.Telphone = model.Telphone; if (model.RoleList.Count > 0) { dbModel.tb_role.Clear(); dbModel.tb_role = context.tb_role.Where(n => model.RoleList.Contains(n.Id)).ToList(); } //context.Configuration.ValidateOnSaveEnabled = false; context.SaveChanges(); //context.Configuration.ValidateOnSaveEnabled = true; result = true; } return(result); }