public static int GetSumCount()
{
using (var db = new OLMSDBEntities1())
{
return(db.Artists.Count());
}
}
public static List <Users> GetAllUser()
{
using (var db = new OLMSDBEntities1())
{
return(db.Users.Include("Roles").ToList());
}
}
public static List <Artists> GetAllType()
{
using (var db = new OLMSDBEntities1())
{
return(db.Artists.ToList());
}
}
public static Artists GetById(int id)
{
using (var db = new OLMSDBEntities1())
{
return(db.Artists.Where(a => a.ArtistId == id).FirstOrDefault());
}
}
public static List <OrderDetails> GetByOrderId(int id)
{
using (var db = new OLMSDBEntities1())
{
return(db.OrderDetails.Include("Orders").Include("Albums").Where(o => o.Orders.OrderId == id).ToList());
}
}
public static List <Roles> GetAllRole()
{
using (var db = new OLMSDBEntities1())
{
return(db.Roles.ToList());
}
}
public static Roles GetById(int id)
{
using (var db = new OLMSDBEntities1())
{
return(db.Roles.Where(a => a.RoleId == id).FirstOrDefault());
}
}
public static int GetOrderCountByStatu(int statu)
{
using (var db = new OLMSDBEntities1())
{
return(db.Orders.Where(o => o.OrderStatus == statu).Count());
}
}
public static List <Orders> GetOrderByStatu(int statu)
{
using (var db = new OLMSDBEntities1())
{
return(db.Orders.Where(o => o.OrderStatus == statu).ToList());
}
}
public static Albums GetById(int id)
{
using (var db = new OLMSDBEntities1())
{
return(db.Albums.Include("Genres").Include("Artists").Where(a => a.AlbumId == id).FirstOrDefault());
}
}
public static List <Genres> GetAllGenre()
{
using (var db = new OLMSDBEntities1())
{
return(db.Genres.ToList());
}
}
public static Users GetById(int id)
{
using (var db = new OLMSDBEntities1())
{
return(db.Users.Include("Roles").Where(a => a.UserId == id).FirstOrDefault());
}
}
public static Genres GetGenreById(int id)
{
using (var db = new OLMSDBEntities1())
{
return(db.Genres.Where(g => g.GenreId == id).FirstOrDefault());
}
}
public static bool AddUser(Users user)
{
using (var db = new OLMSDBEntities1())
{
db.Users.Add(user);
return(db.SaveChanges() > 0);
}
}
public static Users UserLogin(string username, string userpwd)
{
using (var db = new OLMSDBEntities1())
{
var user = db.Users.Where(u => u.LoginId == username & u.LoginPwd == userpwd).FirstOrDefault();
return(user);
}
}
public static bool AddRole(Roles role)
{
using (var db = new OLMSDBEntities1())
{
db.Roles.Add(role);
return(db.SaveChanges() > 0);
}
}
public static bool AddAlbum(Albums album)
{
using (var db = new OLMSDBEntities1())
{
db.Albums.Add(album);
return(db.SaveChanges() > 0);
}
}
public static List <Artists> GetAll(int nowpage)
{
using (var db = new OLMSDBEntities1())
{
string sql = string.Format("select top 7 * from Artists where ArtistId not in (select top (({0}-1)*7) ArtistId from Artists order by ArtistId asc) order by ArtistId asc", nowpage);
return(db.Database.SqlQuery <Artists>(sql).ToList());
}
}
public static bool AddArtist(Artists artist)
{
using (var db = new OLMSDBEntities1())
{
db.Artists.Add(artist);
return(db.SaveChanges() > 0);
}
}
public static bool UpdOrderStatuByOrderId(int orderid, int statu)
{
using (var db = new OLMSDBEntities1())
{
var order = db.Orders.Where(o => o.OrderId == orderid).FirstOrDefault();
if (order == null)
{
return(false);
}
order.OrderStatus = statu;
return(db.SaveChanges() > 0);
}
}
public static bool RemoveRole(int id)
{
using (var db = new OLMSDBEntities1())
{
var role = db.Roles.Where(a => a.RoleId == id).FirstOrDefault();
if (role == null)
{
return(false);
}
db.Roles.Remove(role);
return(db.SaveChanges() > 0);
}
}
public static bool UpdArtist(Artists artist, int id)
{
using (var db = new OLMSDBEntities1())
{
var art = db.Artists.Where(a => a.ArtistId == id).FirstOrDefault();
if (art == null)
{
return(false);
}
art.Name = artist.Name;
return(db.SaveChanges() > 0);
}
}
public static bool UpdRole(Roles role, int id)
{
using (var db = new OLMSDBEntities1())
{
var nowrole = db.Roles.Where(a => a.RoleId == id).FirstOrDefault();
if (nowrole == null)
{
return(false);
}
nowrole.Name = role.Name;
return(db.SaveChanges() > 0);
}
}
public static bool RemoveUser(int id)
{
using (var db = new OLMSDBEntities1())
{
var user = db.Users.Where(a => a.UserId == id).FirstOrDefault();
if (user == null)
{
return(false);
}
db.Users.Remove(user);
return(db.SaveChanges() > 0);
}
}
public static bool RemoveAlbum(int id)
{
using (var db = new OLMSDBEntities1())
{
var album = db.Albums.Where(a => a.AlbumId == id).FirstOrDefault();
if (album == null)
{
return(false);
}
db.Albums.Remove(album);
return(db.SaveChanges() > 0);
}
}
public static bool RemoveArtist(int id)
{
using (var db = new OLMSDBEntities1())
{
var artist = db.Artists.Where(a => a.ArtistId == id).FirstOrDefault();
if (artist == null)
{
return(false);
}
db.Artists.Remove(artist);
return(db.SaveChanges() > 0);
}
}
public static bool UpdUser(int roleid, int userid)
{
using (var db = new OLMSDBEntities1())
{
var user1 = db.Users.Include("Roles").Where(a => a.UserId == userid).FirstOrDefault();
if (user1 == null)
{
return(false);
}
user1.RoleId = roleid;
return(db.SaveChanges() > 0);
}
}
public static List <Users> GetAll(int nowpage)
{
using (var db = new OLMSDBEntities1())
{
string sql = string.Format("select top 7 * from Users where UserId not in (select top (({0}-1)*7) UserId from Users order by UserId asc) order by UserId asc", nowpage);
List <Users> users = db.Database.SqlQuery <Users>(sql).ToList();
List <Users> users1 = new List <Users>();
foreach (var item in users)
{
users1.Add(db.Users.Include("Roles").Where(a => a.UserId == item.UserId).FirstOrDefault());
}
return(users1);
}
}
public static List <Albums> GetAll(int nowpage)
{
using (var db = new OLMSDBEntities1())
{
string sql = string.Format("select top 7 * from Albums where AlbumId not in (select top (({0}-1)*7) AlbumId from Albums order by AlbumId asc) order by AlbumId asc", nowpage);
List <Albums> albums = db.Database.SqlQuery <Albums>(sql).ToList();
List <Albums> albums1 = new List <Albums>();
foreach (var item in albums)
{
albums1.Add(db.Albums.Include("Genres").Include("Artists").Where(a => a.AlbumId == item.AlbumId).FirstOrDefault());
}
return(albums1);
}
}
public static bool UpdAlbum(Albums album, int id)
{
using (var db = new OLMSDBEntities1())
{
var alb = db.Albums.Include("Genres").Include("Artists").Where(a => a.AlbumId == id).FirstOrDefault();
if (alb == null)
{
return(false);
}
alb.Price = album.Price;
alb.ArtistId = album.ArtistId;
alb.Title = album.Title;
alb.GenreId = album.GenreId;
alb.AlbumArtUrl = album.AlbumArtUrl;
return(db.SaveChanges() > 0);
}
}
