private void Articles_Load(object sender, EventArgs e) { Exacta.Menu.db = new DataContext(Exacta.Menu.connectionString); Additional.DesignMyGrid(dgvArticles); Additional.DesignMyGrid(dgv_FaseArticles); fillFaseCombo(); LoadArticles(); dgvArticles.Columns[1].HeaderText = "Article"; dgvArticles.Columns[2].HeaderText = "Description"; _canSaveArt = 0; _canSaveFase = 0; EnableArticleFields(false); EnableArticlePhaseFields(false); Additional.FillTheFilter(dgvArticles, cbArticle, 1); txt_Article.Enabled = false; txt_description_article.Enabled = false; cbClient.Enabled = false; cbCollection.Enabled = false; btn_save_article.Enabled = false; btn_cancel_article.Enabled = false; btn_saveFase.Enabled = false; btn_cancelFase.Enabled = false; cbFinezza.Enabled = true; EnableStoptronicFields(false); // // Exacta.Menu.Expiration(); }
private void pbSaveClient_Click(object sender, EventArgs e) { if (newClient) { Clientss client = new Clientss(); GetDataFromControls(client); if (txtName.Text == "") { MessageBox.Show("Complete at least Client Name!", "Atention!", MessageBoxButtons.OK); } else { try { Tables.TblClients.InsertOnSubmit(client); Exacta.Menu.db.SubmitChanges(); } catch (Exception err) { MessageBox.Show("There was an error. " + err); } newClient = false; } } else { if (dgvClients.Rows.Count == 0) { return; } var dialog = MessageBox.Show("Do you want to update Client?", "Client update", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.No) { return; } Clientss client = Exacta.Menu.db.GetTable <Clientss>().SingleOrDefault(cl => cl.Id.ToString() == selectedClient); try { Articole art = Exacta.Menu.db.GetTable <Articole>().SingleOrDefault(ar => ar.Client == client.Name); if (art != null) { art.Client = txtName.Text; } GetDataFromControls(client); Exacta.Menu.db.SubmitChanges(); } catch (Exception err) { MessageBox.Show("There was an error. " + err); } } LoadClients(); dgvClients.Enabled = true; Additional.FillTheFilter(dgvClients, cbClient, 1); }
private void btn_Delete_Article_Click(object sender, EventArgs e) { if (dgvArticles.Rows.Count == 0) { return; } if (_isNewArticle) { txt_Article.Text = ""; txt_description_article.Text = ""; txt_Article.BackColor = Color.White; txt_description_article.BackColor = Color.White; txt_capiOra.Text = ""; dgvArticles.Enabled = true; LoadArticles(); _isNewArticle = false; return; } var dr = MessageBox.Show("Are you sure you want to delete article '" + txt_Article.Text + "'?", "Article", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.No) { return; } var query = from art in Tables.TblArticole where art.Id.ToString() == _selectedArticle select art; var queryA = from art in Tables.TblOperatiiArticole where art.IdArticol.ToString() == _selectedArticle select art; var articol = queryA.ToList(); foreach (var line in articol) { Tables.TblOperatiiArticole.DeleteOnSubmit(line); } var linex = query.ToList(); foreach (var line in linex) { Tables.TblArticole.DeleteOnSubmit(line); } Exacta.Menu.db.SubmitChanges(); LoadArticles(); loadArticleFase(); Additional.FillTheFilter(dgvArticles, cbArticle, 1); }
private void btn_Delete_Fase_Click(object sender, EventArgs e) { if (dgvFase.Rows.Count == 0) { return; } if (_isNewFase) { txt_FaseID.Text = ""; txt_Fase.Text = ""; txt_FaseID.BackColor = Color.White; txt_Fase.BackColor = Color.White; dgvFase.Enabled = true; LoadFase(); _isNewFase = false; return; } var dr = MessageBox.Show("Are you sure you want to delete " + txt_FaseID.Text + "?", "Phase", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.No) { return; } var query = from fase in Tables.TblOperatii where fase.Id.ToString() == _selectedFase select fase; var linex = query.ToList(); foreach (var line in linex) { Tables.TblOperatii.DeleteOnSubmit(line); } Exacta.Menu.db.SubmitChanges(); LoadFase(); Additional.FillTheFilter(dgvFase, cbPhase, 1); if (dgvFase.Rows.Count == 0) { txt_FaseID.Text = String.Empty; txt_Fase.Text = String.Empty; } }
private void Phase_Load(object sender, EventArgs e) { //pnl_table_Fase.Width = this.Width - pnl_Edit_Fase.Width; //dgvFase.Width = pnl_table_Fase.Width - 10; Exacta.Menu.db = new DataContext(Exacta.Menu.connectionString); Additional.DesignMyGrid(dgvFase); LoadFase(); dgvFase.Columns[1].HeaderText = "Operation Code"; dgvFase.Columns[2].HeaderText = "Operation"; dgvFase.Columns[0].Visible = false; Additional.FillTheFilter(dgvFase, cbPhase, 1); txt_Fase.Enabled = false; txt_FaseID.Enabled = false; // Exacta.Menu.Expiration(); }
private void pbDeleteCollection_Click(object sender, EventArgs e) { if (dgvCollection.Rows.Count == 0) { return; } var dialog = MessageBox.Show("Are you sure you want to delete collection?", "Collection", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.No) { return; } var query = from collection in Tables.TblCollections where collection.Id.ToString() == selectedCollection select collection; foreach (var line in query) { Tables.TblCollections.DeleteOnSubmit(line); } try { Exacta.Menu.db.SubmitChanges(); } catch (Exception err) { Console.WriteLine("There was an error. " + err); } LoadCollections(); Additional.FillTheFilter(dgvCollection, cbCollection, 1); if (dgvCollection.Rows.Count == 0) { txtCollection.Text = String.Empty; txtCode.Text = String.Empty; } }
private void pbDeleteClient_Click(object sender, EventArgs e) { if (dgvClients.Rows.Count == 0) { return; } var dialog = MessageBox.Show("Are you sure you want to delete " + txtName.Text + "?", "Client", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.No) { return; } var query = from client in Tables.TblClients where client.Id.ToString() == selectedClient select client; foreach (var line in query) { Tables.TblClients.DeleteOnSubmit(line); } try { Exacta.Menu.db.SubmitChanges(); } catch (Exception err) { Console.WriteLine("There was an error. " + err); } LoadClients(); Additional.FillTheFilter(dgvClients, cbClient, 1); if (dgvClients.Rows.Count == 0) { ClearClientsTxtBoxes(); } }
private void btn_Save_Fase_Click(object sender, EventArgs e) { if (_isNewFase) //insert new record { try { var lQuery = (from fas in Tables.TblOperatii where fas.CodOperatie == txt_FaseID.Text select fas).ToList(); if (lQuery.Count > 0) { MessageBox.Show("Fase already exists"); return; } Operatii fase = new Operatii(); fase.CodOperatie = txt_FaseID.Text; fase.Operatie = txt_Fase.Text; Tables.TblOperatii.InsertOnSubmit(fase); Exacta.Menu.db.SubmitChanges(); dgvFase.Enabled = true; txt_FaseID.BackColor = Color.White; txt_Fase.BackColor = Color.White; _isNewFase = false; } catch (Exception ex) { _isNewFase = false; MessageBox.Show(ex.Message); } } else //update record { var dr = MessageBox.Show("Do you want to update " + _selectedFase + "?", "Fase update", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.No) { return; } try { //var lQuery = (from fas in Tables.TblOperatii // where fas.CodOperatie == txt_FaseID.Text // select fas).ToList(); //if (lQuery.Count > 0) //{ // MessageBox.Show("Fase already exists"); // return; //} var lsQuery = (from fas in Tables.TblOperatii where fas.Id.ToString() == _selectedFase select fas).SingleOrDefault(); lsQuery.CodOperatie = txt_FaseID.Text; lsQuery.Operatie = txt_Fase.Text; Exacta.Menu.db.SubmitChanges(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } txt_FaseID.Text = ""; txt_Fase.Text = ""; LoadFase(); pnl_Edit_Fase.Visible = true; //pnl_table_Fase.Left -= (pnl_Edit_Fase.Width + 10); btn_Add_Fase.Enabled = true; btn_Modify_Fase.Enabled = true; btn_Delete_Fase.Enabled = true; dgvFase.Enabled = true; btn_Save_Fase.Enabled = false; btn_Cancel_Fase.Enabled = false; txt_Fase.Enabled = false; txt_FaseID.Enabled = false; Additional.FillTheFilter(dgvFase, cbPhase, 1); }
private void pbSaveCollection_Click(object sender, EventArgs e) { if (newCollection) { if (String.IsNullOrEmpty(txtCollection.Text) || String.IsNullOrEmpty(txtCode.Text)) { newCollection = false; return; } Collections collection = new Collections(); GetDataFromControls(collection); if (digit) { try { Tables.TblCollections.InsertOnSubmit(collection); Exacta.Menu.db.SubmitChanges(); } catch (Exception) { MessageBox.Show("The Collection ID aready exists\n Try with another ID.", "Atention!", MessageBoxButtons.OK, MessageBoxIcon.Error); } newCollection = false; } else { return; } } else { if (dgvCollection.Rows.Count == 0) { return; } var dialog = MessageBox.Show("Do you want to update Collection?", "Collection update", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.No) { return; } Collections collection = Exacta.Menu.db.GetTable <Collections>().Single(cl => cl.Id.ToString() == selectedCollection); try { Articole art = Exacta.Menu.db.GetTable <Articole>().SingleOrDefault(ar => ar.Collection == collection.Code); if (art != null) { art.Collection = txtCode.Text; } GetDataFromControls(collection); Exacta.Menu.db.SubmitChanges(); } catch (Exception err) { MessageBox.Show("There was an error. " + err); } } LoadCollections(); dgvCollection.Enabled = true; Additional.FillTheFilter(dgvCollection, cbCollection, 1); }
private void Settings_Load(object sender, EventArgs e) { try { if (Store.Default.sector == rbConfezione.Text) { rbConfezione.Checked = true; } if (Store.Default.sector == rbStiro.Text) { rbStiro.Checked = true; } if (Store.Default.sub_sector == rbConfezioneA.Text) { rbConfezioneA.Checked = true; } if (Store.Default.sub_sector == rbConfezioneB.Text) { rbConfezioneB.Checked = true; } if (Store.Default.sub_sector == rbTurno1.Text) { rbTurno1.Checked = true; } if (Store.Default.sub_sector == rbTurno2.Text) { rbTurno2.Checked = true; } _suggest = Store.Default.suggestData; _autoSync = Store.Default.autoSync; _backupData = Store.Default.backupData; Additional.DesignMyGrid(dgvLines); Additional.DesignMyGrid(dgvMachines); Additional.DesignMyGrid(dgvCollection); Additional.DesignMyGrid(dgvPause); LoadLines(); LoadMachines(); dgvMachines.Columns["NrMatricola"].HeaderText = "Reg. Number"; LoadCollections(); txtLine.CharacterCasing = CharacterCasing.Upper; LoadPause(); //Clients Additional.DesignMyGrid(dgvClients); LoadClients(); dgvClients.Columns["Id"].Visible = false; dgvClients.Columns[6].HeaderText = "E-mail"; dgvClients.Columns[2].HeaderText = "VAT Number"; Additional.FillTheFilter(dgvClients, cbClient, 1); Additional.FillTheFilter(dgvCollection, cbCollection, 1); } catch (Exception err) { MessageBox.Show("There was an error! " + err); } //Exacta.Menu.Expiration(); WorkingTS(); }
private void btn_save_article_Click(object sender, EventArgs e) { if (_canSaveArt == 0) { return; } if (_isNewArticle) //insert new record { try { var lQuery = (from art in Tables.TblArticole where art.Articol == txt_Article.Text select art).ToList(); if (lQuery.Count > 0) { MessageBox.Show("Article already exists"); return; } Articole articol = new Articole(); articol.Articol = txt_Article.Text; articol.Descriere = txt_description_article.Text; articol.Collection = cbCollection.Text; articol.Client = cbClient.Text; Tables.TblArticole.InsertOnSubmit(articol); Exacta.Menu.db.SubmitChanges(); txt_Article.BackColor = Color.White; txt_description_article.BackColor = Color.White; _isNewArticle = false; btn_add_article_fase.Enabled = true; _canSaveArt = 0; } catch (Exception ex) { _canSaveArt = 0; _isNewArticle = false; MessageBox.Show(ex.Message); } } else //update record { var dr = MessageBox.Show("Do you want to update " + _selectedArticle + "?", "Article update", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.No) { return; } try { //var lQuery = (from art in Tables.TblArticole // where art.Articol == txt_Article.Text // select art).ToList(); //if (lQuery.Count > 0) // { // MessageBox.Show("Article already exists"); // return; // } var lsQuery = (from art in Tables.TblArticole where art.Id.ToString() == _selectedArticle select art).SingleOrDefault(); Articole articola = Exacta.Menu.db.GetTable <Articole>().SingleOrDefault(arti => arti.Id.ToString() == _selectedArticle); articola.Articol = txt_Article.Text; articola.Descriere = txt_description_article.Text; articola.Collection = cbCollection.Text; articola.Client = cbClient.Text; Exacta.Menu.db.SubmitChanges(); _canSaveArt = 0; } catch (Exception ex) { _canSaveArt = 0; MessageBox.Show(ex.ToString()); } } LoadArticles(); var Query = (from art in Tables.TblArticole select art).ToList(); dgvArticles.Rows[Query.Count - 1].Selected = true; btn_save_article.Enabled = false; btn_cancel_article.Enabled = false; btn_Add_Article.Enabled = true; btn_Edit_Article.Enabled = true; btn_Delete_Article.Enabled = true; dgvArticles.Enabled = true; Additional.FillTheFilter(dgvArticles, cbArticle, 1); dgv_FaseArticles.Enabled = true; EnableArticleFields(false); }
private void CreateHeaderFilters(DataGridView dgv) { if (_filters.Count >= 1) { foreach (var filter in _filters) { var cb = (from c in dgv.Controls.OfType <ComboBox>() where c.Name == filter.Name select c).SingleOrDefault(); dgv.Controls.Remove(cb); } } var startIdx = 0; foreach (DataGridViewColumn visColumn in dgv.Columns) { if (visColumn.Visible == true) { startIdx = visColumn.Index; break; } } _headerCell = dgv.GetCellDisplayRectangle(startIdx, -1, true); foreach (DataGridViewColumn col in dgv.Columns) { if (col.Visible == true) { ComboBox cb = new ComboBox(); cb.DropDownStyle = ComboBoxStyle.DropDownList; cb.Name = "cb_" + col.Name; dgv.Controls.Add(cb); cb.Location = new Point(_headerCell.Location.X, _headerCell.Location.Y + _headerCell.Height - cb.Height - 1); cb.Size = new Size(col.Width - 1, 10); _headerCell.X += col.Width; _filters.Add(cb); Additional.FillTheFilter(dgv, cb, col.Index); cb.SelectedIndexChanged += delegate { if (!string.IsNullOrEmpty(cb.Text)) { BindingSource bs = new BindingSource(); bs.DataSource = dgv.DataSource; bs.Filter = string.Format("CONVERT(" + dgv.Columns[col.Name].DataPropertyName + ", System.String) like '" + cb.Text.Replace("'", "''") + "'"); dgv.DataSource = bs; } else { if (dgv.DataSource != null) { dgv.DataSource = null; } AddDataTableColumns(); CreateHeaderFilters(dataGridView1); } }; } } }