private void uxDataGrid_SelectionChanged(object sender, EventArgs e)
{
DataGridViewRow row = uxDataGrid.SelectedRows.Count == 0 ? null : uxDataGrid.SelectedRows[0];
if (row != null && row.Cells != null && row.Cells[0].Value != null)
{
uxMake.Text = row.Cells[1].Value.ToString();
uxModel.Text = row.Cells[2].Value.ToString();
uxYear.Text = row.Cells[3].Value.ToString();
uxAskPrice.Text = row.Cells[4].Value.ToString();
uxColor.Text = row.Cells[5].Value.ToString();
uxMilage.Text = row.Cells[6].Value.ToString();
uxOwnerCount.Text = row.Cells[8].Value.ToString();
Group14Connection g14 = new Group14Connection();
int dealershipId;
bool success = Int32.TryParse(row.Cells[7].Value.ToString(), out dealershipId);
if (!success)
{
dealershipId = -1;
}
carLocationId = dealershipId;
string dealershipName = "";
var dealershipData = g14.GetDealershipInformation(dealershipId);
if (dealershipData != null)
{
dealershipName = dealershipData.Tables[0].Rows[0].ItemArray[1].ToString();
}
label15.Text = "Location: " + dealershipName;
}
updatePurchaseAvailability();
}
private void uxEmployeeEmailTxtBox_TextChanged(object sender, EventArgs e)
{
string employeeEmail = uxEmployeeEmailTxtBox.Text;
int dealershipId;
Group14Connection g14 = new Group14Connection();
var employeeData = g14.GetEmployeeFromEmail(employeeEmail);
if (employeeData == null)
{
dealershipId = -1;
}
else
{
bool success = Int32.TryParse(employeeData.Tables[0].Rows[0].ItemArray[2].ToString(), out dealershipId);
if (!success)
{
dealershipId = -1;
}
}
employeeLocationId = dealershipId;
string dealershipName = "";
var dealershipData = g14.GetDealershipInformation(dealershipId);
if (dealershipData != null)
{
dealershipName = dealershipData.Tables[0].Rows[0].ItemArray[1].ToString();
}
uxEmployeeLocationLbl.Text = "Employee Location: " + dealershipName;
updatePurchaseAvailability();
}
public EmployeePerformance(Home ret)
{
returnScreen = ret;
InitializeComponent();
conn = new Group14Connection();
uxTimeLine.SelectedIndex = 0;
}
public MakePurchase(Form ret, int cID)
{
returnScreen = ret;
carID = cID;
conn = new Group14Connection();
InitializeComponent();
}
private void displayData(int dealershipId, DateTimeOffset start, DateTimeOffset end)
{
dataGridView1.Rows.Clear();
Group14Connection g14 = new Group14Connection();
DataSet data = new DataSet();
if (comboBox1.SelectedIndex == 0)
{
data = g14.DealershipPerformance2(dealershipId, start, end);
if (data != null)
{
foreach (DataRow r in data.Tables[0].Rows)
{
string[] arr = new string[5];
arr[0] = r.ItemArray[0].ToString();
arr[1] = r.ItemArray[1].ToString();
arr[2] = string.Format("{0:c}", Convert.ToInt32(r.ItemArray[2].ToString()));
arr[3] = r.ItemArray[3].ToString();
arr[4] = string.Format("{0:c}", Convert.ToInt32(r.ItemArray[4].ToString()));
dataGridView1.Rows.Add(arr);
}
}
else
{
MessageBox.Show("There was an error proccessing your request.");
return;
}
}
else if (comboBox1.SelectedIndex == 1)
{
data = g14.DealershipPerformance(dealershipId, start, end);
if (data != null)
{
foreach (DataRow r in data.Tables[0].Rows)
{
string[] arr = new string[5];
arr[0] = r.ItemArray[0].ToString();
arr[1] = "NA";
arr[2] = string.Format("{0:c}", Convert.ToInt32(r.ItemArray[1].ToString()));
arr[3] = r.ItemArray[2].ToString();
arr[4] = string.Format("{0:c}", Convert.ToInt32(r.ItemArray[3].ToString()));
dataGridView1.Rows.Add(arr);
}
}
else
{
MessageBox.Show("There was an error proccessing your request.");
return;
}
}
else
{
MessageBox.Show("There was an error proccessing your request.");
return;
}
}
public FeatureSearchForm(Home ret)
{
carLocationId = -1;
employeeLocationId = -1;
InitializeComponent();
updatePurchaseAvailability();
homePage = ret;
conn = new Group14Connection();
List <Tuple <string, int> > features = GetFeatures();
AddFeatures(features);
GetCarsWithFeatures(null, null);
}
private void runQuery(int numCustomers, int dealershipId)
{
Group14Connection conn = new Group14Connection();
DataSet data = conn.GetTopCustomers(dealershipId, numCustomers);
if (data != null)
{
DataTable table = data.Tables[0];
displayResults(table);
}
else
{
MessageBox.Show("There was an error proccessing your request");
}
}
private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
label7.Text = "Make: " + dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
label8.Text = "Model: " + dataGridView1.SelectedRows[0].Cells[4].Value.ToString();
label9.Text = "Color: " + dataGridView1.SelectedRows[0].Cells[5].Value.ToString();
label10.Text = "Year: " + dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
label11.Text = "Milage: " + dataGridView1.SelectedRows[0].Cells[6].Value.ToString();
label12.Text = "Owner Count: " + dataGridView1.SelectedRows[0].Cells[7].Value.ToString();
label13.Text = "Ask Price: " + dataGridView1.SelectedRows[0].Cells[8].Value.ToString();
Group14Connection g14 = new Group14Connection();
int carId = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value);
var carData = g14.GetCarFeatures(carId);
string features = "";
if (carData != null && carData.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < carData.Tables[0].Rows.Count; i++)
{
features += carData.Tables[0].Rows[i].ItemArray[0] + "\n";
}
}
else
{
features = "NA";
}
label14.Text = "Features: " + features;
int dealershipId;
bool success = Int32.TryParse(dataGridView1.SelectedRows[0].Cells[1].Value.ToString(), out dealershipId);
if (!success)
{
dealershipId = -1;
}
carLocationId = dealershipId;
var dealershipData = g14.GetDealershipInformation(dealershipId);
string dealershipName = dealershipData.Tables[0].Rows[0].ItemArray[1].ToString();
label15.Text = "Location: " + dealershipName;
updatePurchaseAvailability();
}
}
private void displayData(int top, int deal)
{
dataGridView1.Rows.Clear();
Group14Connection g14 = new Group14Connection();
var data = g14.GetTopEmployees(top, deal);
if (data == null)
{
MessageBox.Show("There was an error proccessing your request.");
return;
}
var table = data.Tables[0];
for (int i = 0; i < table.Rows.Count; i++)
{
object[] currentRow = table.Rows[i].ItemArray;
List <string> listToUse = new List <string>();
foreach (object o in currentRow)
{
listToUse.Add(o.ToString());
}
dataGridView1.Rows.Add(listToUse.ToArray());
}
}
private void displayResults(string make, string model, string year, string color, string milage, string oc, string ap)
{
int num;
Nullable <int> milage2 = null;
Nullable <int> oc2 = null;
Nullable <int> ap2 = null;
Nullable <int> year2 = null;
if (Int32.TryParse(milage, out num))
{
milage2 = Convert.ToInt32(milage);
}
if (Int32.TryParse(oc, out num))
{
oc2 = Convert.ToInt32(oc);
}
if (Int32.TryParse(ap, out num))
{
ap2 = Convert.ToInt32(ap);
}
if (Int32.TryParse(year, out num))
{
year2 = Convert.ToInt32(year);
}
Group14Connection g14 = new Group14Connection();
var data = g14.CarSearch(make, model, color, milage2, oc2, ap2, year2);
if (data == null)
{
MessageBox.Show("There was an error proccessing your request.");
return;
}
var table = data.Tables[0];
if (table.Rows.Count > 0)
{
if (dataGridView1.Columns.Count > 0)
{
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
}
for (int j = 0; j < table.Rows[0].ItemArray.Length; j++)
{
dataGridView1.Columns.Add(table.Columns[j].ColumnName, table.Columns[j].ColumnName);
if (j != 2 && j != 3 && j != 4)
{
dataGridView1.Columns[j].Visible = false;
}
}
for (int i = 0; i < table.Rows.Count; i++)
{
List <string> rowData = new List <string>();
var row = table.Rows[i];
for (int j = 0; j < table.Rows[0].ItemArray.Length; j++)
{
rowData.Add(row[j].ToString());
}
string[] arr = rowData.ToArray();
string hold = arr[0];
dataGridView1.Rows.Add(arr);
}
}
else
{
MessageBox.Show("There was an error proccessing your request.");
}
}
public ListEmployeesForm(Home ret)
{
conn = new Group14Connection();
homePage = ret;
InitializeComponent();
}
public GetCustomerInformation(Home ret)
{
homePage = ret;
InitializeComponent();
conn = new Group14Connection();
}
