/// <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;
}