/// <summary>
/// Get data values from database.
/// </summary>
private void FetchDBListData()
{
using (var paperStockManagementDB = new PaperStockManagementDBEntities())
{
foreach (BreakingForce breakingForce in paperStockManagementDB.BreakingForces.ToList())
{
BFList.Add(breakingForce.Value);
}
foreach (GSM gsm in paperStockManagementDB.GSMs.ToList())
{
GSMList.Add(gsm.Value);
}
foreach (Client client in paperStockManagementDB.Clients.ToList())
{
PartyNameList.Add(client.Name);
}
foreach (Stock stockInventory in
paperStockManagementDB.Stocks.ToList())
{
string stockFormat = string.Format(Constant.StockDataFormat,
stockInventory.BreakingForce, stockInventory.GSM,
stockInventory.Size, stockInventory.Weight,
stockInventory.Quantity);
ExStockList.Add(stockFormat);
}
}
}
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>
/// Initialize insatance(constructor) of AddPartyDetail.
/// </summary>
public AddPartyDetail()
{
InitializeComponent();
// This line of code is generated by Data Source Configuration Wizard
// Instantiate a new DBContext
paperStockManagementDB = new PaperStockManagementDBEntities();
// Call the LoadAsync method to asynchronously get the data for the given DbSet from the database.
paperStockManagementDB.Clients.LoadAsync().ContinueWith(loadTask =>
{
// Bind data to control when loading complete
grdCtrlAddParty.DataSource = paperStockManagementDB.Clients.Local.ToBindingList();
}, System.Threading.Tasks.TaskScheduler.FromCurrentSynchronizationContext());
}
private Stock GetStockInventoryFromInventoryByID(int id)
{
using (var paperStockManagementDB = new PaperStockManagementDBEntities())
{
foreach (Stock stocks in
paperStockManagementDB.Stocks.ToList())
{
if (stocks.ID == id)
{
return(stocks);
}
}
}
return(null);
}
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 btnAddOrder_Click(object sender, EventArgs e)
{
//Mock rows added.
DataRow row = dataTable.NewRow();
row[1] = cmbAddOrderPartyName.SelectedValue;
using (var paperStockManagementDB = new PaperStockManagementDBEntities())
{
Stock stock = paperStockManagementDB.Stocks.ToList()[cmbAddOrderDetail.SelectedIndex];
row[0] = stock.ID;
row[2] = stock.BreakingForce;
row[3] = stock.GSM;
row[4] = stock.Size;
row[5] = stock.Weight;
row[6] = stock.Quantity;
Client client = paperStockManagementDB.Clients.ToList()[cmbAddOrderPartyName.SelectedIndex];
row[7] = client.ID;
}
dataTable.Rows.Add(row);
gridControl1.RefreshDataSource();
}
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();
}
