public JsonResult Update([FromBody]MaterialSBatchModel obj) { var msg = new JMessage() { Error = false }; try { var item = _context.MaterialStoreBatchGoodss.FirstOrDefault(x => x.Code == obj.Code); item.Name = obj.Name; item.ProductCode = obj.ProductCode; item.StoreId = obj.StoreId; item.Quantity = obj.Quantity; item.Unit = obj.Unit; item.Vat = obj.Vat; item.Cost = obj.Cost; item.Currency = obj.Currency; item.Barcode = obj.Barcode; item.SupplierId = obj.SupplierId; item.Madein = obj.Madein; item.Packing = obj.Packing; item.Sale = obj.Sale; item.Description = obj.Description; item.DateProduce = !string.IsNullOrEmpty(obj.DateProduce) ? DateTime.ParseExact(obj.DateProduce, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null; item.DateExpire = !string.IsNullOrEmpty(obj.DateExpire) ? DateTime.ParseExact(obj.DateExpire, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null; item.DateReiceive = !string.IsNullOrEmpty(obj.DateReiceive) ? DateTime.ParseExact(obj.DateReiceive, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null; item.UpdatedBy = ESEIM.AppContext.UserName; item.UpdatedTime = DateTime.Now; //double? total = 0; //if (obj.Quantity != null && obj.Cost != null) //{ // total = obj.Quantity * obj.Cost; // if (obj.Sale != null) // { // total = (total * obj.Sale) / 100; // } // if (obj.Vat != null) // { // total = (total * obj.Vat) / 100; // } //} item.Total = obj.Total; _context.MaterialStoreBatchGoodss.Update(item); _context.SaveChanges(); msg.Title = "Cập nhật lô hàng thành công"; } catch (Exception ex) { msg.Error = true; msg.Title = "Cập nhật lô hàng lỗi!"; msg.Object = ex; } return Json(msg); }
public JsonResult Insert([FromBody]MaterialSBatchModel obj) { var msg = new JMessage() { Error = false, Title = "" }; try { var query = from a in _context.MaterialStoreBatchGoodss where a.Code == obj.Code select a; if (query.Count() == 0) { var temp = new MaterialStoreBatchGoods { Code = obj.Code, Name = obj.Name, ProductCode = obj.ProductCode, StoreId = obj.StoreId, Quantity = obj.Quantity, Unit = obj.Unit, Vat = obj.Vat, Cost = obj.Cost, Currency = obj.Currency, Barcode = obj.Barcode, SupplierId = obj.SupplierId, Madein = obj.Madein, Packing = obj.Packing, Sale = obj.Sale, DateProduce = !string.IsNullOrEmpty(obj.DateProduce) ? DateTime.ParseExact(obj.DateProduce, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null, DateExpire = !string.IsNullOrEmpty(obj.DateExpire) ? DateTime.ParseExact(obj.DateExpire, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null, DateReiceive = !string.IsNullOrEmpty(obj.DateReiceive) ? DateTime.ParseExact(obj.DateReiceive, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null, Description = obj.Description, CreatedBy = ESEIM.AppContext.UserName, CreatedTime = DateTime.Now }; //double? total = 0; //if (obj.Quantity != null && obj.Cost != null) //{ // total = obj.Quantity * obj.Cost; // if (obj.Sale != null) // { // total = (total * obj.Sale) / 100; // } // if (obj.Vat != null) // { // total = (total * obj.Vat) / 100; // } //} temp.Total = obj.Total; _context.MaterialStoreBatchGoodss.Add(temp); _context.SaveChanges(); msg.Title = "Thêm lô hàng thành công"; } else { msg.Error = true; msg.Title = "Mã lô hàng đã tồn tại"; //return msg; } return Json(msg); //var temp = new MaterialStoreBatchGoods //{ // Code = obj.Code, // Name = obj.Name, // ProductCode = obj.ProductCode, // StoreId = obj.StoreId, // Quantity = obj.Quantity, // Unit = obj.Unit, // Vat = obj.Vat, // Cost = obj.Cost, // Currency = obj.Currency, // Barcode = obj.Barcode, // SupplierId = obj.SupplierId, // Madein = obj.Madein, // Packing = obj.Packing, // Sale = obj.Sale, // DateProduce = !string.IsNullOrEmpty(obj.DateProduce) ? DateTime.ParseExact(obj.DateProduce, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null, // DateExpire = !string.IsNullOrEmpty(obj.DateExpire) ? DateTime.ParseExact(obj.DateExpire, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null, // DateReiceive = !string.IsNullOrEmpty(obj.DateReiceive) ? DateTime.ParseExact(obj.DateReiceive, "dd/MM/yyyy", CultureInfo.InvariantCulture) : (DateTime?)null, // Description = obj.Description, // CreatedBy = ESEIM.AppContext.UserName, // CreatedTime = DateTime.Now //}; //double? total = 0; //if (obj.Quantity != null && obj.Cost != null) //{ // total = obj.Quantity * obj.Cost; // if (obj.Sale != null) // { // total = (total * obj.Sale) / 100; // } // if (obj.Vat != null) // { // total = (total * obj.Vat) / 100; // } //} //temp.Total = total; //_context.MaterialStoreBatchGoodss.Add(temp); //_context.SaveChanges(); //msg.Title = "Thêm lô hàng thành công"; } catch (Exception ex) { msg.Error = true; msg.Title = "Thêm lô hàng lỗi!"; } return Json(msg); }