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