public bool IsExist(Category category) { string search = "SELECT * FROM Categories WHERE Name=('" + category.Name + "')"; bool result = _common.Reader(connection, search); return(result); }
private void addButton_Click(object sender, EventArgs e) { User user = new User(); if (adminRadioButton.Checked) { user.userType = 1; } else if (userRadioButton.Checked) { user.userType = 2; } if (userNameSetTextBox.Text != "" && passwordSetTextBox.Text != "" && RadioButtonValidation() == true) { user.userName = userNameSetTextBox.Text; user.PassWord = passwordSetTextBox.Text; try { //search for same category string search = "SELECT * FROM Users WHERE UserName='******' AND PassWord='******' "; bool result = _common.Reader(connection, search); if (result == true) { warningLabel.Text = "User already Exist!"; return; } else { //insert string userAddQuery = @"INSERT INTO Users VALUES('" + user.userName + "', '" + user.PassWord + "', '" + user.userType + "')"; _common.QueryOperation(userAddQuery, connection); MessageBox.Show("Added Successfully!!"); userNameSetTextBox.ResetText(); passwordSetTextBox.ResetText(); } //Update Function string fetch = "SELECT * FROM Users ORDER BY Id DESC"; _common.FillGrid(fetch, connection, userGridView); } catch (Exception exception) { Console.WriteLine(exception); throw; } } else { MessageBox.Show("Please Fill properly!!"); return; } }
private void saveButton_Click(object sender, EventArgs e) { if (itemTextBox.Text.Length > 2) { try { _item.CategoryId = Convert.ToInt32(categoryComboBox.SelectedValue); _item.CompanyId = Convert.ToInt32(companyComboBox.SelectedValue); _item.Name = itemTextBox.Text; _item.ReorderLevel = Convert.ToInt32(reorderLevelTextBox.Text); //search for same category string search = "SELECT * FROM items WHERE Name=('" + _item.Name + "')"; bool result = _common.Reader(connection, search); if (result == true) { warningLabel.Text = "Item already Exist!"; return; } else { string insert = @"INSERT INTO items VALUES('" + _item.Name + "','" + _item.ReorderLevel + "','" + _item.CategoryId + "','" + _item.CompanyId + "')"; bool isAdded = _common.QueryOperation(insert, connection); if (isAdded) { MessageBox.Show("Item Added"); companyComboBox.ResetText(); categoryComboBox.ResetText(); itemTextBox.Clear(); reorderLevelTextBox.Clear(); string insert3 = @"SELECT TOP 1 * FROM items ORDER BY id DESC"; connection.Open(); SqlCommand command1 = new SqlCommand(insert3, connection); int itemId = Convert.ToInt32(command1.ExecuteScalar()); connection.Close(); string insert2 = @"INSERT INTO stockin VALUES('" + _item.CategoryId + "','" + itemId + "',0,'" + _item.CompanyId + "')"; _common.QueryOperation(insert2, connection); } } } catch (Exception exception) { connection.Close(); MessageBox.Show(exception.Message); } } else { warningLabel.Text = "Name at least 3 characters."; } }
private void saveButton_Click(object sender, EventArgs e) { if (nameTextBox.Text.Length > 2) { try { _company.Name = nameTextBox.Text; //search for same category string search = "SELECT * FROM Companies WHERE Name=('" + _company.Name + "')"; bool result = _common.Reader(connection, search); if (result == true) { warningLabel.Text = "Category already Exist!"; return; } else { //insert category name to db string insert = "INSERT INTO Companies VALUES('" + _company.Name + "')"; bool isAdded = _common.QueryOperation(insert, connection); if (!isAdded) { return; } nameTextBox.Clear(); MessageBox.Show("Added Succesfully!"); CompanyForm_Load(this, null); } } catch (Exception exception) { MessageBox.Show(exception.Message); } } else { warningLabel.Text = "Name at least 3 character!"; return; } }