/// <summary> /// Method to REMOVE Department /// </summary> /// <param name="department">Department to Remove</param> public void RemoveDepartment(Department department) { Department parent = DepartmentsDb.Find(x => x.DepartmentName == department.ParentDepartment); if (parent != null) { parent.innerDepartments.Remove(department); } else { company.Clear(); } if (department.DepartmentName != DepartmentsDb.Find(x => x is Company).DepartmentName) { RemoveChildren(department); DepartmentsDb.Remove(department); } else { DepartmentsDb.Clear(); } EmployeesDB = EmployeesDB.Where(x => x.Department != department.DepartmentName).ToList(); }
static async Task Main(string[] args) { const string connection_str = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Employees.DB;Integrated Security=True"; //var service_collection = new ServiceCollection(); //service_collection.AddDbContext<EmployeesDB>(o => o.UseSqlServer(connection_str)); //var service = service_collection.BuildServiceProvider(); using (var db = new EmployeesDB(new DbContextOptionsBuilder <EmployeesDB>().UseSqlServer(connection_str).Options)) { await db.Database.EnsureCreatedAsync(); var k = 0; if (await db.Employees.CountAsync() == 0) { EmployeesFromFile.MyThread thread = new EmployeesFromFile.MyThread(); thread.Thrd.Join(); for (var i = 0; i < EmployeesFromFile.GetEmployees.Count; i++) { await db.Employees.AddAsync(EmployeesFromFile.GetEmployees[i]); } await db.SaveChangesAsync(); } } Console.WriteLine("Основной поток закончил работу"); Console.ReadLine(); }
protected override void Seed(EmployeesDB context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. }
/// <summary> /// SET Employee Values for Properties /// </summary> /// <param name="node">XML node to get Values</param> /// <param name="dept">Department to add Values</param> void DefineEmployeeClass(XmlNode node, Employee emply) { emply.EmployeeName = Convert.ToString(node.Attributes.GetNamedItem("employeeName").Value); emply.LastName = Convert.ToString(node.Attributes.GetNamedItem("lastName").Value); emply.Age = Convert.ToInt32(node.Attributes.GetNamedItem("age").Value); emply.Department = Convert.ToString(node.Attributes.GetNamedItem("department").Value); emply.DaysWorked = Convert.ToInt32(node.Attributes.GetNamedItem("daysWorked").Value); emply.Repository = this; EmployeesDB.Add(emply); }
public DepartmentsManager() { using (var db = new EmployeesDB()) { DepartmentsArray = db.Departments.ToArray(); } using (var db = new EmployeesDB()) { for (var department_n = 1; department_n <= DepartmentsArray.Length; department_n++) { DepartmentsArray[department_n - 1].Employees = db.Employees .Where(employee => employee.Department.Id == department_n).ToList <EmployeeEntity>(); } } }
public ActionResult Account(EmployeeData ED, HttpPostedFileBase ProfileImage) { try { if (ModelState.IsValid) { int NameID = 1; //created the Database Object sdirecttestdbEntities dbEntities = new sdirecttestdbEntities(); //created the table object EmployeesDB edb = new EmployeesDB(); edb.FullName = ED.FullName; edb.Email = ED.Email; edb.DateOfBirth = ED.DateOfBirth; edb.Address = ED.Address; if (ProfileImage != null && ProfileImage.ContentLength > 0) { //get the path where we want to store our image string path = Path.Combine(Server.MapPath("~/uploads"), Path.GetFileName(ProfileImage.FileName)); //move the image to upload folder ProfileImage.SaveAs(path); ViewBag.message = "file uploaded"; } edb.ImageActualName = Path.GetFileName(ProfileImage.FileName); string ptr = Convert.ToString(NameID + "1_"); edb.ImageName = string.Concat(ptr, ED.ImageName); edb.CountryId = ED.CountryId; edb.StateId = ED.StateId; //store the data into table dbEntities.EmployeesDBs.Add(edb); //update the table with new data dbEntities.SaveChanges(); int ID = edb.UserId; NameID = NameID + 1; } ViewBag.CountryList = new SelectList(GetCountryList(), "ID", "CountryName"); ModelState.Clear(); return(View()); } catch (Exception) { throw new Exception("Filed is not valid"); } }
/// <summary> /// Method to ADD new Employee /// </summary> /// <param name="Name">New Employee Name</param> /// <param name="LastName">New Employee Last Name</param> /// <param name="Age">New Employee Age</param> /// <param name="Department">New Employee Department</param> public void AddEmployee(string Name, string LastName, int Age, string Department, int employeeClass) { Employee employee; switch (employeeClass) { case 0: employee = new Intern(Name, LastName, Age, Department, 0); break; case 1: employee = new Worker(Name, LastName, Age, Department, 0); break; case 2: employee = new HeadOfDepartment(Name, LastName, Age, Department, 0); break; case 3: employee = new HeadOfOrganization(Name, LastName, Age, Department, 0); break; default: employee = new Employee(Name, LastName, Age, Department, 0); break; } EmployeesDB.Add(employee); }
public MainWindow() { InitializeComponent(); using (var db = new EmployeesDB()) { var employees_count = db.Employees.Count(); Title = $"Сотрудников в базе {employees_count}"; } using (var db = new EmployeesDB()) if (!db.Departments.Any()) { int epmloyee_n = 1; for (int department_n = 1; department_n <= 5; department_n++) { var department = new DepartmentEntity { Name = $"Department {department_n}" }; for (int i = 0; i < 5; i++) { var employee = new EmployeeEntity { Name = $"Сотрудник {epmloyee_n}", Surname = $"Сотрудник {epmloyee_n}" }; department.Employees.Add(employee); epmloyee_n++; } db.Departments.Add(department); } db.SaveChanges(); } }
public EmployeesStoreInDB(EmployeesDB empl) { _empl = empl; }
/// <summary> /// Method to REMOVE Employee /// </summary> /// <param name="employee">Employee to Remove</param> public void RemoveEmployee(Employee employee) { EmployeesDB.Remove(employee); mainWindow.LoadEmployeesToListView(); }