Welcome to the Lounge

/==================================================================================================
// Source object: AEF2.dbo.Alerts (table)
// File generated: 2020.11.27, 01:03:07

// This file was generated by EntityFactory. Do not modify this file. When regenerated, the file    
// may be overwritten if it already exists (and EntityFactory was configured to overwrite existing   
// files). Note that the generated class is "partial", so if you need to augment the generated    
// code, create a new partial extension file and put your custom code in that new file.             

// The class name indicates the model (or viewmodel) class name prefix followed by the name of the  
// original database object from which the class was generated.                                     
//==================================================================================================

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

// Auto-incrementing column detected - added the following using to support standard C# attributes.
// If you haven't already, add a reference to System.ComponentModel.DataAnnotations to the 
// applicable assembly in your application.
using System.ComponentModel.DataAnnotations;

namespace Models
{
    public partial class EntityAlerts
    {
        #region entity properties

        [Key]
        public int      ID               { get; set; }
        public string   AlertName        { get; set; }
        public string   AlertTitle       { get; set; }
        public string   AlertMsg         { get; set; }
        public DateTime AlertStartDate   { get; set; }
        public DateTime AlertExpireDate  { get; set; }
        public int      AlertType        { get; set; }
        public int      AlertClassLevel  { get; set; }
        public string   AlertApps        { get; set; }
        public string   ActionName       { get; set; }
        public string   ControllerName   { get; set; }
        public DateTime DateAdded        { get; set; }
        public int      AddedByUMSUserID { get; set; }

        #endregion entity properties


        #region database properties

        public string CRUDGet
        {
            get
            {
                return "SELECT [ID], [AlertName], [AlertTitle], [AlertMsg], [AlertStartDate],"
                        +" [AlertExpireDate], [AlertType], [AlertClassLevel], [AlertApps], [ActionName],"
                        +" [ControllerName], [DateAdded], [AddedByUMSUserID] FROM [dbo].[Alerts]"
                        +" WITH(NOLOCK);";
            }
        }

        public string CRUDUpsert
        {
            get
            {
                return "UPDATE [dbo].[Alerts] SET [AlertName] = @AlertName , [AlertTitle] ="
                        +" @AlertTitle , [AlertMsg] = @AlertMsg , [AlertStartDate] = @AlertStartDate ,"
                        +" [AlertExpireDate] = @AlertExpireDate , [AlertType] = @AlertType ,"
                        +" [AlertClassLevel] = @AlertClassLevel , [AlertApps] = @AlertApps , [ActionName]"
                        +" = @ActionName , [ControllerName] = @ControllerName , [DateAdded] = @DateAdded"
                        +" , [AddedByUMSUserID] = @AddedByUMSUserID WHERE [ID] = @ID;"
                        +" IF @@ROWCOUNT = 0"
                        +" INSERT INTO [dbo].[Alerts] ( [AlertName] , [AlertTitle] , [AlertMsg] ,"
                        +" [AlertStartDate] , [AlertExpireDate] , [AlertType] , [AlertClassLevel] ,"
                        +" [AlertApps] , [ActionName] , [ControllerName] , [DateAdded] ,"
                        +" [AddedByUMSUserID]) VALUES ( @AlertName , @AlertTitle , @AlertMsg ,"
                        +" @AlertStartDate , @AlertExpireDate , @AlertType , @AlertClassLevel ,"
                        +" @AlertApps , @ActionName , @ControllerName , @DateAdded , @AddedByUMSUserID);";
            }
        }

        public string CRUDDelete
        {
            get
            {
                return "DELETE FROM [dbo].[Alerts] WHERE [ID] = @ID;";
            }
        }


        #endregion database properties

    }

}