private void ButtonLogIn_Click(object sender, EventArgs e)
{
if (textBoxUsername.Text == "Username:"******"Password:"******"Enter your Username or Password");
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand("Select password From CustomerInfo where username='******'", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr[0].ToString().Trim() == textBoxPassword.Text)
{
q = 1;
break;
}
}
con.Close();
if (q == 1)
{
MainControlClass get1 = new MainControlClass();
List <string> linesData = File.ReadAllLines(get1.tempCustomerIDLoc).ToList();
con.Open();
SqlCommand cmdr = new SqlCommand("select customerID from CustomerInfo where username='******'", con);
SqlDataReader drr = cmdr.ExecuteReader();
while (drr.Read())
{
customerID = drr[0].ToString();
linesData.Add(customerID);
File.WriteAllLines(get1.tempCustomerIDLoc, linesData);
}
con.Close();
foreach (var line in linesData)
{
string[] entries = line.Split(',');
get1.CustomerID = entries[0];
break;
}
SubscriberHome get = new SubscriberHome();
get.SubscriberHome_Load(textBoxUsername.Text);
get.Show();
this.Hide();
}
else
{
MessageBox.Show("Incorrect Username or Password");
}
con.Close();
}
}
private void ButtonConfirm_Click(object sender, EventArgs e)
{
SubscriberHome get = new SubscriberHome();
MainControlClass get1 = new MainControlClass();
Home get3 = new Home();
con.Open();
SqlCommand cmd = new SqlCommand("Select magazineID from MagazineInfo where [publisher]='" + publisher + "' AND Issue#='" + issueNo + "' ", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
magID = dr.GetValue(0).ToString();
break;
}
con.Close();
List <string> linesData = File.ReadAllLines(get1.tempCustomerIDLoc).ToList();
foreach (var line in linesData)
{
string[] entries = line.Split(',');
get1.CustomerID = entries[0];
break;
}
if (comboBoxNoOfMonths.SelectedIndex == 0)
{
con.Open();
SqlCommand cmdr0 = new SqlCommand("Insert Into Subscription values('" + get1.CustomerID + "','" + Int32.Parse(magID) + "','" + DateTime.Now.ToString("M-d-yyyy") + "','" + DateTime.Now.AddDays(30).ToString("M-d-yyyy") + "')", con);
cmdr0.ExecuteNonQuery();
con.Close();
MessageBox.Show("Subscription Success!");
MainControlClass.showControl(get3, Content);
}
else if (comboBoxNoOfMonths.SelectedIndex == 1)
{
con.Open();
SqlCommand cmdr1 = new SqlCommand("Insert Into Subscription values('" + get1.CustomerID + "','" + Int32.Parse(magID) + "','" + DateTime.Now.ToString("M-d-yyyy") + "','" + DateTime.Now.AddDays(60).ToString("M-d-yyyy") + "')", con);
cmdr1.ExecuteNonQuery();
con.Close();
MessageBox.Show("Subscription Success!");
MainControlClass.showControl(get3, Content);
}
else if (comboBoxNoOfMonths.SelectedIndex == 2)
{
con.Open();
SqlCommand cmdr2 = new SqlCommand("Insert Into Subscription values('" + get1.CustomerID + "','" + Int32.Parse(magID) + "','" + DateTime.Now.ToString("M-d-yyyy") + "','" + DateTime.Now.AddDays(90).ToString("M-d-yyyy") + "')", con);
cmdr2.ExecuteNonQuery();
con.Close();
MessageBox.Show("Subscription Success!");
MainControlClass.showControl(get3, Content);
}
else if (comboBoxNoOfMonths.SelectedIndex == 3)
{
con.Open();
SqlCommand cmdr3 = new SqlCommand("Insert Into Subscription values('" + get1.CustomerID + "','" + Int32.Parse(magID) + "','" + DateTime.Now.ToString("M-d-yyyy") + "','" + DateTime.Now.AddDays(120).ToString("M-d-yyyy") + "')", con);
cmdr3.ExecuteNonQuery();
con.Close();
MessageBox.Show("Subscription Success!");
MainControlClass.showControl(get3, Content);
}
else if (comboBoxNoOfMonths.SelectedIndex == 4)
{
con.Open();
SqlCommand cmdr4 = new SqlCommand("Insert Into Subscription values('" + get1.CustomerID + "','" + Int32.Parse(magID) + "','" + DateTime.Now.ToString("M-d-yyyy") + "','" + DateTime.Now.AddDays(150).ToString("M-d-yyyy") + "')", con);
cmdr4.ExecuteNonQuery();
con.Close();
MessageBox.Show("Subscription Success!");
MainControlClass.showControl(get3, Content);
}
else if (comboBoxNoOfMonths.SelectedIndex == 5)
{
con.Open();
SqlCommand cmdr5 = new SqlCommand("Insert Into Subscription values('" + get1.CustomerID + "','" + Int32.Parse(magID) + "','" + DateTime.Now.ToString("M-d-yyyy") + "','" + DateTime.Now.AddDays(180).ToString("M-d-yyyy") + "')", con);
cmdr5.ExecuteNonQuery();
con.Close();
MessageBox.Show("Subscription Success!");
MainControlClass.showControl(get3, Content);
}
else
{
MessageBox.Show("Select how many months to subscribe");
}
}