private void btn_DisplayCassandraTable_Click(object sender, EventArgs e)
{
Stopwatch stopwatch = Stopwatch.StartNew();
BLEmployee ble = new BLEmployee();
RowSet employeeList = new RowSet();
employeeList = ble.DisplayEmpTable();
var list = new List <Employee>();
foreach (var row in employeeList.GetRows())
{
var employee = new Employee();
employee.City = row["city"] as string;
employee.EmpFirstName = row["empfirstname"] as string;
employee.EmpLastName = row["emplastname"] as string;
employee.PhoneNo = row["phoneno"] as string;
employee.Salary = row["salary"] as string;
list.Add(employee);
}
gridview.DataSource = list;
// DataGridViewColumn column = new DataGridViewTextBoxColumn();
stopwatch.Stop();
lbl_DisplayCassandraTable.Text = stopwatch.ElapsedMilliseconds.ToString();
}
protected override void InitBusinessObject()
{
base.InitBusinessObject();
oBL = new BLEmployee();
oBLUser = new BLUser();
oBLRole = new BLRole();
}
private void btn_Save_Employee_Click(object sender, EventArgs e)
{
BLEmployee blE = new BLEmployee();
if (SaveStatus == 1)
{
blE.CreateEmployee(txt_Employee_EmployeeName.Text,
txt_Employee_EmployeeTypeID.Text,
txt_Employee_PhoneNumber.Text,
txt_Employee_IdentityCard.Text,
txt_Employee_PassWord.Text);
}
else if (SaveStatus == 2)
{
blE.UpdateEmployee(Convert.ToInt32(txt_Employee_EmployeeID.Text),
txt_Employee_EmployeeName.Text,
txt_Employee_EmployeeTypeID.Text,
txt_Employee_PhoneNumber.Text,
txt_Employee_IdentityCard.Text,
txt_Employee_PassWord.Text);
}
SaveStatus = 0;
dgv_Employee.DataSource = blE.LoadEmployee();
dgv_Employee_CellClick(null, null);
btn_Update_Employee.Enabled = true;
btn_Create_Employee.Enabled = true;
btn_Save_Employee.Enabled = false;
}
private void btn_Delete_Employee_Click(object sender, EventArgs e)
{
BLEmployee blE = new BLEmployee();
blE.DeleteEmployee(Convert.ToInt32(txt_Employee_EmployeeID.Text));
dgv_Employee.DataSource = blE.LoadEmployee();
dgv_Employee_CellClick(null, null);
}
private void btn_InsertTableCassandra_Click(object sender, EventArgs e)
{
Stopwatch stopwatch = Stopwatch.StartNew();
BLEmployee ble = new BLEmployee();
ble.InsertEmpTable();
stopwatch.Stop();
lbl_InsertCassandraTable.Text = stopwatch.ElapsedMilliseconds.ToString();
MessageBox.Show("Angajatul a fost inserat in tabela Employee.emp");
}
private void btn_DeleteCassandraTable_Click(object sender, EventArgs e)
{
Stopwatch stopwatch = Stopwatch.StartNew();
BLEmployee ble = new BLEmployee();
ble.DeleteEmpTable();
stopwatch.Stop();
lbl_DeleteCassandraTable.Text = stopwatch.ElapsedMilliseconds.ToString();
MessageBox.Show("Tabela Employee.emp a fost stearsa");
}
private void btn_UpdateCassandraTable_Click(object sender, EventArgs e)
{
Stopwatch stopwatch = Stopwatch.StartNew();
BLEmployee ble = new BLEmployee();
ble.UpdateEmpTable();
stopwatch.Stop();
lbl_UpdateCassandraTable.Text = stopwatch.ElapsedMilliseconds.ToString();
MessageBox.Show("Detaliile angajatului au fost modificate cu succes");
}
private void HotelManagement_Load(object sender, EventArgs e)
{
BLEmployee bl = new BLEmployee();
var Temp = bl.FindEmployee(Employee).ElementAt(0);
lbl_UserName.Text = Temp.EmployeeName;
lbl_Permision.Text = "Admin";
if (Temp.EmployeeTypeID != 1)
{
btn_Manage.Enabled = false;
btn_Analysis.Enabled = false;
lbl_Permision.Text = "Receptionist";
}
panel_Manage.Width = 0;
LoadData();
}
private void btn_Employee_Click(object sender, EventArgs e)
{
TabControl_Main.TabPages.Clear();
TabControl_Main.TabPages.Add(TabPage_Employee);
dgv_Employee.AutoResizeColumns();
BLEmployee dbE = new BLEmployee();
var data = dbE.LoadEmployee();
if (data != null)
{
dgv_Employee.DataSource = data;
}
else
{
dgv_Employee.DataSource = null;
}
dgv_Employee_CellClick(null, null);
txt_Employee_EmployeeID.Enabled = false;
}
public object GetOrders()
{
ServiceResult result = new ServiceResult();
List <Employee> items;
try
{
items = new BLEmployee().GetEmployees();
result.Success = true;
result.Data = items;
}
catch (Exception ex)
{
CommonFunction.WriteLog(ex, SerializeUtil.Serialize(""), Request.RequestUri.ToString());
result.Success = false;
result.ErrorCode = ex.Message;
}
return(result);
}
public EmployeeController()
{
bl = new BLEmployee();
}
static void Main(string[] args)
{
BLEmployee employee = new BLEmployee();
BLProject project = new BLProject();
Model.Project p1 = new Model.Project()
{
Name = "sfdsd"
};
Model.Project p2 = new Model.Project()
{
Name = "tyuhg"
};
Model.Employee e1 = new Model.Employee()
{
Name = "Tdfsdf", Age = 39, Status = Model.EnumStatus.Employee, Position = Model.EnumPosition.Developer, Salary = 5675
};
e1.Project.Add(p2);
e1.Project.Add(p1);
p1.Employees.Add(e1);
//employee.CreateEmployee(e1);
//project.CreateProject(p1);
//project.CreateProject(p2);
//employee.Commit();
Console.WriteLine("\n GetAllEmployees \n");
foreach (var employees in employee.GetAllEmployees())
{
foreach (var i in employees.Project)
{
Console.Write("{0} ", i.Name);
}
Console.WriteLine("связанные проекты c Employee: {0} {1}", employees.Id, employees.Name);
}
Console.WriteLine("\n GetByIdEmployee \n");
var employeeById = employee.GetByIdEmployee(19);
Console.WriteLine("GetByIdEmployee Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", employeeById.Id, employeeById.Name, employeeById.Age, employeeById.Salary, employeeById.Status, employeeById.Position);
foreach (var i in employeeById.Project)
{
Console.WriteLine("Project: {0} {1}", i.Id, i.Name);
}
Console.WriteLine("\n GetAllProjects \n");
foreach (var projects in project.GetAllProjects())
{
Console.WriteLine("Project: {0} {1}", projects.Id, projects.Name);
}
Console.WriteLine("\n GetByIdProject \n");
var projectById = project.GetByIdProject(27);
Console.WriteLine("GetByIdProject Id: {0}, Name: {1}", projectById.Id, projectById.Name);
foreach (var i in projectById.Employees)
{
Console.WriteLine("Employee Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", i.Id, i.Name, i.Age, i.Salary, i.Status, i.Position);
}
Console.WriteLine("\n End EntityRepository. \n");
//ADOBLEmployee adoEmployee = new ADOBLEmployee();
//ADOBLProject adoProject = new ADOBLProject();
//Console.WriteLine("\n GetAllEmployees \n");
//foreach (var employees in adoEmployee.GetAllEmployees())
//{
// Console.WriteLine("Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", employees.Id, employees.Name, employees.Age, employees.Salary, employees.Status, employees.Position);
// foreach (var projects in employees.Project)
// {
// Console.WriteLine("ProjectId: {0} ProjectName: {1}", projects.Id, projects.Name);
// }
//}
//Console.WriteLine("\n GetByIdEmployee \n");
//var employeeById = adoEmployee.GetByIdEmployee(19);
//Console.WriteLine("GetByIdEmployee Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", employeeById.Id, employeeById.Name, employeeById.Age, employeeById.Salary, employeeById.Status, employeeById.Position);
//foreach (var i in employeeById.Project)
//{
// Console.WriteLine("Project 19: {0} {1}", i.Id, i.Name);
//}
//Console.WriteLine("\n GetAllProjects \n");
//foreach (var project in adoProject.GetAllProjects())
//{
// Console.WriteLine("Project: {0} {1}", project.Id, project.Name);
// foreach (var employees in project.Employees)
// {
// Console.WriteLine("Employees Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", employees.Id, employees.Name, employees.Age, employees.Salary, employees.Status, employees.Position);
// }
//}
//Console.WriteLine("\n GetByIdProject \n");
//var projectById = adoProject.GetByIdProject(27);
//Console.WriteLine("GetByIdProject Id: {0}, Name: {1}", projectById.Id, projectById.Name);
//foreach (var i in projectById.Employees)
//{
// Console.WriteLine("Employee Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", i.Id, i.Name, i.Age, i.Salary, i.Status, i.Position);
//}
//Console.WriteLine("\n End ADORepository.");
Console.ReadKey();
}
