// By Joel
internal static void InsertLogin(CustomerLogin login)
{
SqlConnection conn = TravelExpertsDB.GetConnection();
string insStmt = "INSERT INTO Logins (CustomerId, UserName, Password) VALUES (@cID, @uname, @pw)";
SqlCommand cmd = new SqlCommand(insStmt, conn);
cmd.Parameters.AddWithValue("@cID", login.CustomerId);
cmd.Parameters.AddWithValue("@uname", login.UserName);
cmd.Parameters.AddWithValue("@pw", login.Password);
try
{
conn.Open();
cmd.ExecuteNonQuery(); //Insert
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
public static bool ResetCustomerPassword(CustomerLogin reset)
{
SqlConnection con = TravelExpertsDB.GetConnection();
string UpdateSmt = "Update Logins " +
"SET Password = @Password " +
"WHERE CustomerId = @CustomerId";
SqlCommand cmd = new SqlCommand(UpdateSmt, con);
cmd.Parameters.AddWithValue("@CustomerId", reset.CustomerId);
cmd.Parameters.AddWithValue("@Password", reset.Password);
try
{
con.Open();
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
// By Joel
internal static CustomerLogin GetLoginByUserName(string text)
{
CustomerLogin login = null; // found customer
// define connection
SqlConnection connection = TravelExpertsDB.GetConnection();
// define the select query command
string selectQuery = "select * " +
"from Logins " +
"where UserName = @uname";
SqlCommand selectCommand = new SqlCommand(selectQuery, connection);
selectCommand.Parameters.AddWithValue("@uname", text);
try
{
// open the connection
connection.Open();
// execute the query
SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleResult);
// process the result if any
if (reader.Read()) // if there is customer
{
login = new CustomerLogin();
login.CustomerId = (int)reader["CustomerId"];
login.UserName = reader["UserName"].ToString();
login.Password = reader["Password"].ToString();
}
}
catch (Exception ex)
{
throw ex; // let the form handle it
}
finally
{
connection.Close(); // close connecto no matter what
}
return(login);
}
