private Tel GetFilledRandomTel(string OmitPropName)
        {
            Tel tel = new Tel();

            if (OmitPropName != "TelTVItemID")
            {
                tel.TelTVItemID = 55;
            }
            if (OmitPropName != "TelNumber")
            {
                tel.TelNumber = GetRandomString("", 5);
            }
            if (OmitPropName != "TelType")
            {
                tel.TelType = (TelTypeEnum)GetRandomEnumType(typeof(TelTypeEnum));
            }
            if (OmitPropName != "LastUpdateDate_UTC")
            {
                tel.LastUpdateDate_UTC = new DateTime(2005, 3, 6);
            }
            if (OmitPropName != "LastUpdateContactTVItemID")
            {
                tel.LastUpdateContactTVItemID = 2;
            }

            return(tel);
        }
Example #2
0
 private void Clear_Click(object sender, RoutedEventArgs e)
 {
     Fio.Clear();
     Data.Clear();
     Tel.Clear();
     Mail.Clear();
 }
Example #3
0
        public override int GetHashCode()
        {
            int hash = 1;

            if (Name.Length != 0)
            {
                hash ^= Name.GetHashCode();
            }
            if (Tel.Length != 0)
            {
                hash ^= Tel.GetHashCode();
            }
            if (Addr.Length != 0)
            {
                hash ^= Addr.GetHashCode();
            }
            if (Postcode.Length != 0)
            {
                hash ^= Postcode.GetHashCode();
            }
            if (_unknownFields != null)
            {
                hash ^= _unknownFields.GetHashCode();
            }
            return(hash);
        }
Example #4
0
 /// <summary>
 /// Construct a TelUri from the specified <see cref="Tel"/>
 /// </summary>
 /// <param name="tel">The Tel value to use for the resulting TelUri</param>
 public TelUri(Tel tel)
 {
     Value   = tel ?? throw new ArgumentNullException(nameof(tel));
     Uri     = new Uri(ToString());
     _params = null;
     Value.PropertyChanged += Value_PropertyChanged;
 }
Example #5
0
 public Order_refundSelectBuild WhereTelLike(params string[] Tel)
 {
     if (Tel == null || Tel.Where(a => !string.IsNullOrEmpty(a)).Any() == false)
     {
         return(this);
     }
     return(this.Where1Or(@"a.`tel` LIKE {0}", Tel.Select(a => "%" + a + "%").ToArray()));
 }
