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