public ActionResult DeleteConfirmed(int id) { PayScaleType payScaleType = db.PayScaleTypes.Find(id); db.PayScaleTypes.Remove(payScaleType); db.SaveChanges(); return(RedirectToAction("Create")); }
public ActionResult DeleteConfirmed(int id) { PayScaleType payScaleType = db.PayScaleTypes.Find(id); db.PayScaleTypes.Remove(payScaleType); db.SaveChanges(); TempData["Success"] = "PayScaleType is deleted Successfully"; return(RedirectToAction("Create")); }
public ActionResult Edit([Bind(Include = "Id,name")] PayScaleType payScaleType) { if (ModelState.IsValid) { db.Entry(payScaleType).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Create")); } ViewBag.Status = "Update"; return(View("CreateList", new PayScaleTypeViewModel { PayScaleTypes = db.PayScaleTypes.ToList() })); }
// GET: PayScaleTypes/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PayScaleType payScaleType = db.PayScaleTypes.Find(id); if (payScaleType == null) { return(HttpNotFound()); } return(View(payScaleType)); }
public ActionResult Create([Bind(Include = "Id,name")] PayScaleType payScaleType) { if (ModelState.IsValid) { db.PayScaleTypes.Add(payScaleType); db.SaveChanges(); return(RedirectToAction("Create")); } ViewBag.Status = "Add"; return(View("CreateList", new PayScaleTypeViewModel { PayScaleTypes = db.PayScaleTypes.ToList() })); }
public ActionResult Create([Bind(Include = "Id,name")] PayScaleType payScaleType) { if (ModelState.IsValid) { db.PayScaleTypes.Add(payScaleType); db.SaveChanges(); TempData["Success"] = "PayScaleType has been created Successfully"; return(RedirectToAction("Create")); } TempData["Fail"] = "Enter fields properly"; ViewBag.Status = "Add"; return(View("CreateList", new PayScaleTypeViewModel { PayScaleTypes = db.PayScaleTypes.ToList() })); }
// GET: PayScaleTypes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PayScaleType payScaleType = db.PayScaleTypes.Find(id); if (payScaleType == null) { return(HttpNotFound()); } ViewBag.Status = "Update"; return(View("CreateList", new PayScaleTypeViewModel { PayScaleType = payScaleType, PayScaleTypes = db.PayScaleTypes.ToList() })); }
public ActionResult Index(UploadFile UploadFile) { if (ModelState.IsValid) { if (UploadFile.ExcelFile.ContentLength > 0) { if (UploadFile.ExcelFile.FileName.EndsWith(".xlsx") || UploadFile.ExcelFile.FileName.EndsWith(".xls")) { XLWorkbook Workbook; try { Workbook = new XLWorkbook(UploadFile.ExcelFile.InputStream); } catch (Exception ex) { ModelState.AddModelError(String.Empty, $"Check your file. {ex.Message}"); return(View()); } IXLWorksheet WorkSheet = null; try { WorkSheet = Workbook.Worksheet(1); } catch (Exception ex) { ex.StackTrace.ToArray(); ModelState.AddModelError(String.Empty, "sheet1 not found!"); return(View()); } try { var count = WorkSheet.Columns().Count(); if (count < 37) { ModelState.AddModelError(String.Empty, "File data not same as sample file shown in above image"); return(View()); } } catch (Exception e) { } WorkSheet.FirstRow().Delete();//if you want to remove ist row var x = 1; foreach (var row in WorkSheet.RowsUsed()) { Debug.Print(row.Cell(1).Value.ToString() + "------"); try { int empId = Convert.ToInt32(row.Cell(1).Value.ToString()); context.Configuration.AutoDetectChangesEnabled = false; context.Configuration.ValidateOnSaveEnabled = false; if (context.Users.FirstOrDefault(u => u.EmployeeId == empId) == null) { ApplicationUser user = new ApplicationUser(); user.EmployeeId = Convert.ToInt32(row.Cell(1).Value.ToString()); user.FirstName = row.Cell(2).Value.ToString(); user.MiddleName = row.Cell(3).IsEmpty() ? null : row.Cell(3).Value.ToString(); user.LastName = row.Cell(4).Value.ToString(); user.UserName = "******" + user.EmployeeId + "*****@*****.**"; var departmentname = row.Cell(5).Value.ToString().Contains("Operations") ? "Operations" : row.Cell(5).Value.ToString(); Department department = context.Departments.Where(m => m.name == departmentname) .SingleOrDefault(); if (department == null) { Department dp = new Department(); dp.name = departmentname; //dp.departmntNumber = departmentId; context.Departments.Add(dp); context.SaveChanges(); user.DepartmentId = dp.Id; //context.SaveChanges(); } else { user.DepartmentId = department.Id; // context.SaveChanges(); } var costcentercode = row.Cell(6).IsEmpty() ? null : row.Cell(6).Value.ToString(); var costcentername = row.Cell(7).Value.ToString(); CostCenter costCenter = context.CostCenters.Where(m => m.name == costcentername) .SingleOrDefault(); if (costCenter == null) { CostCenter cs = new CostCenter(); cs.name = costcentername; cs.CostCenterCode = costcentercode; context.CostCenters.Add(cs); context.SaveChanges(); user.CostCenterId = cs.Id; } else { user.CostCenterId = costCenter.Id; } // user.EmployeeHireDate = row.Cell(8).GetDateTime(); var nationalityname = row.Cell(9).Value.ToString(); Nationality nationality = context.Nationalities.Where(m => m.name == nationalityname) .SingleOrDefault(); if (nationality == null) { Nationality ps = new Nationality(); ps.name = nationalityname; context.Nationalities.Add(ps); context.SaveChanges(); user.NationalityId = ps.Id; //context.SaveChanges(); } else { user.NationalityId = nationality.Id; //context.SaveChanges(); } // user.EmployeeFireDate = row.Cell(10).GetDateTime(); user.EmployeeStatus = row.Cell(11).IsEmpty() ? null : row.Cell(11).Value.ToString(); var eventreason = row.Cell(12).Value.ToString(); EventReason eventReason = context.EventReasons.Where(m => m.name == eventreason) .SingleOrDefault(); if (eventReason == null) { EventReason ev = new EventReason(); ev.name = eventreason; context.EventReasons.Add(ev); context.SaveChanges(); user.EventReasonId = ev.Id; //context.SaveChanges(); } else { user.EventReasonId = eventReason.Id; //context.SaveChanges(); } var locationId = row.Cell(13).Value.ToString(); Location location = context.Locations.Where(m => m.name == locationId) .SingleOrDefault(); if (location == null) { Location lc = new Location(); lc.name = locationId; context.Locations.Add(lc); context.SaveChanges(); user.LocationId = lc.Id; //context.SaveChanges(); } else { user.LocationId = location.Id; // context.SaveChanges(); } var locationgroupId = row.Cell(14).Value.ToString(); LocationGroup locationgrp = context.LocationGroups.Where(m => m.name == locationgroupId) .SingleOrDefault(); if (locationgrp == null) { LocationGroup lc = new LocationGroup(); lc.name = locationgroupId; context.LocationGroups.Add(lc); context.SaveChanges(); user.LocationGroupId = lc.Id; //context.SaveChanges(); } else { user.LocationGroupId = locationgrp.Id; // context.SaveChanges(); } var jobtitlename = row.Cell(15).Value.ToString(); JobTitle jobTitle = context.JobTitles.Where(m => m.name == jobtitlename) .SingleOrDefault(); if (jobTitle == null) { JobTitle jb = new JobTitle(); jb.name = jobtitlename; context.JobTitles.Add(jb); context.SaveChanges(); user.JobTitleId = jb.Id; //context.SaveChanges(); } else { user.JobTitleId = jobTitle.Id; // context.SaveChanges(); } user.GOSINumber = row.Cell(16).IsEmpty() ? null : row.Cell(16).Value.ToString(); user.saudiNationalId = row.Cell(17).IsEmpty() ? null : row.Cell(17).Value.ToString(); user.saudiResidentialId = row.Cell(18).IsEmpty() ? null : row.Cell(18).Value.ToString(); var employeeclass = row.Cell(19).Value.ToString(); EmployeeClass employeeClass = context.employeeClasses .Where(m => m.name == employeeclass).SingleOrDefault(); if (employeeClass == null) { EmployeeClass ec = new EmployeeClass(); ec.name = employeeclass; context.employeeClasses.Add(ec); context.SaveChanges(); user.EmployeeClassId = ec.Id; //context.SaveChanges(); } else { user.EmployeeClassId = employeeClass.Id; // context.SaveChanges(); } var ethincity = row.Cell(20).Value.ToString(); Ethnicity ethnicity = context.Ethnicities.Where(m => m.name == ethincity) .SingleOrDefault(); if (ethnicity == null) { Ethnicity ec = new Ethnicity(); ec.name = ethincity; context.Ethnicities.Add(ec); context.SaveChanges(); user.EthincityId = ec.Id; //context.SaveChanges(); } else { user.EthincityId = ethnicity.Id; // context.SaveChanges(); } user.HasSwipeAccess = row.Cell(21).Value.ToString().Equals("No Swipe Access") ? false : true; user.bussinessPhoneNumber = row.Cell(22).IsEmpty() ? null : row.Cell(22).Value.ToString(); user.homePhoneNumber = row.Cell(23).IsEmpty() ? null : row.Cell(23).Value.ToString(); user.cellPhoneNumber = row.Cell(24).IsEmpty() ? null : row.Cell(24).Value.ToString(); ; user.otherPhoneNumber = row.Cell(25).IsEmpty() ? null : row.Cell(25).Value.ToString(); var payscalename = row.Cell(26).Value.ToString(); PayScaleType payscale = context.PayScaleTypes.Where(m => m.name == payscalename) .SingleOrDefault(); if (payscale == null) { PayScaleType ps = new PayScaleType(); ps.name = payscalename; context.PayScaleTypes.Add(ps); context.SaveChanges(); user.PayScaleTypeId = ps.Id; //context.SaveChanges(); } else { user.PayScaleTypeId = payscale.Id; //context.SaveChanges(); } var religionname = row.Cell(27).Value.ToString(); Religion religion = context.Religions.Where(m => m.name == religionname) .SingleOrDefault(); if (religion == null) { Religion ps = new Religion(); ps.name = religionname.Equals(null) ? "Others" : religionname; context.Religions.Add(ps); context.SaveChanges(); user.ReligionId = ps.Id; //context.SaveChanges(); } else { user.ReligionId = religion.Id; //context.SaveChanges(); } user.personalInfoString = row.Cell(28).IsEmpty() ? null : row.Cell(28).Value.ToString(); ; //user.DOB = row.Cell(29).GetDateTime(); var gendername = row.Cell(30).Value.ToString(); Gender gender = context.Genders.Where(m => m.name == gendername).SingleOrDefault(); if (gender == null) { Gender gn = new Gender(); gn.name = gendername; context.Genders.Add(gn); context.SaveChanges(); user.GenderId = gn.Id; //context.SaveChanges(); } else { user.GenderId = gender.Id; //context.SaveChanges(); } user.otherEmail = row.Cell(31).IsEmpty() ? null : row.Cell(31).Value.ToString(); user.bussinessEmail = row.Cell(32).IsEmpty() ? null : row.Cell(32).Value.ToString(); user.personalEmail = row.Cell(33).IsEmpty() ? null : row.Cell(33).Value.ToString(); var employertypename = row.Cell(34).Value.ToString(); EmployerType employerType = context.employerTypes.Where(m => m.name == employertypename) .SingleOrDefault(); if (employerType == null) { EmployerType ty = new EmployerType(); ty.name = employertypename; context.employerTypes.Add(ty); context.SaveChanges(); user.EmployerTypeId = ty.Id; //context.SaveChanges(); } else { user.EmployerTypeId = employerType.Id; //context.SaveChanges(); } var vendorname = row.Cell(35).Value.ToString(); Vendor vendor = context.vendors.Where(m => m.name == vendorname).SingleOrDefault(); if (vendor == null) { Vendor vn = new Vendor(); vn.name = vendorname; context.vendors.Add(vn); context.SaveChanges(); user.VendorId = vn.Id; //context.SaveChanges(); } else { user.VendorId = vendor.Id; //context.SaveChanges(); } user.outSourcedId = row.Cell(36).IsEmpty() ? null : row.Cell(36).Value.ToString(); var bandname = row.Cell(37).Value.ToString(); Band band = context.bands.Where(m => m.name == bandname).SingleOrDefault(); if (band == null) { Band bnd = new Band(); bnd.name = bandname; context.bands.Add(bnd); context.SaveChanges(); user.BandId = bnd.Id; //context.SaveChanges(); } else { user.BandId = band.Id; //context.SaveChanges(); } context.Users.Add(user); try { context.SaveChanges(); } catch (DbEntityValidationException ex) { Debug.WriteLine(ex.Message); } } else { Debug.Print("Employee exists " + row.Cell(1).Value.ToString()); } } catch (Exception e) { Debug.Print(e.InnerException + "File row issue" + e.StackTrace); ModelState.AddModelError(String.Empty, "Something went wrong while processing row " + (Convert.ToInt32(x) + 1) + ".Employees data till that row has been stored."); return(View()); } x++; } } else { ModelState.AddModelError(String.Empty, "Only .xlsx and .xls files are allowed"); return(View()); } } else { ModelState.AddModelError(String.Empty, "Not a valid file"); return(View()); } } TempData["success"] = "File uploaded successfully"; return(View()); }