public void createTreeview() { InventoryEntities invEntities = new InventoryEntities(); var grped = from it in invEntities.items join ct in invEntities.category_item on it.category_item_id equals ct.category_item_id group it by new { it.category_item_id, ct.category_item_code } into grp select grp; treeViewItem.Nodes.Clear(); foreach (var grouping in grped) { var nodeFor = treeViewItem.Nodes.Add(grouping.Key.category_item_code.ToString()); foreach (var item in grouping) { var subitem = nodeFor.Nodes.Add(item.item_code.ToString()); } } }
private void btnSearch_Click(object sender, EventArgs e) { using (InventoryEntities invEntities = new InventoryEntities()) { var query = default(IEnumerable<TransactionMasterViewModel>); ///get data TransactionMasters query = (from t in invEntities.transaction_master where t.transaction_code.Contains(txtTransaction_code.Text) && DateTime.Compare(t.transaction_date, dtpTransaction_fromdate.Value) >= 0 && DateTime.Compare(t.transaction_date, dtpTransaction_todate.Value) <= 0 && t.transaction_type_id == 2 select new TransactionMasterViewModel { transaction_master_id = t.transaction_master_id, transaction_code = t.transaction_code, transaction_date = t.transaction_date, transaction_type_id = t.transaction_type_id, transaction_type_code = t.transaction_type.transaction_type_code, received_warehouse_id = t.received_warehouse_id, received_warehouse_code = t.received_warehouse.warehouse_code, received_warehouse_name = t.received_warehouse.warehouse_name, delivered_warehouse_id = t.delivered_warehouse.warehouse_id, delivered_warehouse_code = t.delivered_warehouse.warehouse_code, delivered_warehouse_name = t.delivered_warehouse.warehouse_name, receiver = t.receiver, deliver = t.deliver, customer_id = t.customer_id, customer_code = t.customer.customer_code, customer_name = t.customer.customer_name, supplier_id = t.supplier_id, supplier_code = t.supplier.supplier_code, supplier_name = t.supplier.supplier_name, description = t.description, create_user = t.create_user, created_date = t.created_date, update_user = t.update_user, update_date = t.update_date }); dtTransaction_master = Utils.ToDataTable(query); dtTransaction_master.AcceptChanges(); this.grdView.DataSource = dtTransaction_master; } }
public static DataTable reportFinal(Int64 warehouseId, string itemCode, DateTime fromDate, DateTime toDate) { InventoryEntities invEntities = new InventoryEntities(); var result = default(IEnumerable<ReportViewModel>); var qrf = default(IEnumerable<ReportViewModel>); qrf = reportProcess(warehouseId, itemCode, DateTime.MinValue, fromDate != DateTime.MinValue ? fromDate.Date.AddDays(-1) : fromDate); var qrc = default(IEnumerable<ReportViewModel>); qrc = reportProcess(warehouseId, itemCode, fromDate, toDate); var qrl = default(IEnumerable<ReportViewModel>); qrl = reportProcess(warehouseId, itemCode, toDate != DateTime.MaxValue ? toDate.Date.AddDays(1) : fromDate, DateTime.MaxValue); var union = default(IEnumerable<ReportViewModel>); union = qrf.Union(qrc); union = union.Union(qrl).Distinct(); result = from ui in union join qft in qrf on new { ui.item_id, ui.warehouse_id } equals new { qft.item_id, qft.warehouse_id } into qrft from qf in qrft.DefaultIfEmpty() join qct in qrc on new { ui.item_id, ui.warehouse_id } equals new { qct.item_id, qct.warehouse_id } into qrct from qc in qrct.DefaultIfEmpty() join qlt in qrl on new { ui.item_id, ui.warehouse_id } equals new { qlt.item_id, qlt.warehouse_id } into qrlt from ql in qrlt.DefaultIfEmpty() join wh in invEntities.warehouses on ui.warehouse_id equals wh.warehouse_id join it in invEntities.items on ui.item_id equals it.item_id join cte in invEntities.category_item on it.category_item_id equals cte.category_item_id into ctet from ct in ctet.DefaultIfEmpty() join uts in invEntities.units on it.unit_id equals uts.unit_id into utst from ut in utst.DefaultIfEmpty() where ui.warehouse_id != null select new ReportViewModel { warehouse_id = ui.warehouse_id, warehouse_code = wh.warehouse_code, warehouse_name = wh.warehouse_name, item_id = ui.item_id, item_code = it.item_code, item_name = it.item_name, features = it.features, specifications = it.specifications, category_item_id = it.category_item_id, category_item_code = ct.category_item_code, category_item_name = ct.category_item_name, unit_id = it.unit_id, unit_code = ut.unit_code, unit_name = ut.unit_name, baseline = (qf == null || qf.remain == null ? 0 : qf.remain), grow = (qc == null || qc.grow == null ? 0 : qc.grow), decrease = (qc == null || qc.decrease == null ? 0 : qc.decrease), remain = (qc == null || qc.remain == null ? 0 : qc.remain), stock = (ql == null || ql.remain == null ? 0 : ql.remain), balance = (qf == null || qf.remain == null ? 0 : qf.remain) + (qc == null || qc.remain == null ? 0 : qc.remain) + (ql == null || ql.remain == null ? 0 : ql.remain) }; result = from rst in result group rst by new { rst.warehouse_id, rst.warehouse_code, rst.warehouse_name, rst.item_id, rst.item_code, rst.item_name, rst.features, rst.specifications, rst.category_item_id, rst.category_item_code, rst.category_item_name, rst.unit_id, rst.unit_code, rst.unit_name, rst.baseline, rst.grow, rst.decrease, rst.remain, rst.stock, rst.balance } into rs select new ReportViewModel { warehouse_id = rs.Key.warehouse_id, warehouse_code = rs.Key.warehouse_code, warehouse_name = rs.Key.warehouse_name, item_id = rs.Key.item_id, item_code = rs.Key.item_code, item_name = rs.Key.item_name, features = rs.Key.features, specifications = rs.Key.specifications, category_item_id = rs.Key.category_item_id, category_item_code = rs.Key.category_item_code, category_item_name = rs.Key.category_item_name, unit_id = rs.Key.unit_id, unit_code = rs.Key.unit_code, unit_name = rs.Key.unit_name, baseline = rs.Key.baseline, grow = rs.Key.grow, decrease = rs.Key.decrease, remain = rs.Key.remain, stock = rs.Key.stock, balance = rs.Key.balance }; DataTable dt = Utils.ToDataTable(result.Distinct()); return dt; }
public static IEnumerable<ReportViewModel> reportProcess(Int64 warehouseId, string itemCode, DateTime fromDate, DateTime toDate) { InventoryEntities invEntities = new InventoryEntities(); fromDate = new DateTime(fromDate.Year, fromDate.Month, fromDate.Day, 0, 0, 1); toDate = new DateTime(toDate.Year, toDate.Month, toDate.Day, 23, 59, 59); ///get data remain quantity var qrr = default(IEnumerable<ReportViewModel>); var qrg = default(IEnumerable<ReportViewModel>); ///get data grow quantity qrg = from m in invEntities.transaction_master join d in invEntities.transaction_detail on m.transaction_master_id equals d.transaction_master_id join i in invEntities.items on d.item_id equals i.item_id where m.transaction_date >= fromDate && m.transaction_date <= toDate && (warehouseId == Int64.MinValue || m.received_warehouse_id == warehouseId) && i.item_code.Contains(itemCode) group d by new { m.received_warehouse_id, d.item_id } into rs select new ReportViewModel { warehouse_id = rs.Key.received_warehouse_id, item_id = rs.Key.item_id, grow = rs.Sum(d => d.quantity) }; DataTable dtg = Utils.ToDataTable(qrg); var qrd = default(IEnumerable<ReportViewModel>); ///get data decrease quantity qrd = from m in invEntities.transaction_master join d in invEntities.transaction_detail on m.transaction_master_id equals d.transaction_master_id join i in invEntities.items on d.item_id equals i.item_id where m.transaction_date >= fromDate && m.transaction_date <= toDate && (warehouseId == Int64.MinValue || m.delivered_warehouse_id == warehouseId) && i.item_code.Contains(itemCode) group d by new { m.delivered_warehouse_id, d.item_id } into rs select new ReportViewModel { warehouse_id = rs.Key.delivered_warehouse_id, item_id = rs.Key.item_id, decrease = rs.Sum(d => d.quantity) }; DataTable dtd = Utils.ToDataTable(qrd); var union = default(IEnumerable<ReportViewModel>); union = qrg.Union(qrd).Distinct(); ///get data remain quantity /// qrr = from ui in union join qgt in qrg on new { ui.item_id, ui.warehouse_id } equals new { qgt.item_id, qgt.warehouse_id } into qgtt from qg in qgtt.DefaultIfEmpty() join qdt in qrd on new { ui.item_id, ui.warehouse_id } equals new { qdt.item_id, qdt.warehouse_id } into qdtt from qd in qdtt.DefaultIfEmpty() where ui.warehouse_id != null select new ReportViewModel { warehouse_id = ui.warehouse_id, item_id = ui.item_id, grow = (qg == null || qg.grow == null ? 0 : qg.grow), decrease = (qd == null || qd.decrease == null ? 0 : qd.decrease), remain = (qg == null || qg.grow == null ? 0 : qg.grow) - (qd == null || qd.decrease == null ? 0 : qd.decrease) }; DataTable dtr = Utils.ToDataTable(qrr); return qrr; }
private void btnDelete_Click(object sender, EventArgs e) { using (InventoryEntities invEntities = new InventoryEntities()) { /// ///delete transaction master /// var master = (transaction_master)invEntities.transaction_master.Where(m => m.transaction_master_id == TransactionMasterId).FirstOrDefault(); if (master != null) { /// /// delete transaction detail /// var details = from d in invEntities.transaction_detail.Where(m => m.transaction_master_id == TransactionMasterId) select d; invEntities.transaction_detail.RemoveRange(details); invEntities.SaveChanges(); invEntities.transaction_master.Remove(master); invEntities.SaveChanges(); } /// ///reset form value /// TransactionMasterId = Int64.MinValue; } }
private void InsertDate() { using (InventoryEntities invEntities = new InventoryEntities()) { var new_Master_Id = Int64.MinValue; #region insert or update master var udm = from m in invEntities.transaction_master where m.transaction_master_id == this.TransactionMasterId select m; transaction_master obj = udm.SingleOrDefault(); if (obj == null) obj = new transaction_master(); ///set data to object obj.transaction_code = txtTransaction_code.Text.Trim(); obj.transaction_type_id = 1; obj.transaction_date = dtpTransaction_date.Value; if ((Int64)cboReceived_warehouse.SelectedValue != Int64.MinValue) obj.received_warehouse_id = (Int64)cboReceived_warehouse.SelectedValue; obj.enabled = true; obj.receiver = txtReceiver.Text.Trim(); obj.deliver = txtDeliver.Text.Trim(); if ((Int64)cboSupplier.SelectedValue != Int64.MinValue) obj.supplier_id = (Int64)cboSupplier.SelectedValue; obj.created_date = DateTime.Now; obj.create_user = txtCreate_user.Text.Trim(); obj.update_date = DateTime.Now; obj.update_user = txtCreate_user.Text.Trim(); obj.description = txtDescription.Text.Trim(); if (obj.transaction_master_id == 0) invEntities.transaction_master.Add(obj); invEntities.SaveChanges(); new_Master_Id = obj.transaction_master_id; #endregion end insert master; #region insert detail and item for (int i = 0; i < dtTransaction_detail.Rows.Count; i++) { if (dtTransaction_detail.Rows[i].RowState == DataRowState.Added || dtTransaction_detail.Rows[i].RowState == DataRowState.Modified) { /// ///Insert or update item /// var temmId = string.IsNullOrEmpty(dtTransaction_detail.Rows[i][colItemId.ColumnName].ToString()) ? Int64.MinValue : (Int64)dtTransaction_detail.Rows[i][colItemId.ColumnName]; var udi = from it in invEntities.items where it.item_id == temmId select it; item objItem = udi.SingleOrDefault(); if (objItem == null) objItem = new item(); objItem.item_code = dtTransaction_detail.Rows[i][colItemCode.ColumnName].ToString(); objItem.item_name = dtTransaction_detail.Rows[i][colItemName.ColumnName].ToString(); objItem.unit_id = (Int64)dtTransaction_detail.Rows[i][colUnitId.ColumnName]; objItem.category_item_id = (Int64)dtTransaction_detail.Rows[i][colCategoryItemId.ColumnName]; objItem.specifications = dtTransaction_detail.Rows[i][colSpecifications.ColumnName].ToString(); objItem.features = dtTransaction_detail.Rows[i][colFeatures.ColumnName].ToString(); objItem.enabled = true; objItem.create_user = obj.create_user; objItem.update_user = obj.create_user; objItem.created_date = DateTime.Now; objItem.update_date = DateTime.Now; if (objItem.item_id == 0) invEntities.items.Add(objItem); invEntities.SaveChanges(); /// /// insert or update transaction_detail /// var detailId = string.IsNullOrEmpty(dtTransaction_detail.Rows[i][coltransaction_detail_id.DataPropertyName].ToString()) ? Int64.MinValue : (Int64)dtTransaction_detail.Rows[i][coltransaction_detail_id.DataPropertyName]; var udd = from d in invEntities.transaction_detail where d.transaction_detail_id == detailId select d; transaction_detail objDetail = udd.SingleOrDefault(); if (objDetail == null) objDetail = new transaction_detail(); objDetail.transaction_master_id = obj.transaction_master_id; objDetail.category_item_id = (Int64)dtTransaction_detail.Rows[i][colCategoryItemId.ColumnName]; objDetail.item_id = objItem.item_id; if (!string.IsNullOrEmpty(dtTransaction_detail.Rows[i][colQuantity.ColumnName].ToString())) objDetail.quantity = (decimal)dtTransaction_detail.Rows[i][colQuantity.ColumnName]; if (!string.IsNullOrEmpty(dtTransaction_detail.Rows[i][colUnitId.ColumnName].ToString())) objDetail.unit_id = (Int64)dtTransaction_detail.Rows[i][colUnitId.ColumnName]; objDetail.description = dtTransaction_detail.Rows[i][colDescription.ColumnName].ToString(); objDetail.create_user = obj.create_user; objDetail.update_user = obj.create_user; objDetail.created_date = DateTime.Now; objDetail.update_date = DateTime.Now; if (objDetail.transaction_detail_id == 0) { invEntities.transaction_detail.Add(objDetail); } invEntities.SaveChanges(); } else if (dtTransaction_detail.Rows[i].RowState == DataRowState.Deleted) { } } #endregion end insert detail and item #region reload data if (new_Master_Id != TransactionMasterId) { this.TransactionMasterId = new_Master_Id; } else { getDataCombo(); getDataComboForGridView(); GetDataById(); } #endregion end reload data } }
private void grdView_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (this.grdView.Columns[e.ColumnIndex].DataPropertyName == colItemId.ColumnName) { using (InventoryEntities invEntities = new InventoryEntities()) { Int64 itemId = (Int64)this.grdView.CurrentCell.Value; var result = (from i in invEntities.items where i.item_id == itemId select i).FirstOrDefault(); this.grdView.CurrentRow.Cells[3].Value = result.item_code; this.grdView.CurrentRow.Cells[4].Value = result.item_name; this.grdView.CurrentRow.Cells[6].Value = result.category_item_id; this.grdView.CurrentRow.Cells[7].Value = result.unit_id; this.grdView.CurrentRow.Cells[9].Value = result.features; this.grdView.CurrentRow.Cells[10].Value = result.specifications; } } }
private void getDataComboForGridView() { using (InventoryEntities invEntities = new InventoryEntities()) { ///get data CategoryItem List<category_item> listC = new List<category_item>(); var resultC = (from c in invEntities.category_item orderby c.category_item_code select c); listC.AddRange(new category_item[] { new category_item { category_item_id = Int64.MinValue, category_item_code = "<Select a subject>", category_item_name = "<Select a subject>" } }); foreach (category_item item in resultC) listC.Add(item); DataTable tblResultC = Utils.ConvertToDataTable(listC); dtCategory_item.Clear(); dtCategory_item.Merge(tblResultC); dtCategory_item.AcceptChanges(); ///get data Unit List<unit> listU = new List<unit>(); var resultU = (from u in invEntities.units orderby u.unit_code select u); listU.AddRange(new unit[] { new unit { unit_id = Int64.MinValue, unit_code = "<Select a subject>", unit_name = "<Select a subject>" } }); foreach (unit item in resultU) listU.Add(item); DataTable tblResultU = Utils.ConvertToDataTable(listU); dtUnit.Clear(); dtUnit.Merge(tblResultU); dtUnit.AcceptChanges(); ///get data Item List<item> listI = new List<item>(); var resultI = (from i in invEntities.items orderby i.item_code select i); listI.AddRange(new item[] { new item { item_id = Int64.MinValue, item_code = "<Select a subject>", item_name = "<Select a subject>" } }); foreach (item item in resultI) listI.Add(item); DataTable tblResultI = Utils.ConvertToDataTable(listI); dtItem.Clear(); dtItem.Merge(tblResultI); dtItem.AcceptChanges(); } }
private void getDataCombo() { using (InventoryEntities invEntities = new InventoryEntities()) { ///get data Supplier List<supplier> listS = new List<supplier>(); var resultS = (from s in invEntities.suppliers orderby s.supplier_code select s); listS.AddRange(new supplier[] { new supplier { supplier_id = Int64.MinValue, supplier_code = "<Select a subject>", supplier_name = "<Select a subject>" } }); foreach (supplier item in resultS) listS.Add(item); cboSupplier.DataSource = listS; cboSupplier.ValueMember = "supplier_id"; cboSupplier.DisplayMember = "supplier_code"; ///get data Warehouses List<warehouse> listW = new List<warehouse>(); var resultW = (from w in invEntities.warehouses orderby w.warehouse_code select w); listW.AddRange(new warehouse[] { new warehouse { warehouse_id = Int64.MinValue, warehouse_code = "<Select a subject>", warehouse_name = "<Select a subject>" } }); foreach (warehouse item in resultW) listW.Add(item); cboReceived_warehouse.DataSource = listW; cboReceived_warehouse.ValueMember = "warehouse_id"; cboReceived_warehouse.DisplayMember = "warehouse_code"; } }
private void GetDataById() { using (InventoryEntities invEntities = new InventoryEntities()) { ///get data table TransactionMasters var result = (from m in invEntities.transaction_master where m.transaction_master_id == TransactionMasterId select m).FirstOrDefault(); if (result != null) { txtTransaction_code.Text = result.transaction_code; dtpTransaction_date.Value = result.transaction_date; cboReceived_warehouse.SelectedValue = result.received_warehouse_id == null ? Int64.MinValue : result.received_warehouse_id; cboSupplier.SelectedValue = result.supplier_id == null ? Int64.MinValue : result.supplier_id; txtDeliver.Text = result.deliver; txtReceiver.Text = result.receiver; txtCreate_user.Text = result.create_user; txtDescription.Text = result.description; } else { txtTransaction_code.Text =string.Empty; dtpTransaction_date.Value = DateTime.Now; cboReceived_warehouse.SelectedValue = Int64.MinValue; cboSupplier.SelectedValue = Int64.MinValue; txtDescription.Text = string.Empty; txtDeliver.Text = string.Empty; txtReceiver.Text = string.Empty; txtCreate_user.Text = string.Empty; } ///get data table TransactionDetails var query = default(IEnumerable<TransactionDetailViewModel>); query = from d in invEntities.transaction_detail where d.transaction_master_id == TransactionMasterId select new TransactionDetailViewModel { transaction_master_id = d.transaction_master_id, transaction_detail_id = d.transaction_detail_id, category_item_id = d.category_item_id, category_item_code = d.category_item.category_item_code, category_item_name = d.category_item.category_item_name, item_id = d.item_id, item_code = d.item.item_code, item_name = d.item.item_name, price = d.price, unit_id = d.unit_id, unit_code = d.unit.unit_code, unit_name = d.unit.unit_name, quantity = d.quantity, total_price = d.total_price, percent_charges = d.total_price, total_charges = d.total_charges, total_amount = d.total_amount, description = d.description, create_user = d.create_user, created_date = d.created_date, features = d.item.features, specifications = d.item.specifications }; dtTransaction_detail.Rows.Clear(); dtTransaction_detail = Utils.ToDataTable(query); dtTransaction_detail.AcceptChanges(); if (dtTransaction_detail != null && dtTransaction_detail.Rows.Count > 0) this.grdView.DataSource = dtTransaction_detail; } }
private void grdView_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (FormEvents == 1 || FormEvents == 2) { if (this.grdView.Columns[e.ColumnIndex].DataPropertyName == colItemId.ColumnName) { using (InventoryEntities invEntities = new InventoryEntities()) { Int64 itemId = (Int64)this.grdView.CurrentCell.Value; var result = (from i in invEntities.items where i.item_id == itemId select i).FirstOrDefault(); this.grdView.CurrentRow.Cells[3].Value = result.item_code; this.grdView.CurrentRow.Cells[4].Value = result.item_name; this.grdView.CurrentRow.Cells[6].Value = result.category_item_id; this.grdView.CurrentRow.Cells[7].Value = result.unit_id; this.grdView.CurrentRow.Cells[9].Value = result.features; this.grdView.CurrentRow.Cells[10].Value = result.specifications; for (int i = 0; i < dtItem.Rows.Count; i++) { if ((Int64)dtItem.Rows[i][colItemId.ColumnName] == itemId && dtItem.Rows[i]["balance"] != null) { this.grdView.CurrentRow.Cells[8].Value = dtItem.Rows[i]["balance"]; break; } } } } } }
private void getDataComboForGridView() { using (InventoryEntities invEntities = new InventoryEntities()) { ///get data CategoryItem List<category_item> listC = new List<category_item>(); var resultC = (from c in invEntities.category_item orderby c.category_item_code select c); listC.AddRange(new category_item[] { new category_item { category_item_id = Int64.MinValue, category_item_code = "<Select a subject>", category_item_name = "<Select a subject>" } }); foreach (category_item item in resultC) listC.Add(item); DataTable tblResultC = Utils.ConvertToDataTable(listC); dtCategory_item.Clear(); dtCategory_item.Merge(tblResultC); dtCategory_item.AcceptChanges(); ///get data Unit List<unit> listU = new List<unit>(); var resultU = (from u in invEntities.units orderby u.unit_code select u); listU.AddRange(new unit[] { new unit { unit_id = Int64.MinValue, unit_code = "<Select a subject>", unit_name = "<Select a subject>" } }); foreach (unit item in resultU) listU.Add(item); DataTable tblResultU = Utils.ConvertToDataTable(listU); dtUnit.Clear(); dtUnit.Merge(tblResultU); dtUnit.AcceptChanges(); /// ///get data Item /// if (FormEvents == 1 || FormEvents == 2) { Int64 warehouseId = -1; if (cboDelivered_warehouse.SelectedValue != null && (Int64)cboDelivered_warehouse.SelectedValue != Int64.MinValue) warehouseId = (Int64)cboDelivered_warehouse.SelectedValue; var dtReport = ReportView.reportFinal(warehouseId, string.Empty, DateTime.MinValue, DateTime.MinValue); dtItem.Clear(); dtItem.Merge(dtReport); dtItem.AcceptChanges(); } else { List<item> listI = new List<item>(); var resultI = (from i in invEntities.items orderby i.item_code select i); listI.AddRange(new item[] { new item { item_id = Int64.MinValue, item_code = "<Select a subject>", item_name = "<Select a subject>" } }); foreach (item item in resultI) listI.Add(item); DataTable tblResultI = Utils.ConvertToDataTable(listI); dtItem.Clear(); dtItem.Merge(tblResultI); dtItem.AcceptChanges(); } } }
private void getDataCombo() { using (InventoryEntities invEntities = new InventoryEntities()) { ///get data Warehouses List<warehouse> listR = new List<warehouse>(); listR.AddRange(new warehouse[] { new warehouse { warehouse_id = Int64.MinValue, warehouse_code = "<Select a subject>", warehouse_name = "<Select a subject>" } }); ///get data Warehouses List<warehouse> listD = new List<warehouse>(); listD.AddRange(new warehouse[] { new warehouse { warehouse_id = Int64.MinValue, warehouse_code = "<Select a subject>", warehouse_name = "<Select a subject>" } }); var resultW = (from w in invEntities.warehouses orderby w.warehouse_code select w); foreach (warehouse item in resultW) { listR.Add(item); listD.Add(item); } cboReceived_warehouse.DataSource = listR; cboReceived_warehouse.ValueMember = "warehouse_id"; cboReceived_warehouse.DisplayMember = "warehouse_code"; cboDelivered_warehouse.DataSource = listD; cboDelivered_warehouse.ValueMember = "warehouse_id"; cboDelivered_warehouse.DisplayMember = "warehouse_code"; } }
private void cboDelivered_warehouse_SelectedValueChanged(object sender, EventArgs e) { if (FormEvents == 1 || FormEvents == 2) { Int64 warehouseId = -1; if (cboDelivered_warehouse.SelectedValue != null && (Int64)cboDelivered_warehouse.SelectedValue != Int64.MinValue) warehouseId = (Int64)cboDelivered_warehouse.SelectedValue; var dtReport = ReportView.reportFinal(warehouseId, string.Empty, DateTime.MinValue, DateTime.MinValue); dtItem.Clear(); dtItem.Merge(dtReport); dtItem.AcceptChanges(); } else { InventoryEntities invEntities = new InventoryEntities(); List<item> listI = new List<item>(); var resultI = (from i in invEntities.items orderby i.item_code select i); listI.AddRange(new item[] { new item { item_id = Int64.MinValue, item_code = "<Select a subject>", item_name = "<Select a subject>" } }); foreach (item item in resultI) listI.Add(item); DataTable tblResultI = Utils.ConvertToDataTable(listI); dtItem.Clear(); dtItem.Merge(tblResultI); dtItem.AcceptChanges(); } }