public static Contact TblToData(tbl_ContactDB tblContactDB)
        {
            if (tblContactDB == null) return null;

            Contact account= new Contact();
            try
            {

                Console.WriteLine(string.Format("{0,-30}", "\t\tAccountID      : " + tblContactDB.AccountID + "\n"));
                Console.WriteLine(string.Format("{0,-30}", "\t\tFirstName      : " + tblContactDB.FirstName));
                Console.WriteLine(string.Format("{0,-30}", "\t\tMiddleName     : " + tblContactDB.MiddleName));
                Console.WriteLine(string.Format("{0,-30}", "\t\tLastName       : " + tblContactDB.LastName));
                Console.WriteLine(string.Format("{0,-30}", "\t\tAddress        : " + tblContactDB.Address));
                Console.WriteLine(string.Format("{0,-30}", "\t\tCity           : " + tblContactDB.City));
                Console.WriteLine(string.Format("{0,-30}", "\t\tProvince       : " + tblContactDB.Province));
                Console.WriteLine(string.Format("{0,-30}", "\t\tZipCode        : " + (int)tblContactDB.ZipCode));
                Console.WriteLine(string.Format("{0,-30}", "\t\tTelephoneNumber: " + (int)tblContactDB.TelephoneNumber));
                Console.WriteLine(string.Format("{0,-30}", "\t\tMobileNumber   : " + (int)tblContactDB.MobileNumber));
                Console.WriteLine(string.Format("{0,-30}", "\t\tEmail          : " + tblContactDB.Email));
                Console.WriteLine(string.Format("{0,-30}", "\t\tTimeSubmitted  : " + (DateTime)tblContactDB.TimeSubmitted + "\n\n"));

            }
            catch (Exception)
            {
                throw;
            }

            return account;
        }
 partial void Deletetbl_ContactDB(tbl_ContactDB instance);
 partial void Updatetbl_ContactDB(tbl_ContactDB instance);
 partial void Inserttbl_ContactDB(tbl_ContactDB instance);