public ActionResult SaveEmployee(EmployeeObject employeeObj)
{
if (employeeObj.EmpID == 0) // if ID == 0, its a new entry
{
EMPLOYEE _e = new EMPLOYEE();
_e.EMP_NAME = employeeObj.EmpName;
_e.EMP_EMAIL = employeeObj.EmpEmail;
_e.EMP_PHONE = employeeObj.EmpPhone;
_e.EMP_SALARY = employeeObj.EmpSalary;
_e.EMP_HIRE_DATE = DateTime.Today;
_e.EMP_GENDER = employeeObj.EmpGender;
_e.EMP_PHOTO = null;
_e.EMP_IS_ACTIVE = true;
_repository.AddNewEmployee(_e);
}
else if (employeeObj.EmpID > 0) //if ID field is not 0, it is an update!!!
{
EMPLOYEE _e = new EMPLOYEE();
_e.EMP_ID = employeeObj.EmpID;
_e.EMP_NAME = employeeObj.EmpName;
_e.EMP_EMAIL = employeeObj.EmpEmail;
_e.EMP_PHONE = employeeObj.EmpPhone;
_e.EMP_SALARY = employeeObj.EmpSalary;
_e.EMP_HIRE_DATE = Convert.ToDateTime(employeeObj.EmpHireDate);
_e.EMP_GENDER = employeeObj.EmpGender;
_e.EMP_PHOTO = null;
_e.EMP_IS_ACTIVE = employeeObj.EmpIsActive ;
_repository.UpdateEmployee(_e);
}
var _employees = _repository.GetAllEmployeeDataNoPhoto().OrderByDescending(x => x.EmpID).AsQueryable();
return CreateFlexiJson(_employees.ToList(), 1, _employees.Count());
}
public ActionResult Create(EmployeeObject newEmployeeModel)
{
if (ModelState.IsValid)
{
if (newEmployeeModel.File != null)
{
int maxFileSize = 1024 * 1024 * 2; //2MB
string[] AllowedFileExtensions = new string[] { ".jpg" };
var attachedFile = newEmployeeModel.File;
var fileSize = attachedFile.ContentLength;
if (fileSize > maxFileSize)
{
ModelState.AddModelError("File", "File is greater than 2MB. Choose a smaller file and try again.");
}
else
{
if (!AllowedFileExtensions.Contains(newEmployeeModel.File.FileName.Substring(newEmployeeModel.File.FileName.LastIndexOf('.'))))
{
ModelState.AddModelError("File", "Allowed file types are: " + string.Join(", ", AllowedFileExtensions));
}
else
{
EMPLOYEE _newEmployee = new EMPLOYEE();
_newEmployee.EMP_NAME = newEmployeeModel.EmpName;
_newEmployee.EMP_EMAIL = newEmployeeModel.EmpEmail;
_newEmployee.EMP_PHONE = newEmployeeModel.EmpPhone;
_newEmployee.EMP_IS_ACTIVE = true;
_newEmployee.EMP_HIRE_DATE = DateTime.Today.Date;
_newEmployee.EMP_GENDER = newEmployeeModel.EmpGender;
_newEmployee.EMP_SALARY = newEmployeeModel.EmpSalary;
_newEmployee.EMP_PHOTO = new byte[fileSize];
newEmployeeModel.File.InputStream.Read(_newEmployee.EMP_PHOTO, 0, fileSize);
if (_repository.AddNewEmployee(_newEmployee))
{
Success(string.Format("<b>{0}</b> New Employee Added successfully!.", "SUCCESS"), true);
return RedirectToAction("Index");
}
}
}
}
else
{
ModelState.AddModelError("File", "Employee photo is required!");
return View(newEmployeeModel);
}
}
return View(newEmployeeModel);
}
public ActionResult Create(EmployeeObject newEmployeeModel)
{
if (ModelState.IsValid)
{
if (newEmployeeModel.EmpPhone.Length > 0)
{
string _phoneNumberPattern = @"^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$";
if (!Regex.IsMatch(newEmployeeModel.EmpPhone, _phoneNumberPattern))
{
ModelState.AddModelError("", "Invalid Phone number entered!");
}
else
{
EMPLOYEE _model = new EMPLOYEE();
_model.EMP_NAME = newEmployeeModel.EmpName;
_model.EMP_EMAIL = newEmployeeModel.EmpEmail;
_model.EMP_PHONE = newEmployeeModel.EmpPhone;
_model.EMP_SALARY = newEmployeeModel.EmpSalary;
_model.EMP_IS_ACTIVE = true;
_model.EMP_HIRE_DATE = DateTime.Now;
_model.EMP_GENDER = newEmployeeModel.EmpGender;
_repository.AddNewEmployee(_model);
Success(string.Format("<b>{0}</b> New Employee Added succcessfully!.", "SUCCESS"), true);
return RedirectToAction("Index");
}
}
else
{
ModelState.AddModelError("", "Invalid Phone number entered!");
}
}
return View(newEmployeeModel);
}
public ActionResult Edit(int empID)
{
EmployeeObject _model = new EmployeeObject();
EmployeeObject _modelToEdit = new EmployeeObject();
_model = _repository.GetEmployeeByIDNoPhoto(empID);
_modelToEdit.EmpID = _model.EmpID;
_modelToEdit.EmpName = _model.EmpName;
_modelToEdit.EmpEmail = _model.EmpEmail;
_modelToEdit.EmpSalary = _model.EmpSalary;
_modelToEdit.EmpGender = _model.EmpGender;
_modelToEdit.EmpHireDate = _model.EmpHireDate;
_modelToEdit.EmpIsActive = _model.EmpIsActive;
_modelToEdit.EmpPhone = _model.EmpPhone;
_modelToEdit.EmpStatus = _model.EmpStatus;
ViewBag.EmployeeStatus = GetActiveStatusList(_model.IsActive);
return View(_modelToEdit);
}
public ActionResult Edit(EmployeeObject updatedEmployeeModel)
{
ViewBag.EmployeeStatus = GetActiveStatusList(updatedEmployeeModel.EmpStatus);
if (ModelState.IsValid)
{
if (updatedEmployeeModel.EmpPhone.Length > 0)
{
string _phoneNumberPattern = @"^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$";
if (!Regex.IsMatch(updatedEmployeeModel.EmpPhone, _phoneNumberPattern))
{
ModelState.AddModelError("", "Invalid Phone number entered!");
}
else
{
EMPLOYEE _model = new EMPLOYEE();
_model.EMP_ID = updatedEmployeeModel.EmpID;
_model.EMP_NAME = updatedEmployeeModel.EmpName;
_model.EMP_EMAIL = updatedEmployeeModel.EmpEmail;
_model.EMP_PHONE = updatedEmployeeModel.EmpPhone;
_model.EMP_SALARY = updatedEmployeeModel.EmpSalary;
_model.EMP_GENDER = updatedEmployeeModel.EmpGender;
if (updatedEmployeeModel.EmpStatus == "No")
{
_model.EMP_IS_ACTIVE = false;
}
else if (updatedEmployeeModel.EmpStatus == "Yes")
{
_model.EMP_IS_ACTIVE = true;
}
_model.EMP_HIRE_DATE = Convert.ToDateTime(updatedEmployeeModel.EmpHireDate);
_repository.UpdateEmployee(_model);
Success(string.Format("<b>{0}</b> Employee Edited succcessfully!.", "SUCCESS"), true);
return RedirectToAction("Index");
}
}
else
{
ModelState.AddModelError("", "Invalid Phone number entered!");
}
}
return View(updatedEmployeeModel);
}
