public List <GetTransmission> GetTransmission()
        {
            List <GetTransmission> list = new List <GetTransmission>();

            using (_ctx = new GuildCarsEntities())
            {
                var trans = _ctx.GetTransmission();

                foreach (var t in trans)
                {
                    GetTransmission c = new GetTransmission();

                    c.TransmissionId   = t.TransmissionId;
                    c.TransmissionName = t.TransmissionName;

                    list.Add(c);
                }
            }
            return(list);
        }