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