private static VendorPO LoadOneRecord(DataTable dt) { VendorPO retVal = new VendorPO(); if (dt != null) { foreach (DataRow dr in dt.Rows) { retVal = (Load(dr)); } } return(retVal); }
public void UpdateVendorPO(VendorPO _VendorPO) { using (CustomSqlConnection connection = new CustomSqlConnection()) { using (SqlCommand cmd = new SqlCommand("sp_UpdateVendorPO", connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new CustomSqlParameter("id_PurchOrder", SqlDbType.UniqueIdentifier, _VendorPO.id_PurchOrder)); cmd.Parameters.Add(new CustomSqlParameter("PurchOrderStatus", SqlDbType.NVarChar, _VendorPO.PurchOrderStatus)); cmd.Parameters.Add(new CustomSqlParameter("PurchDate", SqlDbType.DateTime, _VendorPO.PurchDate)); cmd.Parameters.Add(new CustomSqlParameter("PODeliveryDate", SqlDbType.DateTime, _VendorPO.PODeliveryDate)); cmd.ExecuteNonQuery(); } } }
private static VendorPO Load(DataRow dr) { VendorPO retVal = new VendorPO { id_PurchOrder = dr["id_PurchOrder"].EnsureGuid(), PurchOrderCode = dr["PurchOrderCode"].EnsureString(), VendCode = dr["VendCode"].EnsureString(), PurchDate = dr["PurchDate"].EnsureDate(), WarehouseCode = dr["WarehouseCode"].EnsureString(), PurchOrdersequential = dr["PurchOrdersequential"].EnsureInt(), PurchOrderStatus = dr["PurchOrderStatus"].EnsureString(), VendorEmail = dr["VendorEmail"].EnsureString() }; return(retVal); }