public ActionResult Order()
{
Guid Memberid = Guid.Parse(System.Web.HttpContext.Current.Session["Memberid"].ToString());
int Now = (int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds;
Setting Setting = settingService.Get().FirstOrDefault();
ViewBag.TotalNumber = membersService.Get().Count(); // 會員總人數
ViewBag.Max = Setting.Max;
ViewBag.Min = Setting.Min;
/**** HTTP GET ****/
string url = "http://www.heohelp.com:80/";
WebRequest myReq = WebRequest.Create(url);
myReq.Method = "GET";
myReq.ContentType = "application/json; charset=UTF-8";
UTF8Encoding enc = new UTF8Encoding();
myReq.Headers.Remove("auth-token");
WebResponse wr = myReq.GetResponse();
Stream receiveStream = wr.GetResponseStream();
StreamReader reader = new StreamReader(receiveStream, Encoding.UTF8);
string content = reader.ReadToEnd();
string[] status = content.Replace("\"", "").Split('#');
return(View());
}
public ActionResult AddFeedbackproduct(Feedbackproduct feedbackproduct)
{
if (TryUpdateModel(feedbackproduct, new string[] { "Feedbackproductname" }) && ModelState.IsValid)
{
feedbackproduct.Feedbackproductid = Guid.NewGuid();
feedbackproduct.Uuid = Guid.NewGuid();
feedbackproduct.Createdate = DateTime.Now;
feedbackproduct.Updatedate = DateTime.Now;
feedbackproductService.Create(feedbackproduct);
foreach (Feedbackdetail feedbackdetail in feedbackproduct.Feedbackdetail)
{
feedbackdetail.Setid = Guid.NewGuid();
feedbackdetail.Feedbackproductid = feedbackproduct.Feedbackproductid;
feedbackdetailService.Create(feedbackdetail);
}
feedbackproductService.SaveChanges();
IEnumerable <Members> member = membersService.Get();
foreach (Members thismember in member)
{
Memberauthorization memberauth = new Memberauthorization();
memberauth.Id = Guid.NewGuid();
memberauth.Memberid = thismember.Memberid;
memberauth.Feedbackproductid = feedbackproduct.Feedbackproductid;
memberauth.Checked = true;
memberauthorizationService.Create(memberauth);
}
memberauthorizationService.SaveChanges();
}
return(RedirectToAction("Feedbackproduct"));
}
public void GetSomeMember()
{
IMembersService members = new MembersService(myemma);
var member = members.Get("752395550");
Assert.IsNotNull(member);
}
public void GetAllMembers()
{
IMembersService members = new MembersService(myemma);
var list = members.Get();
Assert.IsNotNull(list);
}
public void userConnected()
{
Setting setting = settingService.Get().FirstOrDefault();
//Guid Vipid = memberlevelService.Get().Where(a => a.Levelname == "VIP").FirstOrDefault().Levelid;
int Now = (int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800; // 目前時間的總秒數
var query = membersService.Get().Where(x => x.Is_import == 0 || x.Is_import == 2).Where(a => a.Logindate >= Now).Count();
Clients.User(Context.ConnectionId);
Clients.All.getList(query);
}
public async Task Get_ShouldReturnMembers()
{
// arrange
var expectedMembers = _fixture
.CreateMany <Member>(42)
.ToArray();
_membersRepositoryMock
.Setup(x => x.Get())
.ReturnsAsync(expectedMembers);
// act
var members = await _service.Get();
// assert
members.Should().NotBeNullOrEmpty()
.And.HaveCount(expectedMembers.Length);
_membersRepositoryMock.Verify(x => x.Get(), Times.Once);
}
// GET: AjaxMembers
public JsonResult AjaxMembersData(int start, int length)
{
string[] data = new string[12];
string search = Request.QueryString["search[value]"];
ViewBag.search = search;
//var data = membersService.Get().OrderByDescending(o => o.Createdate);
var members = membersService.Get();
members = members.Where(a => a.Account == search || a.Name == search).Take(length);
members = members.OrderByDescending(o => o.Createdate).ToList();
//if (members != null)
//{
// foreach (Members list in members)
// {
// switch (list.Is_import)
// {
// case 0:
// data[0] = "<td class='text-center'><i class='fa fa-male' aria-hidden='true' style='color:green'></i></td>";
// break;
// case 1:
// data[0] = "<td class='text - center'><i class='fa fa-android' aria-hidden='true' style='color: red'></i></td>";
// break;
// default:
// data[0] = "<td class='text - center'><i class='fa fa-android' aria-hidden='true' style='color: blue'></i></td>";
// break;
// }
// }
//}
//ViewBag.message = "按下確定後開始驗證帳號，請勿關閉分頁";
///*** 驗證狀態人數統計 ***/
//ViewBag.Question = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 0).Count();
//ViewBag.Check = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 1).Count();
//ViewBag.Times = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 2).Count();
///**** 機器人、前台登入、仿前台登入機器人的人數 ****/
//ViewBag.Robot = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 1).Where(a => a.Is_import == 1).Count();
//ViewBag.FrontLoginNumber = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 1).Where(a => a.Is_import == 0).Count();
//ViewBag.RobotFrontLoginNumber = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(o => o.Createdate).FirstOrDefault().Status == 1).Where(a => a.Is_import == 2).Count();
return(this.Json(members.ToArray(), JsonRequestBehavior.AllowGet));
}
/*** Service要帳密 ***/
public JsonResult GetAccount(string Id, int number, string Ordernumber)
{
if (Id == "heo_order")
{
Setting setting = settingService.Get().FirstOrDefault();
Order order = orderService.Get().Where(a => a.Ordernumber == Ordernumber).FirstOrDefault(); // 撈訂單的詳細資料
Feedbackproduct feedbackproduct = feedbackproductService.Get().Where(a => a.Feedbackproductname.Contains(order.Service)).FirstOrDefault(); // 撈訂單產品的詳細資料
IEnumerable <Orderfaceooklist> orderfacebookList = orderfacebooklistService.Get().Where(a => a.Order.Ordernumber == Ordernumber); // 撈訂單之前的按讚名單紀錄
IEnumerable <Order> old_order = orderService.Get().Where(x => x.Ordernumber != order.Ordernumber).Where(c => c.Service == feedbackproduct.Feedbackproductname).Where(a => a.Url == order.Url); // 撈所有訂單裡網址為訂單的資料
List <get_old_member> MemberList = new List <get_old_member>();
/**** 判斷訂單是不是HEO內部的單 ***/
if (order.Ordernumber.Contains("heo"))
{
/*** 先將自己給排除掉 ****/
MemberList.Add(
new get_old_member
{
Memberid = order.Members.Memberid
});
}
/**** 將這張單的按讚列表的人排除掉 *****/
if (orderfacebookList.Count() > 0)
{
foreach (Orderfaceooklist thisorderfacebookList in orderfacebookList)
{
MemberList.Add(
new get_old_member
{
Memberid = Guid.Parse(thisorderfacebookList.Memberid.ToString())
}
);
}
}
/*** 將同網址的訂單的按站讚列表的人排除掉 ****/
if (old_order.Count() > 0)
{
foreach (Order thisold_order in old_order)
{
IEnumerable <Orderfaceooklist> oldorderfacebooklist = orderfacebooklistService.Get().Where(a => a.Orderid == thisold_order.Orderid);
foreach (Orderfaceooklist thisoldorderfaceooklist in oldorderfacebooklist)
{
MemberList.Add(
new get_old_member
{
Memberid = Guid.Parse(thisoldorderfaceooklist.Memberid.ToString())
}
);
}
}
}
Guid VipLevelid = memberlevelService.Get().Where(a => a.Levelname == "VIP").FirstOrDefault().Levelid; // VIP層級的ID
if (order.Ordernumber.Contains("heo"))
{
/*** HEO內部下的訂單 ***/
List <get_member> AccountList = new List <get_member>();
/*** 先撈前台登入、仿前台登入的使用者 ***/
IEnumerable <Members> members = membersService.Get().Where(s => s.Is_import == 0 || s.Is_import == 2).Where(c => c.Levelid != VipLevelid).Where(x => x.Lastdate <= Now).Where(a => a.Logindate >= Now).Where(c => c.Memberloginrecord.OrderByDescending(a => a.Createdate).FirstOrDefault().Status == 1).OrderBy(x => x.Lastdate); // 撈層級非VIP的帳號詳細資料
if (members != null)
{
foreach (Members thismembers in members)
{
bool used = false;
int loop;
for (loop = 0; loop < MemberList.Count(); loop++)
{
if (thismembers.Memberid.Equals(MemberList[loop].Memberid))
{
used = true;
}
}
if (used == false)
{
AccountList.Add(
new get_member
{
memberid = thismembers.Memberid,
account = thismembers.Account,
password = thismembers.Password,
useragent_phone = thismembers.Useragent_phone,
facebookcookie = thismembers.Facebookcookie,
}
);
used = false;
}
}
foreach (get_member entity in AccountList.Take(number))
{
/*** 將此會員更新下次互惠時間 ****/
Members member = membersService.GetByID(entity.memberid);
member.Lastdate = Now + (int)setting.Time;
membersService.SpecificUpdate(member, new string[] { "Lastdate" });
}
membersService.SaveChanges();
return(this.Json(AccountList.Take(number), JsonRequestBehavior.AllowGet));
}
else
{
/*** 前台沒人可以抓了，改抓機器人 ***/
IEnumerable <Members> Botmembers = membersService.Get().Where(s => s.Is_import == 1).Where(x => x.Lastdate <= Now).Where(c => c.Memberloginrecord.OrderByDescending(a => a.Createdate).FirstOrDefault().Status != 2).OrderBy(x => x.Lastdate);
if (members != null)
{
bool used = false;
foreach (Members thismembers in Botmembers)
{
int loop;
for (loop = 0; loop < MemberList.Count(); loop++)
{
if (thismembers.Memberid.Equals(MemberList[loop].Memberid))
{
used = true;
}
}
if (used == false)
{
AccountList.Add(
new get_member
{
memberid = thismembers.Memberid,
account = thismembers.Account,
password = thismembers.Password,
useragent_phone = thismembers.Useragent_phone,
facebookcookie = thismembers.Facebookcookie,
}
);
used = false;
}
}
if (AccountList.Count() < number)
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
else
{
foreach (get_member entity in AccountList.Take(number))
{
/*** 將此會員更新下次互惠時間 ****/
Members member = membersService.GetByID(entity.memberid);
member.Lastdate = Now + (int)setting.Time;
membersService.SpecificUpdate(member, new string[] { "Lastdate" });
}
membersService.SaveChanges();
return(this.Json(AccountList.Take(number), JsonRequestBehavior.AllowGet));
}
}
else
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
}
}
else
{
/*** HDZ餵來的訂單 ***/
IEnumerable <Members> members = membersService.Get().Where(x => x.Lastdate <= Now).Where(b => b.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status != 2).Where(s => s.Memberauthorization.Where(q => q.Feedbackproductid == feedbackproduct.Feedbackproductid).FirstOrDefault().Checked == true).OrderBy(x => x.Lastdate);
if (members != null)
{
List <get_member> AccountList = new List <get_member>();
bool used_accoount = false;
foreach (Members thismembers in members)
{
int loop;
if (MemberList.Count() > 0)
{
for (loop = 0; loop < MemberList.Count(); loop++)
{
if ((thismembers.Memberid.Equals(MemberList[loop].Memberid)) == true)
{
used_accoount = true;
}
}
}
if (!used_accoount)
{
AccountList.Add(
new get_member
{
memberid = thismembers.Memberid,
account = thismembers.Account,
password = thismembers.Password,
useragent_phone = thismembers.Useragent_phone,
facebookcookie = thismembers.Facebookcookie,
}
);
}
used_accoount = false;
}
/*** 可用人數小於該訂單所需人數 ***/
if (AccountList.Count < number)
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
else
{
foreach (get_member entity in AccountList.Take(number))
{
/*** 將此會員更新下次互惠時間 ****/
Members member = membersService.GetByID(entity.memberid);
member.Lastdate = Now + (int)setting.Time;
membersService.SpecificUpdate(member, new string[] { "Lastdate" });
}
}
membersService.SaveChanges();
return(this.Json(AccountList.Take(number), JsonRequestBehavior.AllowGet));
}
else
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
}
}
else
{
string status = "Error";
return(this.Json(status, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Members(int p = 1)
{
//var data = membersService.Get().OrderByDescending(o => o.Createdate);
var data = membersService.Get().OrderByDescending(o => o.Createdate);
//ViewBag.pageNumber = p;
ViewBag.Members = data;
//ViewBag.message = "按下確定後開始驗證帳號，請勿關閉分頁";
//LevelDropDownList("Members");
/*** 驗證狀態人數統計 ***/
ViewBag.Question = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 0).Count();
ViewBag.Check = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 1).Count();
ViewBag.Times = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 2).Count();
/**** 機器人、前台登入、仿前台登入機器人的人數 ****/
ViewBag.Robot = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 1).Where(a => a.Is_import == 1).Count();
ViewBag.FrontLoginNumber = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status == 1).Where(a => a.Is_import == 0).Count();
ViewBag.RobotFrontLoginNumber = membersService.Get().Where(a => a.Memberloginrecord.OrderByDescending(o => o.Createdate).FirstOrDefault().Status == 1).Where(a => a.Is_import == 2).Count();
return(View());
}
public ActionResult Login(Members members)
{
string Account = Regex.Replace(members.Account, @"[^a-z||A-Z||@||.||0-9||_]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
Members thismember = membersService.Get().Where(a => a.Account == members.Account).FirstOrDefault();
string useragent_phone = "";
if (thismember != null)
{
useragent_phone = thismember.Useragent_phone;
}
else
{
/***** useragent *****/
useragent_phone = "Mozilla/5.0 (iPhone; CPU iPhone OS 11_1_2 like Mac OS X) AppleWebKit/604.3.5 (KHTML, like Gecko) Version/11.0 Mobile/15B202 Safari/604.1";
}
/**** HTTP POST ****/
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create("http://heohelp.com:8080/Check/CheckFacebook");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = new JavaScriptSerializer().Serialize(new
{
Account = Account,
Password = members.Password,
Useragent = useragent_phone
});
streamWriter.Write(json);
}
HttpWebResponse httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
string result = "";
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
result = streamReader.ReadToEnd();
}
//ViewBag.message = result;
//return View();
string[] status = result.Replace("\"", "").Split('#');
///**** 測試用 ****/
//string[] status = new string[5];
//status[0] = "成功登入!";
//status[1] = "";
//status[2] = "";
//status[3] = "";
//status[4] = "";
if (status[0] == "成功登入!")
{
Session["Img"] = status[2];
Session["Facebookname"] = status[3];
IEnumerable <Members> old_members = membersService.Get().ToList();
Guid NormalLevelid = memberlevelService.Get().Where(a => a.Levelname == "一般").FirstOrDefault().Levelid;
IEnumerable <Feedbackproduct> feedbackproduct = feedbackproductService.Get();
foreach (Members old_member in old_members)
{
if (old_member.Facebookid.Equals(status[1]))
{
if (Session["href"] == null)
{
if (old_member.Facebookstatus == 0)
{
Session["IsLogin"] = true;
Session["Memberid"] = old_member.Memberid;
/**** 將會員成功登入寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = old_member.Memberid;
memberloginrecord.Createdate = DateTime.Now;
memberloginrecord.Status = 1;
memberloginrecordService.Create(memberloginrecord);
memberloginrecordService.SaveChanges();
/**** End Memberloginrecord ****/
/**** 更新會員Facebooklink連結 *****/
old_member.Facebookid = status[1];
old_member.Facebookcookie = status[4];
old_member.Password = members.Password; // 更新密碼
old_member.Logindate = ((int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800); // 登入時間為現在時間的總秒數
membersService.SpecificUpdate(old_member, new string[] { "Facebookid", "Facebookcookie", "Logindate", "Password" });
membersService.SaveChanges();
/***** End Facebookid ****/
return(RedirectToAction("Certified"));
}
else
{
Session["IsLogin"] = true;
Session["Memberid"] = old_member.Memberid;
/**** 將會員成功登入寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = old_member.Memberid;
memberloginrecord.Createdate = DateTime.Now;
memberloginrecord.Status = 1;
memberloginrecordService.Create(memberloginrecord);
memberloginrecordService.SaveChanges();
/**** End Memberloginrecord ****/
/**** 更新會員Facebookid連結 *****/
old_member.Facebookid = status[1];
old_member.Facebookcookie = status[4];
old_member.Password = members.Password; // 更新密碼
old_member.Logindate = ((int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800); // 登入時間為現在時間的總秒數
membersService.SpecificUpdate(old_member, new string[] { "Facebookid", "Facebookcookie", "Logindate", "Password" });
membersService.SaveChanges();
/***** End Facebookid ****/
return(RedirectToAction("Order", "OrderMs"));
}
}
else
{
Session["IsLogin"] = true;
Session["Memberid"] = old_member.Memberid;
/**** 將會員成功登入寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = old_member.Memberid;
memberloginrecord.Createdate = DateTime.Now;
memberloginrecord.Status = 1;
memberloginrecordService.Create(memberloginrecord);
memberloginrecordService.SaveChanges();
/**** End Memberloginrecord ****/
/**** 更新會員Facebookid連結 *****/
old_member.Facebookid = status[1];
old_member.Facebookcookie = status[4];
old_member.Password = members.Password; // 更新密碼
old_member.Logindate = ((int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800); // 登入時間為現在時間的總秒數
membersService.SpecificUpdate(old_member, new string[] { "Facebookid", "Facebookcookie", "Logindate", "Password" });
membersService.SaveChanges();
/***** End Facebookid ****/
return(RedirectToAction("Deposit", "DepositMs"));
}
}
}
if (TryUpdateModel(members, new string[] { "Password" }))
{
/*** 隨機抓取Useragent ***/
int useragentCount = useragentService.Get().Count();
Useragent[] useragent = useragentService.Get().ToArray();
Random crand = new Random();
int rand = crand.Next(0, useragentCount - 1);
/******* 新增會員 ********/
members.Memberid = Guid.NewGuid();
members.Levelid = NormalLevelid;
members.Isenable = 1;
members.Is_import = 0; // 是否匯入【0: 前台登入 , 1 : 後台匯入 , 2 : 轉前台】
members.Account = Account;
members.Createdate = DateTime.Now;
members.Updatedate = DateTime.Now;
members.Facebookcookie = status[4];
members.Useragent_phone = useragent[rand].User_agent;
members.Lastdate = (int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800;
members.Logindate = (int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800; // 紀錄目前登入時間
members.Name = status[3];
members.Facebookid = status[1];
/*** 預設將產品授權功能為fasle 【false:未授權 , true: 已授權】 ***/
foreach (Feedbackproduct feedbackproductlist in feedbackproduct)
{
Memberauthorization memberauthorization = new Memberauthorization();
memberauthorization.Id = Guid.NewGuid();
memberauthorization.Memberid = members.Memberid;
memberauthorization.Feedbackproductid = feedbackproductlist.Feedbackproductid;
memberauthorization.Checked = false;
members.Memberauthorization.Add(memberauthorization);
//memberauthorizationService.Create(memberauthorization);
}
/**** 將會員成功登入寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = members.Memberid;
memberloginrecord.Createdate = members.Createdate;
memberloginrecord.Status = 1;
members.Memberloginrecord.Add(memberloginrecord);
/**** End Memberloginrecord ****/
membersService.Create(members);
membersService.SaveChanges();
}
Session["IsLogin"] = true;
Session["Memberid"] = members.Memberid;
if (Session["href"] == null)
{
return(RedirectToAction("Certified"));
}
else
{
return(RedirectToAction("Deposit", "DepositMs"));
}
}
else
{
/*** 如果該會員有登過heo ***/
if (thismember != null)
{
/**** 將會員登入失敗寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = thismember.Memberid;
memberloginrecord.Createdate = DateTime.Now;
memberloginrecord.Status = 2;
memberloginrecordService.Create(memberloginrecord);
memberloginrecordService.SaveChanges();
/**** End Memberloginrecord ****/
}
ViewBag.Status = status[0];
return(View());
}
}
