public ActionResult Create(DepartmentViewModel DeptVM)
{
if (ModelState.IsValid)
{
Department dept = new Department();
dept.Name = DeptVM.Name;
db.Departments.Add(dept);
db.SaveChanges();
DepartmentLocation deptLoc = new DepartmentLocation();
deptLoc.DepartmentID = dept.DepartmentID;
deptLoc.Location = DeptVM.Location;
db.DepartmentLocations.Add(deptLoc);
db.SaveChanges();
DepartmentManager deptMan = new DepartmentManager();
deptMan.DepartmentID = dept.DepartmentID;
deptMan.EmployeeId = DeptVM.EmployeeId;
deptMan.StartDate = DeptVM.StartDate;
db.DepartmentManagers.Add(deptMan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(DeptVM));
}
public async Task <IActionResult> Edit(int id, [Bind("DepartmentID,LocationID")] DepartmentLocation departmentLocation)
{
if (id != departmentLocation.DepartmentID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(departmentLocation);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DepartmentLocationExists(departmentLocation.DepartmentID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["DepartmentID"] = new SelectList(_context.Departments, "ID", "ID", departmentLocation.DepartmentID);
ViewData["LocationID"] = new SelectList(_context.Locations, "ID", "ID", departmentLocation.LocationID);
return(View(departmentLocation));
}
private void frmEmergencyMaintenanceRequest_Load(object sender, EventArgs e)
{
Dictionary <string, string> tt = this.Tag as Dictionary <string, string>;
//Fill data to group box Selected Asset
lblAssetSNValue.Text = tt["AssetSN"];
lblAssetNameValue.Text = tt["AssetName"];
Session2Entities db = new Session2Entities();
Asset asset = (from x in db.Assets
where x.AssetSN == lblAssetSNValue.Text && x.AssetName == lblAssetNameValue.Text
select x).FirstOrDefault <Asset>();
IEnumerable <EmergencyMaintenance> list_em = from x in db.EmergencyMaintenances
where x.AssetID == asset.ID
select x;
DepartmentLocation departmentLocation = (from x in db.DepartmentLocations
where x.ID == asset.DepartmentLocationID
select x).FirstOrDefault <DepartmentLocation>();
Department department = (from x in db.Departments
where x.ID == departmentLocation.DepartmentID
select x).FirstOrDefault <Department>();
lblDepartmentValue.Text = department.Name;
//Load combobox
foreach (Priority temp in (from x in db.Priorities select x))
{
cbPriority.Items.Add(temp);
}
cbPriority.DisplayMember = "Name";
cbPriority.ValueMember = "ID";
cbPriority.SelectedIndex = 0;
}
public async Task <IActionResult> Create([Bind("DepartmentID,LocationID")] DepartmentLocation departmentLocation)
{
if (ModelState.IsValid)
{
_context.Add(departmentLocation);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DepartmentID"] = new SelectList(_context.Departments, "ID", "ID", departmentLocation.DepartmentID);
ViewData["LocationID"] = new SelectList(_context.Locations, "ID", "ID", departmentLocation.LocationID);
return(View(departmentLocation));
}
public dynamic Post([FromBody] object json2)
{
try
{
Dictionary <string, object> json = JsonConvert.DeserializeObject <Dictionary <string, object> >(json2.ToString());
db = new WSC2019_SS1Entities();
Models.Asset asset = new Models.Asset();
asset.AssetName = json["AssetName"].ToString();
asset.AssetSN = json["AssetSN"].ToString();
asset.AssetGroupID = Convert.ToInt32(json["AssetGroupID"]);
asset.Description = json["Description"].ToString();
asset.WarrantyDate = Convert.ToInt32(json["WarrantyDate"]);
asset.EmployeeID = Convert.ToInt32(json["EmployeeID"]);
int locationid = Convert.ToInt32(json["LocationID"]);
int departmentid = Convert.ToInt32(json["DepartmentID"]);
DepartmentLocation dl = db.DepartmentLocations.Where(x => x.LocationID == locationid && x.DepartmentID == departmentid).SingleOrDefault();
if (dl == null)
{
dl.DepartmentID = departmentid;
dl.LocationID = locationid;
dl.StartDate = DateTime.Now;
db.DepartmentLocations.Add(dl);
db.SaveChanges();
dl = db.DepartmentLocations.Where(x => x.LocationID == locationid && x.DepartmentID == departmentid).SingleOrDefault();
}
asset.DepartmentLocationID = dl.ID;
db.Assets.Add(asset);
db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
//=====================================================================
// GET: Departments/Edit/5
public ActionResult Edit(int?id)
{
Department dept = db.Departments.Find(id);
DepartmentManager dm = db.DepartmentManagers.Where(x => x.DepartmentID == id).FirstOrDefault();
DepartmentLocation dl = db.DepartmentLocations.Where(x => x.DepartmentID == id).FirstOrDefault();
DepartmentViewModel model = new DepartmentViewModel();
//model.MyList = new SelectList(from s in db.Employees.ToList()
// select new
// {
// EmplyeeId = s.EmployeeId,
// FullName = s.FirstName + " " + s.LastName
// },
// "EmplyeeId",
// "FullName",
// new { dm.EmployeeId });
//var Selects = (from s in db.Departments
// join n in db.DepartmentLocations
// on s.DepartmentID equals n.DepartmentID
// join m in db.DepartmentManagers
// on s.DepartmentID equals m.DepartmentID
// join z in db.Employees
// on m.DepartmentID equals z.DepartmentID
// where m.EmployeeId == z.EmployeeId
// select new
// {
// DepartmentID = s.DepartmentID,
// EmployeeId = z.EmployeeId,
// Name = s.Name,
// NumberOfEmps = s.NumberOfEmps,
// Location = n.Location,
// StartDate = m.StartDate,
// FirstName = z.FirstName,
// LastName = z.LastName
// }).FirstOrDefault();
model.DepartmentID = dept.DepartmentID;
model.Name = db.Departments.Where(m => m.DepartmentID == id).Select(x => x.Name).FirstOrDefault();
model.NumberOfEmps = db.Departments.Where(m => m.DepartmentID == id).Select(x => x.NumberOfEmps).FirstOrDefault();
model.Location = db.DepartmentLocations.Where(m => m.DepartmentID == id).Select(x => x.Location).FirstOrDefault();
model.StartDate = db.DepartmentManagers.Where(m => m.DepartmentID == id).Select(x => x.StartDate).FirstOrDefault();
model.FirstName = db.DepartmentManagers.Where(m => m.DepartmentID == id).Select(x => x.Employee.FirstName).FirstOrDefault();
model.LastName = db.DepartmentManagers.Where(m => m.DepartmentID == id).Select(x => x.Employee.LastName).FirstOrDefault();
model.EmployeeId = db.DepartmentManagers.Where(m => m.DepartmentID == id).Select(x => x.EmployeeId).FirstOrDefault();
//model.DepartmentID = dept.DepartmentID;
//model.Name = dept.Name;
//model.Location = dl.Location;
//model.EmployeeId = dm.EmployeeId;
//model.StartDate = dm.StartDate;
TempData["GetLocation"] = model.Location;
TempData["EmpID"] = model.EmployeeId;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (dept == null)
{
return(HttpNotFound());
}
return(View(model));
}
public static void Initialize(EmployeeContext context)
{
// Look for any employees.
if (context.Employees.Any())
{
return; // DB has been seeded
}
var dept = new Department[]
{
new Department {
Name = "Accounting"
},
new Department {
Name = "IT"
},
new Department {
Name = "Marketing"
},
new Department {
Name = "Sales"
},
new Department {
Name = "Management"
},
new Department {
Name = "Plant"
},
new Department {
Name = "Shipping"
},
new Department {
Name = "Warehouse"
}
};
foreach (Department d in dept)
{
context.Departments.Add(d);
}
context.SaveChanges();
var loc = new Location[]
{
new Location {
Type = Models.Type.Headquarters, Address = "2200 Park Ave", Zipcode = "49696"
},
new Location {
Type = Models.Type.Warehouse, Address = "2200 Park Ave", Zipcode = "49696"
},
new Location {
Type = Models.Type.Sales, Address = "2200 Park Ave", Zipcode = "49696"
},
new Location {
Type = Models.Type.Plant, Address = "2100 Park Ave", Zipcode = "49696"
},
new Location {
Type = Models.Type.Plant, Address = "6 Hickory Blvd.", Zipcode = "49696"
},
new Location {
Type = Models.Type.Satellite, Address = "6 Hickory Blvd.", Zipcode = "49696"
}
};
foreach (Location l in loc)
{
context.Locations.Add(l);
}
context.SaveChanges();
var emp = new Employee[]
{
new Employee {
ID = 1012, FirstName = "Freddie", LastName = "Flintstone", HireDate = DateTime.Parse("2020-09-01"), DepartmentID = 1
},
new Employee {
ID = 1067, FirstName = "Wilma", LastName = "Flintstone", HireDate = DateTime.Parse("2005-07-01"), DepartmentID = 2
},
new Employee {
ID = 1098, FirstName = "Barney", LastName = "Rubble", HireDate = DateTime.Parse("2021-09-01"), DepartmentID = 3
},
new Employee {
ID = 100, FirstName = "Judy", LastName = "Jetson", HireDate = DateTime.Parse("2019-02-01"), DepartmentID = 4
},
new Employee {
ID = 101, FirstName = "Daphne", LastName = "Blake", HireDate = DateTime.Parse("2010-01-01"), DepartmentID = 5
}
};
foreach (Employee e in emp)
{
context.Employees.Add(e);
}
context.SaveChanges();
var empBenefits = new Benefits[]
{
new Benefits {
EmployeeID = 1012, Category = Category.family, Dental = true, Health = true, Vision = true, LifeIns = 100000
},
new Benefits {
EmployeeID = 1067, Category = Category.none, LifeIns = 100000
},
new Benefits {
EmployeeID = 100
},
new Benefits {
EmployeeID = 1098
},
new Benefits {
EmployeeID = 101, Category = Category.single, Dental = true, Health = true, Vision = true, LifeIns = 50000
}
};
foreach (Benefits b in empBenefits)
{
context.Benefits.Add(b);
}
context.SaveChanges();
var deptLoc = new DepartmentLocation[]
{
new DepartmentLocation {
DepartmentID = 1, LocationID = 1
},
new DepartmentLocation {
DepartmentID = 2, LocationID = 1
},
new DepartmentLocation {
DepartmentID = 3, LocationID = 1
},
new DepartmentLocation {
DepartmentID = 4, LocationID = 1
},
new DepartmentLocation {
DepartmentID = 5, LocationID = 1
},
new DepartmentLocation {
DepartmentID = 8, LocationID = 1
},
new DepartmentLocation {
DepartmentID = 6, LocationID = 4
},
new DepartmentLocation {
DepartmentID = 7, LocationID = 5
},
new DepartmentLocation {
DepartmentID = 7, LocationID = 5
}
};
foreach (DepartmentLocation dl in deptLoc)
{
context.DepartmentLocation.Add(dl);
}
context.SaveChanges();
}