using System.Threading.Tasks;
using System.Data.SqlClient;
if (flat == 1)
{
Task.Factory.StartNew(()=> InsertarHijos(parentid));
}
private void InsertarHijos(Int64 parent)
{
try {
using (SqlConnection conn1 = KKLUtils.SqlConnectionHelper.GetDefaultConnection())
{
conn1.Open();
SqlCommand cmd1 = new SqlCommand("pr_ConvertToRemplaze", conn1);
cmd1.CommandTimeout = 600;
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add(new SqlParameter("@companyID", this.companyID));
cmd1.Parameters.Add(new SqlParameter("@listTypeID",Convert.ToInt32(this.cmbTipoPrecio.Value)));
cmd1.Parameters.Add(new SqlParameter("@listID", parent));
rdr1 = cmd1.ExecuteReader();
}
using (SqlConnection conn2 = KKLUtils.SqlConnectionHelper.GetDefaultConnection())
{
conn2.Open();
SqlCommand cmd2 = new SqlCommand("pr_ConvertToConfirmate", conn2);
cmd2.CommandTimeout = 1800; //30 mins
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add(new SqlParameter("@companyID", this.companyID));
cmd2.Parameters.Add(new SqlParameter("@typePriceID",Convert.ToInt32(this.cmbTipoPrecio.Value)));
cmd2.Parameters.Add(new SqlParameter("@listID", this.GENERAL_ID));
rdr2 = cmd2.ExecuteReader();
}
}
catch (Exception ex)
{
ErrorMessage = ex.Message.ToString();
}
}