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