/// <summary> /// Occurs when ADD button will be pressed. /// </summary> /// <param name="sender">Insatance of Object.</param> /// <param name="e">Instance of EventArgs.</param> private void btnAddBF_Click(object sender, EventArgs e) { // Add new GSM value to data-base. using (paperStockManagementDB) { var breakingForce = new BreakingForce(); breakingForce.Value = Int32.Parse(txtAddBF.Text); paperStockManagementDB.BreakingForces.Add(breakingForce); paperStockManagementDB.SaveChanges(); PaperStockManagement.BFList.Add(breakingForce.Value); } this.Close(); }
/// <summary> /// Occurs when ADD button will be pressed. /// </summary> /// <param name="sender">Insatance of Object.</param> /// <param name="e">Instance of EventArgs.</param> private void btnAddGSM_Click(object sender, EventArgs e) { // Add new Breaking-force value to data-base. using (paperStockManagementDB) { var gSM = new GSM(); gSM.Value = Int32.Parse(txtAddGSM.Text); paperStockManagementDB.GSMs.Add(gSM); paperStockManagementDB.SaveChanges(); PaperStockManagement.GSMList.Add(gSM.Value); } this.Close(); }
private void button1_Click(object sender, EventArgs e) { using (var paperStockManagementDB = new PaperStockManagementDBEntities()) { for (int i = 0; i < grdViewDeleteOrder.DataRowCount; i++) { if (grdViewDeleteOrder.IsRowSelected(i)) { //Delete order var orderID = int.Parse(grdViewDeleteOrder.GetRowCellValue(i, "ID").ToString()); Order order = paperStockManagementDB.Orders.First(j => j.ID == orderID); paperStockManagementDB.Orders.Remove(order); //Add stock quantity back to main stock paperStockManagementDB.Stocks.First(j => j.ID == order.StockID).Quantity += order.Quantity; } } paperStockManagementDB.SaveChanges(); } ProjectStockManagement.PaperStockManagementDB.PaperStockManagementDBEntities dbContext = new ProjectStockManagement.PaperStockManagementDB.PaperStockManagementDBEntities(); // Call the LoadAsync method to asynchronously get the data for the given DbSet from the database. dbContext.Orders.LoadAsync().ContinueWith(loadTask => { // Bind data to control when loading complete grdCtrlDeleteOrder.DataSource = dbContext.Orders.Local.ToBindingList(); }, System.Threading.Tasks.TaskScheduler.FromCurrentSynchronizationContext()); grdCtrlDeleteOrder.RefreshDataSource(); grdCtrlDeleteOrder.Refresh(); }
/// <summary> /// Occurs when ADD PARTY DETAILS button will be pressed. /// </summary> /// <param name="sender">Insatance of Object.</param> /// <param name="e">Instance of EventArgs.</param> private void addPartyDetails_Click(object sender, EventArgs e) { // Add new Party details to data-base. using (paperStockManagementDB) { var client = new Client(); client.Name = txtName.Text; client.Contact = decimal.Parse(txtContactNo.Text); client.Address = txtAddress.Text; client.Email = txtEmail.Text; paperStockManagementDB.Clients.Add(client); paperStockManagementDB.SaveChanges(); PaperStockManagement.PartyNameList.Add(client.Name); } this.Close(); }
private void dispatchOrderButton_Click(object sender, EventArgs e) { using (var paperStockManagementDB = new PaperStockManagementDBEntities()) { for (int i = 0; i < dispatchOrderGridView.DataRowCount; i++) { if (dispatchOrderGridView.IsRowSelected(i)) { //Get order id var orderID = int.Parse(dispatchOrderGridView.GetRowCellValue(i, "OrderID").ToString()); //Remove add oreder AddOrder addOrder = paperStockManagementDB.AddOrders.First(j => j.OrderID == orderID); paperStockManagementDB.AddOrders.Remove(addOrder); //Dispatch order DispatchOrder dispatchOrder = new DispatchOrder(); dispatchOrder.Date = dateTimePicker2.Value; dispatchOrder.OrderID = addOrder.OrderID; dispatchOrder.DriverName = txtDriverName.Text; dispatchOrder.DriverNumber = txtDriverContactNo.Text; dispatchOrder.VehicleNumber = txtVehicleNumber.Text; //Add Dispatch order paperStockManagementDB.DispatchOrders.Add(dispatchOrder); } } paperStockManagementDB.SaveChanges(); } PaperStockManagementDBEntities dbContext = new PaperStockManagementDBEntities(); // Call the LoadAsync method to asynchronously get the data for the given DbSet from the database. dbContext.AddOrders.LoadAsync().ContinueWith(loadTask => { // Bind data to control when loading complete dispatchOrderGridControl.DataSource = dbContext.AddOrders.Local.ToBindingList(); }, System.Threading.Tasks.TaskScheduler.FromCurrentSynchronizationContext()); dispatchOrderGridControl.RefreshDataSource(); }
/// <summary> /// Save all the data on button click. /// </summary> /// <param name="sender">Instance of Object.</param> /// <param name="e">Instance of EventsArgs.</param> private void btnSave_Click(object sender, EventArgs e) { using (var paperStockManagementDB = new PaperStockManagementDBEntities()) { // Add new stock values to database. var stock = new Stock(); stock.BreakingForce = Int32.Parse(cmbBF.SelectedItem.ToString()); stock.GSM = Int32.Parse(cmbGSM.SelectedItem.ToString()); stock.Weight = Int32.Parse(txtWeight.Text); stock.Size = Int32.Parse(txtSize.Text); stock.Quantity = Int32.Parse(txtStockQuantity.Text); paperStockManagementDB.Stocks.Add(stock); paperStockManagementDB.SaveChanges(); string stockFormat = string.Format(Constant.StockDataFormat, stock.BreakingForce, stock.GSM, stock.Size, stock.Weight, stock.Quantity); ExStockList.Add(stockFormat); } }
private void btnSaveOrder_Click(object sender, EventArgs e) { using (var paperStockManagementDB = new PaperStockManagementDBEntities()) { for (int i = 0; i < addOrderGridView.DataRowCount; i++) { Order order = new Order(); order.AddedDate = DateTime.Now; var id = int.Parse(addOrderGridView.GetRowCellValue(i, "StockID").ToString()); Stock stock = GetStockInventoryFromInventoryByID(id); int quantity = int.Parse(addOrderGridView.GetRowCellValue(i, "Quantity").ToString()); paperStockManagementDB.Stocks.Find(stock.ID).Quantity -= quantity; order.StockID = stock.ID; order.Quantity = quantity; order.ClientID = int.Parse(addOrderGridView.GetRowCellValue(i, "ClientID").ToString()); paperStockManagementDB.Orders.Add(order); AddOrder addOrder = new AddOrder(); addOrder.Order = order; paperStockManagementDB.AddOrders.Add(addOrder); } paperStockManagementDB.SaveChanges(); } dataTable.Rows.Clear(); gridControl1.RefreshDataSource(); }