public ReturnType AddEmailTemplate(EmailTemplate emailtemplate)
        {
            try
            {
                using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
                {

                    alading.AddToEmailTemplate(emailtemplate);
                    if (alading.SaveChanges() == 1)
                    {
                        return ReturnType.Success;
                    }
                    else
                    {
                        return ReturnType.PropertyExisted;
                    }
                }
            }
            catch (SqlException sex)
            {
                return ReturnType.ConnFailed;
            }
            catch (Exception ex)
            {
                return ReturnType.OthersError;
            }
        }
 public ReturnType AddEmailTemplate(List<EmailTemplate> emailtemplateList)
 {
     try
     {
         using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
         {
             foreach (EmailTemplate emailtemplate in emailtemplateList)
             {
                 alading.AddToEmailTemplate(emailtemplate);
             }
             alading.SaveChanges();
             return ReturnType.Success;
         }
     }
     catch (SqlException sex)
     {
         return ReturnType.ConnFailed;
     }
     catch (Exception ex)
     {
         return ReturnType.OthersError;
     }
 }