/// <summary> /// Inicia sesion del usuario /// </summary> /// <param name="email"></param> /// <param name="password"></param> /// <returns></returns> public UserResponde InicioSesion(string email, string password) { string selectSQL = "SELECT Pk_User, Fullname, Email,Password,CreateDate,CreateUpdate FROM Users where Email = ? and Password = ?"; UserResponde respondeUser = new UserResponde(); //SqlConnection con = new SqlConnection(connectionString); //SqlCommand cmd = new SqlCommand(selectSQL, con); OleDbConnection con = new OleDbConnection(connectionString); OleDbCommand cmd = new OleDbCommand(selectSQL, con); cmd.Parameters.Add("@Email", OleDbType.VarChar).Value = email; cmd.Parameters.Add("@Password", OleDbType.VarChar).Value = password; //cmd.Parameters.Add("@Email", System.Data.SqlDbType.VarChar).Value = email; //cmd.Parameters.Add("@Password", System.Data.SqlDbType.VarChar).Value = password; //SqlDataReader reader; OleDbDataReader reader ; try { con.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { respondeUser.IDUser = Convert.ToInt32(reader["Pk_User"].ToString()); if (respondeUser.IDUser == 0) { respondeUser.MessageError = "0"; } else { respondeUser.Fullname = reader["Fullname"].ToString(); respondeUser.Email = reader["Email"].ToString(); respondeUser.Password = reader["Password"].ToString(); respondeUser.CreateDate = Convert.ToDateTime(reader["CreateDate"].ToString()); respondeUser.CreateUpdate = Convert.ToDateTime(reader["CreateUpdate"].ToString()); respondeUser.MessageError = "1"; } } reader.Close(); cmd.Dispose(); con.Close(); } catch (FaultException err) { //respondeUser.MessageError = "Exception jope la hemos liado :(!!!! "; // string json = err.Message + " Pila de Error" + Convert.ToString(err.StackTrace); HttpContext.Current.Response.ContentType = "application/json; charset=utf-8"; HttpContext.Current.Response.Write(json); erroresponde.Fullname = ""; erroresponde.IDUser = 0; erroresponde.Fullname = ""; erroresponde.Email = ""; erroresponde.MessageError = json; respondeUser.MessageError = erroresponde.MessageError; //return erroresponde; throw new FaultException<UserResponde>(respondeUser); } return respondeUser; }
private int VerificarEmail(string email) { string selectSQL = "SELECT Pk_User FROM Users where Email = ?"; int result = 0; UserResponde respondeUser = new UserResponde(); //SqlConnection con = new SqlConnection(connectionString); //SqlCommand cmd = new SqlCommand(selectSQL, con); OleDbConnection con = new OleDbConnection(connectionString); OleDbCommand cmd = new OleDbCommand(selectSQL, con); cmd.Parameters.Add("@Email", OleDbType.VarChar).Value = email; //cmd.Parameters.Add("@Email", System.Data.SqlDbType.VarChar).Value = email; //cmd.Parameters.Add("@Password", System.Data.SqlDbType.VarChar).Value = password; //SqlDataReader reader; OleDbDataReader reader; try { con.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { respondeUser.IDUser = Convert.ToInt32(reader["Pk_User"].ToString()); //respondeUser.Fullname = reader["Fullname"].ToString(); //respondeUser.Password = reader["Password"].ToString(); //respondeUser.CreateDate = Convert.ToDateTime(reader["CreateDate"].ToString()); //respondeUser.CreateUpdate = Convert.ToDateTime(reader["CreateUpdate"].ToString()); //respondeUser.MessageError = "0"; } reader.Close(); if (respondeUser.IDUser == 0) { result = 0; } else { result = 1; } } catch (Exception err) { respondeUser.MessageError = "Exception jope la hemos liado :(!!!! "; respondeUser.MessageError += err.Message; result = -1; } finally { con.Close(); } return result; }