private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("data source=DESKTOP-7KB122K\\WASSIMSQL; initial catalog=airport; integrated security=true");
if (checkBox1.Checked)
{
SqlCommand li = new SqlCommand("select * from Admin where admin_name = @name and admin_password = @pass", con);
con.Open();
SqlParameter pass = new SqlParameter("@pass", textBox1.Text);
SqlParameter name = new SqlParameter("@name", E_mail.Text);
li.Parameters.Add(name);
li.Parameters.Add(pass);
SqlDataReader myreader = li.ExecuteReader();
if (myreader.Read())
{
this.Hide();
admin admin = new admin(E_mail.Text);
admin.Show();
con.Close();
}
else
{
MessageBox.Show("the username or the password is invalid");
E_mail.Clear();
textBox1.Clear();
E_mail.Focus();
con.Close();
}
}
else
{
SqlCommand li2 = new SqlCommand("select * from Passenger where Passenger_username = @name and Passenger_password = @pass", con);
con.Open();
SqlParameter pass = new SqlParameter("@pass", textBox1.Text);
SqlParameter name = new SqlParameter("@name", E_mail.Text);
li2.Parameters.Add(name);
li2.Parameters.Add(pass);
SqlDataReader myreader = li2.ExecuteReader();
if (myreader.Read())
{
this.Hide();
user user = new user(E_mail.Text);
user.Show();
con.Close();
}
else
{
MessageBox.Show("the username or the password is invalid");
E_mail.Clear();
textBox1.Clear();
E_mail.Focus();
myreader.Close();
con.Close();
}
}
con.Close();
}
public Contacts Create(ServiceType st)
{
Contacts service;
switch (st)
{
case ServiceType.E_mail:
service = new E_mail();
break;
}
}
public void DeleteE_mailDB(ref E_mail ek)
{
string deleteString = @"DELETE FROM E_mail WHERE (EmailID = @EmailID)";
using (SqlCommand cmd = new SqlCommand(deleteString, OpenConnection))
{
cmd.Parameters.AddWithValue("@EmailID", ek.EmailID);
var id = (int)cmd.ExecuteNonQuery();
ek = null;
}
}
public Email(E_mail _mail)
{
InitializeComponent();
try
{
deText.Text = _mail.De;
assunto.Text = _mail.Assunto;
conteudo.Text = _mail.ConteudoTexto;
}
catch (Exception)
{
}
}
public void AddE_mailDB(ref E_mail hv)
{
// prepare command string using paramters in string and returning the given identity
string insertStringParam = @"INSERT INTO [E_mail] (E_mail_Address, PersonID)
OUTPUT INSERTED.EmailID
VALUES (@E_mail_Address, @PersonID)";
using (SqlCommand cmd = new SqlCommand(insertStringParam, OpenConnection))
{
// Get your parameters ready
cmd.Parameters.AddWithValue("@E_mail_Address", hv.Email_Adress); //.ToString("yyyy-MM-dd HH:mm:ss")
cmd.Parameters.AddWithValue("@PersonID", hv.persons.PersonID);
hv.EmailID = (long)cmd.ExecuteScalar(); //Returns the identity of the new tuple/record
}
}
public void UpdateE_mailDB(ref E_mail hv)
{
// prepare command string
string updateString =
@"UPDATE E_mail
SET Email_Adress = @Email_Adress
WHERE EmailID = @EmailID";
using (SqlCommand cmd = new SqlCommand(updateString, OpenConnection))
{
// Get your parameters ready
cmd.Parameters.AddWithValue("@EmailID", hv.EmailID);
cmd.Parameters.AddWithValue("@Email_Adress", hv.Email_Adress);
var id = (int)cmd.ExecuteNonQuery();
}
}
public void GetEmailById(ref E_mail ek)
{
string sqlcmd = @"SELECT Email_Address, EmailID FROM E_mail WHERE (EmailID =@EmailID )";
using (var cmd = new SqlCommand(sqlcmd, OpenConnection))
{
cmd.Parameters.AddWithValue("@EmailID", ek.EmailID);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
//Værktøjskasse curvk = new Værktøjskasse();
ek.EmailID = (int)rdr["EmailID"];
ek.Email_Adress = (string)rdr["Email_Adress"];
}
}
}
public List <E_mail> GetPerson_E_Mail(ref E_mail hv)
{
string selectToolboxToolString = @"SELECT *
FROM [E_Mail]
WHERE ([PersonID] = @PersonID)";
using (var cmd = new SqlCommand(selectToolboxToolString, OpenConnection))
{
SqlDataReader rdr = null;
cmd.Parameters.AddWithValue("@EmailID", hv.EmailID);
rdr = cmd.ExecuteReader();
List <E_mail> boxestohv = new List <E_mail>();
E_mail ek = null;
while (rdr.Read())
{
ek = new E_mail(); // Ny instans i hver gennemløb!
ek.EmailID = (int)rdr["EmailID"];
ek.Email_Adress = (string)rdr["E_mail_Adress"];
boxestohv.Add(ek);
}
return(boxestohv);
}
}
