Example #1
0
 public static SoftFluent.Samples.GED.Directory LoadById(System.Guid id)
 {
     if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         return(null);
     }
     SoftFluent.Samples.GED.Directory         directory   = new SoftFluent.Samples.GED.Directory();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.GED.Constants.SoftFluent_Samples_GEDStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Directory", "LoadById");
     persistence.AddRawParameter("@Id", id);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             directory.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             directory.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(directory);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #2
0
 public static SoftFluent.Samples.Thinktecture.IdentityServer.Role LoadByName(string name)
 {
     if ((name == default(string)))
     {
         return(null);
     }
     SoftFluent.Samples.Thinktecture.IdentityServer.Role role        = new SoftFluent.Samples.Thinktecture.IdentityServer.Role();
     CodeFluent.Runtime.CodeFluentPersistence            persistence = CodeFluentContext.Get(SoftFluent.Samples.Thinktecture.IdentityServer.Constants.SoftFluent_Samples_Thinktecture_IdentityServerStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Role", "LoadByName");
     persistence.AddParameter("@Name", name, default(string));
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             role.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             role.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(role);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #3
0
        public virtual bool Delete()
        {
            bool ret = false;

            CodeFluent.Runtime.CodeFluentEntityActionEventArgs evt = new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Deleting, true);
            this.OnEntityAction(evt);
            if ((evt.Cancel == true))
            {
                return(ret);
            }
            if ((this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.Deleted))
            {
                return(ret);
            }
            if ((this.RowVersion == null))
            {
                return(ret);
            }
            CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ModelCodeFluent.Constants.ModelCodeFluentStoreName).Persistence;
            persistence.CreateStoredProcedureCommand(null, "RoleClaim", "Delete");
            persistence.AddParameter("@RoleClaim_Id", this.Id, CodeFluentPersistence.DefaultGuidValue);
            persistence.AddParameter("@_rowVersion", this.RowVersion);
            persistence.ExecuteNonQuery();
            this.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Deleted;
            this.OnEntityAction(new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Deleted, false, false));
            ret = true;
            return(ret);
        }
 public static SoftFluent.Samples.AspNetIdentity2.Role Load(System.Guid id)
 {
     if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         return(null);
     }
     SoftFluent.Samples.AspNetIdentity2.Role  role        = new SoftFluent.Samples.AspNetIdentity2.Role();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity2.Constants.SoftFluent_Samples_AspNetIdentity2StoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Role", "Load");
     persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             role.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             role.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(role);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
 public static System.Data.IDataReader PageDataLoadByUser(CodeFluent.Runtime.PageOptions pageOptions, SoftFluent.Samples.AspNetIdentity1.User user)
 {
     if ((user == null))
     {
         return(null);
     }
     if ((user.Id == default(string)))
     {
         CodeFluent.Runtime.CodeFluentRuntimeException.Throw("invalidEntityKey", "Id", "user", "SoftFluent.Samples.AspNetIdentity1.User");
     }
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity1.Constants.SoftFluent_Samples_AspNetIdentity1StoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "ExternalLogin", "LoadByUser");
     persistence.AddParameter("@UserId", user.Id, default(string));
     if ((pageOptions != null))
     {
         System.Collections.IEnumerator enumerator = pageOptions.OrderByArguments.GetEnumerator();
         bool b;
         int  index = 0;
         for (b = enumerator.MoveNext(); b; b = enumerator.MoveNext())
         {
             CodeFluent.Runtime.OrderByArgument argument = ((CodeFluent.Runtime.OrderByArgument)(enumerator.Current));
             persistence.AddParameter(string.Format("@_orderBy{0}", index), argument.Name);
             persistence.AddParameter(string.Format("@_orderByDirection{0}", index), ((int)(argument.Direction)));
             index = (index + 1);
         }
     }
     System.Data.IDataReader reader = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity1.Constants.SoftFluent_Samples_AspNetIdentity1StoreName).Persistence.ExecuteReader();
     return(reader);
 }
