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 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 Login(tb_user user) { using (var context = new db_cmaEntities()) { return(context.tb_user.Where(n => n.Username == user.Username && n.Password == user.Password).FirstOrDefault() != null); } }
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 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 IEnumerable <MessageModel> GetList() { using (var context = new db_cmaEntities()) { DOBase <tb_message> tRole = new DOBase <tb_message>(context); return(tRole.Where(r => true).ToList().Select(n => GetModel(n))); } }
public IEnumerable <ActionModel> GetList() { using (var context = new db_cmaEntities()) { var dbModelList = context.tb_action.ToList(); return(dbModelList.Select(n => GetModel(n))); } }
public MonitorItemDBModel Get(int id) { using (var context = new db_cmaEntities()) { var tbItem = context.tb_monitoritem.Where(n => n.Id == id).FirstOrDefault(); MonitorItemDBModel itemList = GetDBMonitorItemModel(tbItem); return(itemList); } }
public IEnumerable <CollectorDBModel> GetList() { using (var context = new db_cmaEntities()) { var tbItemList = context.tb_collector.ToList(); IEnumerable <CollectorDBModel> itemList = tbItemList.Select(n => GetDBCollectorModel(n)); return(itemList); } }
public IEnumerable <UserInfoModel> GetList() { using (var context = new db_cmaEntities()) { //var dbModelList = context.tb_user.ToList(); var dbModelList = context.tb_user.Where(u => u.State == 0).ToList(); return(dbModelList.Select(n => GetModel(n))); } }
internal IEnumerable <ActionModel> GetListFromRole(long id) { using (var context = new db_cmaEntities()) { //var dbModelList = context.tb_action.Where(n=>n.).ToList(); //return dbModelList.Select(n => GetModel(n)); } return(null); }
public IEnumerable <MonitorItemDBModel> GetList() { using (var context = new db_cmaEntities()) { var tbItemList = context.tb_monitoritem.ToList(); IEnumerable <MonitorItemDBModel> itemList = tbItemList.Select(n => GetDBMonitorItemModel(n)); return(itemList); } }
public MessageModel Get(long id) { MessageModel result = null; using (var context = new db_cmaEntities()) { DOBase <tb_message> tRole = new DOBase <tb_message>(context); result = GetModel(tRole.GetModel(id)); } return(result); }
/// <summary> /// 检查用户名是否已存在 /// </summary> /// <param name="model"></param> /// <returns>fasle--用户名可用 无重复</returns> /// <returns>true --用户名不可用 有重复</returns> public bool IsExit(UserInfoModel model) { bool result = false; using (var context = new db_cmaEntities()) { var db = context.tb_user.Where(n => n.Username == model.Username).Count(); result = db == 0 ? false : true; } return(result); }
public RoleModel Get(long id) { RoleModel result = null; using (var context = new db_cmaEntities()) { //DOBase<tb_role> tRole = new DOBase<tb_role>(context); result = GetModel(context.tb_role.FirstOrDefault(n => n.Id == id), context.tb_role.FirstOrDefault(n => n.Id == id).tb_action.ToList()); } 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 Delete(int id) { var temp = false; using (var context = new db_cmaEntities()) { DOBase <tb_message> tRole = new DOBase <tb_message>(context); tRole.Delete(id); temp = tRole.SaveChang() > 0 ? true : false; } return(temp); }
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(MessageModel model) { var temp = false; using (var context = new db_cmaEntities()) { DOBase <tb_message> tRole = new DOBase <tb_message>(context); tRole.Edit(GetModel(model), new string[] { "Value", "Time" }); temp = tRole.SaveChang() > 0 ? true : false; //context.Configuration.ValidateOnSaveEnabled = true; } return(temp); }
public UserInfoModel Get(string username) { UserInfoModel result = null; using (var context = new db_cmaEntities()) { var dbModel = context.tb_user.Where(n => n.Username == username).FirstOrDefault(); if (dbModel != null) { result = GetModel(dbModel); } } return(result); }
public bool Add(MessageModel model) { var temp = false; using (var context = new db_cmaEntities()) { DOBase <tb_message> tRole = new DOBase <tb_message>(context); tRole.Add(GetModel(model)); context.Configuration.ValidateOnSaveEnabled = false; temp = tRole.SaveChang() > 0 ? true : false; context.Configuration.ValidateOnSaveEnabled = true; } return(temp); }
public UserInfoModel Get(long id) { UserInfoModel result = null; using (var context = new db_cmaEntities()) { var dbModel = context.tb_user.Where(n => n.Id == id).FirstOrDefault(); if (dbModel != null) { result = GetModel(dbModel, context.tb_user.Where(n => n.Id == id).FirstOrDefault().tb_role); } } 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); }