public IEnumerable <Picture> GetAll()
{
var pictures = new List <Picture>();
using (var connection = new SqlConnection(helper.GetConnectionString()))
{
connection.Open();
using (var command = new SqlCommand("GetPictures", connection))
{
command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var picture = new Picture
{
Id = Convert.ToInt32(reader["Id"]),
Path = reader["Path"].ToString()
};
pictures.Add(picture);
}
}
reader.Close();
}
}
return(pictures);
}
public IEnumerable <Email> GetAll()
{
var emails = new List <Email>();
using (var connection = new SqlConnection(helper.GetConnectionString()))
{
connection.Open();
using (var command = new SqlCommand("GetEmails", connection))
{
command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var email = new Email
{
Id = Convert.ToInt32(reader["Id"]),
Address = reader["Address"].ToString()
};
emails.Add(email);
}
}
reader.Close();
}
}
return(emails);
}
public IEnumerable <Category> GetAll()
{
var categories = new List <Category>();
using (var connection = new SqlConnection(helper.GetConnectionString()))
{
connection.Open();
using (var command = new SqlCommand("GetCategories", connection))
{
command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var category = new Category
{
Id = Convert.ToInt32(reader["Id"]),
Name = reader["Name"].ToString()
};
categories.Add(category);
}
}
reader.Close();
}
}
return(categories);
}
public IEnumerable <Event> GetAll()
{
var events = new List <Event>();
using (var connection = new SqlConnection(helper.GetConnectionString()))
{
connection.Open();
using (var command = new SqlCommand("GetEvents", connection))
{
command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var eventInst = new Event
{
Id = Convert.ToInt32(reader["Id"]),
Name = reader["Name"].ToString()
};
events.Add(eventInst);
}
}
reader.Close();
}
}
return(events);
}
public IEnumerable <Record> GetAll()
{
var records = new List <Record>();
using (var connection = new SqlConnection(helper.GetConnectionString()))
{
connection.Open();
using (var command = new SqlCommand("GetRecords", connection))
{
command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var record = new Record
{
Id = Convert.ToInt32(reader["Id"]),
Name = reader["Name"].ToString(),
CreateDate = Convert.ToDateTime(reader["CreateDate"]),
Description = reader["Description"].ToString(),
CategoryId = Convert.ToInt32(reader["CategoryId"]),
PictureId = Convert.ToInt32(reader["PictureId"])
};
records.Add(record);
}
}
reader.Close();
}
}
return(records);
}
public IEnumerable <User> GetAll()
{
var users = new List <User>();
using (var connection = new SqlConnection(helper.GetConnectionString()))
{
connection.Open();
using (var command = new SqlCommand("GetUsers", connection))
{
command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var user = new User
{
Id = Convert.ToInt32(reader["Id"]),
Name = reader["Name"].ToString(),
Password = reader["Password"].ToString(),
RoleId = Convert.ToInt32(reader["RoleId"]),
EmailId = Convert.ToInt32(reader["EmailId"])
};
users.Add(user);
}
}
reader.Close();
}
}
return(users);
}