public virtual DocumentAffiliate InsertDocumentAffiliate(DocumentAffiliate entity)
{
DocumentAffiliate other = new DocumentAffiliate();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into DocumentAffiliate ( [DocumentID]
,[AffiliateID]
,[CreatedOn] )
Values
( @DocumentID
, @AffiliateID
, @CreatedOn );
Select scope_identity()" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@DocumentID", entity.DocumentId)
, new SqlParameter("@AffiliateID", entity.AffiliateId)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
};
var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray);
if (identity == DBNull.Value)
{
throw new DataException("Identity column was null as a result of the insert operation.");
}
return(GetDocumentAffiliate(Convert.ToInt32(identity)));
}
return(entity);
}
public virtual DocumentAffiliate DocumentAffiliateFromDataRow(DataRow dr)
{
if (dr == null)
{
return(null);
}
DocumentAffiliate entity = new DocumentAffiliate();
entity.DocumentId = (System.Int32)dr["DocumentID"];
entity.AffiliateId = (System.Int32)dr["AffiliateID"];
entity.CreatedOn = (System.DateTime)dr["CreatedOn"];
return(entity);
}
public virtual DocumentAffiliate UpdateDocumentAffiliate(DocumentAffiliate entity)
{
if (entity.IsTransient())
{
return(entity);
}
DocumentAffiliate other = GetDocumentAffiliate(entity.DocumentId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update DocumentAffiliate set [AffiliateID]=@AffiliateID
, [CreatedOn]=@CreatedOn
where DocumentID=@DocumentID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@DocumentID", entity.DocumentId)
, new SqlParameter("@AffiliateID", entity.AffiliateId)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetDocumentAffiliate(entity.DocumentId));
}
public DocumentAffiliate InsertDocumentAffiliate(DocumentAffiliate entity)
{
return(_iDocumentAffiliateRepository.InsertDocumentAffiliate(entity));
}
public DocumentAffiliate UpdateDocumentAffiliate(DocumentAffiliate entity)
{
return(_iDocumentAffiliateRepository.UpdateDocumentAffiliate(entity));
}
public virtual DocumentAffiliate DeleteDocumentAffiliate(DocumentAffiliate entity)
{
this.DeleteDocumentAffiliate(entity.DocumentId);
return(entity);
}
