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); } }