public bool Update(string compId, IEntity entity, DbTransaction transaction) { PartnerItemXref oEntity = entity as PartnerItemXref; if (oEntity == null) { throw new InvalidValueException("Unable to cast entity object"); } Database database = ConnectionSetting.GetDatabase(Core.ApplicationContext.DataConnectionString, compId); DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.trav_tblEdPartnerItemXref_Update", UseStoredProcedure, GetCommandFromResource()); database.AddInParameter(commandWrapper, "@PartnerId", DbType.AnsiString, oEntity.PartnerId); database.AddInParameter(commandWrapper, "@OriginalPartnerId", DbType.AnsiString, oEntity.OriginalPartnerId); database.AddInParameter(commandWrapper, "@TravItemId", DbType.AnsiString, oEntity.TravItemId); database.AddInParameter(commandWrapper, "@OriginalTravItemId", DbType.AnsiString, oEntity.OriginalTravItemId); database.AddInParameter(commandWrapper, "@TravUom", DbType.AnsiString, oEntity.TravUom); database.AddInParameter(commandWrapper, "@OriginalTravUom", DbType.AnsiString, oEntity.OriginalTravUom); database.AddInParameter(commandWrapper, "@EdiUom", DbType.AnsiString, oEntity.EdiUom); database.AddInParameter(commandWrapper, "@EAN", DbType.AnsiString, oEntity.EAN); database.AddInParameter(commandWrapper, "@GTIN", DbType.AnsiString, oEntity.GTIN); database.AddInParameter(commandWrapper, "@UPC", DbType.AnsiString, oEntity.UPC); database.AddInParameter(commandWrapper, "@SKU", DbType.AnsiString, oEntity.SKU); database.AddInParameter(commandWrapper, "@BuyerCode", DbType.AnsiString, oEntity.BuyerCode); database.AddInParameter(commandWrapper, "@VendorCode", DbType.AnsiString, oEntity.VendorCode); database.AddInParameter(commandWrapper, "@InternalCode", DbType.AnsiString, oEntity.InternalCode); database.AddInParameter(commandWrapper, "@InternalCode1", DbType.AnsiString, oEntity.InternalCode1); database.AddInParameter(commandWrapper, "@InternalCode2", DbType.AnsiString, oEntity.InternalCode2); int results = 0; if (transaction != null) { results = database.ExecuteNonQuery(commandWrapper, transaction); } else { results = database.ExecuteNonQuery(commandWrapper); } oEntity.OriginalPartnerId = oEntity.PartnerId; oEntity.OriginalTravItemId = oEntity.TravItemId; oEntity.OriginalTravUom = oEntity.TravUom; oEntity.AcceptChanges(); return(Convert.ToBoolean(results)); }
public bool Delete(string compId, IEntity entity, DbTransaction transaction) { PartnerItemXref oEntity = entity as PartnerItemXref; if (oEntity == null) { throw new InvalidValueException("Unable to cast entity object"); } Database database = ConnectionSetting.GetDatabase(Core.ApplicationContext.DataConnectionString, compId); DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.trav_tblEdPartnerItemXref_Delete", UseStoredProcedure, GetCommandFromResource()); database.AddInParameter(commandWrapper, "@PartnerId", DbType.AnsiString, oEntity.PartnerId); database.AddInParameter(commandWrapper, "@TravItemId", DbType.AnsiString, oEntity.TravItemId); database.AddInParameter(commandWrapper, "@TravUom", DbType.AnsiString, oEntity.TravUom); int results = 0; if (transaction != null) { results = database.ExecuteNonQuery(commandWrapper, transaction); } else { results = database.ExecuteNonQuery(commandWrapper); } if (results == 0) { //throw new DataException("The record has been already deleted."); return(false); } return(Convert.ToBoolean(results)); }//end Delete