public virtual AuditLog InsertAuditLog(AuditLog entity) { AuditLog other = new AuditLog(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into AuditLog ( [ActionDate] ,[CustomerID] ,[UpdatedCustomerID] ,[OrderNumber] ,[Description] ,[Details] ,[PagePath] ,[AuditGroup] ) Values ( @ActionDate , @CustomerID , @UpdatedCustomerID , @OrderNumber , @Description , @Details , @PagePath , @AuditGroup ); Select scope_identity()" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@AuditLogID", entity.AuditLogId) , new SqlParameter("@ActionDate", entity.ActionDate) , new SqlParameter("@CustomerID", entity.CustomerId) , new SqlParameter("@UpdatedCustomerID", entity.UpdatedCustomerId) , new SqlParameter("@OrderNumber", entity.OrderNumber) , new SqlParameter("@Description", entity.Description) , new SqlParameter("@Details", entity.Details) , new SqlParameter("@PagePath", entity.PagePath) , new SqlParameter("@AuditGroup", entity.AuditGroup) }; 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(GetAuditLog(Convert.ToInt32(identity))); } return(entity); }
public virtual AuditLog UpdateAuditLog(AuditLog entity) { if (entity.IsTransient()) { return(entity); } AuditLog other = GetAuditLog(entity.AuditLogId); if (entity.Equals(other)) { return(entity); } string sql = @"Update AuditLog set [ActionDate]=@ActionDate , [CustomerID]=@CustomerID , [UpdatedCustomerID]=@UpdatedCustomerID , [OrderNumber]=@OrderNumber , [Description]=@Description , [Details]=@Details , [PagePath]=@PagePath , [AuditGroup]=@AuditGroup where AuditLogID=@AuditLogID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@AuditLogID", entity.AuditLogId) , new SqlParameter("@ActionDate", entity.ActionDate) , new SqlParameter("@CustomerID", entity.CustomerId) , new SqlParameter("@UpdatedCustomerID", entity.UpdatedCustomerId) , new SqlParameter("@OrderNumber", entity.OrderNumber) , new SqlParameter("@Description", entity.Description) , new SqlParameter("@Details", entity.Details) , new SqlParameter("@PagePath", entity.PagePath) , new SqlParameter("@AuditGroup", entity.AuditGroup) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetAuditLog(entity.AuditLogId)); }