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(); } }