Esempio n. 1
0
        public static bool AddEntAppConfig(DbConnection dbConn, uas_EntAppConfig eac)
        {
            DbDataReader reader = null;

            try
            {
                int maxEntAppConfigId = -1;

                using (DbCommand command = dbConn.CreateCommand())
                {
                    command.CommandText = "SELECT MAX(EntAppConfigId) FROM [dbo].[uas_EntAppConfig] ";
                    command.CommandType = CommandType.Text;

                    reader = command.ExecuteReader();
                    reader.Read();
                    if (!reader.IsDBNull(0))
                    {
                        maxEntAppConfigId = reader.GetInt32(0);
                    }
                    reader.Close();
                }

                if (maxEntAppConfigId == -1)
                {
                    throw new Exception("* * * AddEntAppConfig: Failed to retrieve an unused EntAppConfigId");
                }

                using (DbCommand command = dbConn.CreateCommand())
                {
                    command.CommandText = "INSERT INTO [dbo].[uas_EntAppConfig] "
                                          + "([EntAppConfigId],[EnterpriseID],[ApplicationID],[EnumCode],[baseTypeId],[ConfigName],[ConfigValue],[CreatedDate],[CreatedBy],[StatusFlag]) "
                                          + "VALUES("
                                          + (maxEntAppConfigId + 1) + ","
                                          + eac.EnterpriseID + ","
                                          + eac.ApplicationID + ","
                                          + "'" + eac.EnumCode + "',"
                                          + eac.baseTypeId + ","
                                          + "'" + eac.ConfigName + "',"
                                          + "'" + eac.ConfigValue + "',"
                                          + "'" + eac.CreatedDate + "',"
                                          + eac.CreatedBy + ","
                                          + "'" + eac.StatusFlag + "')";
                    command.CommandType = CommandType.Text;
                    reader = command.ExecuteReader();
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("* * *  AddEntAppConfig  Exception: " + ex.Message);
                throw;
            }

            return(true);
        }
Esempio n. 2
0
        /// <summary>
        /// Retrieve a uas_EntAppConfig Record
        ///
        /// Used in venture mode SharedValidation, to retrieve a pre-computed list of required def_ItemVariable identifiers
        /// </summary>
        /// <param name="dbConn"></param>
        /// <param name="enumCode"></param>
        /// <param name="enterpriseID"></param>
        /// <returns></returns>
        public static uas_EntAppConfig GetEntAppConfig(DbConnection dbConn, string enumCode, int enterpriseID)
        {
            uas_EntAppConfig result = null;
            DbDataReader     reader = null;

            try
            {
                using (DbCommand command = dbConn.CreateCommand())
                {
                    command.CommandText = "SELECT EntAppConfigId,EnterpriseID,ApplicationID,EnumCode,"
                                          + "baseTypeId,ConfigName,ConfigValue,CreatedDate,CreatedBy,StatusFlag FROM [dbo].uas_EntAppConfig WHERE EnumCode = '" + enumCode + "' AND EnterpriseID = " + enterpriseID;
                    command.CommandType = CommandType.Text;

                    reader = command.ExecuteReader();
                    reader.Read();
                    if (!reader.IsDBNull(0))
                    {
                        Debug.WriteLine("* * *  GetEntAppConfig uas_EntAppConfig FieldCount: " + reader.FieldCount.ToString());
                        result = new uas_EntAppConfig();
                        result.EntAppConfigId = reader.GetInt32(0);
                        result.EnterpriseID   = reader.GetInt32(1);
                        result.ApplicationID  = reader.GetInt32(2);
                        result.EnumCode       = reader["EnumCode"].ToString();
                        result.baseTypeId     = reader.GetInt16(4);
                        result.ConfigName     = reader["ConfigName"].ToString();
                        result.ConfigValue    = reader["ConfigValue"].ToString();
                        result.CreatedDate    = Convert.ToDateTime(reader["CreatedDate"].ToString());
                        result.CreatedBy      = reader.GetInt32(8);
                        result.StatusFlag     = reader["StatusFlag"].ToString();
                    }
                    reader.Close();
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("* * *  GetEntAppConfig  Exception: " + ex.Message);
                throw;
            }

            return(result);
        }
Esempio n. 3
0
        public static List <ItemVariableIdentifierWithPartSection> GetRequiredItemVarsWithPartsSections(IFormsRepository formsRepo, def_Forms frm, int enterpriseId)
        {
            //if not in venture mode, get the required item vars as normal (without touching uas_EntApConfig)
            if (!SessionHelper.IsVentureMode)
            {
                return(ComputeRequiredItemVarsWithPartsSections(formsRepo, frm, enterpriseId));
            }

            string configEnumCode = "Required_ItemVariables_FormId_" + frm.formId;

            //attempt to query a pre-computed list of item variabel identifiers from the local Venture DB
            uas_EntAppConfig eac = null;

            using (DbConnection connection = UasAdo.GetUasAdoConnection())
            {
                connection.Open();
                eac = UasAdo.GetEntAppConfig(connection, configEnumCode, enterpriseId);
            }

            //if no pre-computed list was found, create it now and insert it into the local Venture DB so it can be quickly retrieved next time
            if (eac == null || String.IsNullOrWhiteSpace(eac.ConfigValue))
            {
                List <ItemVariableIdentifierWithPartSection> requiredIvs = ComputeRequiredItemVarsWithPartsSections(formsRepo, frm, enterpriseId);
                string configValueString = String.Empty;
                foreach (ItemVariableIdentifierWithPartSection ivps in requiredIvs)
                {
                    configValueString += ivps.partId + "," + ivps.sectionId + "," + ivps.itemVariableIdentifier + ";";
                }

                using (DbConnection connection = UasAdo.GetUasAdoConnection())
                {
                    connection.Open();
                    UasAdo.AddEntAppConfig(connection, new uas_EntAppConfig()
                    {
                        EnterpriseID  = enterpriseId,
                        ApplicationID = UAS.Business.Constants.APPLICATIONID,
                        EnumCode      = configEnumCode,
                        baseTypeId    = 14,
                        ConfigName    = "Required ItemVariable Identifiers for Form " + frm.identifier,
                        ConfigValue   = configValueString,
                        CreatedDate   = DateTime.Now,
                        CreatedBy     = 1,
                        StatusFlag    = "A"
                    });
                }
                return(requiredIvs);
            }

            //if a pre-computed list was found in the local Venture DB, parse identifiers, partIds, sectionIds from the configValue
            List <ItemVariableIdentifierWithPartSection> result = new List <ItemVariableIdentifierWithPartSection>();

            string[] chunks = eac.ConfigValue.Split(';');
            foreach (string chunk in chunks)
            {
                if (String.IsNullOrWhiteSpace(chunk))
                {
                    continue;
                }
                try
                {
                    string[] subChunks = chunk.Split(',');
                    result.Add(new ItemVariableIdentifierWithPartSection
                    {
                        partId    = Convert.ToInt32(subChunks[0]),
                        sectionId = Convert.ToInt32(subChunks[1]),
                        itemVariableIdentifier = subChunks[2]
                    });
                }
                catch (Exception e)
                {
                    throw new Exception("Error converting string \"" + chunk + "\" into ItemVariableIdentifierWithPartSection", e);
                }
            }

            return(result);
        }