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