private void BtnBackUpDataBase_Click(object sender, EventArgs e)
{
saveFileDialog1.FileName = "PrepAndPaintDataBase_" + DateTime.Now.Date.ToString("MM-dd-yyyy");
saveFileDialog1.Filter = "PrepAndPaint databases (*.db)|*.db";
saveFileDialog1.ShowDialog();
PrepAndPaintDB.BackUpDataBase(saveFileDialog1.FileName);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (IsValidate())
{
AdminsModel newAdmin = new AdminsModel()
{
Name = txtAdminName.Text,
Password = txtAdminPassWord.Text
};
List <AdminsModel> admins = PrepAndPaintDB.GetAdmins();
foreach (var name in admins)
{
if (name.Name == newAdmin.Name)
{
MessageBox.Show($"Name: {newAdmin.Name} already exist", "Exist Already!", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtAdminName.Focus();
return;
}
}
PrepAndPaintDB.AddAdmin(newAdmin);
txtAdminName.Clear();
txtAdminPassWord.Clear();
PopulateDataGrid();
}
}
private void DeleteEntry()
{
if (jobInfoDataGrid.SelectedRows.Count > 0)
{
int selectedRowIndex = jobInfoDataGrid.SelectedCells[0].RowIndex;
int Id = (int)jobInfoDataGrid.Rows[selectedRowIndex].Cells[0].Value;
string jobNumber = jobInfoDataGrid.Rows[selectedRowIndex].Cells[2].Value.ToString();
string item = jobInfoDataGrid.Rows[selectedRowIndex].Cells[3].Value.ToString();
if (MessageBox.Show($"Are you sure you want to delete line Item {item} for Job# {jobNumber}", "Confirm delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
PrepAndPaintModel deleteId = new PrepAndPaintModel()
{
Id = Id
};
PrepAndPaintDB.Delete(deleteId);
GetInfo();
//if (selectedRowIndex > 0)
//{
// jobInfoDataGrid.Rows[selectedRowIndex - 1].Cells[1].Selected = true;
//}
}
}
else
{
MessageBox.Show("Sorry you need to select an entry to delete!", "Error", MessageBoxButtons.OK);
}
}
private void btnSearchAnyYear_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtSearch.Text))
{
MessageBox.Show("Enter somethingin the search!", "Noting To Search!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (rdoItem.Checked)
{
dataGridView.DataSource = PrepAndPaintDB.SearchItemAnyYear(txtSearch.Text);
if (dataGridView.Rows.Count <= 0)
{
MessageBox.Show($"Nothing found with name {txtSearch.Text}", "Nothing found!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
SetDataGridView();
}
}
else if (rdoJobNumber.Checked)
{
dataGridView.DataSource = PrepAndPaintDB.SearchJobsByAnyYear(txtSearch.Text);
if (dataGridView.Rows.Count <= 0)
{
MessageBox.Show($"Nothing found for Job# {txtSearch.Text}", "Nothing found!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
SetDataGridView();
}
}
}
private void DeleteEntry()
{
if (dataGridView.SelectedRows.Count > 0)
{
int selectedRowIndex = dataGridView.SelectedCells[0].RowIndex;
int Id = (int)dataGridView.Rows[selectedRowIndex].Cells[0].Value;
string job = dataGridView.Rows[selectedRowIndex].Cells[1].Value.ToString();
if (MessageBox.Show($"Are you sure you want to delete job #{job}?", "Confirm delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
PrepAndPaintModel deleteId = new PrepAndPaintModel()
{
Id = Id
};
PrepAndPaintDB.Delete(deleteId);
GetInfo();
if (selectedRowIndex > 0)
{
dataGridView.Rows[selectedRowIndex - 1].Cells[1].Selected = true;
}
}
}
else
{
MessageBox.Show("Sorry you need to select an entry to delete!", "Error", MessageBoxButtons.OK);
}
}
private void GetInfo()
{
dataGridView1.DataSource = PrepAndPaintDB.GetSuperVisorInfo();
dataGridView1.Columns[0].Visible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void GetItemInfo()
{
List <ItemsModel> list = PrepAndPaintDB.GetItemsList();
foreach (var item in list)
{
itemsListBox.Items.Add(item.ItemName);
}
}
private void PassWord_Load(object sender, EventArgs e)
{
List <AdminsModel> adminList = PrepAndPaintDB.GetAdmins();
if (adminList.Count == 0)
{
MessageBox.Show("Currently there are no admins. Please create an admin account to protect your data", "No Admins!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
AdminPage adminPage = new AdminPage();
adminPage.ShowDialog();
}
}
private void MarkJobCompleted(bool completed)
{
JobsModel editJob = new JobsModel()
{
Id = job.Id,
JobNumber = job.JobNumber,
Customer = job.Customer,
Model = job.Model,
Completed = completed
};
PrepAndPaintDB.EditJob(editJob);
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (IsValidate())
{
if (edit)
{
CheckStartDate();
CheckPaintDate();
PrepAndPaintModel edited = new PrepAndPaintModel()
{
Id = editJob.Id,
StartDate = startDate,
JobNumber = txtJobNumber.Text,
Prepper = txtPrepper.Text,
PaintDate = paintDate,
Painter = txtPainter.Text,
BodyOrDoors = cmboBodyDoors.Text,
Booth = cmboBooth.Text,
Colour = cmboColour.Text,
NewProcess = checkNewProcess.Checked,
WashBay = checkWashBay.Checked,
Comments = txtComments.Text
};
PrepAndPaintDB.EditnewJob(edited);
DialogResult = DialogResult.OK;
Close();
}
else
{
CheckStartDate();
CheckPaintDate();
PrepAndPaintModel newJob = new PrepAndPaintModel()
{
StartDate = startDate,
JobNumber = txtJobNumber.Text,
Prepper = txtPrepper.Text,
PaintDate = paintDate,
Painter = txtPainter.Text,
BodyOrDoors = cmboBodyDoors.Text,
Booth = cmboBooth.Text,
Colour = cmboColour.Text,
NewProcess = checkNewProcess.Checked,
WashBay = checkWashBay.Checked,
Comments = txtComments.Text
};
CheckIfExist(newJob);
}
}
}
private void btnClose_Click(object sender, EventArgs e)
{
List <AdminsModel> adminList = PrepAndPaintDB.GetAdmins();
if (adminList.Count == 0)
{
MessageBox.Show("Currently there are no admins. Please create an admin account to protect your data", "No Admins!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
Close();
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
JobsModel edited = new JobsModel()
{
Id = job.Id,
JobNumber = job.JobNumber,
Customer = txtCustomer.Text,
Model = txtModel.Text
};
PrepAndPaintDB.EditJob(edited);
jobId = edited.Id;
DialogResult = DialogResult.OK;
Close();
}
private void BtnRestoreDataBase_Click(object sender, EventArgs e)
{
PassWord passWord = new PassWord();
DialogResult result = passWord.ShowDialog();
if (result == DialogResult.OK)
{
openFileDialog1.FileName = "";
openFileDialog1.Filter = "PrepAndPaint databases (*.db)|*.db";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
PrepAndPaintDB.RestoreDataBase(openFileDialog1.FileName);
GetInfo();
}
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(txtNotes.Text))
{
SupervisorNotesModel editSupervisorNotes = new SupervisorNotesModel()
{
Date = dateTimePicker1.Value.Date,
Comments = txtNotes.Text
};
PrepAndPaintDB.SaveSuperVisorNotes(editSupervisorNotes);
this.DialogResult = DialogResult.OK;
Close();
}
else
{
MessageBox.Show("You didn't enter anything", "Error");
}
}
private void CheckIfExist(PrepAndPaintModel newJob)
{
List <PrepAndPaintModel> prepAndPaintModels = PrepAndPaintDB.GetNewData();
foreach (var item in prepAndPaintModels)
{
if (item.JobNumber == newJob.JobNumber && item.BodyOrDoors == newJob.BodyOrDoors)
{
MessageBox.Show($"Item: {newJob.BodyOrDoors} already exist for Job# {newJob.JobNumber} in the database!",
"Entry Exist!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
PrepAndPaintDB.AddnewJob(newJob);
jobId = newJob.Id;
DialogResult = DialogResult.OK;
Close();
}
private void DeleteNote()
{
if (dataGridView1.SelectedRows.Count > 0)
{
int selectedRowIndex = dataGridView1.SelectedCells[0].RowIndex;
int Id = (int)dataGridView1.Rows[selectedRowIndex].Cells[0].Value;
if (MessageBox.Show("Are you sure you wanted to delete this entry?", "Confirm delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
SupervisorNotesModel deleteId = new SupervisorNotesModel()
{
Id = Id
};
PrepAndPaintDB.DeleteSuperVisorNote(deleteId);
}
GetInfo();
}
else
{
MessageBox.Show("Sorry you need to select an entry to delete!", "Error", MessageBoxButtons.OK);
}
}
private void BtnDelete_Click(object sender, EventArgs e)
{
try
{
int selectedRowIndex = itemDataGridView.SelectedCells[0].RowIndex;
int id = (int)itemDataGridView.Rows[selectedRowIndex].Cells[0].Value;
string itemname = itemDataGridView.Rows[selectedRowIndex].Cells[1].Value.ToString();
if (MessageBox.Show($"Are you sure you wanted to delete Item: {itemname}?", "Confirm delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ItemsModel deleteId = new ItemsModel()
{
Id = id
};
PrepAndPaintDB.DeleteItem(deleteId);
PopulateListView();
}
}
catch (Exception)
{
MessageBox.Show("Nothing selected to delete!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void BtnOk_Click(object sender, EventArgs e)
{
string login = txtLogin.Text;
string password = txtPassWord.Text;
List <AdminsModel> adminList = PrepAndPaintDB.GetAdmins();
foreach (var name in adminList)
{
if (login == name.Name && password == name.Password)
{
adminLogin = true;
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("Sorry login or password wrong! Please try again", "Incorrect PassWord!", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPassWord.Clear();
txtPassWord.Focus();
return;
}
}
}
private void BtnAddColour_Click(object sender, EventArgs e)
{
if (IsValidate())
{
string colourAndCode = $"{txtColourCode.Text.ToUpper()} - {txtColour.Text.ToUpper()}";
JobColoursModel newJobColour = new JobColoursModel()
{
Colour = colourAndCode
};
List <JobColoursModel> colours = PrepAndPaintDB.GetJobColours();
foreach (var item in colours)
{
if (item.Colour == newJobColour.Colour)
{
MessageBox.Show($" Colour: {newJobColour.Colour} already exist", "Exist already!", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtColourCode.Focus();
return;
}
}
colourName = PrepAndPaintDB.AddColour(newJobColour);
DialogResult = DialogResult.OK;
}
}
private void BtnAddNewItem_Click(object sender, EventArgs e)
{
if (IsValidate())
{
char[] a = txtItemName.Text.ToLower().ToCharArray();
a[0] = char.ToUpper(a[0]);
ItemsModel newItem = new ItemsModel()
{
ItemName = new string(a)
};
itemsList = PrepAndPaintDB.GetItemsList();
foreach (var item in itemsList)
{
if (item.ItemName == newItem.ItemName)
{
MessageBox.Show($" Item: {newItem.ItemName} already exist", "Exit already!", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtItemName.Focus();
return;
}
}
itemName = PrepAndPaintDB.AddItem(newItem);
DialogResult = DialogResult.OK;
}
}
private void PopulateDataGrid()
{
adminDataGridView.DataSource = PrepAndPaintDB.GetAdmins();
adminDataGridView.Columns[0].Visible = false;
adminDataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
}
private void GetItemList()
{
cmboBodyDoors.DisplayMember = "ItemName";
cmboBodyDoors.DataSource = PrepAndPaintDB.GetItemsList();
}
private void PopulateListView()
{
itemDataGridView.DataSource = PrepAndPaintDB.GetItemsList();
itemDataGridView.Columns[0].Visible = false;
}
private void PopulateDataGrid()
{
colourDataGridView.DataSource = PrepAndPaintDB.GetJobColours();
colourDataGridView.Columns[0].Visible = false;
colourDataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
}
private void GetColours()
{
cmboColour.DisplayMember = "Colour";
cmboColour.DataSource = PrepAndPaintDB.GetJobColours();
cmboColour.SelectedIndex = -1;
}
private void GetInfo()
{
prepAndPaintModels = PrepAndPaintDB.GetJobLineItems(job.JobNumber);
jobInfoDataGrid.DataSource = prepAndPaintModels;
//SetDataGridView();
}
private void GetInfo()
{
prepAndPaintModels = PrepAndPaintDB.GetNewData();
dataGridView.DataSource = prepAndPaintModels;
SetDataGridView();
}
private void sortToolStripButton_Click(object sender, EventArgs e)
{
dataGridView.DataSource = PrepAndPaintDB.SortByDate();
SetDataGridView();
txtSearch.Clear();
}
