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