Example #6
0
 public static SoftFluent.Samples.ExtendedSearch.Customer LoadById(int id)
 {
     if ((id == -1))
     {
         return(null);
     }
     SoftFluent.Samples.ExtendedSearch.Customer customer    = new SoftFluent.Samples.ExtendedSearch.Customer();
     CodeFluent.Runtime.CodeFluentPersistence   persistence = CodeFluentContext.Get(SoftFluent.Samples.ExtendedSearch.Constants.SoftFluent_Samples_ExtendedSearchStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Customer", "LoadById");
     persistence.AddParameter("@Id", id, ((int)(-1)));
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             customer.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             customer.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(customer);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #7
0
 public static SoftFluent.Samples.Thinktecture.IdentityServer.Login LoadById(System.Guid id)
 {
     if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         return(null);
     }
     SoftFluent.Samples.Thinktecture.IdentityServer.Login login       = new SoftFluent.Samples.Thinktecture.IdentityServer.Login();
     CodeFluent.Runtime.CodeFluentPersistence             persistence = CodeFluentContext.Get(SoftFluent.Samples.Thinktecture.IdentityServer.Constants.SoftFluent_Samples_Thinktecture_IdentityServerStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Login", "LoadById");
     persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             login.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             login.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(login);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
 public static System.Data.IDataReader PageDataLoadSpacesSupportBySupport(CodeFluent.Runtime.PageOptions pageOptions, SoftFluent.Json.NET.Support support)
 {
     if ((support == null))
     {
         return(null);
     }
     if ((support.Id == -1))
     {
         CodeFluent.Runtime.CodeFluentRuntimeException.Throw("invalidEntityKey", "Id", "support", "SoftFluent.Json.NET.Support");
     }
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Space", "LoadSpacesSupportBySupport");
     persistence.AddParameter("@SupportId", support.Id, ((int)(-1)));
     if ((pageOptions != null))
     {
         System.Collections.IEnumerator enumerator = pageOptions.OrderByArguments.GetEnumerator();
         bool b;
         int  index = 0;
         for (b = enumerator.MoveNext(); b; b = enumerator.MoveNext())
         {
             CodeFluent.Runtime.OrderByArgument argument = ((CodeFluent.Runtime.OrderByArgument)(enumerator.Current));
             persistence.AddParameter(string.Format("@_orderBy{0}", index), argument.Name);
             persistence.AddParameter(string.Format("@_orderByDirection{0}", index), ((int)(argument.Direction)));
             index = (index + 1);
         }
     }
     System.Data.IDataReader reader = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence.ExecuteReader();
     return(reader);
 }
Example #9
0
        public static int DeleteByTypeAndValue(SoftFluent.Samples.AspNetIdentity1.User user, string type, string value)
        {
            if ((user == null))
            {
                throw new System.ArgumentNullException("user");
            }
            if ((user.Id == default(string)))
            {
                CodeFluent.Runtime.CodeFluentRuntimeException.Throw("invalidEntityKey", "Id", "user", "SoftFluent.Samples.AspNetIdentity1.User");
            }
            if ((type == default(string)))
            {
                throw new System.ArgumentNullException("type");
            }
            if ((value == default(string)))
            {
                throw new System.ArgumentNullException("value");
            }
            CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity1.Constants.SoftFluent_Samples_AspNetIdentity1StoreName).Persistence;
            persistence.CreateStoredProcedureCommand(null, "UserClaim", "DeleteByTypeAndValue");
            persistence.AddParameter("@UserId", user.Id, default(string));
            persistence.AddParameter("@Type", type, default(string));
            persistence.AddParameter("@Value", value, default(string));
            int count;

            count = persistence.ExecuteScalar(-1);
            return(count);
        }
Example #10
0
 public static SoftFluent.Samples.GED.Page LoadOneToProcess()
 {
     SoftFluent.Samples.GED.Page page = new SoftFluent.Samples.GED.Page();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.GED.Constants.SoftFluent_Samples_GEDStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Page", "LoadOneToProcess");
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             page.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             page.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(page);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #11
0
 public static ModelCodeFluent.Vehicle LoadByVehicleId(System.Guid vehicleId)
 {
     if ((vehicleId.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         return(null);
     }
     ModelCodeFluent.Vehicle vehicle = new ModelCodeFluent.Vehicle();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ModelCodeFluent.Constants.ModelCodeFluentStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Vehicle", "LoadByVehicleId");
     persistence.AddParameter("@VehicleId", vehicleId, CodeFluentPersistence.DefaultGuidValue);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             vehicle.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             vehicle.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(vehicle);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #12
0
 public static void SaveLocalizedValues(SoftFluent.Samples.RedisCache.Category entity, int lcid, bool isDefault, string name)
 {
     if ((entity == null))
     {
         throw new System.ArgumentNullException("entity");
     }
     if ((entity.Id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         CodeFluent.Runtime.CodeFluentRuntimeException.Throw("invalidEntityKey", "Id", "entity", "SoftFluent.Samples.RedisCache.Category");
     }
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.RedisCache.Constants.SoftFluent_Samples_RedisCacheStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Category", "SaveLocalizedValues");
     persistence.AddParameter("@entityId", entity.Id, CodeFluentPersistence.DefaultGuidValue);
     persistence.AddParameter("@Lcid", lcid);
     persistence.AddRawParameter("@IsDefault", isDefault);
     persistence.AddParameter("@Name", name, default(string));
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         SoftFluent.Samples.RedisCache.Category.SaveLocalizedValuesUpdateRowVersion(reader, entity, lcid, isDefault, name);
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
 }
Example #13
0
 public static SoftFluent.Samples.AspNetIdentity1.User LoadByProviderKey(string providerKey)
 {
     if ((providerKey == default(string)))
     {
         return(null);
     }
     SoftFluent.Samples.AspNetIdentity1.User  user        = new SoftFluent.Samples.AspNetIdentity1.User();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity1.Constants.SoftFluent_Samples_AspNetIdentity1StoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "User", "LoadByProviderKey");
     persistence.AddParameter("@providerKey", providerKey);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             user.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             user.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(user);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #14
0
        public virtual bool Delete()
        {
            bool ret = false;

            CodeFluent.Runtime.CodeFluentEntityActionEventArgs evt = new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Deleting, true);
            this.OnEntityAction(evt);
            if ((evt.Cancel == true))
            {
                return(ret);
            }
            if ((this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.Deleted))
            {
                return(ret);
            }
            if ((this.RowVersion == null))
            {
                return(ret);
            }
            CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity1.Constants.SoftFluent_Samples_AspNetIdentity1StoreName).Persistence;
            persistence.CreateStoredProcedureCommand(null, "User", "Delete");
            persistence.AddParameter("@User_Id", this.Id, default(string));
            persistence.AddParameter("@_rowVersion", this.RowVersion);
            persistence.ExecuteNonQuery();
            this.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Deleted;
            this.OnEntityAction(new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Deleted, false, false));
            ret = true;
            return(ret);
        }
 public static System.Data.IDataReader PageDataLoadUsersRolesByRole(CodeFluent.Runtime.PageOptions pageOptions, SoftFluent.Samples.AspNetIdentity2.Role role)
 {
     if ((role == null))
     {
         return(null);
     }
     if ((role.Id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         CodeFluent.Runtime.CodeFluentRuntimeException.Throw("invalidEntityKey", "Id", "role", "SoftFluent.Samples.AspNetIdentity2.Role");
     }
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity2.Constants.SoftFluent_Samples_AspNetIdentity2StoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "User", "LoadUsersRolesByRole");
     persistence.AddParameter("@RoleId", role.Id, CodeFluentPersistence.DefaultGuidValue);
     if ((pageOptions != null))
     {
         System.Collections.IEnumerator enumerator = pageOptions.OrderByArguments.GetEnumerator();
         bool b;
         int  index = 0;
         for (b = enumerator.MoveNext(); b; b = enumerator.MoveNext())
         {
             CodeFluent.Runtime.OrderByArgument argument = ((CodeFluent.Runtime.OrderByArgument)(enumerator.Current));
             persistence.AddParameter(string.Format("@_orderBy{0}", index), argument.Name);
             persistence.AddParameter(string.Format("@_orderByDirection{0}", index), ((int)(argument.Direction)));
             index = (index + 1);
         }
     }
     System.Data.IDataReader reader = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity2.Constants.SoftFluent_Samples_AspNetIdentity2StoreName).Persistence.ExecuteReader();
     return(reader);
 }
Example #16
0
 public static ContactManager.Address LoadByContact(int contactId)
 {
     if ((contactId == -1))
     {
         return(null);
     }
     ContactManager.Address address = new ContactManager.Address();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ContactManager.Constants.ContactManagerStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Address", "LoadByContact");
     persistence.AddParameter("@ContactId", contactId);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             address.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             address.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(address);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #17
0
 public static ContactManager.User LoadByEmail(string email)
 {
     if ((email == default(string)))
     {
         return(null);
     }
     ContactManager.User user = new ContactManager.User();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ContactManager.Constants.ContactManagerStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "User", "LoadByEmail");
     persistence.AddParameter("@Email", email, default(string));
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             user.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             user.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(user);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #18
0
 public static ModelCodeFluent.Identity.RoleClaim LoadById(System.Guid id)
 {
     if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         return(null);
     }
     ModelCodeFluent.Identity.RoleClaim       roleClaim   = new ModelCodeFluent.Identity.RoleClaim();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ModelCodeFluent.Constants.ModelCodeFluentStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "RoleClaim", "LoadById");
     persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             roleClaim.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             roleClaim.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(roleClaim);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
 public static System.Data.IDataReader PageDataLoadByContactSource(CodeFluent.Runtime.PageOptions pageOptions, SoftFluent.SqlServerInMemory.ContactSource contactSource)
 {
     if ((contactSource == null))
     {
         return(null);
     }
     if ((contactSource.Id == -1))
     {
         CodeFluent.Runtime.CodeFluentRuntimeException.Throw("invalidEntityKey", "Id", "contactSource", "SoftFluent.SqlServerInMemory.ContactSource");
     }
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.SqlServerInMemory.Constants.SoftFluent_SqlServerInMemoryStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Customer", "LoadByContactSource");
     persistence.AddParameter("@ContactSourceId", contactSource.Id, ((int)(-1)));
     if ((pageOptions != null))
     {
         System.Collections.IEnumerator enumerator = pageOptions.OrderByArguments.GetEnumerator();
         bool b;
         int  index = 0;
         for (b = enumerator.MoveNext(); b; b = enumerator.MoveNext())
         {
             CodeFluent.Runtime.OrderByArgument argument = ((CodeFluent.Runtime.OrderByArgument)(enumerator.Current));
             persistence.AddParameter(string.Format("@_orderBy{0}", index), argument.Name);
             persistence.AddParameter(string.Format("@_orderByDirection{0}", index), ((int)(argument.Direction)));
             index = (index + 1);
         }
     }
     System.Data.IDataReader reader = CodeFluentContext.Get(SoftFluent.SqlServerInMemory.Constants.SoftFluent_SqlServerInMemoryStoreName).Persistence.ExecuteReader();
     return(reader);
 }
Example #20
0
 public static SoftFluent.Json.NET.Publication LoadById(int id)
 {
     if ((id == -1))
     {
         return(null);
     }
     SoftFluent.Json.NET.Publication          publication = new SoftFluent.Json.NET.Publication();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Publication", "LoadById");
     persistence.AddParameter("@Id", id, ((int)(-1)));
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             publication.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             publication.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(publication);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
 public static System.Data.IDataReader PageDataLoadByCardNumber(CodeFluent.Runtime.PageOptions pageOptions, string cardNumber)
 {
     if ((cardNumber == default(string)))
     {
         throw new System.ArgumentNullException("cardNumber");
     }
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.EncryptAspect.Constants.SoftFluent_Samples_EncryptAspectStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Customer", "LoadByCardNumber");
     persistence.AddParameter("@CardNumber", cardNumber, default(string));
     persistence.AddParameter("@PassPhrase", SoftFluent.Samples.EncryptAspect.PassPhrase.GetPassPhrase(), default(string));
     if ((pageOptions != null))
     {
         System.Collections.IEnumerator enumerator = pageOptions.OrderByArguments.GetEnumerator();
         bool b;
         int  index = 0;
         for (b = enumerator.MoveNext(); b; b = enumerator.MoveNext())
         {
             CodeFluent.Runtime.OrderByArgument argument = ((CodeFluent.Runtime.OrderByArgument)(enumerator.Current));
             persistence.AddParameter(string.Format("@_orderBy{0}", index), argument.Name);
             persistence.AddParameter(string.Format("@_orderByDirection{0}", index), ((int)(argument.Direction)));
             index = (index + 1);
         }
     }
     System.Data.IDataReader reader = CodeFluentContext.Get(SoftFluent.Samples.EncryptAspect.Constants.SoftFluent_Samples_EncryptAspectStoreName).Persistence.ExecuteReader();
     return(reader);
 }
Example #22
0
 public static SoftFluent.SqlServerInMemory.Customer LoadById(System.Guid id)
 {
     if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         return(null);
     }
     SoftFluent.SqlServerInMemory.Customer    customer    = new SoftFluent.SqlServerInMemory.Customer();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.SqlServerInMemory.Constants.SoftFluent_SqlServerInMemoryStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Customer", "LoadById");
     persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             customer.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             customer.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(customer);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #23
0
        public virtual bool Delete()
        {
            bool ret = false;

            CodeFluent.Runtime.CodeFluentEntityActionEventArgs evt = new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Deleting, true);
            this.OnEntityAction(evt);
            if ((evt.Cancel == true))
            {
                return(ret);
            }
            if ((this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.Deleted))
            {
                return(ret);
            }
            if ((this.RowVersion == null))
            {
                return(ret);
            }
            CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
            persistence.CreateStoredProcedureCommand(null, "Publication", "Delete");
            persistence.AddParameter("@Publication_Id", this.Id, ((int)(-1)));
            persistence.AddParameter("@_rowVersion", this.RowVersion);
            persistence.ExecuteNonQuery();
            this.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Deleted;
            this.OnEntityAction(new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Deleted, false, false));
            ret = true;
            return(ret);
        }
        public virtual bool Delete()
        {
            SoftFluent.Samples.RedisCache.Product.ClearCache();
            bool ret = false;

            CodeFluent.Runtime.CodeFluentEntityActionEventArgs evt = new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Deleting, true);
            this.OnEntityAction(evt);
            if ((evt.Cancel == true))
            {
                return(ret);
            }
            if ((this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.Deleted))
            {
                return(ret);
            }
            if ((this.RowVersion == null))
            {
                return(ret);
            }
            CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.RedisCache.Constants.SoftFluent_Samples_RedisCacheStoreName).Persistence;
            persistence.CreateStoredProcedureCommand(null, "Product", "Delete");
            persistence.AddParameter("@Product_Id", this.Id, CodeFluentPersistence.DefaultGuidValue);
            persistence.AddParameter("@_rowVersion", this.RowVersion);
            persistence.ExecuteNonQuery();
            this.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Deleted;
            this.OnEntityAction(new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Deleted, false, false));
            ret = true;
            return(ret);
        }
 public static SoftFluent.Json.NET.Support LoadByName(string name)
 {
     if ((name == default(string)))
     {
         return(null);
     }
     SoftFluent.Json.NET.Support support = new SoftFluent.Json.NET.Support();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Support", "LoadByName");
     persistence.AddParameter("@Name", name, default(string));
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             support.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             support.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(support);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #26
0
 public static DigitalPicnik.List LoadById(System.Guid id)
 {
     if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         return(null);
     }
     DigitalPicnik.List list = new DigitalPicnik.List();
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(DigitalPicnik.Constants.DigitalPicnikStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "List", "LoadById");
     persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             list.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             list.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(list);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
 public static ContactManager.ContactSource LoadById(int id)
 {
     if ((id == -1))
     {
         return(null);
     }
     ContactManager.ContactSource             contactSource = new ContactManager.ContactSource();
     CodeFluent.Runtime.CodeFluentPersistence persistence   = CodeFluentContext.Get(ContactManager.Constants.ContactManagerStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "ContactSource", "LoadById");
     persistence.AddParameter("@Id", id, ((int)(-1)));
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             contactSource.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
             contactSource.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
             return(contactSource);
         }
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     return(null);
 }
