private void Load_Click(object sender, RoutedEventArgs e) { UISolution.DataSource.HanSungLinqDataContext lContext = new DataSource.HanSungLinqDataContext(); DataSource.Security lSecurity = lContext.Securities.SingleOrDefault(p => p.Id == 1); byte[] arrayBinary = lSecurity.Image.ToArray(); System.Drawing.Image rImage = null; MemoryStream ms = new MemoryStream(arrayBinary); rImage = System.Drawing.Image.FromStream(ms); string lpassword = Decrypt(lSecurity.Password); // imgTEST.Source = rImage; }
private void RadGridView1_Deleted(object sender, Telerik.Windows.Controls.GridViewDeletedEventArgs e) { UISolution.DataSource.HanSungLinqDataContext lDataContext = new DataSource.HanSungLinqDataContext(); foreach (HSPriceHistory l in e.Items) { DataSource.PriceHistory ldeletedItem = lDataContext.PriceHistories.SingleOrDefault(p => p.Id == l.Id); try { lDataContext.PriceHistories.DeleteOnSubmit(ldeletedItem); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void gridSalesItem_Deleted(object sender, Telerik.Windows.Controls.GridViewDeletedEventArgs e) { UISolution.DataSource.HanSungLinqDataContext lDataContext = new DataSource.HanSungLinqDataContext(); foreach (HSOrderItem l in e.Items) { DataSource.OrderItem ldeletedItem = lDataContext.OrderItems.SingleOrDefault(p => p.Id == l.Id); try { lDataContext.OrderItems.DeleteOnSubmit(ldeletedItem); lDataContext.SubmitChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }