public static void Create(EntityUser user)
        {
            string columns = BuilderColumnsAndValuesUser.GetColumnsToCreate();
            string values  = BuilderColumnsAndValuesUser.GetValuesToCreate(user);

            SqlCommandInsert.Execute(tableName, columns.ToString(), values.ToString());
        }
        public static void Create(DbEntityProduct dbEntity)
        {
            string columns = "ProductName,ProductPrice,Stock,CreatedBy";
            string values  = $"'{dbEntity.ProductName}','{dbEntity.ProductPrice}','{dbEntity.Stock}','{dbEntity.CreatedBy}'";

            SqlCommandInsert <DbEntityProduct> .Execute(dbEntity, tableName, columns, values);
        }
Exemple #3
0
        public static void Create(DbEntityClient dbEntity)
        {
            string columns = "Dni,Name,CreatedBy";
            string values  = $"'{dbEntity.Dni}','{dbEntity.Name}','{dbEntity.CreatedBy}'";

            SqlCommandInsert <DbEntityClient> .Execute(dbEntity, tableName, columns, values);
        }
Exemple #4
0
        public static void Create(EntitySensitiveInformation sensitiveInformation)
        {
            string columns = BuilderColumnsValuesSensitiveInformation
                             .GetColumnsToCreate();
            string values = BuilderColumnsValuesSensitiveInformation
                            .GetValuesToCreate(sensitiveInformation);

            SqlCommandInsert.Execute(tableName, columns.ToString(), values.ToString());
        }
        public static void Create(DbEntityUser dbEntityUser)
        {
            string columns = "Dni,Name,Lastname,BirthDate,Address,PhoneNumber,Email,Username,Password,CreatedBy";
            string values  = $"'{dbEntityUser.Dni}','{dbEntityUser.Name}','{dbEntityUser.Lastname}'," +
                             $"'{dbEntityUser.BirthDate}','{dbEntityUser.Address}','{dbEntityUser.PhoneNumber}'," +
                             $"'{dbEntityUser.Email}','{dbEntityUser.Username}','{dbEntityUser.Password}','{dbEntityUser.CreatedBy}'";

            SqlCommandInsert <DbEntityUser> .Execute(dbEntityUser, tableName, columns, values);
        }