public void Create(Category item)
{
var parameters = new List <IDataParameter>()
{
_sqlFactory.CreateDbParameter("Name", item.Name, DbType.String)
};
var connection = _sqlFactory.CreateSqlConnection();
using (var command = _sqlFactory.CreateDbCommand(DbConstant.Command.CreateCategory, connection, CommandType.StoredProcedure, parameters))
{
command.Connection.Open();
command.ExecuteNonQuery();
}
}
public IReadOnlyCollection <Role> GetAll()
{
var collection = new List <Role>();
using (var connection = _sqlFactory.CreateSqlConnection())
{
using (var command = _sqlFactory.CreateDbCommand(DbConstant.Command.GetRolesList, connection, CommandType.StoredProcedure))
{
command.Connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var role = new Role()
{
Id = (int)reader["Id"],
Name = (string)reader["Name"]
};
collection.Add(role);
}
}
}
}
return(collection);
}
public void Create(Organizer item)
{
var parameters = new List <IDataParameter>()
{
_sqlFactory.CreateDbParameter("Name", item.Name, DbType.String),
_sqlFactory.CreateDbParameter("Email", item.Email, DbType.String),
_sqlFactory.CreateDbParameter("Phones", item.Phones, DbType.String)
};
var connection = _sqlFactory.CreateSqlConnection();
using (var command = _sqlFactory.CreateDbCommand(DbConstant.Command.CreateOrganizer, connection, CommandType.StoredProcedure, parameters))
{
command.Connection.Open();
command.ExecuteNonQuery();
}
}
public void Create(Event item)
{
var parameters = new List <IDataParameter>()
{
_sqlFactory.CreateDbParameter("Name", item.Name, DbType.String),
_sqlFactory.CreateDbParameter("Date", item.Date, DbType.DateTime),
_sqlFactory.CreateDbParameter("ImagePath", item.ImagePath, DbType.String),
_sqlFactory.CreateDbParameter("Image", item.Image, DbType.Binary),
_sqlFactory.CreateDbParameter("Address", item.Address, DbType.String),
_sqlFactory.CreateDbParameter("Description", item.Description, DbType.String),
_sqlFactory.CreateDbParameter("Location", item.Location, DbType.String),
_sqlFactory.CreateDbParameter("CategoryId", item.Category.Id, DbType.Int32),
_sqlFactory.CreateDbParameter("OrganizerId", item.Organizer.Id, DbType.Int32),
_sqlFactory.CreateDbParameter("StatusId", item.Status, DbType.Int32),
_sqlFactory.CreateDbParameter("UserId", item.UserId, DbType.Int32)
};
var connection = _sqlFactory.CreateSqlConnection();
using (var command = _sqlFactory.CreateDbCommand(DbConstant.Command.CreateEvent, connection, CommandType.StoredProcedure, parameters))
{
command.Connection.Open();
command.ExecuteNonQuery();
}
}
public void Create(User item)
{
var parameters = new List <IDataParameter>()
{
_sqlFactory.CreateDbParameter("Login", item.Login, DbType.String),
_sqlFactory.CreateDbParameter("Password", item.Password, DbType.String),
_sqlFactory.CreateDbParameter("Name", item.Name, DbType.String),
_sqlFactory.CreateDbParameter("LastName", item.LastName, DbType.String),
_sqlFactory.CreateDbParameter("Email", item.Email, DbType.String),
_sqlFactory.CreateDbParameter("RoleId", item.Role.Id, DbType.Int32)
};
var connection = _sqlFactory.CreateSqlConnection();
using (var command = _sqlFactory.CreateDbCommand(DbConstant.Command.CreateUser, connection, CommandType.StoredProcedure, parameters))
{
command.Connection.Open();
command.ExecuteNonQuery();
}
}
