private void btnSave_Click (object sender, EventArgs e)
{
ContractDetail cd = (ContractDetail) lbItems.SelectedItem;
using (dbOptionsDataContext dc = new dbOptionsDataContext ())
{
var query = (from s1 in dc.Stocks
where s1.Ticker == cd.LocalSymbol
select s1).SingleOrDefault ();
if (query != null)
{
query.Company = cd.LongName;
query.Exchange = cd.Exchange;
try
{
dc.SubmitChanges ();
}
catch (Exception ex)
{
MessageBox.Show (string.Format ("Failed to update existing record {0}. {1}", cd.ToString (), ex.Message));
}
return;
}
Stock s = new Stock ();
s.Ticker = cd.Ticker;
s.Company = cd.LongName;
s.Exchange = cd.Exchange;
s.SecType = (string) lbSecType.SelectedValue;
s.FutureExpiry = cd.Expiry;
dc.Stocks.InsertOnSubmit (s);
try
{
dc.SubmitChanges ();
}
catch (Exception ex)
{
MessageBox.Show (string.Format ("Failed to insert new record {0}. {1}", cd.ToString (), ex.Message));
}
return;
}
}
partial void UpdateStock(Stock instance);
partial void DeleteStock(Stock instance);
partial void InsertStock(Stock instance);