Example #28
0
 public static System.Data.IDataReader PageDataLoadRolesUsersByUser(CodeFluent.Runtime.PageOptions pageOptions, ModelCodeFluent.Identity.User user)
 {
     if ((user == null))
     {
         return(null);
     }
     if ((user.Id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
     {
         CodeFluent.Runtime.CodeFluentRuntimeException.Throw("invalidEntityKey", "Id", "user", "ModelCodeFluent.Identity.User");
     }
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ModelCodeFluent.Constants.ModelCodeFluentStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Role", "LoadRolesUsersByUser");
     persistence.AddParameter("@UserId", user.Id, CodeFluentPersistence.DefaultGuidValue);
     if ((pageOptions != null))
     {
         System.Collections.IEnumerator enumerator = pageOptions.OrderByArguments.GetEnumerator();
         bool b;
         int  index = 0;
         for (b = enumerator.MoveNext(); b; b = enumerator.MoveNext())
         {
             CodeFluent.Runtime.OrderByArgument argument = ((CodeFluent.Runtime.OrderByArgument)(enumerator.Current));
             persistence.AddParameter(string.Format("@_orderBy{0}", index), argument.Name);
             persistence.AddParameter(string.Format("@_orderByDirection{0}", index), ((int)(argument.Direction)));
             index = (index + 1);
         }
     }
     System.Data.IDataReader reader = CodeFluentContext.Get(ModelCodeFluent.Constants.ModelCodeFluentStoreName).Persistence.ExecuteReader();
     return(reader);
 }
Example #29
0
 protected virtual bool BaseSave(bool force)
 {
     if ((this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.ToBeDeleted))
     {
         this.Delete();
         return(false);
     }
     CodeFluent.Runtime.CodeFluentEntityActionEventArgs evt = new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Saving, true);
     this.OnEntityAction(evt);
     if ((evt.Cancel == true))
     {
         return(false);
     }
     CodeFluentPersistence.ThrowIfDeleted(this);
     this.Validate();
     if (((force == false) &&
          (this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.Unchanged)))
     {
         return(false);
     }
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Campaign", "Save");
     persistence.AddParameter("@Campaign_Id", this.Id, ((int)(-1)));
     persistence.AddParameter("@Campaign_Name", this.Name, default(string));
     persistence.AddParameterEnumInt32("@Campaign_State", this.State, SoftFluent.Json.NET.CampaignStateType.Conceived);
     persistence.AddParameter("@Campaign_Customer_Id", this.CustomerId, ((int)(-1)));
     persistence.AddParameter("@Campaign_Price", this.Price, CodeFluentPersistence.DefaultDecimalValue);
     persistence.AddParameter("@Campaign_PriceAllTaxIncluded", this.PriceAllTaxIncluded, CodeFluentPersistence.DefaultDecimalValue);
     persistence.AddParameter("@Campaign_DiscountRate", this.DiscountRate, CodeFluentPersistence.DefaultDecimalValue);
     persistence.AddParameter("@Campaign_ConceptionDate", this.ConceptionDate, CodeFluentPersistence.DefaultDateTimeValue);
     persistence.AddParameter("@Campaign_AddressedDate", this.AddressedDate, CodeFluentPersistence.DefaultDateTimeValue);
     persistence.AddParameter("@Campaign_PropositionDate", this.PropositionDate, CodeFluentPersistence.DefaultDateTimeValue);
     persistence.AddParameter("@Campaign_ConfirmationDate", this.ConfirmationDate, CodeFluentPersistence.DefaultDateTimeValue);
     persistence.AddParameter("@_trackLastWriteUser", persistence.Context.User.Name);
     persistence.AddParameter("@_rowVersion", this.RowVersion);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             this.ReadRecordOnSave(reader);
         }
         CodeFluentPersistence.NextResults(reader);
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     this.OnEntityAction(new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Saved, false, false));
     this.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
     return(true);
 }
