protected void link_edit(object sender, System.EventArgs e)
{
MultiView1.ActiveViewIndex = 1;
LinkButton obj = sender as LinkButton;
Selected_id.Value = obj.CommandArgument;
o = OrderLib.Get_ordData(Selected_id.Value);
payStatus.SelectedValue = o.Status;
MultiView1.ActiveViewIndex = 1;
LessonLib.JoinData l = LessonLib.Web.Get_ord_JoinData(o.Ord_code);
joindata.Visible = false;
companyno.Text = o.Companyno;
title.Text = o.Title;
Repeater1.DataSource = o.OrderDetail;
Repeater1.DataBind();
if (l.JoinDetail != null)
{
joindata.Visible = true;
Lstatus.SelectedValue = l.JoinDetail[0].Status;
}
paymode.SelectedValue = o.Paymode;
Btn_save.CommandArgument = "edit";
string strsql = "select * from Log_Sms where ord_code=@ord_code";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("ord_code", Selected_id.Value);
DataTable dt = DbControl.Data_Get(strsql, nvc);
Repeater2.DataSource = dt;
Repeater2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["memberdata"] != null)
{
MemberLib.Mmemberdata m = (MemberLib.Mmemberdata)Session["memberdata"];
OrderLib.OrderData o = OrderLib.Get_ordData(Request.QueryString["ord_code"]);
if (m.Memberid.ToString() == o.Memberid)
{
htmlstr = unity.classlib.GetTextString(Server.MapPath("/templates/orderdata.html"));
htmlstr = htmlstr.Replace("@ord_code@", o.Ord_code);
htmlstr = htmlstr.Replace("@ordername@", o.Ordname);
htmlstr = htmlstr.Replace("@ordermail@", o.Ordemail);
htmlstr = htmlstr.Replace("@orderphone@", o.Ordphone);
htmlstr = htmlstr.Replace("@shipname@", o.Ordname);
htmlstr = htmlstr.Replace("@shipphone@", o.Ordphone);
htmlstr = htmlstr.Replace("@shipaddress@", o.Ordaddress);
htmlstr = htmlstr.Replace("@TotalPrice@", "NT$:" + o.TotalPrice.ToString());
htmlstr = htmlstr.Replace("@paymode@", OrderLib.getPaymode(o.Paymode));
htmlstr = htmlstr.Replace("@ShipPrice@", o.ShipPrice.ToString());
htmlstr = htmlstr.Replace("@delivery_kind@", OrderLib.getdelivery_kind(o.Delivery_kind));
string detailstr = "";
foreach (var d in o.OrderDetail)
{
detailstr += "<tr><td>" + d.P_name + "</td><td>" + d.Price.ToString() + "</td><td>" + d.Num.ToString() + "</td><td>" + d.Amount.ToString() + "</td></tr>";
}
htmlstr = htmlstr.Replace("@detail@", detailstr);
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
o = OrderLib.Get_ordData(Selected_id.Value);
string ord_code = o.Ord_code;
string site_name = HttpContext.Current.Application["site_name"].ToString();
string filename = HttpContext.Current.Server.MapPath("/templates/letter.html");
DataTable dt = unity.classlib.Get_Message(14);
LessonLib.JoinData l = LessonLib.Web.Get_ord_JoinData(o.Ord_code);
string mailsubject = dt.Rows[0]["title"].ToString();
string mailbody = dt.Rows[0]["contents"].ToString();
mailsubject = mailsubject.Replace("@classname@", get_ld(o.Ord_code));
mailbody = mailbody.Replace("@classname@", get_ld(o.Ord_code));
mailbody = mailbody.Replace("@username@", o.Ordname);
mailbody = mailbody.Replace("@url@", "<a href=\"http://www.culturelaunch.net/Class/" + l.LessonData.MainData.Id + "\">http://www.culturelaunch.net/Class/" + l.LessonData.MainData.Id + "</a>");
string textbody = unity.classlib.GetTextString(filename);
mailbody = textbody.Replace("@mailbody@", mailbody);
string msg = unity.classlib.SendsmtpMail(o.Ordemail, mailsubject, mailbody, "gmail");
outfile = "<script>alert('己送出');</script>";
}
public ActionResult Payment(string shipName, string mobile, string address, string email)
{
var order = new Order();
order.CreatedDate = DateTime.Now;
order.ShipAddress = address;
order.ShipMobile = mobile;
order.ShipName = shipName;
order.ShipEmail = email;
try
{
var id = new OrderLib().Insert(order);
var cart = (List <CartItem>)Session[CartSession];
var detailDao = new Model.Lib.OrderDetailLib();
decimal total = 0;
foreach (var item in cart)
{
var orderDetail = new OrderDetail();
orderDetail.ProductID = item.Product.ID;
orderDetail.OrderID = id;
orderDetail.Price = item.Product.Price;
orderDetail.Quantity = item.Quantity;
detailDao.Insert(orderDetail);
total += (item.Product.Price.GetValueOrDefault(0) * item.Quantity);
}
}
catch (Exception ex)
{
//ghi log
return(Redirect("/payment-error"));
}
return(Redirect("/success"));
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt;
string code = Request["code"];
string[] ary = code.Split('-');
code = ary[0] + "-" + ary[1] + "-" + ary[2];
if (code == null || code == "")
{
msg = "無編號";
}
else
{
LessonLib.JoinData l = LessonLib.Web.Get_ord_JoinData(ary[0]);
if (l.Id == 0)
{
msg = "報名資料不存在";
}
else
{
string strsql = "select * from tbl_joindetail where joinid=@joinid ";
NameValueCollection nvc = new NameValueCollection
{
{ "joinid", ary[1] },
};
strsql = "select * from tbl_joinlog where checkcode=@checkcode ";
nvc.Clear();
nvc = new NameValueCollection
{
{ "checkcode", code },
};
dt = DbControl.Data_Get(strsql, nvc);
if (dt.Rows.Count > 0)
{
msg = "已報到過!";
}
else
{
strsql = "insert into tbl_joinlog (checkcode) values (@checkcode)";
DbControl.Data_add(strsql, nvc);
msg = "報到成功!";
}
msg += "<br>訂單編號:" + l.Ord_code + "<br>";
msg += "付款方式:" + OrderLib.getPaymode(l.OrderData.Paymode) + "<br>";
msg += "訂單狀態:" + OrderLib.get_ord_status(l.OrderData.Status) + "<br>";
}
}
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
o = OrderLib.Get_ordData(Selected_id.Value);
string ord_code = o.Ord_code;
DataTable dt = unity.classlib.Get_Message(17);
LessonLib.JoinData l = LessonLib.Web.Get_ord_JoinData(o.Ord_code);
string smsbody = dt.Rows[0]["contents"].ToString();
smsbody = smsbody.Replace("@username@", l.OrderData.Ordname);
// smsbody = smsbody.Replace("@date@", l.LessonData.StartDay.ToString ("MM月dd日") );
smsbody = smsbody.Replace("@classtime@", l.LessonData.Lessontime);
smsbody = smsbody.Replace("@classname@", l.LessonData.MainData.Subject);
classlib.Log_Sms log = classlib.Sendsms(l.OrderData.Ordphone, smsbody);
string strsql = "update log_SMS set ord_code= @ord_code where msgid=@msgid";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("msgid", log.Msgid);
nvc.Add("ord_code", o.Ord_code);
DbControl.Data_add(strsql, nvc);
outfile = "<script>alert('己送出');</script>";
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ord_code"] != null)
{
ord_code = Session["ord_code"].ToString();
}
if (Request.QueryString["ord_code"] != null)
{
ord_code = Request.QueryString["ord_code"];
}
if (ord_code == "")
{
Response.End();
}
ord_code = classlib.RemoveBadSymbol(ord_code);
o = OrderLib.Get_ordData(ord_code);
SpGatewayHelper.Models.TradeInfoLog log = OrderLib.Get_Tradelog(ord_code);
string ord_id = o.Ord_id.ToString();
temp_product.DataSource = o.OrderDetail;
temp_product.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string repay = Request.QueryString["repay"];
string ord_code = "";
if (repay != null && repay != "")
{
ord_code = MySecurity.DecryptAES256(repay);
Session["ord_code"] = ord_code;
}
OrderLib.OrderData o = OrderLib.Get_ordData(Session["ord_code"].ToString());
LessonLib.JoinData L = LessonLib.Web.Get_ord_JoinData(Session["ord_code"].ToString());
action = "https://core.spgateway.com/MPG/mpg_gateway"; //正式ID
MerchantID = "MS357549208"; //正式ID
string _key = "CD9Zyfb82BIFpnYY2JUppiF4a3f1FB1B";
string _Vi = "jXbof2czX0r9FxBf";
if (Request.Url.Host.IndexOf("localhost") != -1)
{
action = "https://ccore.spgateway.com/MPG/mpg_gateway";//測試ID
MerchantID = "MS34344182";
_key = "By8IMdyhhfeTTgACeHciAYe6bGrXc6bA";
_Vi = "hiDG6VP3CrOA32bM";
}
string _ItemDesc = "";
foreach (var obj in o.OrderDetail)
{
_ItemDesc += obj.P_name + ",";
}
List <article.Lesson> lesson = new List <article.Lesson>();
article.LessonDetail lessondetail = new article.LessonDetail();
if (L.JoinDetail != null)
{
lessondetail = L.LessonData.MainData.Lesson.LessonDetail.Find(c => c.LessonId == L.JoinDetail[0].LessonId);
_ItemDesc = L.LessonData.MainData.Subject + "-" + lessondetail.Description;
}
int CREDIT = 0;
int VACC = 0;
string CustomerURL = "https://www.culturelaunch.net/back";
if (o.Paymode == "1")
{
CREDIT = 1;
CustomerURL = "https://www.culturelaunch.net/completed";
}
else if (o.Paymode == "2")
{
VACC = 1;
CustomerURL = "https://www.culturelaunch.net/atm";
}
var tradeInfo = new TradeInfo()
{
MerchantID = MerchantID,
RespondType = "JSON",
TimeStamp = (DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds.ToString(),
Version = "1.5",
Amt = o.TotalPrice,
ItemDesc = _ItemDesc,
//InstFlag="3,6",
Email = o.Ordemail,
EmailModify = 0,
LoginType = 0,
MerchantOrderNo = Session["ord_code"].ToString(),
TradeLimit = 180,
//CVS=1,
//ExpireDate=DateTime.Now.ToString("yyyyMMdd"),
VACC = VACC,
BARCODE = 0,
CREDIT = CREDIT,
CreditRed = 0,
WEBATM = 0,
ReturnURL = "https://www.culturelaunch.net/completed",
NotifyURL = "https://www.culturelaunch.net/log/receive.ashx",
CustomerURL = CustomerURL
};
var postData = tradeInfo.ToDictionary();
var cryptoHelper = new CryptoHelper(_key, _Vi);
var aesString = cryptoHelper.GetAesString(postData);
aes = aesString;
Sha = cryptoHelper.GetSha256String(aesString);
//ViewData["TradeInfo"] = aesString;
// ViewData["TradeSha"] = cryptoHelper.GetSha256String(aesString);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ord_code"] != null)
{
LessonLib.JoinData o = LessonLib.Web.Get_ord_JoinData(Session["ord_code"].ToString());
string htmldetail = "";
htmlstr = unity.classlib.GetTextString(Server.MapPath("/templates/Lessondata0.html"));
htmldetail = unity.classlib.GetTextString(Server.MapPath("/templates/classdetail.html"));
htmlstr = htmlstr.Replace("@subject@", o.LessonData.MainData.Subject);
htmlstr = htmlstr.Replace("@pic@", o.LessonData.MainData.Pic);
htmlstr = htmlstr.Replace("@totalprice@", o.OrderData.TotalPrice.ToString());
htmlstr = htmlstr.Replace("@classdate@", o.LessonData.StartDay.ToShortDateString() + "~" + o.LessonData.EndDay.ToShortDateString());
htmlstr = htmlstr.Replace("@address@", o.LessonData.Address);
htmlstr = htmlstr.Replace("@ord_code@", o.Ord_code);
htmlstr = htmlstr.Replace("@DeliveryPrice@", o.OrderData.ShipPrice.ToString());
htmlstr = htmlstr.Replace("@ordername@", o.OrderData.Ordname);
htmlstr = htmlstr.Replace("@ordermail@", o.OrderData.Ordemail);
htmlstr = htmlstr.Replace("@orderphone@", o.OrderData.Ordphone);
htmlstr = htmlstr.Replace("@shipname@", o.OrderData.Ordname);
htmlstr = htmlstr.Replace("@shipphone@", o.OrderData.Ordphone);
htmlstr = htmlstr.Replace("@shipaddress@", o.OrderData.Ordaddress);
htmlstr = htmlstr.Replace("@TotalPrice@", "NT$:" + o.OrderData.TotalPrice.ToString());
htmlstr = htmlstr.Replace("@paymode@", OrderLib.getPaymode(o.OrderData.Paymode));
htmlstr = htmlstr.Replace("@ShipPrice@", o.OrderData.ShipPrice.ToString());
htmlstr = htmlstr.Replace("@delivery_kind@", OrderLib.getdelivery_kind(o.OrderData.Delivery_kind));
htmlstr = htmlstr.Replace("@ticketname@", o.LessonData.MainData.Subject);
htmlstr = htmlstr.Replace("@StartDay@", o.LessonData.MainData.Lesson.StartDay.ToString("yyyy/MM/dd"));
htmlstr = htmlstr.Replace("@EndDay@", o.LessonData.MainData.Lesson.EndDay.ToString("yyyy/MM/dd"));
htmlstr = htmlstr.Replace("@Lessontime@", o.LessonData.MainData.Lesson.Lessontime);
string temp = "";
string temp1 = "";
foreach (article.LessonDetail d in o.LessonData.LessonDetail)
{
var data = o.JoinDetail.FindAll(y => y.LessonId == d.LessonId);
// var data = o.LessonData.LessonDetail.FindAll (y => y.LessonId == d.LessonId).Sum(c => d.Sellprice );
// var data = o.LessonData.LessonDetail.FindAll.Where(x => x.ID).Sum(c => c.price)
if (data != null)
{
temp1 += temp1 == "" ? "<tr><td width = '40%' rowspan = '" + o.LessonData.LessonDetail.Count + "'>票券 </td><td>" + d.Description : "<tr><td width = '20%'>" + d.Description;
temp1 += "</td><td width = '20%'> NT$" + d.Sellprice + "</td>";
temp1 += "<td width = '20%' class='text-right'>";
temp1 += "NT$" + d.Sellprice * data.Count + "</td></tr>";
}
}
foreach (LessonLib.JoinDetail d in o.JoinDetail)
{
string QrCode = o.Ord_code + "-" + d.JoinId.ToString() + "-" + d.LessonId + "-" + d.Secno;
temp += htmldetail;
temp = temp.Replace("@secno@", d.Secno.ToString());
temp = temp.Replace("@ticketno@", QrCode);
temp = temp.Replace("@name@", d.Name.ToString());
temp = temp.Replace("@email@", d.Email.ToString());
temp = temp.Replace("@phone@", d.Phone.ToString());
temp = temp.Replace("@qrcode@", QrCode);
QR_Encode qr = new QR_Encode();
qr.BackColor = Color.White;
qr.ForeColor = Color.Black;
int i = qr.EncodeData(1, 0, false, 1, 5, QrCode, Server.MapPath("upload/" + QrCode + ".gif"), false, 255, 255);
//Bitmap b = qr.GetBMP; //輸出至前端
//Response.ContentType = "image/jpeg";
//b.Save(Response.OutputStream, ImageFormat.Gif);
//b.Dispose();
}
htmlstr = htmlstr.Replace("@detail@", temp1);
htmlstr = htmlstr.Replace("@classdetail@", temp);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ord_code"] != null)
{
ord_code = Session["ord_code"].ToString();
}
if (Request.QueryString["ord_code"] != null)
{
ord_code = Request.QueryString["ord_code"];
}
if (ord_code == "")
{
Response.End();
}
ord_code = classlib.RemoveBadSymbol(ord_code);
o = OrderLib.Get_ordData(ord_code);
SpGatewayHelper.Models.TradeInfoLog log = OrderLib.Get_Tradelog(ord_code);
string strsql = "";
string ord_id = o.Ord_id.ToString();
temp_product.DataSource = o.OrderDetail;
temp_product.DataBind();
if (o.Paymode == "1")
{
NameValueCollection nvc = new NameValueCollection
{
{ "ord_code", ord_code }
};
DataTable dt = new DataTable();
if (log.Status == "SUCCESS")
{
strsql = @"update tbl_OrderData set paid= 'Y', status =2 where ord_code=@ord_code";
DbControl.Data_add(strsql, nvc);
dt.Dispose();
}
else
{
Response.Redirect("/cardpayfiled");
}
ord_status = log.Status;
string site_name = HttpContext.Current.Application["site_name"].ToString();
string filename = HttpContext.Current.Server.MapPath("/templates/letter.html");
string mailbody = unity.classlib.GetTextString(filename);
string atmmode = "<table><Tr><td colspan=2>您於「" + site_name + "」進行了信用卡交易，以下為您付款完成資訊</td></tr>";
atmmode += "<tr><td>訂單編號</td><td >" + ord_code + "</td></tr>";
atmmode += "<tr><td>訂單金額</td><td >NT$" + o.TotalPrice + "</td></tr>";
atmmode += "<tr><td>支付方式</td><td >信用卡一次付清</td></tr>";
atmmode += "<tr><td>刷卡結果</td><td >付款成功</td></tr></table>";
unity.classlib.SendsmtpMail(o.Ordemail, "信用卡付款完成通知信", mailbody.Replace("@mailbody@", atmmode), "gmail");
}
LessonLib.JoinData L = LessonLib.Web.Get_ord_JoinData(Session["ord_code"].ToString());
if (L.JoinDetail != null)
{
Response.Redirect("/process-step4.aspx");
}
}
public static string Get_JoinData(string ord_code)
{
string htmldetail = "";
string htmlstr;
LessonLib.JoinData o = LessonLib.Web.Get_ord_JoinData(ord_code);
htmlstr = unity.classlib.GetTextString(HttpContext.Current.Server.MapPath(" /templates/Lessondata0.html"));
htmldetail = unity.classlib.GetTextString(HttpContext.Current.Server.MapPath("/templates/classdetail.html"));
htmlstr = htmlstr.Replace("@subject@", o.LessonData.MainData.Subject);
htmlstr = htmlstr.Replace("@pic@", o.LessonData.MainData.Pic);
htmlstr = htmlstr.Replace("@totalprice@", o.OrderData.TotalPrice.ToString());
htmlstr = htmlstr.Replace("@classdate@", o.LessonData.StartDay.ToShortDateString() + "~" + o.LessonData.EndDay.ToShortDateString());
htmlstr = htmlstr.Replace("@address@", o.LessonData.Address);
htmlstr = htmlstr.Replace("@ord_code@", o.Ord_code);
htmlstr = htmlstr.Replace("@DeliveryPrice@", o.OrderData.ShipPrice.ToString());
htmlstr = htmlstr.Replace("@ordername@", o.OrderData.Ordname);
htmlstr = htmlstr.Replace("@ordermail@", o.OrderData.Ordemail);
htmlstr = htmlstr.Replace("@orderphone@", o.OrderData.Ordphone);
htmlstr = htmlstr.Replace("@shipname@", o.OrderData.Ordname);
htmlstr = htmlstr.Replace("@shipphone@", o.OrderData.Ordphone);
htmlstr = htmlstr.Replace("@shipaddress@", o.OrderData.Ordaddress);
htmlstr = htmlstr.Replace("@TotalPrice@", "NT$:" + o.OrderData.TotalPrice.ToString());
htmlstr = htmlstr.Replace("@paymode@", OrderLib.getPaymode(o.OrderData.Paymode));
htmlstr = htmlstr.Replace("@ShipPrice@", o.OrderData.ShipPrice.ToString());
htmlstr = htmlstr.Replace("@delivery_kind@", OrderLib.getdelivery_kind(o.OrderData.Delivery_kind));
htmlstr = htmlstr.Replace("@ticketname@", o.LessonData.MainData.Subject);
htmlstr = htmlstr.Replace("@StartDay@", o.LessonData.MainData.Lesson.StartDay.ToString("yyyy/MM/dd"));
htmlstr = htmlstr.Replace("@EndDay@", o.LessonData.MainData.Lesson.EndDay.ToString("yyyy/MM/dd"));
htmlstr = htmlstr.Replace("@Lessontime@", o.LessonData.MainData.Lesson.Lessontime);
htmlstr = htmlstr.Replace("@paymode@", OrderLib.getPaymode(o.OrderData.Paymode));
htmlstr = htmlstr.Replace("@paystatus@", OrderLib.get_ord_status(o.OrderData.Status));
SpGatewayHelper.Models.TradeInfoLog log = OrderLib.Get_Tradelog(ord_code);
string payinfo = "";
if (log.Result.TradeNo != "")
{
payinfo += "<tr><td colspan=\"4\">轉帳資訊:<br>";
payinfo += "銀行代碼:" + log.Result.BankCode + "<br>";
payinfo += "帳號:" + log.Result.CodeNo + "<br></td></tr>";
}
// string payinfo = "";
htmlstr = htmlstr.Replace("@payinfo@", payinfo);
string temp = "";
string temp1 = "";
foreach (article.LessonDetail d in o.LessonData.LessonDetail)
{
var data = o.JoinDetail.Find(y => y.LessonId == d.LessonId);
// var data = o.LessonData.LessonDetail.FindAll (y => y.LessonId == d.LessonId).Sum(c => d.Sellprice );
// var data = o.LessonData.LessonDetail.FindAll.Where(x => x.ID).Sum(c => c.price)
if (data != null)
{
temp1 += "<tr><td>" + o.LessonData.MainData.Subject + "</td>";
temp1 += "<td colspan=\"2\">" + d.Description + "</td>";
temp1 += "<td class='text-right'>";
temp1 += "NT$" + d.Sellprice + "</td></tr>";
}
}
foreach (LessonLib.JoinDetail d in o.JoinDetail)
{
string QrCode = o.Ord_code + "-" + d.JoinId.ToString() + "-" + d.LessonId;
string url = "http://www.culturelaunch.net/lib/checkjoin.aspx?code=" + QrCode;
temp += htmldetail;
temp = temp.Replace("@secno@", d.JoinId.ToString());
temp = temp.Replace("@ticketno@", QrCode);
temp = temp.Replace("@name@", d.Name.ToString());
temp = temp.Replace("@email@", d.Email.ToString());
temp = temp.Replace("@phone@", d.Phone.ToString());
temp = temp.Replace("@qrcode@", QrCode);
temp = temp.Replace("@orderno@", ord_code);
QR_Encode qr = new QR_Encode();
qr.BackColor = Color.White;
qr.ForeColor = Color.Black;
int i = qr.EncodeData(1, 0, true, -1, 5, url, HttpContext.Current.Server.MapPath("upload/" + QrCode + ".gif"), false, 255, 255);
//Bitmap b = qr.GetBMP; //輸出至前端
//Response.ContentType = "image/jpeg";
//b.Save(Response.OutputStream, ImageFormat.Gif);
//b.Dispose();
}
htmlstr = htmlstr.Replace("@detail@", temp1);
htmlstr = htmlstr.Replace("@classdetail@", temp);
return(htmlstr);
}
public static JoinData Get_ord_JoinData(string ord_code)
{
string strsql = @"select * FROM tbl_Joindata where ord_code=@ord_code";
NameValueCollection nvc = new NameValueCollection
{
{ "ord_code", ord_code }
};
DataTable dt = DbControl.Data_Get(strsql, nvc);
LessonLib.JoinData n = new LessonLib.JoinData();
OrderLib.OrderData o = OrderLib.Get_ordData(ord_code);
n.Id = 0;
if (dt.Rows.Count > 0)
{
n.Id = (int)dt.Rows[0]["joinid"];
n.Status = (string)dt.Rows[0]["status"];
n.TicketKind = (string)dt.Rows[0]["TicketKind"];
n.Articleid = (int)dt.Rows[0]["Articleid"];
n.Ord_code = (string)dt.Rows[0]["ord_code"];
n.OrderData = o;
n.LessonData = DbHandle.Get_Lesson(n.Articleid.ToString());
strsql = @"select * FROM tbl_joindetail where joinid=@joinid";
nvc.Clear();
dt.Dispose();
nvc = new NameValueCollection
{
{ "joinid", n.Id.ToString() }
};
dt = DbControl.Data_Get(strsql, nvc);
List <JoinDetail> detail = new List <JoinDetail>();
foreach (DataRow d in dt.Rows)
{
strsql = @"select * FROM tbl_joinlog where checkcode=@checkcode";
string checkcode = n.Ord_code
+ "-" + d["joinid"].ToString()
+ "-" + d["lessonid"].ToString();
nvc.Clear();
nvc = new NameValueCollection
{
{ "checkcode", checkcode }
};
DataTable c = DbControl.Data_Get(strsql, nvc);
detail.Add(new JoinDetail
{
JoinId = (int)d["joinid"],
Name = (string)d["username"],
Phone = (string)d["phone"],
Email = (string)d["email"],
Amount = (int)d["Amount"],
LessonId = (int)d["lessonid"],
Secno = (int)d["secno"],
Status = d["status"].ToString(),
Unitname = d["Unitname"].ToString(),
Postion = d["Postion"].ToString(),
checkin = c.Rows.Count == 0 ? "":"Y"
});
c.Dispose();
}
n.JoinDetail = detail;
}
return(n);
}
protected void Page_Load(object sender, EventArgs e)
{
string _key = "CD9Zyfb82BIFpnYY2JUppiF4a3f1FB1B";
_key = "By8IMdyhhfeTTgACeHciAYe6bGrXc6bA";
string _Vi = "jXbof2czX0r9FxBf";
_Vi = "hiDG6VP3CrOA32bM";
SpGatewayResponse spg = new SpGatewayResponse();
spg.Key = _key;
spg.Vi = _Vi;
spg.Status = Request["Status"];
spg.MerchantId = Request["MerchantID"];
spg.TradeInfo = Request["TradeInfo"];
spg.SaveLog();
spg.AddAtmlog();
if (Session["ord_code"] != null)
{
ord_code = Session["ord_code"].ToString();
}
if (Request.QueryString["ord_code"] != null)
{
ord_code = Request.QueryString["ord_code"];
}
if (ord_code == "")
{
Response.End();
}
ord_code = classlib.RemoveBadSymbol(ord_code);
DataTable dt = new DataTable();
string strsql = @"update tbl_OrderData set paid= 'Y', status =2 where ord_code=@ord_code";
NameValueCollection nvc = new NameValueCollection
{
{ "ord_code", ord_code }
};
DbControl.Data_add(strsql, nvc);
strsql = @"select * FROM tbl_OrderData where ord_code=@ord_code";
dt = DbControl.Data_Get(strsql, nvc);
string ord_id = dt.Rows[0]["ord_id"].ToString();
ord_tel = dt.Rows[0]["ordphone"].ToString();
ord_pay = OrderLib.getPaymode(dt.Rows[0]["paymode"].ToString());
ord_status = dt.Rows[0]["status"].ToString();
ord_date = DateTime.Parse(dt.Rows[0]["crtdat"].ToString()).ToString("yyyy/MM/dd");
ord_totalprice = "$" + dt.Rows[0]["TotalPrice"].ToString();
ord_name = dt.Rows[0]["ordname"].ToString();
ord_address = dt.Rows[0]["ordaddress"].ToString();
ord_email = dt.Rows[0]["email"].ToString();
ord_tel = dt.Rows[0]["ordphone"].ToString();
ord_ship_name = dt.Rows[0]["ordname"].ToString();
ord_ship_tel = dt.Rows[0]["ordphone"].ToString();
email = dt.Rows[0]["email"].ToString();
ord_ship_name = dt.Rows[0]["ordname"].ToString();
strsql = @"select * FROM tbl_OrderDetail INNER JOIN
tbl_productData ON tbl_OrderDetail.p_id = tbl_productData.p_id where ord_id=@ord_id";
nvc.Clear();
nvc.Add("ord_id", ord_id);
dt = DbControl.Data_Get(strsql, nvc);
temp_product.DataSource = dt;
temp_product.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userid"] == null || Session["Backmenu"] == null || Session["Backmenu"].ToString() == "")
{
Response.Redirect("~/account/login.aspx?ReturnUrl=" + Request.RawUrl.ToString());
Response.End();
}
string articleid = Request.QueryString["articleid"];
string strsql = @"select * FROM tbl_Joindata where articleid=@articleid";
NameValueCollection nvc = new NameValueCollection
{
{ "articleid", articleid }
};
DataTable dt = DbControl.Data_Get(strsql, nvc);
List <LessonLib.JoinData> JoinData = new List <LessonLib.JoinData>();
foreach (DataRow dr in dt.Rows)
{
LessonLib.JoinData j = LessonLib.Web.Get_ord_JoinData(dr["ord_code"].ToString());
JoinData.Add(j);
}
dt.Dispose();
int i = 0;
int total = 0;
foreach (LessonLib.JoinData j in JoinData)
{
foreach (LessonLib.JoinDetail d in j.JoinDetail)
{
var data = j.LessonData.LessonDetail.Find(y => y.LessonId == d.LessonId);
string qr = j.Ord_code + "-" + d.JoinId + "-" + d.LessonId;
total++;
html += "<tr>";
html += "<td>";
html += "<button type=\"button\"class=\"btn btn-primary\" data-ord_code=\"" + j.Ord_code + "\" data-toggle=\"modal\" data-target=\"#exampleModal\">";
html += j.Ord_code + "</button></td>";
html += "<td>" + OrderLib.getPaymode(j.OrderData.Paymode) + "</td>";
html += "<td>" + OrderLib.get_ord_status(j.OrderData.Status) + "</td>";
html += "<td>" + d.Name + "</td>";
html += "<td>" + d.Email + "</td>";
html += "<td>" + d.Phone + "</td>";
html += "<td>" + d.Unitname + "</td>";
html += "<td>" + d.Postion + "</td>";
html += "<td>" + d.checkin + "</td>";
html += "</tr>" + "\r\n";
if (d.checkin == "Y")
{
i++;
}
//string QrCode = j.Ord_code + "-" + d.JoinId.ToString() + "-" + d.LessonId;
//string url = "http://www.culturelaunch.net/lib/checkjoin.aspx?code=" + QrCode;
//QR_Encode qr = new QR_Encode
//{
// BackColor = Color.White,
// ForeColor = Color.Black
//};
//qr.EncodeData(1, 0, true, -1, 5, url, HttpContext.Current.Server.MapPath("/upload/" + QrCode + ".gif"), false, 255, 255);
}
}
//html += "<Tr><td></td><td>總報名人數</td><td>" + total + "</td>";
//html += "<td>已報到人數</td><td>" + i + "</td>";
//html += "<td><a href=\"javascript:window.print();\">列印</a></td><td></td><td></td><td></td></tr>";
////html += "</table>";
JoinData = null;
}
protected void Page_Load(object sender, EventArgs e)
{
OrderLib.OrderData o = new OrderLib.OrderData();
o = OrderLib.Get_ordData(Request.QueryString["ord_code"]);
action = "https://inv.pay2go.com/API/invoice_issue"; //正式ID
action = "https://cinv.pay2go.com/API/invoice_issue"; //測試ID
MerchantID = ""; //正式ID
MerchantID = "31117495"; //測試ID
string _key = "";
_key = "8hWZNZjoHkNDTTgOXGYJI4Rc5k3OR7CO";
string _Vi = "";
_Vi = "oaAyJlX2BcpSuj8m";
DateTime gtm = new DateTime(1970, 1, 1); //宣告一個GTM時間出來
DateTime utc = DateTime.UtcNow.AddHours(8); //宣告一個目前的時間
int timeStamp = Convert.ToInt32(((TimeSpan)utc.Subtract(gtm)).TotalSeconds);
int TaxAmt = 0;
string ItemName = "";
string ItemCount = "";
string ItemUnit = "";
string ItemPrice = "";
string ItemAmt = "";
string ItemTaxType = "";
int i = 0;
foreach (var p in o.OrderDetail)
{
ItemName += i == 0 ? p.P_name : "|" + p.P_name;
ItemCount += i == 0 ? p.Num.ToString() : "|" + p.Num.ToString();
ItemUnit += i == 0 ? "個" : "|個";
ItemPrice += i == 0 ? p.Price.ToString() : "|" + p.Price.ToString();
TaxAmt += Convert.ToInt16(Math.Ceiling(p.Amount * 0.05));
ItemAmt += i == 0 ? p.Amount.ToString() : "|" + p.Amount.ToString();
ItemTaxType += i == 0 ? "1" : "|1";
i++;
}
var pay2goInfo = new pay2goInfo()
{
RespondType = "JSON",
TimeStamp = timeStamp.ToString(),
Version = "1.4",
BuyerName = o.Ordname,
BuyerAddress = o.Shipaddress,
BuyerEmail = o.Ordemail,
BuyerPhone = o.Ordphone,
MerchantOrderNo = timeStamp.ToString(),//o.Ord_code ,
Category = "B2C",
TaxType = "1",
TaxRate = 5,
Amt = o.TotalPrice - TaxAmt,
TaxAmt = TaxAmt,
TotalAmt = o.TotalPrice,
CarrierType = "",
CarrierNum = Server.HtmlDecode(""),
LoveCode = "",
PrintFlag = "Y",
ItemName = ItemName,
ItemCount = ItemCount,
ItemUnit = ItemUnit,
ItemPrice = ItemPrice,
ItemAmt = ItemAmt,
ItemTaxType = ItemTaxType,
Comment = "TEST，備註說明",
Status = "1",
CreateStatusTime = ""
};
var postData = MyHelper.ToDictionary(pay2goInfo);
var cryptoHelper = new CryptoHelper(_key, _Vi);
var aesString = cryptoHelper.GetAesString(postData);
aes = aesString;
Sha = cryptoHelper.GetSha256String(aesString);
string URI = action;
string myParameters = "MerchantID_=" + MerchantID + "&PostData_=" + aes;
using (WebClient wc = new WebClient())
{
wc.Headers[HttpRequestHeader.ContentType] = "application/x-www-form-urlencoded";
string HtmlResult = wc.UploadString(URI, myParameters);
JObject restoredObject = JsonConvert.DeserializeObject <JObject>(HtmlResult);
JObject result = JsonConvert.DeserializeObject <JObject>(restoredObject["Result"].ToString());
Response.Write(HtmlResult);
string strsql = @"INSERT INTO InvoiceNumner(InvoiceTransNo, MerchantOrderNo, TotalAmt,
InvoiceNumber, RandomNum, CheckCode, CreateTime,
BarCode, QRcodeL, QRcodeR)
VALUES (@InvoiceTransNo, @MerchantOrderNo, @TotalAmt, @InvoiceNumber, @RandomNum, @CheckCode, @CreateTime,
@BarCode, @QRcodeL, @QRcodeR)";
NameValueCollection nvc = new NameValueCollection
{
{ "CheckCode", result["CheckCode"].ToString() },
{ "MerchantOrderNo", result["MerchantOrderNo"].ToString() },
{ "InvoiceNumber", result["InvoiceNumber"].ToString() },
{ "TotalAmt", result["TotalAmt"].ToString() },
{ "InvoiceTransNo", result["InvoiceTransNo"].ToString() },
{ "RandomNum", result["RandomNum"].ToString() },
{ "CreateTime", result["CreateTime"].ToString() },
{ "BarCode", result["BarCode"].ToString() },
{ "QRcodeL", result["QRcodeL"].ToString() },
{ "QRcodeR", result["QRcodeR"].ToString() }
};
if (result != null)
{
DbControl.Data_add(strsql, nvc);
}
//Dictionary<string, string> results = ((IDictionary<string, JToken>)(JObject)parsed["moretests"]).ToDictionary(pair => pair.Key, pair => (string)pair.Value);
Response.Write(restoredObject["Status"]);
Response.Write(restoredObject["Message"]);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string _key = "CD9Zyfb82BIFpnYY2JUppiF4a3f1FB1B";
string _Vi = "jXbof2czX0r9FxBf";
//_key = "By8IMdyhhfeTTgACeHciAYe6bGrXc6bA";
//_Vi = "hiDG6VP3CrOA32bM";
SpGatewayResponse spg = new SpGatewayResponse
{
Key = _key,
Vi = _Vi,
Status = Request["Status"],
MerchantId = Request["MerchantID"],
TradeInfo = Request["TradeInfo"]
};
spg.SaveLog();
spg.AddAtmlog();
if (Session["ord_code"] != null)
{
ord_code = Session["ord_code"].ToString();
}
if (Request.QueryString["ord_code"] != null)
{
ord_code = Request.QueryString["ord_code"];
}
if (ord_code == "")
{
Response.End();
}
ord_code = classlib.RemoveBadSymbol(ord_code);
SpGatewayHelper.Models.TradeInfoLog log = OrderLib.Get_Tradelog(ord_code);
ord_status = log.Status;
BankCode = log.Result.BankCode;
CodeNo = log.Result.CodeNo;
ExpireDate = log.Result.ExpireDate + " " + log.Result.ExpireTime;
OrderLib.OrderData o = OrderLib.Get_ordData(ord_code);
string ord_id = o.Ord_id.ToString();
string site_name = HttpContext.Current.Application["site_name"].ToString();
string filename = HttpContext.Current.Server.MapPath("/templates/letter.html");
string mailbody = unity.classlib.GetTextString(filename);
string atmmode = "<table><Tr><td colspan=2>您於「" + site_name + "」進行了ATM 轉帳交易，以下為您轉帳資訊</td></tr>";
atmmode += "<tr><td>訂單編號</td><td>" + log.Result.MerchantOrderNo + "</td></tr>";
atmmode += "<tr><td>銀行代碼</td><td>" + BankCode + "</td></tr>";
atmmode += "<tr><td>帳號</td><td >" + CodeNo + "</td></tr>";
atmmode += "<tr><td>金額</td><td >NT$" + log.Result.Amt + "</td></tr>";
atmmode += "<tr><td>有效期限</td><td>" + ExpireDate + "</td></tr></table>";
unity.classlib.SendsmtpMail(o.Ordemail, "ATM匯款帳號通知信", mailbody.Replace("@mailbody@", atmmode), "gmail");
if (o.OrderDetail != null)
{
Response.Redirect("/completed.aspx");
Response.End();
}
LessonLib.JoinData L = LessonLib.Web.Get_ord_JoinData(Session["ord_code"].ToString());
if (L.JoinDetail != null)
{
Response.Redirect("/process-step4.aspx");
}
}