public int Update(PurchaseInvoiceItem purchaseInvoiceItem) { UpdateCommand.Parameters["@ID"].Value = purchaseInvoiceItem.ID; UpdateCommand.Parameters["@PurchaseInvoiceNo"].Value = purchaseInvoiceItem.PurchaseInvoiceNo; UpdateCommand.Parameters["@ReferenceNo"].Value = purchaseInvoiceItem.ReferenceNo; UpdateCommand.Parameters["@SupplierID"].Value = purchaseInvoiceItem.SupplierID; UpdateCommand.Parameters["@SupplierName"].Value = purchaseInvoiceItem.SupplierName; UpdateCommand.Parameters["@PaymentModeID"].Value = purchaseInvoiceItem.PaymentModeID; UpdateCommand.Parameters["@PaymentMode"].Value = purchaseInvoiceItem.PaymentMode; UpdateCommand.Parameters["@Total"].Value = purchaseInvoiceItem.Total; UpdateCommand.Parameters["@Discount"].Value = purchaseInvoiceItem.Discount; UpdateCommand.Parameters["@NetTotal"].Value = purchaseInvoiceItem.NetTotal; UpdateCommand.Parameters["@PurchaseInvoiceDate"].Value = purchaseInvoiceItem.PurchaseInvoiceDate; UpdateCommand.Parameters["@InventoryLocationID"].Value = purchaseInvoiceItem.InventoryLocationID; UpdateCommand.Parameters["@InventoryLocationName"].Value = purchaseInvoiceItem.InventoryLocationName; UpdateCommand.Parameters["@Username"].Value = purchaseInvoiceItem.Username; UpdateCommand.Parameters["@Status"].Value = purchaseInvoiceItem.Status; int returnValue = -1; try { UpdateCommand.Connection.Open(); returnValue = UpdateCommand.ExecuteNonQuery(); } catch (SqlException ex) { Logger.Write(ex); } finally { UpdateCommand.Connection.Close(); } return(returnValue); }
public InvoiceItemModel(PurchaseInvoiceItem item) { this.Part = item.ExistPart ? item.Part?.Name : item.Description; this.Description = item.ExistPart ? item.Description : string.Empty; this.Quantity = item.Quantity; // TODO: Where does the currency come from? var currency = "€"; this.Price = item.UnitPrice.ToString("N2", new CultureInfo("nl-BE")) + " " + currency; this.Amount = item.TotalExVat.ToString("N2", new CultureInfo("nl-BE")) + " " + currency; this.Comment = item.Comment; this.SupplierProductId = item.Part?.SupplierOfferingsWherePart?.FirstOrDefault(v => v.Supplier.Equals(item.PurchaseInvoiceWherePurchaseInvoiceItem.BilledFrom))?.SupplierProductId; }
public InvoiceItemModel(PurchaseInvoiceItem item) { this.Part = item.Part?.Name; var description = item.Description; if (string.IsNullOrEmpty(this.Part) && description == null) { description = item.InvoiceItemType.Name; } this.Description = description?.Split('\n'); this.Quantity = item.Quantity; this.Price = item.UnitPrice.ToString("N2", new CultureInfo("nl-BE")); this.Amount = item.TotalExVat.ToString("N2", new CultureInfo("nl-BE")); this.Comment = item.Comment?.Split('\n'); this.SupplierProductId = item.Part?.SupplierOfferingsWherePart?.FirstOrDefault(v => v.Supplier.Equals(item.PurchaseInvoiceWherePurchaseInvoiceItem.BilledFrom))?.SupplierProductId; }
public PurchaseInvoiceItemViewModel(IViewModelDependencies appCtx, IZetboxContext dataCtx, ViewModel parent, PurchaseInvoiceItem obj) : base(appCtx, dataCtx, parent, obj) { this.InvoiceItem = obj; }
private PurchaseInvoiceItem DataTableToEntity(DataTable dt) { PurchaseInvoiceItem purchaseInvoiceItem = new PurchaseInvoiceItem(); if (Null.IsNotNull(dt) == true && dt.Rows.Count > 0) { if (Null.IsNotNull(dt.Rows[0])) { DataRow dr = dt.Rows[0]; if (Null.IsNotNull(dr["ID"])) { purchaseInvoiceItem.ID = Convert.ToInt32(dr["ID"]); } else { purchaseInvoiceItem.ID = 0; } if (Null.IsNotNull(dr["PurchaseInvoiceNo"])) { purchaseInvoiceItem.PurchaseInvoiceNo = Convert.ToInt32(dr["PurchaseInvoiceNo"]); } else { purchaseInvoiceItem.PurchaseInvoiceNo = 0; } if (Null.IsNotNull(dr["ReferenceNo"])) { purchaseInvoiceItem.ReferenceNo = Convert.ToString(dr["ReferenceNo"]); } else { purchaseInvoiceItem.ReferenceNo = string.Empty; } if (Null.IsNotNull(dr["SupplierID"])) { purchaseInvoiceItem.SupplierID = Convert.ToInt32(dr["SupplierID"]); } else { purchaseInvoiceItem.SupplierID = 0; } if (Null.IsNotNull(dr["SupplierName"])) { purchaseInvoiceItem.SupplierName = Convert.ToString(dr["SupplierName"]); } else { purchaseInvoiceItem.SupplierName = string.Empty; } if (Null.IsNotNull(dr["PaymentModeID"])) { purchaseInvoiceItem.PaymentModeID = Convert.ToInt32(dr["PaymentModeID"]); } else { purchaseInvoiceItem.PaymentModeID = 0; } if (Null.IsNotNull(dr["PaymentMode"])) { purchaseInvoiceItem.PaymentMode = Convert.ToString(dr["PaymentMode"]); } else { purchaseInvoiceItem.PaymentMode = string.Empty; } if (Null.IsNotNull(dr["Total"])) { purchaseInvoiceItem.Total = Convert.ToDecimal(dr["Total"]); } else { purchaseInvoiceItem.Total = 0.00m; } if (Null.IsNotNull(dr["Discount"])) { purchaseInvoiceItem.Discount = Convert.ToDecimal(dr["Discount"]); } else { purchaseInvoiceItem.Discount = 0.00m; } if (Null.IsNotNull(dr["NetTotal"])) { purchaseInvoiceItem.NetTotal = Convert.ToDecimal(dr["NetTotal"]); } else { purchaseInvoiceItem.NetTotal = 0.00m; } if (Null.IsNotNull(dr["PurchaseInvoiceDate"])) { purchaseInvoiceItem.PurchaseInvoiceDate = Convert.ToDateTime(dr["PurchaseInvoiceDate"]); } else { purchaseInvoiceItem.PurchaseInvoiceDate = DateTime.Now; } if (Null.IsNotNull(dr["InventoryLocationID"])) { purchaseInvoiceItem.InventoryLocationID = Convert.ToInt32(dr["InventoryLocationID"]); } else { purchaseInvoiceItem.InventoryLocationID = 0; } if (Null.IsNotNull(dr["InventoryLocationName"])) { purchaseInvoiceItem.InventoryLocationName = Convert.ToString(dr["InventoryLocationName"]); } else { purchaseInvoiceItem.InventoryLocationName = string.Empty; } if (Null.IsNotNull(dr["Username"])) { purchaseInvoiceItem.Username = Convert.ToString(dr["Username"]); } else { purchaseInvoiceItem.Username = string.Empty; } if (Null.IsNotNull(dr["Status"])) { purchaseInvoiceItem.Status = Convert.ToString(dr["Status"]); } else { purchaseInvoiceItem.Status = string.Empty; } } } return(purchaseInvoiceItem); }