public IDataResult <AccessToken> CreateAccessToken(_User user)
{
var claims = _userService.GetClaims(user);
var accessToken = _tokenHelper.CreateToken(user, claims);
return(new SuccesDataResult <AccessToken>(accessToken, "Token oluşturuldu"));
}
public ActionResult Upgrade(int AccountTypeId = 2)
{
//return to login/register if not signed in
if (Session["User"] == null)
{
return(RedirectToAction("Index", "Register"));
}
//get user infor
var User = new _User(UserRepository.RefreshAuthToken(((_User)Session["User"]).AuthToken));
Session["User"] = User;
ViewBag.User = User;
ViewBag.AccountType = AccountPaymentsRepository.GetAccountType(AccountTypeId);
//get account types
List <_AccountType> AccountTypes = new List <_AccountType>();
foreach (var AccountType in AccountPaymentsRepository.GetAccountTypes())
{
AccountTypes.Add(new _AccountType(AccountType));
}
ViewBag.AccountTypes = AccountTypes;
return(View());
}
public HttpResponseMessage UpdateChoreUser(string AuthToken, int Id, string ChoreUserValues)
{
try
{
_User User = new _User(UserRepository.RefreshAuthToken(AuthToken));
ChoreUser ChoreUserObject = JsonConvert.DeserializeObject <ChoreUser>(ChoreUserValues);
//get chorelist from chore user
var ChoreList = ChoreRepository.GetChoreList(ChoreUserObject.ChoreListId);
//check if userid matches chore list object user
if (User.Id != ChoreList.UserId)
{
throw new Exception("Unathorized");
}
//keep chore user as active
ChoreUserObject.IsActive = true;
return(OKResponse(new _ChoreUser(ChoreRepository.UpdateChoreUser(Id, ChoreUserObject))));
}
catch (Exception ex)
{
return(ErrorResponse(ex));
}
}
public void EnterUserDetails(_User user)
{
Console.WriteLine("Enter the First Name");
user.FirstName = Console.ReadLine();
Console.WriteLine("Enter the Middle Name(Optional)");
user.MiddleName = Console.ReadLine();
Console.WriteLine("Enter the Last Name");
user.LastName = Console.ReadLine();
Console.WriteLine("Enter the Email Address:");
user.EmailAddress = Console.ReadLine();
Console.WriteLine("Enter your Password");
user.Password = Console.ReadLine();
Console.WriteLine("Enter Department ID, 1-GMIC, 2-GQUA, 3-GMOB");
user.FkDepartmentId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Enter Gender ID 1-Male, 2-Female");
user.FkGenderId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Enter User Type Id, 1-Normal, 2-Admin");
user.FkUserTypeId = Convert.ToInt32(Console.ReadLine());
//Hashing the password with some salt
//Calling or Invoking the HashingPassword method and Passing the entered Password + default Salt
string salt = "Thisismydefaultsalt";
string hashedPassword = HashingPassword(user.Password + salt);
//calling Insert_User method.
Insert_User(user);
}
public ActionResult EditChoreList(int Id = 0)
{
if (Session["User"] == null)
{
return(RedirectToAction("Index", "Register"));
}
var User = (_User)Session["User"];
User = new _User(UserRepository.RefreshAuthToken(User.AuthToken));
Session["User"] = User;
ViewBag.User = User;
if (!ChoreRepository.CanEditChoreList(User.Id, Id))
{
throw new Exception("Unauthorized to edit chorelist");
}
_ChoreList ChoreList = new _ChoreList(ChoreRepository.GetChoreList(Id));
if (ChoreList.StatusId == 2)
{
List <string> Reasons = ChoreRepository.GetInActiveReasons(Id);
ViewBag.InActiveReasons = Reasons;
}
ViewBag.User = User;
ViewBag.ChoreList = ChoreList;
return(View());
}
public List <FlyPm> GetPmList()
{
List <FlyPm> lp = new List <FlyPm>();
string sql = "SELECT srcUid,count(id) as t from t_user where srcUid > 2000 and date(addOn)<'2016-12-28' and date(addOn)>'2016-12-20' group by srcUid order by t desc LIMIT 0,50";
using (DataTable dt = helper.GetDataTable(sql))
{
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
FlyPm b = new FlyPm
{
uid = Convert.ToInt32(r["srcUid"]),
count = Convert.ToInt32(r["t"])
};
user u = new _User().GetUser("", "", b.uid);
if (u != null)
{
b.nickName = u.nickName;
b.openId = u.openId;
b.photoUrl = u.photoUrl;
}
lp.Add(b);
}
}
}
return(lp);
}
public static void UpdateUserDetails(_User user)
{
using (var updateUserContext = new UsersDbContext())
{
try
{
var objupdateUser = updateUserContext.User.Find(user.PkUserId);
objupdateUser.FirstName = user.FirstName;
objupdateUser.MiddleName = user.MiddleName;
objupdateUser.LastName = user.LastName;
objupdateUser.EmailAddress = user.EmailAddress;
objupdateUser.Password = user.Password;
objupdateUser.FkGenderId = user.FkGenderId;
objupdateUser.FkDepartmentId = user.FkDepartmentId;
objupdateUser.FkUserTypeId = user.FkUserTypeId;
updateUserContext.SaveChanges();
Console.WriteLine("User details updated");
Console.ReadKey();
}
catch (Exception)
{
Console.WriteLine("Could not updated user Details");
Console.ReadKey();
}
}
}
///<summary>
///向数据库中添加一条记录
///</summary>
///<param name="model">要添加的实体</param>
public bool Insert(_User model)
{
const string sql = @"INSERT INTO [dbo].[_User] (objectId,updatedAt,createdAt,username,password,transaction_password,sessionToken,nickname,credit,overage,avatar,sign_in,shake_times,authDataId) VALUES (@objectId,@updatedAt,@createdAt,@username,@password,@transaction_password,@sessionToken,@nickname,@credit,@overage,@avatar,@sign_in,@shake_times,@authDataId)";
int res = SqlHelper.ExecuteNonQuery(sql, new SqlParameter("@objectId", model.objectId.ToDBValue()), new SqlParameter("@updatedAt", model.updatedAt.ToDBValue()), new SqlParameter("@createdAt", model.createdAt.ToDBValue()), new SqlParameter("@username", model.username.ToDBValue()), new SqlParameter("@password", model.password.ToDBValue()), new SqlParameter("@transaction_password", model.transaction_password.ToDBValue()), new SqlParameter("@sessionToken", model.sessionToken.ToDBValue()), new SqlParameter("@nickname", model.nickname.ToDBValue()), new SqlParameter("@credit", model.credit.ToDBValue()), new SqlParameter("@overage", model.overage.ToDBValue()), new SqlParameter("@avatar", model.avatar.ToDBValue()), new SqlParameter("@sign_in", model.sign_in.ToDBValue()), new SqlParameter("@shake_times", model.shake_times.ToDBValue()), new SqlParameter("@authDataId", model.authData.objectId.ToDBValue()));
return(res > 0);
}
///<summary>
///分页查询一个集合
///</summary>
///<param name="index">页码</param>
///<param name="size">页大小</param>
///<param name="wheres">条件匿名类</param>
///<param name="orderField">排序字段</param>
///<param name="isDesc">是否降序排序</param>
///<returns>实体集合</returns>
public IEnumerable <_User> QueryList(int index, int size, object wheres = null, string orderField = "objectId", bool isDesc = true)
{
List <SqlParameter> list = null;
string where = wheres.parseWheres(out list);
orderField = string.IsNullOrEmpty(orderField) ? "objectId" : orderField;
var sql = SqlHelper.GenerateQuerySql("_User", new string[] { "objectId", "updatedAt", "createdAt", "username", "password", "transaction_password", "sessionToken", "nickname", "credit", "overage", "avatar", "sign_in", "shake_times", "authDataId" }, index, size, where, orderField, isDesc);
using (var reader = SqlHelper.ExecuteReader(sql, list.ToArray()))
{
if (reader.HasRows)
{
while (reader.Read())
{
_User model = SqlHelper.MapEntity <_User>(reader);
if (reader["authDataId"] != DBNull.Value)
{
authDataDAO authDataDAO = new authDataDAO();
model.authData = authDataDAO.QuerySingleById((string)reader["authDataId"]);
}
yield return(model);
}
}
}
}
public ActionResult LogIn()
{
string username = Request.Form["username"]; //获取用户名
string password = Request.Form["password"]; //获取密码
try
{
//表单验证
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password))
{
return(Content("<script> alert('用户名密码不得为空'); location.href = '" + Url.Action("Index", "Account") + "'</script>"));
}
else
{
if (username != "admin")
{
return(Content("<script> alert('该用户没有权限登录'); location.href = '" + Url.Action("Index", "Account") + "'</script>"));
}
List <Wheres> whs = new List <Wheres>()
{
new Wheres("username", "=", username)
};
var dir = bll.QuerySingleByWheres(whs);
if (dir != null)
{
string obj = (string)(dir.objectId);
string pas = (string)(dir.password);
//string li = "raw:" + password + " sql:" + pas + " jiami:" + (password + obj).Md5();
//string ss = (password + obj).Md5();
if ((password.Md5() + obj).Md5().Equals(pas))
{
string sessionToken = Guid.NewGuid().ToString();
bll.UpdateById(obj, new Dictionary <string, object> {
{ "sessionToken", sessionToken }
});
_User model = bll.QuerySingleById(obj);
Session["CurrentUser"] = username;
return(RedirectToAction("GetItems", "Items"));
//return ok(model);
}
else
{
return(Content("<script> alert('密码错误'); location.href = '" + Url.Action("Index", "Account") + "'</script>"));
// return notFound("密码错误" + li);
}
}
else
{
return(Content("<script> alert('用户不存在'); location.href = '" + Url.Action("Index", "Account") + "'</script>"));
//return notFound("用户不存在");
}
}
}
catch (Exception e)
{
return(Content("<script> alert('" + e.Message + "'); location.href = '" + Url.Action("Index", "Account") + "'</script>"));
//return execept(e.Message);
}
}
public HttpResponseMessage UpdateChore(string AuthToken, int Id, string ChoreValues)
{
try
{
_User User = new _User(UserRepository.RefreshAuthToken(AuthToken));
//get chore from Id
Chore ChoreObject = JsonConvert.DeserializeObject <Chore>(ChoreValues);
//get ChoreList from Choreobject
var ChoreList = new _ChoreList(ChoreRepository.GetChoreList((int)ChoreObject.ChoreListId));
if (User.Id != ChoreList.UserId)
{
throw new Exception("Unauthorized");
}
ChoreObject.IsActive = true;
return(OKResponse(new _Chore(ChoreRepository.UpdateChore(Id, ChoreObject))));
}
catch (Exception ex)
{
return(ErrorResponse(ex));
}
}
/// <summary>
/// 微信绑定
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateInsert(_User model, CreditsHistory history)
{
const string sql = @"INSERT INTO [dbo].[wechat] (objectId,openId,inopenId) VALUES (@objectId,@openId,@inopenId)";
SqlParameter[] parms = { new SqlParameter("@objectId", model.authData.wechat.objectId.ToDBValue()), new SqlParameter("@openId", model.authData.wechat.openId.ToDBValue()), new SqlParameter("@inopenId", model.authData.wechat.inopenId.ToDBValue()) };
const string sql1 = @"INSERT INTO [dbo].[authData] (objectId,wechatId) VALUES (@objectId,@wechatId)";
//SqlParameter[] parms1 = { new SqlParameter("@objectId", model.authData.objectId.ToDBValue()), new SqlParameter("@weiboId", model.authData.weibo.objectId.ToDBValue()), new SqlParameter("@qqId", model.authData.qq.objectId.ToDBValue()), new SqlParameter("@alibabaId", model.authData.alibaba.objectId.ToDBValue()), new SqlParameter("@wechatId", model.authData.wechat.objectId.ToDBValue()) };
SqlParameter[] parms1 = { new SqlParameter("@objectId", model.authData.objectId.ToDBValue()), new SqlParameter("@wechatId", model.authData.wechat.objectId.ToDBValue()) };
const string sql2 = @"UPDATE _User set authDataId=@authDataId where username=@username";
SqlParameter[] parms2 = { new SqlParameter("authDataId", model.authData.objectId), new SqlParameter("@username", model.username) };
const string sql3 = @"UPDATE _User set credit+=@credit where username=@inopenId";
SqlParameter[] parms3 = { new SqlParameter("@credit", history.change), new SqlParameter("@inopenId", model.authData.wechat.inopenId) };
const string sql4 = @"INSERT INTO CreditsHistory (objectId,createdAt,updatedAt,userId,type,change,credit) values (@objectId,@createdAt,@updatedAt,@userId,@type,@change,@credit)";
SqlParameter[] parms4 = { new SqlParameter("@objectId", history.objectId), new SqlParameter("@createdAt", history.createdAt), new SqlParameter("@updatedAt", history.updatedAt), new SqlParameter("@userId", history.userId), new SqlParameter("@type", history.type), new SqlParameter("@change", history.change), new SqlParameter("@credit", history.credit) };
int res = SqlHelper.ExecuteNonQuerysTransaction(sql, parms, sql1, parms1, sql2, parms2, sql3, parms3, sql4, parms4);
return(res > 4);
}
public HttpResponseMessage GetChoreUser(string AuthToken, int Id)
{
try
{
//get user from auth token
_User User = new _User(UserRepository.RefreshAuthToken(AuthToken));
//get chore user object from id
var ChoreUserObject = new _ChoreUser(ChoreRepository.GetChoreUser(Id));
//get chorelist from chore user object
var ChoreList = ChoreRepository.GetChoreList(ChoreUserObject.ChoreListId);
//check if userid matches chore list object user
if (User.Id != ChoreList.UserId)
{
throw new Exception("Unathorized");
}
return(OKResponse(ChoreUserObject));
}
catch (Exception ex)
{
return(ErrorResponse(ex));
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
char sex = 'n';
if (rdbtnMale.Checked)
{
sex = Convert.ToChar(rdbtnMale.Value);
}
else if (rdbtnFemale.Checked)
{
sex = Convert.ToChar(rdbtnFemale.Value);
}
if (isDoesNotExist())
{
if (sex != 'n')
{
u = new _User(txtLName.Text, txtFName.Text, txtMName.Text, txtContact.Text, txtEmail.Text, txtUsername.Text, txtPassword.Text, "Customer", sex);
SQLManager.SQLAdd(u);
Clear();
}
}
else
{
cvUserExist.IsValid = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ID"] == null)
{
Response.Redirect("/SessionExpired.aspx");
}
int id = Convert.ToInt32(Session["ID"]);
string sexprefix = "";
//ADMIN
if (id == -1)
{
navUser.InnerText = "Hello, ADMIN";
}
//USER
else
{
u = SQLManager.SQLRetrieveUserData(id);
if (u.Sex == 'M')
{
sexprefix = "Mr.";
}
else if (u.Sex == 'F')
{
sexprefix = "Ms/Mrs.";
}
navUser.InnerText = "Hello, " + sexprefix + u.Lname;
}
Logout.ServerClick += new EventHandler(Logout_Click);
}
/// <summary>
/// 有邀请人
/// </summary>
/// <param name="model"></param>
/// <param name="history">注册用户记录</param>
/// <param name="history1">邀请者记录</param>
/// <returns></returns>
public bool Insert(_User model, CreditsHistory history, CreditsHistory history1)
{
const string sql = @"INSERT INTO [dbo].[wechat] (objectId,openId,inopenId) VALUES (@objectId,@openId,@inopenId)";
SqlParameter[] parms = { new SqlParameter("@objectId", model.authData.wechat.objectId.ToDBValue()), new SqlParameter("@openId", model.authData.wechat.openId.ToDBValue()), new SqlParameter("@inopenId", model.authData.wechat.inopenId.ToDBValue()) };
const string sql1 = @"INSERT INTO [dbo].[authData] (objectId,wechatId) VALUES (@objectId,@wechatId)";
//SqlParameter[] parms1 = { new SqlParameter("@objectId", model.authData.objectId.ToDBValue()), new SqlParameter("@weiboId", model.authData.weibo.objectId.ToDBValue()), new SqlParameter("@qqId", model.authData.qq.objectId.ToDBValue()), new SqlParameter("@alibabaId", model.authData.alibaba.objectId.ToDBValue()), new SqlParameter("@wechatId", model.authData.wechat.objectId.ToDBValue()) };
SqlParameter[] parms1 = { new SqlParameter("@objectId", model.authData.objectId.ToDBValue()), new SqlParameter("@wechatId", model.authData.wechat.objectId.ToDBValue()) };
const string sql2 = @"INSERT INTO [dbo].[_User] (objectId,updatedAt,createdAt,username,password,transaction_password,sessionToken,nickname,credit,overage,avatar,sign_in,shake_times,authDataId) VALUES (@objectId,@updatedAt,@createdAt,@username,@password,@transaction_password,@sessionToken,@nickname,@credit,@overage,@avatar,@sign_in,@shake_times,@authDataId)";
SqlParameter[] parms2 = { new SqlParameter("@objectId", model.objectId.ToDBValue()), new SqlParameter("@updatedAt", model.updatedAt.ToDBValue()), new SqlParameter("@createdAt", model.createdAt.ToDBValue()), new SqlParameter("@username", model.username.ToDBValue()), new SqlParameter("@password", model.password.ToDBValue()), new SqlParameter("@transaction_password", model.transaction_password.ToDBValue()), new SqlParameter("@sessionToken", model.sessionToken.ToDBValue()), new SqlParameter("@nickname", model.nickname.ToDBValue()), new SqlParameter("@credit", model.credit.ToDBValue()), new SqlParameter("@overage", model.overage.ToDBValue()), new SqlParameter("@avatar", model.avatar.ToDBValue()), new SqlParameter("@sign_in", model.sign_in.ToDBValue()), new SqlParameter("@shake_times", model.shake_times.ToDBValue()), new SqlParameter("@authDataId", model.authData.objectId.ToDBValue()) };
const string sql3 = @"UPDATE _User set credit+=@credit where username=@inopenId";
SqlParameter[] parms3 = { new SqlParameter("@credit", history1.change), new SqlParameter("@inopenId", model.authData.wechat.inopenId) };
const string sql4 = @"INSERT INTO CreditsHistory (objectId,createdAt,updatedAt,userId,type,change,credit) values (@objectId,@createdAt,@updatedAt,@userId,@type,@change,@credit)";
SqlParameter[] parms4 = { new SqlParameter("@objectId", history.objectId), new SqlParameter("@createdAt", history.createdAt), new SqlParameter("@updatedAt", history.updatedAt), new SqlParameter("@userId", model.objectId), new SqlParameter("@type", history.type), new SqlParameter("@change", history.change), new SqlParameter("@credit", history.credit) };
const string sql5 = @"INSERT INTO CreditsHistory (objectId,createdAt,updatedAt,userId,type,change,credit) values (@objectId,@createdAt,@updatedAt,@userId,@type,@change,@credit)";
SqlParameter[] parms5 = { new SqlParameter("@objectId", history1.objectId), new SqlParameter("@createdAt", history1.createdAt), new SqlParameter("@updatedAt", history1.updatedAt), new SqlParameter("@userId", history1.userId), new SqlParameter("@type", history1.type), new SqlParameter("@change", history1.change), new SqlParameter("@credit", history1.credit) };
int res = SqlHelper.ExecuteNonQuerysTransaction(sql, parms, sql1, parms1, sql2, parms2, sql3, parms3, sql4, parms4, sql5, parms5);
return(res > 5);
}
private static string GetUserSQL()
{
IList users = UserData.GetAllUsers();
StringBuilder sbResult = new StringBuilder();
foreach (object o in users)
{
_User user = (_User)o;
StringBuilder sb = new StringBuilder();
sb.Append("insert into _users (userid,name,sex,password) values ");
sb.Append("('" + user.UserID + "'");
sb.Append(",'" + user.Name + "'");
sb.Append(",'" + user.Sex + "'");
sb.Append(",'" + user.Password + "'");
sb.Append(");");
string queryText = sb.ToString();
sbResult.Append(Environment.NewLine);
sbResult.Append(queryText);
sbResult.Append(Environment.NewLine);
}
return(sbResult.ToString());
}
private void IntoLibRec_Load(object sender, System.EventArgs e)
{
IList listUser = UserData.GetAllUsers();
foreach (object o in listUser)
{
_User u = (_User)o;
comboBox1.Items.Add(u.Name);
}
comboBox1.SelectedIndex = 0;
IList PumpNames = IntoLibData.GetIntoLibPumpNames();
foreach (object o1 in PumpNames)
{
comboBox2.Items.Add(o1.ToString());
}
comboBox2.SelectedIndex = 0;
IList PumpClass = PumpTypeData.getPumpTypeName();
foreach (object o2 in PumpClass)
{
comboBox3.Items.Add(o2.ToString());
}
comboBox3.SelectedIndex = 0;
}
public override void OnAuthorization(AuthorizationContext filterContext)
{
base.OnAuthorization(filterContext);
IsUserAuthorized(filterContext);
_User User = new _User();
User.Username = "******";
HttpContext.Current.Session["User"] = new _User();
}
private IEnumerable <Claim> SetClaims(_User _user, List <OperationClaim> operationClaims)
{
var claims = new List <Claim>();
claims.AddNameIdentifier(_user.Id.ToString());
claims.AddEmail(_user.Email);
claims.AddName($"{_user.FirstName} {_user.LastName}");
claims.AddRoles(operationClaims.Select(c => c.Name).ToArray());
return(claims);
}
private CommenResult SignInOk(SignIn signIn, int change)
{
_User user = userbll.QuerySingleById(signIn.objectId);
return(ok(new {
userId = signIn.updateAt.ToShortDateString(), //为向下兼容，暂时返回时间字符串
type = signIn, //为向下兼容，暂时返回连续签到天数
change = change, //积分变化值
credit = user.credit //积分变化后的值
}));
}
// Populate controls with current values
private void PopulateForm()
{
// GENERAL Tab
_User user = SysInfo.Data.Users.Find_User(SysInfo.Data.Options.PrimaryUser);
if (user != null)
{
textBoxFirstName.Text = user.FirstName;
textBoxLastName.Text = user.LastName;
labelUserName.Text = user.Name; // Same as PrimaryUser
}
// Populate the MS Access Export Format combobox
comboMDBformat.DataSource = Enum.GetNames(typeof(MDBformat));
comboMDBformat.SelectedItem = SysInfo.Data.Options.MDBformat.ToString();
checkBoxShowSplash.Checked = SysInfo.Data.Options.ShowSplash;
// DATA TRANSFER Tab
checkBoxUnattendedSync.Checked = SysInfo.Data.Options.DataXfer.UnattendedSync;
checkBoxSyncAudio.Checked = SysInfo.Data.Options.DataXfer.Sound;
// MOBILE Tab
checkBoxAutoUpdate.Checked = SysInfo.Data.Options.Mobile.AutoUpdate;
checkBoxOverrideInstallBlock.Checked = SysInfo.Data.Options.Mobile.OverrideInstallBlock;
checkBoxGetPersonalInfo.Checked = SysInfo.Data.Options.Mobile.GetPersonalInfo;
checkBoxHideQuestionNumbers.Checked = SysInfo.Data.Options.Mobile.HideQuestionNumbers;
// Get the current Purge Duration value
string currText = Enum.GetName(typeof(PurgeDuration), SysInfo.Data.Options.Mobile.PurgeDuration).Replace("_", " ");
// Populate the PurgeDuration ComboBox
int idx = 0;
foreach (int val in Enum.GetValues(typeof(PurgeDuration)))
{
string pdText = Enum.GetName(typeof(PurgeDuration), val);
pdText = pdText.Replace("_", " ");
comboPurgeDuration.Items.Add(pdText);
if (pdText == currText)
{
comboPurgeDuration.SelectedIndex = idx;
}
idx++;
}
// Set the current Battery Warning Level
spinnerBatteryWarningLevel.Value = SysInfo.Data.Options.Mobile.BatteryWarningLevel;
}
/// <summary>
/// 手机端，没有邀请人注册
/// </summary>
/// <param name="model"></param>
/// <param name="history"></param>
/// <returns></returns>
public bool Insert1(_User model, CreditsHistory history)
{
const string sql = @"INSERT INTO [dbo].[_User] (objectId,updatedAt,createdAt,username,password,transaction_password,sessionToken,nickname,credit,overage,avatar,sign_in,shake_times) VALUES (@objectId,@updatedAt,@createdAt,@username,@password,@transaction_password,@sessionToken,@nickname,@credit,@overage,@avatar,@sign_in,@shake_times)";
SqlParameter[] parms = { new SqlParameter("@objectId", model.objectId.ToDBValue()), new SqlParameter("@updatedAt", model.updatedAt.ToDBValue()), new SqlParameter("@createdAt", model.createdAt.ToDBValue()), new SqlParameter("@username", model.username.ToDBValue()), new SqlParameter("@password", model.password.ToDBValue()), new SqlParameter("@transaction_password", model.transaction_password.ToDBValue()), new SqlParameter("@sessionToken", model.sessionToken.ToDBValue()), new SqlParameter("@nickname", model.nickname.ToDBValue()), new SqlParameter("@credit", model.credit.ToDBValue()), new SqlParameter("@overage", model.overage.ToDBValue()), new SqlParameter("@avatar", model.avatar.ToDBValue()), new SqlParameter("@sign_in", model.sign_in.ToDBValue()), new SqlParameter("@shake_times", model.shake_times.ToDBValue()) };
const string sql1 = @"INSERT INTO CreditsHistory (objectId,createdAt,updatedAt,userId,type,change,credit) values (@objectId,@createdAt,@updatedAt,@userId,@type,@change,@credit)";
SqlParameter[] parms1 = { new SqlParameter("@objectId", history.objectId), new SqlParameter("@createdAt", history.createdAt), new SqlParameter("@updatedAt", history.updatedAt), new SqlParameter("@userId", model.objectId), new SqlParameter("@type", history.type), new SqlParameter("@change", history.change), new SqlParameter("@credit", history.credit) };
int res = SqlHelper.ExecuteNonQuerysTransaction(sql, parms, sql1, parms1);
return(res > 1);
}
public ActionResult RefreshSession(string AuthToken)
{
try
{
Session["User"] = new _User(UserRepository.RefreshAuthToken(AuthToken));
return(Json(new { LoggedIn = true }));
}
catch (Exception ex)
{
return(Json(new { LoggedIn = false, Message = ex.Message }));
}
}
private void OubLibFrm_Load(object sender, System.EventArgs e)
{
IList listUser = UserData.GetAllUsers();
foreach (object o in listUser)
{
_User u = (_User)o;
comboBox1.Items.Add(u.Name);
}
comboBox1.SelectedIndex = 0;
}
public _User GetUser(string objectId)
{
try
{
_User model = bll.QuerySingleById(objectId);
return(model);
}
catch (Exception e)
{
return(null);
}
}
public ActionResult CreateSession(string Username, string Password)
{
try
{
var User = new _User(UserRepository.Login(Username, Password));
Session["User"] = User;
return(Json(new { LoggedIn = true }));
}
catch (Exception ex)
{
return(Json(new { LoggedIn = false, Message = ex.Message }));
}
}
public ActionResult RegisterUser(string UserValues)
{
try
{
var UserObject = JsonConvert.DeserializeObject <User>(UserValues);
Session["User"] = new _User(UserRepository.CreateUser(UserObject));
return(Json(new { LoggedIn = true }));
}
catch (Exception ex)
{
return(Json(new { LoggedIn = false, Message = ex.Message }));
}
}
public ActionResult Index()
{
if (Session["User"] != null)
{
var User = (_User)Session["User"];
User = new _User(UserRepository.RefreshAuthToken(User.AuthToken));
Session["User"] = User;
ViewBag.User = User;
return(View());
}
return(RedirectToAction("index", "Register"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ID"] != null)
{
int id = Convert.ToInt32(Session["ID"]);
u = SQLManager.SQLRetrieveUserData(id);
u.UserID = id;
LocalInit();
reloadImage();
}
}
void Start()
{
_label = labelInitialText;
_t1 = new Thread(_func1);
_t2 = new Thread(_func2);
#if true
string ipAddress = "127.0.0.1"; //"localhost";
int gamePort = 14248;
int policyPort = 4000;
bool isPolicyConnected = false;
string hostname = "127.0.0.1";
IPAddress[] ips = Dns.GetHostAddresses(ipAddress);
StreamWriter theWriter;
StreamReader theReader;
foreach (IPAddress ip in ips)
{
ipAddress = ip.ToString();
if (!(isPolicyConnected = Security.PrefetchSocketPolicy(ipAddress, policyPort, 4000)))
print("policy socket address failed to connect to " + ipAddress + ":" + policyPort);
else break;
}
if (isPolicyConnected)
Application.LoadLevel("mainscene");
else ipAddress = hostname;
TcpClient mySocket;
mySocket = new TcpClient(hostname, policyPort);
ns = mySocket.GetStream();
theWriter = new StreamWriter(ns);
theReader = new StreamReader(ns);
#else
ipep = new IPEndPoint(IPAddress.Parse("127.0.0.1"), 4000);
server = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
server.Connect(ipep);
ns = new NetworkStream(server);
#endif
byte[] bByte = new byte[Marshal.SizeOf(__user)];
ns.Read(bByte, 0, Marshal.SizeOf(typeof(_User)));
GCHandle handle = GCHandle.Alloc(bByte, GCHandleType.Pinned);
__user = (_User)Marshal.PtrToStructure(handle.AddrOfPinnedObject(), typeof(_User));
handle.Free();
}
