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