Example #6
0
        public Tel GetTelWithTelIDDB(int TelID)
        {
            Tel tel = (from c in db.Tels
                       where c.TelID == TelID
                       select c).FirstOrDefault <Tel>();

            return(tel);
        }
        public void Tel_Controller_Put_Test()
        {
            foreach (LanguageEnum LanguageRequest in AllowableLanguages)
            {
                foreach (int ContactID in new List <int>()
                {
                    AdminContactID
                })                                                             //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
                {
                    TelController telController = new TelController(DatabaseTypeEnum.SqlServerTestDB);
                    Assert.IsNotNull(telController);
                    Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, telController.DatabaseType);

                    Tel telLast = new Tel();
                    using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
                    {
                        Query query = new Query();
                        query.Language = LanguageRequest;

                        TelService telService = new TelService(query, db, ContactID);
                        telLast = (from c in db.Tels select c).FirstOrDefault();
                    }

                    // ok with Tel info
                    IHttpActionResult jsonRet = telController.GetTelWithID(telLast.TelID);
                    Assert.IsNotNull(jsonRet);

                    OkNegotiatedContentResult <Tel> Ret = jsonRet as OkNegotiatedContentResult <Tel>;
                    Tel telRet = Ret.Content;
                    Assert.AreEqual(telLast.TelID, telRet.TelID);

                    BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
                    Assert.IsNull(badRequest);

                    // Put to return success
                    IHttpActionResult jsonRet2 = telController.Put(telRet, LanguageRequest.ToString());
                    Assert.IsNotNull(jsonRet2);

                    OkNegotiatedContentResult <Tel> telRet2 = jsonRet2 as OkNegotiatedContentResult <Tel>;
                    Assert.IsNotNull(telRet2);

                    BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
                    Assert.IsNull(badRequest2);

                    // Put to return CSSPError because TelID of 0 does not exist
                    telRet.TelID = 0;
                    IHttpActionResult jsonRet3 = telController.Put(telRet, LanguageRequest.ToString());
                    Assert.IsNotNull(jsonRet3);

                    OkNegotiatedContentResult <Tel> telRet3 = jsonRet3 as OkNegotiatedContentResult <Tel>;
                    Assert.IsNull(telRet3);

                    BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
                    Assert.IsNotNull(badRequest3);
                }
            }
        }
        public void Tel_CRUD_Test()
        {
            foreach (CultureInfo culture in AllowableCulture)
            {
                ChangeCulture(culture);

                using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
                {
                    TelService telService = new TelService(new Query()
                    {
                        Lang = culture.TwoLetterISOLanguageName
                    }, dbTestDB, ContactID);

                    int count = 0;
                    if (count == 1)
                    {
                        // just so we don't get a warning during compile [The variable 'count' is assigned but its value is never used]
                    }

                    Tel tel = GetFilledRandomTel("");

                    // -------------------------------
                    // -------------------------------
                    // CRUD testing
                    // -------------------------------
                    // -------------------------------

                    count = telService.GetTelList().Count();

                    Assert.AreEqual(count, (from c in dbTestDB.Tels select c).Count());

                    telService.Add(tel);
                    if (tel.HasErrors)
                    {
                        Assert.AreEqual("", tel.ValidationResults.FirstOrDefault().ErrorMessage);
                    }
                    Assert.AreEqual(true, telService.GetTelList().Where(c => c == tel).Any());
                    telService.Update(tel);
                    if (tel.HasErrors)
                    {
                        Assert.AreEqual("", tel.ValidationResults.FirstOrDefault().ErrorMessage);
                    }
                    Assert.AreEqual(count + 1, telService.GetTelList().Count());
                    telService.Delete(tel);
                    if (tel.HasErrors)
                    {
                        Assert.AreEqual("", tel.ValidationResults.FirstOrDefault().ErrorMessage);
                    }
                    Assert.AreEqual(count, telService.GetTelList().Count());
                }
            }
        }
Example #9
0
 internal void PopulateModel()
 {
     Item.Name        = Name.GetValue <string>();
     Item.Email       = Email.GetValue <string>();
     Item.Number      = Number.GetValue <int>();
     Item.Tel         = Tel.GetValue <string>();
     Item.Notes       = Notes.GetValue <string>();
     Item.DateOfBirth = DateOfBirth.GetValue <DateTime?>();
     Item.TimeOfBirth = TimeOfBirth.GetValue <TimeSpan?>();
     Item.Type        = Type.GetValue <Domain.ContactType>();
     Item.Photo       = Photo.GetValue <Document>();
     Item.IsNice      = IsNice.GetValue <bool?>();
 }
Example #10
0
        public TelModel PostAddTelDB(TelModel telModel)
        {
            string retStr = TelModelOK(telModel);

            if (!string.IsNullOrWhiteSpace(retStr))
            {
                return(ReturnError(retStr));
            }

            ContactOK contactOK = IsContactOK();

            if (!string.IsNullOrEmpty(contactOK.Error))
            {
                return(ReturnError(contactOK.Error));
            }

            TVItemModel tvItemModelTel = _TVItemService.GetTVItemModelWithTVItemIDDB(telModel.TelTVItemID);

            if (!string.IsNullOrWhiteSpace(tvItemModelTel.Error))
            {
                return(ReturnError(tvItemModelTel.Error));
            }

            Tel telNew = new Tel();

            retStr = FillTel(telNew, telModel, contactOK);
            if (!string.IsNullOrWhiteSpace(retStr))
            {
                return(ReturnError(retStr));
            }

            using (TransactionScope ts = new TransactionScope())
            {
                db.Tels.Add(telNew);
                retStr = DoAddChanges();
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(ReturnError(retStr));
                }

                LogModel logModel = _LogService.PostAddLogForObj("Tels", telNew.TelID, LogCommandEnum.Add, telNew);
                if (!string.IsNullOrWhiteSpace(logModel.Error))
                {
                    return(ReturnError(logModel.Error));
                }

                ts.Complete();
            }
            return(GetTelModelWithTelIDDB(telNew.TelID));
        }
