/// <summary author="Kevin Broskow" created="2019/04/03">
/// Returns a specific Receiving Ticket
/// </summary>
public ReceivingTicket retrieveReceivingTicketByID(int id)
{
ReceivingTicket ticket = new ReceivingTicket();
try
{
ticket = _accessor.selectReceivingTicketByID(id);
}
catch (Exception ex)
{
ExceptionLogManager.getInstance().LogException(ex);
throw ex;
}
return(ticket);
}
public ReceivingTicket selectReceivingTicketByID(int id)
{
ReceivingTicket _ticket = new ReceivingTicket();
foreach (var ticket in _tickets)
{
if (ticket.ReceivingTicketID == id)
{
_ticket = ticket;
}
else
{
throw new ArgumentException();
}
}
return(_ticket);
}
/// <summary>
/// Author: Kevin Broskow
/// Created : 3/25/2019
/// Real constructor for the window being opened
///
/// </summary>
public OrderRecieving(ReceivingTicket ticket)
{
originalTicket = ticket;
try
{
supplierOrderLine = _supplierManager.RetrieveAllSupplierOrderLinesBySupplierOrderID(ticket.SupplierOrderID);
order = _supplierManager.RetrieveSupplierOrderByID(ticket.SupplierOrderID);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
InitializeComponent();
this.lblRecieving.Content += ticket.SupplierOrderID.ToString();
this.btnSubmit.Content = "Save";
dgOrderRecieving.ItemsSource = supplierOrderLine;
}
private void Complete_Click(object sender, RoutedEventArgs e)
{
try
{
if (dgReceiving.SelectedIndex < 0)
{
MessageBox.Show("You must have a ticket selected");
}
else
{
ReceivingTicket ticket = (ReceivingTicket)dgReceiving.SelectedItem;
_supplierManager.CompleteSupplierOrder(ticket.SupplierOrderID);
_receivingManager.deactivateReceivingTicket(ticket.ReceivingTicketID);
}
}
catch (Exception ex)
{
MessageBox.Show("ERROR:" + ex.Message);
}
}
public void updateReceivingTicket(ReceivingTicket original, ReceivingTicket updated)
{
if (updated.IsValid())
{
foreach (var ticket in _tickets)
{
if (ticket.ReceivingTicketID == original.ReceivingTicketID)
{
ticket.ReceivingTicketCreationDate = updated.ReceivingTicketCreationDate;
ticket.ReceivingTicketExceptions = updated.ReceivingTicketExceptions;
ticket.Active = updated.Active;
ticket.SupplierOrderID = updated.SupplierOrderID;
}
}
}
else
{
throw new ArgumentException();
}
}
/// <summary>
/// Author Kevin Broskow
/// Created 4/5/201
/// <paramref name="original"/>
/// <paramref name="updated"/>
///
/// Updates a specific receiving ticket.
/// </summary>
public void updateReceivingTicket(ReceivingTicket original, ReceivingTicket updated)
{
var cmdText = @"sp_update_receiving";
var conn = DBConnection.GetDbConnection();
var cmd = new SqlCommand(cmdText, conn);
cmd.Parameters.AddWithValue("@ReceivingID", original.ReceivingTicketID);
cmd.Parameters.AddWithValue("@Description", updated.ReceivingTicketExceptions);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
