-
Notifications
You must be signed in to change notification settings - Fork 0
/
ProcessStoreAcceptServices.ashx
126 lines (113 loc) · 4.54 KB
/
ProcessStoreAcceptServices.ashx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<%@ WebHandler Language="C#" Class="ProcessStoreAcceptServices" %>
using System;
using System.Web;
using System.Linq;
public class ProcessStoreAcceptServices : IHttpHandler {
FactoryDBDataContext db = new FactoryDBDataContext();
string date = "";
int storeid = 0, memberid = 0;
string storename = "", membername = "", servicename = "";
public void ProcessRequest (HttpContext context) {
if (context.Request["calendarid"] != null)
{
//找資料
var table = from t in db.tCalendar
where t.fIdCalendar == Convert.ToInt32(context.Request["calendarid"])
select t;
if (table.Count() > 0)
{
foreach(tCalendar c in table)
{
c.fAccepted = true;
date = (c.fDate).ToString();
storeid = c.fIdStores;
var service = from s in db.tServices
where s.fIdServices == c.fIdServices
select s;
if (service.Count() > 0)
{
foreach(tServices s in service)
{
servicename = s.fName;
}
}
var msg = from m in db.tMember
where m.fIdMember == c.fIdStores || m.fIdMember == c.fIdMember
select m;
if (msg.Count() > 0)
{
foreach(tMember m in msg)
{
if (m.fIdentity == 0)
{
memberid = m.fIdMember;
membername = m.fName;
}
else
{
storeid = m.fIdMember;
storename = m.fName;
}
}
}
}
}
if (context.Request["yes"] !=null)
{//當廠商按下接受
tAvailableTime a = new tAvailableTime();
a.fAvailableTime = Convert.ToDateTime(date);
a.fIdStores = storeid;
db.tAvailableTime.InsertOnSubmit(a);
tLetter l = new tLetter();
l.fIdReceiver = memberid;
l.fContent = "您已經與 " + storename + " 廠商配對成功!詳細時間請於專屬行事曆查看";
l.fIdSender = storeid;
l.fIsRead = false;
l.fLetterOrChat = 1;
l.fSendTime = DateTime.Now;
db.tLetter.InsertOnSubmit(l);
tLetter g = new tLetter();
g.fIdReceiver = storeid;
g.fContent = "您已經與 " + membername + " 新人配對成功!詳細時間請於專屬行事曆查看";
g.fIdSender = memberid;
g.fIsRead = false;
g.fLetterOrChat = 1;
g.fSendTime = DateTime.Now;
db.tLetter.InsertOnSubmit(g);
db.SubmitChanges();
}
else
{//當廠商按下拒絕
tLetter l = new tLetter();
l.fIdReceiver = memberid;
l.fContent = "您已經被 " + storename + " 廠商拒絕了 "+servicename+" 服務方案。<br/>理由是:<br/>"+context.Request["reason"].Replace("\n","<br/>");
l.fIdSender = storeid;
l.fIsRead = false;
l.fLetterOrChat = 1;
l.fSendTime = DateTime.Now;
db.tLetter.InsertOnSubmit(l);
tLetter g = new tLetter();
g.fIdReceiver = storeid;
g.fContent = "您已經殘忍拒絕了 " + membername + " 新人選擇的 "+servicename+" 服務方案!";
g.fIdSender = memberid;
g.fIsRead = false;
g.fLetterOrChat = 1;
g.fSendTime = DateTime.Now;
db.tLetter.InsertOnSubmit(g);
if (table.Count() > 0)
{
foreach(tCalendar c in table)
{
db.tCalendar.DeleteOnSubmit(c);
}
}
db.SubmitChanges();
}
}
}
public bool IsReusable {
get {
return false;
}
}
}