public void saveSaleInfo(StockManagement tempSale) { string connect = @"Server = DESKTOP-NRHJE6N\SQLEXPRESS; Database = Stock Management; Integrated Security = true"; SqlConnection sqlConnection = new SqlConnection(connect); string query = "INSERT INTO Sale (ItemName,Customer,Quantity, UnitPrice, TotalPrice) " + "VALUES('" + tempSale.itemName + "', '" + tempSale.customerName + "','" + tempSale.quantity + "', '" + tempSale.unitPrice + "','" + tempSale.totalPrice + "');"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); int rowsAffected = sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); if (rowsAffected > 0) { MessageBox.Show("Successfully Saved"); } else { MessageBox.Show("Something went wrong"); } //Data Grid View sqlConnection.Open(); SqlDataAdapter purchaseView = new SqlDataAdapter("SELECT * from Sale", sqlConnection); DataTable purchaseTable = new DataTable(); purchaseView.Fill(purchaseTable); saleDataGridView.DataSource = purchaseTable; populateComboBox(); populateCustomerComboBox(); }
public void saveCustomer(StockManagement customerInfo) { SqlConnection sqlConnection = new SqlConnection(connect); string sqlQuery = "INSERT INTO Customer(CustomerName,CustomerPhone)VALUES('" + customerInfo.customerName + "','" + customerInfo.customerPhone + "')"; SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlConnection.Open(); int rowAffected = sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); if (rowAffected >= 0) { MessageBox.Show("Data Save Successfully..!"); } else { MessageBox.Show("Data not Saved"); } sqlConnection.Open(); SqlDataAdapter customerView = new SqlDataAdapter("SELECT * from Customer", sqlConnection); DataTable customerTable = new DataTable(); customerView.Fill(customerTable); customerDataGridView.DataSource = customerTable; }
public void saveItem(StockManagement itemInfo) { SqlConnection sqlConnection = new SqlConnection(connect); string sqlQuery = "INSERT INTO Items(itemName,itemCode)VALUES('" + itemInfo.itemName + "','" + itemInfo.itemCode + "')"; SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlConnection.Open(); int rowAffected = sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); if (rowAffected >= 0) { MessageBox.Show("Data Save Successfully..!"); } else { MessageBox.Show("Data not Saved"); } sqlConnection.Open(); SqlDataAdapter itemView = new SqlDataAdapter("SELECT * from Items", sqlConnection); DataTable itemTable = new DataTable(); itemView.Fill(itemTable); itemDataGridView.DataSource = itemTable; }
public List <StockManagement> GetAllItems() { string queryString = @"Server = DESKTOP-NRHJE6N\SQLEXPRESS; Database = Stock Management; Integrated Security = true"; SqlConnection connection = new SqlConnection(queryString); string query = "SELECT * FROM Items;"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <StockManagement> items = new List <StockManagement>(); while (reader.Read()) { StockManagement item = new StockManagement(); item.itemName = reader["itemName"].ToString(); item.itemCode = reader["itemCode"].ToString(); items.Add(item); } return(items); }
private void customerSaveButton_Click(object sender, EventArgs e) { StockManagement customer = new StockManagement(); customer.customerName = customerNametextBox.Text; customer.customerPhone = customerPhoneTextBox.Text; saveCustomer(customer); }
private void saveItemButton_Click(object sender, EventArgs e) { StockManagement items = new StockManagement(); items.itemName = itemNameTextBox.Text; items.itemCode = itemCodeTextBox.Text; saveItem(items); }
private void button1_Click(object sender, EventArgs e) { StockManagement sale = new StockManagement(); sale.quantity = saleQuantityTextBox.Text; sale.itemName = saleItemNameComboBox.Text; sale.customerName = customerComboBox.Text; sale.unitPrice = saleUnitPriceTextBox.Text; int total = Convert.ToInt32(saleQuantityTextBox.Text) * Convert.ToInt32(saleUnitPriceTextBox.Text); sale.totalPrice = saleTotalPriceTextBox.Text = total.ToString(); saveSaleInfo(sale); }
private void savePurchaseButton_Click(object sender, EventArgs e) { StockManagement purchase = new StockManagement(); purchase.itemName = itemNameComboBox.Text; purchase.quantity = purchaseQuantityTextBox.Text; purchase.unitPrice = purchaseUnitPriceTextBox.Text; int total = Convert.ToInt32(purchaseQuantityTextBox.Text) * Convert.ToInt32(purchaseUnitPriceTextBox.Text); //purchase.totalPrice = total.ToString(); purchase.totalPrice = purchaseTotalPriceTextBox.Text = total.ToString(); savePurchase(purchase); //populateComboBox(); }
public List <StockManagement> GetAllICustomer() { SqlConnection sqlConnection = new SqlConnection(connect); string sqlQuery = "SELECT * FROM Customer"; SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlConnection.Open(); SqlDataReader reader = sqlCommand.ExecuteReader(); List <StockManagement> customers = new List <StockManagement>(); while (reader.Read()) { StockManagement customerName = new StockManagement(); customerName.customerName = reader["CustomerName"].ToString(); customers.Add(customerName); } return(customers); }
public List <StockManagement> GetAllItems() { SqlConnection sqlConnection = new SqlConnection(connect); string sqlQuery = "SELECT * FROM Items"; SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlConnection.Open(); SqlDataReader reader = sqlCommand.ExecuteReader(); List <StockManagement> purchase = new List <StockManagement>(); while (reader.Read()) { StockManagement purchaseItemName = new StockManagement(); purchaseItemName.itemName = reader["itemName"].ToString(); purchase.Add(purchaseItemName); } return(purchase); }
public List <StockManagement> GetAllIItem() { string connect = @"Server = DESKTOP-NRHJE6N\SQLEXPRESS; Database = Stock Management; Integrated Security = true"; SqlConnection sqlConnection = new SqlConnection(connect); string sqlQuery = "SELECT * FROM Items"; SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlConnection.Open(); SqlDataReader reader = sqlCommand.ExecuteReader(); List <StockManagement> sales = new List <StockManagement>(); while (reader.Read()) { StockManagement saleItemName = new StockManagement(); saleItemName.itemName = reader["itemName"].ToString(); sales.Add(saleItemName); } return(sales); }