public int Update(InventoryTransferItem inventoryTransferItem)
{
UpdateCommand.Parameters["@ID"].Value = inventoryTransferItem.ID;
UpdateCommand.Parameters["@InventoryTransferNo"].Value = inventoryTransferItem.InventoryTransferNo;
UpdateCommand.Parameters["@FromInventoryLocationID"].Value = inventoryTransferItem.FromInventoryLocationID;
UpdateCommand.Parameters["@FromInventoryLocationName"].Value = inventoryTransferItem.FromInventoryLocationName;
UpdateCommand.Parameters["@ToInventoryLocationID"].Value = inventoryTransferItem.ToInventoryLocationID;
UpdateCommand.Parameters["@ToInventoryLocationName"].Value = inventoryTransferItem.ToInventoryLocationName;
UpdateCommand.Parameters["@Total"].Value = inventoryTransferItem.Total;
UpdateCommand.Parameters["@Discount"].Value = inventoryTransferItem.Discount;
UpdateCommand.Parameters["@NetTotal"].Value = inventoryTransferItem.NetTotal;
UpdateCommand.Parameters["@InventoryTransferDate"].Value = inventoryTransferItem.InventoryTransferDate;
UpdateCommand.Parameters["@Username"].Value = inventoryTransferItem.Username;
UpdateCommand.Parameters["@Status"].Value = inventoryTransferItem.Status;
int returnValue = -1;
try
{
UpdateCommand.Connection.Open();
returnValue = UpdateCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
UpdateCommand.Connection.Close();
}
return(returnValue);
}
private InventoryTransferItem DataTableToEntity(DataTable dt)
{
InventoryTransferItem inventoryTransferItem = new InventoryTransferItem();
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"]))
{
inventoryTransferItem.ID = Convert.ToInt32(dr["ID"]);
}
else
{
inventoryTransferItem.ID = 0;
}
if (Null.IsNotNull(dr["InventoryTransferNo"]))
{
inventoryTransferItem.InventoryTransferNo = Convert.ToInt32(dr["InventoryTransferNo"]);
}
else
{
inventoryTransferItem.InventoryTransferNo = 0;
}
if (Null.IsNotNull(dr["FromInventoryLocationID"]))
{
inventoryTransferItem.FromInventoryLocationID = Convert.ToInt32(dr["FromInventoryLocationID"]);
}
else
{
inventoryTransferItem.FromInventoryLocationID = 0;
}
if (Null.IsNotNull(dr["FromInventoryLocationName"]))
{
inventoryTransferItem.FromInventoryLocationName = Convert.ToString(dr["FromInventoryLocationName"]);
}
else
{
inventoryTransferItem.FromInventoryLocationName = string.Empty;
}
if (Null.IsNotNull(dr["ToInventoryLocationID"]))
{
inventoryTransferItem.ToInventoryLocationID = Convert.ToInt32(dr["ToInventoryLocationID"]);
}
else
{
inventoryTransferItem.ToInventoryLocationID = 0;
}
if (Null.IsNotNull(dr["ToInventoryLocationName"]))
{
inventoryTransferItem.ToInventoryLocationName = Convert.ToString(dr["ToInventoryLocationName"]);
}
else
{
inventoryTransferItem.ToInventoryLocationName = string.Empty;
}
if (Null.IsNotNull(dr["Total"]))
{
inventoryTransferItem.Total = Convert.ToDecimal(dr["Total"]);
}
else
{
inventoryTransferItem.Total = 0.00m;
}
if (Null.IsNotNull(dr["Discount"]))
{
inventoryTransferItem.Discount = Convert.ToDecimal(dr["Discount"]);
}
else
{
inventoryTransferItem.Discount = 0.00m;
}
if (Null.IsNotNull(dr["NetTotal"]))
{
inventoryTransferItem.NetTotal = Convert.ToDecimal(dr["NetTotal"]);
}
else
{
inventoryTransferItem.NetTotal = 0.00m;
}
if (Null.IsNotNull(dr["InventoryTransferDate"]))
{
inventoryTransferItem.InventoryTransferDate = Convert.ToDateTime(dr["InventoryTransferDate"]);
}
else
{
inventoryTransferItem.InventoryTransferDate = DateTime.Now;
}
if (Null.IsNotNull(dr["Username"]))
{
inventoryTransferItem.Username = Convert.ToString(dr["Username"]);
}
else
{
inventoryTransferItem.Username = string.Empty;
}
if (Null.IsNotNull(dr["Status"]))
{
inventoryTransferItem.Status = Convert.ToString(dr["Status"]);
}
else
{
inventoryTransferItem.Status = string.Empty;
}
}
}
return(inventoryTransferItem);
}
