/// <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();
}