public async Task <Em.Employees> PutAsync(string id, Em.Employees updateRequest)
{
int empNo;
if (!int.TryParse(id, out empNo))
{
return(await Task.FromResult <Em.Employees>(null));
}
Em.Employees employee = await _context.Employees
.Where(i => i.EmpNo == empNo)
.FirstOrDefaultAsync();
// try {
// DataCloneExtension.CopyProperties(updateRequest, employee);
// } catch(Exception ex) {
// var e = ex;
// }
employee.FirstName = updateRequest.FirstName;
employee.LastName = updateRequest.LastName;
employee.BirthDate = updateRequest.BirthDate;
employee.HireDate = updateRequest.HireDate;
employee.Gender = updateRequest.Gender;
_context.Entry(employee).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(updateRequest);
}
static void Task_8()
{
Console.Write("Введите город, который хотите удалить: ");
string town = Console.ReadLine();
var townDb = context.Towns
.Where(t => t.Name.Contains(town))
.FirstOrDefault();
if (townDb == null)
{
Console.WriteLine("Данного города не существует, повторите попытку..");
return;
}
else
{
context.Entry(townDb).Collection(c => c.Addresses).Load();
context.Towns.Remove(townDb);
try
{
context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e.InnerException.Message);
return;
}
Console.WriteLine("Город {0} был удалён.", town);
}
}
static void DeleteTown()
{
Console.Write("Town: ");
string town = Console.ReadLine();
var towns = _context.Towns
.Where(t => t.Name.Contains(town))
.FirstOrDefault();
_context.Entry(towns).Collection(t => t.Addresses).Load();
_context.Towns.Remove(towns);
_context.SaveChanges();
}
public ActionResult AddorEdit(Employee emp)
{
try
{
if (emp.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(emp.ImageUpload.FileName);
string extension = Path.GetExtension(emp.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
emp.ImagePath = "~/AppFiles/Images/" + fileName;
emp.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
using (EmployeesContext db = new EmployeesContext())
{
if (emp.EmployeeID == 0)
{
db.Employees.Add(emp);
db.SaveChanges();
}
else
{
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
}
}
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = true, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public IHttpActionResult PutEmployee(int id, Employee employee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != employee.Id)
{
return(BadRequest());
}
db.Entry(employee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> PutEmployees([FromRoute] int id, [FromBody] Employee employee)
{
if (id != employee.EmployeeId)
{
return(BadRequest());
}
_context.Entry(employee).State = EntityState.Modified;
try
{
await CreateOrEditAddresses(employee.Addresses);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutEmployee(long id, Employee employee)
{
if (id != employee.Id)
{
return(BadRequest());
}
_context.Entry(employee).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult Edit(Employees employees)
{
if (ModelState.IsValid)
{
db.Entry(employees).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employees));
}
public ActionResult Edit([Bind(Include = "Id,DepartmentName,Director")] Department department)
{
if (ModelState.IsValid)
{
db.Entry(department).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(department));
}
public ActionResult Edit([Bind(Include = "Id,Name,Department")] Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public async Task <Em.VwEmpDetails> PutAsync(string id, Em.VwEmpDetails updateRequest)
{
int empNo;
if (!int.TryParse(id, out empNo))
{
return(await Task.FromResult <Em.VwEmpDetails>(null));
}
Em.Employees employee = await _context.Employees
.Where(i => i.EmpNo == empNo)
.FirstOrDefaultAsync();
Em.VwSalariesCurrent salary = await _context.VwSalariesCurrent
.Where(i => i.EmpNo == empNo)
.FirstOrDefaultAsync();
Em.VwTitlesCurrent title = await _context.VwTitlesCurrent
.Where(i => i.EmpNo == empNo)
.FirstOrDefaultAsync();
Em.VwDeptEmpCurrent deptEmp = await _context.VwDeptEmpCurrent
.Where(i => i.EmpNo == empNo)
.FirstOrDefaultAsync();
if (title.Title != updateRequest.Title)
{
throw new NotImplementedException();
}
if (salary.Salary != updateRequest.Salary)
{
throw new NotImplementedException();
}
if (deptEmp.DeptNo != updateRequest.DeptNo)
{
throw new NotImplementedException();
}
if (employeeBasicInfoChanged(employee, updateRequest))
{
employee.BirthDate = updateRequest.BirthDate;
employee.FirstName = updateRequest.FirstName;
employee.LastName = updateRequest.LastName;
employee.Gender = updateRequest.Gender;
employee.HireDate = updateRequest.HireDate;
_context.Entry(employee).State = EntityState.Modified;
}
await _context.SaveChangesAsync();
return(updateRequest);
}
public ActionResult Edit([Bind(Include = "Id,Fullname,CIN,DepartmentId")] Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DepartmentName", employee.DepartmentId);
return(View(employee));
}
public ActionResult DeleteCrewFlight(int cId, int fId, int?jj)
{
using (EmployeesContext db = new EmployeesContext())
{
Employee ex = db.crew.Find(cId, fId);
db.Entry(ex).State = EntityState.Deleted;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(int id, Employee employee)
{
try
{
dbEmployee.Entry(employee).State = EntityState.Modified;
dbEmployee.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}
static void Task8()
{
string town = Console.ReadLine();
var towns = (
from t in _context.Towns
where t.Name == town
select t
).First();
_context.Entry(towns).Collection(t => t.Addresses).Load();
_context.Towns.Remove(towns);
_context.SaveChanges();
}
public async Task <Departments> PutAsync(string id, Departments updateRequest)
{
IQueryable <Departments> result =
from d in this._context.Departments
where d.DeptNo == id
select d;
var dept = await result.FirstAsync();
dept.DeptName = updateRequest.DeptName;
_context.Entry(dept).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(dept);
}
public IHttpActionResult PutEmployee(Employees editEmployee)
{
var emp = db.EmployeeList.Find(editEmployee.EmployeeID);
if (emp != null)
{
emp.EmployeeName = editEmployee.EmployeeName;
emp.Address = editEmployee.Address;
emp.Email = editEmployee.Email;
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
return(Ok());
}
return(NotFound());
}
public void Update(Employee item)
{
_db.Entry(item).State = EntityState.Modified;
}
