public IHttpActionResult PutDeparments(int id, Deparments deparments) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != deparments.Id) { return(BadRequest()); } db.Entry(deparments).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DeparmentsExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PostDeparments(int id, Deparments deparments) { Deparments curDep = db.Deparments.Find(id); if (curDep == null) { return(NotFound()); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { curDep.DepName = deparments.DepName; db.SaveChanges(); } catch (Exception e) { return(BadRequest(e.Message)); } return(Created("Employees DB", Mapper.Map <Deparments, Deparments>(curDep))); }
public IHttpActionResult GetDeparments(int id) { Deparments deparments = db.Deparments.Find(id); if (deparments == null) { return(NotFound()); } return(Ok(Mapper.Map <Deparments, Deparments> (deparments))); }
public ActionResult AddNewDepartment(string deptName, int facultyID) { SISEntities db = new SISEntities(); Deparments deparment = new Deparments { d_Name = deptName, d_Faculties_TableID = facultyID, }; db.Deparments.Add(deparment); db.SaveChanges(); return(View()); }
public IHttpActionResult DeleteDeparments(int id) { Deparments deparments = db.Deparments.Find(id); if (deparments == null) { return(NotFound()); } db.Deparments.Remove(deparments); db.SaveChanges(); return(Ok(Mapper.Map <Deparments, Deparments>(deparments))); }
public IHttpActionResult PostDeparments(Deparments deparments) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { db.Deparments.Add(deparments); db.SaveChanges(); } catch (Exception e) { return(BadRequest(e.Message)); } return(Created("Employees DB", Mapper.Map <Deparments, Deparments>(deparments))); }
public async Task <IActionResult> Create([Bind("Id,Name")] Deparments deparments) { var dep_name = from d in _context.Deparments select d.Name; if (dep_name.Contains(deparments.Name)) { ModelState.AddModelError("Name", "This name is already exist"); return(View(deparments)); } if (ModelState.IsValid && !dep_name.Contains(deparments.Name)) { _context.Add(deparments); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(RedirectToAction("Index", new { error = "Не створено" })); }
public async Task <IActionResult> Edit(long id, [Bind("Id,Name")] Deparments deparments) { var dep_name = from d in _context.Deparments select d.Name; if (dep_name.Contains(deparments.Name)) { ModelState.AddModelError("Name", "This name is already exist"); return(View(deparments)); } if (id != deparments.Id) { return(NotFound()); } if (ModelState.IsValid && !dep_name.Contains(deparments.Name)) { try { _context.Update(deparments); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DeparmentsExists(deparments.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(RedirectToAction("Index", new { error = "Не редаговано" })); }
public async Task <IActionResult> Import(IFormFile fileExcel) { if (ModelState.IsValid) { if (fileExcel != null) { using (var stream = new FileStream(fileExcel.FileName, FileMode.Create)) { await fileExcel.CopyToAsync(stream); using (XLWorkbook workBook = new XLWorkbook(stream, XLEventTracking.Disabled)) { //перегляд усіх листів (в даному випадку категорій) foreach (IXLWorksheet worksheet in workBook.Worksheets) { if (worksheet.Name == "Departments") { foreach (IXLRow row in worksheet.RowsUsed().Skip(1)) { try { if (row.Cell(1) != null && row.Cell(2) != null) { Deparments dep = new Deparments(); Groups group = new Groups(); dep.Name = row.Cell(1).Value.ToString(); group = _context.Groups.Where(g => g.Name == row.Cell(2).Value.ToString()).FirstOrDefault(); if (group == null) { group = new Groups(); group.Name = row.Cell(2).Value.ToString(); } var names_d = (from d in _context.Deparments select d.Name).ToList(); if (!names_d.Contains(row.Cell(1).Value.ToString())) { _context.Deparments.Add(dep); await _context.SaveChangesAsync(); } group.DepartmentId = _context.Deparments.Where(d => d.Name == dep.Name).FirstOrDefault().Id; var names_g = (from g in _context.Groups select g.Name).ToList(); if (!names_g.Contains(row.Cell(2).Value.ToString())) { _context.Groups.Add(group); await _context.SaveChangesAsync(); for (int i = 1; i < 8; i++) { Shedule shedule = new Shedule(); shedule.GroupId = group.Id; shedule.DayId = i; _context.Shedule.Add(shedule); } } else { _context.Groups.Update(group); } await _context.SaveChangesAsync(); } } catch (Exception) { } } } else if (worksheet.Name == "Schedules") { foreach (IXLRow row in worksheet.RowsUsed().Skip(1)) { try { Groups group = _context.Groups.Where(g => g.Name == row.Cell(1).Value.ToString()).FirstOrDefault(); var names_g = (from g in _context.Groups select g.Name).ToList(); if (names_g.Contains(group.Name)) { var names_l = (from l in _context.Lessons select l.Name).ToList(); Shedule shedule = _context.Shedule.Where(s => s.GroupId == group.Id && s.Day.Name == row.Cell(2).Value.ToString()).FirstOrDefault(); for (int i = 3; i < 8; i++) { LessonToschedule lts = new LessonToschedule(); LessonToschedule lts1 = _context.LessonToschedule.Where(l => l.ScheduleId == shedule.Id && l.Num == i - 2).FirstOrDefault(); if (lts1 != null) { if (row.Cell(i).Value.ToString() != null && names_l.Contains(row.Cell(i).Value.ToString())) { lts1.ScheduleId = shedule.Id; lts1.LessonId = _context.Lessons.Where(l => l.Name == row.Cell(i).Value.ToString()).FirstOrDefault().Id; _context.LessonToschedule.Update(lts1); } else { _context.LessonToschedule.Remove(lts1); } } else { lts1 = new LessonToschedule(); if (row.Cell(i).Value.ToString() != null && names_l.Contains(row.Cell(i).Value.ToString())) { lts1.ScheduleId = shedule.Id; lts1.Num = i - 2; lts1.LessonId = _context.Lessons.Where(l => l.Name == row.Cell(i).Value.ToString()).FirstOrDefault().Id; _context.LessonToschedule.Add(lts1); } } await _context.SaveChangesAsync(); } } } catch (Exception) { //logging самостійно :) } } } else { //worksheet.Name - назва категорії. Пробуємо знайти в БД, якщо відсутня, то створюємо нову Groups newcat; var c = (from cat in _context.Groups where cat.Name.Contains(worksheet.Name) select cat).ToList(); if (c.Count > 0) { newcat = c[0]; foreach (IXLRow row in worksheet.RowsUsed().Skip(1)) { try { Students student = new Students(); student = _context.Students.Where(s => s.Name == row.Cell(1).Value.ToString() && s.Surname == row.Cell(2).Value.ToString() && s.Gender == row.Cell(3).Value.ToString() && s.Birthday == Convert.ToDateTime(row.Cell(4).Value.ToString())).FirstOrDefault(); if (student == null) { student = new Students(); student.Name = row.Cell(1).Value.ToString(); student.Surname = row.Cell(2).Value.ToString(); student.Gender = row.Cell(3).Value.ToString(); student.Birthday = Convert.ToDateTime(row.Cell(4).Value.ToString()); student.GroupId = newcat.Id; _context.Students.Add(student); } else { student.Name = row.Cell(1).Value.ToString(); student.Surname = row.Cell(2).Value.ToString(); student.Gender = row.Cell(3).Value.ToString(); student.Birthday = Convert.ToDateTime(row.Cell(4).Value.ToString()); student.GroupId = newcat.Id; _context.Students.Update(student); } await _context.SaveChangesAsync(); } catch (Exception) { //logging самостійно :) } } } } } } } } await _context.SaveChangesAsync(); } return(RedirectToAction("Index", "Home")); }