public ActionResult Save(Employe emp)
{
bool status = false;
if (ModelState.IsValid)
{
using (DBmodels dm = new DBmodels())
{
if (emp.EmployeID > 0)
{
var v = dm.Employes.Where(a => a.EmployeID == emp.EmployeID).FirstOrDefault();
if (v != null)
{
//edit
v.Name = emp.Name;
v.Office = emp.Office;
v.Position = emp.Position;
v.Age = emp.Age;
v.Salary = emp.Salary;
}
}
else
{
dm.Employes.Add(emp);
}
dm.SaveChanges();
status = true;
}
}
return(Json(new { status = status }));
}
public ActionResult Save(int id)
{
using (DBmodels dm = new DBmodels())
{
var emp = dm.Employes.Where(a => a.EmployeID == id).FirstOrDefault();
return(View(emp));
}
}
public ActionResult Getdata()
{
using (DBmodels dbm = new DBmodels())
{
List <Employe> lem = dbm.Employes.ToList();
return(Json(new { data = lem }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (DBmodels db = new DBmodels())
{
var v = db.Employes.Where(a => a.EmployeID == id).FirstOrDefault();
if (v != null)
{
return(View(v));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult DeleteEmplyee(int id)
{
bool status = false;
using (DBmodels dm = new DBmodels())
{
var v = dm.Employes.Where(a => a.EmployeID == id).FirstOrDefault();
if (v != null)
{
dm.Employes.Remove(v);
dm.SaveChanges();
status = true;
}
}
return(Json(new { status = status }));
}
public ActionResult Login(User user)
{
using (DBmodels db = new DBmodels())
{
var userDetails = db.Users.Where(x => x.UserName == user.UserName && x.Password == user.Password).FirstOrDefault();
if (userDetails == null)
{
user.LoginError = "Wrong User Name or Password";
return(View("Login", user));
}
else
{
Session["UserID"] = user.UserId;
Session["UserName"] = user.UserName;
return(RedirectToAction("Welcome", "User"));
}
}
return(View(user));
}
public ActionResult CreateOrEditUser(User user)
{
using (DBmodels db = new DBmodels())
{
if (db.Users.Any(x => user.UserName == x.UserName))
{
ViewBag.DuplicateMessage = "User Name '" + user.UserName + "' already exists";
return(View("CreateOrEditUser", user));
}
else
{
db.Users.Add(user);
db.SaveChanges();
}
}
ViewBag.successmessage = "Successfully '" + user.UserName + "' added to the portal";
ModelState.Clear();
return(View("CreateOrEditUser", new User()));
}