Example #11
0
        static void Main(string[] args)
        {
            AlanKodu A = new AlanKodu();
            Tel      T = new Tel();

            T.Telno    = "544 30 828 30";
            A.alankodu = "5443082830";

            Console.WriteLine(T.Telno);
            Console.WriteLine(A.alankodu);


            Console.ReadKey();
        }
        public IHttpActionResult GetTelWithID([FromUri] int TelID, [FromUri] string lang = "en", [FromUri] string extra = "")
        {
            using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
            {
                TelService telService = new TelService(new Query()
                {
                    Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
                }, db, ContactID);

                telService.Query = telService.FillQuery(typeof(Tel), lang, 0, 1, "", "", extra);

                if (telService.Query.Extra == "A")
                {
                    TelExtraA telExtraA = new TelExtraA();
                    telExtraA = telService.GetTelExtraAWithTelID(TelID);

                    if (telExtraA == null)
                    {
                        return(NotFound());
                    }

                    return(Ok(telExtraA));
                }
                else if (telService.Query.Extra == "B")
                {
                    TelExtraB telExtraB = new TelExtraB();
                    telExtraB = telService.GetTelExtraBWithTelID(TelID);

                    if (telExtraB == null)
                    {
                        return(NotFound());
                    }

                    return(Ok(telExtraB));
                }
                else
                {
                    Tel tel = new Tel();
                    tel = telService.GetTelWithTelID(TelID);

                    if (tel == null)
                    {
                        return(NotFound());
                    }

                    return(Ok(tel));
                }
            }
        }
Example #13
0
        /// <summary>
        /// Construct a TelUri from the provided URI
        /// </summary>
        /// <param name="source"></param>
        public TelUri(Uri source)
        {
            if (source == null)
            {
                throw new ArgumentNullException(nameof(source));
            }
            if (source.Scheme != SCHEME)
            {
                throw new ArgumentOutOfRangeException(ParsingHelper.UriWrongSchemeError(SCHEME));
            }

            Uri   = source;
            Value = new Tel(Uri.LocalPath, out _params);
            Value.PropertyChanged += Value_PropertyChanged;
        }
Example #14
0
 public override int GetHashCode()
 {
     unchecked
     {
         var hashCode = (Gcp != null ? Gcp.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Name != null ? Name.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Addr2 != null ? Addr2.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Addr3 != null ? Addr3.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Addr4 != null ? Addr4.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (PostalCode != null ? PostalCode.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (City != null ? City.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Tel != null ? Tel.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Mail != null ? Mail.GetHashCode() : 0);
         return(hashCode);
     }
 }
 /// <summary>
 /// Serves as a hash function for a particular type.
 /// </summary>
 /// <returns>
 /// A hash code for the current <see cref="T:System.Object"/>.
 /// </returns>
 public override int GetHashCode()
 {
     unchecked
     {
         var hashCode = Fn?.GetHashCode() ?? 0;
         hashCode = (hashCode * 397) ^ (Email?.GetHashCode() ?? 0);
         hashCode = (hashCode * 397) ^ (Url?.GetHashCode() ?? 0);
         hashCode = (hashCode * 397) ^ (Org?.GetHashCode() ?? 0);
         hashCode = (hashCode * 397) ^ (Adr?.GetHashCode() ?? 0);
         hashCode = (hashCode * 397) ^ (Tel?.GetHashCode() ?? 0);
         hashCode = (hashCode * 397) ^ (XTwitter?.GetHashCode() ?? 0);
         hashCode = (hashCode * 397) ^ (XGithub?.GetHashCode() ?? 0);
         hashCode = (hashCode * 397) ^ (Photo?.GetHashCode() ?? 0);
         hashCode = (hashCode * 397) ^ (VCard?.GetHashCode() ?? 0);
         return(hashCode);
     }
 }
        public bool Update(Tel tel)
        {
            tel.ValidationResults = Validate(new ValidationContext(tel), ActionDBTypeEnum.Update);
            if (tel.ValidationResults.Count() > 0)
            {
                return(false);
            }

            db.Tels.Update(tel);

            if (!TryToSave(tel))
            {
                return(false);
            }

            return(true);
        }
        private bool TryToSave(Tel tel)
        {
            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException ex)
            {
                tel.ValidationResults = new List <ValidationResult>()
                {
                    new ValidationResult(ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""))
                }.AsEnumerable();
                return(false);
            }

            return(true);
        }
