public static int?UpsertJobV3(JobDataModel job, out List <string> outMessageList)
{
outMessageList = new List <string>();
var messageList = new List <string>(); // need local holding list for InfoMessage event handler
using (var conn = new SqlConnection(_connectionString))
{
conn.Open();
conn.InfoMessage += (sender, args) =>
{
messageList.Add(args.Message);
};
using (var cmd = new SqlCommand("dbo.UpsertJobV3", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
var idOutPram = SqlParameterHelper.CreateInputOutputIntParameter("job_id", job.Id);
cmd.Parameters.Add(idOutPram);
cmd.Parameters.AddWithValue("job_name", job.Name);
cmd.Parameters.AddWithValue("job_type_name", job.Type);
cmd.Parameters.AddWithValue("job_date", job.Date);
cmd.Parameters.AddWithValue("job_amount", job.Amount);
cmd.ExecuteNonQuery();
outMessageList.AddRange(messageList);
return(idOutPram.Value as int?);
}
}
}
public static int?UpsertJob(JobDataModel job)
{
using (var conn = new SqlConnection(_connectionString))
{
conn.Open();
using (var cmd = new SqlCommand("dbo.UpsertJob", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
var idOutPram = SqlParameterHelper.CreateInputOutputIntParameter("job_id", job.Id);
cmd.Parameters.Add(idOutPram);
cmd.Parameters.AddWithValue("job_name", job.Name);
cmd.Parameters.AddWithValue("job_type_name", job.Type);
cmd.Parameters.AddWithValue("job_date", job.Date);
cmd.Parameters.AddWithValue("job_amount", job.Amount);
cmd.ExecuteNonQuery();
return(idOutPram.Value as int?);
}
}
}
