private void ProductIDTextBox_KeyDown(object sender, KeyEventArgs e)
{
switch (e.Key)
{
case Key.Enter: {
if (!int.TryParse(this.ProductIDTextBox.Text, out int prodID))
{
MessageBox.Show("Введите корректный код!");
this.ProductIDTextBox.Focus();
return;
} //if
try {
using (SmallBusinessDBEntities context = new SmallBusinessDBEntities()) {
this.ProductTitleLabel.Content = (object)context.Products.FirstOrDefault(g => g.productID == prodID).productTitle;
} //using
PriceTextBox.Focus();
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
break;
case Key.F1: {
if (!short.TryParse(this.GroupTextBox.Text, out short groupID))
{
MessageBox.Show("Введите корректную группу!");
this.GroupTextBox.Focus();
return;
} //if
GetProductWindow gpw = new GetProductWindow(groupID);
if (gpw.ShowDialog() == true)
{
this.ProductIDTextBox.Text = gpw.currentProduct.productID.ToString();
try {
using (SmallBusinessDBEntities context = new SmallBusinessDBEntities()) {
this.ProductTitleLabel.Content = (object)context.Products.FirstOrDefault(g => g.productID == gpw.currentProduct.productID).productTitle;
} //using
PriceTextBox.Focus();
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
} //if
}
break;
default: break;
}//switch
}
private bool ValidateForm()
{
if (!Regex.Match(TitleTextBox.Text, @"^\D{1,20}$").Success)
{
MessageBox.Show("Title must consist of at least 1 character and not exceed 20 characters!");
TitleTextBox.Focus();
return(false);
}
if (!Regex.Match(DescriptionTextBox.Text, @"^\D{1,200}$").Success)
{
MessageBox.Show("Description must consist of at least 1 character and not exceed 200 characters!");
DescriptionTextBox.Focus();
return(false);
}
if (CategoryComboBox.SelectedItem == null)
{
MessageBox.Show("Please select category");
return(false);
}
if (ProducerComboBox.SelectedItem == null)
{
MessageBox.Show("Please select categoty");
return(false);
}
if (!Regex.Match(WeightTextBox.Text, @"^[0-9]*(?:\,[0-9]*)?$").Success)
{
MessageBox.Show("Invalid weight! Check the data you've entered!");
WeightTextBox.Focus();
return(false);
}
if (!Regex.Match(ComponentsTextBox.Text, @"^\D{1,200}$").Success)
{
MessageBox.Show("Components must consist of at least 1 character and not exceed 200 characters!");
ComponentsTextBox.Focus();
return(false);
}
if (!Regex.Match(PriceTextBox.Text, @"^[0-9]*(?:\,[0-9]*)?$").Success)
{
MessageBox.Show("Invalid price! Check the data you've entered!");
PriceTextBox.Focus();
return(false);
}
return(true);
}
// save button clicked
private void SaveButton_Click(object sender, EventArgs e)
{
if (TitleTextBox.ForeColor != Color.Red && AuthorTextBox.ForeColor != Color.Red &&
ISBNTextBox.ForeColor != Color.Red && PriceTextBox.ForeColor != Color.Red)
{
// adding new book
if (addNewBookMode)
{
DialogResult save = MessageBox.Show("Do you want to save the book?", "Add New Book", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (save == DialogResult.Yes)
{
scmd = new SqlCommand("select count(*) from Books where (ISBN = @isbn)", connection);
scmd.Parameters.AddWithValue("@isbn", ISBNTextBox.Text);
connection.Open();
int exists = (int)scmd.ExecuteScalar(); // check if entered isnb is unique
connection.Close();
if (exists == 0)
{
scmd = new SqlCommand("insert into Books(Title, Author, ISBN, Price) Values(@title, @author, @isbn, @price)", connection);
connection.Open();
scmd.Parameters.AddWithValue("@title", TitleTextBox.Text);
scmd.Parameters.AddWithValue("@author", AuthorTextBox.Text);
scmd.Parameters.AddWithValue("@isbn", ISBNTextBox.Text);
scmd.Parameters.AddWithValue("@price", PriceTextBox.Text);
scmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show("The Book Was Added Successfully.");
DisplayBooks(); // refresh combobox values
ResetAll();
BooksComboBox.Enabled = true;
}
else
{
MessageBox.Show("Provided ISBN code already exists in the database.", "Invalid ISBN Code", MessageBoxButtons.OK, MessageBoxIcon.Error);
ISBNTextBox.Focus();
}
}
}
// updating existing book
if (updateBookMode)
{
DialogResult update = MessageBox.Show("Do you want to update the book?", "Update Existing Book", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (update == DialogResult.Yes)
{
string cmdText = "UPDATE Books SET Title = @title, Author = @author, Price = @price WHERE ISBN = @isbn";
scmd = new SqlCommand(cmdText, connection);
connection.Open();
scmd.Parameters.AddWithValue("@title", TitleTextBox.Text);
scmd.Parameters.AddWithValue("@author", AuthorTextBox.Text);
scmd.Parameters.AddWithValue("@isbn", ISBNTextBox.Text);
scmd.Parameters.AddWithValue("@price", PriceTextBox.Text);
scmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show("The Book Was Updated Successfully.");
DisplayBooks(); // refresh combobox values
ResetAll();
}
}
}
else
{
MessageBox.Show("Make sure you have provided valid inputs for all the fields", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (TitleTextBox.ForeColor == Color.Red)
{
TitleTextBox.Focus();
}
if (AuthorTextBox.ForeColor == Color.Red)
{
AuthorTextBox.Focus();
}
if (ISBNTextBox.ForeColor == Color.Red)
{
ISBNTextBox.Focus();
}
if (PriceTextBox.ForeColor == Color.Red)
{
PriceTextBox.Focus();
}
}
}
void UnitDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
this.DisplayPrice();
PriceTextBox.Focus();
}
private void AddButton_Click(object sender, EventArgs e)
{
if (venta == null)
{
MessageBox.Show("Debe asignar un cliente");
ClienteTextBox.Focus();
return;
}
if (IdTextBox.Text == string.Empty)
{
MessageBox.Show("Debe ingresar un ID");
IdTextBox.Focus();
return;
}
int id = 0;
if (!int.TryParse(IdTextBox.Text, out id))
{
MessageBox.Show("Debe ingresar un ID numerico entero");
IdTextBox.Focus();
return;
}
if (id <= 0)
{
MessageBox.Show("Debe ingresar un ID mayor a cero");
IdTextBox.Focus();
return;
}
if (DescriptionTextBox.Text == string.Empty)
{
MessageBox.Show("Debe ingresar una Descripcion");
DescriptionTextBox.Focus();
return;
}
decimal price = 0;
if (!decimal.TryParse(PriceTextBox.Text, out price))
{
MessageBox.Show("Debe ingresar un Precio numerico entero");
PriceTextBox.Focus();
return;
}
if (price <= 0)
{
MessageBox.Show("Debe ingresar un Precio mayor a cero");
PriceTextBox.Focus();
return;
}
int amount = 0;
if (!int.TryParse(AmountTextBox.Text, out amount))
{
MessageBox.Show("Debe ingresar una Cantidad numerico entero");
AmountTextBox.Focus();
return;
}
if (amount <= 0)
{
MessageBox.Show("Debe ingresar una Cantidad mayor a cero");
AmountTextBox.Focus();
return;
}
Article article = new Article();
article.ID = id;
article.Description = DescriptionTextBox.Text;
article.Price = price;
article.Amount = amount;
venta.AddProduct(article);
DetailsDataGridView.DataSource = null;
DetailsDataGridView.DataSource = venta.Products;
IdTextBox.Text = string.Empty;
DescriptionTextBox.Text = string.Empty;
PriceTextBox.Text = string.Empty;
AmountTextBox.Text = string.Empty;
IdTextBox.Focus();
}