Example #30
0
 protected virtual bool BaseSave(bool force)
 {
     if ((this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.ToBeDeleted))
     {
         this.Delete();
         return(false);
     }
     CodeFluent.Runtime.CodeFluentEntityActionEventArgs evt = new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Saving, true);
     this.OnEntityAction(evt);
     if ((evt.Cancel == true))
     {
         return(false);
     }
     CodeFluentPersistence.ThrowIfDeleted(this);
     this.Validate();
     if (((force == false) &&
          (this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.Unchanged)))
     {
         return(false);
     }
     CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
     persistence.CreateStoredProcedureCommand(null, "Customer", "Save");
     persistence.AddParameter("@Customer_Id", this.Id, ((int)(-1)));
     persistence.AddParameter("@Customer_Name", this.Name, default(string));
     persistence.AddParameter("@Customer_Address", this.Address, default(string));
     persistence.AddParameter("@Customer_City", this.City, default(string));
     persistence.AddParameter("@Customer_ZipCode", this.ZipCode, default(string));
     persistence.AddParameter("@Customer_Country", this.Country, default(string));
     persistence.AddParameter("@Customer_Phone", this.Phone, default(string));
     persistence.AddParameter("@Customer_Fax", this.Fax, default(string));
     persistence.AddParameter("@Customer_WebSite", this.WebSite, default(string));
     persistence.AddParameterEnumInt32("@Customer_Language", this.Language, SoftFluent.Json.NET.Language.French);
     persistence.AddParameterEnumInt32("@Customer_CustomerType", this.CustomerType, SoftFluent.Json.NET.CustomerType.Client);
     persistence.AddParameter("@_trackLastWriteUser", persistence.Context.User.Name);
     persistence.AddParameter("@_rowVersion", this.RowVersion);
     System.Data.IDataReader reader = null;
     try
     {
         reader = persistence.ExecuteReader();
         if ((reader.Read() == true))
         {
             this.ReadRecordOnSave(reader);
         }
         CodeFluentPersistence.NextResults(reader);
     }
     finally
     {
         if ((reader != null))
         {
             reader.Dispose();
         }
         persistence.CompleteCommand();
     }
     this.OnEntityAction(new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Saved, false, false));
     this.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
     return(true);
 }