// GET: Part40DisplayForFormatText/Details/5
public ActionResult Details(int id)
{
EmployeeBusiness emp = new EmployeeBusiness();
EmployeeBO employee = (EmployeeBO)emp.DeptEmployees().Where(m => m.EmpID == id).FirstOrDefault();
return(View(employee));
}
public void TestMethod1()
{
var mockEmployeeBusiness = new Mock <IEmployeeBusiness>();
var mockRepo = new Mock <IGenericRepository <Employee> >();
AutoMapperProfile.Run();
var mockMapper = new Mock <IMapper>();
IQueryable <Employee> employees = new Employee[] { new Employee()
{
FirstName = "Alejandro", Id = 1, ContractType = new ContractType {
Id = 1
}, Salary = 200
} }.AsQueryable();
mockRepo.Setup(repo => repo.GetAll()).Returns(employees);
IPaymentFactory paymentFac = new PaymentFactory();
IEmployeeBusiness _employeeBusiness = new EmployeeBusiness(mockRepo.Object, paymentFac);
var model = _employeeBusiness.Get(1);
//Salary = 200
//MonthlySalary (MonthtlySalary * 12)
// 200 * 12 = 2400
Assert.IsTrue(model.AnnualSalary.Equals(2400));
}
public GetEmployeeController()
{
if (_employeeBusiness == null)
{
_employeeBusiness = new EmployeeBusiness();
}
}
public IActionResult Delete(EmployeeDeleteModel employee)
{
EmployeeBusiness employeeBusiness = new EmployeeBusiness();
var result = employeeBusiness.Delete(employee);
return(Ok(result));
}
public LoginForm1()
{
_employeeBusiness = new EmployeeBusiness();
_employee = new Employee();
_employeeRole = new EmployeeRole();
InitializeComponent();
}
public IActionResult GetPaging(BaseCondition <Employee> condition)
{
EmployeeBusiness employeeBusiness = new EmployeeBusiness();
var result = employeeBusiness.GetAllEmployeeSearched(condition);
return(Ok(result));
}
public IActionResult GetAll()
{
EmployeeBusiness employeeBusiness = new EmployeeBusiness();
var result = employeeBusiness.GetAll();
return(Ok(result));
}
private Employee GetEmployeeByID(int ID)
{
try
{
using (var employeesBusiness = new EmployeeBusiness())
{
Employee castedEmployee = null;
Employee responsedEmployee = employeesBusiness.GetByID(ID);
if (responsedEmployee != null)
{
castedEmployee = new Employee()
{
EmployeesId = responsedEmployee.EmployeesId,
EmployeesCompanyId = responsedEmployee.EmployeesCompanyId,
EmployeesAddress = responsedEmployee.EmployeesAddress,
EmployeesEmail = responsedEmployee.EmployeesEmail,
EmployeesPhoneNumber = responsedEmployee.EmployeesPhoneNumber,
EmployessPassword = responsedEmployee.EmployessPassword
};
}
return(castedEmployee);
}
}
catch (Exception ex)
{
LogHelper.Log(LogTarget.File, ExceptionHelper.ExceptionToString(ex), true);
throw new Exception("Employee doesn't exists.");
}
}
public ResponseBussiness <EmployeeResponse[]> SearchEmployee(EmployeeRequest employeeRequest)
{
TokenDto token = new TokenService().Get();
ResponseBussiness <EmployeeResponse[]> response = new EmployeeBusiness(token).SearchEmployee(employeeRequest);
return(response);
}
protected void Page_Load(object sender, EventArgs e)
{
pnlRed.Visible = false;
pnlGreen.Visible = false;
pnlYellow.Visible = false;
pnlBlue.Visible = false;
SB = new ServiceBusiness();
AB = new AccountBusiness();
EB = new EmployeeBusiness();
DB = new DepartmentBusiness();
CB = new CompanyBLL();
OB = new OrderBusiness();
GetRouteData();
cvBillDate.ValueToCompare = DateTime.Now.Date.ToShortDateString();
if (!IsPostBack)
{
loadData();
}
else
{
String script = WebHelper.Instance.GetJqueryScript("App_Themes/js/jquery/custom_jquery.js");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MessageWarning", script, true);
}
}
//
// GET: /Home/
public ActionResult Index()
{
IEmployeeBusiness empData = new EmployeeBusiness();
ViewBag.EmpName = empData.GetEmployeeName("189080");
return(View());
}
private void LoginButton_Click(object sender, EventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
try
{
var login = new LoginViewBusiness();
if (login.Login(UsernameField.Text, PasswordField.Text) == true)
{
var employeeName = new EmployeeBusiness();
string firstName = employeeName.GetEmployeeFirstName(UsernameField.Text);
string lastName = employeeName.GetEmployeeLastName(UsernameField.Text);
var newForm = new MainScreen(firstName, lastName);
this.Hide();
newForm.Show();;
}
else
{
ErrorMsgLabel.Text = "Грешно потребителско име или парола";
ErrorMsgLabel.ForeColor = Color.Red;
};
}
catch (ArgumentNullException)
{
ErrorMsgLabel.Text = "Грешка във въведените данни";
ErrorMsgLabel.ForeColor = Color.Red;;
}
}
private void BindEmpRecords()
{
DataSet ds = new DataSet();
try
{
ds = objBLL.GetEmpRecords();
if (ds.Tables[0].Rows.Count > 0)
{
grdEmpDetails.DataSource = ds;
grdEmpDetails.DataBind();
}
else
{
grdEmpDetails.DataSource = null;
grdEmpDetails.DataBind();
}
}
catch (Exception ex)
{
Response.Write("Error Occured: " + ex.Message.ToString());
}
finally
{
objBEL = null;
objBLL = null;
}
}
// GET: Part40DisplayForFormatText/Edit/5
public ActionResult Edit(int id)
{
EmployeeBusiness emp = new EmployeeBusiness();
EmployeeBO employee = (EmployeeBO)emp.DeptEmployees().SingleOrDefault(m => m.EmpID == id);
return(View(employee));
}
protected void Page_Load(object sender, EventArgs e)
{
pnlRed.Visible = false;
pnlGreen.Visible = false;
pnlYellow.Visible = false;
pnlBlue.Visible = false;
EB = new EmployeeBusiness();
DB = new DepartmentBusiness();
AB = new AccountBusiness();
GetRouteData();
loadData();
Search();
if (IsPostBack)
{
String script = WebHelper.Instance.GetJqueryScript("App_Themes/js/jquery/custom_jquery.js");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MessageWarning", script, true);
}
else
{
ddlSearchBy.Items.Clear();
ddlSearchBy.Items.Add("All");
if (IsAdmin())
{
ddlSearchBy.Items.Add("Account");
}
ddlSearchBy.Items.Add("Employee");
ddlSearchBy.Items.Add("Department");
}
}
// GET: Account
public ActionResult Index()
{
EmployeeBusiness obj = new EmployeeBusiness();
List <Employee> EmployeeList = obj.GetAllEmployees();
return(View(EmployeeList));
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtId.Text.Trim()) || string.IsNullOrEmpty(txtPassword.Text.Trim()))
{
MessageBox.Show(@"Vui lòng kiểm tra lại thông tin đăng nhập và mật khẩu.", @"Lỗi", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
var employee = new EmployeeDto
{
EmployeeId = "1",
Username = txtId.Text,
Password = txtPassword.Text
};
try
{
if (!EmployeeBusiness.IsValid(employee.Username, employee.Password))
{
MessageBox.Show(@"Thông tin đăng nhập hoặc mật khẩu không hợp lệ.", @"Lỗi", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
}
catch (Exception)
{
MessageBox.Show(@"Không thể kết nối cơ sở dữ liệu.", @"Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
Dispose();
return;
}
new FormMain(employee, this).Show();
Hide();
}
public void Mutation_UpdateRate_InvalidRoomKind()
{
Database.WriteAsync(realm => realm.Add(new Rate
{
Id = 21,
RoomKind = RoomKindBusiness.Get(1),
Employee = EmployeeBusiness.Get("admin")
})).Wait();
SchemaHelper.ExecuteAndExpectError(
"Mã loại phòng không tồn tại",
@"/_GraphQL/Rate/mutation.updateRate.gql",
new
{
input = new
{
id = 21,
dayRate = 5,
nightRate = 5,
weekRate = 5,
monthRate = 5,
lateCheckOutFee = 5,
earlyCheckInFee = 5,
effectiveStartDate = DateTimeOffset.MinValue,
roomKind = new
{
id = 100
}
}
},
p => p.PermissionManageRate = true
);
}
public IActionResult Add(AddEmployeeModel employee)
{
EmployeeBusiness employeeBusiness = new EmployeeBusiness();
var result = employeeBusiness.AddEmployee(employee);
return(Ok(result));
}
public void Mutation_ConfirmCleanedAndServices_InvalidStatus()
{
Database.WriteAsync(realm => realm.Add(new HouseKeeping
{
Id = 33,
Status = (int)HouseKeeping.StatusEnum.Pending,
Type = (int)HouseKeeping.TypeEnum.ExpectedDeparture,
Employee = EmployeeBusiness.Get("admin"),
Booking = BookingBusiness.Get(1)
})).Wait();
SchemaHelper.ExecuteAndExpectError(
"Không thể xác nhận dọn phòng",
@"/_GraphQL/HouseKeeping/mutation.confirmCleanedAndServices.gql",
new
{
servicesDetails = new[]
{
new
{
number = 1,
service = new { id = 1 }
},
new
{
number = 2,
service = new { id = 1 }
}
},
houseKeepingId = 33
},
p => p.PermissionCleaning = true
);
}
public IActionResult GetById(int Id)
{
EmployeeBusiness employeeBusiness = new EmployeeBusiness();
var result = employeeBusiness.GetById(Id);
return(Ok(result));
}
public void Mutation_ConfirmCleanedAndServices_InvalidType()
{
Database.WriteAsync(realm => realm.Add(new HouseKeeping
{
Id = 34,
Status = (int)HouseKeeping.StatusEnum.Cleaning,
Type = (int)HouseKeeping.TypeEnum.ExpectedArrival,
Employee = EmployeeBusiness.Get("admin"),
Booking = BookingBusiness.Get(1)
})).Wait();
SchemaHelper.ExecuteAndExpectError(
"Chỉ được sử dụng kiểu xác nhận này đối với phòng check-out",
@"/_GraphQL/HouseKeeping/mutation.confirmCleanedAndServices.gql",
new
{
servicesDetails = new[]
{
new
{
number = 1,
service = new { id = 1 }
},
new
{
number = 2,
service = new { id = 1 }
}
},
houseKeepingId = 34
},
p => p.PermissionCleaning = true
);
}
public IActionResult EditStatus(EmployeeEditStatusModel employee)
{
EmployeeBusiness employeeBusiness = new EmployeeBusiness();
var result = employeeBusiness.EditStatus(employee);
return(Ok(result));
}
public void Mutation_ConfirmCleaned_InvalidEmployee()
{
Database.WriteAsync(realm =>
{
realm.Add(new Employee
{
Id = "nhanvien_60",
Address = "Địa chỉ",
IsActive = true,
Birthdate = DateTimeOffset.Now,
Email = "*****@*****.**",
Gender = true,
Name = "Quản trị viên",
IdentityCard = "123456789",
Password = CryptoHelper.Encrypt("12345678"),
PhoneNumber = "+84 0123456789",
Position = PositionBusiness.Get(1),
StartingDate = DateTimeOffset.Now
});
realm.Add(new HouseKeeping
{
Id = 22,
Status = (int)HouseKeeping.StatusEnum.Cleaning,
Employee = EmployeeBusiness.Get("nhanvien_60"),
Booking = BookingBusiness.Get(1)
});
}).Wait();
SchemaHelper.ExecuteAndExpectError(
"Nhân viên không được phép xác nhận dọn",
@"/_GraphQL/HouseKeeping/mutation.confirmCleaned.gql",
new { id = 22 },
p => p.PermissionCleaning = true
);
}
public ActionResult Part64Sorting(string searchby, string search, int?Page, string sortBy)
{
ViewBag.SortByNameParameter = string.IsNullOrEmpty(sortBy) ? "Name desc" : "";
ViewBag.SortByGenderParameter = (sortBy == "Gender") ? "Gender Desc" : "Gender";
EmployeeBusiness db = new EmployeeBusiness();
var employee = db.DeptEmployees().AsQueryable();
if (searchby == "Gender")
{
employee = employee.Where(x => x.Gender == search || search == null);
}
else
{
employee = employee.Where(x => x.Employeename.StartsWith(search) || search == null);
}
switch (sortBy)
{
case "Name desc":
employee = employee.OrderByDescending(x => x.Employeename);
break;
case "Gender Desc":
employee = employee.OrderByDescending(x => x.Gender);
break;
case "Gender":
employee = employee.OrderBy(x => x.Gender);
break;
default:
employee = employee.OrderBy(x => x.Employeename);
break;
}
return(View(employee.ToPagedList(Page ?? 1, 3)));
}
public JsonResult UpdateEmployeeBasicInfo(EmployeeInfoModel model)
{
try
{
var result = EmployeeBusiness.UpdateEmployeeBasicInfo(model);
if (result != null)
{
if (Request.Files.Count > 0)
{
UploadEmployeeResume(result.employeeId);
}
}
var response = new ApiRespnoseWrapper {
status = ApiRespnoseStatus.Success, results = new ArrayList()
{
result
}
};
return(new JsonResult {
Data = response
});
}
catch (Exception ex)
{
return(CommonBusiness.GetErrorResponse(ex.Message));
}
}
public ActionResult Part73OutputCache()
{
// System.Threading.Thread.Sleep(3000);
EmployeeBusiness db = new EmployeeBusiness();
return(View(db.DeptEmployees()));
}
public bool UploadEmployeeResume(int employeeId)
{
var folderPath = CommonFunctions.GetConfigValue("employeeResumePath");
List <string> documentExtensions = new List <string>()
{
".pdf", ".doc", ".docx"
};
for (int i = 0; i < Request.Files.Count; i++)
{
var fileName = Path.GetFileName(Request.Files[i].FileName);
var fileExtension = Path.GetExtension(Request.Files[i].FileName).ToLower();
var fileNameOnDisk = string.Empty;
if (documentExtensions.IndexOf(fileExtension) < 0)
{
return(false);
}
fileNameOnDisk = fileNameOnDisk = "ER-" + employeeId + "-" + Guid.NewGuid().ToString().Replace("-", "") + fileExtension;
Request.Files[i].SaveAs(folderPath + fileNameOnDisk);
if (EmployeeBusiness.UploadResume(employeeId, fileName, fileNameOnDisk, Request.Files[i].ContentLength) > 0)
{
return(true);
}
else
{
return(false);
}
}
return(true);
}
private void importEmployeeToolStripMenuItem_Click(object sender, EventArgs e)
{
EmployeeBusiness _bll = new EmployeeBusiness();
OpenFileDialog openFileDialog = new OpenFileDialog();
if (openFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string filePath = openFileDialog.FileName;
string fileName = System.IO.Path.GetFileNameWithoutExtension(openFileDialog.FileName);
List <GetDuplicateGEIDModel> listofDuplicate;
_bll.GetEmployeeExcel(filePath, fileName);
_bll.SaveListEmployee();
listofDuplicate = _bll.GetDuplicateGEID(filePath, fileName);
string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
Directory.CreateDirectory(path + "\\ListofDuplicate");
string fullpath = path + "\\ListofDuplicate\\DuplicateGEID_" + fileName.Replace(".xls", "") + "_" + DateTime.Now.ToString("dd-MM-yyyy") + ".txt";
StreamWriter writer = new StreamWriter(fullpath, false, System.Text.Encoding.GetEncoding("windows-1252"));
writer.WriteLine("GEID Number ; Employee Name ; Legal Vehicle");
if (listofDuplicate.Count > 0)
{
for (int i = 0; i <= listofDuplicate.Count - 1; i++)
{
writer.WriteLine(listofDuplicate[i].GEID + " ; " + listofDuplicate[i].EmpName + " ; " + listofDuplicate[i].LegalVehicle);
}
MessageBox.Show("Please check the list of duplicate GEID # in: " + fullpath, "OCMS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
writer.Close();
MessageBox.Show("Successfully Import List of Employee!", "OCMS", MessageBoxButtons.OK);
}
}
public List <Employee> GetAllEmployees()
{
EmployeeBusiness employeeRepository = new EmployeeBusiness(new ApiEmployeeRepository());
List <EmployeeDTO> employeesDto = employeeRepository.GetEmployees();
List <Employee> employees = new List <Employee>();
EmployeeFactory contractFactory = new EmployeeFactory();
var config = new MapperConfiguration(cfg => {
cfg.CreateMap <EmployeeDTO, Employee>();
});
IMapper iMapper = config.CreateMapper();
if (employeesDto != null)
{
foreach (var employeeDto in employeesDto)
{
Employee employee = contractFactory.CreateContract(employeeDto.ContractTypeName);
iMapper.Map <EmployeeDTO, Employee>(employeeDto, employee);
employee.CalculateSalary();
employees.Add(employee);
}
}
return(employees);
}
