public override void ExecuteDelete()
{
if (SelectedGoodsReceipt != null && ConfirmDelete())
{
GoodsReceiptHelper.DeleteGoodsReceipt(SelectedGoodsReceipt);
SaveChanges();
GoodsReceipts.Remove(SelectedGoodsReceipt);
}
}
public async static Task DeleteGoodsReceipt(GoodsReceipt itemPara)
{
using (var db = new SalesContext())
{
//if (itemPara.Store != null) //NOT DELETE - IMPORTANT
// db.Stores.Attach(itemPara.Store);
//if (itemPara.Product != null) //NOT DELETE - IMPORTANT
// db.Products.Attach(itemPara.Product);
db.Entry(itemPara).State = EntityState.Unchanged; //NOT DELETE - IMPORTANT
GoodsReceipts.Remove(itemPara);
db.Entry(itemPara).State = EntityState.Deleted;
await UpdateDatabase(db);
}
}
public async static Task GetAllProducts()
{
Products.Clear();
Categories.Clear();
ProductPrices.Clear();
Stores.Clear();
GoodsReceipts.Clear();
using (var db = new SalesContext())
{
try
{
var result = await(from c in db.Products select c).Include("ProductPrices").ToListAsync();
var result1 = await(from c in db.Categories.Include("Products") select c).ToListAsync();
var result2 = await(from c in db.ProductPrices select c).Include("Product").Include("Store").ToListAsync();
var result3 = await(from c in db.Stores select c).Include("ProductPrices").ToListAsync();
var result4 = await(from c in db.GoodsReceipts select c).Include("ReceiptDetails").Include("Store").ToListAsync();
foreach (Product item in result)
{
Products.Add(item);
}
foreach (Category item in result1)
{
Categories.Add(item);
}
foreach (ProductPrice item in result2)
{
ProductPrices.Add(item);
}
foreach (Store item in result3)
{
Stores.Add(item);
}
foreach (GoodsReceipt item in result4)
{
GoodsReceipts.Add(item);
}
}
catch (Exception e)
{
var x = e.Message;
}
}
}
public async static Task DeleteAllGoodsReceipts(ICollectionView itemParas)
{
using (var db = new SalesContext())
{
List <GoodsReceipt> list = new List <GoodsReceipt>();
foreach (object item in itemParas)
{
list.Add((GoodsReceipt)item);
}
foreach (GoodsReceipt item in list)
{
db.Entry(item).State = EntityState.Unchanged;
GoodsReceipts.Remove(item);
db.Entry(item).State = EntityState.Deleted;
//Categories.Remove(item);
//var query = db.Categories.Find(item.Id);
//db.Entry(query).State = EntityState.Deleted;
}
await UpdateDatabase(db);
}
}
public async static Task AddGoodsReceipt(GoodsReceipt itemPara)
{
using (var db = new SalesContext())
{
if (itemPara.Store != null)
{
itemPara.StoreID = itemPara.Store.Id;
db.Entry(itemPara.Store).State = EntityState.Unchanged;
}
foreach (ReceiptDetail rd in itemPara.ReceiptDetails)
{
rd.ProductID = rd.Product.Id;
db.Entry(rd.Product).State = EntityState.Unchanged;
//db.ReceiptDetails.Add(rd);
}
db.GoodsReceipts.Add(itemPara);
await UpdateDatabase(db);
CodeGenerate(itemPara);
await UpdateDatabase(db);
GoodsReceipts.Add(itemPara);
}
}
private void OpenModuleDetail(int taskID)
{
//Open new form
Form openingView;
switch (taskID)
{
case (int)GlobalEnums.NmvnTaskID.Customer:
openingView = new Customers();
break;
case (int)GlobalEnums.NmvnTaskID.Commodity:
openingView = new Commodities();
break;
case (int)GlobalEnums.NmvnTaskID.BinLocation:
openingView = new BinLocations();
break;
case (int)GlobalEnums.NmvnTaskID.Pickup:
openingView = new Pickups();
break;
case (int)GlobalEnums.NmvnTaskID.GoodsReceipt:
openingView = new GoodsReceipts();
break;
case (int)GlobalEnums.NmvnTaskID.SalesOrder:
openingView = new SalesOrders();
break;
case (int)GlobalEnums.NmvnTaskID.DeliveryAdvice:
openingView = new DeliveryAdvices();
break;
case (int)GlobalEnums.NmvnTaskID.TransferOrder:
openingView = new TransferOrders();
break;
case (int)GlobalEnums.NmvnTaskID.GoodsIssue:
openingView = new GoodsIssues();
break;
case (int)GlobalEnums.NmvnTaskID.WarehouseAdjustment:
openingView = new WarehouseAdjustments();
break;
case (int)GlobalEnums.NmvnTaskID.GoodsReceiptDetailAvailable:
openingView = new GoodsReceiptDetailAvailables();
break;
case (int)GlobalEnums.NmvnTaskID.Report:
openingView = new Reports();
break;
default:
openingView = new BlankView();
break;
}
if (openingView != null)
{
this.OpenView(openingView);
}
}
private void OpenModuleDetail(int moduleDetailID)
{
if (moduleDetailID > 0)
{
Form openingView = null;//Form to open
for (int i = 0; i < this.MdiChildren.Length; i++)
{//Find and active the current form
IToolstripChild mdiChildCallToolStrip = this.MdiChildren[i] as IToolstripChild;
if (mdiChildCallToolStrip != null)
{
if (moduleDetailID == (int)mdiChildCallToolStrip.NMVNTaskID)
{
openingView = (Form)this.MdiChildren[i];
break;
}
}
}
if (openingView != null)
{
openingView.Activate();
IToolstripChild mdiChildCallToolStrip = openingView as IToolstripChild;
if (mdiChildCallToolStrip != null)
{
mdiChildCallToolStrip.DoAfterActivate();
}
}
else
{ //OPEN NEW VIEW
switch (moduleDetailID)
{
case (int)GlobalEnums.NmvnTaskID.Customers:
openingView = new Customers();
break;
case (int)GlobalEnums.NmvnTaskID.CustomerTypes:
openingView = new CustomerTypes();
break;
case (int)GlobalEnums.NmvnTaskID.CustomerCategories:
openingView = new CustomerCategories();
break;
case (int)GlobalEnums.NmvnTaskID.Commodities:
openingView = new Commodities();
break;
case (int)GlobalEnums.NmvnTaskID.CommoditySettings:
openingView = new CommoditySettings();
break;
case (int)GlobalEnums.NmvnTaskID.CommodityTypes:
openingView = new CommodityTypes();
break;
case (int)GlobalEnums.NmvnTaskID.CommodityCategories:
openingView = new CommodityCategories();
break;
case (int)GlobalEnums.NmvnTaskID.BinLocations:
openingView = new BinLocations();
break;
case (int)GlobalEnums.NmvnTaskID.Teams:
openingView = new Teams();
break;
case (int)GlobalEnums.NmvnTaskID.Territories:
openingView = new Territories();
break;
case (int)GlobalEnums.NmvnTaskID.Warehouses:
openingView = new Warehouses();
break;
case (int)GlobalEnums.NmvnTaskID.Employees:
openingView = new Employees();
break;
case (int)GlobalEnums.NmvnTaskID.Pickups:
openingView = new Pickups();
break;
case (int)GlobalEnums.NmvnTaskID.GoodsReceipts:
openingView = new GoodsReceipts();
break;
case (int)GlobalEnums.NmvnTaskID.Forecasts:
openingView = new Forecasts();
break;
case (int)GlobalEnums.NmvnTaskID.SalesOrders:
openingView = new SalesOrders();
break;
case (int)GlobalEnums.NmvnTaskID.DeliveryAdvices:
openingView = new DeliveryAdvices();
break;
case (int)GlobalEnums.NmvnTaskID.TransferOrders:
openingView = new TransferOrders();
break;
case (int)GlobalEnums.NmvnTaskID.GoodsIssues:
openingView = new GoodsIssues();
break;
case (int)GlobalEnums.NmvnTaskID.WarehouseAdjustments:
openingView = new WarehouseAdjustments();
break;
case (int)GlobalEnums.NmvnTaskID.AvailableItems:
openingView = new GoodsReceiptDetailAvailables();
break;
case (int)GlobalEnums.NmvnTaskID.PendingOrders:
openingView = new PendingOrders();
break;
case (int)GlobalEnums.NmvnTaskID.Reports:
openingView = new Reports();
break;
default:
openingView = new BlankView();
break;
}
if (openingView != null)
{
this.OpenView(openingView);
}
}
if (!this.naviBarModuleMaster.Collapsed)
{
buttonNaviBarHeader_Click(this.buttonNaviBarHeader, new EventArgs());
}
}
}
