// Print Invoice public ActionResult Invoice(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProductReceive productReceive = _productReceiveService.FindById(id.Value); if (productReceive == null) { return(HttpNotFound()); } var productReceiveLineItemViewModels = new List <ProductReceiveLineItemViewModel>(); foreach (var productReceiveLineItem in productReceive.ProductReceiveLineItems) { var productReceiveLineItemviewModel = new ProductReceiveLineItemViewModel() { ProductReceiveLineItemId = productReceiveLineItem.ProductReceiveLineItemId, ProductId = productReceiveLineItem.ProductId, Productname = _productService.FindBy(s => s.ProductcId == productReceiveLineItem.ProductId).First().ProductName, Quantity = productReceiveLineItem.Quantity, UnitCost = productReceiveLineItem.UnitCost, UnitPrice = _productService.FindBy(s => s.ProductcId == productReceiveLineItem.ProductId).First().UnitPrice }; productReceiveLineItemViewModels.Add(productReceiveLineItemviewModel); } ViewBag.LineItems = productReceiveLineItemViewModels; MyIdentityUser user = userManager.FindById(productReceive.UserId); ViewBag.UserName = user.FullName; return(View(productReceive)); }
public JsonResult SavePurchase(ProductReceive O) { bool status = false; if (ModelState.IsValid) { MyIdentityDbContext db = new MyIdentityDbContext(); UserStore <MyIdentityUser> userStore = new UserStore <MyIdentityUser>(db); UserManager <MyIdentityUser> userManager = new UserManager <MyIdentityUser>(userStore); MyIdentityUser user = userManager.FindByName(HttpContext.User.Identity.Name); O.DateReceived = DateTime.Now; O.UserId = user.Id; _productReceiveService.AddProductReceive(O); //Order order = new Order { OrderNo = O.OrderNo, OrderDate = O.OrderDate, Description = O.Description }; //foreach (var i in O.OrderDetails) //{ // // // // i.TotalAmount = // order.OrderDetails.Add(i); //} //dc.Orders.Add(order); //dc.SaveChanges(); status = true; } else { status = false; } return(new JsonResult { Data = new { status = status } }); }
public ActionResult DeleteConfirmed(int id) { ProductReceive productReceive = _productReceiveService.FindById(id); _productReceiveService.DeleteProductReceive(productReceive); return(RedirectToAction("Index", "ProductReceives")); }
public bool AddProductReceiveLineItem(ProductReceive productReceive, ProductReceiveLineItem item) { _unitOfWork.ProductReceiveRepository.Edit(productReceive); AddLineItemStock(item, productReceive.BranchId); _unitOfWork.Save(); return(true); }
public bool DeleteProductReceiveLineItem(ProductReceive productReceive, ProductReceiveLineItem lineItem) { //_unitOfWork.ProductReceiveRepository.Edit(productReceive); _unitOfWork.ProductReceiveLineItemRepository.Delete(lineItem); SubtractLineItemStock(lineItem, productReceive.BranchId); _unitOfWork.Save(); return(true); }
public ActionResult Edit([Bind(Include = "ProductReceiveId,DateReceived,BranchId,UserId")] ProductReceive productReceive) { if (ModelState.IsValid) { _productReceiveService.EditProductReceive(productReceive); return(RedirectToAction("Index")); } return(View(productReceive)); }
public bool DeleteProductReceive(ProductReceive productReceive) { if (productReceive == null) { return(false); } _unitOfWork.ProductReceiveRepository.Delete(productReceive); _unitOfWork.Save(); return(true); }
public bool AddProductReceive(ProductReceive productReceive) { _unitOfWork.ProductReceiveRepository.Add(productReceive); if (productReceive.ProductReceiveLineItems != null) { foreach (var item in productReceive.ProductReceiveLineItems) { AddLineItemStock(item, productReceive.BranchId); } } _unitOfWork.Save(); return(true); }
// GET: ProductReceives/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProductReceive productReceive = _productReceiveService.FindById(id.Value); if (productReceive == null) { return(HttpNotFound()); } return(View(productReceive)); }
public ActionResult Create(ProductReceiveViewModel productReceiveViewModel) { if (ModelState.IsValid) { MyIdentityDbContext db = new MyIdentityDbContext(); UserStore <MyIdentityUser> userStore = new UserStore <MyIdentityUser>(db); UserManager <MyIdentityUser> userManager = new UserManager <MyIdentityUser>(userStore); MyIdentityUser user = userManager.FindByName(HttpContext.User.Identity.Name); var productReceive = new ProductReceive() { BranchId = user.BranchId, UserId = user.Id, DateReceived = DateTime.Now }; _productReceiveService.AddProductReceive(productReceive); return(RedirectToAction("Create", "ProductReceives", new { id = productReceive.ProductReceiveId })); } return(View(productReceiveViewModel)); }
public JsonResult SaveEditPurchase(ProductReceive O) { bool status = false; if (ModelState.IsValid) { MyIdentityDbContext db = new MyIdentityDbContext(); UserStore <MyIdentityUser> userStore = new UserStore <MyIdentityUser>(db); UserManager <MyIdentityUser> userManager = new UserManager <MyIdentityUser>(userStore); MyIdentityUser user = userManager.FindByName(HttpContext.User.Identity.Name); O.DateReceived = DateTime.Now; O.UserId = user.Id; _productReceiveService.AddProductReceive(O); status = true; } else { status = false; } return(new JsonResult { Data = new { status = status } }); }
protected override void Seed(MoencoPOSContext context) { var addresses = new List <Address> { new Address { AddressId = 1, LandLineNo = "+251111123456", CellPhoneNo = "+251911123456", State = "Afar", City = "Semera", StreetNo = "12345", HouseNo = "123" }, new Address { AddressId = 2, LandLineNo = "+555555555555", CellPhoneNo = "+666666666666", State = "Amhara", City = "Bahirdar", StreetNo = "44444", HouseNo = "555" }, }; addresses.ForEach(s => context.Addresses.Add(s)); context.SaveChanges(); var branches = new List <Branch> { new Branch { BranchName = "Main", BranchLocation = "Addis Ababa", BranchDescription = "Country Main Branch" }, new Branch { BranchName = "South Branch", BranchLocation = "Awassa", BranchDescription = "SNNP Branch in Awassa" } }; branches.ForEach(s => context.Branches.Add(s)); context.SaveChanges(); var customers = new List <Customer> { new Customer { FirstName = "Tewodros", LastName = "Afro", Address = "Arat Killo", TelephoneNo = "123456789", TIN = "123456789", VATNumber = "123456789", Trusted = true }, new Customer { FirstName = "Tilahun", LastName = "Gessesse", Address = "Arat Killo", TelephoneNo = "123456789", TIN = "123456789", VATNumber = "123456789", Trusted = true } }; customers.ForEach(s => context.Customers.Add(s)); context.SaveChanges(); var salesInvoices = new List <SalesInvoice> { new SalesInvoice { SalesInvoiceId = 1, CustomerId = 1, BranchId = 1, SalesType = 0, UserId = "98f74499-a614-4373-aacd-5eec5b46ef95", DateSold = DateTime.Parse("2016-10-09"), ReferenceNo = "ABC-123" }, new SalesInvoice { SalesInvoiceId = 2, CustomerId = 2, BranchId = 2, SalesType = 1, UserId = "98f74499-a614-4373-aacd-5eec5b46ef95", DateSold = DateTime.Parse("2016-10-09"), ReferenceNo = "XYZ-123" } }; salesInvoices.ForEach(s => context.SalesInvoices.Add(s)); context.SaveChanges(); var categories = new List <Category> { new Category { CategoryName = "Car", CategoryDescription = "Toyota Cars." }, new Category { CategoryName = "Tyres", CategoryDescription = "Tyre for diffrent model Toyota Cars." } }; categories.ForEach(s => context.Categories.Add(s)); context.SaveChanges(); var productcs = new List <Productc> { new Productc { ProductName = "Toyota Vitz", ProductDescription = "Toyota Vitz 2014", Model = "Vitz 2014", UnitOfMeasure = "Pcs", UnitCost = 200000.00M, UnitPrice = 250000.00M, CategoryId = 1 }, new Productc { ProductName = "Toyota Yaris", ProductDescription = "Toyota Yaris 2012", Model = "Yaris 2012", UnitOfMeasure = "Pcs", UnitCost = 350000.00M, UnitPrice = 400000.00M, CategoryId = 1 } }; productcs.ForEach(s => context.Productcs.Add(s)); context.SaveChanges(); var stocks = new List <Stock> { new Stock { BranchId = 1, ProductId = 1, Quantity = 5 }, new Stock { BranchId = 1, ProductId = 2, Quantity = 3 } }; stocks.ForEach(s => context.Stocks.Add(s)); context.SaveChanges(); var receiveInvoice = new ProductReceive { UserId = "98f74499-a614-4373-aacd-5eec5b46ef95", BranchId = 1, DateReceived = DateTime.Parse("2017-12-09") }; var receiveLineItems = new List <ProductReceiveLineItem> { new ProductReceiveLineItem { ProductId = 1, Quantity = 1, UnitCost = 200000.00M }, new ProductReceiveLineItem { ProductId = 2, Quantity = 1, UnitCost = 350000.00M } }; receiveInvoice.ProductReceiveLineItems = receiveLineItems; context.ProductReceives.Add(receiveInvoice); context.SaveChanges(); var transferInvoice = new ProductTransfer { UserId = "98f74499-a614-4373-aacd-5eec5b46ef95", FromBranchId = 1, ToBranchId = 2, DateTransfered = DateTime.Parse("2017-12-09") }; var transferLineItems = new List <ProductTransferLineItem> { new ProductTransferLineItem { ProductId = 1, Quantity = 1 }, new ProductTransferLineItem { ProductId = 2, Quantity = 1 } }; transferInvoice.ProductTransferLineItems = transferLineItems; context.ProductTransfers.Add(transferInvoice); context.SaveChanges(); }
public bool EditProductReceive(ProductReceive productReceive) { _unitOfWork.ProductReceiveRepository.Edit(productReceive); _unitOfWork.Save(); return(true); }
protected override void Seed(REERPContext context) { var addresses = new List <Address> { new Address { AddressId = 1, LandLineNo = "+251111123456", CellPhoneNo = "+251911123456", State = "Afar", City = "Semera", StreetNo = "12345", HouseNo = "123" }, new Address { AddressId = 2, LandLineNo = "+555555555555", CellPhoneNo = "+666666666666", State = "Amhara", City = "Bahirdar", StreetNo = "44444", HouseNo = "555" }, }; addresses.ForEach(s => context.Addresses.Add(s)); context.SaveChanges(); var branches = new List <Branch> { new Branch { BranchName = "Main", BranchLocation = "Addis Ababa", BranchDescription = "Country Main Branch" }, new Branch { BranchName = "South Branch", BranchLocation = "Awassa", BranchDescription = "SNNP Branch in Awassa" } }; branches.ForEach(s => context.Branches.Add(s)); context.SaveChanges(); var customers = new List <Customer> { new Customer { FirstName = "Tewodros", LastName = "Afro", Address = "Arat Killo", TelephoneNo = "123456789", TIN = "123456789", VATNumber = "123456789", Trusted = true }, new Customer { FirstName = "Tilahun", LastName = "Gessesse", Address = "Arat Killo", TelephoneNo = "123456789", TIN = "123456789", VATNumber = "123456789", Trusted = true } }; customers.ForEach(s => context.Customers.Add(s)); context.SaveChanges(); var salesInvoices = new List <SalesInvoice> { new SalesInvoice { SalesInvoiceId = 1, CustomerId = 1, BranchId = 1, SalesType = 0, UserId = "98f74499-a614-4373-aacd-5eec5b46ef95", DateSold = DateTime.Parse("2016-10-09") }, new SalesInvoice { SalesInvoiceId = 2, CustomerId = 2, BranchId = 2, SalesType = 1, UserId = "98f74499-a614-4373-aacd-5eec5b46ef95", DateSold = DateTime.Parse("2016-10-09") } }; salesInvoices.ForEach(s => context.SalesInvoices.Add(s)); context.SaveChanges(); var categories = new List <Category> { new Category { CategoryName = "Brandy", CategoryDescription = "Distilled From: Fruit. Primarily grapes, though apple, apricot, cherry, peach, and other fruits" }, new Category { CategoryName = "Gin", CategoryDescription = "Distilled From: Neutral grains such as barley, corn, rye, and wheat. Flavored with a variety of botanicals, which vary by brand" }, new Category { CategoryName = "Rum", CategoryDescription = "Distilled From: Sugar. Either molasses or pure sugar cane" }, new Category { CategoryName = "Tequila", CategoryDescription = "Agave plant" }, new Category { CategoryName = "Vodka", CategoryDescription = "Distilled From: Neutral grain (rye, corn, wheat, etc.) or potato. Some are distilled from beets, grapes, and other bases" }, new Category { CategoryName = "Whiskey", CategoryDescription = "Distilled From: Neutral grain (rye, corn, wheat, etc.) or potato. Some are distilled from beets, grapes, and other bases" } }; categories.ForEach(s => context.Categories.Add(s)); context.SaveChanges(); var productcs = new List <Productc> { new Productc { ProductcId = "001", ProductName = "Courvoisier - V.S", ProductDescription = "750 ml ", Model = "", UnitOfMeasure = "Pcs", UnitCost = 58.00M, UnitPrice = 58.00M, CategoryId = 1 }, new Productc { ProductcId = "002", ProductName = "Courvoisier - V.S.O.P", ProductDescription = "750 ml ", Model = "", UnitOfMeasure = "Pcs", UnitCost = 89.00M, UnitPrice = 89.00M, CategoryId = 1 }, new Productc { ProductcId = "003", ProductName = "Courvoisier - X.O. IMPERIAL", ProductDescription = "750 ml ", Model = "", UnitOfMeasure = "Pcs", UnitCost = 240.00M, UnitPrice = 240.00M, CategoryId = 1 } }; productcs.ForEach(s => context.Productcs.Add(s)); context.SaveChanges(); var stocks = new List <Stock> { new Stock { BranchId = 1, ProductcId = "001", Quantity = 100 }, new Stock { BranchId = 1, ProductcId = "002", Quantity = 100 }, new Stock { BranchId = 1, ProductcId = "003", Quantity = 100 } }; stocks.ForEach(s => context.Stocks.Add(s)); context.SaveChanges(); var receiveInvoice = new ProductReceive { UserId = "98f74499-a614-4373-aacd-5eec5b46ef95", BranchId = 1, DateReceived = DateTime.Parse("2017-12-09") }; var receiveLineItems = new List <ProductReceiveLineItem> { new ProductReceiveLineItem { ProductId = "001", Quantity = 25, UnitCost = 58.00M }, new ProductReceiveLineItem { ProductId = "002", Quantity = 25, UnitCost = 89.00M }, new ProductReceiveLineItem { ProductId = "003", Quantity = 55, UnitCost = 240.00M } }; receiveInvoice.ProductReceiveLineItems = receiveLineItems; context.ProductReceives.Add(receiveInvoice); context.SaveChanges(); var transferInvoice = new ProductTransfer { UserId = "98f74499-a614-4373-aacd-5eec5b46ef95", FromBranchId = 1, ToBranchId = 2, DateTransfered = DateTime.Parse("2017-12-09") }; var transferLineItems = new List <ProductTransferLineItem> { new ProductTransferLineItem { ProductId = "001", Quantity = 25 }, new ProductTransferLineItem { ProductId = "002", Quantity = 25 }, new ProductTransferLineItem { ProductId = "003", Quantity = 25 } }; transferInvoice.ProductTransferLineItems = transferLineItems; context.ProductTransfers.Add(transferInvoice); context.SaveChanges(); }
private void btnImport_Click(object sender, EventArgs e) { try { Hashtable filedsHt = new Hashtable(); foreach (DataGridViewRow dr in dgvData.Rows) { filedsHt.Add(dr.Cells["NAME"].Value, dr.Cells["EXCEL_FILED"].Value); } AbstractReceive receive = null; if ("BASE_PRODUCT_GROUP".Equals(cboBaseTable.SelectedValue)) { receive = new ProductGroupReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_PRODUCT".Equals(cboBaseTable.SelectedValue)) { receive = new ProductReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_PRODUCT_PARTS".Equals(cboBaseTable.SelectedValue)) { receive = new ProductPartsReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_CUSTOMER".Equals(cboBaseTable.SelectedValue)) { receive = new CustomerReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_SUPPLIER".Equals(cboBaseTable.SelectedValue)) { receive = new SupplierReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_STOCK".Equals(cboBaseTable.SelectedValue)) { receive = new StockReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_WAREHOUSE".Equals(cboBaseTable.SelectedValue)) { receive = new WarehouseReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_LOCATION".Equals(cboBaseTable.SelectedValue)) { receive = new LocationReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_CUSTOMER_PRICE".Equals(cboBaseTable.SelectedValue)) { receive = new CustomerPriceReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_CUSTOMER_REPORTED".Equals(cboBaseTable.SelectedValue)) { receive = new CustomerReportedReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_SUPPLIER_PRICE".Equals(cboBaseTable.SelectedValue)) { receive = new SupplierPriceReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_PRODUCT_UNIT".Equals(cboBaseTable.SelectedValue)) { receive = new ProductUnitReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_SAFETY_STOCK".Equals(cboBaseTable.SelectedValue)) { receive = new SafetyStockReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_CURRENCY".Equals(cboBaseTable.SelectedValue)) { receive = new CurrencyReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_TAXATION".Equals(cboBaseTable.SelectedValue)) { receive = new TaxAtionReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_SLIP_TYPE".Equals(cboBaseTable.SelectedValue)) { receive = new SlipTypeReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); CCacheData.SlipType = null; CCacheData.OrderSlipType = null; CCacheData.PurchaseSlipType = null; } else if ("BASE_DELIVERY".Equals(cboBaseTable.SelectedValue)) { receive = new DeliveryReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_MASTER_MACHINE".Equals(cboBaseTable.SelectedValue)) { receive = new MasterMachineReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } else if ("BASE_USER".Equals(cboBaseTable.SelectedValue)) { receive = new UserReceive(txtFilePath.Text, CConvert.ToString(cboFileType.SelectedValue), CConvert.ToString(cboExcelSheet.SelectedValue), filedsHt, _userInfo); } string[] a = receive.DoReceiveJob(); MessageBox.Show("成功导入" + a[0] + "行!\r\n失败导入" + a[1] + "行!\r\n" + a[2]); EndImport(); } catch (Exception ex) { MessageBox.Show("操作错误,请重新导入!"); } }
public static ProductReceive CreateProductReceive(int ID, byte[] rowVersion) { ProductReceive productReceive = new ProductReceive(); productReceive.Id = ID; productReceive.RowVersion = rowVersion; return productReceive; }
public void AddToProductReceives(ProductReceive productReceive) { base.AddObject("ProductReceives", productReceive); }