public async Task <List <hnNotify> > ShowMember(int member_counter)
{
NotifyContext db = this._dbconn;
var q = await(from p in db.hnNotify where p.deleted == 0 && p.member_counter == member_counter select p).ToAsyncEnumerable().ToList();
return(q);
}
public async Task <List <hnNotifyItem> > ShowItem()
{
NotifyContext db = this._dbconn;
var q = await(from p in db.hnNotifyItem where p.deleted == 0 select p).ToAsyncEnumerable().ToList();
return(q);
}
public async Task <Members> accountLogin(string account, string password)
{
NotifyContext db = this._dbconn;
var q = await(from p in db.Members where p.deleted == 0 && account == p.account select p).ToAsyncEnumerable().FirstOrDefault();
// return q;
if (q == null)
{
// 沒有資料列
Members _member = new Members();
_member.counter = -1;
return(_member);
}
else if (q.password == password)
{
// 登入成功
return(q);
}
else
{
// 密碼錯誤
q.counter = 0;
return(q);
}
}
public async Task delUserServiceOrder(int member_counter, string actionName, string serviceName)
{
NotifyContext db = this._dbconn;
var q1 = (from p in db.hnNotifyItem where p.name == serviceName select p).AsEnumerable().FirstOrDefault();
var q = (from p in db.hnNotify where p.member_counter == member_counter && p.hnNotifyItem_counter == q1.counter select p)
.AsEnumerable().FirstOrDefault();
var a = db.hnNotify.Find(q.counter);
db.hnNotify.Attach(a);
if (actionName == "Line")
{
a.Line = 0;
}
if (actionName == "Mail")
{
a.Mail = 0;
}
if (actionName == "Message")
{
a.Message = 0;
}
await db.SaveChangesAsync();
}
public async Task addLineToken(int counter, string Token)
{
NotifyContext db = this._dbconn;
var _member = db.Members.Find(counter);
db.Members.Attach(_member);
_member.LineToken = Token;
await db.SaveChangesAsync();
}
public async Task updateMember(hnNotify _hnNotify)
{
NotifyContext db = this._dbconn;
var _member = db.hnNotify.Find(_hnNotify.counter);
db.hnNotify.Attach(_member);
// _member = _hnNotify;
_member.Line = _hnNotify.Line;
_member.Mail = _hnNotify.Mail;
_member.Message = _hnNotify.Message;
await db.SaveChangesAsync();
}
public async Task <List <DTOhnNotifyItem> > ShowMemberItem(int member_counter)
{
NotifyContext db = this._dbconn;
var q = await(from p in db.hnNotify where p.deleted == 0 && p.member_counter == member_counter select p).ToAsyncEnumerable().ToList();
var tmpList = new List <DTOhnNotifyItem> ();
foreach (var p in db.hnNotifyItem.Where(c => c.deleted == 0))
{
var DTO = new DTOhnNotifyItem();
DTO.counter = p.counter;
DTO.name = p.name;
var p2 = q.Where(c => c.hnNotifyItem_counter == p.counter).FirstOrDefault();
if (p2 != null)
{
if (p2.Line == 1)
{
DTO.Line = true;
}
else
{
DTO.Line = false;
}
if (p2.Mail == 1)
{
DTO.Mail = true;
}
else
{
DTO.Mail = false;
}
if (p2.Message == 1)
{
DTO.Message = true;
}
else
{
DTO.Message = false;
}
}
else
{
DTO.Line = false;
DTO.Mail = false;
DTO.Message = false;
}
tmpList.Add(DTO);
}
return(tmpList);
}
public List <USERSERVICEORDER> ShowMemberOrderItem(int member_counter)
{
NotifyContext db = this._dbconn;
var q = (from p in db.hnNotify join p2 in db.hnNotifyItem on p.hnNotifyItem_counter equals p2.counter where p.deleted == 0 && p.member_counter == member_counter
select new {
Line = p.Line,
Mail = p.Mail,
Message = p.Message,
serviceName = p2.name
}).AsEnumerable();
List <USERSERVICEORDER> l = new List <USERSERVICEORDER> ();
foreach (var p in q)
{
if (p.Line == 1)
{
USERSERVICEORDER d = new USERSERVICEORDER();
d.actionName = "Line";
d.serviceName = p.serviceName;
l.Add(d);
}
if (p.Mail == 1)
{
USERSERVICEORDER d = new USERSERVICEORDER();
d.actionName = "Mail";
d.serviceName = p.serviceName;
l.Add(d);
}
if (p.Message == 1)
{
USERSERVICEORDER d = new USERSERVICEORDER();
d.actionName = "Message";
d.serviceName = p.serviceName;
l.Add(d);
}
}
l = l.OrderBy(c => c.actionName).ToList();
return(l);
}
public hnNotifyItemService(NotifyContext dbconn)
{
this._dbconn = dbconn;
}
public MemberService(NotifyContext dbconn)
{
this._dbconn = dbconn;
}
public void UpdateNotifyMember(DTOhnNotifyItemUser dto)
{
NotifyContext db = this._dbconn;
var q = (from p in db.hnNotify where p.member_counter == dto.member_counter select p)
.AsEnumerable().ToList();
if (q.FirstOrDefault() == null)
{
foreach (var p in dto.DTOhnNotifyItems)
{
var _hnNotify = new hnNotify();
_hnNotify.member_counter = dto.member_counter;
_hnNotify.counter = Guid.NewGuid();
_hnNotify.hnNotifyItem_counter = p.counter;
if (p.Line == true)
{
_hnNotify.Line = 1;
}
else
{
_hnNotify.Line = 0;
}
if (p.Mail == true)
{
_hnNotify.Mail = 1;
}
else
{
_hnNotify.Mail = 0;
}
if (p.Message == true)
{
_hnNotify.Message = 1;
}
else
{
_hnNotify.Message = 0;
}
_hnNotify.deleted = 0;
db.hnNotify.Add(_hnNotify);
db.SaveChanges();
}
}
else
{
foreach (var p in q)
{
var _hnNotify = db.hnNotify.Find(p.counter);
db.hnNotify.Attach(_hnNotify);
_hnNotify.deleted = 0;
foreach (var p1 in dto.DTOhnNotifyItems)
{
if (p.hnNotifyItem_counter == p1.counter)
{
if (p1.Line == true)
{
_hnNotify.Line = 1;
}
else
{
_hnNotify.Line = 0;
}
if (p1.Mail == true)
{
_hnNotify.Mail = 1;
}
else
{
_hnNotify.Mail = 0;
}
if (p1.Message == true)
{
_hnNotify.Message = 1;
}
else
{
_hnNotify.Message = 0;
}
}
}
}
db.SaveChanges();
}
}