private void savedatabase() { int dem = -1; DataClasses1DataContext db = new DataClasses1DataContext(); Table <TBL_SANPHAM> tbsanp = db.GetTable <TBL_SANPHAM>(); foreach (TBL_SANPHAM r in tbsanp) { if (r.MASANPHAM != null) { dem += 1; } } TBL_SANPHAM a = new TBL_SANPHAM(); for (int j = dem + 1; j < dataGridViewnhapkho.Rows.Count - 1; j++) { ModuleDB.cnn = new SqlConnection(ModuleDB.cnnstr); SqlCommand cm = new SqlCommand("SELECT dbo.fu_createMANK()", ModuleDB.cnn); ModuleDB.cnn.Open(); a.MASANPHAM = cm.ExecuteScalar().ToString(); nhapkho.EndCurrentEdit(); a.TENSANPHAM = dataGridViewnhapkho.Rows[j].Cells[1].Value.ToString(); a.LOAISANPHAM = dataGridViewnhapkho.Rows[j].Cells[2].Value.ToString(); a.SOLUONG = (int)dataGridViewnhapkho.Rows[j].Cells[3].Value; a.GIA = (double)dataGridViewnhapkho.Rows[j].Cells[4].Value; a.THOIGIAN = dateTimePicker1.Value; db.TBL_SANPHAMs.InsertOnSubmit(a); db.SubmitChanges(); ModuleDB.cnn.Close(); } MessageBox.Show("Thêm vào kho thành công"); }
private void dataGridViewnhapkho_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex <= 6 && e.RowIndex >= 0) { if (e.ColumnIndex == 5) { nhapkho.Position = e.RowIndex; DataClasses1DataContext db = new DataClasses1DataContext(); TBL_SANPHAM a = new TBL_SANPHAM(); a = (TBL_SANPHAM)nhapkho.Current; TBL_SANPHAM b = new TBL_SANPHAM(); b = db.TBL_SANPHAMs.Single(p => p.MASANPHAM.Equals(a.MASANPHAM)); db.TBL_SANPHAMs.DeleteOnSubmit(b); db.SubmitChanges(); MessageBox.Show("Xóa thành công"); loaddatagrid(); } } nhapkho.Position = 0; }
partial void DeleteTBL_SANPHAM(TBL_SANPHAM instance);
partial void UpdateTBL_SANPHAM(TBL_SANPHAM instance);
partial void InsertTBL_SANPHAM(TBL_SANPHAM instance);