public EmployeeInfo getEmployee(EmployeeRequest employeeRequest) { Employee employee = null; EmployeeTable employeeTable = employees.Where(x => x.id == employeeRequest.EmployeeId).SingleOrDefault(); if ((EmployeeType)employeeTable.Type == EmployeeType.FullTimeEmployee) { employee = new FullTimeEmployee { id = Convert.ToInt32(employeeTable.id), name = employeeTable.name.ToString(), gender = employeeTable.gender.ToString(), dateOfBirth = Convert.ToDateTime(employeeTable.dateOfBirth), Type = EmployeeType.FullTimeEmployee, annualSalary = Convert.ToInt32(employeeTable.annualSalary) }; } else { employee = new PartTimeEmployee { id = Convert.ToInt32(employeeTable.id), name = employeeTable.name.ToString(), gender = employeeTable.gender.ToString(), dateOfBirth = Convert.ToDateTime(employeeTable.dateOfBirth), Type = EmployeeType.PartTimeEmployee, hourlyPay = Convert.ToInt32(employeeTable.hourlyPay), hoursWorked = Convert.ToInt32(employeeTable.hoursWorked) }; } return(new EmployeeInfo(employee)); }
public Employee GetEmployee(int id) { Employee emp = default(Employee); string cs = ConfigurationManager.ConnectionStrings["subhasishConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Id"; parameterId.Value = id; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTimeEmployee) { emp = new FullTimeEmployee() { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), //Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.FullTimeEmployee, AnnualSalary = Convert.ToInt32(reader["AnnualSalary"]), City = reader["City"].ToString(), }; } else { emp = new PartTimeEmployee() { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), //Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]), City = reader["City"].ToString(), }; } } } if (_lastSavedEmployee != null && _lastSavedEmployee.Id == id) { emp.ExtensionData = _lastSavedEmployee.ExtensionData; } return(emp); }
public EmployeeInfo GetEmployee(EmployeeRequest request) { if (request.LicenseKey != "SuperSecret123") { throw new WebFaultException <string>( "Wrong license key", HttpStatusCode.Forbidden); } else { Employee employee = null; string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Id"; parameterId.Value = request.EmployeeId; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTimeEmployee) { employee = new FullTimeEmployee { Type = EmployeeType.FullTimeEmployee, MonthlySalary = Convert.ToInt32(reader["MonthlySalary"]) }; } else { employee = new PartTimeEmployee { Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]) }; } employee.Id = Convert.ToInt32(reader["Id"]); employee.Name = reader["Name"].ToString(); employee.Gender = reader["Gender"].ToString(); employee.DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]); } } return(new EmployeeInfo(employee)); } }
public EmployeeInfo GetEmployee(EmployeeRequest request) { Console.WriteLine("License Key:" + request.LicenseKey); Employee emp = default(Employee); string cs = ConfigurationManager.ConnectionStrings["subhasishConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Id"; parameterId.Value = request.EmployeeId; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTimeEmployee) { emp = new FullTimeEmployee() { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.FullTimeEmployee, AnnualSalary = Convert.ToInt32(reader["AnnualSalary"]) }; } else { emp = new PartTimeEmployee() { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]) }; } } } return(new EmployeeInfo(emp)); }
public Employee GetEmployee(int Id) { Employee employee = null; string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Id"; parameterId.Value = Id; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTimeEmployee) { employee = new FullTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.FullTimeEmployee, AnnualSalary = Convert.ToInt32(reader["AnnualSalary"]), //City = Convert.ToString(reader["City"]) // commented for implementing Extensible Data Object }; } else { employee = new PartTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]), //City = Convert.ToString(reader["City"]) }; } } } if (lastEmployee?.Id == employee.Id) { employee.ExtensionData = lastEmployee.ExtensionData; } return(employee); }
public Employee GetEmployee(int Id) { Employee employee = null; string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@EmployeeId"; parameterId.Value = Id; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while(reader.Read()) { if ((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTimeEmployee) { employee = new FullTimeEmployee { EmployeeId = Convert.ToInt32(reader["EmployeeId"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), dob = Convert.ToDateTime(reader["dob"]), City = reader["City"].ToString(), DepartmentId = Convert.ToInt32(reader["DepartmentId"]), Type = EmployeeType.FullTimeEmployee, AnnualSalary = Convert.ToInt32(reader["AnnualSalary"]) }; } else { employee = new PartTimeEmployee { EmployeeId = Convert.ToInt32(reader["EmployeeId"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), dob = Convert.ToDateTime(reader["dob"]), City = reader["City"].ToString(), DepartmentId = Convert.ToInt32(reader["DepartmentId"]), Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]) }; } } } return employee; }
//public Employee GetEmployee(int Id = 0) public EmployeeInfo GetEmployee(EmployeeRequest request) { Employee employee = null;//new Employee(); string cs = ConfigurationManager.ConnectionStrings["DDBC"].ConnectionString; using (SqlConnection conn = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", conn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Id"; parameterId.SqlValue = request.EmployeeId;//Id; cmd.Parameters.Add(parameterId); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while(reader.Read()) { if((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTimeEmployee) { employee = new FullTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.FullTimeEmployee, AnnualSalary = Convert.ToInt32(reader["AnnualSalary"]) }; } else { employee = new PartTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]) }; } } } //return employee; return new EmployeeInfo(employee); }
public EmployeeInfo GetEmployee(EmplpoyeeRequest empRequest) { //for(int i=0;i<=100;i++){ // Thread.Sleep(50); // Callback.progress(i); //} Employee employee = null; string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter idParm = new SqlParameter("@Id", empRequest.EmployeeId); cmd.Parameters.Add(idParm); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTimeEmployee) { employee = new FullTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = (reader["Name"]).ToString(), Gender = (reader["Gender"]).ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.FullTimeEmployee, AnnualSalary = Convert.ToInt32(reader["AnnualSalary"]) }; } else { employee = new PartTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = (reader["Name"]).ToString(), Gender = (reader["Gender"]).ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]) }; } } } return(new EmployeeInfo(employee)); }
public Employee GetEmployee(int id) { Employee employee = null; string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { // spGetEmployee is the name of the stored procedure // so we have to tell to the command Object SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Id"; parameterId.Value = id; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((EmployeeType)(reader["EmployeeType"]) == EmployeeType.FullTimeEmployee) { employee = new FullTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.FullTimeEmployee, AnnualSallary = Convert.ToInt32(reader["AnnualSalary"]) }; } else { employee = new PartTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]) }; } } } return(employee); }
public Employee GetEmployee(int id) { Employee employee = null;// we dont need any more create here new employee, because in while loop we create instance of derived class type string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Id"; parameterId.Value = id; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTimeEmployee) { employee = new FullTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.FullTimeEmployee, AnnualSalary = Convert.ToInt32(reader["AnnualSalary"]) }; } else { employee = new PartTimeEmployee { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]), }; } } } return(employee); }
public EmployeeInfo GetEmployeeMessageContract(EmployeeRequest employeeRequest) { Console.WriteLine($"License Key: {employeeRequest.LicenseKey}"); Employee employee = null; string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Id"; parameterId.Value = employeeRequest.EmployeeID; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTime) { employee = new FullTimeEmployee { ID = Convert.ToInt32(reader["ID"]), Name = reader["Name"].ToString(), //Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.FullTime, AnnualSalary = Convert.ToInt32(reader["AnnualSalary"]) }; } else { employee = new PartTimeEmployee { ID = Convert.ToInt32(reader["ID"]), Name = reader["Name"].ToString(), //Gender = reader["Gender"].ToString(), DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]), Type = EmployeeType.PartTime, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]), }; } } } return(new EmployeeInfo(employee)); }
public Employee GetEmployee(int id) { Employee employee = null; string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter(); parameterId.ParameterName = "@Id"; parameterId.Value = id; cmd.Parameters.Add(parameterId); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if ((EmployeeType)reader["EmployeeType"] == EmployeeType.FullTimeEmployee) { employee = new FullTimeEmployee { Type = EmployeeType.FullTimeEmployee, MonthlySalary = Convert.ToInt32(reader["MonthlySalary"]) }; } else { employee = new PartTimeEmployee { Type = EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(reader["HourlyPay"]), HoursWorked = Convert.ToInt32(reader["HoursWorked"]) }; } employee.Id = Convert.ToInt32(reader["Id"]); employee.Name = reader["Name"].ToString(); employee.Gender = reader["Gender"].ToString(); employee.DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]); } } return(employee); }
protected void btnSave_Click(object sender, EventArgs e) { EmployeeService.EmployeeServiceClient client = new EmployeeService.EmployeeServiceClient(); EmployeeService.Employee employee = null; string message = string.Empty; if (((EmployeeService.EmployeeType)Convert.ToInt32(ddlEmployeeType.SelectedValue)) == EmployeeService.EmployeeType.FullTimeEmployee) { employee = new EmployeeService.FullTimeEmployee { ID = Convert.ToInt32(txtID.Text), Name = txtName.Text, Gender = txtGender.Text, DateOfBirth = Convert.ToDateTime(txtDateOfBirth.Text), Type = EmployeeService.EmployeeType.FullTimeEmployee, AnnualSalary = Convert.ToInt32(txtAnnualSalary.Text), }; client.SaveEmployee(employee); lblMessage.Text = "Employee saved"; } else if (((EmployeeService.EmployeeType)Convert.ToInt32(ddlEmployeeType.SelectedValue)) == EmployeeService.EmployeeType.PartTimeEmployee) { employee = new EmployeeService.PartTimeEmployee { ID = Convert.ToInt32(txtID.Text), Name = txtName.Text, Gender = txtGender.Text, DateOfBirth = Convert.ToDateTime(txtDateOfBirth.Text), Type = EmployeeService.EmployeeType.PartTimeEmployee, HourlyPay = Convert.ToInt32(txtHourlyPay.Text), HoursWorked = Convert.ToInt32(txtHoursWorked.Text), }; client.SaveEmployee(employee); lblMessage.Text = "Employee saved"; } else { lblMessage.Text = "Please select Employee Type"; } }
protected override void Seed(EmployeeContext context) { FullTimeEmployee employee = new FullTimeEmployee(); employee.Name = "Вася"; employee.DateOfBirth = new DateTime(1986, 04, 21); employee.Gender = Gender.Male; employee.MonthSallary = 4000; employee.EmployeeType = EmployeeType.FullTimeEmployee; PartTimeEmployee employee2 = new PartTimeEmployee(); employee2.Name = "Соня"; employee2.DateOfBirth = new DateTime(1989, 02, 10); employee2.Gender = Gender.Female; employee2.HourlyPay = 250; employee2.HoursWorked = 16; employee2.EmployeeType = EmployeeType.PartTimeEmployee; context.Employees.Add(employee); context.Employees.Add(employee2); context.SaveChanges(); }
public bool EditEmployee(int id, Employee newEmployeeData) { bool result = false; try { using (EmployeeContext context = new EmployeeContext()) { Employee employee = context.Employees.FirstOrDefault(e => e.Id == id); if (employee != null) { employee.Name = newEmployeeData.Name; employee.DateOfBirth = newEmployeeData.DateOfBirth; employee.Gender = newEmployeeData.Gender; employee.EmployeeType = newEmployeeData.EmployeeType; if (employee is FullTimeEmployee && newEmployeeData is FullTimeEmployee) { (employee as FullTimeEmployee).MonthSallary = (newEmployeeData as FullTimeEmployee).MonthSallary; } else if (employee is PartTimeEmployee && newEmployeeData is PartTimeEmployee) { (employee as PartTimeEmployee).HourlyPay = (newEmployeeData as PartTimeEmployee).HourlyPay; (employee as PartTimeEmployee).HoursWorked = (newEmployeeData as PartTimeEmployee).HoursWorked; } else { if (newEmployeeData is FullTimeEmployee) { FullTimeEmployee newEmployee = new FullTimeEmployee(); newEmployee.Id = employee.Id; newEmployee.Name = employee.Name; newEmployee.DateOfBirth = employee.DateOfBirth; newEmployee.Gender = employee.Gender; newEmployee.EmployeeType = EmployeeType.FullTimeEmployee; newEmployee.MonthSallary = (newEmployeeData as FullTimeEmployee).MonthSallary; context.Employees.Remove(employee); context.SaveChanges(); context.Employees.Add(newEmployee); } else if (newEmployeeData is PartTimeEmployee) { PartTimeEmployee newEmployee = new PartTimeEmployee(); newEmployee.Id = employee.Id; newEmployee.Name = employee.Name; newEmployee.DateOfBirth = employee.DateOfBirth; newEmployee.Gender = employee.Gender; newEmployee.EmployeeType = EmployeeType.PartTimeEmployee; newEmployee.HourlyPay = (newEmployeeData as PartTimeEmployee).HourlyPay; newEmployee.HoursWorked = (newEmployeeData as PartTimeEmployee).HoursWorked; context.Employees.Remove(employee); context.SaveChanges(); context.Employees.Add(newEmployee); } } context.SaveChanges(); result = true; } } } catch { result = false; } return(result); }