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
