public async Task <Employee> UpdateEmployees(Employee employee)
{
EmployeeDao empDao = new EmployeeDao();
var result = await empDao.UpdateEmployee(employee);
return(result);
}
public async Task <Employee> GetEmployeeById(Employee employee)
{
EmployeeDao empDao = new EmployeeDao();
var result = await empDao.GetEmployeeById(employee);
return(result);
}
public ActionResult Detail()
{
var session = (UserLogin)Session[CommonConstants.USER_SESSION];
var employee = new EmployeeDao().ViewDetail(session.UserID);
return(View(employee));
}
public ActionResult Edit(int id)
{
var employee = new EmployeeDao().ViewDetail(id);
SetViewBag();
return(View(employee));
}
private void OKevent(Window p)
{
EMPLOYEE em = new EMPLOYEE();
em.FIRST_NAME = EmployeeViewObj.first_name;
em.LAST_NAME = EmployeeViewObj.last_name;
em.TITLE = EmployeeViewObj.title;
em.START_DATE = EmployeeViewObj.start_date;
em.END_DATE = EmployeeViewObj.end_date;
em.ASSIGNED_BRANCH_ID = BranchDao.Instance().SelectbyName(EmployeeViewObj.branch).BRANCH_ID;
em.DEPT_ID = DepartmentDao.Instace().SelectbyName(EmployeeViewObj.department).DEPT_ID;
em.SUPERIOR_EMP_ID = null;
if (cv == "insert")
{
EmployeeDao.Instance().Insert(em);
evm.EmployeeViewLists = evm.UpdateListview();
}
else
{
em.EMP_ID = EmployeeViewObj.id;
EmployeeDao.Instance().Update(em);
evm.EmployeeViewLists = evm.UpdateListview();
}
p.Close();
}
public JsonResult CreateAccountInfor(Guid UserID, Guid EnterpriseID, string EmployeeName, int Position, string Sex, string BirthDay, string Email, string Mobile, string Code)
{
var employeeInfor = new Employee();
employeeInfor.EmployeeID = UserID;
employeeInfor.EnterpriseID = EnterpriseID;
employeeInfor.EmployeeName = EmployeeName;
employeeInfor.Position = Position;
employeeInfor.Sex = Sex;
employeeInfor.Email = Email;
employeeInfor.Mobile = Mobile;
string[] splitDate = BirthDay.Split('-');
employeeInfor.BirthDay = new DateTime(int.Parse(splitDate[0]), int.Parse(splitDate[1]), int.Parse(splitDate[2]));
var ent = new EnterpriseDao().FindById(EnterpriseID);
if (ent.Code == Code)
{
var checkInsertEmployee = new EmployeeDao().InsertEmployee(employeeInfor);
return(Json(new
{
status = checkInsertEmployee,
codeInput = true
}));
}
return(Json(new
{
codeInput = false
}));
}
private void dataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
IEmployeeDao ed = new EmployeeDao();
DataRowView mySelectedElement = (DataRowView)dataGrid.SelectedItem;
string str_id = mySelectedElement.Row[0].ToString();
int id;
if (int.TryParse(str_id, out id))
{
Employee employee = ed.getSingleEmployee(id);
textname.Text = employee.Name;
contact.Text = employee.ContactMethod;
identity.Text = employee.Identity;
salary.Text = employee.Salary.ToString();
address.Text = employee.Address;
account.Text = employee.Account;
photo.Source = employee.Photo;
}
else
{
MessageBox.Show("无法解析为数字。");
return;
}
}
catch (Exception exx)
{
return;
}
}
private void ShowEmployees()
{
var empDao = new EmployeeDao();
dgvEmployees.AutoGenerateColumns = false;
dgvEmployees.DataSource = empDao.GetAllEmployees();
}
public ActionResult EditAction(Employee employee_edit)
{
EmployeeDao dao = new EmployeeDao();
int k = dao.UpdateEmployee(employee_edit);
return(RedirectToAction("List"));
}
public ActionResult List(string a, string b)
{
EmployeeDao my = new EmployeeDao();
IQueryable <Employee> list = my.ListEmployee();
return(View("List", list));
}
public AccountVM()
{
List <PRODUCT> listp = ProductDao.Instance().getAll();
List <EMPLOYEE> liste = EmployeeDao.Instance().getAll();
foreach (PRODUCT p in listp)
{
ProductView pv = new ProductView(p);
listpro.Add(pv);
}
foreach (EMPLOYEE p in liste)
{
EmployeeView pv = new EmployeeView(p);
listem.Add(pv);
}
AccountViewLists = UpdateListview();
FindCommand = new RelayCommand <FrameworkElement>((p) => { return(p != null ? true : false); }, (p) => { Find(p); });
EditFormCommand = new RelayCommand <AccountView>((p) => true, (p) => { ShowEditForm(p); });
DeleteRowCommand = new RelayCommand <AccountView>((p) => true, (p) => { Remove(p); });
NewFormCommand = new RelayCommand <Window>((p) => true, (p) => { NewEditForm(); });
SelectedItemCommand = new RelayCommand <AccountView>((p) => { return(p != null ? true : false); }, (p) => { SelectedItem(p); });
NextButtonCommand = new RelayCommand <AccountView>((p) => true, (p) => { NextButton(p); });
PrevButtonCommand = new RelayCommand <AccountView>((p) => true, (p) => { PrevButton(p); });
FirstButtonCommand = new RelayCommand <AccountView>((p) => true, (p) => { FirstButton(p); });
LastButtonCommand = new RelayCommand <AccountView>((p) => true, (p) => { LastButton(p); });
}
public EmployeeDictionary()
{
List <EmployeeKeys> employeeKeys = new List <EmployeeKeys>()
{
new EmployeeKeys(1, "岡崎 誠", 1, "aaa", 1),
new EmployeeKeys(2, "永瀬 昌利", 2, "bbb", 0),
new EmployeeKeys(3, "池田 沙菜", 3, "ccc", 0),
new EmployeeKeys(4, "渡辺 敏男", 4, "ddd", 1),
new EmployeeKeys(5, "森田 利勝", 5, "eee", 0),
new EmployeeKeys(6, "末永 好男", 1, "fff", 1),
new EmployeeKeys(7, "尾上 千尋", 2, "ggg", 0),
new EmployeeKeys(8, "大槻 龍宏", 3, "hhh", 0),
new EmployeeKeys(9, "小俣 哲", 4, "iii", 0),
new EmployeeKeys(10, "石倉 菜那", 5, "ggg", 0),
};
List <EmployeeDto> employees = new EmployeeDao().GetAllEmployee();
this.EmployeeDic = new Dictionary <EmployeeKeys, EmployeeDto>();
for (int i = 0; i < employeeKeys.Count; i++)
{
EmployeeDic[employeeKeys[i]] = employees[i];
}
}
public ActionResult Login(string email, string password)
{
if (Membership.ValidateUser(email, password))
{
FormsAuthentication.SetAuthCookie(email, false);
if (email.Contains("@alkoshop.com"))
{
EmployeeDao employeeDao = new EmployeeDao();
DataAccess.Model.Employee employee = employeeDao.GetByEmailAndPassword(email, password);
Session["User"] = employee;
Session["UserRole"] = "Employee";
}
else
{
CustomerDao customerDao = new CustomerDao();
DataAccess.Model.Customer customer = customerDao.GetByEmailAndPassword(email, password);
Session["User"] = customer;
Session["UserRole"] = "Customer";
}
return(RedirectToAction("Index", "Home", new { area = Session["UserRole"] }));
}
TempData["login-error"] = "Login nebo heslo není správné";
return(RedirectToAction("Index", "Login"));
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (lsvEmployee.SelectedItems.Count > 0)
{
EmployeeDao emDao = new EmployeeDao();
Employee emp = emDao.GetEmployeeByID(Convert.ToInt32(lsvEmployee.SelectedItems[0].SubItems[0].Text));
emp.EmployeeName = txtName.Text;
emp.Address = txtAddress.Text;
emp.Position = txtPosition.Text;
emp.PhoneNumber = txtPhoneNumber.Text;
emp.Gender = (cboGender.SelectedIndex == 0);
try
{
emDao.UpdateEmployee(emp);
}
catch (Exception ex)
{
MessageBox.Show("Failed : " + ex.Message);
}
txtName.Text = "";
txtAddress.Text = "";
txtPhoneNumber.Text = "";
txtPosition.Text = "";
txtStartDate.Text = "";
LoadTable();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//ユーザー一覧で選択した従業員の情報を最初から表示したい
EUser EU = new EUser();
using (TranMng TM = new TranMng())
{
string UserId = Session["UserId"].ToString();
user.Text = UserId;
//選んだユーザーの情報をエンティティに保存
EmployeeDao SD = new EmployeeDao();
EU = SD.Select(UserId);
last_nm.Text = EU.last_nm;
first_nm.Text = EU.first_nm;
last_nm_kana.Text = EU.last_nm_kana;
first_nm_kana.Text = EU.first_nm_kana;
}
DropDownList1.SelectedIndex = EU.gender_cd;
ListItem li2 = DropDownList2.Items.FindByValue(EU.section_cd);
int section_idx = DropDownList2.Items.IndexOf(li2);
DropDownList2.SelectedIndex = section_idx;
}
}
public ActionResult Index(string name, string password)
{
LoginDao login_dao = new LoginDao();
if (login_dao.Login(name, password) == 1)
{
EmployeeDao employee_dao = new EmployeeDao();
UserLogin userlogin = new UserLogin();
userlogin.Type = 1;
userlogin.ID = employee_dao.GetIDByLogin(name);
userlogin.Login = name;
userlogin.Name = employee_dao.GetNameByID(userlogin.ID);
userlogin.GroupEmployeeID = employee_dao.GetGroupEmployeeIDByLogin(name);
Session["UserLogin"] = userlogin;
return(RedirectToAction("Blank", "Blank", new { Area = "Admin" }));
}
else if (login_dao.Login(name, password) == 2)
{
CustomerDao cus_dao = new CustomerDao();
UserLogin userlogin = new UserLogin();
userlogin.Type = 2;
userlogin.ID = cus_dao.GetIDByLogin(name);
userlogin.Login = name;
userlogin.Name = cus_dao.GetNameByID(userlogin.ID);
Session["UserLogin"] = userlogin;
return(RedirectToAction("HomePage", "HomePage"));
}
else
{
ModelState.AddModelError("loitaikhoan", "Tài khoản hoặc mật khẩu không chính xác");
}
return(View("Index"));
}
public JsonResult SaveCandidate(Guid userId)
{
var accID = int.Parse(User.Identity.Name);
var acc = new AccountDao().FindAccountById(accID);
var employee = new EmployeeDao().FindById(acc.UserId);
var enterpriseId = employee.EnterpriseID;
var savedCandidate = new SavedCandidate();
// Guid enterpriseId = new Guid("4c0bba20-27f2-4838-8cb9-ce3a80ce7784");
DateTime date = DateTime.Today;
savedCandidate.UserID = userId;
savedCandidate.EnterpriseID = enterpriseId;
savedCandidate.CreateDate = date.ToString("dd/MM/yyyy");
var checkInsertCandidate = new SavedCandidateDao().InsertCandidate(savedCandidate);
if (checkInsertCandidate == false)
{
return(Json(new
{
status = false
}));
}
return(Json(new
{
status = true
}));
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (formValidator.Validate())
{
int empId = 0;
int.TryParse(txtEmployeeId.Text, out empId);
var emp = new Employee
{
Id = empId,
Name = txtName.Text,
Role = (cmbRoles.SelectedItem as Role).Id,
Designation = (cmbDesignations.SelectedItem as Designation).Id,
AllowLogin = Convert.ToSByte(chkAllowLogin.Checked),
IsDeleted = Convert.ToSByte(chkIsDeleted.Checked),
LoginId = txtLoginId.Text,
Password = txtPassword.Text,
CreatedBy = 1,
CreatedOn = DateTime.Now,
ModifiedBy = 1,
ModifiedOn = DateTime.Now
};
var empDao = new EmployeeDao();
empDao.SaveEmployee(emp);
ShowEmployees();
}
}
public async Task <Employee> DeleteEmployeeByName(Employee employee)
{
EmployeeDao empDao = new EmployeeDao();
var result = await empDao.DeleteEmployeeByName(employee);
return(result);
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
var dao = new EmployeeDao();
var result = dao.Login(model.Email, Encryptor.MD5Hash(model.Password));
if (result == 1)
{
var employee = dao.GetByEmail(model.Email);
var employeeSession = new EmployeeLogin();
Session["empname"] = dao.GetByEmail(model.Email).EmployeeName;
employeeSession.EmployeeName = employee.EmployeeName;
employeeSession.Email = employee.Email;
Session.Add(CommonConstants.EMPLOYEE_SESSION, employeeSession);
Session["Account"] = employee.EmployeeName;
Session["Image"] = employee.Image;
return(RedirectToAction("Index", "Home"));
}
else if (result == 0)
{
ModelState.AddModelError("", "This account does not exsits");
}
else if (result == -1)
{
ModelState.AddModelError("", "This account was locked");
}
else if (result == -2)
{
ModelState.AddModelError("", "Incorect email or password");
}
}
return(View("Index"));
}
public ActionResult Edit(Employee employee)
{
if (ModelState.IsValid)
{
var dao = new EmployeeDao();
var rawEmployee = dao.ViewDetail(employee.EmployeeID);
if (!string.IsNullOrEmpty(employee.Password))
{
if (employee.Password != rawEmployee.Password)
{
var encryptMd5Password = Encryptor.MD5Hash(employee.Password);
employee.Password = encryptMd5Password;
}
}
var result = dao.Update(employee);
if (result)
{
return(RedirectToAction("Index", "Employee"));
}
else
{
ModelState.AddModelError("", "Modify employee successfully");
}
}
return(View("Index"));
}
public JsonResult checkStatusInterview(Guid userId, Guid offerId)
{
var interview = new InterviewDao().findInterview(userId, offerId);
if (interview != null)
{
var user = new UserDao().FindById(userId);
var employee = new EmployeeDao().FindById(interview.EmployeeID);
var offer = new OfferJobDao().findById(offerId);
return(Json(new
{
having = true,
User = user.UserName,
InterviewID = interview.InterviewID,
Offer = offer.OfferName,
Time = interview.Time,
Date = interview.Date,
Status = interview.Status,
Employee = employee.EmployeeName,
Address = interview.Address,
Note = interview.Note
}));;
}
return(Json(new
{
having = false
}));
}
/// <summary>
///
/// </summary>
private bool CheckPassword()
{
var password = txt_Password.Text.Trim();
if (password == "")
{
MsgBox.ShowInfo("旧密码不能为空");
return(false);
}
var dictpass = new EmployeeDao().GetModel(Program.CurrentEmployee.EmployeeID);
if (Salt.Encrypt(password).Equals(dictpass.Password))
{
if (txt_NewPassword.Text.Trim() == "")
{
MsgBox.ShowInfo("新密码不能为空");
return(false);
}
else if (txt_NewPassword.Text.Trim() != txt_NewPassword2.Text.Trim())
{
MsgBox.ShowInfo("两次输入的密码不相同，请重新输入");
return(false);
}
return(true);
}
else
{
MsgBox.ShowInfo("原密码不正确");
return(false);
}
return(true);
}
/// <summary>
/// 店员列表
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public PageResult Do_EmployeeLogon(BaseApi baseApi)
{
PageResult pageResult = new PageResult();
EmployeeLogonParam employeeLogonParam = JsonConvert.DeserializeObject <EmployeeLogonParam>(baseApi.param.ToString());
if (employeeLogonParam.current == 0)
{
employeeLogonParam.current = 1;
}
if (employeeLogonParam.pageSize == 0)
{
employeeLogonParam.pageSize = 9;
}
pageResult.pagination = new Page(employeeLogonParam.current, employeeLogonParam.pageSize);
string shopId = Util.GetUserShopId(baseApi.token);
string power = Util.GetUserPower(baseApi.token);
if (power != "1")
{
throw new ApiException(CodeMessage.InsufficientAuthority, "InsufficientAuthority");
}
EmployeeDao employeeDao = new EmployeeDao();
pageResult = employeeDao.EmployeeLogon(shopId, employeeLogonParam);
return(pageResult);
}
private void OperatorReport_Load(object sender, EventArgs e)
{
var empDao = new EmployeeDao();
cmbUsername.DataSource = empDao.GetLoginIds();
cmbUsername.DisplayMember = "LoginId";
cmbUsername.ValueMember = "Id";
}
// GET: Admin/Employee
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
var dao = new EmployeeDao();
var model = dao.ListAllPaging(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public int GetRowCount(string filter)
{
using (PersistentManager persistentManager = new PersistentManager())
{
EmployeeDao dao = new EmployeeDao();
return(dao.GetRowCount(strTableView, filter));
}
}
public string GetNewEmployeeCode()
{
using (PersistentManager persistentManager = new PersistentManager())
{
EmployeeDao dao = new EmployeeDao();
return(dao.GetNewEmployeeCode());
}
}
public DataSet QueryEmployee(int pageIndex, int pageSize, string filter, string OrderByFields)
{
using (PersistentManager persistentManager = new PersistentManager())
{
EmployeeDao dao = new EmployeeDao();
return(dao.Query(strTableView, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableView));
}
}
/// <summary>
/// 新增店员检查用户名
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public AddEmployeeParam Do_CheckOldStoreCode(BaseApi baseApi)
{
string shopId = Util.GetUserShopId(baseApi.token);
EmployeeDao employeeDao = new EmployeeDao();
AddEmployeeParam msg = employeeDao.CheckOldStoreId(shopId);
return(msg);
}