public ActionResult ToInsert(string datas)
{
var scores = JsonSerializer.Deserialize <Score[]>(datas);
foreach (var i in scores)
{
CProductRank rank = new CProductRank();
rank.fRank = i.score;
rank.fComment = i.message;
rank.fSubmitDataTime = DateTime.UtcNow.AddHours(08);
rank.fDetailOrderIId = i.id;
CProductRankFactory.fn評價新增(rank);
var a = CDetailOrderFactory.fn訂單明細查詢().Where(n => n.fDetailOrderIId == i.id).ToList();
CNotice c = new CNotice();
c.fCategoryType = "評價留言";
c.fLink = "超連結";
c.fNoticeDatetime = DateTime.UtcNow.AddHours(08);
c.fMemberId = a.Single().fMemberSellerId;
c.fNoticeContent = "您的" + a.Single().fName + "以新增評價";
CNoticeFactory.fn通知訂單訊息新增(c);
}
return(new ApiResult());
}
//將選取的對象加入黑名單
public string intoblacklist(int memberid, string blackreason)
{
var goblacklist = CMemberFactory.fn會員查詢().FirstOrDefault(g => g.fMemberId == memberid);
if (goblacklist.fIsBanned == true)//判斷是否已經是黑名單 避免重複加入黑名單
{
ViewBag.blacklist = "此會員已是黑名單會員";
return("已是黑名單成員");
}
else
{
goblacklist.fIsBanned = true;
CMemberFactory.fn會員更新(goblacklist);
CBlackListFactory.fn黑名單新增(new CBlackList()
{
fLockDateTime = DateTime.UtcNow.AddHours(08),
fMemberId = memberid,
fReason = blackreason
});
CNotice c = new CNotice();
c.fNoticeDatetime = DateTime.Now;
c.fNoticeContent = "此帳號因發言屢次違規已被設為黑名單，期間內無法針對商品進行留言";
c.fCategoryType = "管理員";
c.fLink = "超連結";
c.fMemberId = goblacklist.fMemberId;
CNoticeFactory.fn通知訂單訊息新增(c);
return("黑名單更新成功！");
}
}
//會員訊息查詢-----------------------------------------------------\\
public ActionResult MemberNotice()
{
CMember member = Session[CMemberSession.Session_Login_User] as CMember;
if (member != null)
{
var SelectNotices = CNoticeFactory.fn通知訊息查詢(member).ToList().OrderByDescending(n => n.fNoticeDatetime);
var Count銷售 = CNoticeFactory.fn通知訊息查詢(member).Where(n => n.fCategoryType == "銷售").Count();
var Count留言 = CNoticeFactory.fn通知訊息查詢(member).Where(n => n.fCategoryType == "評價留言").Count();
ViewBag.Count銷售 = Count銷售;
ViewBag.Count留言 = Count留言;
return(View("../Member/MemberNotice", SelectNotices));
}
return(RedirectToAction("../Home/Index"));
}
public string SignIn(CMember m, CNotice c)
{
List <CMember> SELECTMember = CMemberFactory.fn會員查詢();
CMember member = SELECTMember.FirstOrDefault(n => n.fAccount == m.fAccount);
var data = "";
if (member == null)
{
string str = m.fPassword + "QAQ";
var md5 = CMemberFactory.MD5驗證碼新增(str);
m.fMoneyPoint = 100;
m.fPhoto = "../Image/MemberImage/Member.jpg";
m.fRegisterDateTime = DateTime.UtcNow.AddHours(08);
m.fLastLoginDateTime = DateTime.UtcNow.AddHours(08);
m.fIsVIP = false;
m.fIsBanned = false;
m.fThePasswordURL = md5;
m.fTheAddress = m.fCity + m.fTown + m.fTheAddress;
CMemberFactory.fn會員新增(m);
//會員註冊訊息新增---------------------------------------------------------------\\
List <CMember> SELECTMember2 = CMemberFactory.fn會員查詢();
CMember member2 = SELECTMember2.FirstOrDefault(n => n.fAccount == m.fAccount);
c.fNoticeDatetime = DateTime.UtcNow.AddHours(08);
c.fNoticeContent = m.fFirstName + m.fLastName + "歡迎加入Notedge!";
c.fCategoryType = "系統";
c.fLink = "我是超連結";
c.fMemberId = member2.fMemberId;
CNoticeFactory.fn通知訊息新增(member2, c);
//會員註冊新增未分類筆記----------------------------------------------------------\\
CNoteFolderFactory.fn建立預設筆記資料夾(member2);
data = "新增成功";
return(data);
}
else
{
data = "新增失敗";
ViewBag.Message = "信箱與人重複，請重新輸入";
return(data);
}
}
//將選取的對象加入黑名單
public string commentboard(int commentid, string content, int memberid)
{
CAdmin admin = Session[CAdminSession.Session_Login_User] as CAdmin;
var comment = CCommentFactory.fn留言查詢().FirstOrDefault(m => m.fCommentId == commentid);
comment.fContent = content;
comment.fIsBanned = true;
CCommentFactory.fn留言更新(comment);
var member = CMemberFactory.fn會員查詢().FirstOrDefault(n => n.fMemberId == memberid);
CNotice c = new CNotice();
c.fNoticeDatetime = DateTime.UtcNow.AddHours(08);
c.fNoticeContent = "此留言因涉及違規發言已被遮蔽";
c.fCategoryType = "管理員";
c.fLink = "超連結";
c.fMemberId = member.fMemberId;
CNoticeFactory.fn通知訂單訊息新增(c);
return("遮蔽原因更新成功！");
}
//將選取的對象解除黑名單
public string unlockBlacklist(int bannid, int memberid)
{
CAdmin admin = Session[CAdminSession.Session_Login_User] as CAdmin;
List <CBlackList> blacklist = new List <CBlackList>();
var unlock = CBlackListFactory.fn黑名單查詢().FirstOrDefault(m => m.fBannedId == bannid);
var member = CMemberFactory.fn會員查詢().FirstOrDefault(n => n.fMemberId == memberid);
member.fIsBanned = false;
CMemberFactory.fn會員更新(member);
CBlackListFactory.fn黑名單刪除(unlock);
CNotice c = new CNotice();
c.fNoticeDatetime = DateTime.UtcNow.AddHours(08);
c.fNoticeContent = "此帳號已從黑名單解鎖";
c.fCategoryType = "管理員";
c.fLink = "超連結";
c.fMemberId = member.fMemberId;
CNoticeFactory.fn通知訂單訊息新增(c);
return("解鎖成功!");
}
public void ToOrder(int totalprice, int remain, int cartId)
{
CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員
COrder o = new COrder();
o.fPurchaseDate = DateTime.UtcNow.AddHours(08);
o.fTotalPrice = totalprice;
o.fMemberId = member.fMemberId;
COrderFactory.fn訂單新增(o);
CMemberFactory.fn會員更新點數(member, remain);
CNotice c = new CNotice();
c.fCategoryType = "系統";
c.fLink = "超連結";
c.fNoticeDatetime = DateTime.UtcNow.AddHours(08);
c.fMemberId = member.fMemberId;
c.fNoticeContent = "您的訂單已完成了";
CNoticeFactory.fn通知訂單訊息新增(c);
List <CCartProduct> CP = CCartProductFactory.fn購物車商品個人查詢(cartId).ToList();
var f = CNoteFolderFactory.fn筆記資料夾查詢(member).Where(q => q.fFolderName == "未分類筆記").ToList();
int orderid = COrderFactory.fn訂單查詢(member).LastOrDefault().fOrderId;
foreach (var a in CP)
{
CDetailOrderFactory.fn訂單明細新增(orderid, a.fProductId);
CNotice c1 = new CNotice();
c1.fCategoryType = "銷售";
c1.fLink = "超連結";
c1.fNoticeDatetime = DateTime.UtcNow.AddHours(08);
c1.fMemberId = a.fMemberSellerId;
c1.fNoticeContent = "您的" + a.fName + "已被購買";
CNoticeFactory.fn通知訂單訊息新增(c1);
CIncome i1 = new CIncome();
i1.fIncome = a.fPrice;
i1.fPaymentDateTime = DateTime.UtcNow.AddHours(08);
i1.fIncomeCategory = "獲利";
i1.fMemberId = a.fMemberSellerId;
CIncomeFactory.fn公司獲利新增(i1);
var point = CMemberFactory.fn會員查詢().Where(z => z.fMemberId == a.fMemberSellerId);
int point1 = (point.Single().fMoneyPoint) + a.fPrice;
CMember cm1 = new CMember();
cm1.fMemberId = point.Single().fMemberId;
CMemberFactory.fn會員更新點數(cm1, point1);
var t = CNoteFactory.fn私人筆記全部查詢().Where(q => q.fFolderId == f.Single().fFolderId).ToList();
int t1 = t.Count();
CNote n = new CNote();
n.fNoteListName = a.fName;
n.fCreateDateTime = DateTime.UtcNow.AddHours(08);
n.fEditDateTime = DateTime.UtcNow.AddHours(08);
n.fNoteListLevel = t1;
n.fIsMyFavourite = false;
n.fIsTrash = false;
n.fFolderId = f.Single().fFolderId;
n.fJsonContent = a.fContent;
n.fTheShareLink = null;
n.fTheContactPerson = null;
n.fHTMLContent = "";
CNoteFactory.fn訂單私人筆記新增(n);
}
CCartFactory.fn購物車個人更新(cartId);
}
//登入後主畫面-------------------------------------------------------------------------------\\
public ActionResult MyHome(string name, string id, CNotice c)
{
CMember member = Session[CMemberSession.Session_Login_User] as CMember;
//創造一組亂數字串不重複的訂單編號
var str = "123456789ABCDEFGHIJKLMNPQRSTUVWXYZabcdefhijklmnorstuvwxz";
var next = new Random();
var builder = new StringBuilder();
for (var i = 0; i < 10; i++)
{
builder.Append(str[next.Next(0, str.Length)]);
}
//MerchantID(不可變動)，MerchantTradeNo(亂數訂單編號)，MerchantTradeDate(抓取當前日期時間)
int MerchantID = 2000132;
var MerchantTradeNo = builder;
string MerchantTradeDate = DateTime.UtcNow.AddHours(08).ToString("yyyy/MM/dd hh:mm:ss");
/*tring ReturnUrl = "https://localhost:44300/Home/MyHome?id=" + MerchantTradeNo;*/
string ReturnUrl = "https://noteledge.azurewebsites.net/Home/MyHome?id=" + MerchantTradeNo;
string ProductName = "Notedge尊爵鑽石豪華VIP頂級會員";
int Amount = 99;
//把需要的資料作串接
string Url = "HashKey=5294y06JbISpM5x9&ChoosePayment=ALL&ChooseSubPayment=&ClientBackURL=" + ReturnUrl + "&EncryptType=1&ItemName="
+ ProductName
+ "&MerchantID="
+ MerchantID
+ "&MerchantTradeDate="
+ MerchantTradeDate
+ "&MerchantTradeNo="
+ MerchantTradeNo
+ "&PaymentType=aio&ReturnURL=" + ReturnUrl + "&StoreID=&TotalAmount=" + Amount + "&TradeDesc=建立全金流測試訂單&HashIV=v77hoKGq4kWxNNIS";
//串接好的資料轉成Encoded
var Encoded = System.Web.HttpUtility.UrlEncode(Url);
//Encoded 轉成 小寫 encoded
var encoded = Encoded.ToLower();
//呼叫sha256_hash(encoded)轉換成SHA256 在轉換大寫
string SHA256 = sha256_hash(encoded).ToUpper();
//把資料傳到前端
ViewBag.MerchantID = MerchantID;
ViewBag.MerchantTradeNo = MerchantTradeNo;
ViewBag.MerchantTradeDate = MerchantTradeDate;
ViewBag.SHA256 = SHA256;
ViewBag.Url = ReturnUrl;
ViewBag.ProductName = ProductName;
ViewBag.Amount = Amount;
if (id != null)
{
List <CMember> SelecteMember = CMemberFactory.fn會員查詢();
CMember cMember = SelecteMember.FirstOrDefault(n => n.fMemberId == member.fMemberId);
cMember.fIsVIP = true;
cMember.fMoneyPoint = cMember.fMoneyPoint + 500;
CMemberFactory.fn會員更新(cMember);
//成為VIP新增通知----------------------------------------------------------------------\\
c.fNoticeDatetime = DateTime.UtcNow.AddHours(08);
c.fNoticeContent = cMember.fFirstName + cMember.fLastName + "您已成為Notedge尊爵鑽石豪華VIP頂級會員";
c.fCategoryType = "系統";
c.fLink = "連結";
c.fMemberId = member.fMemberId;
CNoticeFactory.fn通知訊息新增(member, c);
Session[CMemberSession.Session_Login_User] = cMember;
if (Session[CMemberSession.Session_Login_User] == null && name == null)
{
Session[CMemberSession.Session_Login_User] = null;
return(RedirectToAction("../Home/Index"));
}
else
{
ViewBag.name = name;
return(View("../Home/MyHome", "_Layout"));
}
}
if (Session[CMemberSession.Session_Login_User] == null && name == null)
{
Session[CMemberSession.Session_Login_User] = null;
return(RedirectToAction("../Home/Index"));
}
else
{
if (name == null)
{
var SelectNoticess = CNoticeFactory.fn通知訊息查詢(member).Where(n => n.fCategoryType == "銷售" || n.fCategoryType == "評價留言").OrderByDescending(n => n.fNoticeDatetime);
var SelectChats = CChatFactory.fn聊聊查詢(member).Where(n => n.fMemberTo == member.fMemberId).OrderByDescending(n => n.fSubmitDateTime);
int MCounts = SelectChats.Count();
int SCounts = SelectNoticess.Count();
CMemberMessage memberMessage = new CMemberMessage();
if (Session[CMemberSession.Session_Message_Count] == null)
{
memberMessage.MessageBell = MCounts;
Session[CMemberSession.Session_Message_Count] = memberMessage;
}
if (Session[CMemberSession.Session_sale_Count] == null)
{
memberMessage.SaleBell = SCounts;
Session[CMemberSession.Session_sale_Count] = memberMessage;
}
return(View("../Home/MyHome", "_Layout"));
}
else
{
ViewBag.name = name;
return(View("../Home/MyHome", "_Layout"));
}
}
}
