private void BtnRemoveLineItem_Click(object sender, RoutedEventArgs e)
{
if (dgLineItemList.SelectedIndex != -1)
{
RepairLineItem lineItem = _lineItems[dgLineItemList.SelectedIndex];
_lineItems.Remove(lineItem);
dgLineItemList.ItemsSource = new List <RepairLineItem>();
dgLineItemList.ItemsSource = _lineItems;
dgLineItemList.Columns.RemoveAt(0);
dgLineItemList.Columns.RemoveAt(1);
}
}
private void BtnAddLineItem_Click(object sender, RoutedEventArgs e)
{
NewRepairLineItem lineItemWindow = new NewRepairLineItem();
lineItemWindow.ShowDialog();
if (lineItemWindow.saved)
{
RepairLineItem lineItem = lineItemWindow.lineItem;
_lineItems.Add(lineItem);
dgLineItemList.ItemsSource = new List <RepairLineItem>();
dgLineItemList.ItemsSource = _lineItems;
dgLineItemList.Columns.RemoveAt(0);
dgLineItemList.Columns.RemoveAt(1);
}
}
public List<RepairLineItem> GetRepairLineItems(int repairID)
{
//Declare variables
List<RepairLineItem> lineItems = new List<RepairLineItem>();
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_get_repair_line_items");
//Setup cmd object
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
//Add parameter
cmd.Parameters.Add("@RepairID", SqlDbType.Int);
cmd.Parameters["@RepairID"].Value = repairID;
//Try to execute the query
try
{
conn.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
int repairLineItemID = reader.GetInt32(1);
string serialNumber = reader.GetString(2);
Decimal amount = reader.GetDecimal(3);
string partType = reader.GetString(4);
RepairLineItem lineItem = new RepairLineItem(repairID, repairLineItemID,
serialNumber, amount, partType);
lineItems.Add(lineItem);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return lineItems;
}
private void BtnAdd_Click(object sender, RoutedEventArgs e)
{
Decimal amount;
string serialNumber;
string type;
try
{
amount = Convert.ToDecimal(txtAmount.Text);
if (txtSerialNumber.Text == "")
{
MessageBox.Show("Serial Number field cannot be blank");
}
else
{
serialNumber = txtSerialNumber.Text;
type = cboPartType.SelectedItem.ToString();
if (_partsManager.isPartAvailable(serialNumber, type))
{
lineItem = new RepairLineItem(0, 0, serialNumber, amount, type);
saved = true;
this.Close();
}
else
{
MessageBox.Show("Part not found");
}
}
}
catch (FormatException ex)
{
MessageBox.Show("Amount field in incorrect format");
}
}
