private void btnEditar_Click(object sender, EventArgs e)
{
pnlDatos.Enabled = true;
txtName.Focus();
PurchaseDetail purchaseDetail =
purchaseDetailBindingSource1.Current as PurchaseDetail;
}
public JsonResult DeleteConfirmed(int?id)
{
bool result = false;
Purchase p = db.Purchases.SingleOrDefault(f => f.purchaseId == id);
var pv = db.Vouchers.SingleOrDefault(r => r.voucherNo == p.purVoucherNo);
if (p != null)
{
db.Purchases.Remove(p);
db.Vouchers.Remove(pv);
db.PurchaseDetails.RemoveRange(db.PurchaseDetails.Where(f => f.purchaseDetailsId == id));
db.VoucherBodies.RemoveRange(db.VoucherBodies.Where(r => r.voucherNo == pv.voucherNo));
db.SaveChanges();
result = true;
}
else
{
PurchaseDetail pd = db.PurchaseDetails.Single(r => r.code == id);
var vb = db.VoucherBodies.Where(r => r.voucherNo == pd.Purchase.purVoucherNo);
db.PurchaseDetails.Remove(pd);
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
// Insertar elementos en la base de datos
public PurchaseDetail Insert(PurchaseDetail purchaseDetail)
{
// Guardar elemento
_context.PurchaseDetail.Add(purchaseDetail);
_context.SaveChanges();
return(purchaseDetail);
}
private void btnGuardar_Click(object sender, EventArgs e)
{
using (DataContext dataContext = new DataContext())
{
PurchaseDetail purchaseDetail =
purchaseDetailBindingSource1.Current as PurchaseDetail;
if (purchaseDetail != null)
{
if (dataContext.Entry <PurchaseDetail>(purchaseDetail).State == EntityState.Detached)
{
dataContext.Set <PurchaseDetail>().Attach(purchaseDetail);
}
if (purchaseDetail.Id == 0)
{
dataContext.Entry <PurchaseDetail>(purchaseDetail).State = EntityState.Added;
}
else
{
dataContext.Entry <PurchaseDetail>(purchaseDetail).State = EntityState.Modified;
}
dataContext.SaveChanges();
MetroFramework.MetroMessageBox.Show(this, "Detalle de compra guardado");
grdDatos.Refresh();
pnlDatos.Enabled = false;
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("PurchaseDetailId,PuchaseId,ProductId,Quantity,Price,UOM,Discount")] PurchaseDetail purchaseDetail)
{
if (id != purchaseDetail.PurchaseDetailId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(purchaseDetail);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseDetailExists(purchaseDetail.PurchaseDetailId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ProductId"] = new SelectList(_context.Product, "ProductId", "ProductId", purchaseDetail.ProductId);
ViewData["PuchaseId"] = new SelectList(_context.Purchase, "PurchaseId", "PurchaseId", purchaseDetail.PuchaseId);
return(View(purchaseDetail));
}
public void SavePurchaseDetail(PurchaseDetail aPurchaseDetail)
{
Connection.Open();
try
{
Query = "insert into PurchaseDetail values(@PurchaseId,'@PurchaseInvNo',@ItemGroupId,@ItemId,'@ItemName',@GodownId,,'@ProductName'" +
"'@Quantity',@UnitPrice,@TotalAmount,@IsApporved,@ApprovedByUserId,@ApproveDateTime,'@Department','@Location')";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.AddWithValue("PurchaseId", aPurchaseDetail.PurchaseId);
Command.Parameters.AddWithValue("PurchaseInvNo", aPurchaseDetail.PurchaseInvoiceNo);
Command.Parameters.AddWithValue("ItemGroupId", aPurchaseDetail.ItemGroupId);
Command.Parameters.AddWithValue("ItemId", aPurchaseDetail.ItemId);
Command.Parameters.AddWithValue("ItemName", aPurchaseDetail.ItemName);
Command.Parameters.AddWithValue("GodownId", aPurchaseDetail.GodownId);
Command.Parameters.AddWithValue("ProductName", aPurchaseDetail.ProductName);
Command.Parameters.AddWithValue("Quantity", aPurchaseDetail.Quantity);
Command.Parameters.AddWithValue("UnitPrice", aPurchaseDetail.UnitPrice);
Command.Parameters.AddWithValue("TotalAmount", aPurchaseDetail.TotalAmount);
Command.Parameters.AddWithValue("IsApporved", aPurchaseDetail.IsApproved);
Command.Parameters.AddWithValue("ApprovedByUserId", aPurchaseDetail.ApproveByUserId);
Command.Parameters.AddWithValue("ApproveDateTime", aPurchaseDetail.ApproveDateTime);
Command.Parameters.AddWithValue("Department", aPurchaseDetail.Department);
Command.Parameters.AddWithValue("Location", aPurchaseDetail.Location);
RowCount = Command.ExecuteNonQuery();
}
catch { RowCount = 2; }
Connection.Close();
}
public void CreateOrder(Purchase purchase)
{
purchase.TimeOrderPlaced = DateTime.Now;
_appDbContext.Purchases.Add(purchase);
var shoppingCartItems = _shoppingCart.ShoppingCartItems;
foreach (var shoppingCartItem in shoppingCartItems)
{
var orderDetail = new PurchaseDetail()
{
Amount = shoppingCartItem.Amount,
AnimalId = shoppingCartItem.Animal.AnimalId,
Animal = shoppingCartItem.Animal,
PurchaseId = purchase.PurchaseId,
Price = shoppingCartItem.Animal.Price
};
_appDbContext.PurchaseDetails.Add(orderDetail);
}
purchase.PurchaseTotal = _shoppingCart.GetShoppingCartTotal();
_appDbContext.SaveChanges();
}
public async Task <IActionResult> PutPurchaseDetail([FromRoute] int id, [FromBody] PurchaseDetail purchaseDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != purchaseDetail.PurchaseDetailId)
{
return(BadRequest());
}
_context.Entry(purchaseDetail).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IHttpActionResult PutPurchaseDetail(int id, PurchaseDetail purchaseDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != purchaseDetail.Id)
{
return(BadRequest());
}
db.Entry(purchaseDetail).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public HttpResponseMessage Update(string email, List <PurchaseDTO> movies)
{
PurchaseDetail purchased = new PurchaseDetail();
foreach (var item in movies)
{
//product = db.Products.Find(item.ProductId);
//product.InventoryCount = product.InventoryCount - item.InventoryCount;
purchased.InventoryCount = item.InventoryCount;
purchased.Price = item.Price;
purchased.type = item.type;
purchased.Name = item.Name;
purchased.ScreenNumber = item.ScreenNumber;
purchased.time = item.time;
purchased.date = DateTime.Today.ToString();
db.PurchaseDetails.Add(purchased);
try
{
db.SaveChanges();
Gmailer mail = new Gmailer();
mail.sendEmail(email, movies);
}
catch (DbUpdateConcurrencyException)
{
}
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public bool Create(PurchaseDetailViewModel model, IDataSourceError error)
{
var purchaseDetail = new PurchaseDetail
{
PurchaseId = model.PurchaseId,
Price = model.Price,
Inventory = model.Inventory
};
if (model.Product != null && !string.IsNullOrEmpty(model.Product.Value))
{
purchaseDetail.ProductId = Convert.ToInt32(model.Product.Value);
}
if (model.ProductDetail != null && !string.IsNullOrEmpty(model.ProductDetail.Value))
{
purchaseDetail.ProductDetailId = Convert.ToInt32(model.ProductDetail.Value);
}
this.DbContext.PurchaseDetails.Add(purchaseDetail);
var result = false;
try
{
this.DbContext.SaveChanges();
model.PurchaseDetailId = purchaseDetail.PurchaseDetailId;
model.SubtotalAmount = model.Price * model.Inventory;
result = true;
}
catch { }
return(result);
}
public void InsertTest()
{
//有效的
PurchaseBill p = new PurchaseBill();
p.PurchaseID = "20160130001";
p.SupplierID = "0";
p.PurchaseDate = Convert.ToDateTime("2015-05-06");
p.StockDate = new DateTime();
p.Clerk = "1";
p.Examiner = "2";
p.Custodian = "3";
p.OnProcess = 0;
p.Memo = "哈哈哈";
List <PurchaseDetail> pdd = new List <PurchaseDetail>();
PurchaseDetail pd = new PurchaseDetail();
pd.PurchaseID = "20160130001";
pd.PurchaseDetailID = 1;
pd.ProductID = "0002";
pd.PurchasePrice = 2;
pd.Quantity = 100;
pdd.Add(pd);
p.DetailList = pdd;
PurchaseBillDAL target = new PurchaseBillDAL();
bool atual = target.Insert(p); //实际的结果
bool expected = true; //预期的结果
Assert.AreEqual(expected, atual); //断言判等
}
public void Post([FromBody] Purchase pur)
{
FinanceEntities db = new FinanceEntities();
PurchaseDetail p = new PurchaseDetail();
p.ProductID = pur.id;
p.CardID = (from c in db.CardDetails
join u in db.Users
on c.CustomerID equals u.CustomerID
where u.Username == pur.username
select c.CardID).FirstOrDefault();
p.PurchaseDate = DateTime.Now;
p.CustomerID = (from u in db.Users where u.Username == pur.username select u.CustomerID).FirstOrDefault();
p.EmiScheme = pur.scheme;
p.EmiPerMonth = pur.amount / pur.scheme;
p.EmiPaid = 0;
p.EmiLeft = pur.amount;
p.PaidForMonth = "NO";
db.PurchaseDetails.Add(p);
db.SaveChanges();
CardDetail query = (from c in db.CardDetails
where c.CustomerID == p.CustomerID
select c).FirstOrDefault();
query.RemainingCredit = query.RemainingCredit - pur.amount;
db.Entry(query).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public IHttpActionResult SaveNewPurchase(NewPurchaseRequestModel request)
{
Purchase purchase = new Purchase();
purchase.InvoiceNo = _service.GetRecordId();
purchase.Amount = request.Total;
purchase.Comment = "N/A";
var savedPurchase = _service.AddwithReturnId(purchase);
foreach (var item in request.PurchaseItem)
{
PurchaseDetail purchasDetail = new PurchaseDetail();
purchasDetail.Amount = item.Subtotal;
purchasDetail.Quantity = item.Qty;
purchasDetail.ProductId = item.Id;
purchasDetail.PurchaseId = savedPurchase.Id;
_purchaseDetailsService.Add(purchasDetail);
_productService.IncreaseStock(purchasDetail.ProductId, purchasDetail.Quantity);
}
_companyService.DeductBalence(savedPurchase.Amount);
return(Ok(purchase.InvoiceNo));
}
public async Task <IActionResult> Edit(int id, [Bind("PurchaseDetailID,Quantity,Amount")] PurchaseDetail purchaseDetail)
{
if (id != purchaseDetail.PurchaseDetailID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(purchaseDetail);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseDetailExists(purchaseDetail.PurchaseDetailID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(purchaseDetail));
}
//添加入库明细
public bool AddDetail(PurchaseDetail detail)
{
if (detail == null)
{
throw new ArgumentNullException("detail");
}
_cmd.CommandText = "InsertPurchaseDetail";
_cmd.Parameters.Clear();
_cmd.Parameters.Add("@purchaseid", SqlDbType.Int).Value = detail.PurchaseID;
_cmd.Parameters.Add("@productid", SqlDbType.Int).Value = detail.ProductID;
_cmd.Parameters.Add("@price", SqlDbType.Decimal).Value = detail.Price;
_cmd.Parameters.Add("@quantity", SqlDbType.Int).Value = detail.Quantity;
_cmd.Parameters.Add("@sortcode", SqlDbType.Int).Value = detail.SortCode;
var result = DBAccess.ExecuteSQL(_cmd);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
void lineItems_CollectionChanged(object sender, NotifyCollectionChangedEventArgs e)
{
if (e.Action == NotifyCollectionChangedAction.Add && e.NewItems != null)
{
foreach (PurchaseDetail item in e.NewItems)
{
this.Model.PurchaseDetails.Add(item);
}
}
else if (e.Action == NotifyCollectionChangedAction.Remove && e.OldItems != null)
{
foreach (PurchaseDetail item in e.OldItems)
{
this.Model.PurchaseDetails.Remove(item);
if (item.ProductId.HasValue)
{
ReduceStock(item.ProductId.Value, item.Quantity);
}
}
this.SelectedLineItem = this.LineItems.LastOrDefault();
}
this.Model.NotifyChanges();
}
public JsonResult GetPurchaseHome(string suplid, string Productname, string Quantity, string Desc, decimal Price, string Addcomments)
{
PurchaseDetail obj1 = new PurchaseDetail();
obj1.SupplierName = suplid;
obj1.product_name = Productname;
obj1.Description = Desc;
obj1.Quantity = Quantity;
obj1.price = Price;
obj1.additionalComment = Addcomments;
obj1.Description = Desc;
obj1.PurchaseDate = DateTime.Now.ToString();
//obj.watt = Watts;
//obj.Product_name = Item;
//obj.Product_price = Price;
//obj.Quantity = Quantity;
//obj.Amount = TotalAmo;
//obj.sales_date = DateTime.Now.ToString();
//obj.AdditionalComments = Addcomments;
using (SainiShopEntities1 objDb = new SainiShopEntities1())
{
objDb.PurchaseDetails.Add(obj1);
objDb.SaveChanges();
}
var response = new Response(true, "Contact Successfully Submitted");
return(Json(response));
}
private Product GetProduct(PurchaseDetail item)
{
var prod = new Product();
if (item.ProductId.HasValue)
{
var oldProduct = this.productService.GetProductById(item.ProductId.Value);
if (oldProduct.MRP == item.MRP || oldProduct.SellPrice == item.SellPrice)
{
prod.Id = item.ProductId.Value; // if mrp or sellprice is not changed then update the old product
}
}
prod.Barcode = item.Barcode;
prod.Name = item.Name;
prod.MRP = item.MRP;
prod.SellPrice = item.SellPrice;
prod.BuyPrice = item.BuyPrice;
prod.Discount = item.Discount;
prod.Status = true;
prod.Stock += item.Quantity;
prod.CategoryId = item.CategoryId;
prod.TaxCategoryId = item.TaxCategoryId;
prod.SupplierId = this.Model.SupplierId;
return(prod);
}
public async Task <IActionResult> Edit(int id, [Bind("PurchaseDetailID,PurchaseID,ProductID,PhoneNumber,Email,Address")] PurchaseDetail purchaseDetail)
{
if (id != purchaseDetail.PurchaseDetailID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(purchaseDetail);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseDetailExists(purchaseDetail.PurchaseDetailID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["PurchaseID"] = new SelectList(_context.Purchase, "PurchaseID", "PurchaseID", purchaseDetail.PurchaseID);
return(View(purchaseDetail));
}
private void Restore()
{
btnAdd.Enabled = true;
btnEdit.Enabled = btnDelete.Enabled = btnSave.Enabled = btnCancel.Enabled
= btnDelDetail.Enabled = btnAddDetail.Enabled = cbSupplier.Enabled = txtMemo.Enabled = false;
//cbSupplier.SelectedIndex = 0;
lbxSerialnumber.DataSource = null;
purchase = null;
purchaseDetails = null;
selected_PurchaseDetail = null;
//清理所有文本框
foreach (var c in groupBox2.Controls)
{
if (c is TextBox)
{
((TextBox)c).Text = string.Empty;
}
}
dgvDetails.DataSource = null;
_op = EnumOperation.None;
purchase = new Purchase();
purchaseDetails = new List <PurchaseDetail>();
selected_PurchaseDetail = new PurchaseDetail();
}
public async Task <IActionResult> MakeOrder()
{
var cartStr = HttpContext.Session.Keys.Contains("cart") ?
HttpContext.Session.GetString("cart") :
"[]";
var jArray = JArray.Parse(cartStr);
var(products, quantities) = RetrieveCart(jArray);
var newOrder = new Order
{
Created = DateTime.UtcNow,
User = await _userManager.FindUserByName(User.Identity.Name)
};
var newOrderId = _dataManager.OrderRepository.SaveEntity(newOrder);
foreach (var product in products)
{
var newPurchaseDetail = new PurchaseDetail
{
OrderId = newOrderId,
Product = product,
Amount = quantities[products.IndexOf(product)]
};
_dataManager.PurchaseDetailRepository.SaveEntity(newPurchaseDetail);
}
HttpContext.Session.SetString("cart", "[]");
return(Json(new { success = true }));
}
private void btnEliminar_Click(object sender, EventArgs e)
{
if (MetroFramework.MetroMessageBox.Show(this,
"¿Quieres eliminar el registro?",
"Eliminar",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Question) == DialogResult.OK)
{
using (DataContext dataContext = new DataContext())
{
PurchaseDetail purchaseDetail =
purchaseDetailBindingSource1.Current as PurchaseDetail;
if (purchaseDetail != null)
{
if (dataContext.Entry <PurchaseDetail>(purchaseDetail).State == EntityState.Detached)
{
dataContext.Set <PurchaseDetail>().Attach(purchaseDetail);
}
dataContext.Entry <PurchaseDetail>(purchaseDetail).State = EntityState.Deleted;
dataContext.SaveChanges();
MetroFramework.MetroMessageBox.Show(this, "Detalle de compra eliminado");
purchaseDetailBindingSource1.RemoveCurrent();
pnlDatos.Enabled = false;
}
}
}
}
public ActionResult ViewDetail(FormCollection formCollection)
{
try
{
PurchaseDetail purchaseDetail = new PurchaseDetail();
// Retrieve form data using form collection
purchaseDetail.BookID = Convert.ToInt32(formCollection["BookID"]);
purchaseDetail.Amount = Convert.ToDouble(formCollection["Price"]);
purchaseDetail.transactionstatus = "Success";
purchaseDetail.transactionType = formCollection["PayType"];
purchaseDetail.PurchaseID = 0;
purchaseDetail.PurchasedOn = DateTime.Now;
purchaseDetail.Userid = 1;
BookGateway.BookGatewayFactory bookFactory = new BookGateway.BookGatewayFactory();
IBookGateway bookGateway = bookFactory.GetBookGateway(purchaseDetail.transactionType);
PurchaseDetail opurchaseDetail = bookGateway.SavePaymentDetails(purchaseDetail);
TempData["Message"] = "<span style='color:blue;'>Book purchased successfully</span>";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
TempData["Message"] = "<span style='color:red;'>" + ex.Message + "</span>";
}
return(View());
}
//按流水号查询商品明细
public List <PurchaseDetail> GetPurchaseDetails(string sn)
{
_cmd.CommandText = "GetPurchaseDetailsBySerialNumber";
_cmd.Parameters.Clear();
_cmd.Parameters.Add("@SerialNumber", SqlDbType.NVarChar, 12).Value = sn;
var list = new List <PurchaseDetail>();
SqlDataReader sdr = DBAccess.ReadData(_cmd);
while (sdr.Read())
{
var d = new PurchaseDetail();
d.BarCode = sdr["BarCode"].ToString();
d.Price = Convert.ToDecimal(sdr["Price"]);
d.ProductID = Convert.ToInt32(sdr["ProductID"]);
d.ProductName = sdr["ProductName"].ToString();
d.PurchaseDetailID = Convert.ToInt32(sdr["PurchaseDetailID"]);
d.PurchaseID = Convert.ToInt32(sdr["PurchaseID"]);
d.Quantity = Convert.ToInt32(sdr["Quantity"]);
d.Serialnumber = sdr["Serialnumber"].ToString();
d.SortCode = Convert.ToInt32(sdr["SortCode"]);
list.Add(d);
}
sdr.Close();
return(list);
}
public ActionResult CrearPedido(Models.PurchaseDetail detail)
{
try
{
if (User.Identity.IsAuthenticated)
{
detail.Client_id = User.Identity.Name;
PurchaseDetail det = new PurchaseDetail();
det.Client_id = detail.Client_id;
det.Album_id = detail.Album_id;
det.Total = detail.Total;
new Front().CrearPedido(det);
return(RedirectToAction("Index", "PurchaseDetail"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
catch (Exception)
{
throw;
}
}
// GET: Orders/Details/5
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var orden = await _context.PurchaseOrder
.Include(o => o.Customer)
.Include(o => o.Payment)
.FirstOrDefaultAsync(m => m.PurchaseId == id);
if (orden == null)
{
return(NotFound());
}
var purchaseview = new PurchaseOrderView();
var purchasedetail = new PurchaseDetail();
purchaseview.PurchaseOrder = await _context.PurchaseOrder
.Include(o => o.Customer)
.Include(o => o.Payment)
.FirstOrDefaultAsync(m => m.PurchaseId == id);
var datapurchase = _context.PurchaseDetail.Include(od => od.PurchaseOrder).Include(od => od.Item).Where(od => od.PurchaseId.Equals(id)).ToList();
purchaseview.PurchaseDetails = datapurchase;
ViewData["PurchaseId"] = new SelectList(_context.PurchaseOrder, "PurchaseId", "PurchaseId", purchasedetail.PurchaseId);
ViewData["PaymentId"] = new SelectList(_context.PurchaseOrder, "PaymentId", "Pway", purchasedetail.PurchaseId);
ViewData["ItemId"] = new SelectList(_context.Items, "ItemId", "ItemName", purchasedetail.ItemId);
return(View(purchaseview));
}
// Insertar elementos en la base de datos
public PurchaseDetail Insert(PurchaseDetail purchaseDetail, string id)
{
// Guardar elemento
purchaseDetail.auditInsert(id);
_context.PurchaseDetail.Add(purchaseDetail);
_context.SaveChanges();
return(purchaseDetail);
}
public bool Purchase(PurchaseDetail detail)
{
var p = GetById(detail.ProductId);
p.Received = p.Received + detail.Quantity;
p.OnHand = p.OnHand + detail.Quantity;
return(base.Edit(p));
}
// GET: Purchase/Delete/5
public ActionResult Delete(PurchaseDetail IdtoDel)
{
var d = Entities_MVC.PurchaseDetails.Where(x => x.id == IdtoDel.id).FirstOrDefault();
Entities_MVC.PurchaseDetails.Remove(d);
Entities_MVC.SaveChanges();
return(RedirectToAction("AllPurchase"));
}
