public List <EventSubscription> GetAll(string eventID) { using (var db = new SystemDbContext()) { return(db.EventSubscriptions.Where(x => x.EventID == eventID).ToList()); } }
public override List <EventSubscription> GetAll() { using (var db = new SystemDbContext()) { return(db.EventSubscriptions.ToList()); } }
public ActionResult CustomAuthGroup(FormCollection collection) { string groupId = collection["GroupId"]; string groupName = collection["GroupName"]; //遍历用户选择的所有角色,将用于添加到每一个角色当中 string[] FormKeys = collection.AllKeys; List <AuthorizeGroup> groups = new List <AuthorizeGroup>(); foreach (string tmp in FormKeys) { if (tmp.Contains("Auth_")) { groups.Add(new AuthorizeGroup() { GroupId = groupId, GroupName = groupName, ActionName = tmp }); } } using (SystemDbContext db = new SystemDbContext()) { db.AuthorizeGroups.AddRange(groups); db.SaveChanges(); } return(View()); }
public ActionResult TestCheckbox() { SystemDbContext db = new SystemDbContext(); List <BonsaiiModels.Authorize> tmpList = db.Authorizes.ToList(); List <string> ModuleNames = tmpList.Select(p => p.ModuleName).Distinct().ToList(); List <ModuleViewModel> result = new List <ModuleViewModel>(); foreach (string tmpModule in ModuleNames) { ModuleViewModel tmpModuleviewModel = new ModuleViewModel(); tmpModuleviewModel.ModuleName = tmpModule; tmpModuleviewModel.UnitCount = tmpList.Where(p => p.ModuleName.Equals(tmpModule)).Select(p => p.UnitName).Distinct().Count(); List <string> UnitNames = tmpList.Where(p => p.ModuleName.Equals(tmpModule)).Select(p => p.UnitName).Distinct().ToList(); List <UnitViewModel> units = new List <UnitViewModel>(); foreach (string tmpUnit in UnitNames) { UnitViewModel tmpUnitViewModel = new UnitViewModel(); tmpUnitViewModel.UnitName = tmpUnit; tmpUnitViewModel.UnitId = tmpList.Where(p => p.UnitName.Equals(tmpUnit)).Select(p => p.UnitId).First(); tmpUnitViewModel.Actions = tmpList.Where(p => p.UnitName.Equals(tmpUnit)).Select(p => new AuthorizeViewModel() { ActionName = p.ActionName, ActionValue = p.ActionValue, Name = p.Name }).ToList(); units.Add(tmpUnitViewModel); } tmpModuleviewModel.Units = units; result.Add(tmpModuleviewModel); } return(View(result)); }
public string GetUserNameById(string id, string eventId) { using (var db = new SystemDbContext()) { return(db.EventSubscriptions.FirstOrDefault(e => e.EventID == eventId && e.UserID == id).UserName); } }
public override Event Get(string id) { using (var db = new SystemDbContext()) { return(db.Events.FirstOrDefault(x => x.EventID == id)); } }
public SiteController( IOptions <WebConfig> webConfig, SystemDbContext context) { _context = context; _webConfig = webConfig.Value; }
/// <summary> /// 发起人员离职申请并且审核通过之后,执行此函数 /// 修改员工档案,并增加一条记录到离职档案,最后修改Users表(如果需要) /// </summary> /// <param name="staffApplication"></param> public void StaffApplicationPassAudit(StaffApplication staffApplication) { try { staffApplication.AuditStatus = 3; Staff staffId = (from p in db.Staffs where p.StaffNumber == staffApplication.StaffNumber && p.ArchiveTag != true select p).ToList().Single(); //根据员工工号找到这个人的人员档案,是唯一的。 Staff staff = db.Staffs.Find(staffId.Number); staff.ArchiveTag = true; //true 代表离职 staff.BindingCode = null; ///看看离职档案里面有没有;没有就添加。 var staffArchiveFind = (from p in db.StaffArchives where p.StaffNumber == staffApplication.StaffNumber select p).ToList(); if (staffArchiveFind.Count == 0) { StaffArchive staffArchive = new StaffArchive(); staffArchive.BillTypeNumber = staffApplication.BillTypeNumber; staffArchive.BillTypeName = staffApplication.BillTypeName; staffArchive.BillNumber = staffApplication.BillNumber; staffArchive.StaffNumber = staff.StaffNumber; staffArchive.StaffName = staff.Name; staffArchive.LeaveDate = staffApplication.HopeLeaveDate; staffArchive.Department = (from p in db.Departments where p.DepartmentId == staff.Department select p.Name).ToList().FirstOrDefault(); staffArchive.IdenticationNumber = staff.IdentificationNumber; staffArchive.RecordPerson = staff.RecordPerson; staffArchive.RecordTime = staff.RecordTime; staffArchive.BlackList = false; staffArchive.WorkPlus = false; db.StaffArchives.Add(staffArchive); } db.SaveChanges(); ////修改系统表 SystemDbContext sysdb = new SystemDbContext(); var Ucount = (from p in sysdb.BindCodes where (p.CompanyId == this.CompanyId && p.StaffNumber == staffApplication.StaffNumber) select p).SingleOrDefault(); if (Ucount != null) { sysdb.BindCodes.Remove(Ucount); sysdb.SaveChanges(); } //SystemDbContext sysdb = new SystemDbContext(); // var UCount = (from p in sysdb.Users where (p.CompanyId == this.CompanyId) && (p.UserName == staffId.IndividualTelNumber)&&() select p).ToList(); //if (UCount.Count() != 0)//如果存在符合条件的User //{ // UserModels user = UCount.FirstOrDefault(); // user.CompanyId = "app-id"; // user.CompanyFullName = "GeneralStaff"; // user.BindingCode = null; // user.StaffNumber = null; // user.BindTag = null; // user.ConnectionString = "app-ConnectionString"; // sysdb.SaveChanges(); //} //db.SaveChanges(); } catch (Exception e) { //throw e; throw new ArgumentOutOfRangeException("符合条件的员工不存在或工号不唯一"); } }
private void WriteSmsInDb(List <ShortMessage> listShortMessages) { double stepValue = 100 / (double)listShortMessages.Count; using (SystemDbContext context = new SystemDbContext(ConfigurationManager.ConnectionStrings["BatteryMonitoringSystemDb"].ConnectionString)) { foreach (var msg in listShortMessages) { var query = context.Informations.Where(info => info.MessageNumber == msg.MessageNumber && info.InformationSource.InternationalCode + info.InformationSource.PhoneNumber == msg.Sender).ToList(); if (query.Count == 0) { var infoSource = context.InformationSources.Where(source => source.InternationalCode + source.PhoneNumber == msg.Sender).First(); context.Informations.Add(new Information { MessageNumber = msg.MessageNumber, MessageDateTime = msg.ReceivedDateTime, Message = msg.Message, InformationSourceID = infoSource.InformationSourceID }); context.SaveChanges(); } Dispatcher.Invoke(() => { dataLoading.Value += stepValue; }); } } }
// GET: News public ActionResult Index() { using (SystemDbContext context = new SystemDbContext()) { return(View(context.News.ToList())); } }
public List <Debt> GetUnpaidDebts(string eventID) { using (var db = new SystemDbContext()) { return(db.Debts.Where(x => x.AmountDue > 0 && x.EventID == eventID).ToList()); } }
/// <summary> /// get resource value by name /// </summary> /// <param name="name">name key of resource</param> /// <param name="notFound">insert to db if not found</param> /// <returns></returns> private string GetResourceValue(string name, out bool notFound) { var culture = CultureInfo.CurrentCulture.Name; var dicKey = $"{culture}-{_resourceType}-{name}".ToLower(); if (_localizations.ContainsKey(dicKey)) { notFound = true; return(_localizations[dicKey]); } else { notFound = false; _localizations.Add(dicKey, name); if (_sqlLocalizationOptions.CreateDbResourceIfNotFound) { _taskQueue.QueueBackgroundWorkItem(async token => { using var localizedDbContext = new SystemDbContext(new DbContextOptionsBuilder <SystemDbContext>().UseSqlServer(_sqlLocalizationOptions.ConnectionString).Options); localizedDbContext.LanguageResources.Add(new LanguageResource() { Culture = culture, Key = name, Type = _resourceType, Value = name }); await localizedDbContext.SaveChangesAsync(); }); } return(name); } }
/// <summary> /// 显示用户勾选中的菜单 /// </summary> /// <returns></returns> public ActionResult IndexMain() { List <Menu> Menus = db.Menus.Where(p => p.IsShow == true).OrderBy(p => p.ParentOrder).ToList(); List <MenuViewModel> menuViewModel = new List <MenuViewModel>(); menuViewModel.Add(new MenuViewModel(Menus[0].ParentName, Menus[0].ParentClass, Menus[0].ParentOrder)); int j = 0; menuViewModel[j].MenuNodes.Add(new MenuNode(Menus[0].Name, Menus[0].Href, Menus[0].IsShow, Menus[0].Id)); for (int i = 1; i < Menus.Count; i++) { if (!Menus[i].ParentOrder.Equals(Menus[i - 1].ParentOrder)) { menuViewModel.Add(new MenuViewModel(Menus[i].ParentName, Menus[i].ParentClass, Menus[0].ParentOrder)); j++; } menuViewModel[j].MenuNodes.Add(new MenuNode(Menus[i].Name, Menus[i].Href, Menus[i].IsShow, Menus[i].Id)); } /*Panda Add SystemMessage alert*/ SystemDbContext db2 = new SystemDbContext(); var count = (from p in db2.SystemMessages where (p.CompanyId) == this.CompanyId && (p.UserName == this.UserName) && (p.IsRead == false) select p).ToList(); ViewBag.Mess = count.Count(); return(View(menuViewModel)); }
public Event GetEventByCreatorId(string eventName, string creatorUserId) { using (var db = new SystemDbContext()) { return(db.Events.Single(e => e.Name == eventName && e.CreatorID == creatorUserId)); } }
public Event GetByName(string eventName, string channelId) { using (var db = new SystemDbContext()) { return(db.Events.Single(e => e.Name == eventName && e.ChannelID == channelId)); } }
public ActionResult AdminIndex() { List <UserModels> users = new List <UserModels>(); using (SystemDbContext db = new SystemDbContext()){ users = db.Users.Where(p => p.CompanyId.Equals("001")).ToList(); } return(View(users)); }
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl) { if (!ModelState.IsValid) { return(View(model)); } using (SystemDbContext con = new SystemDbContext()) { ApplicationUser user = UserManager.FindByName(model.UserName); if (user == null) { ModelState.AddModelError("", "用户名或密码错误!请重新登录"); return(View(model)); } if (!user.IsProved) { ModelState.AddModelError("", "您所属的企业尚未通过审核。请与系统管理员联系。"); return(View(model)); } if (!user.IsAvailable) { ModelState.AddModelError("", "抱歉,您已经被企业管理员禁用!请与企业管理员联系"); return(View(model)); } } // 这不会计入到为执行帐户锁定而统计的登录失败次数中 // 若要在多次输入错误密码的情况下触发帐户锁定,请更改为 shouldLockout: true var result = await SignInManager.PasswordSignInAsync(model.UserName, model.Password, model.RememberMe, shouldLockout : false); switch (result) { case SignInStatus.Success: var user = UserManager.FindByName(model.UserName); //设置session Session["ConnectionString"] = user.ConnectionString; Session["CompanyId"] = user.CompanyId; Session["UserName"] = user.UserName; Session["CompanyFullName"] = user.CompanyFullName; Session["IsProved"] = user.IsProved; return(RedirectToLocal(returnUrl)); case SignInStatus.LockedOut: return(View("Lockout")); case SignInStatus.RequiresVerification: return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe })); case SignInStatus.Failure: default: ModelState.AddModelError("", "无效的登录尝试。"); return(View(model)); } }
public async Task <ActionResult> GetImage(int?id) { using (SystemDbContext context = new SystemDbContext()) { BazinamSite2.Models.Picture pic = new BazinamSite2.Models.Picture(); pic = await context.Pictures.FindAsync(id); return(base.File(pic.PicSourceBytes, "image/jpeg")); } }
public ActionResult SwitchIsAvailable(string id) { using (SystemDbContext con = new SystemDbContext()) { UserModels user = con.Users.Find(id); user.IsAvailable = user.IsAvailable ? false : true; con.SaveChanges(); } return(RedirectToAction("Index")); }
public EmployeesHoursSearchViewModel(SystemDbContext context, int empId, DateTime start, DateTime end) { _context = context; EmployeeList = EmployeeSearch(); SearchList = HoursSearch(empId, start, end); foreach (var item in SearchList) { Total += item.Total; } }
public static void Main() { using var db = new SystemDbContext(); db.Topics.Add(new Topic() { Description = "good topic - 2" }); db.SaveChanges(); }
private void AddNewPhone_Click(object sender, RoutedEventArgs e) { if (phoneNumber.Text != "" && operatorsBox.SelectedIndex > 0) { Regex phoneNumberRegex = new Regex(@"^(\+375)(29|25|33|44)(\d{7})$"); if (phoneNumberRegex.IsMatch(phoneNumber.Text)) { using (SystemDbContext context = new SystemDbContext(ConfigurationManager.ConnectionStrings["BatteryMonitoringSystemDb"].ConnectionString)) { var informationSource = context.InformationSources.Where(p => p.InternationalCode == phoneNumber.Text.Substring(0, 6) && p.PhoneNumber == phoneNumber.Text.Substring(6)).FirstOrDefault(); if (informationSource == null) { context.InformationSources.Add(new InformationSource { InternationalCode = phoneNumber.Text.Substring(0, 6), PhoneNumber = phoneNumber.Text.Substring(6), Operator = operatorsBox.Text, IsEnable = true }); context.SaveChanges(); } else if (informationSource.IsEnable == false) { informationSource.IsEnable = true; context.SaveChanges(); } else { MessageBox.Show("Введеный номер уже имеется в списке доступных контактов.", "Внимание"); } DialogResult = true; Close(); } } else { MessageBox.Show("Неправильно набран номер. Введите номер используя следующую форму записи - +375291234567.", "Ошибка"); } } else if (phoneNumber.Text != "" && operatorsBox.SelectedIndex == 0) { MessageBox.Show("Выберите мобильного оператора!", "Ошибка"); } else if (phoneNumber.Text == "" && operatorsBox.SelectedIndex > 0) { MessageBox.Show("Введите номер телефона!", "Ошибка"); } else { MessageBox.Show("Данные не введены.", "Ошибка"); } }
public ActionResult Create() { SystemDbContext db = new SystemDbContext(); List <BonsaiiModels.Authorize> tmpList = db.Authorizes.ToList(); List <string> ModuleNames = tmpList.Select(p => p.ModuleName).Distinct().ToList(); List <ModuleViewModel> result = new List <ModuleViewModel>(); foreach (string tmpModule in ModuleNames) { ModuleViewModel tmpModuleviewModel = new ModuleViewModel(); tmpModuleviewModel.ModuleName = tmpModule; tmpModuleviewModel.UnitCount = tmpList.Where(p => p.ModuleName.Equals(tmpModule)).Select(p => p.UnitName).Distinct().Count(); List <string> UnitNames = tmpList.Where(p => p.ModuleName.Equals(tmpModule)).Select(p => p.UnitName).Distinct().ToList(); List <UnitViewModel> units = new List <UnitViewModel>(); foreach (string tmpUnit in UnitNames) { UnitViewModel tmpUnitViewModel = new UnitViewModel(); tmpUnitViewModel.UnitName = tmpUnit; tmpUnitViewModel.UnitId = tmpList.Where(p => p.UnitName.Equals(tmpUnit)).Select(p => p.UnitId).First(); tmpUnitViewModel.Actions = tmpList.Where(p => p.UnitName.Equals(tmpUnit)).Select(p => new AuthorizeViewModel() { ActionName = p.ActionName, ActionValue = p.ActionValue, Name = p.Name }).ToList(); units.Add(tmpUnitViewModel); } tmpModuleviewModel.Units = units; List <AuthorizeGroup> tmpAuthorizeGroup = db.AuthorizeGroups.ToList(); Dictionary <string, string> authMap = new Dictionary <string, string>(); foreach (AuthorizeGroup tmp in tmpAuthorizeGroup) { if (!authMap.ContainsKey(tmp.GroupName)) { authMap.Add(tmp.GroupName, tmp.ActionName); } else { authMap[tmp.GroupName] += "," + tmp.ActionName; } } ViewBag.authGroup = authMap; result.Add(tmpModuleviewModel); } ViewBag.Roles = result; return(View()); }
public ActionResult Close(string id) { using (SystemDbContext mydb = new SystemDbContext()) { List <UserModels> tmp = mydb.Users.Where(p => p.CompanyId.Equals(id)).ToList(); foreach (UserModels user in tmp) { user.IsProved = false; } mydb.Entry(tmp).State = System.Data.Entity.EntityState.Modified; mydb.SaveChanges(); return(RedirectToAction("Index")); } }
// GET: MultiStore/Home public async Task <ActionResult> Index() { SystemDbContext <SystemUser> C = (SystemDbContext <SystemUser>) this.UserContext.Db; MySqlDefault <Entity.MiniApp.User.MiniAccount> DefaultDb = DefaultContext.UsedOrginalDb <Entity.MiniApp.User.MiniAccount>(); var Hy = DefaultDb.GetList(); if (C != null) { try { //var V = this.UserManager.FindByIdAsync<MiniAccount>( // this.UserManager.Users.ToList().FirstOrDefault().Id, // HttpContext.GetOwinContext()); //SystemUser User = new SystemUser(); //User.UserName = "******"; //User.Email = "*****@*****.**"; //User.MiniAccountList = new List<MiniAccount>(); //MiniAccount account1 = C.MiniAccounts.Create(); //account1.AccountId = Guid.NewGuid().ToString(); //MiniAccount account2 = C.MiniAccounts.Create(); //account2.AccountId = Guid.NewGuid().ToString(); //User.MiniAccountList.Add(account1); //User.MiniAccountList.Add(account2); //C.SaveChanges(); //var result = await UserManager.CreateAsync(User, "Asgsg/12323"); //if (result.Succeeded) //{ //} } catch (Exception ex) { } } return(View()); }
public override void Create(Debt element) { using (var db = new SystemDbContext()) { if (element.AmountDue == 0) { throw HttpResponseExceptionHelper.Create("Do you really want to set up a 0$ Debt ?", HttpStatusCode.BadRequest); } db.Debts.Add(element); db.SaveChanges(); } }
public static List <AssignmentsViewModel> ConvertModelToVM(SystemDbContext context, List <Assignments> assign) { List <AssignmentsViewModel> list = new List <AssignmentsViewModel>(); foreach (var item in assign) { AssignmentsViewModel assignment = new AssignmentsViewModel(context); assignment._EmployeeName = assignment.EmployeeName(item.EmpId); assignment._TaskName = assignment.TasksName(item.TaskId); assignment._AssignmentId = item.AssignmentId; list.Add(assignment); } return(list); }
public EmployeesHoursViewModel(SystemDbContext context, int EmpId) { _context = context; try { var _emp = _context.Employees.Find(EmpId); EmployeeName = _emp.Name + " " + _emp.Surname; TaskList = Tasks(_context.Assignments.Where(d => d.EmpId == EmpId).ToList()); TempEmpId = EmpId; } catch (Exception) { //log } }
public override void Create(EventSubscription element) { if (element == null) { throw HttpResponseExceptionHelper.Create("Element you want to create is null (Event Subscription)", HttpStatusCode.BadRequest); } using (var db = new SystemDbContext()) { element.EventSubscriptionID = EventSubscriptionHelper.GetEventSubscriptionId(element); db.EventSubscriptions.Add(element); db.SaveChanges(); } }
public JsonResult Register(string UserName, string Password, string NickName, string Code) { SystemDbContext db = new SystemDbContext(); //首先核对用户的短信验证码是否合法 using (var vCode = new SystemDbContext()) { var CurrentUserCode = vCode.VerifyCodes.Find(UserName); DateTime CurTime = System.DateTime.Now; if (CurTime > CurrentUserCode.OverTime) //用户短信验证码超时 { ModelState.AddModelError("", "抱歉,您的验证码已经过期!"); } else if (!CurrentUserCode.Code.Equals(Code)) { ModelState.AddModelError("", "抱歉,您的验证码输入错误!"); this.PackageJson(0, "验证码错误!", null); } } ApplicationUser user = new ApplicationUser { CompanyFullName = "GeneralStaff", //model.CompanyFullName, PhoneNumber = UserName, UserName = UserName, NickName = NickName, Name = "普通员工", //用户注册的时候写入该名称 IsProved = false, //是否审核的标志 IsAvailable = false, //是否是可用的管理员 IsRoot = false //注册企业号的人默认就是企业的超级管理员 }; //填写CompanyId,由于新注册的用户没有绑定企业,所以填写一个默认值 user.CompanyId = "app-id"; user.ConnectionString = "app-ConnectionString"; var result = UserManager.Create(user, Password); if (result.Succeeded) { //在环信中注册 EaseMobDemo myEaseMobDemo = new EaseMobDemo(appClientID, appClientSecret, appName, orgName); string MobResult = myEaseMobDemo.AccountCreate(UserName, Password, NickName); return(PackageJson(1, "注册成功!", MobResult)); } // 如果我们进行到这一步时某个地方出错,则重新显示表单 return(PackageJson(0, "Web系统中注册用户失败!", null)); }