Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [Route("Login")]
- [HttpPost]
- public async Task<UserSession> Login()
- {
- string input = await Request.Content.ReadAsStringAsync();
- dynamic data = Newtonsoft.Json.Linq.JObject.Parse(input);
- LoginUser user = new LoginUser();
- user.Email= data.email;
- user.Password = data.password;
- user.Token = data.token.ToObject<byte[]>();
- byte[] mSessionID = new Session().getToken(user.Token);
- /* using (System.Data.SqlClient.SqlConnection _conn = new System.Data.SqlClient.SqlConnection
- ("data source=devtest.dataquest.com.au;" + "initial catalog=Safe2Pay;" + "user id=sa;password=ipsec@21;"));
- using (System.Data.SqlClient.SqlCommand _cmdLoginDetails = new System.Data.SqlClient.SqlCommand(
- "INSERT into Login (" + "Email,Token,UserLogged)" + "VALUES(@user.Email,@Token,@UserLogged)", _conn))
- {
- System.Data.SqlClient.SqlParameter paramEmail = _cmdLoginDetails.Parameters.Add("@user.Email", System.Data.SqlDbType.NVarChar);
- System.Data.SqlClient.SqlParameter paramToken = _cmdLoginDetails.Parameters.Add("@Token", System.Data.SqlDbType.Binary);
- System.Data.SqlClient.SqlParameter paramUserLogged = _cmdLoginDetails.Parameters.Add(@UserLogge)
- } */
- _conn = new System.Data.SqlClient.SqlConnection("data source=devtest.dataquest.com.au;" + "initial catalog=Safe2Pay;" + "user id=sa;password=ipsec@21;");
- System.Data.SqlClient.SqlCommand _cmdLoginDetails = new System.Data.SqlClient.SqlCommand("INSERT INTO Login ("+
- "Email, Token, UserLogged)"+
- "VALUES(@Email,@Token,@UserLogged)",_conn);
- _cmdLoginDetails.Parameters.Add("@Email", System.Data.SqlDbType.NVarChar, 30).Value = user.Email;
- _cmdLoginDetails.Parameters.Add("@Token", System.Data.SqlDbType.VarBinary).Value = mSessionID;
- _cmdLoginDetails.Parameters.Add("@UserLogged", System.Data.SqlDbType.Bit).Value = 1;
- _conn.Open();
- _cmdLoginDetails.ExecuteNonQuery();
- _conn.Close();
- return new UserSession
- {
- SessionID = mSessionID
- };
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement