public ActionResult Create([Bind(Include = "EmployeeId,Name,HourlyWage,HoursWorked,Manager,Gross_Earnings,FWT,Net_earnings")] Employee employee)
{
if (ModelState.IsValid)
{
//calculate net pay
double grossEarnings = employee.HourlyWage * employee.HoursWorked;
if (employee.Manager)
{
grossEarnings += grossEarnings * .2;
}
else
{
if (employee.HoursWorked > 40)
{
grossEarnings += (employee.HoursWorked - 40) * 1.5 * employee.HourlyWage;
}
}
employee.Gross_Earnings = (float)grossEarnings;
employee.FWT = (float)(grossEarnings * 0.15);
employee.Net_earnings = employee.Gross_Earnings - employee.FWT;
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public IHttpActionResult PutSignUp(int id, SignUp signUp)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != signUp.Id)
{
return(BadRequest());
}
db.Entry(signUp).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SignUpExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutEmployeeData(string id, EmployeeData employeeData)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != employeeData.IdNumber)
{
return(BadRequest());
}
db.Entry(employeeData).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeDataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "EmployeeId,Name,Gender,City,EmailId")] tblEmployee tblEmployee)
{
if (ModelState.IsValid)
{
db.tblEmployees.Add(tblEmployee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblEmployee));
}
public ActionResult Create([Bind(Include = "EmployeeID,Name,Position,Office,Age,Salary")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,Email")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public ActionResult Create([Bind(Include = "EmployeeGuid,EmployeeNumber,FirstName,LastName,HireDate," +
"TerminationDate,Type,Status,Shift,Department,Title")] Employee employee)
{
if (ModelState.IsValid)
{
employee.EmployeeGuid = Guid.NewGuid();
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
/*#####################################################
* delete
*####################################################*/
public HttpResponseMessage Delete(int id)
{
try
{
using (EmployeesEntities entities = new EmployeesEntities())
{
//1.get the employee which user want to delete
var entity = entities.Employees.FirstOrDefault(e => e.EmpID == id);
//2.if the employee is not found (wrong id) => 404
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Employee with Id = " + id.ToString() + " not found to delete"));
}
//3.if the employee already exist in the database => (200 ok)
else
{
entities.Employees.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
/*##########################################################
* put
*##########################################################*/
public HttpResponseMessage Put(int id, [FromBody] Employee employee)
{
try
{
using (EmployeesEntities entities = new EmployeesEntities())
{
//1.get the employee from database
var entity = entities.Employees.FirstOrDefault(e => e.EmpID == id);
//2.if the employee is not found (wrong id) => 404
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Employee with Id " + id.ToString() + " not found to update"));
}
//3.if the employee already exist in the database => (200 ok)
else
{
entity.EmpID = employee.EmpID;
entity.Name = employee.Name;
entity.Salary = employee.Salary;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ApiEmployee Add(ApiEmployee item)
{
ApiEmployee returnValue = null;
using (var _context = new EmployeesEntities())
{
try
{
item.id = -1;
Employee user = _context.Employees.Add(item.AsEmployee());
_context.SaveChanges();
returnValue = user.AsApiEmployee();
}
catch (DbEntityValidationException ex)
{
throw ex.DBValidationEntityExceptionAsFriendlyException();
}
catch (Exception ex)
{
throw ex.EntityExceptionAsFriendlyException();
}
}
return(returnValue);
}
private void DeleteEmployeeExecute()
{
try
{
using (EmployeesEntities context = new EmployeesEntities())
{
// geting the registration number of the user
string jmbg = ViewEmployee.JMBG;
// confirmation for the action
MessageBoxResult messageBoxResult = MessageBox.Show("Deleting the employee will delete all his records. \nAre you sure you want to delete?", "Delete Confirmation", MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
// getting the user from the database
tblEmployee employeeToDelete = (from x in context.tblEmployees where x.JMBG == jmbg select x).First();
// removin the user from the database
context.tblEmployees.Remove(employeeToDelete);
context.SaveChanges();
// logging the action
FileActions.Instance.DeletingEmployee(FileActions.path, FileActions.actions, DateTime.Now, employeeToDelete.FullName);
EmployeeList = GetAllEmployees().ToList();
}
}
}
catch (Exception)
{
MessageBox.Show("The employee can not be deleted, please try again.");
}
}
public bool Update(ApiEmployee item)
{
using (var context = new EmployeesEntities())
{
var employer = context.Employees.Where(p => p.id == item.id).FirstOrDefault();
employer.fullName = item.fullName;
employer.aditional_info = item.aditional_info;
employer.aditional_service = item.aditional_service;
employer.another_building = item.another_building;
employer.another_company = item.another_company;
employer.fk_buildingaccess = item.fk_buildingaccess;
employer.cellphone = item.cellphone;
employer.email = item.email;
employer.fk_companylist = item.fk_companylist;
employer.fk_hiredfor = item.fk_hiredfor;
employer.hiringManagerEmail = item.hiringManagerEmail;
employer.initiationDate = item.initiationDate;
employer.restricted_access = item.restricted_access;
employer.service_equipmentneeded = item.service_equipmentneeded;
employer.startDate = item.startDate;
context.SaveChanges();
return(true);
}
return(false);
}
public ActionResult Create([Bind(Include = "Id,Name,Comments")] tblComment tblComment)
{
StringBuilder sbComments = new StringBuilder();
// Encode the text that is coming from comments textbox
sbComments.Append(HttpUtility.HtmlEncode(tblComment.Comments));
// Only decode bold and underline tags
sbComments.Replace("<b>", "<b>");
sbComments.Replace("</b>", "</b>");
sbComments.Replace("<u>", "<u>");
sbComments.Replace("</u>", "</u>");
tblComment.Comments = sbComments.ToString();
// HTML encode the text that is coming from name textbox
string strEncodedName = HttpUtility.HtmlEncode(tblComment.Name);
tblComment.Name = strEncodedName;
if (ModelState.IsValid)
{
db.tblComments.Add(tblComment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblComment));
}
public void DeleteEmployee(int id)
{
using (var db = new EmployeesEntities())
{
db.Employees.Remove(db.Employees.Find(id));
db.SaveChanges();
}
}
public void AddEmployee(Shared.Entities.Employee emp)
{
using (var db = new EmployeesEntities())
{
db.Employees.Add(emp);
db.SaveChanges();
}
}
public ActionResult Edit(Employee emp)
{
using (EmployeesEntities db = new EmployeesEntities())
{
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Employee emp)
{
using (EmployeesEntities db = new EmployeesEntities())
{
db.Employees.Add(emp);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public void UpdateEmployee(Shared.Entities.Employee emp)
{
using (var db = new EmployeesEntities())
{
db.Employees.Attach(emp);
var entry = db.Entry(emp);
entry.State = EntityState.Modified;
db.SaveChanges();
}
}
public void Remove(int id)
{
using (var context = new EmployeesEntities())
{
var employer = context.Employees.Where(p => p.id == id).FirstOrDefault();
context.Employees.Attach(employer);
context.Employees.Remove(employer);
context.SaveChanges();
}
}
public ActionResult Delete(int id)
{
using (EmployeesEntities db = new EmployeesEntities())
{
Employee emp = db.Employees.Where(x => x.EmployeeID == id).FirstOrDefault <Employee>();
db.Employees.Remove(emp);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(IEnumerable <int> employeeIdsToDelete)
{
var departmentList = db.DepartmentDetails1.Where(x => employeeIdsToDelete.Contains(x.DepId)).ToList();
foreach (var item in departmentList)
{
db.DepartmentDetails1.Remove(item);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
static void Main(string[] args)
{
using (var EmpObj = new EmployeesEntities())
{
var emp = new Table_Employees();
emp.Emp_ID = 1;
emp.Emp_Name = "Manu";
emp.Emp_Salary = 1200;
EmpObj.Table_Employees.Add(emp);
EmpObj.SaveChanges();
Console.WriteLine("Record Inserted");
}
Console.ReadLine();
}
public JsonResult AddEmployee(Employee employee)
{
if (employee != null)
{
using (var db = new EmployeesEntities())
{
db.Employees.Add(employee);
db.SaveChanges();
return(Json(new { success = true }));
}
}
return(Json(new { success = false }));
}
public ActionResult AddOrEdit(EmployeeTbl emp)
{
try
{
if (emp.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(emp.ImageUpload.FileName);
string extention = Path.GetExtension(emp.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extention;
emp.Image = "~/AppFiles/Images/" + fileName;
emp.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
using (EmployeesEntities db = new EmployeesEntities())
{
if (emp.EmployeeId == 0)
{
db.EmployeeTbls.Add(emp);
db.SaveChanges();
}
else
{
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
}
}
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Submitted Successfully" },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = ex.Message },
JsonRequestBehavior.AllowGet));
}
}
public JsonResult Delete(int id)
{
using (var db = new EmployeesEntities())
{
var employee = db.Employees.Find(id);
if (employee == null)
{
return(Json(new { success = false }));
}
db.Employees.Remove(employee);
db.SaveChanges();
return(Json(new { success = true }));
}
}
// New Employee Detals
public IHttpActionResult AddEmployee(EmployeeViewModel employee)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid Data"));
}
using (var ctx = new EmployeesEntities())
{
ctx.Employees.Add(new Employee()
{
Name = employee.Name,
Age = employee.Age,
JoiningDate = employee.JoiningDate
});
ctx.SaveChanges();
}
return(Ok());
}
internal void AddEmployee(tblEmployee employee, string sector, string location)
{
Thread.Sleep(2000);
try
{
using (EmployeesEntities context = new EmployeesEntities())
{
employee.SectorID = Convert.ToInt32(sector);
employee.LocationOfEmployee = location;
context.tblEmployees.Add(employee);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write("Exception" + ex.Message.ToString());
}
}
public List <EmployeesModel> Create(EmployeesModel model)
{
if (ModelState.IsValid)
{
using (var db = new EmployeesEntities())
{
db.Employees.Add(new Employee
{
Id_Employee = model.Id_Employee,
Fullname = model.Fullname,
Position = model.Position
});
db.SaveChanges();
return //???;
}
}
return //???;
}
public ActionResult Delete(int id)
{
try
{
using (EmployeesEntities db = new EmployeesEntities())
{
EmployeeTbl emp = db.EmployeeTbls.Where(x => x.EmployeeId == id).FirstOrDefault <EmployeeTbl>();
db.EmployeeTbls.Remove(emp);
db.SaveChanges();
}
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Deleted Successfully" },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = ex.Message },
JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateEmployee(Employee employee)
{
using (var db = new EmployeesEntities())
{
var updatedEmployee = db.Employees.Find(employee.EmployeeId);
if (updatedEmployee == null)
{
return(Json(new { success = false }));
}
else
{
updatedEmployee.Name = employee.Name;
updatedEmployee.Department = employee.Department;
updatedEmployee.Office = employee.Office;
updatedEmployee.Email = employee.Email;
db.SaveChanges();
return(Json(new { success = true }));
}
}
}