public string ResetPassWord(SimpleUserModel user)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
// 判断手机号是否存在
db_User dbUser = context.db_User.Where(c => c.PhoneNumber == user.PhoneNumber.Trim()).FirstOrDefault();
if (dbUser == null)
{
//手机号不存在
message.MessageCode = MESSAGE.NOUSER_CODE;
message.Message = MESSAGE.NOUSER;
}
else
{
//修改密码
MD5 md5Hash = MD5.Create();
dbUser.UserPassWord = Common.GetMd5Hash(md5Hash, user.PassWord);
context.SaveChanges();
//修改成功
message.MessageCode = MESSAGE.OK_CODE;
message.Message = MESSAGE.OK;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string MyAllTeam(SimpleTeamModel team)
{
string result = "";
MessageModel message = new MessageModel();
List <TeamModel> teamInfo = new List <TeamModel>();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//三种情况：1.不属于任何战队，也没有自己的战队。2.是某战队的队员。 3.是某战队的队长
db_User user = context.db_User.Where(c => c.UserID == team.CreatUserID).FirstOrDefault();
if (user != null)
{
//获取用户的所有战队信息
teamInfo = Team.MyAllTeam(user.UserID);
}
else
{
//无此用户
message.Message = MESSAGE.NOUSER;
message.MessageCode = MESSAGE.NOUSER_CODE;
}
returnResult.Add(message);
returnResult.Add(teamInfo);
}
result = jss.Serialize(returnResult);
return(result);
}
public ActionResult Index(db_User db_User)
{
try
{
using (db_vendorEntities_ db = new db_vendorEntities_())
{
var userDetails = db.db_User.Where(x => x.user_loginID == db_User.user_loginID && x.user_password == db_User.user_password).FirstOrDefault();
if (userDetails == null)
{
db_User.LoginErrorMessage = " !! Wrong username or password.";
return(View("Index", db_User));
}
else
{
TextInfo cultInfo = new CultureInfo("en-US", false).TextInfo;
Session["userID"] = userDetails.user_loginID;
Session["UI"] = cultInfo.ToTitleCase(Session["userID"].ToString());
Session["userName"] = userDetails.user_password;
Session["userdesc"] = userDetails.user_desc_id;
return(RedirectToAction("HomePage", "Dashboard"));
}
}
}
catch (Exception ex)
{
string exa = ex.ToString();
return(RedirectToAction("Index"));
}
}
public static string MyReceiveFight(FightParameterModel fight)
{
string result = "";
MessageModel message = new MessageModel();
List <FightStateModel> fightStateList = new List <FightStateModel>();
HashSet <object> returnResult = new HashSet <object>();
JavaScriptSerializer jss = new JavaScriptSerializer();
List <FightStateDetailModel> fightReceiveList;
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
string teamID = "()";
db_User userInfo = context.db_User.Where(c => c.PhoneNumber == fight.PhoneNumber).FirstOrDefault();
if (userInfo != null)
{
teamID = Team.MyAllTeamID(userInfo.UserID);
}
var sql = "SELECT" +
" t1.DateID,t1.STeamID,t1.ETeamID,t1.Money,t1.FightAddress as SFightAddress,t1.FightAddress1 as EFightAddress,t1.CurrentState," +
" CONVERT(varchar(100), t1.FightTime, 20) as FightTime," +
" t5.PhoneNumber," +
" CONVERT(varchar(100), t2.StateTime, 20) as StateTimeStr," +
" t3.TeamName as STeamName,t4.TeamName as ETeamName," +
" t1.SFightPic as SFightPic,t1.EFightPic as EFightPic" +
" FROM" +
" db_DateFight t1 join db_FightState t2" +
" ON t1.DateID = t2.DateID and t1.CurrentState = t2.State" +
" LEFT JOIN db_Team t3" +
" ON t1.STeamID = t3.TeamID" +
" LEFT JOIN db_Team t4" +
" ON t1.ETeamID = t4.TeamID" +
" LEFT JOIN db_User t5" +
" ON t3.CreateUserID = t5.UserID" +
" WHERE t3.State=0 AND t4.State=0 AND t1.ETeamID IN" + teamID +
" ORDER BY t2.StateTime DESC";
fightReceiveList = context.Database.SqlQuery <FightStateDetailModel>(sql)
.Skip((fight.StartPage - 1) * fight.PageCount)
.Take(fight.PageCount).ToList();
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
returnResult.Add(message);
returnResult.Add(fightReceiveList);
result = jss.Serialize(returnResult);
return(result);
}
public string Register(SimpleUserModel user)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
// 判断手机号是否存在
db_User dbUser = context.db_User.Where(c => c.PhoneNumber == user.PhoneNumber.Trim()).FirstOrDefault();
if (dbUser == null)
{
db_AssetRecord assetRecord = new db_AssetRecord();
db_User userRecord = new db_User();
//判断验证码是否正确
//判断验证码是否过期
//添加信息到User表
userRecord.PhoneNumber = user.PhoneNumber;
MD5 md5Hash = MD5.Create();
userRecord.UserPassWord = Common.GetMd5Hash(md5Hash, user.PassWord);
userRecord.RegisterDate = DateTime.Now;
userRecord.UserWebPicture = @"http://images.haigame7.com/avatar/20160127125552WxExqw0paJXAo1AtXc4RzGYo2LE=.png";
context.db_User.Add(userRecord);
context.SaveChanges();
//添加信息到资产表
db_User regUser = context.db_User.Where(c => c.PhoneNumber == user.PhoneNumber.Trim()).FirstOrDefault();
Asset.AddMoneyRegister(regUser.UserID);
//添加成功
message.MessageCode = MESSAGE.OK_CODE;
message.Message = MESSAGE.OK;
}
else
{
//手机号已存在
message.MessageCode = MESSAGE.USEREXIST_CODE;
message.Message = MESSAGE.USEREXIST;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string MyGameInfo(SimpleUserModel user)
{
string result = "";
MessageModel message = new MessageModel();
GameModel gameInfo = new GameModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//获取用户
db_User userInfo = User.GetUserByPhoneNumber(user.PhoneNumber);
if (userInfo != null)
{
// 获取用户游戏数据
var sql = "select t1.UserID,t1.GameID,t1.CertifyState,t2.GamePower,t1.CertifyName" +
" from db_GameIDofUser t1" +
" left join db_GameInfoofPlatform t2" +
" on t1.UGID = t2.UGID" +
" where t1.UserID = " + userInfo.UserID + " and t1.GameType = 'DOTA2'";
gameInfo = context.Database.SqlQuery <GameModel>(sql)
.FirstOrDefault();
if (gameInfo == null)
{
//无游戏数据
message.Message = MESSAGE.NOGAMEDATA;
message.MessageCode = MESSAGE.NOGAMEDATA_CODE;
}
else
{
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
}
else
{
message.Message = MESSAGE.NOUSER;
message.MessageCode = MESSAGE.NOUSER_CODE;
}
returnResult.Add(message);
returnResult.Add(gameInfo);
}
result = jss.Serialize(returnResult);
return(result);
}
public static bl_GuestList_Result Add(bl_GuestList info)
{
using (var metadata = DataAccess.getDesktopMetadata())
{
var qDuplicate = (from row in metadata.db_User
where row.Email.ToLower().Trim() == info.Email.ToLower().Trim()
select row).FirstOrDefault();
if (qDuplicate == null)
{
var newGuest = new db_User
{
FirstName = info.FirstName,
LastName = info.LastName,
Email = info.Email,
Cell = info.Cell,
PasswordHash = info.PasswordHash,
allowPlusOne = info.allowPlusOne,
isPlusOne = info.isPlusOne,
groupCoupleID = info.groupCoupleID,
isGuest = info.isGuest,
isAdmin = info.isAdmin,
hasRSVPd = info.hasRSVPd,
isAttending = info.isAttending,
};
metadata.db_User.Add(newGuest);
metadata.SaveChanges();
var result = new bl_GuestList_Result
{
hasError = false,
};
return(result);
}
else
{
var result = new bl_GuestList_Result
{
hasError = true,
ErrorText = "Email already exist for another Guest"
};
return(result);
}
}
}
public string VerifyCode1(SimpleUserModel user)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
// 判断手机号是否存在
db_User dbUser = context.db_User.Where(c => c.PhoneNumber == user.PhoneNumber.Trim()).FirstOrDefault();
if (dbUser == null)
{
//验证码
string verifyCode = Common.MathRandom(4);
//发送验证码
Dictionary <string, object> ret = Common.SendSMS(user.PhoneNumber, verifyCode);
//返回发送结果
if (ret["statusCode"].ToString() == "000000")
{
//手机号，验证码存储到session
//获取验证码成功
message.MessageCode = MESSAGE.OK_CODE;
message.Message = verifyCode;
}
else
{
//获取验证码失败
message.MessageCode = MESSAGE.SMSERR_CODE;
message.Message = MESSAGE.SMSERR;
}
}
else
{
//手机号已注册
message.MessageCode = MESSAGE.USEREXIST_CODE;
message.Message = MESSAGE.USEREXIST;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string MyTeam(SimpleTeamModel team)
{
string result = "";
MessageModel message = new MessageModel();
TeamModel teamInfo = new TeamModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//三种情况：1.不属于任何战队，也没有自己的战队。2.是某战队的队员。 3.是某战队的队长
db_User user = context.db_User.Where(c => c.UserID == team.CreatUserID).FirstOrDefault();
if (user != null)
{
//判断用户是否加入战队或创建战队
bool isCreateOrJoinTeam = Team.IsCreateOrJoinTeam(user.UserID, context);
if (isCreateOrJoinTeam == false)
{
//不属于任何战队
message.Message = MESSAGE.NOTEAM;
message.MessageCode = MESSAGE.NOTEAM_CODE;
}
else
{
//获取用户的战队信息，通过Role字段区别是队员还是队长
teamInfo = Team.MyTeam(user.UserID, context);
}
}
else
{
//无此用户
message.Message = MESSAGE.NOUSER;
message.MessageCode = MESSAGE.NOUSER_CODE;
}
returnResult.Add(message);
returnResult.Add(teamInfo);
}
result = jss.Serialize(returnResult);
return(result);
}
public string MyJoinMatch(MatchParameter2Model match)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
MyBoBoModel myBobo = new MyBoBoModel();
message.MessageCode = MESSAGE.NOJOINMATCH_CODE;
message.Message = MESSAGE.NOJOINMATCH;
//报名参赛
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
db_User user = User.GetUserByPhoneNumber(match.PhoneNumber);
if (user != null)
{
var matchRecord = context.db_GameRecord
.Where(c => c.GameID == match.MatchID)
.Where(c => c.TeamID == match.TeamID)
.FirstOrDefault();
if (matchRecord != null)
{
var bobo = context.db_BoBo
.Where(c => c.BoBoID == matchRecord.BoBoID)
.FirstOrDefault();
if (bobo != null)
{
myBobo.Name = bobo.Name;
myBobo.ApplyTime = ((DateTime)matchRecord.ApplyTIme).ToString("yyyy-MM-dd hh:mm:ss");
message.MessageCode = MESSAGE.OK_CODE;
message.Message = MESSAGE.OK;
}
}
}
}
returnResult.Add(message);
returnResult.Add(myBobo);
result = jss.Serialize(returnResult);
return(result);
}
public string QuitMatch(MatchParameter2Model match)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
//取消报名参赛
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
db_User user = User.GetUserByPhoneNumber(match.PhoneNumber);
//判断是否队长，队员不可报名
var team = context.db_Team.Where(c => c.TeamID == match.TeamID).
Where(c => c.CreateUserID == user.UserID).
FirstOrDefault();
if (team == null)
{
message.MessageCode = MESSAGE.CANNOTQUITMATCH_CODE;
message.Message = MESSAGE.CANNOTQUITMATCH;
}
else
{
db_GameRecord gameRecord = context.db_GameRecord.
Where(c => c.GameID == match.MatchID).
Where(c => c.TeamID == match.TeamID).FirstOrDefault();
//删除队伍已报名信息
if (gameRecord != null)
{
context.db_GameRecord.Remove(gameRecord);
context.SaveChanges();
}
message.MessageCode = MESSAGE.OK_CODE;
message.Message = MESSAGE.OK;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public ActionResult register([Bind(Include = "firstname,lastname,user_loginID,user_password,company,email_address,company_website,office_address,city,country,personal_phone,business_phone,postal_code,Employment_title,fax_number,STN_reg_no")] Registration_View_Model user)
{
db_vendorEntities_ db = new db_vendorEntities_();
user_desc fesc = new user_desc();
fesc.firstname = user.firstname;
fesc.lastname = user.lastname;
fesc.fullname = user.firstname + " " + user.lastname;
fesc.company = user.company;
fesc.country = user.country;
fesc.city = user.city;
fesc.STN_reg_no = user.STN_reg_no;
fesc.office_address = user.office_address;
fesc.postal_code = user.postal_code;
fesc.Employment_title = user.Employment_title;
fesc.contact_type = "business";
fesc.business_phone = user.business_phone;
fesc.personal_phone = user.personal_phone;
fesc.email_address = user.email_address;
fesc.fax_number = user.fax_number;
fesc.company_website = user.company_website;
db.user_desc.Add(fesc);
db.SaveChanges();
int dbuser_desc_ID = fesc.user_descId;
db_User usewr = new db_User();
usewr.user_desc_id = dbuser_desc_ID;
usewr.user_loginID = user.user_loginID;
usewr.user_password = user.user_password;
usewr.is_admin = false;
usewr.is_customer = false;
usewr.is_supplier = true;
db.db_User.Add(usewr);
db.SaveChanges();
ViewBag.Message = "Congrats ! You have been added in Vendor Assistance. Enter your Supplier UserID and password to access Vendor Assistance Supplier Portal";
return(RedirectToAction("Index", "Home"));
}
public string UpdateCertifyGameID(SimpleUserModel user)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//获取用户
db_User userInfo = User.GetUserByPhoneNumber(user.PhoneNumber);
if (userInfo != null)
{
db_GameIDofUser gameIDofUser = context.db_GameIDofUser.
Where(c => c.UserID == userInfo.UserID).
Where(c => c.GameType == "DOTA2").
FirstOrDefault();
gameIDofUser.GameID = user.GameID;
gameIDofUser.CertifyState = 2;//正在认证
gameIDofUser.CertifyName = "氦七" + Common.MathRandom(6);
gameIDofUser.ApplyCertifyTime = DateTime.Now;
context.SaveChanges();
//返回认证昵称
message.Message = gameIDofUser.CertifyName;
message.MessageCode = MESSAGE.OK_CODE;
}
else
{
//无用户信息
message.Message = MESSAGE.NOUSER;
message.MessageCode = MESSAGE.NOUSER_CODE;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string MyTotalAsset(SimpleUserModel user)
{
string result = "";
MessageModel message = new MessageModel();
MyAssetModel myAsset = new MyAssetModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
//获取我的资产
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//获取用户
db_User userInfo = User.GetUserByPhoneNumber(user.PhoneNumber);
if (userInfo != null && user.PhoneNumber != null)
{
//获取用户总资产
var asset = context.db_AssetRecord.Where(c => c.UserID == userInfo.UserID).Sum(c => c.VirtualMoney);
myAsset.TotalAsset = (int)asset;
//获取用户资产排名
myAsset.MyRank = Asset.MyRank(myAsset.TotalAsset, (DateTime)userInfo.RegisterDate);
message.Message = MESSAGE.OK;
message.MessageCode = MESSAGE.OK_CODE;
}
else
{
message.Message = MESSAGE.NOUSER;
message.MessageCode = MESSAGE.NOUSER_CODE;
}
returnResult.Add(message);
returnResult.Add(myAsset);
}
result = jss.Serialize(returnResult);
return(result);
}
public string JoinMatch(MatchParameter2Model match)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
//报名参赛
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
db_User user = User.GetUserByPhoneNumber(match.PhoneNumber);
if (user != null)
{
//判断是否队长，队员不可报名
var team = context.db_Team.Where(c => c.TeamID == match.TeamID).
Where(c => c.CreateUserID == user.UserID).
FirstOrDefault();
if (team == null)
{
message.MessageCode = MESSAGE.CANNOTJOINMATCH_CODE;
message.Message = MESSAGE.CANNOTJOINMATCH;
}
else
{
//判断队伍是否满5人
var teamCount = context.db_TeamUser.Where(c => c.TeamID == match.TeamID).ToList().Count;
if (teamCount < 4)
{
message.MessageCode = MESSAGE.TEAMUSERNOTENOUGH_CODE;
message.Message = MESSAGE.TEAMUSERNOTENOUGH;
}
else
{
//判断报名队伍数是否已满
if (Team.IsBoBoFull(match) == true)
{
//判断队伍是否已报名
db_GameRecord gameRecord = new db_GameRecord();
gameRecord.BoBoID = match.BoBoID;
gameRecord.GameID = match.MatchID;
gameRecord.TeamID = match.TeamID;
gameRecord.ApplyTIme = DateTime.Now;
gameRecord.UserID = user.UserID;
gameRecord.IsCancel = 0;
gameRecord.State = 0;
context.db_GameRecord.Add(gameRecord);
context.SaveChanges();
message.MessageCode = MESSAGE.OK_CODE;
message.Message = MESSAGE.OK;
}
else
{
//名额已满
message.MessageCode = MESSAGE.MATCHFULL_CODE;
message.Message = MESSAGE.MATCHFULL;
}
}
}
}
else
{
//用户未存在
message.MessageCode = MESSAGE.NOUSER_CODE;
message.Message = MESSAGE.NOUSER;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}
public string UpdateUserInfo(UserModel user)
{
string result = "";
MessageModel message = new MessageModel();
JavaScriptSerializer jss = new JavaScriptSerializer();
HashSet <object> returnResult = new HashSet <object>();
using (HiGame_V1Entities context = new HiGame_V1Entities())
{
//获取用户
db_User userInfo = context.db_User.Where(c => c.PhoneNumber == user.PhoneNumber).FirstOrDefault();
if (userInfo != null)
{
int code = MESSAGE.OK_CODE;
string msg = MESSAGE.OK;
#region 个人信息字段
if (user.Address != null)
{
userInfo.Address = user.Address;
}
if (user.Birthday != null)
{
userInfo.Birthday = DateTime.Parse(user.Birthday);
}
if (user.Hobby != null)
{
userInfo.Hobby = user.Hobby;
}
if (user.Sex != null)
{
userInfo.Sex = user.Sex;
}
if (user.UserWebNickName != null)
{
//验证昵称是否存在
if (User.GetUserByNickName(user.UserWebNickName.Trim()))
{
userInfo.UserWebNickName = user.UserWebNickName;
}
else
{
//昵称已存在
msg = MESSAGE.NICKEXIST;
code = MESSAGE.NICKEXIST_CODE;
}
}
if (user.UserWebPicture != null)
{
userInfo.UserWebPicture = Common.Base64ToImage(user.UserWebPicture, userInfo.UserID.ToString());
}
#endregion
context.SaveChanges();
message.Message = msg;
message.MessageCode = code;
}
else
{
message.Message = MESSAGE.NOUSER;
message.MessageCode = MESSAGE.NOUSER_CODE;
}
}
returnResult.Add(message);
result = jss.Serialize(returnResult);
return(result);
}