private API_Card FormatData(tblCard model)
        {
            var t = new API_Card()
            {
                CardNo      = model.CardNo,
                CardNumber  = model.CardNumber,
                DateExpired = Convert.ToDateTime(model.ExpireDate).ToString("dd/MM/yyyy"),
                Plates      = new List <string>()
            };

            if (!string.IsNullOrWhiteSpace(model.Plate1))
            {
                t.Plates.Add(model.Plate1);
            }

            if (!string.IsNullOrWhiteSpace(model.Plate2))
            {
                t.Plates.Add(model.Plate2);
            }

            if (!string.IsNullOrWhiteSpace(model.Plate3))
            {
                t.Plates.Add(model.Plate3);
            }

            var first = t.CardNumber.Substring(0, 2);
            var last  = t.CardNumber.Substring(t.CardNumber.Length - 4, 3);

            t.CardNumber_Mix = first + "..." + last;

            return(t);
        }
        public API_Card GetByCardNumber(string cardnumber)
        {
            var model = new API_Card();

            var query = from n in _tblCardRepository.Table
                        where n.IsDelete == false && n.IsLock == false && n.CardNumber == cardnumber
                        select n;

            var t = query.FirstOrDefault();

            if (t != null)
            {
                model = FormatData(t);
            }

            return(model);
        }