private void NewStudentAdd_Click(object sender, EventArgs e)
{
try
{
Item collegeItem = (Item)newStudentCollege.SelectedItem;
Item majorItem = (Item)newStudentMajor.SelectedItem;
String collegeID = collegeItem.Value.ToString();
String majorID = majorItem.Value.ToString();
String name = newStudentName.Text;
if (name.Length == 0)
{
throw new System.ArgumentException("Parameter cannot be empty", "original");
}
newStudentCollege.SelectedIndex = -1;
newStudentName.Text = "";
Walton_DB.ExecSqlString(
"INSERT INTO tbl_Students (StudentName, StudentCollege, StudentMajor) VALUES ('" +
name.Trim() + "'," + collegeID + "," + majorID + ")");
loadData();
} catch
{
System.Windows.Forms.MessageBox.Show("You must enter a Name, College, and Major before adding a student.\n\nStudent not added.",
"Error Adding Student",
System.Windows.Forms.MessageBoxButtons.OK,
System.Windows.Forms.MessageBoxIcon.Error);
}
}
private void PopulateCourseGradeTerm()
{
//Adds the corresponding grade to the class
cboGrade.Items.Add("A");
cboGrade.Items.Add("B");
cboGrade.Items.Add("C");
cboGrade.Items.Add("D");
cboGrade.Items.Add("F");
Walton_DB.FillDataTable_ViaSql(ref dtCourse, "SELECT CourseID, Course FROM tbl_Courses order by Course");
if (dtCourse != null && dtCourse.Rows.Count > 0)
{
foreach (DataRow dr in dtCourse.Rows)
{
cboCourse.Items.Add(dr["Course"]);
}
}
Walton_DB.FillDataTable_ViaSql(ref dtTerms, "SELECT TermID, Term FROM tbl_Terms order by Term");
if (dtTerms != null && dtTerms.Rows.Count > 0)
{
foreach (DataRow dr in dtTerms.Rows)
{
cboTerm.Items.Add(dr["Term"]);
}
}
}
private void NewGradeAdd_Click(object sender, EventArgs e)
{
try
{
Item studentItem = (Item)newGradeStudent.SelectedItem;
Item courseItem = (Item)newGradeCourse.SelectedItem;
Item termItem = (Item)newGradeTerm.SelectedItem;
String studentID = studentItem.Value.ToString();
String courseID = courseItem.Value.ToString();
String termID = termItem.Value.ToString();
String grade = (string)newGradeGrade.SelectedItem;
Walton_DB.ExecSqlString("INSERT INTO tbl_Grades (Student, Course, Term, Grade) VALUES (" +
studentID + "," + courseID + "," + termID + ",'" + grade + "')");
newGradeGrade.SelectedIndex = -1;
loadData();
}
catch
{
System.Windows.Forms.MessageBox.Show("You must select a Student, Course, Grade, and Term before adding a Grade.\n\nGrade not added.",
"Error Adding Grade",
System.Windows.Forms.MessageBoxButtons.OK,
System.Windows.Forms.MessageBoxIcon.Error);
}
}
private void bttnAddCust_Click(object sender, EventArgs e)
{
//INSERTINTO Customer(name, phone) VALUES('John', '4795551212')"
if (Walton_DB.ExecSqlString("INSERT INTO Customer (name, phone) VALUES ('" + txtCustomerName.Text + "','" + txtRewardsTelephone.Text + "')"))
{
MessageBox.Show("Customer Added!");
}
}
private void PopulateCollegeDropDown()
{
//Calls upon the walton database to gather information and display a list of colleges offered at the school
Walton_DB.FillDataTable_ViaSql(ref dtColleges, "SELECT CollegeID, College FROM tbl_Colleges order by College");
foreach (DataRow dr in dtColleges.Rows)
{
cboCollege.Items.Add(dr["College"]);
}
}
private void bttnInventoryRprt_Click(object sender, EventArgs e)
{
sql = "SELECT InventoryOrderNumber, Inventory_Name, Qty_Ordered, Date_Ordered FROM InventoryOrderingLog";
DataTable dtCustomerInfo = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtCustomerInfo, sql);
dataGridView3.DataSource = dtCustomerInfo;
dataGridView3.Refresh();
}
private void cmbPhone_SelectedIndexChanged(object sender, EventArgs e)
{
sql = "SELECT Customer_Id, name, phone FROM Customer";
DataTable dtCustomerInfo = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtCustomerInfo, sql);
dataGridView2.DataSource = dtCustomerInfo;
dataGridView2.Refresh();
}
private void bttnAddExpense_Click(object sender, EventArgs e)
{
if (Walton_DB.ExecSqlString("INSERT INTO Expense (eDesc, expseCost) VALUES ('" + txtBoxExpseDesc.Text + "','" + txtBoxExpseAmt.Text + "')"))
{
MessageBox.Show("Expense Added!");
}
txtBoxExpseAmt.Text = "";
txtBoxExpseDesc.Text = "";
}
private void btnList_Click(object sender, EventArgs e)
{
sql = "SELECT jpMember_Id, name, birthday, city, email, gender, phone, postal, street, zip FROM jpMembers";
DataTable dtjpMembers = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtjpMembers, sql);
dataGridView1.DataSource = dtjpMembers;
dataGridView1.Refresh();
}
private void bttnSalesRprt_Click(object sender, EventArgs e)
{
{
sql = "SELECT Payment_Id, aDue, aPaid, customer FROM Payment";
DataTable dtCustomerInfo = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtCustomerInfo, sql);
dataGridView3.DataSource = dtCustomerInfo;
dataGridView3.Refresh();
}
}
private void bttnExpenseRprt_Click(object sender, EventArgs e)
{
{
sql = "SELECT Expense_Id, eDesc, expseCost FROM Expense";
DataTable dtCustomerInfo = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtCustomerInfo, sql);
dataGridView3.DataSource = dtCustomerInfo;
dataGridView3.Refresh();
}
}
private void PopulateStudentDropDown()
{
//Calls upon the walton database to populate the student table with student names
Walton_DB.FillDataTable_ViaSql(ref dtStudents, "SELECT StudentID, StudentName FROM tbl_Students order by StudentName");
if (dtStudents != null && dtStudents.Rows.Count > 0)
{
foreach (DataRow dr in dtStudents.Rows)
{
cboStudent.Items.Add(dr["StudentName"]);
}
}
}
private void PopulateMajorDropDown()
{
//Calls upon the walton database to get a list of majors offered at the school
cboMajor.Items.Clear();
Walton_DB.FillDataTable_ViaSql(ref dtMajors, "SELECT MajorID, Major FROM tbl_Majors where CollegeID = " + dtColleges.Select("College = '" + cboCollege.Text + "'")[0]["CollegeID"].ToString());
if (dtMajors != null && dtMajors.Rows.Count > 0)
{
foreach (DataRow dr in dtMajors.Rows)
{
cboMajor.Items.Add(dr["Major"]);
}
}
}
private void RefreshStudentDGV()
{
//Updates the grid with the student information
DataTable dtStudents = null;
Walton_DB.FillDataTable_ViaSql(ref dtStudents, "SELECT tbl_Students.StudentID, tbl_Students.StudentName, tbl_Colleges.College, tbl_Majors.Major FROM tbl_Students INNER JOIN tbl_Colleges ON tbl_Students.StudentCollege = tbl_Colleges.CollegeID INNER JOIN tbl_Majors ON tbl_Students.StudentMajor = tbl_Majors.MajorID");
if (dtStudents != null && dtStudents.Rows.Count > 0)
{
dgbStudents.DataSource = dtStudents;
dgbStudents.Refresh();
}
}
private void RefreshGradeDGV()
{
//Refreshes and updates the grades
DataTable dtStudents = null;
Walton_DB.FillDataTable_ViaSql(ref dtStudents, "SELECT tbl_Students.StudentName, tbl_Courses.Course, tbl_Terms.Term, tbl_Grades.Grade FROM tbl_Grades INNER JOIN tbl_Students ON tbl_Grades.Student = tbl_Students.StudentID INNER JOIN tbl_Courses ON tbl_Grades.Course = tbl_Courses.CourseID INNER JOIN tbl_Terms ON tbl_Grades.Term = tbl_Terms.TermID");
if (dtStudents != null && dtStudents.Rows.Count > 0)
{
dgbGrades.DataSource = dtStudents;
dgbGrades.Refresh();
}
}
private void loadData()
{
newStudentCollege.Items.Clear();
newStudentMajor.Items.Clear();
newGradeStudent.Items.Clear();
newGradeTerm.Items.Clear();
newGradeCourse.Items.Clear();
DataTable dtCollegeList = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtCollegeList,
"SELECT CollegeID, College FROM tbl_Colleges order by College");
foreach (DataRow dr in dtCollegeList.Rows)
{
newStudentCollege.Items.Add(new Item((String)dr["College"], (int)(dr["CollegeID"])));
}
DataTable dtStudentList = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtStudentList,
"SELECT StudentID, StudentName FROM tbl_Students order by StudentName");
foreach (DataRow dr in dtStudentList.Rows)
{
newGradeStudent.Items.Add(new Item((String)dr["StudentName"], (int)(dr["StudentID"])));
}
DataTable dtCourseList = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtCourseList,
"SELECT CourseID, Course FROM tbl_Courses order by Course");
foreach (DataRow dr in dtCourseList.Rows)
{
newGradeCourse.Items.Add(new Item((String)dr["Course"], (int)(dr["CourseID"])));
}
DataTable dtTermList = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtTermList,
"SELECT TermID, Term FROM tbl_Terms order by Term");
foreach (DataRow dr in dtTermList.Rows)
{
newGradeTerm.Items.Add(new Item((String)dr["Term"], (int)(dr["TermID"])));
}
refreshDataGridViews();
}
private void refreshDataGridViews()
{
DataTable dtStudentsList = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtStudentsList,
"SELECT tbl_Students.StudentID, tbl_Students.StudentName, tbl_Colleges.College, tbl_Majors.Major FROM tbl_Students INNER JOIN tbl_Colleges ON tbl_Students.StudentCollege = tbl_Colleges.CollegeID INNER JOIN tbl_Majors ON tbl_Students.StudentMajor = tbl_Majors.MajorID");
studentDataBindingSource.DataSource = dtStudentsList;
DataTable dtGradesList = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtGradesList,
"SELECT tbl_Students.StudentName, tbl_Courses.Course, tbl_Terms.Term, tbl_Grades.Grade FROM tbl_Grades INNER JOIN tbl_Students ON tbl_Grades.Student = tbl_Students.StudentID INNER JOIN tbl_Courses ON tbl_Grades.Course = tbl_Courses.CourseID INNER JOIN tbl_Terms ON tbl_Grades.Term = tbl_Terms.TermID");
gradeDataBindingSource.DataSource = dtGradesList;
}
private void bttnOrderInventory_Click(object sender, EventArgs e)
{
if (Walton_DB.ExecSqlString("INSERT INTO InventoryOrderingLog (Inventory_Name, Qty_Ordered, Date_Ordered) VALUES ('" + drpDownInventory.SelectedItem.ToString() + "','" + txtBoxInvQty.Text + "','" + txtBoxInvDate.Text + "')"))
{
MessageBox.Show("Inventory Order Logged!");
}
drpDownInventory.SelectedIndex = -1;
txtBoxInvQty.Text = "";
txtBoxInvSalesTax.Text = "";
txtBoxInvPreTax.Text = "";
txtBoxInvTotal.Text = "";
richTxtBoxInventory.Text = "";
txtBoxInvDate.Text = "";
}
private void NewStudentCollege_SelectedIndexChanged(object sender, EventArgs e)
{
if (newStudentCollege.SelectedIndex == -1)
{
return;
}
Item itm = (Item)newStudentCollege.SelectedItem;
DataTable dtMajorList = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtMajorList,
"SELECT MajorID, Major FROM tbl_Majors where CollegeID = " + itm.Value.ToString());
foreach (DataRow dr in dtMajorList.Rows)
{
newStudentMajor.Items.Add(new Item((String)dr["Major"], (int)(dr["MajorID"])));
}
}
private void ShowOrderInventory()
{
pnlOrderInventory.Visible = true;
pnlOrderInventory.Dock = DockStyle.Fill;
pnlMainMenu.Visible = false;
pnlReports.Visible = false;
pnlJPMembers.Visible = false;
pnlExpenses.Visible = false;
sql = "SELECT Inventory_Id, Inventory_Name, Package_Amount, Price, Reorder_Level FROM Inventory";
DataTable dtCustomerInfo = new DataTable();
Walton_DB.FillDataTable_ViaSql(ref dtCustomerInfo, sql);
dataGridViewInventory.DataSource = dtCustomerInfo;
dataGridViewInventory.Refresh();
}
private void btnAddStudent_Click(object sender, EventArgs e)
{
//Adds a student to the table
if (txtName.Text == "")
{
MessageBox.Show("Please enter a name.");
return;
}
if (cboCollege.SelectedIndex == -1)
{
MessageBox.Show("Please select a college.");
return;
}
if (cboMajor.SelectedIndex == -1)
{
MessageBox.Show("Please select a major.");
return;
}
string CollegeID = dtColleges.Select("College = '" + cboCollege.Text + "'")[0]["CollegeID"].ToString();
string MajorID = dtMajors.Select("Major = '" + cboMajor.Text + "'")[0]["MajorID"].ToString();
if (Walton_DB.ExecSqlString("INSERT INTO tbl_Students (StudentName, StudentCollege, StudentMajor) VALUES ('"
+ txtName.Text.Trim() + "'," + CollegeID.ToString() + "," + MajorID.ToString() + ")"))
{
MessageBox.Show("Student " + txtName.Text + " was added to the database." +
System.Environment.NewLine + "College: " + cboCollege.Text + "(" + CollegeID + ")" +
System.Environment.NewLine + "Major: " + cboMajor.Text + "(" + MajorID + ")");
txtName.Text = "";
cboCollege.SelectedIndex = -1;
cboMajor.SelectedIndex = -1;
RefreshStudentDGV();
}
else
{
MessageBox.Show("Database Error - please try again!");
}
}
private void btnAddGrade_Click(object sender, EventArgs e)
{
//Adds the grade to the class for that particular student
if (cboStudent.SelectedIndex == -1)
{
MessageBox.Show("You must select a student.");
return;
}
if (cboCourse.SelectedIndex == -1)
{
MessageBox.Show("You must select a course.");
return;
}
if (cboGrade.SelectedIndex == -1)
{
MessageBox.Show("You must select a gradet.");
return;
}
if (cboTerm.SelectedIndex == -1)
{
MessageBox.Show("You must select a term.");
return;
}
string StudentID = dtStudents.Select("StudentName = '" + cboStudent.Text + "'")[0]["StudentID"].ToString();
string CourseID = dtCourse.Select("Course = '" + cboCourse.Text + "'")[0]["CourseID"].ToString();
string TermID = dtTerms.Select("Term = '" + cboTerm.Text + "'")[0]["TermID"].ToString();;
if (Walton_DB.ExecSqlString("INSERT INTO tbl_Grades (Student, Course, Term, Grade) VALUES (" + StudentID.ToString() + "," + CourseID.ToString() + "," + TermID.ToString() + ",'" + cboGrade.Text + "')"))
{
MessageBox.Show("Student added!");
PopulateStudentDropDown();
RefreshGradeDGV();
}
else
{
MessageBox.Show("Database Error - please try again!");
}
}
private void bttnCompleteOrder_Click(object sender, EventArgs e)
{
if (Walton_DB.ExecSqlString("INSERT INTO Payment (Customer, aDue, aPaid) VALUES ('" + txtCustomerName.Text.ToString() + "','" + txtBoxTotal.Text.ToString() + "','" + txtBoxTotal.Text.ToString() + "')"))
{
MessageBox.Show("Order Completed!");
}
txtBoxBowlQty.Text = "";
txtBoxPreTaxTot.Text = "";
txtBoxRewardsFromOrder.Text = "";
txtBoxSalesTaxTotal.Text = "";
txtBoxShootersQty.Text = "";
txtBoxSmoothieQty.Text = "";
txtBoxTotal.Text = "";
txtCustomerName.Text = "";
txtRewardsTelephone.Text = "";
drpDownBowls.SelectedIndex = -1;
drpDownShooters.SelectedIndex = -1;
drpDownSmoothies.SelectedIndex = -1;
drpDownPhoneNum.SelectedIndex = -1;
richTextBoxOrderSummary.Text = "";
}
private void bttnAddCustJP_Click(object sender, EventArgs e)
{
string Gender = "";
Gender = drpDownJPGender.ToString();
string CustomerName = "";
CustomerName = txtJPCustomerName.Text;
string Phone = "";
Phone = txtJPPhoneNumb.Text;
string Street = "";
Street = txtJPStreetAddress.Text;
string City = "";
City = txtJPCityAddress.Text;
string PostalCode = "";
PostalCode = txtJPPostalCode.Text;
//if (txtJPDOB.Text == "")
//{
// MessageBox.Show("Please Enter Date of Birth MM/DD/YYYY");
// return;
//}
//if (CustomerName.Trim() == "")
//{
// MessageBox.Show("You Must Enter A Name!");
// return;
//}
//else if (Phone.Trim() == "")
//{
// MessageBox.Show("You Must Enter A Number!");
// return;
//}
//else if (drpDownJPGender.SelectedIndex != -1)
//{
// Gender = drpDownJPGender.Text;
//}
//else if (drpDownJPGender.SelectedIndex == -1)
//{
// MessageBox.Show("You Must Select A Gender");
// return;
//}
//else if (Street.Trim() == "")
//{
// MessageBox.Show("You Must Enter Your Street Address");
// return;
//}
//else if (City.Trim() == "")
//{
// MessageBox.Show("You Must Enter A City!");
// return;
//}
//else if (PostalCode.Trim() == "")
//{
// MessageBox.Show("You Must Enter A Postal Code!");
// return;
//}
if (Walton_DB.ExecSqlString("INSERT INTO jpMembers (name, phone, birthday, gender, street, city, zip ) VALUES ('" + txtJPCustomerName.Text + "','" + txtJPPhoneNumb.Text + "' , '" + txtJPDOB.Text + "', '" + drpDownJPGender.SelectedItem.ToString() + "' , '" + txtJPStreetAddress.Text + "', '" + txtJPCityAddress.Text + "', '" + txtJPPostalCode.Text + "')"))
{
MessageBox.Show("Juicy Perks Member Added");
return;
}
}
