Лістинг коду 3 страница

}

}

public void new_transaction_compl(int transaction_id, string cl_name, string cl_phone, string cl_address, string cr_id, ref string res)

{

try

{

using (SqlConnection conn = new SqlConnection(CS.CONNECT_SQL))

{

conn.Open();

SqlCommand command = new SqlCommand("dbo.sp_new_transaction_compl", conn) { CommandType = CommandType.StoredProcedure };

command.Parameters.Add("@transaction_id", SqlDbType.Int).Value = transaction_id;

command.Parameters.Add("@cl_name", SqlDbType.VarChar, 20).Value = cl_name;

command.Parameters.Add("@cl_phone", SqlDbType.VarChar, 20).Value = cl_phone;

command.Parameters.Add("@cl_address", SqlDbType.VarChar, 20).Value = cl_address;

command.Parameters.Add("@cr_id", SqlDbType.Int).Value = cr_id;

command.Parameters.Add("@res", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

res = command.Parameters["@res"].Value.ToString();

conn.Close();

}

}

catch (Exception ex)

{

res = String.Format("Помилка виклику процедури dbo.sp_new_transaction_compl");

}

}

}

}

Дата добавления: 2015-08-31