public string DoLogin(UserRequest user)
{
throw new NotImplementedException();
}
//private string connectionString = ConfigurationManager.ConnectionStrings["SiteSqlServer"].ToString();
/*private string str = ConfigurationManager.ConnectionStrings["SiteSqlServer"].ToString();*/
//public string GetData(int value)
//{
// return string.Format("You entered: {0}", value);
//}
//public CompositeType GetDataUsingDataContract(CompositeType composite)
//{
// if (composite == null)
// {
// throw new ArgumentNullException("composite");
// }
// if (composite.BoolValue)
// {
// composite.StringValue += "Suffix";
// }
// return composite;
//}
// public string DoLogin(UserRequest request)
// {
// string lblResult = string.Empty; ;
// string selectSQL = "SELECT Pk_User, Fullname, Email,Password,CreateDate,CreateUpdate FROM Users where Email = @email and Password = @password";
// SqlConnection con = new SqlConnection(connectionString);
// SqlCommand cmd = new SqlCommand(selectSQL, con);
// cmd.Parameters.AddWithValue("@email", request.Email);
// cmd.Parameters.AddWithValue("@password", request.Password);
// SqlDataReader reader;
// UserResponde responde = new UserResponde();
// try
// {
// con.Open();
// reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// responde.IDUser = Convert.ToInt32(reader["Pk_User"].ToString());
// if (responde.IDUser == 0) {
// lblResult = "0";
// return lblResult;
// }else
// {
// lblResult = "1";
// return lblResult;
// }
// //responde.Fullname = reader["Fullname"].ToString();
// //responde.Email = reader["Email"].ToString();
// //responde.Password = reader["Password"].ToString();
// //responde.CreateDate = Convert.ToDateTime(reader["CreateDate"].ToString());
// //responde.CreateUpdate = Convert.ToDateTime(reader["CreateUpdate"].ToString());
// //responde.Fullname = reader["Fullname"].ToString();
// //responde.Email = reader["Email"].ToString();
// //responde.Password = reader["Password"].ToString();
// //responde.CreateDate = Convert.ToDateTime(reader["CreateDate"].ToString());
// //responde.CreateUpdate = Convert.ToDateTime(reader["CreateUpdate"].ToString());
// }
// reader.Close();
// }
// catch (Exception err)
// {
// lblResult = "Exception jope!!!! ";
// lblResult += err.Message;
// }
// finally
// {
// con.Close();
// }
// return lblResult;
//}
/// <summary>
/// Registrar usuario
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public string PostRegister(UserRequest user)
{
// insertSQL += "phone, address, city, state, zip, contract) ";
string lblResult;
string insertSQL;
insertSQL = "INSERT INTO Users (";
insertSQL += "Fullname, Email, Password, CreateDate,CreateUpdate) ";
insertSQL += "VALUES (";
insertSQL += "?,?, ?, ";
insertSQL += "?, ?)";
OleDbConnection con = new OleDbConnection(connectionString);
OleDbCommand cmd = new OleDbCommand(insertSQL, con);
cmd.Parameters.Add("@Fullname",OleDbType.VarChar,100).Value = user.Fullname;
cmd.Parameters.Add("@Email", OleDbType.VarChar, 100).Value = user.Email;
cmd.Parameters.Add("@Password", OleDbType.VarChar, 100).Value = user.Password;
cmd.Parameters.Add("@CreateDate", OleDbType.Date).Value = DateTime.Now;
cmd.Parameters.Add("@CreateUpdate", OleDbType.Date).Value = DateTime.Now;
// cmd.Parameters.AddWithValue("@city", txtCity.Text);
//cmd.Parameters.AddWithValue("@state", txtState.Text);
//cmd.Parameters.AddWithValue("@zip", txtZip.Text);
//cmd.Parameters.AddWithValue("@contract", Convert.ToInt16(chkContract.Checked));
int added = 0;
try
{
con.Open();
int i = VerificarEmail(user.Email);
if (i == 0)
{
added = cmd.ExecuteNonQuery();
// lblResult = added.ToString();
return GetIdUser(user.Email).ToString();
}
else {
return "0";
}
}
catch (Exception err)
{
lblResult = "Error inserting record. ";
lblResult += err.Message;
return lblResult;
}
finally
{
con.Close();
}
}
