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;
}
