//public IEnumerable<TblUser> Get()
//{
// using (EmployeeDbEntities entities = new EmployeeDbEntities())
// {
// return entities.TblUsers.ToList();
// }
//}
public TblUser Get(int id)
{
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
return(entities.TblUsers.FirstOrDefault(x => x.Id == id));
}
}
public HttpResponseMessage Put(int id, [FromBody] Employee employee)
{
try
{
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"employee id: " + id.ToString() + " not found to update"));
}
else
{
entity.FirstName = employee.FirstName;
entity.Salary = employee.Salary;
entity.Gender = employee.Gender;
entity.LastName = employee.LastName;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
// GET
public HttpResponseMessage Get(string gender = "all")
{
try
{
using (EmployeeDbEntities db = new EmployeeDbEntities())
{
switch (gender.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, db.Employees.ToList()));
case "male":
return(Request.CreateResponse(HttpStatusCode.OK, db.Employees.Where(emp => emp.Gender.ToLower() == "male").ToList()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK, db.Employees.Where(emp => emp.Gender.ToLower() == "female").ToList()));
default:
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Value for gender must be 'All', 'Male', or 'Female'. '" + gender + "' is invalid."));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
// DELETE
public HttpResponseMessage Delete(int id)
{
try
{
using (EmployeeDbEntities db = new EmployeeDbEntities())
{
Employee employee = db.Employees.Find(id);
if (employee != null)
{
db.Employees.Remove(employee);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + id.ToString() + " not found to delete."));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IEnumerable <Employee> Get()
{
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
return(entities.Employees.ToList());
}
}
// PUT
public HttpResponseMessage Put(int id, [FromBody] Employee employee)
{
try
{
using (EmployeeDbEntities db = new EmployeeDbEntities())
{
Employee entity = db.Employees.Find(id);
if (entity != null)
{
entity.FirstName = employee.FirstName;
entity.LastName = employee.LastName;
entity.Gender = employee.Gender;
entity.Salary = employee.Salary;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + id.ToString() + " not found to update."));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public List <Employee> GetEmployees()
{
using (var db = new EmployeeDbEntities())
{
return(db.Employees.ToList());
}
}
public Employee Get(string id)
{
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
return(entities.Employees.FirstOrDefault(x => x.code == id));
}
}
public Employee Get(int id)
{
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
return(entities.Employees.FirstOrDefault(e => e.ID == id));
}
}
public Employee GetEmployeById(long id)
{
using (var db = new EmployeeDbEntities())
{
return(db.Employees.Where(x => x.Id == id).FirstOrDefault());
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NoContent,
"employee id : " + id.ToString() + " not found to delete"));
}
else
{
entities.Employees.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IEnumerable <Employees> Get()
{
EmployeeDbEntities db = new EmployeeDbEntities();
return(db.Employees.ToList());
}
public static bool Login(string username, string password)
{
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
return(entities.Users.Any(user => user.Username.Equals(username,
StringComparison.OrdinalIgnoreCase) && user.Password == password));
}
}
public List <int> GetEmployeeCountByType()
{
var countList = new List <int>();
using (var db = new EmployeeDbEntities())
{
countList.Add(db.Employees.Where(x => x.Type.ToLower() == "permanent").Count());
countList.Add(db.Employees.Where(x => x.Type.ToLower() == "contract").Count());
}
return(countList);
}
public void DeleteEmployee(long id)
{
using (var db = new EmployeeDbEntities())
{
var existingEmployee = db.Employees.Where(x => x.Id == id).FirstOrDefault();
if (existingEmployee != null)
{
db.Entry(existingEmployee).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
}
public List <int> GetEmployeeCountByMonth()
{
var countList = new List <int>();
using (var db = new EmployeeDbEntities())
{
countList.Add(db.Employees.Where(x => x.DateOfJoining.Value.Month == 1).Count());
countList.Add(db.Employees.Where(x => x.DateOfJoining.Value.Month == 2).Count());
countList.Add(db.Employees.Where(x => x.DateOfJoining.Value.Month == 3).Count());
countList.Add(db.Employees.Where(x => x.DateOfJoining.Value.Month == 4).Count());
countList.Add(db.Employees.Where(x => x.DateOfJoining.Value.Month == 5).Count());
countList.Add(db.Employees.Where(x => x.DateOfJoining.Value.Month == 6).Count());
}
return(countList);
}
public void SaveEmployee(Employee employee)
{
using (var db = new EmployeeDbEntities())
{
db.Employees.Add(new Employee()
{
Name = employee.Name,
Email = employee.Email,
Type = string.IsNullOrEmpty(employee.Type) ? "Permanent" : employee.Type,
DateOfJoining = employee.DateOfJoining == null ? DateTime.Now.Date : employee.DateOfJoining
});
db.SaveChanges();
}
}
public HttpResponseMessage Get(int id)
{
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound,
"employee with id " + id.ToString() + "not found"));
}
}
}
public IEnumerable <Employee> GetEmployees()
{
_dbContext = new EmployeeDbEntities();
return(_dbContext.Employees.ToList());
//Employee item = new Employee()
//{
// Id = 1,
// Name = "Deepali",
// EmailId = "*****@*****.**",
// EmployeeType = EmployeeType.Permanent
//};
//List<Employee> lst = new List<Employee>();
//lst.Add(item);
//return lst;
}
public void UpdateEmployee(long id, Employee employee)
{
using (var db = new EmployeeDbEntities())
{
var existingEmployee = db.Employees.Where(x => x.Id == id).FirstOrDefault();
if (existingEmployee != null)
{
existingEmployee.Name = employee.Name;
existingEmployee.Email = employee.Email;
existingEmployee.Type = employee.Type;
existingEmployee.DateOfJoining = employee.DateOfJoining;
db.Entry(existingEmployee).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
public HttpResponseMessage Post([FromBody] Employees employee)
{
try
{
using (EmployeeDbEntities db = new EmployeeDbEntities())
{
db.Employees.Add(employee);
db.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, employee);
message.Headers.Location = new Uri(Request.RequestUri + employee.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Get(string gender = "All")
{
string username = Thread.CurrentPrincipal.Identity.Name;
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
switch (username.ToLower())
{
case "male":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.Employees.Where(e => e.Gender.ToLower() == "male").ToList()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.Employees.Where(e => e.Gender.ToLower() == "female").ToList()));
default:
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
}
public HttpResponseMessage Get(string gender = "All")
{
using (EmployeeDbEntities entities = new EmployeeDbEntities())
{
switch (gender.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.ToList()));
case "male":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.Employees.Where(e => e.Gender.ToLower() == "male").ToList()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.Employees.Where(e => e.Gender.ToLower() == "female").ToList()));
default:
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "value for gender must be all, male or female" + gender + " is valid"));
}
}
}
public ActionResult Getdatatables(JQueryDataTableParamModel param)
{
EmployeeDbEntities _dbcontext = new EmployeeDbEntities();
using (_dbcontext)
{
var result = _dbcontext.Tests;
IEnumerable <Test> filteredTests = result;
//Searching
if (!string.IsNullOrEmpty(param.sSearch))
{
//filteredTests = result
// .Where(c => c.EmployeeName.ToLower().Contains(param.sSearch.ToLower()) ||
// c.EmployeeType.ToLower().Contains(param.sSearch));
filteredTests = result.Where(x => x.Name.ToLower().Contains(param.sSearch.ToLower()));
}
//sorting
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.QueryString["iSortCol_0"]);
//Func<Test, string> orderingFunction = (c => sortColumnIndex == 0 ? c.Rno.ToString() : sortColumnIndex == 1 ? c.Name.ToString() : sortColumnIndex == 2 ? c.EmployeeName : sortColumnIndex == 3 ? c.EmployeeType : c.EmployeeDesignation);
//Func<Test, int> orderingFunction = (c => sortColumnIndex == 0 ? c.Rno : 0); for int sorting
Func <Test, string> orderingFunction = c => sortColumnIndex == 0 ? c.Rno.ToString() : c.Name.ToString();
var sortDirection = HttpContext.Request.QueryString["sSortDir_0"]; // asc or desc
filteredTests = sortDirection == "asc" ? filteredTests.OrderBy(orderingFunction) : filteredTests.OrderByDescending(orderingFunction);
//Pagination
var displayedTest = filteredTests.Skip(param.iDisplayStart)
.Take(param.iDisplayLength);
var totalRecords = filteredTests.Count();
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = displayedTest.ToList()
}, JsonRequestBehavior.AllowGet));
}
}
public void SaveEmployee(Employee emp)
{
_dbContext = new EmployeeDbEntities();
_dbContext.Employees.Add(emp);
_dbContext.SaveChanges();
}
public Employees Get(int id)
{
EmployeeDbEntities db = new EmployeeDbEntities();
return(db.Employees.FirstOrDefault(x => x.ID == id));
}
