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