private void button1_Click(object sender, EventArgs e) { ModelDataInterfaceDataContext db = new ModelDataInterfaceDataContext(Connection.GetStringConnection()); var opennings = (from pos in db.POSITIONs where pos.ID == _id select pos).First(); OpenFileDialog fop = new OpenFileDialog(); fop.InitialDirectory = @"D:\project\NhatKyGiaoDich\"; fop.Filter = "[png]|*.png"; if (fop.ShowDialog() == DialogResult.OK) { FileStream FS = new FileStream(@fop.FileName, FileMode.Open, FileAccess.Read); byte[] img = new byte[FS.Length]; FS.Read(img, 0, Convert.ToInt32(FS.Length)); opennings.ImageBinaryClose = img; } opennings.IdStatus = 2; opennings.NoteClosed = rtbNoteClose.Text; opennings.IdResult = cbbTypeclose.SelectedIndex + 1; db.SubmitChanges(); ///note // System.Windows.Forms.Form f = System.Windows.Forms.Application.OpenForms["Form1"]; ((Form1)f).ResetDataGridview(); ((Form1)f).LoadOpenningPosition(); ((Form1)f).LoadClosedPositions(); // ((Form1)f).idresult = cbbTypeclose.SelectedIndex + 1; this.Close(); }
public void LoadClosedPositions() { ModelDataInterfaceDataContext db = new ModelDataInterfaceDataContext(Connection.GetStringConnection()); var opennings = from pos in db.POSITIONs join sta in db.STATUSSes on pos.IdStatus equals sta.ID join cucucuc in db.PAIRs on pos.IdPair equals cucucuc.ID where sta.StatusName == "Closed" select new { pos.ID, cucucuc.PairName, pos.DateOpen }; dtgClosedPosition.DataSource = opennings; dtgClosedPosition.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dtgClosedPosition.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dtgClosedPosition.AllowUserToResizeRows = false; DataGridViewButtonColumn btnsee = new DataGridViewButtonColumn(); btnsee.HeaderText = "Information"; btnsee.Text = "See"; btnsee.Name = "btn"; dtgClosedPosition.Columns.Add(btnsee); btnsee.UseColumnTextForButtonValue = true; }
private void LoadDataCombobox() { //combbox PAIR ModelDataInterfaceDataContext db = new ModelDataInterfaceDataContext(Connection.GetStringConnection()); var pairsss = from table in db.RESULTs select table.NameResult; cbbTypeclose.DataSource = pairsss; }
private void button1_Click(object sender, EventArgs e) { ModelDataInterfaceDataContext db = new ModelDataInterfaceDataContext(Connection.GetStringConnection()); PAIR ob = new PAIR(); ob.PairName = textBox1.Text; db.PAIRs.InsertOnSubmit(ob); db.SubmitChanges(); this.Close(); }
// public string connection = @"Data Source=SA2WKS0265\SQLEXPRESS;Initial Catalog=TheWay;Integrated Security=True"; public void LoadDataCombobox() { //combbox PAIR ModelDataInterfaceDataContext db = new ModelDataInterfaceDataContext(Connection.GetStringConnection()); var pairsss = from table in db.PAIRs select table.PairName; cmbPair.DataSource = pairsss; //combobox Status var statuss = from table in db.STATUSSes select table.StatusName; cmbstatus.DataSource = statuss; }
public void LoadImage() { try { //load openposition ModelDataInterfaceDataContext db = new ModelDataInterfaceDataContext(Connection.GetStringConnection()); var imageBinary = from table in db.POSITIONs where table.ID == _id select table.ImageBinary; //byte[] y = imageBinary.First().ToArray(); MemoryStream ms = new MemoryStream(imageBinary.First().ToArray()); pbopen.Image = Image.FromStream(ms); pbopen.SizeMode = PictureBoxSizeMode.StretchImage; pbopen.Refresh(); // if (_showclosed) { var noteOpen = from table in db.POSITIONs where table.ID == _id select table.NoteOpen; rtbopen.Text = noteOpen.First().ToString(); } ////////////////// var imageBinaryclosed = from table in db.POSITIONs where table.ID == _id select table.ImageBinaryClose; //byte[] y = imageBinary.First().ToArray(); MemoryStream mss = new MemoryStream(imageBinaryclosed.First().ToArray()); pbclosed.Image = Image.FromStream(mss); pbclosed.SizeMode = PictureBoxSizeMode.StretchImage; pbclosed.Refresh(); { var noteOpen = from table in db.POSITIONs where table.ID == _id select table.NoteClosed; rtbclosed.Text = noteOpen.First().ToString(); } } catch (Exception eff) { MessageBox.Show(eff.ToString()); } }
private void button2_Click(object sender, EventArgs e) { try { ModelDataInterfaceDataContext db = new ModelDataInterfaceDataContext(Connection.GetStringConnection()); POSITION openFrm = new POSITION(); openFrm.IdPair = cmbPair.SelectedIndex + 1; openFrm.IdStatus = cmbstatus.SelectedIndex + 1; openFrm.Entryprice = float.Parse(txtEntry.Text); openFrm.Stoploss = float.Parse(txtSL.Text); openFrm.TakeProfit = float.Parse(txtTP.Text); openFrm.DateOpen = dtpDateOpen.Value; openFrm.NoteOpen = rtbNoteOpen.Text; openFrm.NoteClosed = ""; openFrm.IdResult = 3; OpenFileDialog fop = new OpenFileDialog(); fop.InitialDirectory = @"D:\project\NhatKyGiaoDich\"; fop.Filter = "[png]|*.png"; if (fop.ShowDialog() == DialogResult.OK) { FileStream FS = new FileStream(@fop.FileName, FileMode.Open, FileAccess.Read); byte[] img = new byte[FS.Length]; FS.Read(img, 0, Convert.ToInt32(FS.Length)); openFrm.ImageBinary = img; openFrm.ImageBinaryClose = img; } db.POSITIONs.InsertOnSubmit(openFrm); db.SubmitChanges(); MessageBox.Show("Saved!!!"); System.Windows.Forms.Form f = System.Windows.Forms.Application.OpenForms["Form1"]; ((Form1)f).ResetDataGridview(); ((Form1)f).LoadOpenningPosition(); ((Form1)f).LoadClosedPositions(); this.Close(); } catch (Exception ef) { MessageBox.Show(ef.ToString()); } }