public ModuleController(LabContext context, ILoadConfigFileService config, IHttpContextAnalysisService analysis, ILoggerService logger) { _context = context; _config = config; _analysis = analysis; _logger = logger; }
public PrincipalController(LabContext context, IEncryptionDataService encryption, IHostingEnvironment hosting, IHttpContextAnalysisService analysis) { _context = context; _encryption = encryption; _hosting = hosting; _analysis = analysis; }
public SettingController(LabContext context, IHostingEnvironment hosting, ILoadConfigFileService config, IHttpContextAnalysisService analysis) { _context = context; _hosting = hosting; _config = config; _analysis = analysis; }
public EChartController(LabContext context, IHttpContextAnalysisService analysis, ILoggerService logger, IDataBaseService service) { _context = context; _analysis = analysis; _logger = logger; _service = service; }
public JsonResult SaveEvents(Event e) { var status = false; using (LabContext db = new LabContext()) { if (e.EventID > 0) { // Update the event var v = db.Events.Where(a => a.EventID == e.EventID).FirstOrDefault(); if (v != null) { v.Subject = e.Subject; v.Start = e.Start; v.End = e.End; v.Description = e.Description; v.ThemeColor = e.ThemeColor; v.IsFullDay = e.IsFullDay; } } else { db.Events.Add(e); } db.SaveChanges(); status = true; } return(new JsonResult { Data = new { status = status } }); }
public MainWindow() { InitializeComponent(); using (LabContext db = new LabContext()) { unitOfWork.CompaniesUnits.ListOfCompanies = db.Companies.ToList(); unitOfWork.EmployeesUnits.ListOfEmployees = db.Employees.ToList(); db.SaveChanges(); } //var company1 = new Company { Name = "Mila", Cost = 50000000, Adress = "Минск, Бобруйская 6" }; //var company2 = new Company { Name = "Electrosila", Cost = 150000000, Adress = "Минск, Бобруйская 6" }; //using (CompaniesContext db = new CompaniesContext()) //{ // db.Companies.Add(company1); // db.Companies.Add(company2); // db.SaveChanges(); //} //using (EmployeesContext db = new EmployeesContext()) //{ // var employee1 = new Employee { Id = 1, Name = "Nikolai", Age = 24, Post = "Consultant", Wage = 400, CompanyName = company1.Name }; // var employee2 = new Employee { Id = 2, Name = "Olga", Age = 22, Post = "Salesman", Wage = 500, CompanyName = company1.Name }; // db.Employees.Add(employee1); // db.Employees.Add(employee2); // db.SaveChanges(); //} }
public JudgeController(IHttpContextAnalysisService analysis, IEncryptionDataService encryption, LabContext context, ILoggerService logger, ILoadConfigFileService config) { _analysis = analysis; _encryption = encryption; _context = context; _logger = logger; _config = config; }
public AccountController(IEncryptionDataService ncryption, LabContext context, IHttpContextAccessor accessor, IHttpContextAnalysisService analysis, ILoadConfigFileService config) { _ncryption = ncryption; _context = context; _accessor = accessor; _analysis = analysis; _config = config; }
public ManagerController(IEncryptionDataService ncryption, LabContext context, IHttpContextAccessor accessor, ILoadConfigFileService config, IHttpContextAnalysisService analysis, ILoggerService logger) { _ncryption = ncryption; _context = context; _config = config; _analysis = analysis; _logger = logger; }
public ResourceController(LabContext context, IEncryptionDataService encryption, IHostingEnvironment hosting, IHttpContextAnalysisService analysis, IHttpContextAccessor accessor, ILoggerService logger) { _context = context; _hosting = hosting; _analysis = analysis; _accessor = accessor; _logger = logger; }
public ReExamController(IEmailService email, LabContext context, ILoggerService logger, ILoadConfigFileService config, IHttpContextAnalysisService analysis) { _email = email; _context = context; _logger = logger; _config = config; _analysis = analysis; }
public SingleController(LabContext context, IEncryptionDataService encryption, IHttpContextAnalysisService analysis, ILoadConfigFileService config, ILoggerService logger) { _context = context; _encryption = encryption; _analysis = analysis; _config = config; _logger = logger; }
private void SaveEmployees_Click(object sender, RoutedEventArgs e) { if (DG1 != null && DG1.Items != null && unitOfWork.EmployeesUnits != null) { using (LabContext db = new LabContext()) { unitOfWork.EmployeesUnits._EmployeesContext = db; using (var transaction = unitOfWork.EmployeesUnits._EmployeesContext.Database.BeginTransaction()) { try { foreach (var employee in unitOfWork.EmployeesUnits.ListOfEmployees) { if (employee is Employee) { if (unitOfWork.EmployeesUnits._EmployeesContext.Employees.Any(x => x.Id == employee.Id)) { var emp = unitOfWork.EmployeesUnits._EmployeesContext.Employees.FirstOrDefault(el => el.Id == employee.Id); if (emp != null) { unitOfWork.EmployeesUnits._EmployeesContext.Employees.Attach(emp); emp.Name = employee.Name; emp.Post = employee.Post; emp.Wage = employee.Wage; emp.Age = employee.Age; emp.CompanyName = employee.CompanyName; } unitOfWork.EmployeesUnits._EmployeesContext.SaveChanges(); } else { unitOfWork.EmployeesUnits.Save(employee); } } } foreach (var employee in unitOfWork.EmployeesUnits._EmployeesContext.Employees.ToList()) { if (!unitOfWork.EmployeesUnits.ListOfEmployees.Any(elDG => elDG.Id == employee.Id)) { unitOfWork.EmployeesUnits._EmployeesContext.Employees.Remove(employee); } } transaction.Commit(); unitOfWork.EmployeesUnits._EmployeesContext.SaveChanges(); db.SaveChangesAsync(); } catch (Exception ex) { transaction.Rollback(); MessageBox.Show(ex.Message); } } } } }
private void ShowCompanies_Click(object sender, RoutedEventArgs e) { using (LabContext db = new LabContext()) { unitOfWork.CompaniesUnits._CompaniesContext = db; unitOfWork.CompaniesUnits.ListOfCompanies = unitOfWork.CompaniesUnits._CompaniesContext.Companies.ToList(); DG2.DataContext = unitOfWork.CompaniesUnits.ListOfCompanies; db.SaveChangesAsync(); } }
private void ShowEmployees_Click(object sender, RoutedEventArgs e) { using (LabContext db = new LabContext()) { unitOfWork.EmployeesUnits._EmployeesContext = db; unitOfWork.EmployeesUnits.ListOfEmployees = unitOfWork.EmployeesUnits._EmployeesContext.Employees.ToList(); DG1.DataContext = unitOfWork.EmployeesUnits.ListOfEmployees; db.SaveChangesAsync(); } }
public JsonResult GetEvents() { using (LabContext db = new LabContext()) { var events = db.Events.ToList(); return(new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public ApplicationController(IEmailService email, LabContext context, ILoggerService logger, IHostingEnvironment hosting, IHttpContextAnalysisService analysis, IEncryptionDataService encryption, ILoadConfigFileService config) { _email = email; _context = context; _logger = logger; _analysis = analysis; _encryption = encryption; _config = config; }
private void SaveCompanies_Click(object sender, RoutedEventArgs e) { if (DG2 != null && DG2.Items != null && unitOfWork.CompaniesUnits != null) { using (LabContext db = new LabContext()) { unitOfWork.CompaniesUnits._CompaniesContext = db; unitOfWork.EmployeesUnits._EmployeesContext = db; foreach (var company in unitOfWork.CompaniesUnits.ListOfCompanies) { if (company is Company) { if (unitOfWork.CompaniesUnits._CompaniesContext.Companies.Any(x => x.Name == company.Name)) { var el = unitOfWork.CompaniesUnits._CompaniesContext.Companies.FirstOrDefault(elDB => elDB.Name == company.Name); var emp = unitOfWork.EmployeesUnits._EmployeesContext.Employees.FirstOrDefault(empDB => empDB.CompanyName == el.Name); if (emp != null) { unitOfWork.EmployeesUnits._EmployeesContext.Employees.Attach(emp); emp.CompanyName = company.Name; } if (el != null) { unitOfWork.CompaniesUnits._CompaniesContext.Companies.Attach(el); el.Cost = company.Cost; el.Adress = company.Adress; el.Name = company.Name; } unitOfWork.EmployeesUnits._EmployeesContext.SaveChanges(); unitOfWork.CompaniesUnits._CompaniesContext.SaveChanges(); } else { unitOfWork.CompaniesUnits.Save(company); } } } foreach (var el in unitOfWork.CompaniesUnits._CompaniesContext.Companies.ToList()) { if (!unitOfWork.CompaniesUnits.ListOfCompanies.Any(elDG => el.Name == elDG.Name)) { if (unitOfWork.EmployeesUnits.ListOfEmployees.Any(elDG => elDG.CompanyName == el.Name)) { unitOfWork.EmployeesUnits._EmployeesContext.Employees.RemoveRange(unitOfWork.EmployeesUnits._EmployeesContext.Employees.Where(x => x.CompanyName == el.Name)); } unitOfWork.CompaniesUnits._CompaniesContext.Companies.Remove(el); } } unitOfWork.EmployeesUnits._EmployeesContext.SaveChanges(); unitOfWork.CompaniesUnits._CompaniesContext.SaveChanges(); db.SaveChangesAsync(); } } }
public void FinishPaper(ExaminationPaper paper, LabContext context) { if (paper != null) { if (!paper.IsFinish) { if (paper.LeaveExamTime <= 1.0) { paper.LeaveExamTime = 0; } paper.IsFinish = true; if (String.IsNullOrEmpty(paper.Review)) { paper.Review = "学生未作出评价!"; } paper.Score = GetPaperScore(paper.PaperId, context); Student student = context.Student.Find(paper.StudentId); if (student != null) { if (paper.Score >= paper.PassScore) { student.IsPassExam = true; } double middle = Math.Round((paper.Score / paper.TotleScore) * 100, 1); if (middle > student.MaxExamCount) { student.MaxExamScore = (float)middle; } } else { context.LogPricipalOperations.Add(new LogPricipalOperation { PrincpalOperationStatus = PrincpalOperationStatus.Success, AddTime = DateTime.Now, PrincpalOperationCode = PrincpalOperationCode.SystemRuntimeError, OperationIp = "系统运行产生!", PrincpalOperationName = $"试卷ID:{paper.PaperId} ,试卷所属学生学号:{paper.StudentId}", PrincpalOperationContent = "完成试卷的时候发现学生已经被删除! 考试期间管理员删除了学生导致考试异常! 请查看." }); } context.SaveChanges(); } } }
public RouteLegService(LabContext db_, IConfiguration config) { this.db = db_; this.dbSet = db_.Set <RouteLeg>(); AppConfiguration = config; string key = AppConfiguration["googleApi:Key"]; string url = AppConfiguration["googleApi:DirectionsUrl"]; googleApi = new GoogleApi.Direction(key, url); }
public bool DeletePaper(ExaminationPaper ePaper, LabContext context) { if (ePaper != null && context.ExaminationPapers.Any(p => p.PaperId == ePaper.PaperId)) { try { context.Database.BeginTransaction(); context.Database.ExecuteSqlCommand("Delete from ExamJudgeChoices Where PaperId = @pid", new SqlParameter { Value = ePaper.PaperId, ParameterName = "@pid", SqlDbType = SqlDbType.Int }); context.Database.ExecuteSqlCommand("Delete from ExamMultipleChoices Where PaperId = @pid", new SqlParameter { Value = ePaper.PaperId, ParameterName = "@pid", SqlDbType = SqlDbType.Int }); context.Database.ExecuteSqlCommand("Delete from ExamSingleChoices Where PaperId = @pid", new SqlParameter { Value = ePaper.PaperId, ParameterName = "@pid", SqlDbType = SqlDbType.Int }); context.ExaminationPapers.Remove(ePaper); int result = context.SaveChanges(); context.Database.CommitTransaction(); return(result == 1); } catch (Exception e) { context.Database.RollbackTransaction(); Console.WriteLine(e); throw; } } else { return(false); } }
private void SearchCompanies_Click(object sender, RoutedEventArgs e) { Company findingObject = null; var list = new List <Company>(); using (LabContext db = new LabContext()) { unitOfWork.CompaniesUnits._CompaniesContext = db; if (CompanyNameTxtBlock.Text.Count() != 0) { findingObject = unitOfWork.CompaniesUnits._CompaniesContext.Companies.Find(CompanyNameTxtBlock.Text); } if (CompanyCostTxtBlock.Text.Count() != 0) { int cost = 0; if (Int32.TryParse(CompanyCostTxtBlock.Text, out cost)) { if (CompanyNameTxtBlock.Text.Count() == 0) { list = unitOfWork.CompaniesUnits._CompaniesContext.Companies.ToList().Where(x => x.Cost <= cost).ToList(); } else { if (findingObject != null && findingObject.Cost <= cost) { list.Add(findingObject); } } } } else { if (findingObject != null) { list.Add(findingObject); } } DG2.DataContext = list; unitOfWork.CompaniesUnits._CompaniesContext.SaveChangesAsync(); db.SaveChangesAsync(); } }
private void SearchEmployee_Click(object sender, RoutedEventArgs e) { Employee findingObject = null; var list = new List <Employee>(); using (LabContext db = new LabContext()) { unitOfWork.EmployeesUnits._EmployeesContext = db; if (EmpNameTxtBox.Text.Count() != 0) { findingObject = unitOfWork.EmployeesUnits._EmployeesContext.Employees.Where(x => x.Name == EmpNameTxtBox.Text).FirstOrDefault(); } if (EmpAgeTxtBox.Text.Count() != 0) { int age = 0; if (Int32.TryParse(EmpAgeTxtBox.Text, out age)) { if (EmpNameTxtBox.Text.Count() == 0) { list = unitOfWork.EmployeesUnits._EmployeesContext.Employees.ToList().Where(x => x.Age <= age).ToList(); } else { if (findingObject != null && findingObject.Age <= age) { list.Add(findingObject); } } } } else { if (findingObject != null) { list.Add(findingObject); } } DG1.DataContext = list; unitOfWork.EmployeesUnits._EmployeesContext.SaveChangesAsync(); db.SaveChangesAsync(); } }
public static ICollection <Strumento> CheckTTL(LabContext context) { IEnumerable <Strumento> strumenti = context.Strumento.ToList(); ICollection <Strumento> strumentiLowTTL = new List <Strumento>(); foreach (var s in strumenti) { if (s.TTL != new DateTime()) { if (DateTime.Today >= s.TTL.AddDays(-5)) { var TTL = DateTime.Today - s.TTL; strumentiLowTTL.Add(s); } } } return(strumentiLowTTL); }
public JsonResult DeleteEvent(int eventID) { var status = false; using (LabContext db = new LabContext()) { var v = db.Events.Where(a => a.EventID == eventID).FirstOrDefault(); if (v != null) { db.Events.Remove(v); db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public int NotJoinSystemStudentCount(LabContext context) { String sql = "select count(*) from Student where StudentId not in(select StudentId from LogStudentOperations )"; if (context.Database.GetDbConnection().State == ConnectionState.Open) { } else { context.Database.GetDbConnection().Open(); } DbCommand cmd = context.Database.GetDbConnection().CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sql; int result = Convert.ToInt32(cmd.ExecuteScalar()); return(result); }
public float GetPaperScore(int paperId, LabContext context) { ExaminationPaper paper = context.ExaminationPapers.Find(paperId); if (paper == null) { return(-100.0f); } else { float judgeScore = context.ExamJudgeChoices.Where(p => p.PaperId == paper.PaperId) .Where(p => p.RealAnswer == p.StudentAnswer).Sum(p => p.Score); float singleScore = context.ExamSingleChoices.Where(p => p.PaperId == paper.PaperId) .Where(p => p.RealAnswer == p.StudentAnswer).Sum(p => p.Score); float multipleScore = context.ExamMultipleChoices.Where(p => p.PaperId == paper.PaperId) .Where(p => p.RealAnswer == p.StudentAnswer).Sum(p => p.Score); return(judgeScore + singleScore + multipleScore); } }
public ActionResult Login(FormCollection form, bool rememberMe = false) { String Email = form["Email address"].ToString(); String EmpPassword = form["Password"].ToString(); var db = new LabContext(); var currentUser = db.Database.SqlQuery <Employee>( "Select * " + "FROM Employee " + "WHERE Email = '" + Email + "' AND " + "EmpPassword = '******'"); var SPcurrentUser = db.Database.SqlQuery <Location>( "Select * " + "FROM Employee " + "INNER JOIN Location On Employee.LocationID = Location.LocationID " + "WHERE Email = '" + Email + "' AND " + "EmpPassword = '******' AND " + "LocationDescription = 'Singapore'"); if (currentUser.Count() > 0) { if (SPcurrentUser.Count() > 0) { FormsAuthentication.SetAuthCookie(Email, rememberMe); return(RedirectToAction("About", "Home", new { userlogin = Email })); } else { FormsAuthentication.SetAuthCookie(Email, rememberMe); return(RedirectToAction("Index", "Worker", new { userlogin = Email })); } } else { return(View()); } }
public StudentViewModel(Student student, LabContext context) { if (student == null) { throw new Exception("传入的学生为null"); } this.Name = student.Name; this.LearningTime = context.Progresses.Where(s => s.StudentId == student.StudentId).Sum(v => v.StudyTime); this.MaxScore = student.MaxExamScore; this.ExamTime = context.ExaminationPapers.Count(p => p.StudentId == student.StudentId); this.Sex = student.Sex ? "男" : "女"; this.ApplicationTime = context.ApplicationForReExaminations.Count(a => a.StudentId == student.StudentId); this.StudentId = student.StudentId; this.Grade = student.Grade; this.IsPass = student.IsPassExam ? "Yes" : "No"; this.StudentType = student.StudentType == Map.StudentType.PostGraduate ? "研究生" : "本科生"; this.HeadPortrait = student.Sex ? "student_nan.png" : "student_nv.png"; this.Email = student.Email; this.InstituteName = context.Institute.Find(student.InstituteId).Name; this.ProfessionName = context.Professions.Find(student.ProfessionId).Name; this.Phone = student.Phone; }
public ActionResult Login(FormCollection form, bool rememberMe = false) { String email = form["Email"].ToString(); String password = form["Password"].ToString(); var db = new LabContext(); var currentUser = db.Database.SqlQuery <Customer>( "Select * " + "FROM Customer " + "WHERE Email = '" + email + "' AND " + "Password = '******'"); if (currentUser.Count() > 0) { FormsAuthentication.SetAuthCookie(email, rememberMe); return(RedirectToAction("Index")); } else { return(View()); } }