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 EmployeeResponse Get(EmployeeRequest request) { if (!IsValid(request.LicenseKey)) { WebOperationContext.Current.OutgoingResponse.StatusCode = System.Net.HttpStatusCode.Forbidden; return(null); } Employee employee = employeeRepository.Get(request.EmployeeId); return(new EmployeeResponse(employee)); }
public EmployeeInfo GetEmployee(EmployeeRequest request) { Console.WriteLine("License Key = " + request.LicenseKey); EmployeeModel 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 FullTimeEmployeeModel { 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 { employee = new PartTimeEmployeeModel { 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 && employee.Id == _lastSavedEmployee.Id) { employee.ExtensionData = _lastSavedEmployee.ExtensionData; } return(new EmployeeInfo(employee)); }
public EmployeeInfo GetEmployee(EmployeeRequest request) { Console.WriteLine("License key = " + request.LicenseKey); var empFact = new EmployeeFactory(); var employee = empFact.GetFromDb(request.EmployeeId); var employeeInfo = EmployeeInfo.ConvertToEmployeeInfo(employee); return(employeeInfo); }
//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 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 EmployeeInfo GetEmployee(EmployeeRequest request) { return(new EmployeeInfo(EmployeeProvider.GetEmployee(request.EmployeeID))); }