public PartialViewResult SaveEmployeeKnownType(EmployeeKnownType employee, FormCollection formCollection)
{
//EmployeeServiceClient client = new EmployeeServiceClient("BasicHttpBinding_IEmployeeService");
//EmployeeKnownType employeeKnownType = new EmployeeKnownType();
IEmployeeService client = new EmployeeServiceClient();
EmployeeInfo employeeKnownType = new EmployeeInfo();
bool result = false;
if ((int)employee.EmployeeType == 1)
{
//employeeKnownType = new FullTimeEmployee()
//{
// Id = employee.Id,
// Name = employee.Name,
// Gender = employee.Gender,
// DateOfBirth = employee.DateOfBirth,
// EmployeeType = employee.EmployeeType,
// AnnualSalary = Convert.ToInt32(formCollection["AnnualSalary"])
//};
employeeKnownType.EmployeeType = EmployeeType.FullTimeEmployee;
employeeKnownType.AnnualSalary = Convert.ToInt32(formCollection["AnnualSalary"]);
}
else if ((int)employee.EmployeeType == 2)
{
//employeeKnownType = new PartTimeEmployee()
//{
// Id = employee.Id,
// Name = employee.Name,
// Gender = employee.Gender,
// DateOfBirth = employee.DateOfBirth,
// EmployeeType = employee.EmployeeType,
// HourlyPay = Convert.ToInt32(formCollection["HourlyPay"]),
// HoursWorked = Convert.ToInt32(formCollection["HoursWorked"])
//};
employeeKnownType.EmployeeType = employee.EmployeeType;
employeeKnownType.HourlyPay = Convert.ToInt32(formCollection["HourlyPay"]);
employeeKnownType.HoursWorked = Convert.ToInt32(formCollection["HoursWorked"]);
}
employeeKnownType.Id = employee.Id;
employeeKnownType.Name = employee.Name;
employeeKnownType.Gender = employee.Gender;
employeeKnownType.DOB = employee.DateOfBirth;
employeeKnownType.EmployeeType = employee.EmployeeType;
try
{
client.SaveEmployeeKnownType(employeeKnownType);
result = true;
}
catch (Exception ex)
{
}
return(PartialView("SaveEmployee", result));
}
public void SaveEmployee(Employee employee, EmployeeKnownType e1 = null, PartTimeEmployee e2 = null, FullTimeEmployee e3 = null) // e1, e2, e3 - Parameters for compatibility reason with previous version of client app.
{
string cs = ConfigurationManager.ConnectionStrings["SampleWebService"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spSaveEmployee", con);
cmd.CommandType = CommandType.StoredProcedure;
//SqlParameter parameterId = new SqlParameter
//{
// ParameterName = "@Id",
// Value = employee.Id
//};
//cmd.Parameters.Add(parameterId);
SqlParameter parameterName = new SqlParameter
{
ParameterName = "@Name",
Value = employee.Name
};
cmd.Parameters.Add(parameterName);
SqlParameter parameterGender = new SqlParameter
{
ParameterName = "@Gender",
Value = employee.Gender
};
cmd.Parameters.Add(parameterGender);
SqlParameter parameterDateOfBirth = new SqlParameter
{
ParameterName = "@DateOfBirth",
Value = employee.DateOfBirth
};
cmd.Parameters.Add(parameterDateOfBirth);
con.Open();
cmd.ExecuteNonQuery();
}
}
public PartialViewResult GetEmployeeKnownType(int id)
{
//EmployeeServiceClient client = new EmployeeServiceClient("BasicHttpBinding_IEmployeeService");
//EmployeeKnownType employee = client.GetEmployeeKnownType(id);
IEmployeeService client = new EmployeeServiceClient();
EmployeeRequest request = new EmployeeRequest(LicenseKey: "ASCX4534DXZC", EmployeeId: id);
EmployeeInfo employeeInfo = client.GetEmployeeKnownType(request);
EmployeeKnownType employee = null;
if (employeeInfo.EmployeeType == EmployeeType.Null)
{
return(PartialView("GetEmployee", null));
}
if (employeeInfo.EmployeeType == EmployeeType.FullTimeEmployee)
{
employee = new FullTimeEmployee()
{
AnnualSalary = employeeInfo.AnnualSalary
};
}
else if (employeeInfo.EmployeeType == EmployeeType.PartTimeEmployee)
{
employee = new PartTimeEmployee()
{
HourlyPay = employeeInfo.HourlyPay,
HoursWorked = employeeInfo.HoursWorked
};
}
employee.Id = employeeInfo.Id;
employee.Name = employeeInfo.Name;
employee.Gender = employeeInfo.Gender;
employee.DateOfBirth = employeeInfo.DOB;
employee.EmployeeType = employeeInfo.EmployeeType;
return(PartialView("GetEmployee", employee));
}
//public EmployeeKnownType GetEmployeeKnownType(int Id)
public EmployeeInfo GetEmployeeKnownType(EmployeeRequest request)
{
EmployeeKnownType employee = null;
string cs = ConfigurationManager.ConnectionStrings["SampleWebService"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spGetEmployeeKnownType", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameterId = new SqlParameter();
parameterId.ParameterName = "@Id";
//parameterId.Value = Id;
parameterId.Value = request.EmployeeId;
cmd.Parameters.Add(parameterId);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return(new EmployeeInfo());
}
//return null;
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"]),
EmployeeType = EmployeeType.FullTimeEmployee,
AnnualSalary = reader["AnnualSalary"] == null ? 0 : 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"]),
EmployeeType = EmployeeType.PartTimeEmployee,
HourlyPay = reader["HourlyPay"] == null ? 0 : Convert.ToInt32(reader["HourlyPay"]),
HoursWorked = reader["HoursWorked"] == null ? 0 : Convert.ToInt32(reader["HoursWorked"])
};
}
}
}
if (lastSavedEmployee != null && request.EmployeeId == lastSavedEmployee.Id)
{
employee.ExtensionData = lastSavedEmployee.ExtensionData;
}
//return employee;
return(new EmployeeInfo(employee));
}
//public void SaveEmployeeKnownType(EmployeeKnownType employee)
public void SaveEmployeeKnownType(EmployeeInfo employee)
{
string cs = ConfigurationManager.ConnectionStrings["SampleWebService"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spSaveEmployeeKnownType", con);
cmd.CommandType = CommandType.StoredProcedure;
//SqlParameter parameterId = new SqlParameter
//{
// ParameterName = "@Id",
// Value = employee.Id
//};
//cmd.Parameters.Add(parameterId);
SqlParameter parameterName = new SqlParameter
{
ParameterName = "@Name",
Value = employee.Name
};
cmd.Parameters.Add(parameterName);
SqlParameter parameterGender = new SqlParameter
{
ParameterName = "@Gender",
Value = employee.Gender
};
cmd.Parameters.Add(parameterGender);
SqlParameter parameterDateOfBirth = new SqlParameter
{
ParameterName = "@DateOfBirth",
//Value = employee.DateOfBirth
Value = employee.DOB
};
cmd.Parameters.Add(parameterDateOfBirth);
SqlParameter parameterEmployeeType = new SqlParameter
{
ParameterName = "@EmployeeType",
//Value = employee.EmployeeType
Value = employee.EmployeeType
};
cmd.Parameters.Add(parameterEmployeeType);
//if (employee.GetType() == typeof(FullTimeEmployee))
if (employee.EmployeeType == EmployeeType.FullTimeEmployee)
{
SqlParameter parameterAnnualSalary = new SqlParameter
{
ParameterName = "@AnnualSalary",
//Value = ((FullTimeEmployee)employee).AnnualSalary
Value = employee.AnnualSalary
};
cmd.Parameters.Add(parameterAnnualSalary);
}
else
{
SqlParameter parameterHourlyPay = new SqlParameter
{
ParameterName = "@HourlyPay",
//Value = ((PartTimeEmployee)employee).HourlyPay,
Value = employee.HourlyPay,
};
cmd.Parameters.Add(parameterHourlyPay);
SqlParameter parameterHoursWorked = new SqlParameter
{
ParameterName = "@HoursWorked",
//Value = ((PartTimeEmployee)employee).HoursWorked
Value = employee.HoursWorked
};
cmd.Parameters.Add(parameterHoursWorked);
}
lastSavedEmployee = employee.GetEmployeeObject();
con.Open();
cmd.ExecuteNonQuery();
}
}
