public bool SetStaffUDF(Int32 personid, string udf)
{
try
{
using (EditEmployee empprocess = new EditEmployee())
{
empprocess.Load(personid, DateTime.Now);
foreach (UDFValue udfVal in empprocess.Employee.UDFValues)
{
if (simsudf == udfVal.TypedValueAttribute.Description)
{
if (Core.SetUdf(udfVal, udf))
{
empprocess.Save(DateTime.Now);
return(true);
}
else
{
return(false);
}
}
}
logger.Error("UDF {0} not found.", simsudf);
return(false);
}
}
catch (Exception SetStaffUDF_Exception)
{
logger.Log(LogLevel.Error, "SetStaffUDF (string)" + SetStaffUDF_Exception);
return(false);
}
}
// GET: ShowDataController/Edit/5
public ActionResult EditEmployee(int id)
{
EditEmployee dataModel = new EditEmployee();
DataTable tblda = new DataTable();
using (con)
{
con.Open();
//string query = "select * from Employee where EmpId=@EmpId";
SqlCommand cmd = new SqlCommand("Sp_EditBasicInfo", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sqlda = new SqlDataAdapter(cmd);
sqlda.SelectCommand.Parameters.AddWithValue("@EmpId", id);
sqlda.Fill(tblda);
}
if (tblda.Rows.Count == 1)
{
dataModel.EmpId = (int)tblda.Rows[0][0];
dataModel.EmpName = tblda.Rows[0][1].ToString();
dataModel.DeptId = (int)tblda.Rows[0][2];
// dataModel.Designation = tblda.Rows[0][3].ToString();
// dataModel.GrossSalary = (float)tblda.Rows[0][4];
// dataModel.BankAccount = (int)tblda.Rows[0][5];
// dataModel.BankName = tblda.Rows[0][6].ToString();
// dataModel.Degree = tblda.Rows[0][7].ToString();
// dataModel.POY = tblda.Rows[0][8].ToString();
// dataModel.DOJ = tblda.Rows[0][9].ToString();
return(View(dataModel));
}
else
{
return(RedirectToAction("Index"));
}
}
public EditEmployeeViewModel(EditEmployee editEmployeeOpen, vwEmployee employeeEdit)
{
eventObject = new EventClass();
editEmployee = editEmployeeOpen;
selectedMenager = new vwMenager();
employee = employeeEdit;
selctedLocation = new vwLOCATION();
selectedMenager = new vwMenager();
//selectedMenager.Menager = employee.MenagerName;
StartDate = (DateTime)employee.DateOfBirth;
Sector = employee.SectorName;
locationService = new LocationService();
employeeService = new EmployeeService();
genderService = new GenderService();
sectorService = new SectorService();
LocationList = locationService.GetAllLocations().ToList();
LocationList.OrderByDescending(x => x.Location);
LocationList.Reverse();
PotentialMenagers = employeeService.GetAllPotentialMenagersForEditWindow(employeeEdit.EmployeeID);
eventObject.ActionPerformed += ActionPerformed;
oldEmployee = new vwEmployee();
oldEmployee.FirstName = employee.FirstName;
oldEmployee.LastName = employee.LastName;
oldEmployee.JMBG = employee.JMBG;
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
//save to the database
db.SaveChanges();
MessageBox.Show("Save Successfull!", "SB Payroll", MessageBoxButtons.OK, MessageBoxIcon.Information);
CalculateTotalNonCashBenefitAmount();
if (OnEmployeeBenefitAmountChanged != null)
{
OnEmployeeBenefitAmountChanged(this, new BenefitAmountHandlerEventArgs(TotalNonCashBenefitsAmount));
}
if (this.Owner is EditEmployee)
{
EditEmployee f = (EditEmployee)this.Owner;
f.GridRefresh();
this.Close();
}
else if (this.Owner is AddEmpTxn)
{
AddEmpTxn aet = (AddEmpTxn)this.Owner;
this.Close();
}
}
catch (Exception ex)
{
Utils.ShowError(ex);
}
}
public EditEmployeeViewModel(EditEmployee editEmployeeView, tblEmployee employeeLogedIn)
{
view = editEmployeeView;
qualifications = new List <string>()
{
"I", "II", "III", "IV", "V", "VI", "VII"
};
userService = new UserService();
sectorService = new SectorService();
employeeService = new EmployeeService();
positionService = new PositionService();
managerService = new ManagerService();
requestService = new RequestService();
User = new tblUser();
EmployeeToEdit = employeeService.GetvwEmployeeByEmployeeId(employeeLogedIn.EmployeeID);
//Employee = new tblEmployee();
SectorList = sectorService.GetSectors();
PositionList = positionService.GetPositions();
//MessageBox.Show(employeeLogedIn.EmployeeID.ToString());
oldEmployee = employeeLogedIn;
oldUserName = EmployeeToEdit.Username;
oldJMBG = EmployeeToEdit.JMBG;
}
private void ButtonClick(object sender, EventArgs e)
{
string clickedButton = (sender as Button).Text;
switch (clickedButton)
{
case "Add Employee":
MVCForm.DisposeView(this.view);
AddEmployee addEmployeeDashboard = new AddEmployee();
AddEmployeeView addEmployeeView = new AddEmployeeView();
AddEmployeeController addEmployeeController = new AddEmployeeController(addEmployeeDashboard, addEmployeeView, this.curForm);
addEmployeeController.DisplayView();
DisplayNavigation();
break;
case "Edit Employee":
MVCForm.DisposeView(this.view);
EditEmployee editEmployeeDashboard = new EditEmployee();
EditEmployeeView editEmployeeView = new EditEmployeeView();
EditEmployeeController editEmployeeController = new EditEmployeeController(editEmployeeDashboard, editEmployeeView, this.curForm);
editEmployeeController.DisplayView();
DisplayNavigation();
break;
case "Delete Employee":
MVCForm.DisposeView(this.view);
DeleteEmployee deleteEmployeeDashboard = new DeleteEmployee();
DeleteEmployeeView deleteEmployeeView = new DeleteEmployeeView();
DeleteEmployeeController deleteEmployeeController = new DeleteEmployeeController(deleteEmployeeDashboard, deleteEmployeeView, this.curForm);
deleteEmployeeController.DisplayView();
DisplayNavigation();
break;
}
}
//[ValidateModelState]
public IActionResult Edit(EditEmployee employee)
{
var requestUrl = client.CreateRequestUri(string.Format(System.Globalization.CultureInfo.InvariantCulture, "Employee/Put"));
var response = client.PostAsync(requestUrl, employee);
return(this.RedirectToAction("Index", "Home", new { id = employee.CompanyId }));
}
private void EditEmployee_Click(object sender, RoutedEventArgs e)
{
EditEmployee editEmployee = new EditEmployee();
editEmployee.Owner = this;
editEmployee.Show();
}
public string GetStaffUDF(int pid)
{
logger.Log(LogLevel.Debug, "Trace:: SIMSBulkImport.Classes.Staff.GetStaffUDF(pid=" + pid + ")");
string result = "";
try
{
var empprocess = new EditEmployee();
empprocess.Load(pid, DateTime.Now);
foreach (UDFValue udfVal in empprocess.Employee.UDFValues)
{
if (udfVal.FieldTypeCode == UDFFieldType.STRING1_CODE)
{
string type = udfVal.TypedValueAttribute.Description;
if (type == simsudf)
{
return(((StringAttribute)udfVal.TypedValueAttribute).Value);
}
}
}
empprocess.Dispose();
}
catch (Exception GetStaffUdfException)
{
logger.Log(LogLevel.Error, GetStaffUdfException);
}
return(result);
}
public EditEmployeeViewModel(EditEmployee editEmployeeViewOpen, tblEmployee employeeToEdit)
{
view = editEmployeeViewOpen;
employeeService = new EmployeeService();
managerService = new MenagerService();
Employee = employeeToEdit;
OldEmployee = employeeToEdit;
}
public EditEmployeeController(EditEmployee model, EditEmployeeView view, Form curForm)
{
db = new LINQDataContext();
this.model = model;
this.view = view;
this.curForm = curForm;
this.view.ComboName.SelectedIndexChanged += (sender, e) => comboName_SelectedIndexChanged(sender, e);
this.view.BtnEdit.Click += (sender, e) => btnEdit_Click(sender, e);
}
private void btEmployeeEdit_Click(object sender, EventArgs e)
{
var selectedRow = dgvEmployees.GetSelectedRow();
var editEmployee = new EditEmployee(repository);
if (editEmployee.Perform(selectedRow))
{
gridLoader.GetAndLoadWith(filterParameters);
}
}
public ActionResult Edit([Bind(Include = "EmployeeID,Email,FullName,Password,ComfirmPassword,JoinDate,Position,Team,Status,Security")] EditEmployee modifiedEmployee)
{
if (ModelState.IsValid)
{
Employee originalEmployee = db.Employees.Find(modifiedEmployee.EmployeeID);
modifiedEmployee.UpdateOriginal(originalEmployee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modifiedEmployee));
}
private void EditProfileExecute()
{
try
{
EditEmployee editEmployee = new EditEmployee(Employee);
editEmployee.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public EditEmployeeViewModel(EditEmployee editEmployeeOpen, EmployeeDto employeeEdit)
{
eventObject = new EventClass();
editEmployee = editEmployeeOpen;
Employee = employeeEdit;
selctedLocation = new LocationDto();
StartDate = (DateTime)employee.DateOfBirth;
Sector = employee.SectorName;
locationService = new LocationService();
employeeService = new EmployeeService();
sectorService = new SectorService();
potentialManagersInDb = employeeService.GetAllPotentialMenagers();
PotentialMenagers = ConvertManagerListToDto(potentialManagersInDb);
PotentialMenagers = PotentialMenagers.Where(x => x.ID != Employee.EmployeeID).ToList();
locations = locationService.GetAllLocations().ToList();
tblLocation locataionForPresent = locationService.GetLocationByID((int)Employee.LocationID);
tblEmployee managerToPresent = null;
if (Employee.ManagerId != null)
{
managerToPresent = employeeService.GetEmployeeByID((int)Employee.ManagerId);
}
LocationList = ConvertLocationDtoList(locations);
SelctedLocation = LocationList.Where(x => x.ID == locataionForPresent.LocationID).FirstOrDefault();
LocationList.OrderByDescending(x => x.Location);
LocationList.Reverse();
//if (managerToPresent!=null)
//{
// SelectedMenager = PotentialMenagers.Where(x=>x.ID==Employee.ManagerId).FirstOrDefault();
//}
eventObject.ActionPerformed += ActionPerformed;
oldEmployee = new EmployeeDto();
oldEmployee.FirstName = employee.FirstName;
oldEmployee.LastName = employee.LastName;
oldEmployee.JMBG = employee.JMBG;
}
public ViewResult Edit(int id)
{
var employee = _employeeRepository.GetEmployeeById(id);
var employeeViewModel = new EditEmployee()
{
Id = employee.Id,
FirstName = employee.FirstName,
Email = employee.Email,
Department = employee.Department,
ExistingPhotoPath = employee.PhotoPath
};
return(View(employeeViewModel));
}
private void EditCommandExecute()
{
try
{
EditEmployee editEmployee = new EditEmployee(SelectedEmployee);
editEmployee.ShowDialog();
EmployeeList = employeeService.GetAllNonManagerEmployees();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public IActionResult Edit(int employeeId)
{
var employee = employeeService.Get(employeeId);
var editEmp = new EditEmployee()
{
AvatarPath = employee.AvatarPath,
Age = employee.Age,
Code = employee.Code,
Email = employee.Email,
Firstname = employee.Firstname,
Lastname = employee.Lastname,
Id = employee.Id
};
return(View(editEmp));
}
public string GetStaffSurname(int pid)
{
logger.Log(LogLevel.Debug, "Trace:: SIMSBulkImport.Classes.Staff.GetStaffSurname(pid=" + pid + ")");
string result = "";
try
{
var empprocess = new EditEmployee();
empprocess.Load(pid, DateTime.Now);
result = empprocess.Employee.Surname;
}
catch (Exception GetPersonSurnameException)
{
logger.Log(LogLevel.Error, GetPersonSurnameException);
}
return(result);
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Employee employee = db.Employees.Find(id);
if (employee == null)
{
return(HttpNotFound());
}
EditEmployee modal = new EditEmployee();
modal.Fill(employee);
return(View(modal));
}
private void EditEmployeeExecute()
{
try
{
EditEmployee editEmployee = new EditEmployee(SelectedEmployee);
editEmployee.ShowDialog();
employees = employeeService.GetEmployees();
EmployeeList = ConvertToListEmployeeDto(employees);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
// GET: ShowDataController/Edit/5
public ActionResult EditEmployee(int id)
{
EditEmployee dataModel = new EditEmployee();
DataTable tblda = new DataTable();
DataSet ds = new DataSet();
using (con)
{
con.Open();
//string query = "select * from Employee where EmpId=@EmpId";
SqlCommand cmd = new SqlCommand("Sp_EditBasicInfo", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sqlda = new SqlDataAdapter(cmd);
sqlda.SelectCommand.Parameters.AddWithValue("@EmpId", id);
sqlda.Fill(tblda);
//ViewBag.DeptName = ds.Tables[0];
//List<SelectListItem> getDeptName = new List<SelectListItem>();
//foreach (System.Data.DataRow dr in ViewBag.DeptName.Rows)
//{
// getDeptName.Add(new SelectListItem { Text = @dr["DeptName"].ToString(), Value = @dr["DeptName"].ToString() });
//}
//ViewBag.Department = getDeptName;
}
if (tblda.Rows.Count == 1)
{
dataModel.EmpId = (int)tblda.Rows[0][0];
dataModel.EmpName = tblda.Rows[0][1].ToString();
dataModel.DeptId = (int)tblda.Rows[0][2];
// dataModel.Designation = tblda.Rows[0][3].ToString();
// dataModel.GrossSalary = (float)tblda.Rows[0][4];
// dataModel.BankAccount = (int)tblda.Rows[0][5];
// dataModel.BankName = tblda.Rows[0][6].ToString();
// dataModel.Degree = tblda.Rows[0][7].ToString();
// dataModel.POY = tblda.Rows[0][8].ToString();
// dataModel.DOJ = tblda.Rows[0][9].ToString();
return(View(dataModel));
}
else
{
return(RedirectToAction("Index"));
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (IsEmployeeTransactionValid())
{
try
{
if (cbItemId.SelectedIndex != -1)
{
_empTxn.ItemId = cbItemId.SelectedValue.ToString();
}
decimal _amount;
if (!string.IsNullOrEmpty(txtAmount.Text) && decimal.TryParse(txtAmount.Text, out _amount))
{
_empTxn.Amount = _amount;
}
decimal _YTDAmount;
if (!string.IsNullOrEmpty(txtYTDAmount.Text) && decimal.TryParse(txtYTDAmount.Text, out _YTDAmount))
{
_empTxn.Balance = _YTDAmount;
}
_empTxn.PostDate = DateTime.Today;
_empTxn.EmpNo = _empTxn.EmpNo;
_empTxn.Recurrent = chkRecurrent.Checked;
_empTxn.Enabled = chkEnabled.Checked;
_empTxn.TrackYTD = chkTrackYTD.Checked;
_empTxn.CreatedBy = _empTxn.CreatedBy;
_empTxn.LastChangeDate = DateTime.Today;
_empTxn.LastChangedBy = _User;
_empTxn.AuthorizedBy = _empTxn.AuthorizedBy;
_empTxn.AuthorizeDate = _empTxn.AuthorizeDate.GetValueOrDefault();
_empTxn.ShowYTDInPayslip = chkShowYTDinPayslip.Checked;
rep.UpdateEmpTxn(_empTxn);
EditEmployee f = (EditEmployee)this.Owner;
f.GridRefresh();
this.Close();
}
catch (Exception ex)
{
Utils.ShowError(ex);
}
}
}
private void EditEmployeeExecute()
{
try
{
if (Employee != null)
{
EditEmployee editEmployee = new EditEmployee(Employee);
editEmployee.ShowDialog();
Employees = employeeService.GetAllEmployees().ToList();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public string GetStaffDOB(int pid)
{
logger.Log(LogLevel.Debug, "Trace:: SIMSBulkImport.Classes.Staff.GetStaffDOB(pid=" + pid + ")");
string result = "";
try
{
var empprocess = new EditEmployee();
empprocess.Load(pid, DateTime.Now);
DateTime dt = empprocess.Employee.DateOfBirth;
result = dt.ToShortDateString();
}
catch (Exception GetPersonDobException)
{
logger.Log(LogLevel.Error, GetPersonDobException);
}
return(result);
}
public IActionResult Edit(EditEmployee model)
{
if (ModelState.IsValid)
{
var existingAvatar = model.AvatarPath;
if (model.Avatar != null)
{
//remove exist file
existingAvatar = existingAvatar.Split("/").Last();
if (string.Compare(existingAvatar, "noavatar.jpg") != 0)
{
System.IO.File.Delete(Path.Combine(webHostEnvironment.WebRootPath, "images", existingAvatar));
}
//upload new file
var folderPath = Path.Combine(webHostEnvironment.WebRootPath, "images");
var filename = $"{Guid.NewGuid()}_{model.Avatar.FileName}";
var filePath = Path.Combine(folderPath, filename);
using (var fs = new FileStream(filePath, FileMode.Create))
{
model.Avatar.CopyTo(fs);
}
existingAvatar = $"~/images/{filename}";
}
var employee = new ViewEmployee()
{
Age = model.Age,
AvatarPath = existingAvatar,
Code = model.Code,
Email = model.Email,
Firstname = model.Firstname,
Lastname = model.Lastname,
Id = model.Id,
Phone = model.Phone
};
if (employeeService.Edit(employee))
{
return(RedirectToAction("Profile", "Employee", new { id = model.Id }));
}
}
return(View(model));
}
private void dataGridViewEmployees_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dataGridViewEmployees.SelectedRows.Count != 0)
{
DAL.Employee emp = (DAL.Employee)bindingSourceEmployees.Current;
Forms.EditEmployee f = new EditEmployee(emp, _user, connection);
f.Text = emp.Surname.ToString().Trim().ToUpper() + " " + emp.OtherNames.ToString().Trim().ToUpper();
f.Owner = this;
f.ShowDialog();
}
}
catch (Exception ex)
{
Utils.ShowError(ex);
}
}
public string GetStaffTelephone(int pid)
{
logger.Log(LogLevel.Debug, "Trace:: SIMSBulkImport.Classes.Staff.GetStaffTelephone(pid=" + pid + ")");
string result = "";
try
{
var empprocess = new EditEmployee();
empprocess.Load(pid, DateTime.Now);
if (empprocess.Employee.Telephones.Value.Count > 0)
{
int workcount = 1;
string telephone = null;
foreach (Telephone item in empprocess.Employee.Telephones.Value)
{
//int location = item.Location.ID;
//if (location == telephoneLocationId)
if (workcount == 1)
{
telephone = item.Number.ToLower();
}
else
{
telephone = telephone + "," + item.Number.ToLower();
}
workcount = workcount + 1;
}
if (string.IsNullOrEmpty(telephone))
{
return("<NO TYPE TELEPHONE>");
}
return(telephone);
}
return("<BLANK>");
}
catch (Exception GetPersonEmailException)
{
logger.Log(LogLevel.Error, GetPersonEmailException);
}
return(result);
}
public IActionResult Edit(int employeeId)
{
var employee = employeeService.Get(employeeId);
if (employee == null)
{
return(View("~/Views/Erorr/EmployeeNotFound.cshtml", employeeId));
}
var editEmp = new EditEmployee()
{
AvatarPath = employee.AvatarPath,
Age = employee.Age,
Code = employee.Code,
Email = employee.Email,
Firstname = employee.Firstname,
Lastname = employee.Lastname,
Id = employee.Id
};
return(View(editEmp));
}
public IActionResult Edit(EditEmployee model)
{
if (ModelState.IsValid)
{
var employee = _employeeRepository.GetEmployeeById(model.Id);
employee.FirstName = model.FirstName;
employee.Email = model.Email;
employee.Department = model.Department;
if (model.Photo != null)
{
if (model.ExistingPhotoPath != null)
{
string filePath = Path.Combine(hostingEnvironment.WebRootPath, "Images", model.ExistingPhotoPath);
System.IO.File.Delete(filePath);
}
employee.PhotoPath = ProcessUploadedFile(model);
}
return(RedirectToAction("Employees"));
}
return(View());
}
