public static void InsertResume(JobPostingResume resumee)
        {
            string connectionString = ConfigurationManager.ConnectionStrings["ContosoHR"].ConnectionString;

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                SqlCommand command = connection.CreateCommand();
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "InsertJobPostingResumee";
                command.Parameters.Add(new SqlParameter("@jobPostingId", resumee.JobPosting.Id));
                command.Parameters.Add(new SqlParameter("@candidateMail", resumee.CandidateMail));
                command.Parameters.Add(new SqlParameter("@candidateName", resumee.CandidateName));
                command.Parameters.Add(new SqlParameter("@resumee", resumee.ResumeeText));

                command.ExecuteNonQuery();
            }
        }
        public static void InsertResume(JobPostingResume resumee)
        {
            string connectionString = ConfigurationManager.ConnectionStrings["ContosoHR"].ConnectionString;

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                SqlCommand command = connection.CreateCommand();
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "InsertJobPostingResumee";
                command.Parameters.Add(new SqlParameter("@jobPostingId", resumee.JobPosting.Id));
                command.Parameters.Add(new SqlParameter("@candidateMail", resumee.CandidateMail));
                command.Parameters.Add(new SqlParameter("@candidateName", resumee.CandidateName));
                command.Parameters.Add(new SqlParameter("@resumee", resumee.ResumeeText));

                command.ExecuteNonQuery();
            }
        }