public void Create(CreateBlockCommand command)
{
_db.Connection().Execute(
"spCreateBlock",
new
{
id = command.Id,
description = command.Description,
idCollege = command.IdCollege
},
commandType: CommandType.StoredProcedure
);
}
public void Create(CreateClassRoomCommand command)
{
_db.Connection().Execute(
"spCreateClassRoom",
new
{
id = command.Id,
description = command.Description,
status = command.Status,
type = command.Type,
idBlock = command.IdBlock
},
commandType: CommandType.StoredProcedure
);
}
public bool Create(Category category)
{
int affectedRows = _db.Connection().Execute(
"insert into [Category] (Id, Title, Description, CreatedAt, UpdatedAt) values(@id, @title, @description, @createdAt, @updatedAt)",
new
{
id = category.Id,
title = category.Title,
description = category.Description,
createdAt = category.CreatedAt,
updatedAt = category.UpdatedAt
}
);
return(affectedRows > 0);
}
public bool Create(Gender gender)
{
int affectedRows = _db.Connection().Execute(
"insert into [Gender] (Id, Title, Description, CreatedAt, UpdatedAt) values(@id, @title, " +
"@description, @createdAt, @updatedAt)",
new
{
id = gender.Id,
title = gender.Title,
description = gender.Description,
createdAt = gender.CreatedAt,
updatedAt = gender.UpdatedAt
}
);
return(affectedRows > 0);
}
public void Create(CreateProfessorCommand Command)
{
_db.Connection().Execute(
"spCreateProfessor",
new
{
id = Command.Id,
firstName = Command.FirstName,
lastName = Command.LastName,
document = Command.Document,
email = Command.Email,
phone = Command.Phone,
status = Command.Status,
idCourse = Command.IdCourse
},
commandType: CommandType.StoredProcedure
);
}
public bool Create(Album album)
{
int affectedRows = _db.Connection().Execute(
"insert into [Album](Id, Title, GenderId, CategoryId, Image, CreatedAt, UpdatedAt)" +
"values(@id, @title, @genderId, @categoryId, @image, @createdAt, @updatedAt)",
new
{
id = album.Id,
title = album.Title,
genderId = album.Gender.Id,
categoryId = album.Category.Id,
image = album.Image,
createdAt = album.CreatedAt,
updatedAt = album.UpdatedAt
}
);
return(affectedRows > 0);
}
public bool Create(Singer singer)
{
int affectedRows = _db.Connection().Execute(
"insert into [Singer](Id, FirstName, LastName, Nationality, About, Image, CreatedAt, UpdatedAt) " +
"values(@id, @firstName, @lastName, @nationality, @about, @image, @createdAt, @updatedAt)",
new
{
id = singer.Id,
firstName = singer.Name.FirstName,
lastName = singer.Name.LastName,
nationality = singer.Nationality,
about = singer.About,
image = singer.Image,
createdAt = singer.CreatedAt,
updatedAt = singer.UpdatedAt
}
);
return(affectedRows > 0);
}
public void Book(Guid id)
{
_db.Connection().Execute(
"spBookHeritage",
new
{
id = id
},
commandType: CommandType.StoredProcedure
);
}
public void Book(Equipment equipment)
{
_db.Connection().Execute(
"spBookEquipment",
new
{
id = equipment.Id,
status = equipment.Status
},
commandType: CommandType.StoredProcedure
);
}
public bool ChangeStatus(Guid id, int status)
{
int affectedRows = _db.Connection().Execute(
"update [User] set Status = @status where Id = @id",
new
{
id = id,
status = status
}
);
return(affectedRows > 0);
}
public void Create(User user)
{
_db.Connection().Execute(
"spCreateUser",
new
{
id = user.Id,
firstName = user.Name.FirstName,
lastName = user.Name.LastName,
document = user.Document.Number,
email = user.Email.Address,
password = user.Password.Value,
phone = user.Phone,
status = user.Status,
image = user.Image
},
commandType: CommandType.StoredProcedure
);
}
public void Create(Project project)
{
_db.Connection().Execute(
"spCreateProject",
new
{
id = project.Id,
title = project.Title,
description = project.Description,
createdAt = project.CreatedAt,
updatedAt = project.UpdatedAt,
ownerId = project.Owner.Id,
status = project.Status
},
commandType: CommandType.StoredProcedure
);
}
public bool Create(Song song)
{
int affectedRows = _db.Connection().Execute(
"insert into [Song](Id, Title, SingerId, AlbumId, Url, DownloadCounter, PublishedDate, CreatedAt, UpdatedAt) " +
"values(@id, @title, @singerId, @albumId, @url, @downloadCounter, @publishedDate, @createdAt, @updatedAt)",
new
{
id = song.Id,
title = song.Title,
singerId = song.Singer.Id,
albumId = song.Album.Id,
url = song.Url,
downloadCounter = song.DownloadCounter,
publishedDate = song.PublishedDate,
createdAt = song.CreatedAt,
updatedAt = song.UpdatedAt
}
);
return(affectedRows > 0);
}
public void Create(College college)
{
_db.Connection().Execute(
"spCreateCollege",
new
{
id = college.Id,
firstName = college.Name.FirstName,
lastName = college.Name.LastName,
document = college.Document.Number,
email = college.Email.Address,
phone = college.Phone,
image = college.Image
},
commandType: CommandType.StoredProcedure
);
foreach (var address in college.Addresses)
{
_db.Connection().Execute(
"spCreateAddress",
new
{
id = address.Id,
street = address.Street,
number = address.Number,
district = address.District,
city = address.City,
state = address.State,
zipCode = address.ZipCode,
country = address.Country,
idOwner = college.Id
},
commandType: CommandType.StoredProcedure
);
}
}
