private void ButtonSearch_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=DESKTOP-D2ICRPB;Initial Catalog=eMagazine;Integrated Security=True"); con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select publisher from MagazineInfo where [publisher]='" + textBoxSearch.Text + "'"; cmd.Connection = con; SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { if (rd[0].ToString().Trim() == textBoxSearch.Text) { q = 1; break; } } if (q == 1) { MagazineFound ts = new MagazineFound(); ts.MagazineFound_Load(textBoxSearch.Text); MainControlClass.showControl(ts, Content); } else { } con.Close(); }
private void ButtonSubscribe3_Click(object sender, EventArgs e) { Subscribe get = new Subscribe(); get.Subscribe_Load(3, PublisherName); MainControlClass.showControl(get, Content); }
private void BunifuFlatButton3_Click(object sender, EventArgs e) { sidePanel.Height = bunifuFlatButton3.Height; sidePanel.Top = bunifuFlatButton3.Top; SelectMagazineRead get = new SelectMagazineRead(); MainControlClass.showControl(get, Content); }
private void BunifuFlatButton2_Click(object sender, EventArgs e) { sidePanel.Height = bunifuFlatButton2.Height; sidePanel.Top = bunifuFlatButton2.Top; Browse gs = new Browse(); MainControlClass.showControl(gs, Content); }
private void BunifuFlatButton1_Click(object sender, EventArgs e) { sidePanel.Height = bunifuFlatButton1.Height; sidePanel.Top = bunifuFlatButton1.Top; Home get = new Home(); MainControlClass.showControl(get, Content); }
public SubscriberHome() { InitializeComponent(); sidePanel.Height = bunifuFlatButton1.Height; sidePanel.Top = bunifuFlatButton1.Top; Home get = new Home(); MainControlClass.showControl(get, Content); }
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(); } }
public LogIn() { MainControlClass get1 = new MainControlClass(); List <string> linesData = File.ReadAllLines(get1.tempCustomerIDLoc).ToList(); foreach (var line in linesData) { string[] entries = line.Split(','); linesData.Remove(line); break; } File.WriteAllLines(get1.tempCustomerIDLoc, linesData); InitializeComponent(); }
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"); } }
private void MagazineFound_Load(object sender, EventArgs e) { MainControlClass get1 = new MainControlClass(); List <string> linesData = File.ReadAllLines(get1.tempCustomerIDLoc).ToList(); foreach (var line in linesData) { string[] entries = line.Split(','); get1.CustomerID = entries[0]; break; } con.Open(); SqlCommand cmd = new SqlCommand("Select magazineID from Subscription where dateEnded > @dateNow AND customerID = @costomerID AND magazineID =@magID", con); cmd.Parameters.Add("@dateNow", DateTime.Now); cmd.Parameters.Add("@costomerID", get1.CustomerID); cmd.Parameters.Add("@magID", magazine1); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { if (Convert.ToInt32(dr[0].ToString().Trim()) == magazine1) { buttonSubscribe1.Text = "Subscribed"; buttonSubscribe1.Enabled = false; } break; } con.Close(); con.Open(); SqlCommand cmd2 = new SqlCommand("Select magazineID from Subscription where dateEnded > @dateNow AND customerID = @costomerID AND magazineID =@magID", con); cmd2.Parameters.Add("@dateNow", DateTime.Now); cmd2.Parameters.Add("@costomerID", get1.CustomerID); cmd2.Parameters.Add("@magID", magazine2); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { if (Convert.ToInt32(dr2[0].ToString().Trim()) == magazine2) { buttonSubscribe2.Text = "Subscribed"; buttonSubscribe2.Enabled = false; } break; } con.Close(); con.Open(); SqlCommand cmd3 = new SqlCommand("Select magazineID from Subscription where dateEnded > @dateNow AND customerID = @costomerID AND magazineID =@magID", con); cmd3.Parameters.Add("@dateNow", DateTime.Now); cmd3.Parameters.Add("@costomerID", get1.CustomerID); cmd3.Parameters.Add("@magID", magazine3); SqlDataReader dr3 = cmd3.ExecuteReader(); while (dr3.Read()) { if (Convert.ToInt32(dr3[0].ToString().Trim()) == magazine3) { buttonSubscribe3.Text = "Subscribed"; buttonSubscribe3.Enabled = false; } break; } con.Close(); }