private void btnImportEmployee_Click(object sender, EventArgs e) { string txt = ""; try { StreamReader sr = new StreamReader(txbEmployeeListFile.Text); txt = sr.ReadToEnd(); sr.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } string[] empList = txt.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries); foreach (string empstr in empList) { string[] empinfo = empstr.Split(','); MyEmployee emp = new MyEmployee() { EmployeeNumber = empinfo[0], Name = empinfo[1], Dept = empinfo[2] }; string shortpy = ""; emp.Pinyin = GetPinyin(emp.Name, out shortpy); emp.ShortPinyin = shortpy; AnnualPartySqlHelper.Instance.InitEmployee(emp); } MessageBox.Show("成功导入员工" + empList.Length + "个"); }
public MyEmployee AddEmployee(MyEmployee employee) { employee.Id = Guid.NewGuid(); _employeeContext.Employees.Add(employee); _employeeContext.SaveChanges(); return(employee); }
public void ExecuteRow_DataRowMapTo_Test() { using (var cmd = new DatabaseCommand(_connection)) { cmd.Log = Console.WriteLine; cmd.CommandText = @"SELECT EMP.EMPNO, EMP.ENAME, DEPT.DNAME FROM EMP INNER JOIN DEPT ON DEPT.DEPTNO = EMP.DEPTNO WHERE EMPNO = 7369"; var smith = cmd.ExecuteRow(row => { MyEmployee emp = row.MapTo <MyEmployee>(); emp.Department = row.MapTo <MyDepartment>(); return(emp); }); Assert.AreEqual(7369, smith.EmpNo); Assert.AreEqual("SMITH", smith.EName); Assert.AreEqual(null, smith.Salary); Assert.AreEqual(null, smith.SAL); Assert.AreEqual(0, smith.Department.DeptNo); Assert.AreEqual("RESEARCH", smith.Department.DName); } }
public MyEmployee UpdateEmployee(MyEmployee employee) { var existingEmployee = GetEmployee(employee.Id); existingEmployee.Name = employee.Name; return(existingEmployee); }
private void del_btn_Click(object sender, RoutedEventArgs e) { MyEmployee selectedEmpRow = dataGrid1.SelectedItem as MyEmployee; if (dataGrid1.SelectedItem != null) { //// Получение id редактируемого объекта string selectedId = selectedEmpRow.EmployeeId; try { client?.DeleteEmployee(selectedId); } catch (Exception ex) { MessageBox.Show(ex.Message); } RefreshOne(); } else { MessageBox.Show("You are didn't select employee..."); } }
public void UpdateEmployee() { MainImplementation service = new MainImplementation(); MyEmployee newtbl = new MyEmployee() { Id = 18, Name = "Marios", Salary = 7777, Birthday = new DateTime(1998, 04, 30, 13, 14, 19), Job = "HR" }; int result = service.UpdateEmployee(newtbl); //Xunit.Assert.True(result == newtbl.Id); //to kainoyrio tbl tha to kanw getemployeei by id //MyTasktbl getbyidtbl = new MyTasktbl(); //MyTasktbl employee = service.GetEmployeeByID(1); //Xunit.Assert.True(employee.Exists(x => x.Id == 2)); //Xunit.Assert.True(employee.Exists(x => x.Name.Equals("Panos"))); //Xunit.Assert.True(employee.Exists(x => x.Salary == 7777)); //Xunit.Assert.True(employee.Exists(x => x.Birthday ==new DateTime(1998, 04, 30, 13, 14, 19))); //Xunit.Assert.True(employee.Exists(x => x.Job.Equals("HR"))); }
public void InsertWithSubmit() { var mappingSource = new FluentMappingSource(delegate { var mapping = new DataContextMapping <DataContext>(); mapping.Provider = new ProviderAttribute(typeof(AccessDbProvider)); mapping.Map <MyEmployee>() .Table("Employees") .Column(o => (int)o["EmployeeID"], o => o.PrimaryKey().AutoSyncOnInsert().DbGenerated()) .Column(o => (string)o["FirstName"]) .Column(o => (string)o["LastName"]); return(mapping); }); var db = new DataContext("C:/Northwind.mdb", mappingSource) { Log = Console.Out }; var item = new MyEmployee(); item["FirstName"] = "CCC"; item["LastName"] = "DDD"; var table = db.GetTable <MyEmployee>(); table.InsertOnSubmit(item); db.SubmitChanges(); }
protected void btnSave_Click(object sender, EventArgs e) { try { lblInfoText.Text = string.Empty; int x; DateTime z; if (!DateTime.TryParse(tbxBirthDate.Text, out z)) { lblBirthDateError.Text = "Birthdate is not in a correct format, please try again (yyyy-mm-dd)"; return; } if (!int.TryParse(tbxReportsTo.Text, out x)) { lblNotesError.Text = "Reports To is not in a correct format, please try again (digits)"; return; } if (!DateTime.TryParse(tbxHireDate.Text, out z)) { lblHireDateError.Text = "Hiredate is not in a correct format, please try again (yyyy-mm-dd)"; return; } using (_host) { var employee = new MyEmployee() { EmployeeId = int.TryParse(tbxGetEmpId.Text, out x) ? int.Parse(tbxGetEmpId.Text) : x, FirstName = tbxFirstName.Text, LastName = tbxLastName.Text, TitleOfCourtesy = tbxTitleOfCourtesy.Text, Extension = tbxExtension.Text, BirthDate = DateTime.Parse(tbxBirthDate.Text), Title = tbxTitle.Text, Address = tbxAddress.Text, HomePhone = tbxHomePhone.Text, PostalCode = tbxPostalCode.Text, Region = tbxRegion.Text, Notes = tbxNotes.Text, ReportsTo = int.Parse(tbxReportsTo.Text), Country = tbxCountry.Text, City = tbxCity.Text, HireDate = DateTime.Parse(tbxHireDate.Text) }; lblInfoText.Text = _host.UpdateEmployeeInfo(employee); } } catch (FaultException exc) { lblInfoText.Text = exc.Message; } catch (Exception) { lblInfoText.Text = "Something went wrong while trying to save the employee. Try again later."; } }
public int Edit(EditEmployeeViewModel model) { var employee = new MyEmployee(); employee.Name = model.Name; employee.LastName = model.LastName; employee.Departament = model.Departament; return(_employeeRepository.Update(employee)); }
public void GetEmployeeByID() { MainImplementation service = new MainImplementation(); MyEmployee employee = service.GetEmployeeByID(1); Xunit.Assert.NotNull(employee); Xunit.Assert.True(employee.Id == 1); //Xunit.Assert.True(employee.Count == 1); //Xunit.Assert.True(employee.Exists(x => x.Id == 1)); }
public int Add(CreateEmployeeViewModel model) { var employee = new MyEmployee(); employee.Name = model.Name; employee.LastName = model.LastName; employee.Departament = model.Departament; return(_employeeRepository.Insert(employee)); }
public void ShowPhoto(List <int> list) { for (int i = 0; i < list.Count; i++) { MyEmployee emp = empList[list[i]]; pics[i].Key = emp.EmployeeNumber; pics[i].Image = emp.Photo; pics[i].Text = emp.Dept + " " + emp.Name; } }
public void CreateOrUpdate(MyEmployee tasktbl) { if (GetEmployeeByID(tasktbl.Id) == null) { CreateEmployee(tasktbl); } else { UpdateEmployee(tasktbl); } }
public ViewResult AboutEmployee() { MyEmployee emp = employeeRepository.GetEmployee(2); //ViewBag.projectName = "BookHive"; EmployeeProjectView ep = new EmployeeProjectView(); ep.employee = emp; ep.projectName = "Book Hive"; return(View(ep)); }
public void DeleteEmployee() { MainImplementation service = new MainImplementation(); service.DeleteEmployee(17); MyEmployee employee = service.GetEmployeeByID(17); Xunit.Assert.Null(employee); //Xunit.Assert.True(employee.Count == 0); }
public int UpdateEmployee(MyEmployee tasktbl) { using (IDbConnection db = new SqlConnection(GetConnectionString())) { //tasktbl.Id = employeeid; string updatequery = @"UPDATE MyTasktbl SET Name=@Name,Salary=@Salary,Birthday=@Birthday,Job=@Job WHERE Id=@Id "; //db.Execute(updatequery, new { tasktbl.Id, tasktbl.Name, tasktbl.Salary, tasktbl.Birthday, tasktbl.Job }); int id = db.QuerySingleOrDefault <int>(updatequery, new { tasktbl.Id, tasktbl.Name, tasktbl.Salary, tasktbl.Birthday, tasktbl.Job }); return(id); } }
public IActionResult EditEmployee(Guid Id, MyEmployee employee) { var employeeExisted = _employeeData.GetEmployee(Id); if (employeeExisted != null) { employee.Id = employeeExisted.Id; _employeeData.UpdateEmployee(employee); } return(Ok(employee)); }
public MyEmployee UpdateEmployee(MyEmployee employee) { var employeeExists = _employeeContext.Employees.Find(employee.Id); if (employeeExists != null) { employeeExists.Name = employee.Name; _employeeContext.Employees.Update(employeeExists); _employeeContext.SaveChanges(); } return(employee); }
public int CreateEmployee(MyEmployee tasktbl) { using (IDbConnection db = new SqlConnection(GetConnectionString())) { //den xreiazetai to id? string insertquery = @"INSERT INTO MyTasktbl (Name,Salary,Birthday,Job) VALUES (@Name,@Salary,@Birthday,@Job) "; //db.Execute(insertquery,new { tasktbl.Name,tasktbl.Salary,tasktbl.Birthday,tasktbl.Job}); var parameters = new { tasktbl.Id, tasktbl.Name, tasktbl.Salary, tasktbl.Birthday, tasktbl.Job }; int id = db.QuerySingleOrDefault <int>(insertquery, parameters); return(id); } }
public void CreateOrUpdate() { MainImplementation service = new MainImplementation(); var tasktbl = new MyEmployee() { Id = 20, Name = "manos", Salary = 4444, Birthday = new DateTime(1998, 04, 30, 13, 14, 19), Job = "HRrrrrrr" }; service.CreateOrUpdate(tasktbl); }
public void CreateEmployee() { MainImplementation service = new MainImplementation(); MyEmployee newtbl = new MyEmployee() { Name = "nikos", Salary = 9999, Birthday = new DateTime(1998, 04, 30, 13, 14, 19), Job = "Hr" }; int result = service.CreateEmployee(newtbl); Xunit.Assert.Equal(result, newtbl.Id); }
/// <summary> /// 显示员工照片 /// </summary> /// <param name="list"></param> public void ShowPhoto(List <MyEmployee> list) { this.Controls.Clear(); InitPictureBox(list.Count); for (int i = 0; i < list.Count; i++) { MyEmployee emp = list[i]; var item = pics[i]; item.Key = emp.EmployeeNumber; item.Image = emp.Photo; item.Text = emp.Dept + " " + emp.Name; item.ShowBorder = emp.Checkin; ShowCheckinFlag(item); } //this.Refresh(); }
public IActionResult Search(int?id) { int ID = (int)((id == null) ? 1 : id); MyEmployee emp = employeeRepository.GetEmployee(ID); //if(emp!=null) //{ // return Content(emp.Id + "\n" + emp.Name + "\n" + emp.Email + "\n" + emp.Dept); //} //return Content("employee does not exist"); //return emp.Id+"\n"+emp.Name+"\n"+emp.Email+"\n"+emp.Dept; //************************************************************************************************** //this code is for """"viewData**** //ViewData["id"] = emp.Id; //ViewData["name"] = emp.Name; //ViewData["email"] = emp.Email; //ViewData["dept"] = emp.Dept; //********object is passing ******// //ViewData["Employee"]=emp; //****************************************************************************************************** //***********VIEWbag code**************************************************************************** //ViewBag.id = emp.Id; //ViewBag.name = emp.Name; //ViewBag.email = emp.Email; //ViewBag.dept = emp.Dept; //ViewBag.employee = emp; //return View(); return(View(emp)); }
private async void dataGrid1_MouseDoubleClick(object sender, MouseButtonEventArgs e) { try { MyEmployee selectedEmpRow = dataGrid1.SelectedItem as MyEmployee; if (!File.Exists(@"c:\Images\" + selectedEmpRow.EmployeeId + ".jpg")) { byte[] arr = await client.GetArrayAsync(@"c:\temper\Images2\" + selectedEmpRow.EmployeeId + ".jpg"); File.WriteAllBytes(@"c:\Images\" + selectedEmpRow.EmployeeId + ".jpg", arr); } EmployeeCardWindow employeeCardWindow = new EmployeeCardWindow(); employeeCardWindow.IDText = selectedEmpRow.EmployeeId; employeeCardWindow.Refresh(); employeeCardWindow.Show(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public IActionResult AddNewEmployee(MyEmployee employee) { _employeeData.AddEmployee(employee); return(Created(HttpContext.Request.Scheme + "://" + HttpContext.Request.Host + HttpContext.Request.Path + "/" + employee.Id, employee)); }
public void DeleteEmployee(MyEmployee employee) { employees.Remove(employee); }
public MyEmployee AddEmployee(MyEmployee employee) { employee.Id = Guid.NewGuid(); employees.Add(employee); return(employee); }
public EmployeeViewModel(MyEmployee employee) { Name = employee.Name; LastName = employee.LastName; Departament = employee.Departament; }
public void UpdateEmployee([FromUri] int id, [FromBody] MyEmployee employee) { MymainService.UpdateEmployee(employee); }
public void CreateOrUpdate([FromBody] MyEmployee employee) { MymainService.CreateOrUpdate(employee); }