public static void Save(JobPosting jobPosting)
{
string connectionString = ConfigurationManager.ConnectionStrings["ContosoHR"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SaveJobPosting";
command.Parameters.Add(new SqlParameter("@id", jobPosting.Id));
command.Parameters.Add(new SqlParameter("@hiringRequestId", jobPosting.HiringRequestInfo.Id));
command.Parameters.Add(new SqlParameter("@title", jobPosting.Title));
command.Parameters.Add(new SqlParameter("@description", jobPosting.Description));
command.Parameters.Add(new SqlParameter("@status", jobPosting.Status));
command.ExecuteNonQuery();
}
}
public static void Save(JobPosting jobPosting)
{
string connectionString = ConfigurationManager.ConnectionStrings["ContosoHR"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SaveJobPosting";
command.Parameters.Add(new SqlParameter("@id", jobPosting.Id));
command.Parameters.Add(new SqlParameter("@hiringRequestId", jobPosting.HiringRequestInfo.Id));
command.Parameters.Add(new SqlParameter("@title", jobPosting.Title));
command.Parameters.Add(new SqlParameter("@description", jobPosting.Description));
command.Parameters.Add(new SqlParameter("@status", jobPosting.Status));
command.ExecuteNonQuery();
}
}