Example #18
0
        public List <Field> GetFields()
        {
            List <Field> fields = GetEmptyFields();

            fields[0].SetValue(Name);
            fields[1].SetValue(Surname);
            fields[2].SetValue(Dni.ToString());
            fields[3].SetValue(Mail);
            fields[4].SetValue(Tel.ToString());
            fields[5].SetValue(Dir);
            fields[6].SetValue(City);
            fields[7].SetValue(Postal.ToString());
            fields[8].SetValue(BirthDate.ToString("yyyy-MM-dd HH.mmm:ss:l"));
            fields[9].SetValue(Endabled.ToString());
            fields[10].SetValue(User);
            return(fields);
        }
 /// <summary>
 /// Serves as a hash function for a particular type.
 /// </summary>
 /// <returns>
 /// A hash code for the current <see cref="T:System.Object"/>.
 /// </returns>
 public override int GetHashCode()
 {
     unchecked
     {
         var hashCode = (Fn != null ? Fn.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Email != null ? Email.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Url != null ? Url.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Org != null ? Org.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Adr != null ? Adr.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Tel != null ? Tel.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (XTwitter != null ? XTwitter.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (XGithub != null ? XGithub.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (Photo != null ? Photo.GetHashCode() : 0);
         hashCode = (hashCode * 397) ^ (VCard != null ? VCard.GetHashCode() : 0);
         return(hashCode);
     }
 }
Example #20
0
        public List <Field> GetFields()
        {
            List <Field> f = GetEmptyFields();

            f[0].SetValue(Cuit);
            f[1].SetValue(Rsocial);
            f[2].SetValue(Mail);
            f[3].SetValue(Tel.ToString());
            f[4].SetValue(Domicilio);
            f[5].SetValue(Localidad);
            f[6].SetValue(Ciudad);
            f[7].SetValue(Rubro);
            f[8].SetValue(Postal.ToString());
            f[9].SetValue(ProvNombre);
            f[10].SetValue(Endabled.ToString());
            f[11].SetValue(user);
            return(f);
        }
Example #21
0
        // Fill
        public string FillTel(Tel tel, TelModel telModel, ContactOK contactOK)
        {
            tel.DBCommand          = (int)telModel.DBCommand;
            tel.TelTVItemID        = telModel.TelTVItemID;
            tel.TelNumber          = telModel.TelNumber;
            tel.TelType            = (int)telModel.TelType;
            tel.LastUpdateDate_UTC = DateTime.UtcNow;
            if (contactOK == null)
            {
                tel.LastUpdateContactTVItemID = 2;
            }
            else
            {
                tel.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
            }

            return("");
        }
Example #22
0
        public EstimationPage()
        {
            InitializeComponent();
            Intitule.Completed += (s, e) => Adresse.Focus();
            Adresse.Completed  += (s, e) => Ville.Focus();
            Ville.Completed    += (s, e) => Tel.Focus();
            Tel.Completed      += (s, e) => Mail.Focus();

            EstimationPlus.Clicked += (s, e) => Estimation.Focus();


            Estimation.Completed   += (s, e) => Secteur.Focus();
            Secteur.Completed      += (s, e) => Surface.Focus();
            Surface.Completed      += (s, e) => TypeChantier.Focus();
            TypeChantier.Completed += (s, e) => TypeBatiment.Focus();
            TypeBatiment.Completed += (s, e) => Lieu.Focus();
            Lieu.Completed         += (s, e) => Annee.Focus();
        }
Example #23
0
        public TelModel PostDeleteTelDB(int telID)
        {
            ContactOK contactOK = IsContactOK();

            if (!string.IsNullOrEmpty(contactOK.Error))
            {
                return(ReturnError(contactOK.Error));
            }

            Tel telToDelete = GetTelWithTelIDDB(telID);

            if (telToDelete == null)
            {
                return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToDelete, ServiceRes.Tel)));
            }

            int TVItemIDToDelete = telToDelete.TelTVItemID;

            using (TransactionScope ts = new TransactionScope())
            {
                db.Tels.Remove(telToDelete);
                string retStr = DoDeleteChanges();
                if (!string.IsNullOrWhiteSpace(retStr))
                {
                    return(ReturnError(retStr));
                }

                LogModel logModel = _LogService.PostAddLogForObj("Tels", telToDelete.TelID, LogCommandEnum.Delete, telToDelete);
                if (!string.IsNullOrWhiteSpace(logModel.Error))
                {
                    return(ReturnError(logModel.Error));
                }

                TVItemModel tvItemModelRet = _TVItemService.PostDeleteTVItemWithTVItemIDDB(TVItemIDToDelete);
                if (!string.IsNullOrWhiteSpace(tvItemModelRet.Error))
                {
                    return(ReturnError(tvItemModelRet.Error));
                }

                ts.Complete();
            }

            return(ReturnError(""));
        }
