public IHttpActionResult Put(AspNetEmployee employee)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
var existingEmployee = db.AspNetEmployees.FirstOrDefault(x => x.employee_id == employee.employee_id);
if (existingEmployee != null)
{
existingEmployee.first_name = employee.first_name;
existingEmployee.last_name = employee.last_name;
existingEmployee.email = employee.email;
existingEmployee.hire_date = employee.hire_date;
existingEmployee.phone_number = employee.phone_number;
existingEmployee.salary = employee.salary;
existingEmployee.job_id = employee.job_id;
existingEmployee.department_id = employee.department_id;
existingEmployee.manager_id = employee.manager_id;
db.SaveChanges();
}
else
{
return(NotFound());
}
return(Ok());
}
public ActionResult NonManagerialEmployees(RegisterViewModel model)
{
int Active_SID = db.AspNetSessions.Where(x => x.Status == "Active").FirstOrDefault().Id;
if (1 == 1 && Active_SID == SessionID)
{
AspNetEmployee emp = new AspNetEmployee();
emp.Name = model.Name;
emp.Email = model.Email;
emp.PositionAppliedFor = Request.Form["appliedFor"];
emp.DateAvailable = Request.Form["dateAvailable"];
emp.JoiningDate = Request.Form["JoiningDate"];
emp.BirthDate = Request.Form["birthDate"];
emp.Nationality = Request.Form["nationality"];
emp.Religion = Request.Form["religion"];
emp.Gender = Request.Form["gender"];
emp.MailingAddress = Request.Form["mailingAddress"];
emp.CellNo = Request.Form["cellNo"];
emp.Landline = Request.Form["landLine"];
emp.SpouseName = Request.Form["spouseName"];
emp.SpouseHighestDegree = Request.Form["spouseHighestDegree"];
emp.SpouseOccupation = Request.Form["spouseOccupation"];
emp.SpouseBusinessAddress = Request.Form["spouseBusinessAddress"];
//emp.GrossSalary = Convert.ToInt32(Request.Form["GrossSalary"]);
//emp.BasicSalary = Convert.ToInt32(Request.Form["BasicSalary"]);
//emp.MedicalAllowance = Convert.ToInt32(Request.Form["MedicalAllowance"]);
//emp.Accomodation = Convert.ToInt32(Request.Form["Accomodation"]);
//emp.ProvidedFund = Convert.ToInt32(Request.Form["ProvidedFund"]);
//emp.Tax = Convert.ToInt32(Request.Form["Tax"]);
//emp.EOP = Convert.ToInt32(Request.Form["EOP"]);
emp.VirtualRoleId = db.AspNetVirtualRoles.Where(x => x.Name == "Non Directive Staff").Select(x => x.Id).FirstOrDefault();
try
{
db.AspNetEmployees.Add(emp);
if (db.SaveChanges() > 0)
{
Aspnet_Employee_Session ES = new Aspnet_Employee_Session();
ES.Session_Id = SessionID;
ES.Emp_Id = emp.Id;
db.Aspnet_Employee_Session.Add(ES);
db.SaveChanges();
}
TempData["sMessage"] = "Employee successfully saved.";
return(RedirectToAction("Index", "AspNetEmployees"));
}
catch (Exception e)
{
ModelState.AddModelError("", e.InnerException);
return(View(model));
}
}
return(View(model));
}
public ActionResult Disable(int id)
{
AspNetEmployee emp = db.AspNetEmployees.Where(x => x.Id == id).Select(x => x).FirstOrDefault();
emp.Status = "False";
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: AspNetEmployees/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetEmployee aspNetEmployee = db.AspNetEmployees.Find(id);
if (aspNetEmployee == null)
{
return(HttpNotFound());
}
return(View(aspNetEmployee));
}
public ActionResult Edit([Bind(Include = "Id,PositionAppliedFor,DateAvailable,Name,UserName,BirthDate,Nationality,Religion,Gender,MailingAddress,Email,CellNo,Landline,SpouseName,SpouseHighestDegree,SpouseOccupation,SpouseBusinessAddress,UserId,GrossSalary,BasicSalary,MedicalAllowance,Accomodation,ProvidedFund,Tax,EOP,Salary,VirtualRoleId")] AspNetEmployee aspNetEmployee)
{
if (ModelState.IsValid)
{
db.Entry(aspNetEmployee).State = EntityState.Modified;
var VirtualId = db.AspNetVirtualRoles.Where(x => x.Name == "Non Directive Staff").Select(x => x.Id).FirstOrDefault();
aspNetEmployee.VirtualRoleId = VirtualId;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", aspNetEmployee.UserId);
ViewBag.VirtualRoleId = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetEmployee.VirtualRoleId);
return(View(aspNetEmployee));
}
// GET: AspNetEmployees/Details/5
public ActionResult Details(string username)
{
if (username == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetEmployee aspNetEmployee = db.AspNetEmployees.Where(x => x.UserName == username).Select(x => x).FirstOrDefault();
if (aspNetEmployee == null)
{
return(HttpNotFound());
}
return(View(aspNetEmployee));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
AspNetEmployee aspNetEmployee = db.AspNetEmployees.Find(id);
db.AspNetEmployees.Remove(aspNetEmployee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.data = "This Employee has salary data in it.It can't be deleted";
return(View("Delete", db.AspNetEmployees.Find(id)));
}
}
// GET: AspNetEmployees/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AspNetEmployee aspNetEmployee = db.AspNetEmployees.Find(id);
if (aspNetEmployee == null)
{
return(HttpNotFound());
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", aspNetEmployee.UserId);
ViewBag.VirtualRoleId = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetEmployee.VirtualRoleId);
return(View(aspNetEmployee));
}
public ActionResult EmployeeDetail(int Id)
{
AspNetEmployee aspNetEmployee = db.AspNetEmployees.Where(x => x.Id == Id).Select(x => x).FirstOrDefault();
if (aspNetEmployee.UserId != null)
{
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", aspNetEmployee.UserId);
}
if (aspNetEmployee.Status != null)
{
aspNetEmployee.Status = aspNetEmployee.Status.Trim();
}
ViewBag.VirtualRoleId = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetEmployee.VirtualRoleId);
return(View("Details", aspNetEmployee));
}
public ActionResult GetSubjects()
{
var uniqueId = User.Identity.GetUserId();
AspNetEmployee aspNetEmployee = db.AspNetEmployees.Where(x => x.UserId == uniqueId).FirstOrDefault();
var result = from s in db.AspNetSubjects
join ts in db.AspNetTeacherSubjects
on s.Id equals ts.SubjectID
where (ts.TeacherID == aspNetEmployee.Id)
select new
{
Id = s.Id,
Name = s.SubjectName,
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "Id,PositionAppliedFor,DateAvailable,Name,UserName,BirthDate,Nationality,Religion,Gender,MailingAddress,Email,CellNo,Landline,SpouseName,SpouseHighestDegree,SpouseOccupation,SpouseBusinessAddress,UserId,GrossSalary,BasicSalary,MedicalAllowance,Accomodation,ProvidedFund,Tax,EOP,Salary,VirtualRoleId")] AspNetEmployee aspNetEmployee)
{
if (ModelState.IsValid)
{
var VirtualId = db.AspNetVirtualRoles.Where(x => x.Name == "Non Directive Staff").Select(x => x.Id).FirstOrDefault();
aspNetEmployee.VirtualRoleId = VirtualId;
db.AspNetEmployees.Add(aspNetEmployee);
db.SaveChanges();
Aspnet_Employee_Session ES = new Aspnet_Employee_Session();
int sessionid = db.AspNetSessions.Where(x => x.Status == "Active").FirstOrDefault().Id;
ES.Session_Id = sessionid;
ES.Emp_Id = aspNetEmployee.Id;
db.Aspnet_Employee_Session.Add(ES);
db.SaveChanges();
return(RedirectToAction("Indexs"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", aspNetEmployee.UserId);
ViewBag.VirtualRoleId = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetEmployee.VirtualRoleId);
return(View(aspNetEmployee));
}
public ActionResult Excel_Data(HttpPostedFileBase excelfile)
{
var dbTransaction = db.Database.BeginTransaction();
try
{
if (excelfile == null || excelfile.ContentLength == 0)
{
TempData["Error"] = "Please select an excel file";
return(RedirectToAction("Create", "AspNetEmployees"));
}
else if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx"))
{
HttpPostedFileBase file = excelfile; // Request.Files["excelfile"];
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
ApplicationDbContext context = new ApplicationDbContext();
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
AspNetEmployee Employee = new AspNetEmployee();
Employee.Email = workSheet.Cells[rowIterator, 1].Value.ToString();
Employee.Name = workSheet.Cells[rowIterator, 2].Value.ToString();
Employee.UserName = workSheet.Cells[rowIterator, 3].Value.ToString();
Employee.PositionAppliedFor = workSheet.Cells[rowIterator, 4].Value.ToString();
Employee.DateAvailable = workSheet.Cells[rowIterator, 5].Value.ToString();
Employee.JoiningDate = workSheet.Cells[rowIterator, 6].Value.ToString();
Employee.BirthDate = workSheet.Cells[rowIterator, 7].Value.ToString();
Employee.Nationality = workSheet.Cells[rowIterator, 8].Value.ToString();
Employee.Religion = workSheet.Cells[rowIterator, 9].Value.ToString();
Employee.Gender = workSheet.Cells[rowIterator, 10].Value.ToString();
Employee.MailingAddress = workSheet.Cells[rowIterator, 11].Value.ToString();
Employee.CellNo = workSheet.Cells[rowIterator, 12].Value.ToString();
Employee.Landline = workSheet.Cells[rowIterator, 13].Value.ToString();
Employee.SpouseName = workSheet.Cells[rowIterator, 14].Value.ToString();
Employee.SpouseHighestDegree = workSheet.Cells[rowIterator, 15].Value.ToString();
Employee.SpouseOccupation = workSheet.Cells[rowIterator, 16].Value.ToString();
Employee.SpouseBusinessAddress = workSheet.Cells[rowIterator, 17].Value.ToString();
Employee.Illness = workSheet.Cells[rowIterator, 18].Value.ToString();
Employee.GrossSalary = Convert.ToInt32(workSheet.Cells[rowIterator, 19].Value.ToString());
Employee.BasicSalary = Convert.ToInt32(workSheet.Cells[rowIterator, 20].Value.ToString());
Employee.MedicalAllowance = Convert.ToInt32(workSheet.Cells[rowIterator, 21].Value.ToString());
Employee.Accomodation = Convert.ToInt32(workSheet.Cells[rowIterator, 22].Value.ToString());
Employee.ProvidedFund = Convert.ToInt32(workSheet.Cells[rowIterator, 23].Value.ToString());
Employee.Tax = Convert.ToInt32(workSheet.Cells[rowIterator, 24].Value.ToString());
Employee.EOP = Convert.ToInt32(workSheet.Cells[rowIterator, 25].Value.ToString());
Employee.UserId = null;
Employee.VirtualRoleId = db.AspNetVirtualRoles.Where(x => x.Name == "Non Directive Staff").Select(x => x.Id).FirstOrDefault();
db.AspNetEmployees.Add(Employee);
db.SaveChanges();
}
}
dbTransaction.Commit();
return(RedirectToAction("Index", "AspNetEmployees"));
}
else
{
TempData["Error"] = "File type is incorrect";
return(RedirectToAction("Create", "AspNetEmployees"));
}
}
catch
{
dbTransaction.Dispose();
TempData["Error"] = "Incorrect data in file";
return(RedirectToAction("Create", "AspNetEmployees"));
}
}
public IHttpActionResult Post(AspNetEmployee employee)
{
db.AspNetEmployees.Add(employee);
db.SaveChanges();
return(Ok());
}
