public ActionResult Create(string id) { ViewBag.Country = dbcontext.Country.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Area = dbcontext.Area.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.the_states = dbcontext.the_states.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Territories = dbcontext.Territories.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.cities = dbcontext.cities.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.postcode = dbcontext.postcode.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Employee_Profile = dbcontext.Employee_Profile.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.idemp = id; var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Personnel); var model = dbcontext.Employee_Address_Profile.ToList(); var count = 0; if (model.Count() == 0) { count = 1; } else { var te = model.LastOrDefault().ID; count = te + 1; } var ID = int.Parse(id); var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == ID); var EmployeeAddress = new Employee_Address_Profile { Employee_Profile = emp, Employee_ProfileId = emp.ID.ToString(), Code = stru.Structure_Code + count.ToString() }; return(View(EmployeeAddress)); }
public ActionResult Create(Employee_Address_Profile model, string command) { try { //if (model.countryid == null) { model.countryid = "0"; } //if (model.areaid == null) { model.areaid = "0"; } //if (model.stateid == null) { model.stateid = "0"; } if (model.Territoriesid == null) { model.Territoriesid = "0"; } if (model.citiesid == null) { model.citiesid = "0"; } if (model.postcodeId == null) { model.postcodeId = "0"; } ViewBag.Employee_Profile = dbcontext.Employee_Profile.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Country = dbcontext.Country.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Area = dbcontext.Area.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.the_states = dbcontext.the_states.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Territories = dbcontext.Territories.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.cities = dbcontext.cities.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.postcode = dbcontext.postcode.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); //ViewBag.Employee_Profile = dbcontext.Employee_Profile.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); //ViewBag.idemp = model.ID; //if (ModelState.IsValid) //{ // var prof = int.Parse(model.Employee_ProfileId); // var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == prof); var EmpObj = dbcontext.Employee_Profile.FirstOrDefault(a => a.ID == model.Employee_Profile.ID); var list = dbcontext.Employee_Address_Profile.ToList(); Employee_Address_Profile record = new Employee_Address_Profile(); if (list.Count() == 0) { record.Resident = true; } else { var te = list.LastOrDefault(); te.Resident = false; record.Resident = true; } record.Code = model.Code; record.Streetname = model.Streetname; record.Streetnumber = model.Streetnumber; record.Pobox = model.Pobox; record.DistancefromMeetingpointtoworklocationkm = model.DistancefromMeetingpointtoworklocationkm; record.Distancetoworklocationkm = model.Distancetoworklocationkm; record.Transportation_method = model.Transportation_method; var empid = EmpObj.Code + "------" + EmpObj.Name; record.Employee_ProfileId = model.Employee_ProfileId == null ? model.Employee_ProfileId = EmpObj.ID.ToString() : model.Employee_ProfileId; ViewBag.idemp = model.Employee_ProfileId; record.Employee_Profile = EmpObj; record.countryid = model.countryid; var Countryid = int.Parse(model.countryid); record.Country = dbcontext.Country.FirstOrDefault(m => m.ID == Countryid); record.areaid = model.areaid; var Areaid = int.Parse(model.areaid); record.Area = dbcontext.Area.FirstOrDefault(m => m.ID == Areaid); record.stateid = model.stateid; var the_statesid = int.Parse(model.stateid); record.the_states = dbcontext.the_states.FirstOrDefault(m => m.ID == the_statesid); record.Territoriesid = model.Territoriesid; var Territoriesid = int.Parse(model.Territoriesid); record.Territories = dbcontext.Territories.FirstOrDefault(m => m.ID == Territoriesid); record.citiesid = model.citiesid; var citiesid = int.Parse(model.citiesid); record.cities = dbcontext.cities.FirstOrDefault(m => m.ID == citiesid); record.postcodeId = model.postcodeId; var postcodeId = int.Parse(model.postcodeId); record.postcode = dbcontext.postcode.FirstOrDefault(m => m.ID == postcodeId); dbcontext.Employee_Address_Profile.Add(record); dbcontext.SaveChanges(); if (command == "Submit") { return(RedirectToAction("edit", "Employee_Profile", new { id = EmpObj.ID })); //int.Parse(record.Employee_ProfileId) } return(RedirectToAction("Index", new { id = EmpObj.ID })); //model.Employee_ProfileId //} //else //{ // return View(model); //} return(View(model)); } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }