public static List<Employee> GetEmployee()
{
List<Employee> listEmployee = new List<Employee>();
Employee employee = new Employee
{
Id = 1,
Name = "LAMGHARI",
Gender = "M",
Dateofb = Convert.ToDateTime("21/10/1988"),
};
listEmployee.Add(employee);
return listEmployee;
}
public void SaveEmployee(Employee Employee)
{
LogDeb.LogException("EmployeeService", "SaveEmployee", "SaveEmployee Debut Ok");
string cs = ConfigurationManager.ConnectionStrings["DBCS"].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 parameterDateofb = new SqlParameter()
{
ParameterName = "@Dateofb",
Value = Employee.Dateofb
};
cmd.Parameters.Add(parameterDateofb);
SqlParameter parameterEmployeeType = new SqlParameter()
{
ParameterName = "@EmployeeType",
Value = Employee.Type
};
cmd.Parameters.Add(parameterEmployeeType);
if (Employee.GetType() == typeof(FullTimeEmployee))
{
SqlParameter parameterAnnualSalary = new SqlParameter()
{
ParameterName = "@AnnualSalary",
Value = ((FullTimeEmployee)Employee).AnnualSalary
};
cmd.Parameters.Add(parameterAnnualSalary);
}
else
{
SqlParameter parameterHourlyPay = new SqlParameter
{
ParameterName = "@HourlyPay",
Value = ((PartTimeEmployee)Employee).HourlyPay
};
cmd.Parameters.Add(parameterHourlyPay);
SqlParameter parameterHoursWorked = new SqlParameter
{
ParameterName = "@HoursWorked",
Value = ((PartTimeEmployee)Employee).HoursWorked
};
cmd.Parameters.Add(parameterHoursWorked);
}
con.Open();
cmd.ExecuteNonQuery();
LogDeb.LogException("EmployeeService", "SaveEmployee", "SaveEmployee End Ok");
}
}
