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);
}
};
}
}
}
public QuantityIntervals()
{
InitializeComponent();
Additional.DesignMyGrid(dgvQty);
}
