public HttpResponseMessage Edit(int id, [FromBody] tbl_employee employee) { try { using (empEntities entities = new empEntities()) { var entity = entities.tbl_employee.FirstOrDefault(e => e.Id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID" + id.ToString() + " not found")); } else { entity = employee; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } //entity.Id = employee.Id; //entity.Name = employee.Name; //entity.Gender = employee.Gender; } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
// POST api/Employee public string InsertEmployee(string FirstName, string LastName, string Gender, int Salary) { string strResult = ""; try { Employee employee = new Employee { FirstName = FirstName, LastName = LastName, Gender = Gender, Salary = Salary }; using (empEntities db = new empEntities()) { db.AddObject("tblemployees", employee); db.SaveChanges(); }; } catch (Exception ex) { strResult = ex.Message; } return(null); }
public static bool Login(string username, string password) { using (empEntities entities = new empEntities()) { return(entities.tbl_users.Any(user => user.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && user.Password == password)); } }
// GET api/Employee public IEnumerable <Employee> GetEmployee() { IEnumerable <Employee> Result = new List <Employee>(); empEntities db = new empEntities(); Result = db.tblemployees.Select(employee => new Employee { FirstName = employee.FirstName, LastName = employee.LastName, Gender = employee.Gender, Salary = (int)(employee.Salary) }).AsEnumerable <Employee>(); return(Result); }
// GET api/department public IEnumerable <Department> GetDepartment() { IEnumerable <Department> Result = new List <Department>(); empEntities db = new empEntities(); Result = db.tbldepartments.Select(depart => new Department { DepartmentId = depart.DepartmentId, DepartmentName = depart.DepartmentName, Location = depart.Location }).AsEnumerable <Department>(); return(Result); }
public HttpResponseMessage GetById(int id) { using (empEntities entities = new empEntities()) { var entity = entities.tbl_employee.FirstOrDefault(e => e.Id == id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + id.ToString() + " not found")); } } }
public ActionResult Autherize(Emp_Mvc.Models.LoginModel usermodel, string ReturnUrl) { using (empEntities db = new empEntities()) { var EmpLogin = db.Tbl_Employee.Where(m => m.EmpId == usermodel.EmpId && m.Password1 == usermodel.Password && m.RoleId == 20001).FirstOrDefault(); if (EmpLogin == null) { usermodel.LoginMessage = "Wrong credentials"; return(View("Login1", usermodel)); } else { usermodel.LoginMessage = "Login successful"; return(View("Login1", usermodel)); } } //return View(); }
// DELETE api/Employee/3 public string DeleteEmployee(int EmpID) { string strResult = ""; try { empEntities db = new empEntities(); var Results = db.tblemployees.Single(x => x.EmpId == (int)EmpID); db.tblemployees.DeleteObject(Results); db.SaveChanges(); strResult = "Deleted Successfully"; } catch (Exception ex) { strResult = ex.Message; } return(strResult); }
public HttpResponseMessage Insert([FromBody] tbl_employee employee) { try { using (empEntities entities = new empEntities()) { entities.tbl_employee.Add(employee); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, employee); message.Headers.Location = new Uri(Request.RequestUri + employee.Id.ToString()); return(message); } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
public HttpResponseMessage Get(string gender = "All") { string username = Thread.CurrentPrincipal.Identity.Name; using (empEntities entities = new empEntities()) { switch (username.ToLower()) { case "male": return(Request.CreateResponse(HttpStatusCode.OK, entities.tbl_employee.Where(e => e.Gender.ToLower() == "male").ToList())); case "female": return(Request.CreateResponse(HttpStatusCode.OK, entities.tbl_employee.Where(e => e.Gender.ToLower() == "female").ToList())); default: return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } }
// PUT api/Employee/ public string UpdateEmployee(int EmpID, string FirstName, string LastName, string Gender, int Salary) { string strResult = ""; try { empEntities db = new empEntities(); var Results = db.tblemployees.Single(x => x.EmpId == (int)EmpID); Results.FirstName = FirstName; Results.LastName = LastName; Results.Gender = Gender; Results.Salary = Salary; db.SaveChanges(); strResult = "Changes Updated Successfully"; } catch (Exception ex) { strResult = ex.Message; } return(strResult); }
public HttpResponseMessage Delete(int id) { try { using (empEntities entities = new empEntities()) { var entity = entities.tbl_employee.FirstOrDefault(e => e.Id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID " + id.ToString() + " not found to delete")); } else { entities.tbl_employee.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
// POST api/department public string AddDepartment(string DepartmentName, string Location) { string strResult = ""; try { Department depart = new Department { DepartmentName = DepartmentName, Location = Location }; using (empEntities db = new empEntities()) { db.AddObject("tbldepartments", depart); db.SaveChanges(); }; } catch (Exception ex) { strResult = ex.Message; } return(null); }