Example #24
0
        /// <summary>
        /// Construct a TelUri from the provided string.
        /// </summary>
        /// <param name="uriSource"></param>
        public TelUri(string uriSource)
        {
            if (string.IsNullOrWhiteSpace(uriSource))
            {
                throw new ArgumentNullException(nameof(uriSource));
            }
            if (!uriSource.Trim().ToLower().StartsWith(SCHEME))
            {
                throw new ArgumentOutOfRangeException(ParsingHelper.UriWrongSchemeError(SCHEME));
            }
            if (!Uri.IsWellFormedUriString(uriSource, UriKind.RelativeOrAbsolute))
            {
                throw new UriFormatException();
            }

            Uri   = new Uri(uriSource);
            Value = new Tel(Uri.LocalPath, out _params);
            Value.PropertyChanged += Value_PropertyChanged;
        }
        public void Tel_Controller_GetTelWithID_Test()
        {
            foreach (LanguageEnum LanguageRequest in AllowableLanguages)
            {
                foreach (int ContactID in new List <int>()
                {
                    AdminContactID
                })                                                             //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
                {
                    TelController telController = new TelController(DatabaseTypeEnum.SqlServerTestDB);
                    Assert.IsNotNull(telController);
                    Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, telController.DatabaseType);

                    Tel telFirst = new Tel();
                    using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
                    {
                        TelService telService = new TelService(new Query(), db, ContactID);
                        telFirst = (from c in db.Tels select c).FirstOrDefault();
                    }

                    // ok with Tel info
                    IHttpActionResult jsonRet = telController.GetTelWithID(telFirst.TelID);
                    Assert.IsNotNull(jsonRet);

                    OkNegotiatedContentResult <Tel> Ret = jsonRet as OkNegotiatedContentResult <Tel>;
                    Tel telRet = Ret.Content;
                    Assert.AreEqual(telFirst.TelID, telRet.TelID);

                    BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
                    Assert.IsNull(badRequest);

                    // Not Found
                    IHttpActionResult jsonRet2 = telController.GetTelWithID(0);
                    Assert.IsNotNull(jsonRet2);

                    OkNegotiatedContentResult <Tel> telRet2 = jsonRet2 as OkNegotiatedContentResult <Tel>;
                    Assert.IsNull(telRet2);

                    NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
                    Assert.IsNotNull(notFoundRequest);
                }
            }
        }
        public IHttpActionResult Delete([FromBody] Tel tel, [FromUri] string lang = "en")
        {
            using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
            {
                TelService telService = new TelService(new Query()
                {
                    Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
                }, db, ContactID);

                if (!telService.Delete(tel))
                {
                    return(BadRequest(String.Join("|||", tel.ValidationResults)));
                }
                else
                {
                    tel.ValidationResults = null;
                    return(Ok(tel));
                }
            }
        }
        public void GetTelList_Test()
        {
            foreach (CultureInfo culture in AllowableCulture)
            {
                ChangeCulture(culture);

                using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
                {
                    TelService telService = new TelService(new Query()
                    {
                        Lang = culture.TwoLetterISOLanguageName
                    }, dbTestDB, ContactID);
                    Tel tel = (from c in dbTestDB.Tels select c).FirstOrDefault();
                    Assert.IsNotNull(tel);

                    List <Tel> telDirectQueryList = new List <Tel>();
                    telDirectQueryList = (from c in dbTestDB.Tels select c).Take(200).ToList();

                    foreach (string extra in new List <string>()
                    {
                        null, "A", "B", "C", "D", "E"
                    })
                    {
                        telService.Query.Extra = extra;

                        if (string.IsNullOrWhiteSpace(extra))
                        {
                            List <Tel> telList = new List <Tel>();
                            telList = telService.GetTelList().ToList();
                            CheckTelFields(telList);
                        }
                        else
                        {
                            //Assert.AreEqual(true, false);
                        }
                    }
                }
            }
        }
