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));
}
