Ejemplo n.º 1
0
        public static int Create(DomainModel.FieldConfigurationMode data, int auditId)
        {
            var sql        = Save(data, auditId, "Create");
            var AEFLModeId = DataAccess.DBDML.RunScalarSQL("FieldConfigurationMode.Insert", sql, DataStoreKey);

            return(Convert.ToInt32(AEFLModeId));
        }
Ejemplo n.º 2
0
        private static string Save(DomainModel.FieldConfigurationMode data, int auditId, string sqlcmd)
        {
            var sql = "EXEC ";

            switch (sqlcmd)
            {
            case "Create":
                sql += "dbo.FieldConfigurationModeInsert  " +
                       " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
                       ", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId);
                break;

            case "Update":
                sql += "dbo.FieldConfigurationModeUpdate  " +
                       " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId);
                break;

            default:
                break;
            }

            sql = sql + ", " + ToSQLParameter(data, DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId) +
                  ", " + ToSQLParameter(data, StandardModel.StandardDataColumns.Name) +
                  ", " + ToSQLParameter(data, StandardModel.StandardDataColumns.Description) +
                  ", " + ToSQLParameter(data, StandardModel.StandardDataColumns.SortOrder);
            return(sql);
        }
Ejemplo n.º 3
0
        public static List <DomainModel.FieldConfigurationMode> GetEntityDetails(DomainModel.FieldConfigurationMode data, int auditId)
        {
            var sql = "EXEC dbo.FieldConfigurationModeDetails " +
                      " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
                      ", " + ToSQLParameter(data, DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId);

            var result = new List <DomainModel.FieldConfigurationMode>();

            using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
            {
                var dbReader = reader.DBReader;

                while (dbReader.Read())
                {
                    var dataItem = new DomainModel.FieldConfigurationMode();

                    dataItem.FieldConfigurationModeId = (int)dbReader[DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId];

                    SetStandardInfo(dataItem, dbReader);

                    /*BaseData.SetBaseInfo(dataItem, dbReader);
                     */
                    result.Add(dataItem);
                }
            }

            return(result);
        }
Ejemplo n.º 4
0
        public static void Delete(DomainModel.FieldConfigurationMode data, int auditId)
        {
            var sql = "EXEC dbo.FieldConfigurationModeDelete " +
                      " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
                      ", " + ToSQLParameter(data, DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId);

            DataAccess.DBDML.RunSQL("FieldConfigurationMode.Delete", sql, DataStoreKey);
        }
Ejemplo n.º 5
0
        public static DataTable GetDetails(DomainModel.FieldConfigurationMode data, int auditId)
        {
            var sql = "EXEC dbo.FieldConfigurationModeDetails " +
                      " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
                      ", " + ToSQLParameter(data, DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId);

            var oDT = new DataAccess.DBDataTable("FieldConfigurationMode.Details", sql, DataStoreKey);

            return(oDT.DBTable);
        }
Ejemplo n.º 6
0
        public static DataTable DoesExist(DomainModel.FieldConfigurationMode data, int auditId)
        {
            var sql = "EXEC dbo.FieldConfigurationModeDoesExist " +
                      " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
                      ", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
                      ", " + ToSQLParameter(data, DomainModel.FieldConfigurationMode.DataColumns.Name);

            var oDT = new DataAccess.DBDataTable("FieldConfigurationMode.DoesExist", sql, DataStoreKey);

            return(oDT.DBTable);
        }
Ejemplo n.º 7
0
        public static DataTable Search(DomainModel.FieldConfigurationMode data, int auditId)
        {
            // formulate SQL
            var sql = "EXEC dbo.FieldConfigurationModeSearch " +
                      " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
                      ", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
                      ", " + ToSQLParameter(data, DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId) +
                      ", " + ToSQLParameter(data, StandardModel.StandardDataColumns.Name);

            var oDT = new DataAccess.DBDataTable("FieldConfigurationMode.Search", sql, DataStoreKey);

            return(oDT.DBTable);
        }
Ejemplo n.º 8
0
        public static int?GetFCModeIdByName(string name, int auditId)
        {
            int?fcModeId = null;

            var obj = new DomainModel.FieldConfigurationMode();

            obj.Name = name;

            // formulate SQL
            var sql = "EXEC dbo.FieldConfigurationModeSearch " +
                      " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
                      ", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
                      ", " + ToSQLParameter(obj, StandardModel.StandardDataColumns.Name);

            var oDT = new DataAccess.DBDataTable("FieldConfigurationMode.Search", sql, DataStoreKey);

            if (oDT.DBTable != null && oDT.DBTable.Rows.Count > 0)
            {
                fcModeId = Convert.ToInt32(oDT.DBTable.Rows[0][DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId]);
            }
            return(fcModeId);
        }
Ejemplo n.º 9
0
        public static string ToSQLParameter(DomainModel.FieldConfigurationMode data, string dataColumnName)
        {
            var returnValue = "NULL";

            switch (dataColumnName)
            {
            case DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId:
                if (data.FieldConfigurationModeId != null)
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId, data.FieldConfigurationModeId);
                }
                else
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationMode.DataColumns.FieldConfigurationModeId);
                }
                break;

            default:
                returnValue = StandardClass.ToSQLParameter(data, dataColumnName);
                break;
            }

            return(returnValue);
        }
Ejemplo n.º 10
0
        public static void Update(DomainModel.FieldConfigurationMode data, int auditId)
        {
            var sql = Save(data, auditId, "Update");

            DataAccess.DBDML.RunSQL("FieldConfigurationMode.Update", sql, DataStoreKey);
        }