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));
}
