public ActionResult Login(string returnUrl, string option) { ViewBag.ReturnUrl = returnUrl; using (var databaseContext = new MachineTest.EmployeeEntities1()) { var user = (databaseContext.Employees.FirstOrDefault()); return(View("UserLandingView1", databaseContext.Employees.ToList())); } return(View("Login")); }
public ActionResult Index(string option, string search) { using (var databaseContext = new MachineTest.EmployeeEntities1()) { var user = (databaseContext.Employees.FirstOrDefault()); if (option == "Name" && !string.IsNullOrEmpty(search)) { return(View("UserLandingView1", databaseContext.Employees.Where(x => x.Name == search).ToList())); } return(View("UserLandingView1", databaseContext.Employees.ToList())); } return(View("")); }
public FileResult Export(string GridHtml) { try { List <Employee> all = new List <Employee>(); using (var databaseContext = new MachineTest.EmployeeEntities1()) { var user = (databaseContext.Employees.FirstOrDefault()); // if (!string.IsNullOrEmpty(Convert.ToString(Session["UserID"])) && !string.IsNullOrEmpty(Convert.ToString(Session["Password"]))) //{ all = databaseContext.Employees.ToList(); //} } WebGrid webGrid1 = new WebGrid(source: all, canPage: false, canSort: false); string gridHtml = webGrid1.GetHtml( columns: webGrid1.Columns( webGrid1.Column("Name", "Name"), webGrid1.Column("BirthDate", "BirthDate"), webGrid1.Column("Qualification", "Qualification"), webGrid1.Column("Experience", "Experience"), webGrid1.Column("JoinningDate", "JoinningDate"), webGrid1.Column("Salary", "Salary"), webGrid1.Column("Designation", "Designation"), webGrid1.Column("Hobbies", "Hobbies") ) ).ToString(); string exportData = String.Format("<html><head>{0}</head><body>{1}</body></html>", "<style>table{ border-spacing: 1px; border-collapse: separate;border - collapse: collapse, border: 1px solid #ccc; }" + "th{backgroung-color:#BBDBFD;border:1px solid #ccc; border-width:1px}td{padding:8px;border-style:solid;border-color:#666666;background-color:#fffff;border:1px solid #ccc; border-width:1px}</style>", gridHtml); var bytes = System.Text.Encoding.UTF8.GetBytes(exportData); using (var input = new MemoryStream(bytes)) { var output = new MemoryStream(); var document = new iTextSharp.text.Document(PageSize.A4_LANDSCAPE, 10, 10, 100, 0); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xmlWorker = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xmlWorker.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; return(File(output, "application/pdf", "Grid.pdf")); } } catch (Exception ex) { } return(File("", "application/pdf", "Grid.pdf")); }
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl) { if (!ModelState.IsValid) { return(View(model)); } using (var databaseContext = new MachineTest.EmployeeEntities1()) { var user = (databaseContext.Employees.Where(a => a.Name.Equals(model.UserName)).FirstOrDefault()); var password = (databaseContext.Employees.Where(a => a.Password.Equals(model.Password)).FirstOrDefault()); if (user != null && password != null) { Session["UserID"] = user.Name; Session["Password"] = user.Password; } var result = await SignInManager.PasswordSignInAsync(model.UserName, model.Password, model.RememberMe, shouldLockout : false); switch (result) { case SignInStatus.Success: // return RedirectToLocal(returnUrl); return(View("UserLandingView1", databaseContext.Employees.ToList())); case SignInStatus.LockedOut: return(View("Lockout")); case SignInStatus.RequiresVerification: return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe })); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid login attempt."); return(View(model)); } } }
public async Task <ActionResult> Register(Employee employee, FormCollection check) { try { if (ModelState.IsValid) { ViewBag.QualificationList = new List <SelectListItem>() { new SelectListItem { Text = "BE", Value = "1" }, new SelectListItem { Text = "BSc", Value = "1" }, new SelectListItem { Text = "MSc", Value = "1" }, new SelectListItem { Text = "MCA", Value = "1" } }; using (var databaseContext = new MachineTest.EmployeeEntities1()) { var newUser = databaseContext.Employees.Create(); newUser.Name = employee.Name; newUser.Password = employee.Password; newUser.BirthDate = employee.BirthDate; newUser.Qualification = Convert.ToString(employee.QualificationList); newUser.Experience = employee.Experience; newUser.JoinningDate = employee.JoinningDate; newUser.Salary = employee.Salary; newUser.Designation = employee.Designation; if (!String.IsNullOrEmpty(check["Hobbies"])) { newUser.Hobbies = check["Hobbies"]; } databaseContext.Employees.Add(newUser); databaseContext.SaveChanges(); return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("", "Invalid Input"); } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { Exception raise = ex; foreach (var validationError in ex.EntityValidationErrors) { foreach (var item in validationError.ValidationErrors) { string message = string.Format("{0}:{1}", validationError.Entry.Entity.ToString(), item.ErrorMessage); raise = new InvalidOperationException(message, raise); } } throw raise; } // If we got this far, something failed, redisplay form return(View(employee)); }