CREATE TABLE [dbo].[Records] (
  [id] int IDENTITY(1, 1) NOT NULL,
  [Title] nvarchar(150) COLLATE Ukrainian_CI_AS NOT NULL,
  [Text] nvarchar(max) COLLATE Ukrainian_CI_AS NOT NULL,
  [Type] int NOT NULL,
  [Category] int NULL,
  [DateTimePublish] datetime NOT NULL,
  [DateTimeActivate] smalldatetime NULL,
  [User_id] int NOT NULL,
  [is_publish] bit CONSTRAINT [DF_Records_is_publish] DEFAULT 0 NOT NULL,
  [PathThumbnail] nvarchar(50) COLLATE Ukrainian_CI_AS NULL,
  [Anonse] nvarchar(150) COLLATE Ukrainian_CI_AS NULL, 
  [Approve] bit NULL,
  [Deleted] bit DEFAULT 0 NULL,
  [Views] int NULL, 
  [Uniq] bit DEFAULT 0 NOT NULL,
   varchar(300) COLLATE Ukrainian_CI_AS NULL,
  [Section] int DEFAULT 5 NOT NULL,
  [CommentsOpen] bit DEFAULT 1 NOT NULL,
  CONSTRAINT [PK_Records] PRIMARY KEY CLUSTERED ([id]),
  CONSTRAINT [FK_Records_CategoriesRecord] FOREIGN KEY ([Category]) 
  REFERENCES [dbo].[CategoriesRecord] ([id]) 
  ON UPDATE NO ACTION
  ON DELETE NO ACTION,
  CONSTRAINT [FK_Records_TypesRecord] FOREIGN KEY ([Type]) 
  REFERENCES [dbo].[TypesRecord] ([id]) 
  ON UPDATE NO ACTION
  ON DELETE NO ACTION,
  CONSTRAINT [FK_Records_Users] FOREIGN KEY ([User_id]) 
  REFERENCES [dbo].[UserProfile] ([id]) 
  ON UPDATE NO ACTION
  ON DELETE NO ACTION
)

CREATE TABLE [dbo].[SEO] (
  [id] int IDENTITY(1, 1) NOT NULL,
  [id_record] int NOT NULL,
  [Title] varchar(150) COLLATE Ukrainian_CI_AS NULL,
  [Keywords] varchar(150) COLLATE Ukrainian_CI_AS NULL,
  [Description] varchar(250) COLLATE Ukrainian_CI_AS NULL,
  [Direct] bit NULL,
  PRIMARY KEY CLUSTERED ([id]),
  UNIQUE ([id_record]),
  CONSTRAINT [SEO_fk_record] FOREIGN KEY ([id_record]) 
  REFERENCES [dbo].[Records] ([id]) 
  ON UPDATE NO ACTION
  ON DELETE NO ACTION
)

 public Record GetRecordById(int id_record, bool? ViewPlus = false) 
        {          


            if (db == null) { db = new T_DLL.Model.TDBEntities(); }
			
            //возвращаем 1 дб объект
            var record = (from rec in db.Records
                           join usr in db.UserProfiles on rec.User_id equals usr.id
                           join typ in db.TypesRecord on rec.Type equals typ.id
                           join cat in db.CategoriesRecord on rec.Category equals cat.id
                           join seo_source in db.SEOs on rec.id equals seo_source.id_record 
                           into t1
                           from seo in t1.DefaultIfEmpty()
                           where rec.id == id_record && rec.Deleted == false
                           select new { record = rec, user = usr, TypeName = typ, PathImgCategory = cat, seo = seo }).FirstOrDefault();

            
           
              //УВЕЛИЧИМ ПРОСМОТР ЕСЛИ ИСТИНА
            if (ViewPlus == true)
            {
                ViewPlusM(record.record.id);                 
            }
          

                 
            return   MapToRecordsBLLseo(record.record, record.user, record.TypeName, record.PathImgCategory, record.seo); 
        }



        public void ViewPlusM(int id_record) 
        {                   
             
                


                using (var db = new T_DLL.Model.TDBEntities())
                {

                    string sql = "update Records set Views = @Views_Now where id = @id_rec";
                    
                    List<System.Data.SqlClient.SqlParameter> parameterList = new List<System.Data.SqlClient.SqlParameter>();

                    parameterList.Add(new System.Data.SqlClient.SqlParameter("@id_rec", id_record));                  
                  
                    System.Data.SqlClient.SqlParameter[] parameters = parameterList.ToArray();

                    int result = db.Database.ExecuteSqlCommand(sql, parameters);                     

                }

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE dbo.AddView @id_rec int
AS
BEGIN

update Records

SET Views = Views + ABS(Checksum(NewID()) % 3) + 2
 
where id = @id_rec
 

END