public void InsertByMemberId(int memberId, Dictionary <string, string> news)
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
string link = news["link"];
var scrap = context.Scraps.FirstOrDefault(x => x.Link == link);
var LoginedUser = context.Members.FirstOrDefault(x => x.MemberId == memberId);
foreach (var sc in LoginedUser.Scraps)
{
if (sc == scrap)
{
return;
}
}
if (scrap == null)
{
scrap = new Scrap();
scrap.PubDate = DateTime.Now;
scrap.Title = news["title"];
scrap.Description = news["description"];
scrap.Link = news["link"];
scrap.OriginalLink = news["originalLink"];
}
LoginedUser.Scraps.Add(scrap);
context.SaveChanges();
}
}
public int GetCount(Expression <Func <T, bool> > predicate)
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
return(context.Set <T>().Count(predicate));
}
}
public void InsertKeyword(int memberId, string str)
{
using (var context = new ABGNDBEntities())
{
// keyword 유무 확인
var keyword = context.Keywords.FirstOrDefault(x => x.PushName == str);
// member 에 keyword 있는지 확인
var member = context.Members.FirstOrDefault(x => x.MemberId == memberId);
foreach (var kw in member.Keywords)
{
if (kw == keyword)
{
return;
}
}
// keyword 테이블에 없을 시 새로 생성
if (keyword == null)
{
keyword = new Keyword();
keyword.PushDate = DateTime.Now;
keyword.PushName = str;
}
// 매핑 테이블에 추가
member.Keywords.Add(keyword);
context.SaveChanges();
}
}
public Member GetLastMember()
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
return(context.Members.OrderByDescending(x => x.MemberId).First());
}
}
//getByPK
public Member GetByPK(int memberId)
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
return(context.Members.FirstOrDefault(x => x.MemberId == memberId));
}
}
//로그인 체크 기능
public Member GetMember(string idText, string pwText)
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
return(context.Members.FirstOrDefault(x => (x.Id == idText && x.Password == pwText)));
}
}
public void Delete(T entity)
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
context.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
public void Insert(T entity)
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
context.Set <T>().Add(entity);
context.Entry(entity).State = System.Data.Entity.EntityState.Added;
context.SaveChanges();
}
}
public void DeleteKeyword(int memberId, string str)
{
using (var context = new ABGNDBEntities())
{
var keyword = context.Keywords.FirstOrDefault(x => x.PushName == str);
context.Members.FirstOrDefault(x => x.MemberId == memberId).Keywords.Remove(keyword);
context.SaveChanges();
}
}
public void DeleteScrap(int memberId, string link)
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
var scrap = context.Scraps.FirstOrDefault(x => x.Link == link);
var member = context.Members.FirstOrDefault(x => x.MemberId == memberId);
member.Scraps.Remove(scrap);
context.SaveChanges();
}
}
public List <Keyword> GetByMemberId(int memberId)
{
using (var context = new ABGNDBEntities())
{
return(context.Members
.Where(x => x.MemberId == memberId)
.FirstOrDefault()
.Keywords
.OrderByDescending(x => x.KeywordId)
.ToList());
}
}
public List <T> GetAll(Expression <Func <T, bool> > predicate = null)
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
IQueryable <T> query = context.Set <T>();
if (predicate != null)
{
query = query.Where(predicate);
}
return(query.ToList());
}
}
//한 회원이 스크랩한 기사들의 목록
public List <Scrap> GetByMemberId(int memberId)
{
using (ABGNDBEntities context = new ABGNDBEntities())
{
var query = (from scrap in context.Scraps
from member in scrap.Members
select new
{
Scrap = scrap,
MemberName = member.Name,
MemberId = member.MemberId
}).Where(x => x.MemberId == memberId)
.OrderByDescending(x => x.Scrap.ScrapId);
var list = query.ToList();
foreach (var item in list)
{
item.Scrap.MemberName = item.MemberName;
}
return(list.ConvertAll(x => x.Scrap));
}
}
