/// <summary> /// Handles invocation of RowMouseLeave events /// </summary> internal void DoRowMouseLeaveEvent(GridRow gridRow) { if (RowMouseLeave != null) { GridRowEventArgs ev = new GridRowEventArgs(gridRow.GridPanel, gridRow); RowMouseLeave(this, ev); } }
public frmGridViews() { InitializeComponent(); Icon = Properties.Resources.logo; DataSet ds = Program.DB.SelectAll("SELECT ID,Name,IsZone FROM Rooms;"); Dictionary<int, string> zones = new Dictionary<int, string>(); if (ds.Tables.Count > 0) { TreeNode tnRoot = new TreeNode(); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["IsZone"] != DBNull.Value && dr["IsZone"].Equals("Y")) { zones.Add(Convert.ToInt32(dr["ID"]), dr["Name"].ToString()); } } foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["IsZone"] != DBNull.Value && dr["IsZone"].Equals("Y")) { tv.Nodes.Add(dr["Name"].ToString().Replace("|", " - ")); tnRoot = tv.Nodes[tv.Nodes.Count - 1]; tnRoot.Tag = dr["ID"]; } else if (dr["IsZone"] != DBNull.Value && dr["IsZone"].Equals("B")) { tv.Nodes.Add(dr["Name"].ToString().Replace("|", " - ")); tv.Nodes[tv.Nodes.Count - 1].Tag = dr["ID"]; } else { tnRoot.Nodes.Add(dr["Name"].ToString()); tnRoot.Nodes[tnRoot.Nodes.Count - 1].Tag = dr["ID"]; } } } tv.ExpandAll(); ds = Program.DB.SelectAll("SELECT * FROM WorkSheets;"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { DateTime dtS = Convert.ToDateTime(dr["Start"].ToString()), dtF = Convert.ToDateTime(dr["Finish"].ToString()); GridRow r = new GridRow(new object[] { dr["ID"].ToString(), dr["Name"].ToString(), dtS.Date.ToShortDateString(), dtF.Date.ToShortDateString() }); r.Tag = dr["ID"]; g.PrimaryGrid.Rows.Add(r); } } }
private void gridZakazky_RowDoubleClick(object sender, DevComponents.DotNetBar.SuperGrid.GridRowDoubleClickEventArgs e) { DevComponents.DotNetBar.SuperGrid.GridRow selectedRow = (DevComponents.DotNetBar.SuperGrid.GridRow)e.GridRow; int cisloZakazky = Convert.ToInt32(selectedRow.Cells[1].Value); Properties.Settings.Default.CisloZakazky = cisloZakazky; Properties.Settings.Default.Save(); if (System.Windows.Forms.Application.OpenForms["EditZakazky"] as EditZakazky != null) { MessageBox.Show("Formulár úprava zákazky je už otvorený"); } else { EditZakazky EditZakazky = new EditZakazky(); EditZakazky.ShowDialog(); } }
/// <summary> /// Handles invocation of RowValidating events /// </summary> internal bool DoRowValidatingEvent(GridRow gridRow) { if (RowValidating != null) { GridRowValidatingEventArgs ev = new GridRowValidatingEventArgs(gridRow.GridPanel, gridRow); RowValidating(this, ev); return (ev.Cancel); } return (false); }
private void anadir_tmtos_Click(object sender, EventArgs e) { GridRow tupla = (GridRow)sgrid_tmtos.ActiveRow; if (tupla != null) { if (sgrid_tmtos2.PrimaryGrid.Columns.Count == 0) { GridColumnCollection columnas = sgrid_tmtos.PrimaryGrid.Columns; foreach (GridColumn columna in columnas) sgrid_tmtos2.PrimaryGrid.Columns.Add(new GridColumn(columna.Name)); } GridCellCollection c = tupla.Cells; if(!esta_agregado(c[0].ToString())) { GridRow nueva = new GridRow(c[0].Value.ToString(),c[1].Value.ToString(),c[2].Value.ToString(),c[3].Value.ToString(), c[4].Value.ToString(),c[5].Value.ToString(),c[6].Value.ToString()); sgrid_tmtos2.PrimaryGrid.Rows.Add((GridElement)nueva); } else mensaje_error("Ya se ha agregado el mismo medicamento."); } }
private void modifica_t_Click_1(object sender, EventArgs e) { GridRow tupla = (GridRow)sgrid_tratamientos.ActiveRow; if (tupla != null) { GridCellCollection tratamiento = tupla.Cells; List<String> ids_med = new List<string>(); codigo_tm = tratamiento[0].Value.ToString(); nombre_t.Text = tratamiento[1].Value.ToString(); descripcion_t.Text = tratamiento[2].Value.ToString(); sgrid_tmtos2.PrimaryGrid.Rows.Clear(); if (sgrid_tmtos2.PrimaryGrid.Columns.Count == 0) { GridColumnCollection columnas = sgrid_tmtos.PrimaryGrid.Columns; foreach (GridColumn columna in columnas) sgrid_tmtos2.PrimaryGrid.Columns.Add(new GridColumn(columna.Name)); } med_aux = new List<string>(); foreach (GridRow medicamento in sgrid_det_med.PrimaryGrid.Rows) { GridCellCollection m = medicamento.Cells; med_aux.Add(m[1].Value.ToString()); GridRow nueva = new GridRow(m[1].Value.ToString(),"", m[2].Value.ToString(), m[3].Value.ToString(), m[4].Value.ToString(), m[5].Value.ToString(), m[6].Value.ToString()); sgrid_tmtos2.PrimaryGrid.Rows.Add((GridElement)nueva); } sgrid_det_med.PrimaryGrid.Rows.Clear(); alta_t.Text = "Confirmar"; stc_tratamiento.SelectedTab = sti_control_t; modifica_tm = true; } }
private void btnSave_Click(object sender, EventArgs e) { int i; if (txtName.Text.Trim().Length == 0) { MessageBox.Show("Please enter a grid view name to continue.", "Grid View Name", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else if (!bDateStartChosen) { MessageBox.Show("Please select a start date to continue.", "Start Date", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else if (!bDateFinishChosen) { MessageBox.Show("Please select a finish date to continue.", "Finish Date", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } string sRooms = ""; int iRooms = 0; foreach (TreeNode n in tv.Nodes) { if (n.Checked && n.Nodes.Count > 0) { sRooms += sRooms.Length > 0 ? "," + n.Tag : n.Tag; iRooms++; foreach (TreeNode nc in n.Nodes) { if (nc.Checked) { sRooms += sRooms.Length > 0 ? "," + nc.Tag : nc.Tag; iRooms++; } } } else if (n.Checked) { sRooms += sRooms.Length > 0 ? "," + n.Tag : n.Tag; iRooms++; } } if (iRooms == 0) { MessageBox.Show("Please choose some rooms to continue.", "Rooms", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } Program.DB.AddParameter("Name", txtName.Text); Program.DB.AddParameter("Start", Convert.ToDateTime(dtFrom.Text)); Program.DB.AddParameter("Finish", Convert.ToDateTime(dtTo.Text)); Program.DB.AddParameter("Rooms", sRooms); if (iID > 0) { Program.DB.AddParameter("ID", iID); i = Program.DB.Update("UPDATE WorkSheets SET Name=@Name,Rooms=@Rooms,Start=@Start,Finish=@Finish WHERE ID=@ID;"); if (i < 1) { MessageBox.Show("The update failed. Please try again.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { MessageBox.Show("The update was successful.", "Updated", (MessageBoxButtons.OK), (MessageBoxIcon.Information)); } } else { i = Program.DB.Insert("INSERT INTO WorkSheets (Name,Rooms,Start,Finish) VALUES (@Name,@Rooms,@Start,@Finish)"); if (i < 1) { MessageBox.Show("The addition failed. Please try again.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { MessageBox.Show("The addition was successful.", "Updated", (MessageBoxButtons.OK), (MessageBoxIcon.Information)); } } iID = 0; txtName.Text = ""; dtFrom.Text = ""; dtTo.Text = ""; foreach (TreeNode n in tv.Nodes) { n.Checked = false; if (n.Nodes.Count > 0) { foreach (TreeNode nc in n.Nodes) { nc.Checked = false; } } } txtName.Enabled = false; dtFrom.Enabled = false; dtTo.Enabled = false; tv.Enabled = false; btnCancel.Enabled = false; btnSave.Enabled = false; bDateStartChosen = false; bDateFinishChosen = false; g.Enabled = true; g.PrimaryGrid.Rows.Clear(); DataSet ds = Program.DB.SelectAll("SELECT * FROM WorkSheets;"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { DateTime dtS = Convert.ToDateTime(dr["Start"].ToString()), dtF = Convert.ToDateTime(dr["Finish"].ToString()); GridRow r = new GridRow(new object[] { dr["ID"].ToString(), dr["Name"].ToString(), dtS.Date.ToShortDateString(), dtF.Date.ToShortDateString() }); r.Tag = dr["ID"]; g.PrimaryGrid.Rows.Add(r); } } bDataChanged = true; }
/// <summary> /// Handles invocation of RowDoubleClick events /// </summary> internal bool DoRowDoubleClickEvent(GridRow row, RowArea rowArea, MouseEventArgs e) { if (RowDoubleClick != null) { GridRowDoubleClickEventArgs ev = new GridRowDoubleClickEventArgs(row.GridPanel, row, rowArea, e); RowDoubleClick(this, ev); return (ev.Cancel); } return (false); }
private GridRow AllocNewGridRow(int index) { GridPanel panel = _Container.GridPanel; if (panel != null) { GridRow row = new GridRow(); row.Parent = _Container; row.GridIndex = index; row.Index = index; row.RowIndex = index; row.FullIndex = index; row.Loading = true; try { GridColumnCollection columns = panel.Columns; if (columns.Count > 0) { for (int i = 0; i < columns.Count; i++) { GridColumn col = panel.Columns[i]; GridCell cell = new GridCell(col.DefaultNewRowCellValue); cell.Parent = row; cell.ColumnIndex = i; row.Cells.Add(cell); } } ArrangeRow(panel, row); if (columns.Count > 0) _Container.SuperGrid.DoLoadVirtualRowEvent(panel, row); } finally { row.Loading = false; } return (row); } return (null); }
private void mRemove_Click(object sender, EventArgs e) { if (row != null && row.Tag != null && Convert.ToInt32(row.Tag) > 0) { Program.DB.AddParameter("ID", Convert.ToInt32(row.Tag)); int i = Program.DB.Delete("DELETE FROM WorkSheets WHERE ID=@ID;"); if (i < 1) { MessageBox.Show("The removal failed. Please try again.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { MessageBox.Show("The removal was successful.", "Updated", (MessageBoxButtons.OK), (MessageBoxIcon.Information)); } g.PrimaryGrid.Rows.Clear(); DataSet ds = Program.DB.SelectAll("SELECT * FROM WorkSheets;"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { DateTime dtS = Convert.ToDateTime(dr["Start"].ToString()), dtF = Convert.ToDateTime(dr["Finish"].ToString()); GridRow r = new GridRow(new object[] { dr["ID"].ToString(), dr["Name"].ToString(), dtS.Date.ToShortDateString(), dtF.Date.ToShortDateString() }); r.Tag = dr["ID"]; g.PrimaryGrid.Rows.Add(r); } } bDataChanged = true; } }
private void btnCommentSave_Click(object sender, EventArgs e) { if (txtComment.Text.Trim().Length > 0) { if (rComment != null && rComment.Tag.ToString() != "") { rComment.Cells[2].Value = txtComment.Text.Trim(); gComments.PrimaryGrid.Rows[rComment.Index] = rComment; } else { GridRow r = new GridRow(new object[] { DateTime.Now.ToString(), Program.Global.UserFirstName + " " + Program.Global.UserLastName, txtComment.Text.Trim() }); gComments.PrimaryGrid.Rows.Add(r); } } rComment = null; txtComment.Text = ""; txtComment.Enabled = false; btnCommentSave.Enabled = false; btnCommentCancel.Enabled = false; gComments.Enabled = true; }
private void gComments_RowActivated(object sender, GridRowActivatedEventArgs e) { rComment = e.NewActiveRow as GridRow; }
/// <summary> /// Handles invocation of RowSetDefaultValues events /// </summary> internal void DoRowSetDefaultValuesEvent( GridPanel panel, GridRow row, NewRowContext context) { if (RowSetDefaultValues != null) { GridRowSetDefaultValuesEventArgs ev = new GridRowSetDefaultValuesEventArgs(panel, row, context); bool loading = row.Loading; row.Loading = true; try { RowSetDefaultValues(this, ev); } finally { row.Loading = loading; } } }
private void MeasureCell(GridLayoutInfo layoutInfo, GridLayoutStateInfo stateInfo, ColumnAutoSizeMode autoSizeMode, GridRow row, GridCell cell) { if (cell.NeedsMeasured || NeedsMeasured || row.NeedsMeasured) { int rowHeight = row.GetRowHeight(); if (rowHeight > 0) { Size size = new Size(Width, rowHeight); if (autoSizeMode != ColumnAutoSizeMode.None) { cell.Measure(layoutInfo, stateInfo, Size.Empty); size.Width = cell.Size.Width; size.Width += GetColumnIndent(stateInfo.IndentLevel); } else { cell.Measure(layoutInfo, stateInfo, size); } cell.Size = size; } else { Size size = Size.Empty; if (autoSizeMode == ColumnAutoSizeMode.None) { size.Width = Width; size.Width -= GetColumnIndent(stateInfo.IndentLevel); size.Width = Math.Max(1, size.Width); } cell.Measure(layoutInfo, stateInfo, new Size(size.Width, 0)); if (autoSizeMode != ColumnAutoSizeMode.None) { size = cell.Size; size.Width += GetColumnIndent(stateInfo.IndentLevel); cell.Size = size; } else { size = cell.Size; size.Width = Width; cell.Size = size; } } cell.CellSize = cell.Size; } }
/// <summary> /// Handles invocation of RowMoving events /// </summary> internal bool DoRowMovingEvent(GridRow gridRow, GridContainer srcCont, int srcIndex, ref GridContainer destCont, ref int destIndex) { if (RowMoving != null) { GridRowMovingEventArgs ev = new GridRowMovingEventArgs( gridRow.GridPanel, gridRow, srcCont, srcIndex, destCont, destIndex); RowMoving(this, ev); destIndex = ev.DestIndex; destCont = ev.DestContainer; return (ev.Cancel); } return (false); }
/// <summary> /// Handles invocation of RowMouseUp events /// </summary> internal void DoRowMouseUpEvent(GridRow gridRow, MouseEventArgs args, RowArea area) { if (RowMouseUp != null) { GridRowMouseEventArgs ev = new GridRowMouseEventArgs(gridRow.GridPanel, gridRow, args, area); RowMouseUp(this, ev); } }
/// <summary> /// Handles invocation of RowGetDetailHeight events /// </summary> internal void DoRowGetDetailHeightEvent(GridRow row, GridLayoutInfo layoutInfo, Size sizeNeeded, ref int preHeight, ref int postHeight) { if (GetDetailRowHeight != null) { GridGetDetailRowHeightEventArgs ev = new GridGetDetailRowHeightEventArgs(row.GridPanel, row, layoutInfo, sizeNeeded, preHeight, postHeight); GetDetailRowHeight(this, ev); preHeight = ev.PreDetailHeight; postHeight = ev.PostDetailHeight; } }
/// <summary> /// Handles invocation of RowInfoDoubleClick events /// </summary> internal void DoRowInfoDoubleClickEvent(GridRow gridRow, MouseEventArgs e) { if (RowInfoDoubleClick != null) { GridRowDoubleClickEventArgs ev = new GridRowDoubleClickEventArgs(gridRow.GridPanel, gridRow, RowArea.InRowInfo, e); RowInfoDoubleClick(this, ev); } }
/// <summary> /// Handles invocation of RowInfoEnter events /// </summary> internal bool DoRowInfoEnterEvent(GridRow gridRow, Point pt) { if (RowInfoEnter != null) { GridRowInfoEnterEventArgs ev = new GridRowInfoEnterEventArgs(gridRow.GridPanel, gridRow, pt); RowInfoEnter(this, ev); return (ev.Cancel); } return (false); }
private Size GetMaxRowCellSize(GridRow row, GridLayoutInfo layoutInfo, GridLayoutStateInfo layoutState) { if (row.Cells.Count <= ColumnIndex) return (Size.Empty); GridCell cell = row.Cells[ColumnIndex]; Size oldSize = cell.Size; cell.Measure(layoutInfo, layoutState, Size.Empty); Size size = cell.Size; size.Width += GetColumnIndent(layoutState.IndentLevel); cell.Size = oldSize; if (row.Rows.Count > 0 && row.Expanded == true) { layoutState.IndentLevel++; foreach (GridContainer item in row.Rows) { if (item is GridRow) { Size cellSize = GetMaxRowCellSize((GridRow)item, layoutInfo, layoutState); size.Width = Math.Max(size.Width, cellSize.Width); size.Height = Math.Max(size.Height, cellSize.Height); } } layoutState.IndentLevel--; } return (size); }
/// <summary> /// Handles invocation of RowValidated events /// </summary> internal void DoRowValidatedEvent(GridRow gridRow) { if (RowValidated != null) { GridRowValidatedEventArgs ev = new GridRowValidatedEventArgs(gridRow.GridPanel, gridRow); RowValidated(this, ev); } }
public frmBooking() { InitializeComponent(); Icon = Properties.Resources.logo; for (int i = 1; i < 201; i++) { cbxDelegates.Items.Add(i.ToString()); cbxLunchAttendees.Items.Add(i.ToString()); } DataSet ds = Program.DB.SelectAll("SELECT ID,Name FROM Companies;"); if (ds.Tables.Count > 0) { AutoCompleteStringCollection asCompanies = new AutoCompleteStringCollection(); foreach (DataRow dr in ds.Tables[0].Rows) { asCompanies.Add(dr["Name"].ToString().Trim()); } txtCompany.AutoCompleteCustomSource = asCompanies; } ds = Program.DB.SelectAll("SELECT ID,Name,IsZone FROM Rooms;"); Dictionary<int, string> zones = new Dictionary<int, string>(); if (ds.Tables.Count > 0) { TreeNode tnRoot = new TreeNode(); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["IsZone"] != DBNull.Value && dr["IsZone"].Equals("Y")) { zones.Add(Convert.ToInt32(dr["ID"]), dr["Name"].ToString()); } } foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["IsZone"] != DBNull.Value && dr["IsZone"].Equals("Y")) { tvRooms.Nodes.Add(dr["Name"].ToString().Replace("|", " - ")); tnRoot = tvRooms.Nodes[tvRooms.Nodes.Count - 1]; tnRoot.Tag = dr["ID"]; } else if (dr["IsZone"] != DBNull.Value && dr["IsZone"].Equals("B")) { tvRooms.Nodes.Add(dr["Name"].ToString().Replace("|", " - ")); tvRooms.Nodes[tvRooms.Nodes.Count - 1].Tag = dr["ID"]; } else { tnRoot.Nodes.Add(dr["Name"].ToString()); tnRoot.Nodes[tnRoot.Nodes.Count - 1].Tag = dr["ID"]; } } } if (SharedData.iBookingID > 0) { Text = "Edit Booking"; //iNextID = SharedData.iBookingID; ds = Program.DB.SelectAll("SELECT ID,Job,BUser,BUserMod,BName,BCompany,BContact,BPhone,BEmail,BRoom,BRoomLayout,BDates,BTimes,BTimesAccess,BDelegates,BEquipment,BRefreshments,BRefreshmentsTimes,BLunch,BLunchMenu,BLunchNumber,BLunchTime,BLunchDiet,BComments,BInvoiceAddress,BInvoicePayment,BInvoiceOrder,Confirmed FROM Jobs WHERE ID=" + SharedData.iBookingID); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; if (row.ItemArray.Length > 0) { iNextID = Convert.ToInt32(row["Job"]); DataSet d; if (row["BCompany"] != DBNull.Value && row["BCompany"].ToString().All(char.IsDigit)) { d = Program.DB.SelectAll("SELECT Name FROM Companies WHERE ID=" + row["BCompany"].ToString() + ";"); if (d.Tables.Count > 0 && d.Tables[0].Rows.Count > 0) { txtCompany.Text = d.Tables[0].Rows[0]["Name"].ToString(); } } if (txtCompany.Text.Trim() != "" && row["BContact"] != DBNull.Value && row["BContact"].ToString().All(char.IsDigit)) { AutoCompleteStringCollection asContacts = new AutoCompleteStringCollection(); Program.DB.AddParameter("Company", row["BCompany"].ToString()); d = Program.DB.SelectAll("SELECT ID,NameTitle,NameFirst,NameLast FROM Contacts WHERE Company=@Company;"); if (d.Tables.Count > 0 && d.Tables[0].Rows.Count > 0) { string sSelected = ""; foreach (DataRow r in d.Tables[0].Rows) { asContacts.Add(r["NameFirst"].ToString() + " " + r["NameLast"].ToString()); if (r["ID"] == row["BContact"]) { sSelected = r["NameFirst"].ToString() + " " + r["NameLast"].ToString(); } } txtContact.AutoCompleteCustomSource = asContacts; txtContact.Text = sSelected; } } txtPhone.Text = row["BPhone"].ToString(); txtEmail.Text = row["BEmail"].ToString(); if (row["BRoom"] != DBNull.Value && row["BRoom"].ToString() != "") { string[] sRooms = row["BRoom"].ToString().Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); foreach (TreeNode n in tvRooms.Nodes) { if (n.Nodes.Count > 0) { foreach (TreeNode nc in n.Nodes) { if (sRooms.Contains(nc.Tag.ToString())) { nc.Checked = true; } } } if (sRooms.Contains(n.Tag.ToString())) { n.Checked = true; } } tvRooms.ExpandAll(); tvRooms.TopNode = tvRooms.Nodes[0]; } txtLayout.Text = row["BRoomLayout"].ToString(); txtName.Text = row["BName"].ToString(); DateTime now = DateTime.Now; int iYear = now.Year, iMonth = now.Month, iDay = now.Day; string[] dates; if (row["BDates"].ToString() != "") { dates = row["BDates"].ToString().Split('|'); if (dates.Length == 2) { string[] d1 = dates[0].Split('/'); iYear = Convert.ToInt32(d1[2].Substring(0, d1[2].IndexOf(' '))); iMonth = Convert.ToInt32(d1[1]); iDay = Convert.ToInt32(d1[0]); dtDateFrom.Value = new DateTime(iYear, iMonth, iDay); string[] d2 = dates[1].Split('/'); iYear = Convert.ToInt32(d2[2].Substring(0, d2[2].IndexOf(' '))); iMonth = Convert.ToInt32(d2[1]); iDay = Convert.ToInt32(d2[0]); dtDateTo.Value = new DateTime(iYear, iMonth, iDay); } } string[] sTimes = row["BTimes"].ToString().Split('|'); if (sTimes.Length == 2) { dtTimeFrom.Text = sTimes[0]; dtTimeTo.Text = sTimes[1]; } else { dtTimeFrom.Text = ""; dtTimeTo.Text = ""; } sTimes = row["BTimesAccess"].ToString().Split('|'); if (sTimes.Length == 2) { dtTimeAccessFrom.Text = sTimes[0]; dtTimeAccessTo.Text = sTimes[1]; } else { dtTimeAccessFrom.Text = ""; dtTimeAccessTo.Text = ""; } cbxDelegates.SelectedIndex = cbxDelegates.FindStringExact(row["BDelegates"].ToString()); txtEquipment.Text = row["BEquipment"].ToString(); if (row["BRefreshments"] != DBNull.Value && row["BRefreshments"].ToString() == "Y") { swRefreshments.Value = true; } else { swRefreshments.Value = false; } txtRefreshmentTimes.Text = row["BRefreshmentsTimes"].ToString(); if (row["BLunch"] != DBNull.Value && row["BLunch"].ToString() == "Y") { swLunch.Value = true; } else { swLunch.Value = false; } txtLunchMenu.Text = row["BLunchMenu"].ToString(); cbxLunchAttendees.SelectedIndex = cbxLunchAttendees.FindStringExact(row["BLunchNumber"].ToString()); dtLunchTime.Text = row["BLunchTime"].ToString().Length > 0 ? row["BLunchTime"].ToString() : ""; txtLunchDiet.Text = row["BLunchDiet"].ToString(); d = Program.DB.SelectAll("SELECT ID,Entered,UserID,Comment FROM Comments WHERE Job=" + iNextID + ";"); if (d.Tables.Count > 0 && d.Tables[0].Rows.Count > 0) { foreach (DataRow r in d.Tables[0].Rows) { string sUser = ""; if (r["UserID"] != DBNull.Value && r["UserID"].ToString() != "") { DataSet du = Program.DB.SelectAll("SELECT NameFirst,NameLast FROM Users WHERE ID=" + r["UserID"].ToString() + ";"); if (du.Tables.Count > 0 && du.Tables[0].Rows.Count > 0) { sUser = du.Tables[0].Rows[0]["NameFirst"].ToString() + " " + du.Tables[0].Rows[0]["NameFirst"].ToString(); } } GridRow gr = new GridRow(new object[] { r["Entered"].ToString(), sUser, r["Comment"].ToString() }); gr.Tag = r["ID"]; gComments.PrimaryGrid.Rows.Add(gr); } } txtInvoiceAddress.Text = row["BInvoiceAddress"].ToString(); foreach (DevComponents.Editors.ComboItem ci in cbxPaymentMethod.Items) { if (ci.Text == row["BInvoicePayment"].ToString()) { cbxPaymentMethod.SelectedItem = ci; break; } } txtPurchaseOrder.Text = row["BInvoiceOrder"].ToString(); if (row["BUser"] != DBNull.Value && row["BUser"].ToString().All(char.IsDigit)) { d = Program.DB.SelectAll("SELECT NameFirst,NameLast FROM Users WHERE ID=" + row["BUser"].ToString() + ";"); if (d.Tables.Count > 0 && d.Tables[0].Rows.Count == 1) { lblUsers.Text = "Added by: " + d.Tables[0].Rows[0]["NameFirst"].ToString() + " " + d.Tables[0].Rows[0]["NameLast"].ToString(); lblUsers.Visible = true; } } if (row["BUserMod"] != DBNull.Value && row["BUserMod"].ToString().All(char.IsDigit)) { d = Program.DB.SelectAll("SELECT NameFirst,NameLast FROM Users WHERE ID=" + row["BUserMod"].ToString() + ";"); if (d.Tables.Count > 0 && d.Tables[0].Rows.Count == 1) { lblUsers.Text += Environment.NewLine + "Last modified by: " + d.Tables[0].Rows[0]["NameFirst"].ToString() + " " + d.Tables[0].Rows[0]["NameLast"].ToString(); lblUsers.Visible = true; } } Text = "Edit Booking: " + Convert.ToInt32(row["Job"]).ToString(sNextIDFormat); Program.DB.AddParameter("Job", row["Job"]); DataSet c = Program.DB.SelectAll("SELECT * FROM Comments WHERE Job=@Job;"); if (c.Tables.Count > 0 && c.Tables[0].Rows.Count > 0) { foreach (DataRow r in c.Tables[0].Rows) { string sUser = r["UserID"].ToString(); Program.DB.AddParameter("ID", r["UserID"]); DataSet cu = Program.DB.SelectAll("SELECT NameFirst,NameLast FROM Users WHERE ID=@ID;"); if (cu.Tables.Count > 0 && cu.Tables[0].Rows.Count > 0) { sUser = cu.Tables[0].Rows[0]["NameFirst"] + " " + cu.Tables[0].Rows[0]["NameFirst"]; } GridRow cr = new GridRow(new object[] { r["Entered"].ToString(), sUser, r["Comment"].ToString() }); cr.Tag = r["ID"]; } } } } string sPath = Properties.Settings.Default.PathToData + @"\Bookings\" + SharedData.iBookingID.ToString(sNextIDFormat); if (Directory.Exists(sPath)) { string[] sFiles = Directory.GetFiles(sPath); foreach (string sFile in sFiles) { if (File.Exists(sFile)) { FileInfo inf = new FileInfo(sFile); ListViewItem i = new ListViewItem(); i.Tag = sFile; i.Text = inf.Name; lvDocuments.Items.Add(i); } } } } else { dtDateFrom.Value = SharedData.dtSelectedStart != DateTime.Today ? SharedData.dtSelectedStart : DateTime.Today; dtDateTo.Value = SharedData.dtSelectedFinish != DateTime.Today ? SharedData.dtSelectedFinish : DateTime.Today; if (SharedData.sBookingCompany != "") { txtCompany.Text = SharedData.sBookingCompany; } if (SharedData.sBookingContact != "") { txtContact.Text = SharedData.sBookingContact; } if (SharedData.sBookingEmail != "") { txtEmail.Text = SharedData.sBookingEmail; } if (SharedData.sBookingPhone != "") { txtPhone.Text = SharedData.sBookingEmail; } if (SharedData.sBookingRooms != "") { string[] sRooms = SharedData.sBookingRooms.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); foreach (TreeNode n in tvRooms.Nodes) { if (n.Nodes.Count > 0) { foreach (TreeNode nc in n.Nodes) { if (sRooms.Contains(nc.Tag.ToString())) { nc.Checked = true; } } } if (sRooms.Contains(n.Tag.ToString())) { n.Checked = true; } } tvRooms.ExpandAll(); tvRooms.TopNode = tvRooms.Nodes[0]; } dtTimeFrom.Text = "08:30"; dtTimeTo.Text = "16:30"; dtTimeAccessFrom.Text = "08:00"; dtTimeAccessTo.Text = "17:00"; ds = Program.DB.SelectAll("SELECT MAX(Job) AS NextID FROM Jobs;"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0]["NextID"] != DBNull.Value) { iNextID = Convert.ToInt32(ds.Tables[0].Rows[0]["NextID"].ToString()) + 1; } else { iNextID = 1; } foreach (TreeNode item in tvRooms.Nodes) { item.Checked = false; } Text = "Add Booking: " + iNextID.ToString(sNextIDFormat); } }
/// <summary> /// Handles invocation of LoadVirtualRow events /// </summary> internal void DoLoadVirtualRowEvent(GridPanel panel, GridRow row) { if (LoadVirtualRow != null) { GridVirtualRowEventArgs ev = new GridVirtualRowEventArgs(panel, row, row.Index); LoadVirtualRow(this, ev); } }
private void mCommentsAdd_Click(object sender, EventArgs e) { rComment = null; txtComment.Text = ""; txtComment.Enabled = true; gComments.Enabled = false; btnCommentSave.Enabled = true; btnCommentCancel.Enabled = true; }
/// <summary> /// Handles invocation of StoreVirtualRow events /// </summary> internal void DoStoreVirtualRowEvent(GridPanel gridPanel, GridRow gridRow) { if (StoreVirtualRow != null) { GridVirtualRowEventArgs ev = new GridVirtualRowEventArgs(gridPanel, gridRow, gridRow.Index); StoreVirtualRow(this, ev); } }
private void ArrangeRow(GridPanel panel, GridRow row) { Rectangle r = panel.BoundsRelative; r.Y += (panel.FixedRowHeight - (panel.FrozenRowCount * panel.VirtualRowHeight)); r.Y += (row.Index * panel.VirtualRowHeight); r.Size = new Size(panel.ColumnHeader.Size.Width, panel.VirtualRowHeight); _layoutInfo.ClientBounds = r; _stateInfo.GridPanel = panel; row.FixedRowHeight = r.Size.Height; row.Arrange(_layoutInfo, _stateInfo, r); }
private static bool EvalRowFilterState( GridPanel panel, GridRow row, ref bool filteredOut) { try { filteredOut = (panel.FilterEval.Evaluate(row) == false); } catch (Exception exp) { filteredOut = false; bool throwException = false; if (panel.SuperGrid.DoFilterRowErrorEvent(panel, row, exp, ref filteredOut, ref throwException) == true) { return (true); } if (throwException == true) throw; MessageBoxEx.Show(exp.Message); return (true); } return (false); }
private void g_RowActivated(object sender, GridRowActivatedEventArgs e) { row = e.NewActiveRow as GridRow; }
private static bool EvalColumnFilterState( GridPanel panel, GridRow row, ref bool filteredOut) { foreach (GridColumn col in panel.Columns) { if (col.IsFiltered == true) { if (col.FilterError == false) { try { filteredOut = (col.FilterEval.Evaluate(row) == false); } catch (Exception exp) { col.FilterError = true; filteredOut = false; bool throwException = false; if (panel.SuperGrid.DoFilterColumnErrorEvent(panel, row, col, exp, ref filteredOut, ref throwException) == true) { return (true); } if (throwException == true) throw; if (col.FilterEval.PostError == true) MessageBoxEx.Show((col.Name ?? "[" + col.ColumnIndex + "]") + ":\n" + exp.Message); return (true); } } } if (filteredOut == true) break; } return (false); }
internal static void UpdateRowFilterState(GridPanel panel, GridRow row) { bool isPrimary = (row.Parent is GridPanel); bool root = (panel.FilterLevel & (FilterLevel.Root | FilterLevel.RootConditional)) != 0; bool expanded = (panel.FilterLevel & FilterLevel.Expanded) != 0; if ((isPrimary == true && root == true) || (isPrimary == false && expanded == true)) { bool filteredOut = false; bool rowFiltered = IsRowFiltered(panel); bool colFiltered = IsColumnFiltered(panel); if (rowFiltered == true || colFiltered == true) { if (rowFiltered == true) rowFiltered = UpdateRowFilter(panel); if (colFiltered == true) UpdateColumnFilter(panel); if (rowFiltered == true) { if (EvalRowFilterState(panel, row, ref filteredOut) == true) return; } if (filteredOut == false && colFiltered == true) { if (EvalColumnFilterState(panel, row, ref filteredOut) == true) return; } } row.RowFilteredOut = filteredOut; panel.SuperGrid.NeedToUpdateIndicees = true; } }
/// <summary> /// Handles invocation of PreRenderRow events /// </summary> internal bool DoPreRenderRowEvent(Graphics g, GridRow gridRow, RenderParts parts, Rectangle bounds) { if (PreRenderRow != null) { GridPreRenderRowEventArgs ev = new GridPreRenderRowEventArgs(g, gridRow.GridPanel, gridRow, parts, bounds); PreRenderRow(this, ev); return (ev.Cancel); } return (false); }