public async Task <ActionResult> pvwAddEmployees([FromBody] EmployeesDTO _sarpara) { EmployeesDTO _Employees = new EmployeesDTO(); try { string baseadress = config.Value.urlbase; HttpClient _client = new HttpClient(); _client.DefaultRequestHeaders.Add("Authorization", "Bearer " + HttpContext.Session.GetString("token")); var result = await _client.GetAsync(baseadress + "api/Employees/GetEmployeesById/" + _sarpara.IdEmpleado); string valorrespuesta = ""; if (result.IsSuccessStatusCode) { valorrespuesta = await(result.Content.ReadAsStringAsync()); _Employees = JsonConvert.DeserializeObject <EmployeesDTO>(valorrespuesta); } if (_Employees == null) { _Employees = new EmployeesDTO(); } } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); throw ex; } return(PartialView(_Employees)); }
public EmployeesDTO GetEmployeesByPositionId(int positionId) { try { var employeesCollection = _employeeService.GetEmployeesByPositionId(positionId); var result = new EmployeesDTO { Employees = employeesCollection, Status = CollectionGetStatus.Success }; return(result); } catch (Exception e) { Console.WriteLine(e.Message); var result = new EmployeesDTO { Status = CollectionGetStatus.Failure }; return(result); } }
public ActionResult UpdateEmployee(EmployeesDTO employeesDTO) { bool isUpdated = _EmployeesBusiness.UpdateEmployee(employeesDTO); //var employee = _EmployeesBusiness.GetEmployee(employeesDTO.Id); return(RedirectToAction("GetEmployees")); }
private void UpdateEmployees() { GridView gridView = grcEmployees.FocusedView as GridView; EmployeesDTO employeesDTO = new EmployeesDTO(); employeesDTO.iMaNV = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iMaNV"); employeesDTO.iTenNV = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iTenNV"); employeesDTO.iDienThoai = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iDienThoai"); employeesDTO.iDiaChi = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iDiaChi"); employeesDTO.iDiDong = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iDiDong"); employeesDTO.iEmail = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iEmail"); employeesDTO.iBoPhan = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iBoPhan"); employeesDTO.iNguoiQL = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iNguoiQL"); employeesDTO.iActive = (bool)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iActive"); frmUpdateEmployees frmUpdate = new frmUpdateEmployees(employeesDTO); frmUpdate.ShowDialog(); if (statusAction == 1) { LoadEmployees(); statusAction = 0; } else { } }
public ActionResult GetEmployee(int EmployeeId) { var employee = new EmployeesDTO(); employee = _EmployeesBusiness.GetEmployee(EmployeeId); return(View(employee)); }
public formMain(EmployeesDTO accountName) { InitializeComponent(); pnlPrint.Hide(); this.CurrentAccount = accountName; ReLoad("12345"); }
bool IEmployeesAccess.EmployeesMod(EmployeesDTO DTO) { try { using (NorthwindContext DB = new NorthwindContext()) { //TODO fix Mapper.Initialize(cfg => cfg.CreateMap <EmployeesDTO, Territories>()); var model = Mapper.Map <Territories>(DTO); var item = DB.Employees.Where(b => b.EmployeeId == DTO.EmployeeId); if (item != null) { DB.Add(model); } else { return(false); } DB.SaveChanges(); return(true); } } catch { return(false); } }
//public List<EmployeesDTO> searchEmployees1(EmployeesDTO e) //{ // List<EmployeesDTO> listEmployee = new List<EmployeesDTO>(); // try // { // string sql1 = "select e.*, acc.password from employees e, accounts acc where e.userid = acc.userid and" + // " name like @name and address like @address and e.userid like @userid"; // //string sql1 = "select e.*, acc.password from employees e, accounts acc where e.userid = acc.userid and" + // // " name like '%T%' and isleader = true and address like '%%' and e.userid like '%%'"; // //string sql1 = "select e.*, acc.password from employees e, accounts acc where e.userid = acc.userid and" + // // " name like '%" +e.Name+"%' and isleader =" + e.Isleader + " and address like '%" + e.Address+ "%' and e.userid like '%" + e.Userid+ "%'"; // NpgsqlConnection pgcon = new NpgsqlConnection(connectionString); // pgcon.Open(); // NpgsqlCommand pgcom = new NpgsqlCommand(sql1, pgcon); // var a = e.Isleader; // pgcom.CommandType = CommandType.Text; // pgcom.Parameters.AddWithValue("name", "%" + e.Name + "%"); // pgcom.Parameters.AddWithValue("address", "%" + e.Address + "%"); // pgcom.Parameters.AddWithValue("userid", "%" + e.Userid + "%"); // NpgsqlDataReader pgreader = pgcom.ExecuteReader(); // while (pgreader.Read()) // { // EmployeesDTO result = new EmployeesDTO(); // result.Name = pgreader.GetString(2); // result.Userid = pgreader.GetString(6); // result.Password = pgreader.GetString(8); // result.Dateofbirth = pgreader.GetDateTime(3); // result.Address = pgreader.GetString(5); // result.Idcard = pgreader.GetInt32(4); // result.Isleader = pgreader.GetBoolean(1); // listEmployee.Add(result); // } // return listEmployee; // } // catch // { // } // return listEmployee; //} public bool InsertEmployee(EmployeesDTO e) { try { string sql2 = "INSERT INTO employees (isleader,name,dateofbirth,idcard,address,userid, salaryid) VALUES (@isleader,@name, @dateOfBirth, @idCard, @address, @userId, @salaryId)"; NpgsqlConnection pgcon = new NpgsqlConnection(connectionString); pgcon.Open(); NpgsqlCommand pgcom = new NpgsqlCommand(sql2, pgcon); pgcom.CommandType = CommandType.Text; pgcom.Parameters.AddWithValue("isleader", e.Isleader); pgcom.Parameters.AddWithValue("name", e.Name); pgcom.Parameters.AddWithValue("dateOfBirth", e.Dateofbirth); pgcom.Parameters.AddWithValue("idCard", e.Idcard); pgcom.Parameters.AddWithValue("address", e.Address); pgcom.Parameters.AddWithValue("userId", e.Userid); pgcom.Parameters.AddWithValue("salaryId", e.Salaryid); NpgsqlDataReader pgreader = pgcom.ExecuteReader(); return(true); } catch { return(false); } }
public async Task <IHttpActionResult> GetEmployee(int id) { EmployeesDTO empl = new EmployeesDTO(); var employee = await db.Employees.Where(x => x.Position.SalonID == id && !x.Deleted).Select(x => new EmplForListDTO { EmployeeID = x.EmployeeID, FirstName = x.FirstName, LastName = x.LastName, MiddleName = x.MiddleName, PositionID = x.PositionID, PositionName = x.Position.PositionName, ImageUrl = x.ImageUrl, EmplSchedule = db.EmployeeSchedules.Where(z => z.EmployeeID == x.EmployeeID).Select(y => new { Date = y.Date, DayOfWeek = y.DayOfWeek, EmployeeID = y.EmployeeID, EndTime = y.EndTime, Holiday = y.Holiday, ScheduleID = y.ScheduleID, StartTime = y.StartTime }) }).ToListAsync(); empl.Employees = employee; empl.PositionsCount = await db.Positions.CountAsync(x => !x.Deleted && x.SalonID == id); return(Ok(empl)); }
protected void Application_AuthenticateRequest() { if (User == null) { return; } string login = Context.User.Identity.Name; string[] roles = null; using (BankDB bankDB = new BankDB()) { ClientsDTO clientsDTO = bankDB.Clients.FirstOrDefault(x => x.ClientLogin == login); EmployeesDTO employeesDTO = bankDB.Employees.FirstOrDefault(x => x.EmployeeLogin == login); if (clientsDTO != null) { roles = bankDB.UserRoles.Where(x => x.UserId == clientsDTO.ClientId).Select(x => x.RoleClient.Name).ToArray(); } else { roles = bankDB.ListEmployeeRoles.Where(x => x.EmployeeId == employeesDTO.EmployeeId).Select(x => x.RoleEmployee.Name).ToArray(); } } IIdentity clientIdentity = new GenericIdentity(login); IPrincipal newClientObject = new GenericPrincipal(clientIdentity, roles); Context.User = newClientObject; }
public ActionResult LoginPartial() { string login = User.Identity.Name; LoginPartialVM loginPartial; using (BankDB bankDB = new BankDB()) { EmployeesDTO employeesDTO = bankDB.Employees.FirstOrDefault(x => x.EmployeeLogin == login); ClientsDTO clientsDTO = bankDB.Clients.FirstOrDefault(x => x.ClientLogin == login); if (employeesDTO == null) { loginPartial = new LoginPartialVM() { FirstName = clientsDTO.ClientName, Surname = clientsDTO.ClientSurname }; } else { loginPartial = new LoginPartialVM() { FirstName = employeesDTO.EmployeeName, Surname = employeesDTO.EmployeeSurname }; } return(PartialView("_LoginPartial", loginPartial)); } }
public IHttpActionResult CreateEmployee(EmployeesDTO dto) { bool isAdded = _EmployeesBusiness.CreateEmployee(dto); return(Ok(isAdded)); }
public bool UpdateEmployee(EmployeesDTO e) { try { string sql2 = "update employees set isleader = @isleader ,name = @name ,dateofbirth = @dateOfBirth,idcard = @idCard ,address = @address,salaryid = @salaryId" + " where userid = @userid "; NpgsqlConnection pgcon = new NpgsqlConnection(connectionString); pgcon.Open(); NpgsqlCommand pgcom = new NpgsqlCommand(sql2, pgcon); pgcom.CommandType = CommandType.Text; pgcom.Parameters.AddWithValue("isleader", e.Isleader); pgcom.Parameters.AddWithValue("name", e.Name); pgcom.Parameters.AddWithValue("dateOfBirth", e.Dateofbirth); pgcom.Parameters.AddWithValue("idCard", e.Idcard); pgcom.Parameters.AddWithValue("address", e.Address); pgcom.Parameters.AddWithValue("userId", e.Userid); pgcom.Parameters.AddWithValue("salaryId", e.Salaryid); NpgsqlDataReader pgreader = pgcom.ExecuteReader(); return(true); } catch { return(false); } }
public ActionResult CreateEmployee(EmployeesDTO dto) { bool isAdded = _EmployeesBusiness.CreateEmployee(dto); return(RedirectToAction("GetEmployees")); }
private void btnSave_Click_1(object sender, EventArgs e) { EmployeesDTO nv = new EmployeesDTO(); nv.iTenNV = txtTenNV.Text; nv.iDiaChi = txtDiaChi.Text; nv.iDienThoai = txtDienThoai.Text; nv.iDiDong = txtDiDong.Text; nv.iEmail = txtEmail.Text; nv.iBoPhan = lkBoPhan.EditValue != null?lkBoPhan.EditValue.ToString() : null; nv.iNguoiQL = lkQuanLy.EditValue != null?lkQuanLy.EditValue.ToString() : null; nv.iActive = bool.Parse(ckActive.Checked.ToString()); if (nv.iTenNV == "") { XtraMessageBox.Show("Dữ liệu ô này không được bỏ trống!!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtTenNV.Focus(); } else { int check = employeesBUS.InsertEmployees(nv); if (check == 1) { XtraMessageBox.Show("Success!!!"); frmEmployees.statusAction = 1; this.Close(); } else { XtraMessageBox.Show("Fail!!!"); } } }
public ActionResult CreateEmployee(EmployeeVM model) { TextInfo textInfo = CultureInfo.CurrentCulture.TextInfo; if (!ModelState.IsValid) { using (BankDB bankDB = new BankDB()) { model.positionList = new SelectList(bankDB.EmployeeRoles.ToList(), "Id", "Name"); return(View(model)); } } using (BankDB bankDB = new BankDB()) { EmployeesDTO employeesDTO = new EmployeesDTO(); if (bankDB.Employees.Any(x => x.EmployeeLogin == model.EmployeeLogin)) { ModelState.AddModelError("loginExist", "Это имя занято, выберите другое"); return(View(model)); } employeesDTO.EmployeeName = textInfo.ToTitleCase(model.EmployeeName); employeesDTO.EmployeeSurname = textInfo.ToTitleCase(model.EmployeeSurname); employeesDTO.EmployeeAge = model.EmployeeAge; employeesDTO.EmployeeEmail = model.EmployeeEmail; employeesDTO.EmployeePhone = model.EmployeePhone; employeesDTO.EmployeeLogin = model.EmployeeLogin; employeesDTO.EmployeePassword = model.EmployeePassword; employeesDTO.EmployeePositionId = model.EmployeePositionId; EmployeeRoleDTO employeeRole = bankDB.EmployeeRoles.FirstOrDefault(x => x.Id == model.EmployeePositionId); employeesDTO.EmployeePosition = employeeRole.Name; employeesDTO.EmployeeSalary = model.EmployeeSalary; employeesDTO.ClientsCount = 0; bankDB.Employees.Add(employeesDTO); bankDB.SaveChanges(); int id = employeesDTO.EmployeeId; int roleId = bankDB.EmployeeRoles.Where(x => x.Name == employeeRole.Name).Select(x => x.Id).First(); ListEmployeeRoleDTO listRoleEmployee = new ListEmployeeRoleDTO() { EmployeeId = id, RoleEmployeeId = roleId }; bankDB.ListEmployeeRoles.Add(listRoleEmployee); bankDB.SaveChanges(); } TempData["OK"] = "Сотрудник добавлен"; return(RedirectToAction("Index")); }
private void grvNhanVien_MasterRowGetChildList(object sender, DevExpress.XtraGrid.Views.Grid.MasterRowGetChildListEventArgs e) { GridView grv = sender as GridView; EmployeesDTO infor = grv.GetRow(e.RowHandle) as EmployeesDTO; e.ChildList = listTheoHangHoaBuy.Where(x => x.MaNV == infor.iMaNV).ToList(); }
public List <EmployeesDTO> searchEmployees(EmployeesDTO e) { List <EmployeesDTO> listEmployee = new List <EmployeesDTO>(); try { string sql1 = "select e.*, acc.password from employees e, accounts acc where e.userid = acc.userid and" + " name ilike @name and isleader = @isleader and address like @address and e.userid like @userid"; //string sql1 = "select e.*, acc.password from employees e, accounts acc where e.userid = acc.userid and" + // " name like '%T%' and isleader = true and address like '%%' and e.userid like '%%'"; //string sql1 = "select e.*, acc.password from employees e, accounts acc where e.userid = acc.userid and" + // " name like '%" +e.Name+"%' and isleader =" + e.Isleader + " and address like '%" + e.Address+ "%' and e.userid like '%" + e.Userid+ "%'"; if (e.flag == 1) { sql1 = sql1.Replace(" and isleader = @isleader ", " "); } NpgsqlConnection pgcon = new NpgsqlConnection(connectionString); pgcon.Open(); NpgsqlCommand pgcom = new NpgsqlCommand(sql1, pgcon); pgcom.CommandType = CommandType.Text; pgcom.Parameters.AddWithValue("name", "%" + e.Name + "%"); pgcom.Parameters.AddWithValue("isleader", e.Isleader); pgcom.Parameters.AddWithValue("address", "%" + e.Address + "%"); pgcom.Parameters.AddWithValue("userid", "%" + e.Userid + "%"); NpgsqlDataReader pgreader = pgcom.ExecuteReader(); while (pgreader.Read()) { EmployeesDTO result = new EmployeesDTO(); result.Id = pgreader.GetInt32(0); result.Name = pgreader.GetString(2); result.Userid = pgreader.GetString(6); result.Password = pgreader.GetString(8); result.Dateofbirth = pgreader.GetDateTime(3); result.Address = pgreader.GetString(5); result.Idcard = pgreader.GetInt32(4); result.Isleader = pgreader.GetBoolean(1); result.Salaryid = pgreader.GetInt32(7); listEmployee.Add(result); } return(listEmployee); } catch { } return(listEmployee); }
public EmployeesDTO Map(Employee entity) { EmployeesDTO dto = new EmployeesDTO(); dto.Fname = entity.Fname; dto.Lname = entity.Lname; dto.Id = entity.Id; return(dto); }
void AllowAccess(string username) { EmployeesDTO accountName = LoginDAO.Instance.GetEmployeesByUsername(username); formMain f = new formMain(accountName); this.Hide(); f.ShowDialog(); this.Show(); }
void ChangeAccount(EmployeesDTO account) { txbUsername.Text = CurrentAccount.TenDangNhap; txbName.Text = CurrentAccount.HoTen; txbPosition.Text = CurrentAccount.MaChucVu.ToString(); txbID.Text = CurrentAccount.ChungMinhNhanDan; txbAddress.Text = CurrentAccount.DiaChi; txbPhone.Text = CurrentAccount.SoDienThoai; }
private void grvNhanVien_MasterRowEmpty(object sender, DevExpress.XtraGrid.Views.Grid.MasterRowEmptyEventArgs e) { GridView grv = sender as GridView; EmployeesDTO infor = grv.GetRow(e.RowHandle) as EmployeesDTO; if (infor != null) { e.IsEmpty = !listTheoHangHoaBuy.Any(x => x.MaNV == infor.iMaNV); } }
public frmUpdateEmployees(EmployeesDTO employees) : this() { employeesDTO.iMaNV = employees.iMaNV; employeesDTO.iTenNV = employees.iTenNV; employeesDTO.iDiaChi = employees.iDiaChi; employeesDTO.iDienThoai = employees.iDienThoai; employeesDTO.iDiDong = employees.iDiDong; employeesDTO.iEmail = employees.iEmail; employeesDTO.iBoPhan = employees.iBoPhan; employeesDTO.iActive = employees.iActive; employeesDTO.iNguoiQL = employees.iNguoiQL; }
public List <EmployeesDTO> GetEmployeesList(int maChucVu) { List <EmployeesDTO> employeesList = new List <EmployeesDTO>(); string query = "select * from nhanvien where machucvu= @machucvu "; DataTable data = DataProvider.Instance.ExecuteQuery(query, new object[] { maChucVu }); foreach (DataRow item in data.Rows) { EmployeesDTO dataLine = new EmployeesDTO(item); employeesList.Add(dataLine); } return(employeesList); }
public List <EmployeesDTO> GetEmployeesListForComboBox() { List <EmployeesDTO> employeesList = new List <EmployeesDTO>(); string query = "select * from dbo.nhanvien"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { EmployeesDTO dataLine = new EmployeesDTO(item); employeesList.Add(dataLine); } return(employeesList); }
public Employee Map(EmployeesDTO dto) { Employee entity = new Employee() { Fname = dto.Fname, Lname = dto.Lname, Id = dto.Id }; return(entity); }
//one to dal public static Employees ToDAL(EmployeesDTO item) { return(new Employees() { Id = item.Id, FirstName = item.FirstName, LastName = item.LastName, address = item.address, IdEmployeeType = item.IdEmployeeType, Tz = item.Tz, Phone = item.Phone, }); }
void deleteNV() { EmployeesDTO transfer = new EmployeesDTO(txtManv.Text, txtTennv.Text, cbxGioitinh.SelectedItem.ToString(), dtpNgaySinh.Value.ToString(), txtSdt.Text, txtDiachi.Text, txtChucVu.Text); if (EmployeesDAO.Instance.deteleNV(transfer) >= 1) { loadnv(); MessageBox.Show("Đã xóa nhân viên"); } else { MessageBox.Show("Thất bại kiểm tra lại"); } }
void updateNV() { EmployeesDTO transfer = new EmployeesDTO(txtManv.Text, txtTennv.Text, cbxGioitinh.SelectedItem.ToString(), dtpNgaySinh.Value.Month.ToString() + "/" + dtpNgaySinh.Value.Day.ToString() + "/" + dtpNgaySinh.Value.Year.ToString(), txtSdt.Text, txtDiachi.Text, txtChucVu.Text); if (EmployeesDAO.Instance.updateNV(transfer) >= 1) { loadnv(); MessageBox.Show("Thành công"); } else { MessageBox.Show("Thất bại kiểm tra lại"); } }
public EmployeeVM(EmployeesDTO row) { EmployeeId = row.EmployeeId; EmployeeName = row.EmployeeName; EmployeeSurname = row.EmployeeSurname; EmployeeAge = row.EmployeeAge; EmployeeEmail = row.EmployeeEmail; EmployeePhone = row.EmployeePhone; EmployeeLogin = row.EmployeeLogin; EmployeePassword = row.EmployeePassword; EmployeePositionId = row.EmployeePositionId; EmployeePosition = row.EmployeePosition; EmployeeSalary = row.EmployeeSalary; ClientsCount = row.ClientsCount; }