public void Delete(PropertyInterface myProperty, int SelektovaniRed, Bunifu.Framework.UI.BunifuCustomDataGrid dgv) { try { DataGridViewRow row = dgv.SelectedRows[0]; var properties = myProperty.GetType().GetProperties(); foreach (PropertyInfo item in properties) { if (item.GetCustomAttribute <PrimaryKeyAttribute>() != null) { string value = row.Cells[item.GetCustomAttribute <SqlNameAttribute>().Name] .Value.ToString(); item.SetValue(myProperty, Convert.ChangeType(value, item.PropertyType)); } } SqlHelper.ExecuteNonQuery(SqlHelper.GetConnectionString(), CommandType.Text, myProperty.GetDeleteQuery(), myProperty.GetDeleteParameters().ToArray()); CRUD.IstorijaCRUD.Istorija(UserEmail, StateEnum.Delete, myProperty); //PopulateGrid(myProperty); } catch (System.Data.SqlClient.SqlException) { MessageBox.Show("\n\nNemoguce je obrisati ovaj red zbog povezanosti sa drugim tabelama!!!\n\n", "Greska pri brisanju!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void load_toSettingGrade() { MysqlClass db = new MysqlClass(); DataTable tb = db.GetData("SELECT cou.keterangan FROM(SELECT keterangan FROM tb_grade group by keterangan) as cou"); //MessageBox.Show(tb.Rows.Count.ToString()); foreach (DataRow row in tb.Rows) { TabPage tp = new TabPage(row["keterangan"].ToString()); Bunifu.Framework.UI.BunifuCustomDataGrid dgv = new Bunifu.Framework.UI.BunifuCustomDataGrid(); dgv.Dock = DockStyle.Fill; dgv.Columns.Add("no", "No"); dgv.Columns.Add("grade", "Grade"); dgv.Columns.Add("biaya", "Biaya"); dgv.RowHeadersVisible = false; dgv.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(67, 20, 109); dgv.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dgv.Dock = DockStyle.Fill; dgv.Location = new Point(20, 10); tp.Controls.Add(dgv); // settingGrade1.tabControl1.TabPages.Add(tp); } }
private string valorCelda(Bunifu.Framework.UI.BunifuCustomDataGrid grid, string column) { string celda = ""; try { celda = grid.CurrentRow.Cells[column].Value.ToString(); } catch (Exception e) { MessageBox.Show(e.Message); } return(celda); }
public void Update(PropertyInterface myProperty, string ID, Bunifu.Framework.UI.BunifuCustomDataGrid dgv) { //Pretraga SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text, myProperty.GetSelectQueryZaJedanItem(ID)); DataTable dt = new DataTable(); dt.Load(reader); reader.Close(); dgv.DataSource = dt; var type = myProperty.GetType(); var properties = type.GetProperties(); PropertyInterface pom = myProperty; int i = 0; try { foreach (DataGridViewCell cell in dgv.Rows[0].Cells) { String value = cell.Value.ToString(); PropertyInfo property = properties.Where(x => dgv.Columns[i].HeaderText == x.GetCustomAttribute <DisplayNameAttribute>().DisplayName).FirstOrDefault(); property.SetValue(myProperty, Convert.ChangeType(value, property.PropertyType)); i++; } } catch { } InputForma inputForma = null; if (DetaljiUpdate != "detalji") { inputForma = new InputForma(myProperty, StateEnum.Update, UserEmail, UserID); } else { inputForma = new InputForma("detalji", myProperty, StateEnum.Update, UserEmail, UserID); } inputForma.ShowDialog(); if (inputForma.DialogResult == DialogResult.Cancel) { return; } }
private void cargarGrid(Bunifu.Framework.UI.BunifuCustomDataGrid grid, string consulta, string[] encabezados, int p1) { try { SqlDataAdapter adapter = new SqlDataAdapter(consulta, conex); adapter.SelectCommand.Parameters.Add("@p1", SqlDbType.Int).Value = p1; DataSet data = new DataSet(); adapter.Fill(data, "DATA"); grid.DataSource = data.Tables["DATA"]; estiloGrid(grid, encabezados); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void estiloGrid(Bunifu.Framework.UI.BunifuCustomDataGrid grid, string[] encabezados) { // Cargar los encabezados y centrarlos for (int i = 0; i < grid.Columns.Count; i++) { grid.Columns[i].HeaderText = encabezados[i]; grid.Columns[i].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; grid.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } // Color de encabezados y color de letra grid.HeaderBgColor = Color.Black; grid.HeaderForeColor = Color.White; // Fuente grid.ColumnHeadersDefaultCellStyle.Font = new Font("Century Gothic", 8, FontStyle.Regular); // Quitar la ultima fila por defecto grid.AllowUserToAddRows = false; // Quitar el estilo de rejilla de las celdas del gridView grid.CellBorderStyle = DataGridViewCellBorderStyle.None; // Quitar la columna a la izquierda por defecto grid.RowHeadersVisible = false; if (grid.Rows.Count > 0) { // Estilos celdas dentro del gidView grid.SelectionMode = DataGridViewSelectionMode.FullRowSelect; grid.MultiSelect = false; grid.ReadOnly = true; grid.AllowUserToResizeRows = false; // Seleccionar por defecto la primera fila del gridView grid.Rows[0].Selected = true; } }