public void SaveEmployee(EmployeeInfo employee)
{
string cs = ConfigurationManager.ConnectionStrings["cdkConnectionString"].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);
SqlParameter parameterEmployeeType = new SqlParameter
{
ParameterName = "@EmployeeType",
Value = employee.Type
};
cmd.Parameters.Add(parameterEmployeeType);
if (employee.Type == EmployeeType.FullTimeEmployee)
{
SqlParameter parameterAnnualSalary = new SqlParameter
{
ParameterName = "@AnnualSalary",
Value = employee.AnnualSalary
};
cmd.Parameters.Add(parameterAnnualSalary);
}
else
{
SqlParameter parameterHourlyPay = new SqlParameter
{
ParameterName = "@HourlyPay",
Value = employee.HourlyPay
};
cmd.Parameters.Add(parameterHourlyPay);
SqlParameter parameterHoursWorked = new SqlParameter
{
ParameterName = "@HoursWorked",
Value = employee.HoursWorked
};
cmd.Parameters.Add(parameterHoursWorked);
}
con.Open();
cmd.ExecuteNonQuery();
}
}
public void SaveEmployee(EmployeeInfo employee)
{
_lastSavedEmployee = employee;
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 parameterDateOfBirth = new SqlParameter
{
ParameterName = "@DateOfBirth",
Value = employee.DOB
};
cmd.Parameters.Add(parameterDateOfBirth);
SqlParameter parameterEmployeeType = new SqlParameter
{
ParameterName = "@EmployeeType",
Value = employee.Type
};
cmd.Parameters.Add(parameterEmployeeType);
SqlParameter parameterEmployeeCity = new SqlParameter
{
ParameterName = "@City",
Value = employee.City
};
cmd.Parameters.Add(parameterEmployeeCity);
if (employee.Type == EmployeeType.FullTimeEmployee)
{
SqlParameter parameterAnnualSalary = new SqlParameter
{
ParameterName = "@AnnualSalary",
Value = employee.AnnualSalary
};
cmd.Parameters.Add(parameterAnnualSalary);
}
else
{
SqlParameter parameterHourlyPay = new SqlParameter
{
ParameterName = "@HourlyPay",
Value = employee.HourlyPay,
};
cmd.Parameters.Add(parameterHourlyPay);
SqlParameter parameterHoursWorked = new SqlParameter
{
ParameterName = "@HoursWorked",
Value = employee.HoursWorked
};
cmd.Parameters.Add(parameterHoursWorked);
}
con.Open();
cmd.ExecuteNonQuery();
}
}
public void SaveEmployee(EmployeeInfo employee)
{
EmployeeProvider.SaveEmployee(employee.ToEmployeeEntity());
}
//public void SetEmployee(Employee employee)
public void SetEmployee(EmployeeInfo employee)
{
// 1- Parepare the connection
string cs = ConfigurationManager.ConnectionStrings["DDBC"].ConnectionString;
using(SqlConnection conn = new SqlConnection(cs))
{
// 2- Setup the command type
SqlCommand cmd = new SqlCommand("spSaveEmployee", conn);
cmd.CommandType = CommandType.StoredProcedure;
// 3- Add the parameters
SqlParameter parameterId = new SqlParameter()
{
ParameterName = "@Id",
Value = employee.Id
};
SqlParameter parameterName = new SqlParameter()
{
ParameterName = "@Name",
Value = employee.Name
};
SqlParameter parameterDateOfBirth = new SqlParameter()
{
ParameterName = "@DateOfBirth",
Value = employee.DOB.ToShortDateString() //employee.DateOfBirth.ToShortDateString()
};
SqlParameter parameterEmployeeType = new SqlParameter()
{
ParameterName = "@EmployeeType",
Value = employee.Type
};
cmd.Parameters.Add(parameterId);
cmd.Parameters.Add(parameterName);
cmd.Parameters.Add(parameterDateOfBirth);
cmd.Parameters.Add(parameterEmployeeType);
//if (employee.GetType() == typeof(FullTimeEmployee))
if(employee.Type == EmployeeType.FullTimeEmployee)
{
SqlParameter parameterAnnualSalary = new SqlParameter()
{
ParameterName = "@AnnualSalary",
Value = employee.AnnualSalary //((FullTimeEmployee)employee).AnnualSalary
};
cmd.Parameters.Add(parameterAnnualSalary);
}
else
{
SqlParameter parameterHourlyPay = new SqlParameter()
{
ParameterName = "@HourlyPay",
Value = employee.HourlyPay //((PartTimeEmployee)employee).HourlyPay
};
SqlParameter parameterHoursWorked = new SqlParameter()
{
ParameterName = "@HoursWorked",
Value = employee.HoursWorked //((PartTimeEmployee)employee).HoursWorked
};
cmd.Parameters.Add(parameterHourlyPay);
cmd.Parameters.Add(parameterHoursWorked);
}
// 4- Open and Execute
conn.Open();
cmd.ExecuteNonQuery();
}
}