Example #28
0
        public AuthCodeViewModel(RegisterByOpenIdPara registerByOpenIdPara)
        {
            Tel                  = registerByOpenIdPara.tel;
            AuthCode             = string.Empty;
            SecretTel            = Tel.Substring(0, 3) + "****" + Tel.Substring(7, 4);
            AuthCodeButtonEnable = false;
            AuthLoginButtonColor = "#83d7f9";

            SendAuthCode();

            LoginCommand = new Command(() =>
            {
                RebindingWechat(registerByOpenIdPara);
            }, () => { return(true); });

            CheckInputCommand = new Command(() =>
            {
                if (AuthCode.Length == 6)
                {
                    AuthCodeButtonEnable = true;
                    AuthLoginButtonColor = "#01acf2";
                }
            }, () => { return(true); });
        }
Example #29
0
        public override string ToString()
        {
            string json = string.Concat(
                __jsonIgnore.ContainsKey("Id") ? string.Empty : string.Format(", Id : {0}", Id == null ? "null" : Id.ToString()),
                __jsonIgnore.ContainsKey("Member_id") ? string.Empty : string.Format(", Member_id : {0}", Member_id == null ? "null" : Member_id.ToString()),
                __jsonIgnore.ContainsKey("Address") ? string.Empty : string.Format(", Address : {0}", Address == null ? "null" : string.Format("'{0}'", Address.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))),
                __jsonIgnore.ContainsKey("Create_time") ? string.Empty : string.Format(", Create_time : {0}", Create_time == null ? "null" : Create_time.Value.Subtract(new DateTime(1970, 1, 1)).TotalMilliseconds.ToString()),
                __jsonIgnore.ContainsKey("Is_default") ? string.Empty : string.Format(", Is_default : {0}", Is_default == null ? "null" : (Is_default == true ? "true" : "false")),
                __jsonIgnore.ContainsKey("Name") ? string.Empty : string.Format(", Name : {0}", Name == null ? "null" : string.Format("'{0}'", Name.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))),
                __jsonIgnore.ContainsKey("Tel") ? string.Empty : string.Format(", Tel : {0}", Tel == null ? "null" : string.Format("'{0}'", Tel.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))),
                __jsonIgnore.ContainsKey("Telphone") ? string.Empty : string.Format(", Telphone : {0}", Telphone == null ? "null" : string.Format("'{0}'", Telphone.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))),
                __jsonIgnore.ContainsKey("Zip") ? string.Empty : string.Format(", Zip : {0}", Zip == null ? "null" : string.Format("'{0}'", Zip.Replace("\\", "\\\\").Replace("\r\n", "\\r\\n").Replace("'", "\\'"))), " }");

            return(string.Concat("{", json.Substring(1)));
        }
        public void Tel_Properties_Test()
        {
            foreach (CultureInfo culture in AllowableCulture)
            {
                ChangeCulture(culture);

                using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
                {
                    TelService telService = new TelService(new Query()
                    {
                        Lang = culture.TwoLetterISOLanguageName
                    }, dbTestDB, ContactID);

                    int count = 0;
                    if (count == 1)
                    {
                        // just so we don't get a warning during compile [The variable 'count' is assigned but its value is never used]
                    }

                    count = telService.GetTelList().Count();

                    Tel tel = GetFilledRandomTel("");

                    // -------------------------------
                    // -------------------------------
                    // Properties testing
                    // -------------------------------
                    // -------------------------------


                    // -----------------------------------
                    // [Key]
                    // Is NOT Nullable
                    // tel.TelID   (Int32)
                    // -----------------------------------

                    tel       = null;
                    tel       = GetFilledRandomTel("");
                    tel.TelID = 0;
                    telService.Update(tel);
                    Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "TelID"), tel.ValidationResults.FirstOrDefault().ErrorMessage);

                    tel       = null;
                    tel       = GetFilledRandomTel("");
                    tel.TelID = 10000000;
                    telService.Update(tel);
                    Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "Tel", "TelID", tel.TelID.ToString()), tel.ValidationResults.FirstOrDefault().ErrorMessage);


                    // -----------------------------------
                    // Is NOT Nullable
                    // [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Tel)]
                    // tel.TelTVItemID   (Int32)
                    // -----------------------------------

                    tel             = null;
                    tel             = GetFilledRandomTel("");
                    tel.TelTVItemID = 0;
                    telService.Add(tel);
                    Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "TelTVItemID", tel.TelTVItemID.ToString()), tel.ValidationResults.FirstOrDefault().ErrorMessage);

                    tel             = null;
                    tel             = GetFilledRandomTel("");
                    tel.TelTVItemID = 1;
                    telService.Add(tel);
                    Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "TelTVItemID", "Tel"), tel.ValidationResults.FirstOrDefault().ErrorMessage);


                    // -----------------------------------
                    // Is NOT Nullable
                    // [StringLength(50))]
                    // tel.TelNumber   (String)
                    // -----------------------------------

                    tel = null;
                    tel = GetFilledRandomTel("TelNumber");
                    Assert.AreEqual(false, telService.Add(tel));
                    Assert.AreEqual(1, tel.ValidationResults.Count());
                    Assert.IsTrue(tel.ValidationResults.Where(c => c.ErrorMessage == string.Format(CSSPServicesRes._IsRequired, "TelNumber")).Any());
                    Assert.AreEqual(null, tel.TelNumber);
                    Assert.AreEqual(count, telService.GetTelList().Count());

                    tel           = null;
                    tel           = GetFilledRandomTel("");
                    tel.TelNumber = GetRandomString("", 51);
                    Assert.AreEqual(false, telService.Add(tel));
                    Assert.AreEqual(string.Format(CSSPServicesRes._MaxLengthIs_, "TelNumber", "50"), tel.ValidationResults.FirstOrDefault().ErrorMessage);
                    Assert.AreEqual(count, telService.GetTelList().Count());

                    // -----------------------------------
                    // Is NOT Nullable
                    // [CSSPEnumType]
                    // tel.TelType   (TelTypeEnum)
                    // -----------------------------------

                    tel         = null;
                    tel         = GetFilledRandomTel("");
                    tel.TelType = (TelTypeEnum)1000000;
                    telService.Add(tel);
                    Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "TelType"), tel.ValidationResults.FirstOrDefault().ErrorMessage);


                    // -----------------------------------
                    // Is NOT Nullable
                    // [CSSPAfter(Year = 1980)]
                    // tel.LastUpdateDate_UTC   (DateTime)
                    // -----------------------------------

                    tel = null;
                    tel = GetFilledRandomTel("");
                    tel.LastUpdateDate_UTC = new DateTime();
                    telService.Add(tel);
                    Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), tel.ValidationResults.FirstOrDefault().ErrorMessage);
                    tel = null;
                    tel = GetFilledRandomTel("");
                    tel.LastUpdateDate_UTC = new DateTime(1979, 1, 1);
                    telService.Add(tel);
                    Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), tel.ValidationResults.FirstOrDefault().ErrorMessage);

                    // -----------------------------------
                    // Is NOT Nullable
                    // [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Contact)]
                    // tel.LastUpdateContactTVItemID   (Int32)
                    // -----------------------------------

                    tel = null;
                    tel = GetFilledRandomTel("");
                    tel.LastUpdateContactTVItemID = 0;
                    telService.Add(tel);
                    Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", tel.LastUpdateContactTVItemID.ToString()), tel.ValidationResults.FirstOrDefault().ErrorMessage);

                    tel = null;
                    tel = GetFilledRandomTel("");
                    tel.LastUpdateContactTVItemID = 1;
                    telService.Add(tel);
                    Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), tel.ValidationResults.FirstOrDefault().ErrorMessage);


                    // -----------------------------------
                    // Is NOT Nullable
                    // [NotMapped]
                    // tel.HasErrors   (Boolean)
                    // -----------------------------------

                    // No testing requied

                    // -----------------------------------
                    // Is NOT Nullable
                    // [NotMapped]
                    // tel.ValidationResults   (IEnumerable`1)
                    // -----------------------------------

                    // No testing requied
                }
            }
        }