//Μεθοδος που ελεγχεί αν υπαρχει ο χρήστης στη βάση (Για αποφυγεί σφαλμάτων στη βαση κατα την διαδικασία του login ή οποιαδηποτε αλλη συμπεριλαμβανη τον χρήστη)
public bool checkUserName(string userName)
{
enventDataSetTableAdapters.userTableAdapter checkUserName = new enventDataSetTableAdapters.userTableAdapter();
if (Convert.ToInt32(checkUserName.tryLogInAsUser(userName)) > 0)
{
return(false);
}
else
{
return(true);
}
}
public Profile(int userID)
{
enventDataSetTableAdapters.userTableAdapter pro = new enventDataSetTableAdapters.userTableAdapter();
List <enventDataSet.userRow> results = pro.getProfile(userID).ToList();
this.fname = results.ElementAt(0).fname;
this.lname = results.ElementAt(0).lname;
this.email = results.ElementAt(0).email;
this.address = results.ElementAt(0).address;
this.gender = results.ElementAt(0).gender;
this.dob = results.ElementAt(0).dob;
}
//Μέθοδος για το LogIn
public User LogInAsNormalUser(string userName, string passWord)
{
enventDataSetTableAdapters.userTableAdapter tr = new enventDataSetTableAdapters.userTableAdapter();
if (Convert.ToInt32(tr.tryLogInAsUser(userName)) > 0)
{
InstanceOfUser.CreateCustomerUser(userName, passWord); //Δημιουργία global χρήστη τύπου normla στην στατική κλάση.
return(InstanceOfUser.GetUser()); // Επιστροφή
}
else
{
throw new Exceptions.FailLogInAsNormalUser("O Χρήστης δεν υπάρχει");
}
}
private void button1_Click(object sender, EventArgs e)
{
//Dimiourgia antikeimenou gia na pame to email se alli klasi
theEmail = EmailForgot.Text;
User x = InstanceOfUser.GetUser();
if ((x is Visitor) && (emailExists()))
{
Visitor vis = (Visitor)x;
enventDataSetTableAdapters.userTableAdapter env = new enventDataSetTableAdapters.userTableAdapter();
string username = env.returnUsernamePassword(theEmail).ToList().ElementAt(0).username;
string password = env.returnUsernamePassword(theEmail).ToList().ElementAt(0).password;
NormalUser nu = (NormalUser)vis.LogInAsNormalUser(username, password);
}
if (emailExists())
{
//Dimiourgia Random Verification Code
Random rand = new Random();
randomCode = (rand.Next(999999)).ToString();
//Apostoli Email
MailMessage mm = new MailMessage("*****@*****.**", EmailForgot.Text.Trim());
mm.Subject = "Κωδικός Επαναφοράς";
mm.Body = string.Format("Ο κωδικός επαναφοράς είναι: " + randomCode);
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential();
NetworkCred.UserName = "******";
NetworkCred.Password = "******";
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
labelSend.ForeColor = Color.Green;
labelSend.Text = "Ο κωδικός επαναφοράς εστάλη επιτυχώς!";
}
else
{
labelSend.ForeColor = Color.Red;
labelSend.Text = "Το e-mail δεν βρέθηκε";
}
}
public RegisteredUser(string userName, string passWord)
{
try
{
enventDataSetTableAdapters.userTableAdapter id = new enventDataSetTableAdapters.userTableAdapter();
this.userID = id.getID(userName).ToList().ElementAt(0).id;
}
catch (Exception e)
{
enventDataSetTableAdapters.adminTableAdapter id = new enventDataSetTableAdapters.adminTableAdapter();
this.userID = id.GetID(userName).ToList().ElementAt(0).id;
}
this.userName = userName;
this.passWord = passWord;
}
private Boolean emailExists()
{
bool result;
//elegxoume an yparxei to email sti vasi
enventDataSetTableAdapters.userTableAdapter kati = new enventDataSetTableAdapters.userTableAdapter();
int counter = Convert.ToInt32(kati.checkEmail(EmailForgot.Text));
if (counter > 0)
{
result = true;
}
else
{
result = false;
}
return(result);
}
//Μέθοδο για την εγγραφή του χρήστη
public void signUpAsUser(UserProfile profile, string userName, string passWord, List <int> prefferences)
{
enventDataSetTableAdapters.userTableAdapter singUp = new enventDataSetTableAdapters.userTableAdapter();
if (checkUserName(userName)) //Έλεγχος αν υπάρχει το username ήδη .
{
singUp.registerAsUser(profile.GetFirstName(), profile.GetLastName(), userName, passWord, profile.GetEmail(), profile.GetAddress(), profile.GetGender(), profile.GetDob()); //Η εγγραφη στη βαση
if (prefferences.Count > 0) //Ελεγχος αν ο χρήστης συμπλήρωσε προτημίσης
{
enventDataSetTableAdapters.preffered_categoriesTableAdapter prefference = new enventDataSetTableAdapters.preffered_categoriesTableAdapter();
int id = Convert.ToInt32(singUp.getID(userName).ToList().ElementAt(0).id); //Παίρνει το id που μόλις δημιουργήθηκε
foreach (int i in prefferences) // Σάρωση της λίστας με τα ενδιαφεροντα που συμπληρωσε ο χρήστης
{
prefference.insertPrefference(id, i);//Εγγραφη στη βαση
}
}
}
else
{
throw new Exceptions.UserNameException("User name is already in use"); //Σε περίπτωση που το username χρησιμοποιήτε ήδη
}
}
public static bool CheckEmail(String email)
{
enventDataSetTableAdapters.userTableAdapter check = new enventDataSetTableAdapters.userTableAdapter();
return(Convert.ToBoolean(check.checkEmail(email)));
}
public static bool CheckUserName(String userName)
{
enventDataSetTableAdapters.userTableAdapter checkUserName = new enventDataSetTableAdapters.userTableAdapter();
return(Convert.ToBoolean(checkUserName.tryLogInAsUser(userName)));
}
public override void UpdatePassword(int id, string password)
{
enventDataSetTableAdapters.userTableAdapter up = new enventDataSetTableAdapters.userTableAdapter();
up.updatePassword(password, id);
}
public override void UpdateUserName(int id, string userName)
{
enventDataSetTableAdapters.userTableAdapter up = new enventDataSetTableAdapters.userTableAdapter();
up.updateUserName(userName, id);
}
public override void UpdateEmail(int id, string email)
{
enventDataSetTableAdapters.userTableAdapter up = new enventDataSetTableAdapters.userTableAdapter();
up.updateEmail(email, id);
}
public override void UpdateAddress(int id, string address)
{
enventDataSetTableAdapters.userTableAdapter up = new enventDataSetTableAdapters.userTableAdapter();
up.updateAddress(address, id);
}
