private void viewButton_Click(object sender, EventArgs e) { datesListBox.Items.Clear(); int id; int.TryParse(iDLabel1.Text, out id); //fname = firstTextBox.Text; //lname = lastTextBox.Text; Bus449_TestDataSetTableAdapters.Oncall_CalendarTableAdapter oncall = new Bus449_TestDataSetTableAdapters.Oncall_CalendarTableAdapter(); Bus449_TestDataSetTableAdapters.EmployeeTableAdapter employee = new Bus449_TestDataSetTableAdapters.EmployeeTableAdapter(); //int.TryParse(employeeTableAdapter.GetDataByName(lname, fname).ToString(), out id); DataView calendar = new DataView(bus449_TestDataSet.Oncall_Calendar); calendar.Sort = "Date_ID ASC"; foreach (DataRowView dr in calendar) { int am, pm; int.TryParse(dr["empid_am"].ToString(), out am); int.TryParse(dr["empid_pm"].ToString(), out pm); if (am == id || pm == id) { DateTime add = new DateTime(); add = DateTime.Parse(dr["Date_ID"].ToString()); datesListBox.Items.Add(add.ToString("MM/dd/yyyy")); } } }
private void viewButton_Click(object sender, EventArgs e) { datesListView.Items.Clear(); DateTime start = new DateTime(); DateTime end = new DateTime(); start = startDateTimePicker.Value; end = endDateTimePicker.Value; Bus449_TestDataSetTableAdapters.Oncall_CalendarTableAdapter oncall = new Bus449_TestDataSetTableAdapters.Oncall_CalendarTableAdapter(); Bus449_TestDataSetTableAdapters.EmployeeTableAdapter employee = new Bus449_TestDataSetTableAdapters.EmployeeTableAdapter(); DataView calendar = new DataView(bus449_TestDataSet.Oncall_Calendar); calendar.Sort = "Date_ID ASC"; foreach (DataRowView dr in calendar) { DateTime date = new DateTime(); date = DateTime.Parse(dr["Date_ID"].ToString()); if (date >= start && date <= end) { int am, pm; string amlname = "", pmlname = "", amphone = "", pmphone = "", amshift = "", pmshift = ""; int.TryParse(dr["empid_am"].ToString(), out am); int.TryParse(dr["empid_pm"].ToString(), out pm); foreach (DataRow dt in bus449_TestDataSet.Employee.Rows) { int check = int.Parse(dt["ID"].ToString()); if (am == check) { amlname = dt["L_Name"].ToString(); amphone = dt["phone"].ToString(); amshift = dt["shift"].ToString(); } } foreach (DataRow dz in bus449_TestDataSet.Employee.Rows) { int check2 = int.Parse(dz["ID"].ToString()); if (pm == check2) { pmlname = dz["L_Name"].ToString(); pmphone = dz["phone"].ToString(); pmshift = dz["shift"].ToString(); } } //Create a listview to show all products and purchase amounts string[] fieldsArrayAM = new string[4]; fieldsArrayAM[0] = date.ToString("MM/dd/yyyy"); fieldsArrayAM[1] = amlname; fieldsArrayAM[2] = amphone; fieldsArrayAM[3] = amshift; ListViewItem showsLVI = new ListViewItem(fieldsArrayAM); datesListView.Items.Add(showsLVI); string[] fieldsArrayPM = new string[4]; fieldsArrayPM[0] = date.ToString("MM/dd/yyyy"); fieldsArrayPM[1] = pmlname; fieldsArrayPM[2] = pmphone; fieldsArrayPM[3] = pmshift; ListViewItem showsLVI2 = new ListViewItem(fieldsArrayPM); datesListView.Items.Add(showsLVI2); //string addam = date.ToString("MM/dd/yyyy") + " " + amlname + " " + amphone + " " + amshift; //string addpm = date.ToString("MM/dd/yyyy") + " " + pmlname + " " + pmphone + " " + pmshift; } } }