CCN.Modules.Car.DataAccess.CarDataAccess.ExchangePictureSort C# (CSharp) Method

        public int ExchangePictureSort(List<CarPictureModel> listPicture)
        {
            const string sql = @"update car_picture set sort=@sort where innerid=@innerid;";

            using (var conn = Helper.GetConnection())
            {
                var tran = conn.BeginTransaction();
                try
                {
                    conn.Execute(sql, new { innerid = listPicture[0].Innerid, sort = listPicture[0].Sort }, tran);
                    conn.Execute(sql, new { innerid = listPicture[1].Innerid, sort = listPicture[1].Sort }, tran);

                    tran.Commit();
                    return 1;
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                    return 0;
                }
            }
        }