private void btn_xoa_Click(object sender, EventArgs e) { NHANVIEN nv = MyDb.GetInstance().NHANVIENs.Where(p => p.MaNV == txt_MaNV.Text.Trim()).SingleOrDefault(); User user = MyDb.GetInstance().Users.Where(p => p.MaNV == nv.MaNV).SingleOrDefault(); MyDb.GetInstance().Users.Remove(user); nhanvienBLL.Delete(nv); Shownhanvien(nhanvienBLL.GetAll()); }
void LoadData() { var result = MyDb.GetInstance().HOCBONGs.Select(a => new { a.Mahb, a.Tenhb, a.Sotien }); dtgvHB.DataSource = result.ToList(); dtgvHB.Columns[0].HeaderText = "Mã HB"; dtgvHB.Columns[1].HeaderText = "Tên HB"; dtgvHB.Columns[2].HeaderText = "Số tiền"; }
public void saveConnectionstring(string yourInitialCatalog, string yourDataSource, string userName, string passWord) { DEMOQLKTXEntities selectedDb = MyDb.GetInstance(); selectedDb.ChangeDatabase(initialCatalog: yourInitialCatalog.Trim(), dataSource: yourDataSource.Trim(), userName, passWord); User firstUser = selectedDb.Users.FirstOrDefault(); if (firstUser == null) { MessageBox.Show("Error"); } // WriteAllText creates a file, writes the specified string to the file, // and then closes the file. You do NOT need to call Flush() or Close(). System.IO.File.WriteAllText("ConnectString.txt", selectedDb.Database.Connection.ConnectionString); }
private void dtgvData1_CellClick(object sender, DataGridViewCellEventArgs e) { var DataJoin = from sv in MyDb.GetInstance().SINHVIENs where sv.Mahb == txbID.Text select new { sv.Mahb, sv.Masv, sv.Hoten, sv.Gioitinh, sv.Sdt }; dtgvSV.DataSource = DataJoin.ToList(); dtgvSV.Columns[0].HeaderText = "Mã HB"; dtgvSV.Columns[1].HeaderText = "Mã số SV"; dtgvSV.Columns[2].HeaderText = "Họ Tên"; dtgvSV.Columns[3].HeaderText = "Giới Tính"; dtgvSV.Columns[4].HeaderText = "SĐT"; }
int count = 0;//Dùng để trờ về trang ds phòng sau khi xem ds sv mỗi phòng #region Method void LoadPhong() { List <PHONG> dsp = PhongBLL.GetAll(); foreach (PHONG item in ktx.PHONGs) { var dssv = MyDb.GetInstance().HOPDONGs.Where(x => x.Sophong == item.Sophong).Count(); Button button1 = new Button(); // // button1 // button1.BackColor = System.Drawing.Color.DarkRed; button1.ForeColor = System.Drawing.Color.Coral; button1.Location = new System.Drawing.Point(463, 10); button1.Name = "button1"; button1.Size = new System.Drawing.Size(75, 23); button1.TabIndex = 40; button1.Text = "button1"; button1.UseVisualStyleBackColor = false; IconButton iBtnPhong = new IconButton(); if (item.LoaiPhong == "Nam") { #region Phòng Nam //Design button bằng code iBtnPhong.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(6)))), ((int)(((byte)(137)))), ((int)(((byte)(255))))); iBtnPhong.FlatAppearance.BorderSize = 0; iBtnPhong.FlatStyle = System.Windows.Forms.FlatStyle.Flat; iBtnPhong.Flip = FontAwesome.Sharp.FlipOrientation.Normal; iBtnPhong.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); iBtnPhong.ForeColor = System.Drawing.Color.White; iBtnPhong.IconChar = FontAwesome.Sharp.IconChar.Male; iBtnPhong.IconColor = System.Drawing.Color.White; iBtnPhong.IconSize = 40; iBtnPhong.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft; iBtnPhong.Location = new System.Drawing.Point(403, 245); iBtnPhong.Name = "iconButton1"; iBtnPhong.Rotation = 0D; iBtnPhong.Size = new System.Drawing.Size(123, 70); iBtnPhong.TabIndex = 15; iBtnPhong.Text = item.Sophong + "\r\n" + dssv.ToString() + "/" + item.Sluongsv.ToString() + " SV\r\n"; iBtnPhong.TextAlign = System.Drawing.ContentAlignment.MiddleRight; iBtnPhong.UseVisualStyleBackColor = false; #endregion } else { #region Phòng Nữ iBtnPhong.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(77)))), ((int)(((byte)(214))))); iBtnPhong.FlatAppearance.BorderSize = 0; iBtnPhong.FlatStyle = System.Windows.Forms.FlatStyle.Flat; iBtnPhong.Flip = FontAwesome.Sharp.FlipOrientation.Normal; iBtnPhong.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); iBtnPhong.ForeColor = System.Drawing.Color.White; iBtnPhong.IconChar = FontAwesome.Sharp.IconChar.Female; iBtnPhong.IconColor = System.Drawing.Color.White; iBtnPhong.IconSize = 40; iBtnPhong.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft; iBtnPhong.Location = new System.Drawing.Point(403, 245); iBtnPhong.Name = "iconButton1"; iBtnPhong.Rotation = 0D; iBtnPhong.Size = new System.Drawing.Size(123, 70); iBtnPhong.TabIndex = 15; iBtnPhong.Text = item.Sophong + "\r\n" + dssv.ToString() + "/" + item.Sluongsv.ToString() + " SV\r\n"; iBtnPhong.TextAlign = System.Drawing.ContentAlignment.MiddleRight; iBtnPhong.UseVisualStyleBackColor = false; #endregion } iBtnPhong.Click += IBtnPhong_Click; //Design button phòng --> gắn event button1.Click += Button1_Click; button1.Tag = item; // iBtnPhong.Tag = item; PanelPhong.Controls.Add(iBtnPhong); } }
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { var result = MyDb.GetInstance().SINHVIENs.Select(x => new { x.MaDTUT, x.Hoten, x.Masv, x.Cmnd, x.Ngaysinh }); dGVdsSinhVien.DataSource = result.ToList(); }